The Tax report (Reports → Tax) does not include the Sales journal. It only includes Sales documents (i.e. Invoices an Credit notes). Transactions on other Batch types may cause similar errors.  

The reason for this, is the Consolidate balancing option on the Standard tab - F10:Setup on the "Options for this batch" screen. When setting up the batch, an information message will be displayed.

"Consolidating lines and using tax will mess up your tax report! Please make sure you do not use tax or do not consolidate lines!" 

Click on the OK button and click on the F10:Setup icon and deselect (remove the tick) from the Consolidate balancing field on the Standard tab of the "Options for this batch" screen. 

Balance the batch again.

You may print the Tax per period to check your tax transactions of posted batch transactions and posted documents (i.e. invoices, credit notes, purchase and supplier return documents).  

The Tax excluded and Tax amount in the Report total of the Tax report - Reference / Document no. report, should balance with the Total - Output tax – Input tax of the Tax per period report, if the same periods are selected.

It is recommended that these tax reports are printed and archived (PDF) for record and audit purposes.

Report options

To print Tax per period reports

1.On the Reports ribbon, select Reports → Tax

2.Select "Tax per period" report.

tax-per-period-options

3.Select the following:

a)Period - Select the period on the Per period tab. You may click on the Free selection tab to select a specific date or a range of dates.

b)Show details - By default, this option is not selected. It will only list the totals exclusive of Tax (VAT/GST/Sales tax) for each tax code. If this option is selected, it will list all transactions and documents including the account code, account description, country and tax reference of the debtor or creditor (supplier / vendor) account (if applicable). 

c)Show tax separately - Select this option to print each tax code on a new page. 

It is recommended that this option is only selected if the "Show details" option is selected.

4.Click on the OK button. 

Printed example : Tax per period : No details

An example of the "Tax per period" (no details) report, is as follows:

tax-per-period-print

Printed example : Tax per period : Show details

An example of the "Tax per period" ("Show details" and "Show tax separately") report, is as follows:

Page 1 - Output tax - 15%

tax-per-period-print-output-tax

Page 2 - Input tax - Standard rate - 15%

tax-per-period-print-input-tax-standard-rate

Page 3 - Input tax - Capital goods -15%

tax-per-period-print-input-tax-capital-goods

The Tax excluded and Tax amount in the Report total of the Tax report - Reference / Document no. report, should balance with the Total - Output tax – Input tax of the Tax per period report, if the same periods are selected.