Excel spreadsheet for VAT reconciliation

[Mike Simmonds]

VAT Recon.xls

Here is the VAT recon, the overall idea is to track cumulative income and expenses and the VAT paid or claimed thereon. Expenses and credit notes applying to prior periods, that will generally not appear on the reports of Accounting Software programs, are one of the main reasons for continually updating this recon before every VAT submission.

I hope it helps you, but please let me know if you have any queries.