G/L - VAT Reconciliation (report)

The G/L - VAT Reconciliation report uses VAT statement lines to show amounts and VAT by G/L account. It includes Account Totaling and VAT Entry Totaling lines to help you compare general ledger amounts with VAT entries. It doesn't list individual transactions.

Use this report during VAT filing periods to validate that posted VAT entries match the VAT amounts in your general ledger. This report is important for accurate tax filings and audit readiness.

Select the VAT statement name and enter Starting Date and Ending Date. G/L account totals use posting dates, while VAT entry totals use VAT reporting dates. Choose whether to include open, closed, or both states of VAT entries, and whether to include entries before the period. Reversed VAT entries are excluded.

VAT entries must have a G/L account number for reconciliation. If the report can't determine the account for an entry, exclude the affected entry or ask your partner to help fix the data.

Use cases

Compare general ledger amounts with VAT entry totals by G/L account, based on your VAT statement setup. G/L totals use posting dates, while VAT entry totals use VAT reporting dates. Investigate differences before you file VAT.

Tip

Here are some tips on how to use the report:

  • Catch discrepancies early by using the report during VAT filing periods.
  • Check for differences between posting dates and VAT reporting dates when you compare amounts.
  • Ensure all VAT entries are properly posted and reconciled with the G/L.
  • Confirm VAT accuracy by using the report as part of your audit preparation checklist.

Accountants can use the report to:

  • Verify VAT postings.
  • Ensure compliance with tax regulations.

Controllers can use the report to:

  • Oversee VAT reconciliation processes.
  • Support internal control and audit readiness.

Auditors might reference the report to:

  • Confirm the completeness and accuracy of VAT filings.
  • Identify account totals that need further investigation in the ledger entries.

Try the report

Try the report here: G/L - VAT Reconciliation

Tip

If you hold down the Ctrl key while you select the report link, the report opens on a new browser tab. The new tab lets you stay on the current page while you explore the report on the other browser tab.

VAT management overview
Built-in VAT reports in Business Central
Built-in key finance reports
Ad hoc analysis on finance data
Financial analytics overview

Find free e-learning modules for Business Central here