I'm glad to see you here in the Community, @Cath_R. I'm very eager to lend a hand on how we can figure out why these reports aren't matching in QuickBooks Desktop (QBDT).
The total sales and total income won't always match due to transactions that may emerge in a data file that will unlikely for them to match. We can compare the two reports to see which transactions are causing the discrepancies.
Here's how:
- Go to the Reports menu, and select Vendors & Payables > Sales Tax Liability.
- Double-click the Total for Total Sales column. It will open the Sales Tax Revenue QuickZoom report.
- Select Customize Report.
- Choose the correct report basis, Accrual or Cash.
- Under the Display tab, select the date range for the report.
- From the Filters tab, choose Accounts.
- Tick the drop-down menu, and choose All ordinary income accounts.
- Still, under the Filters tab, select Transaction Type and choose Multiple Transaction Types from the drop-down menu.
- In the box, put a checkmark next to all transaction types excluding Invoice and Sale Receipts.
- Select OK to return to the Filters window.
- Click OK again to return to the report.
From there, we can open the Profit and Loss report and collate the details to get around this issue.
You can read through this article for more insights about this process: Sales Tax Liability Report: Total sales are different from total income.
Additionally, I'll share with you this handy guide in case you encounter any other issues with the Sales Tax Liability report: How to fix common issues when running a Sales Tax Liability report.
I'll be around if you need further assistance managing your reports in QBDT. I'm very eager to help. Take care!
