Why is my reconciliation showing a non-zero Difference or many unmatched transactions?

Short Answer: Non-zero Difference means some records didn't match — check Unmatched list, verify Reference / Identifier and 'VAT Amount GBP' mappings, and re-run after fixes.

PreRequisites

1. A reconciliation run has completed and results page is available.

Steps

1. Open the reconciliation results page and inspect the 'Unmatched' card and 'Difference' value.
   You see the difference amount and how many transactions are unmatched.

2. Click the 'Unmatched' tab to list the specific transactions that failed to match.
   A list of unmatched rows is displayed for investigation.

3. Open Configure file for both Books and VAT files and confirm 'Tax amount' is set to 'VAT Amount GBP' and Reference / Identifier columns are correct.
   Mappings reflect the proper tax and reference columns.

4. Fix file data or mappings e.g., correct reference formats or add missing rows, then re-run reconciliation.
   Difference reduces or resolves after a successful run.

Troubleshooting

1. Transactions present in Books but not in VAT file.
   LikelyCause: VAT / sales tax statement is missing rows or file is incomplete.
   Action: Upload the correct VAT file or add missing rows via '+ Add more files to VAT / sales tax statement' and re-run.

2. Amounts do not match for the same reference.
   LikelyCause: Tax amount column mis-mapped e.g., net amount chosen instead of VAT.
   Action: Open Configure file and select 'VAT Amount GBP' for Tax amount in both files, then re-run.

Note: Example shown: Total Books 64,950.36 vs VAT 62,774.44 with Difference 2,175.92.