Income by Customer Detail Report

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. 

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?

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:

1. In QBDT, go to the Reports menu at the top.
2. In the drop-down, select Jobs, Time & Mileage, then Job Estimates vs. Actuals Detail.
3. 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.

Unfortunately, the Job Estimates vs. Actual Detail shows zero across the board. I checked with multiple customers. 

Allow me to help and provide options when it comes to running reports, laweindustries.

The Job Estimates vs. Actual Detail will only show data if you created invoices from estimates. This is the reason why it's giving you zero amounts since the transactions are created from the billable expenses and were not converted from estimates. 

I opened the Income by Customer Detail report and the Debit column is showing the actual amount instead of the average.

You'll want to use the verify and rebuild utility tool. This will help you resolve possible data issues that might have caused the program to use averages instead of the actual cost. Here's how;

1. Go to the File menu, hover over Utilities, and then select Rebuild Data.
2. Click OK and follow the onscreen steps to save a backup.
3. Let the tool repair your file. It may take some time. QuickBooks may seem stuck, but as long as you can move your mouse, the tool is working.
4. Choose OK when the process is completed.
5. Go back to the File menu, hover over Utilities, and then select Verify Data.
6. Let the tool check your file for data issues.

If there's an issue in your company file, select Rebuild Now. Additional details and other options to resolve data issues are discussed here: Fix Data Damage on your QuickBooks Desktop company file.

Once done, go back to the report and check if the Debit column is now giving you the actual cost. 

Alternatively, you can use run the Job Profitability Detail report. It has an Actual Cost, Actual Revenue, Amount Difference, and Percentage Difference columns so it's easier for you to know much you earned for from a customer or job. Here's how:

1. Go to the Reports menu, proceed to Jobs, Time, and Mileage, and then choose Job Profitability Details. 
2. Select the name of the customer and click OK.

Please note that QuickBooks is using also using the actual amount in this report and not the averages. Allow me to share this article for extra reference: Customize Customer, Job, and Sales Reports in QuickBooks Desktop 

Don't hesitate to let me know if you're able to get the data you need for the costs associated to your customers. You can also visit us again if you need anything else. 

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?