Skip to main content
June 25, 2022
Question

Monthly and YTD figures on the Sales Graph and the P&L Income figure on the dashboard do not match by more than 30%. Why?

  • June 25, 2022
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

June 25, 2022

Hello there, @sales268.

 

Thanks for your interest in the QuickBooks Community. I appreciate you providing specific information about your concern. With this, I'll make sure to go over how reports work in QuickBooks Online.

 

A significant difference between the Profit & Loss and Sales reports could be due to one or more issues, including, but not restricted to, the following:

 

  • The date ranges of the reports do not match.
  • The accounting bases for the reports do not correspond.
  • The sales items point to the wrong sales accounts.
  • Transactions that don't use items are included in the P&L report (e.g., the Expense Tab on a bill or a journal entry).
  • In the company data file, there is a list of transaction damage.

 

QuickBooks lets you customize the Report date range, allowing you to choose the dates the report covers and display detailed data. With that, the following steps should assist in resolving the gap between the Profit and Loss and Sales reports:

 

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

 

Moreover, the amounts on your dashboard's Sales graph are based on the sales transactions in your account for the specified period. This excludes journal entries posted to your sales accounts and calculated sales taxes.

 

In addition, you can use these articles to learn more about adjusting the Profit and Loss summary and other reports in the program:

 

 

I'm always up for assistance, sales268. Let me know if you have any other questions or concerns. I'll make sure you're taken care of. Have a great weekend!