Simple VAT Filing Kit (MTD Ready)
Stop dreading VAT quarter-end.
If you're VAT-registered and managing your own books, you already know the problem: your transactions are scattered, the 9 boxes feel confusing, and you're not sure you've captured everything correctly before filing.
This kit fixes that.
What It Is
The Simple VAT Filing Kit (MTD Ready) is a professionally built spreadsheet template that helps UK VAT-registered businesses organise their transactions and prepare accurate Box 1–9 totals — ready to copy into your MTD-compatible filing software.
It's not accounting software. It's not a subscription. It's a clean, structured system you own outright and use every quarter.
What's Included
✅ VAT Spreadsheet Template — Excel (.xlsx) and Google Sheets compatible ✅ Boxes 1–9 layout — pre-mapped to HMRC's exact 9-box structure ✅ Quarterly transaction tracker — log sales and purchases with dates, VAT rates, and totals ✅ Standard & Cash Accounting modes — switch schemes in the Settings tab ✅ Auto-calculating Gross column — Net + VAT calculated for you ✅ Period filter — only transactions in your VAT period count toward the return ✅ Error Check tab — flags missing data, mismatched VAT, and incomplete entries before you file ✅ Reconciliation tab — compare your template totals to your VAT control account ✅ Deadline Tracker — 8-quarter forward planner with days-until-deadline countdown ✅ Example Data tab — 15 sample transactions so you understand the system instantly ✅ Plain-English "How to Use" guide — built into the file, no separate PDF needed
Who This Is For
This kit is built for:
- UK VAT-registered small businesses and sole traders who manage their own bookkeeping
- DIY bookkeepers who want a clean, reliable quarterly system without the cost of full software
- Businesses on Standard (Invoice) or Cash Accounting scheme
- Anyone who already uses spreadsheets and wants structure, not complexity
- Virtual assistants and bookkeeping clients who need a simple system to hand off to their accountant
Important — MTD Compliance Note
This template helps you prepare your VAT return totals. It does not submit to HMRC directly. You will still need MTD-compatible software (such as bridging software or your accounting package) to submit your return. This is standard practice for spreadsheet-based businesses under MTD.
Made By a Qualified Bookkeeper
This isn't a generic template made by a designer. It was built by the team at MMJ B&P Digital, a division of MMJ Bookkeeping & Paralegal. We work with UK VAT-registered businesses every day — this kit reflects how VAT records actually need to be kept.
Instant Download — Use It This Quarter
After purchase you'll receive immediate access to download your file. Instructions are built directly into the spreadsheet — no account required, no software to install. Open it, fill in your Settings, and start entering transactions.
FAQ
Does this submit my VAT return to HMRC? No — it prepares your Box 1–9 totals. You submit via MTD-compatible software (bridging software, Xero, QuickBooks, etc.).
Does it work in both Excel and Google Sheets? Yes. The .xlsx file works in Excel and can be uploaded directly to Google Drive and opened as a Google Sheet.
Is this for Standard scheme or Cash Accounting? Both. The Settings tab has a toggle — select your scheme and the logic updates automatically.
Do I need accounting knowledge to use it? No. It's designed for non-accountants. Every tab includes plain-English instructions and the Example Data tab shows you exactly how it works.
Can I use it for multiple businesses? This licence covers use for one business. For multiple copies please get in touch for a multi-licence option.
Licence & Usage
This is a digital template for business use. You may use and adapt it for your own business. You may not resell, redistribute, or repackage it as your own product.
© MMJ B&P Digital | A division of MMJ Bookkeeping & Paralegal. This template does not constitute tax advice. Always verify your VAT return with a qualified accountant or bookkeeper if you are unsure.