I have a client who was on VAT cash accounting who deregistered and I prepared the final VAT return. The Vat return just would not reconcile back to net balance of the 2200, 2201 and 2202.
There were outstanding debtors or creditors all balances were “Zero” on both debtors and creditors so I just could not understand why it would reconcile by a miserable £4.69 and was tempted to put in an adjustment for the amount instead of spending hours on it. However I persevered and found the cause. One of the suppliers had issued an invoice for £31.49 inclusive of VAT back in early 2010. A credit note was received for the same amount and matched up with the invoice and as such the Invoice was not paid.
I deleted both the Invoice and Credit note and reposted the Invoice and paid it posted the credit note and recorded a refund from the supplier (this corrected the bank reconciliation) and now the VAT report balances exactly to balances from accounts 2200, 2201 and 2202.
If anyone comes across something like the above scenerio it might be worth your while to check the above.