Creating a report using columns NUM or REF as a filter.

celittle

I have been using Quicken for a long time (since it was Quicken no year). I use separate accounts to track expenses that I have for work and other ventures to seperate each expense report I use NUM or REF column to identify the expense report (IE 1, 2,..) and when I get reimbursed I use the same REF number to tie the payment to the expense report. I have always been able to get a report using the CLR column to only get the transactions in a particular expense report. But they are getting bigger and harder to do that.
I'm looking for a way to create a report that can filter using the REF or NUM column in an account to create that report there-by only have those transactions for a particular expense report.
Thanks

NotACPA

I couldn't find a way to filter on those columns either.

BUT, have you considered creating a "Receivables" asset/banking type account and using that account as the category for your expenses to be reimbursed?  That way, those expenses will still show as money  owed to you.

Then, when you get paid you show the deposit as coming  from the Receivables account.

This also gets those items out of your Income/Expense reports since they're truly neither.

celittle

Interesting I will look into that. Thanks for the comment.

Rocket J Squirrel

You can use the Find command to find certain Num or Ref entries, but that's not as good as a report you can manipulate.

volvogirl

You can also try using TAGS to identify each thing.  You can sort and filter reports by Tag.  

celittle

I already use the tags to organize the expense report (Meals, Travel etc.)
Thanks for the comment

Rocket J Squirrel

A transaction (or split line) can have multiple tags separated by colons.