Sales Tax Liability Report: Total sales is different from total income

Scenario: Total Sales on the Sales Tax Liability Report is different from the Profit and Loss Report Total Income.

Quick Tip: The total sales and total income will not always match because there are transactions that can appear in a data file that will make it unlikely for the Sales Tax Liability and Profit and Loss reports to match. You can compare the two reports to see which transactions are causing the discrepancies.

To fix the problem, compare the details of the totals by running the Sales Tax Liability report and The Profit & Loss Standard report.

Sales Tax Liability

1. From the Reports menu, select Suppliers & Payables > Sales Tax Liability.
2. Double-click the Total for Total Sales column. This will open the Sales Tax Revenue QuickZoom report.
3. Select Customise Report.
4. Choose the correct report basis, Accrual or Cash.
5. Under the Display tab, select the date range for the report.
6. Under the Filters tab, choose Accounts.
7. From the drop-down menu, select All ordinary income accounts.
8. Still under the Filters tab, select Transaction Type and choose Multiple Transaction Types from the drop-down menu.
9. In the box that opens, put a check mark next to all transaction types excluding Invoice and Sale Receipt.
10. Select OK to return to the Filters window.
11. Select OK again to return to the report.

Profit and Loss Standard

1. From the Reports menu, select Company & Financial > Profit & Loss Standard.
2. Double-click Total Income.
3. Select Customise Report.
4. Choose the correct report basis, Accrual or Cash.
5. On the Display tab, select the same date range.
6. Under the Filters tab, choose Accounts.
7. From the drop-down menu, select All ordinary income accounts.
8. Still under the Filters tab, select Transaction Type and choose Multiple Transaction Types from the drop-down menu.
9. In the box that opens, put a check mark next to all transaction types excluding Invoice and Sale Receipt.
10. Select OK to return to the Filters window.
11. Select OK again to return to the report.

If you encounter any other issues with STLR, see Resolve common issues when running Sales Tax Liability Report.