Skip to main content
V
Von-1
January 17, 2024
Question

Sales dashboard incorrect

  • January 17, 2024
  • 1 reply
  • 0 views

My sales dashboard figure is incorrect. It is $757.90 more than the sales amount in the profit and loss report for the same period. The $757.90 is for an invoice amount paid by a customer twice in error. It was allocated as a deposit to accounts receivable and has now been refunded and accou8nts receivable now back to $0. 

Why does the dposit of $757.90 get included in the sales dashboard when it is not applied to an invoice and has been refunded?

1 reply

I
IntuitSheila
January 17, 2024

Hi Von-1,

 

Thanks for your post in the Community!

 

The Sales dashboard in QuickBooks Online will display all transaction under uncategorised income accounts and deposits. As compare to the Profit and loss report this will show transactions using income and expense accounts.

 

I would recommend checking the following to compare the sales dashboard and the P&L report:

 

  • 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).
  • List or transaction damage in the company data file.

We can also run a report like your Transaction List by date or the Transaction List by Customer and filter it to show All sales, invoices and other income transaction.

 

Also 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.

 

Post again in the Community if you have further concerns. I am around to help you.

V
Von-1Author
January 17, 2024

The date range is set to this financial year and on a cash basis which is the same as the P&L report.

As the $757.90 is a deposit for a customer payment made in error it was refunded to the same customer 2 days later. I don't understand why then it shows in the sales dashboard?

I
IntuitSheila
January 17, 2024

Thanks for checking out the information, Von-1.

 

There is no way to change how that Dashboard Widget works, it will really include any deposits created, so I would advise using the P&L or a different Sales report that best fits how you record your sales.

 

  • Please make sure that the two reports are of the same period.
  • Run the Profit and Loss report and Sales by Customer Detail/Summary report and check the Accounting method and report period.
  • Make sure that the GST code of the transaction is not set to Out of Scope (Sales) instead change the Amounts are Out of Scope of GST.

I would recommend contacting our Customer Care Team to help check your transactions and reports in QuickBooks Online. 

 

Drop by again in the Community if you have other concerns.

Terms & ConditionsAccessibility statement