You can run the Day Book VAT Entry Report to check totals in each box of your VAT Statement.
For version 4 and later – Financial Management, General Ledger, Reports, VAT Reporting, Day Book VAT Entry.For version 3 – General Ledger, Reports, Day Book VAT Entry
Box 1: VAT due on sales and other outputs (SALES VAT) You get this value if you run Day Book report with type SALE
Box 2: VAT due from you (but not paid) on acquisitions from other EU countries (PURCHASE REVERSE VAT) You get this value if you run Day Book report with type PURCHASE, VAT Calculation Type equal Reverse Charge VAT
Box 3: total VAT due (TOTAL VAT)
This is the sum of boxes 1 and 2. This is the amount of VAT you must pay or reclaim.
Box 4: VAT reclaimable on your purchases (PURCHASE VAT incl. REVERSE) This is the VAT that you paid on your purchases. You should also include VAT you paid on imports. You can also think about this amount as a sum of "PURCHASE VAT" and "PURCHASE REVERSE VAT".
You get this value if you run Day Book report with type PURCHASE
Box 5: VAT payable or reclaimable
This is the difference between boxes 3 and 4.
Run the Day Book report with type PURCHASE|SALE, "VAT Calculation Type" different from "Reverse Charge VAT"
Box 6: Total value of sales excl. VAT, incl. Row 8
You get this value if you run Day Book report with type SALE from the BASE Total
Box 7: Total value of purchases excl. VAT, incl. Row 9
You get this value if you run Day Book report with type PURCHASE from the BASE Total
Box 8: Total value of supplies excl. VAT to EU
Run the run Day Book report with type of SALE, VAT Calculation Type equal to Reverse Charge Vat
Box 9: Total value of acquisitions excl. VAT to EU
Run the run Day Book report with type of PURCHASE, VAT Calculation Type equal to Reverse Charge Vat from the BASE Total