Dynamics NAV: Checking totals on your VAT Statement

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

Leave a Reply