Quickbooks Support

Call QuickBooks Help know how to Match Total Sales with Total Income in QuickBooks

QuickBooks is a popular accounting software that enables you maintains reliable and up-to-date financial reports. The two reports could perhaps match when you reconcile the sales tax liability report with the profit and loss norm report. However, because of the transactions appearing in the data sheet, it is not always possible to align total revenue with total income in QuickBooks. You need to analyze the two reports to figure out which transaction is causing this difference in order to deal with this situation. Until the end, read this article.

If the QuickBooks sales tax records do not fit total profits, send us a call to help our experienced QuickBooks experts get help from our QuickBooks.

In QuickBooks, how to balance total sales with total income?

“Sometimes, in QuickBooks, aligning total sales to total revenue can give an error message on your screen that says, “Sales tax liability report: Total sales vary from total revenue. You have to compare the two reports in this scenario to see which transaction is causing the problem. It is necessary for you all to know the reporting basis you have chosen for your sales tax once you compare these two reports. To analyze the reports, follow the reports provided down.

Sales Tax Liability

Let’s run the sales tax liability report in the first place by completing the instructions below to align total sales with total income in QuickBooks:

  • Select Vendors & Payables from the Reports menu as well as further select Sales Tax Liability.
  • Double-click the Number for Total Sales column as well as the Quick Zoom Sales Tax Revenue report will open.
  • You have to pick the Customize Report after that.
  • After this, choose the correct basis of the study, Accrual or Cash.
  • Pick the date range for your sales tax liability report from under the Show tab.
  • Heading further, select Accounts under the Filters tab.
  • From the drop-down menu, pick All Usual Income Accounts.
  • You ought to pick the Transaction Form from under the Filters tab.
  • Pick the Multiple Transaction Forms option from the drop-down menu.
  • Check the box for all forms of transactions, except invoices and sales receipts.
  • To return to the Filter pane, click OK.
  • Once more, to return to the report, click OK.

Standard for Benefit and Loss

Also that you have seen the declaration of sales tax liability, let’s run the regular profit and loss report to balance net sales in QuickBooks with total revenue and find the transaction causing the discrepancy:

  • Go to the Reports menu, choose Business & Financial, and then choose Profit & Loss Norm again.
  • After that, double-click Income Max.
  • Pick Customize Report after that
  • You have to select the correct report basis, Accrual or Cash, to step forward.
  • Then, pick the same date range from the Show tab as you selected in the sales tax liability report.
  • Select Accounts from under the Filters tab.
  • Select All Ordinary Income Accounts using the drop-down list.
  • You have to pick the Transaction Form from under the Filters tab.
  • After that, from the drop-down menu, pick Various Transaction Types.
  • Your previous action would open a box that allows you to check the box for all forms of purchases, except invoices and receipts for sales.
  • To return to the Filter pane, click OK.
  • Select OK once again, and it will take you back to the study.


In QuickBooks, the process mentioned in this post will help you to reconcile total sales with total income. If you have any questions about the solution and need to communicate with our expert team, call us on our Quickbooks help number for QuickBooks, our dedicated team of professionals will assist you to correct the inconsistencies in your reports so that you can match total sales without any distress with total revenue in QuickBooks. You can also contact us by sending us an email for guidance at ( for more information about QuickBooks; you can visit our website at

Comments are closed.