Home VAT/Sales Tax Reconciliation How do I find transactions that didn't match between VAT / sales tax and Books?

How do I find transactions that didn't match between VAT / sales tax and Books?

Last updated on May 18, 2026

Short Answer: Click the 'Unmatched' tab to see entries that were not matched and review the 'Statement date' and 'Statement description' list.

PreRequisites

  1. Be on the VAT / sales tax vs books page where 'Matched' and 'Unmatched' tabs are visible.

Steps

  1. Click the 'Unmatched' tab next to 'Matched'.
    The 'Unmatched' list is displayed.

  2. Scan the 'Statement date' and 'Statement description' columns to find the transactions that are not matched.
    You see rows such as '02 Jan 2026 Metro Foods PLC' that were not matched.

  3. Use the row details date, customer, invoice to determine why the item didn't match.
    You identify missing invoices, date/amount mismatches, or other reasons for being unmatched.

Troubleshooting

  1. Totals still show a difference but 'Unmatched' appears empty.
    LikelyCause: A filter is applied or the page did not refresh.
    Action: Clear any filters, refresh the page, and re-check the 'Matched' and 'Unmatched' tabs.

Note: The 'Matched - VAT / sales tax vs books' header shows how many transactions are matched; compare that to the counts in the 'Total' card.