Hello My P&L shows a total of $1,059,400.41, while the Sales by Customer Summary report shows $943,897.55. can you tell me why the difference in amount is

I can help you understand the difference between the total amounts shown in your Profit and Loss (P&L) statement and your Sales by Customer Summary Report in QuickBooks Online (QBO), @debbie165.

There are a few reasons why there's a difference in the total amounts of those two reports. Below are the following facts to consider:

• Mismatched date range
• Different accounting method
• Incorrect sales account assignments
•  Inclusion of non-item transactions in the P&L report
• Transaction damage in the company data file.

To ensure accurate results, make sure to match the date range and accounting method of the reports by following the steps below:

1. Go to Reports, then select the report that you want to compare.
2. From the Dates drop-down, choose All.
3. Set the report basis to Accrual, then select Run Report.

The following steps should help correct the differences between the Profit & Loss and Sales by Customer Summary report totals:

1. Confirm that the reports have the same date range and basis.
2. Make sure the items point to the correct accounts.
3. Check for transactions without items.
4. Compare the detailed reports line by line to find differences.

 Additionally, I am providing this article on how to export your reports to Excel if you would like to use your reports outside of QuickBooks: Export your reports to Excel from QuickBooks Online.

We're just one post away if you need additional assistance in managing your business reports in QBO. We're here to assist you 24/7.