Dashboard Figures

semps · ‎July 20, 2021

Any idea why my Dashboard "Sales" total is higher than my Profit & Loss Income figure. It's out by almost £30k, so not really even close

Ethel_A · ‎July 20, 2021

Thank you for joining us here in the Community, @semps.

I understand how important it is for us to understand the figures showing in our QuickBooks Desktop account. Let me help you understand what is showing on your Dashboard and Profit and Loss page.

The figures that you can see in the Dashboard "Sales" shows only the sales generated by Invoices and Sales Receipt, While the Profit and Loss report all types of transactions which includes Journal Entry and Bank Deposit directed to the income account. That is why there is a big difference between the figures that you can see.

Here are also the common reasons why they have different amounts:

Date ranges don't match.
Accounting bases match.
Sales items added to incorrect sales accounts.
P&L includes transactions that do not use items, for example, the Expense Tab on a bill or a journal entry.

Additionally, I recommend checking an Introduction To The Home Dashboard to know how to manage the page so you'll have a real-time overview of your company finances.

You can always reach out to me if you need anything else about understanding the Dashboard. I'm here for you. Have a great day.

View solution in original post

Ethel_A · ‎July 20, 2021

Thank you for joining us here in the Community, @semps.

I understand how important it is for us to understand the figures showing in our QuickBooks Desktop account. Let me help you understand what is showing on your Dashboard and Profit and Loss page.

The figures that you can see in the Dashboard "Sales" shows only the sales generated by Invoices and Sales Receipt, While the Profit and Loss report all types of transactions which includes Journal Entry and Bank Deposit directed to the income account. That is why there is a big difference between the figures that you can see.

Here are also the common reasons why they have different amounts:

Date ranges don't match.
Accounting bases match.
Sales items added to incorrect sales accounts.
P&L includes transactions that do not use items, for example, the Expense Tab on a bill or a journal entry.

Additionally, I recommend checking an Introduction To The Home Dashboard to know how to manage the page so you'll have a real-time overview of your company finances.

You can always reach out to me if you need anything else about understanding the Dashboard. I'm here for you. Have a great day.

JamesW2 · ‎January 05, 2023

I have just discovered that the dashboard includes in sales and purchase items that are for example Directors loan account transactions, this is driven by the VAT code used for example No VAT (sales) goes into sales.

Quickbooks - this is creating very misleading figures on the dashboard , dashboard should be driven by underlying categories not VAT codes please fix it asap.

Ashleigh1 · ‎January 05, 2023

Hello JamesW2, thanks for posting on this thread, so on the Dashboard Profit and Loss it will include Paid and Unpaid Invoices, sales receipts, and Deposits with a Sales/Income account linked. It won't show Unlinked payments (pre-payments) or Deposits that have a Sales vat code but a non sales/income account type used. As that will not truly reflect everyone's business needs you should only use it as a quick estimate of your figures, and use the full editable Profit and Loss report for your true figures. Nothing can be edited on the Dashboard widget. So you just need to ignore the Dashboard figures and run a full report to get 100% accurate figures.

Topics

Training

Community

Resources

Dashboard Figures