Question

Income by Customer Detail Report

Forum|Forum|3 years ago
August 24, 2022
2 replies
2 views

When I use the income by customer summary report, and drill down to look at specific customers, the Debit column, which is out cost, does not match the actual cost given to the customer. It is giving the average cost instead. How do I get the report to reflect the true/actual cost, rather than an average, or is there another report that does not automatically assign the average as the debit/actual cost. (Job Prof. Summary also is assigning the average rather than the actual.)

QuickBooks Enterprise Suite

DivinaMercy_N

Moderator

Hi there, @laweindustries. I'm here to ensure you'll be able to see the actual cost when running the Customer Detail report in QuickBooks Desktop (QBDT).

To fix the report, you can switch the accounting basis to cash. To do so, simply select the Cash radio button located at the upper left part of the page. Please see the screenshot for visual reference:

For more information, feel free to check this article: Differentiate Cash and Accrual basis.

Additionally, to give further guidance in managing your reports, you can visit this link that includes detailed instructions for modifying them: Customize reports in QuickBooks Desktop.

Please let me know updates on how this goes. I'd appreciate any details you can add. If you have further questions about managing reports in QuickBooks, don't hesitate to leave a reply. I'm just around the corner and waiting for your response. Have a delightful day.

L

laweindustriesAuthor

Thank you for the insight, however, since we are on an accrual basis, this toggle to Cash does not work. If the invoices are not yet paid, they do not show up when I toggle to cash, it only shows invoices that have been paid in the date range I give, regardless of invoice date.

For example if a customer makes a purchase on August 25, and are on 30 day terms, when I look at the report in cash mode for August's invoices (say on September 1st), that invoice is not there yet because they have not paid yet, and if I use the Income by Customer Detail Report to look at the Balance in Accrual mode, the Debit column is using the average so the calculation is inaccurate.

The end goal is to be able to take the sale price, minus the actual cost (already paid to the vendor, not the average), and get the real difference/balance. Is this even possible?

AlcaeusF

Level 14

Thanks for getting back to us, @laweindustries.

Allow me to chime in and help ensure you can pull up the report that you need in QuickBooks Desktop (QBDT).

You can run the Job Estimates vs. Actuals report instead. This will display detailed costs and revenues for the customer or job you'll select. It compares estimated and actual costs and estimated to actual revenue for each job that you invoiced.

Estimated Cost comes from the Cost side while the Estimated Revenue comes from the Sales side.

Here's how to pull up the report:

In QBDT, go to the Reports menu at the top.
In the drop-down, select Jobs, Time & Mileage, then Job Estimates vs. Actuals Detail.
Choose the customer's name in the Filter Report by Job pop-up.

I'm also adding a guide that covers all available reports can be accessed through the QuickBooks Reports menu: Understand reports.

For more tips and other resources, I recommend visiting our website for future reference: Self-help articles.

Please let me know if you have follow-up questions about reports or anything else QuickBooks. I'm always here to help. Take care.

O

Obey 12

I would like to create a report that shows the customer information as well as phone and email for all customers that have not purchased in the past 12 months?

Sign up

Login with SSO

Let's get you signed in

Login with SSO

Scanning file for viruses.

This file cannot be downloaded