← Guides

MTD BRIDGE / PRACTICAL GUIDANCE

Prepare your first spreadsheet

Use your existing summary or start with a small, clearly labelled workbook.

1. Prepare the source

Create a nine-box VAT summary linked to the digital records you already keep. If a box does not apply, use a real zero. Blank cells do not mean zero. Our starter uses blank inputs so you cannot accidentally mistake a template for a completed return.

Download the Excel starter ↓ · Download an example CSV ↓

2. Recalculate, save and export

In Excel, recalculate and save an unencrypted .xlsx file. In Google Sheets, download Microsoft Excel (.xlsx) or comma-separated CSV. CSV must use commas between fields, a decimal point and UTF-8 text. Quote amounts containing thousands separators.

We read saved results for Excel formulae. We do not execute macros or recalculate workbook formulae. A formula without a saved numeric result cannot be imported. If results are missing or outdated, recalculate and save in your spreadsheet application.

3. Choose the source cells

Open the file in the tool. A summary with labels “Box 1” to “Box 9” immediately to the left of amounts can be detected automatically. Verify these suggestions. Other layouts can be mapped by choosing each worksheet and cell reference, such as B4.

4. Review the checks

Boxes 1–5 allow up to two decimal places. Box 5 must be positive or zero. Boxes 6–9 require whole pounds; apply the appropriate rounding in your source file. The beta supports up to £9,999,999,999.99 per box, a smaller range than the HMRC API.

Use a compact summary up to 10 MB, 30 sheets, 50,000 populated cells, 10,000 rows and 200 columns. Expanded workbooks are limited to 40 MB. Old .xls, .xlsm, external workbook links and password-protected files are unsupported.

5. Download and retain

Add your period labels, confirm your review and download an accessible HTML report, CSV or JSON, or use Print / save as PDF. Reports contain the nine mapped figures and source references. They are not submission receipts or universal import files for other software. A saved mapping file contains cell references only; import your updated spreadsheet and load the mapping next time.

Open VAT preparation →