Finding transactions without customer/job info

Hi, all. How can I find all transactions that do not have a customer/job assigned to them? The totals on my "P&L by Job" report don't match the totals on the "P&L Summary" report, so I know some transactions are missing customer/job info, but I don't know how to find them. The "P&L by Job" report simply omits these transactions rather than including a column for transactions without customer/job info. I'm using QB Pro 2004. Thanks in advance.

LW

Reply to
LW
Loading thread data ...

That seems an unusual requirement. There are many transactions that do not have a customer/job "assigned" - most expenses for example, payroll, journal entries for depreciation. Can you be more specific about what you're trying to find, and/or why?

My version of QB doesn't have a "P&L Summary", so I'm guessing you mean a "Standard" P&L.

One procedure: Modify the P&L By Job to show only one column, Totals Only. Compare this with the standard P&L to identify specific accounts you want to investigate. Display the standard P&L and double-click an account to "drill down" to the Transaction Detail; modify this report to sort by Name. Now all the transactions with no data in the Name field will be at the top of the report, Customers next, followed by those with Vendor, Employee, and Other names.

Reply to
!-!

Hi. Thanks for your reply.

In our system, we include customer/job info on nearly all transactions. G&A expenses are assigned to a customer/job called G&A. Payroll is tracked by job. My goal is to find the transactions in which the customer/job field was left blank, so these transactions can be assigned to the appropriate job, so the jobs accurately reflect all costs. Yes, by P&L Summary I meant the standard P&L.

I had tried drilling down from the standard P&L and using the name field (as well as running the P&L detail and using the name field), but unfortunately, if you leave the customer/job field blank in a transaction, QB populates the name field of the P&L report with another name, e.g. the vendor name. Because of this, you can't sort on the name field and bring all the missing customer/job transactions together. Yes, I can review that column of the report to look for transactions where the name is a vendor rather than a customer/job, but this company has a huge number of transactions, so it's a slow process.

I was hoping someone knew of a direct way to isolate the transactions without customer/job info, but maybe there isn't any way. In searching for an answer to this before I posted the question, I noticed a similar question had been asked in another forum, and no one had ever replied.

Linda

!-! wrote:

Reply to
LW

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.