Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
K
K2RB
February 9, 2019
Question

Sales Numbers on Dashboard

  • February 9, 2019
  • 1 reply
  • 24 views

On my Dashboard, the Sales Per Month (total YTD), does not equal the Sales Value in the Profit and Loss calculation.  The P&L calculation value agrees with my Profit and Loss Report.  How are the two values determined and why aren't they equal?  I am on an accrual basis.  Thanks.

 

1 reply

Angelyn_T
Angelyn_TModerator
Moderator
February 9, 2019

Hi there, @K2RB.

 

Thank you for posting here in the Community. I'm here to help share information about the Sales graph and sales value in the Profit and Loss calculation shown in the Dashboard.

 

The amounts on your Sales graph on the dashboard are based on the sales transactions in your account for the period specified. This will not include journal entries posted to your sales accounts and the calculated sales taxes.

 

To double-check the amount shown on your sales graph, make sure that you filter the report date correctly by clicking the This Month drop-down arrow. Once done, run the Sales by Customer Summary report to check the details of your Sales graph.

  1. Click Reports at the left pane.
  2. Look for Sales by Customer Summary in the search field.
  3. Change the Report period at the top.
  4. Click Run Report.

A noticeable discrepancy between the Profit & Loss and a Sales reports may be due to one or more issues, including, but not limited to the following:

  • The date ranges of the reports do not match.
  • The accounting bases of the reports do not match.
  • Sales items point to incorrect sales accounts.
  • The P&L report includes transactions that do not use items (e.g., the Expense Tab on a bill or a journal entry).

The following steps should help correct discrepancy between Profit and Loss and Sales report:

  • 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 detail reports line by line to find differences.

If you need further assistance, you may get in touch with our QuickBooks Support Team.

 

Let me know if you have any other questions about reports in QuikBooks Online (QBO), I'm always here to help you. Have a great day ahead!

H
haen6404
May 7, 2019

@Angelyn_T I'm sorry, I'm still not 100% understanding -- does the Sales chart on the dashboard include open invoices that have not been paid? Also, does it include estimates or delayed charges that have not been added to an invoice yet?

 

Thank you! These are the two areas I need clarification on.

 

SophiaAnnL
SophiaAnnL
Level 5
May 7, 2019

I'm here to discuss the sales graph flow in QBO, haen6404.

 

The sales graph you see in the Dashboard only displays the posting transactions. That being said, it does not include estimates. Since you mentioned above that you're on accrual basis, the open invoices will also be included there.

 

On the other hand, the delayed charges will show if they have been added to your invoices. Lastly, deposits (not payments) that were posted directly to an income account will not be added on the sales graph.

 

I hope these cleared things out for you. If you have further questions, just leave a reply.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement