cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
accounts-ketonco
Level 1

I get a different sales figure from the amount in the profit & loss account when I run a sales report, what could be the issue?

 
1 Comment 1
MichaelaS
QuickBooks Team

I get a different sales figure from the amount in the profit & loss account when I run a sales report, what could be the issue?

Let's determine the steps to correct the discrepancies, Keton.

 

There are various reasons for the difference in amounts between the Profit & Loss and Sales reports. Refer to the following:

 

  • The date ranges of the reports don't match.
  • Both reports use different accounting methods.
  • The sales items point to the incorrect sales accounts.
  • The P&L report includes transactions that don't use items, such as expenses recorded on bills or journal entries.

 

To fix this, start by customizing each report and verifying the date ranges. Here's how:

 

  1. On each report, select Customize report.
  2. From the Dates dropdown, select All.
  3. Set the report basis to Accrual, then select OK.
  4. Check both reports and make sure they match.

 

Next, ensure that the items are in the correct accounts. Refer to the steps below:

 

  1. From the Lists menu, select Item List.
  2. In the Item List, right-click anywhere and select Customize Columns.
  3. Make sure to include the Account and Cost Account columns.
  4. Check the accounts for each sales item.
  5. Correct all items that have the wrong accounts.
  6. Check the reports.

 

If there is still a discrepancy in the income amount between the two reports, continue to Steps 3 and 5 in this article: Profit and Loss report does not match a sales report. The article is from the US version, yet the information applies to any region.

 

You may check this article to learn how to save your report modifications: Memorise reports in QuickBooks Online.

 

Don't hesitate to let us know whenever you have other questions about financial concerns. We'll be around to help.