Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowThe "Profit & Loss by Job" report (any job-related report, really) does not work. When will this be fixed?
For example, my "Profit & Loss by Job" report shows much of my COGS, and all of my non-inventory COGS, under "No sales rep" even though every transaction is associated with a job that has a sales rep.
That the data is there, and correct, is easily verified by drilling down / clicking through from the report; it's just the report that is not correct.
All of the "by Job" reports, no matter how they are sorted (by Rep, or Customer, etc.) have similar anomalies. (Nevermind that the revenue numbers don't match the income statement, which don't match the sales reports... that's a rant for a different post.)
For our business, the "by Job" reports would be the most useful set of reports if only they'd work. Besides helping us to understand profitability by customer/job, we (would if it worked) use this report to calculated sales commissions.
Is this a known defect? Is there an estimate of when this will be repaired? Has anyone devised work-arounds to properly report cost by job?
The report in your picture is not a P&L by Job, but a P&L by rep.
Normally the COGS will appear in the correct column, unless that is you sell your inventory before you buy it, and in that case the COGS is recorded not on your sales, but on your subsequent purchases.
If you quickZoom on the offending COGS amounts, what type of transactions appear on the resulting detail report?
Yes, the picture I showed happens to be set so that "Show Columns" is by Rep, but the report generated was the P&L by Job, and shows similar errors when left at its default column setting of Customer Job.
As mentioned in my original post, drilling down (by Quick Zoom or any other route) into individual transactions shows them to be coded correctly: they are associated with a Customer:Job, that Job has a Sales Rep assigned, they are assigned to the correct G/L code, etc.
Quickzoom the Total field shows a transaction list:
and quickzoom on any of those transactions shows it coded properly:
So... the transaction is correct, the detail report is correct, but the P&L view is not correct as far as I can tell.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here