Home VAT/Sales Tax Reconciliation How do I identify which book transaction matches a VAT transaction when I open details?

How do I identify which book transaction matches a VAT transaction when I open details?

Last updated on May 18, 2026

Short Answer: Open 'Matched transaction details' and confirm the match by comparing 'Invoice No', 'Customer/Supplier', date and amounts in both tables e.g., 'INV-2026151'.

PreRequisites

  1. 'Matched transaction details' panel is open.

Steps

  1. Open the matched transaction to view both tables.
    VAT and Book transaction rows are visible side by side.

  2. Compare 'Invoice No' values in the 'VAT / sales tax transactions' and 'Book transactions' tables.
    Invoice numbers match or a related identifier is present e.g., 'VAT-2026151' vs 'INV-2026151'.

  3. Also compare 'Customer/Supplier', dates and 'VAT Amount GBP' to confirm the correct pairing.
    You can confirm whether the book transaction corresponds to the VAT record.

Troubleshooting

  1. Invoice numbers differ between the two tables.
    LikelyCause: VAT return uses a different identifier than the ledger entry or the match used date/amount to pair records.
    Action: Confirm match using date and amount; if uncertain, note the invoice numbers and investigate the source records.

Note: Matching can use invoice identifiers but may also rely on date and amount; the 'Match basis' message confirms the rule used.