How do I run a VAT reconciliation?

Short Answer: Confirm Tax account name and Period, ensure Books and VAT files are uploaded and configured, then click 'Run reconciliation'.

PreRequisites

1. At least one Books file and one VAT / sales tax statement file uploaded.

2. File mappings configured Date, Tax amount, Reference / Identifier.

3. Tax account name and Period selected.

Steps

1. Open the VAT / sales tax reconciliation setup page and confirm the 'Tax account name' and 'Period' fields.
   Tax account name and Period are visible example: 'VAT Reconciliation' and 'May2026'.

2. Verify Books and VAT files are present and configured in their panels.
   Configured files e.g., UK_VAT_Internal.xlsx and UK_VAT_Return.xlsx are listed.

3. If you need to replace or add files first, click 'Add files & update report'.
   Upload/configure flow opens to update files.

4. Click the green 'Run reconciliation' button in the top-right.
   System runs and the results page loads showing summary cards and transaction lists.

5. Review the results on the reconciliation results page cards and tabs.
   Cards for Total, Fully matched, Partially matched, and Unmatched appear with counts and totals.

Troubleshooting

1. Clicking 'Run reconciliation' appears to do nothing.
   LikelyCause: Required files or mappings are missing or fields are empty.
   Action: Confirm both files are uploaded and configured and that 'Tax account name' and 'Period' are set; then click 'Run reconciliation' again.

2. Results show unexpected or large Difference.
   LikelyCause: Wrong column mapped for Tax amount or Reference / Identifier.
   Action: Re-open Configure file for each file and verify 'VAT Amount GBP' is selected as Tax amount and correct Reference columns are chosen; then re-run.

Note: Run results include Recon ID and timestamp e.g., 'Recon ID: 139 • Run on Sep 4, 2026 • 5:57 PM'.