All the general ledger postings to the VAT accounts are extracted for the past three periods together with all the entries posted to the VAT sub ledger. Using this data the balancing items are removed to leave a reconciliation which shows unmatched general ledger and sub ledger entries broken down into prior, current and post period buckets - based on tax point date.

VAT Reconciliation summary

VAT Reconciliation non balancing items