Report Transactions not Assigned a Job

[roland.garton]

I may have asked this question in the past, but maybe newer versions of QuickBooks have some features to provide what I need. I need a report that lists all transactions NOT assigned a Customer:Job. Our bookkeepers are required to assign a job to every transaction, but they forget sometimes, so I need a report to quickly check for any such omissions.

Any suggestions?

[Wartrace]

It is difficult because you the reports don't have the option of selecting Name OR Job, only name. What you could do is run a custom transaction detail report by name. The transactions that do not have a job assigned to them will appear as just a name whereas the ones WITH jobs assigned will have the name:job

If you wanted to you could export the report to excel and sort the fields based on which names do not contain a ":" and you would have a list of transactions without jobs assigned to them.

[roland.garton]

Even sneakier: QB by default lists the customer or customer:job in the Name column of standard reports. But if you filter by name, QB changes the report to display the vendor in the Name Column.

What I do now, as a workaround, is to export the list of jobs to Excel and export all transactions to Excel, then do vlookup()s in excel to identify transactions whose Name is not in the list of customer:jobs. Your solution is simpler but will not find transactions assigned to a customer without sub-jobs and therefore without the colon in the Name column.

I was hoping for something that I could do within QuickBooks, to make the double-check as simple as running a QuickBooks report. All it would take is a NOT filter in QB, but they ignore my requests for this feature. In the meantime, any other ideas would be welcome.