Map Extract
Free tool

VAT return box calculator

Paste the period's sales and purchases with a header row, or switch to the Flat Rate Scheme and enter turnover. The calculator fills in boxes 1 to 9 as VAT Notice 700/12 describes them, ready to check against your bookkeeping before you submit through compatible software.

Runs in your browser. Nothing you enter is uploaded.

Standard accounting: from rows to boxes

  1. Prepare the rows

    One row per invoice or bill. The columns are found by name: Type (sale or purchase), Net and VAT, or Gross with Rate. Extra columns such as Date and Description are ignored.

  2. Enter credit notes as negatives

    A credit note you issued is a sale with a minus net and minus VAT. It reduces boxes 1 and 6 rather than adding to purchases.

  3. Flag Northern Ireland goods if relevant

    Use the NI column: EU for goods sold from Northern Ireland to the EU, Acquisition for goods bought into Northern Ireland from the EU. Everyone else leaves it blank.

  4. Paste and read the boxes

    The table shows each box with its description and amount. The line above it says how many rows were used and how many were skipped for having no type or amount.

  5. Download the result

    Save the boxes as CSV to file with the period's working papers.

Example: a quarter for a small web agency

A two-person web agency pastes five rows for July to September: two sales invoices, one credit note for £250 plus VAT, a monitor and some train fares with no VAT.

Box 1 is £960, the £640 and £370 of output VAT less the £50 on the credit note. Box 4 is £84, the VAT on the monitor. Box 5 shows £876 to pay. Box 6 is £4,800 of net sales after the credit, and box 7 is £516 of purchases including the zero-VAT train fares.

Input
Type,Date,Description,Net,VAT,NI
Sale,04/08/2026,INV-0140,3200.00,640.00,
Sale,22/08/2026,INV-0144,1850.00,370.00,
Sale,15/09/2026,CN-0009 credit,-250.00,-50.00,
Purchase,07/08/2026,Monitor,420.00,84.00,
Purchase,30/09/2026,Train fares,96.00,0.00,
Result
Box 1 £960.00
Box 2 £0.00
Box 3 £960.00
Box 4 £84.00
Box 5 £876.00 (to pay HMRC)
Box 6 £4,800.00
Box 7 £516.00
Box 8 £0.00
Box 9 £0.00

Flat Rate Scheme mode

Switch the scheme to Flat Rate and enter VAT-inclusive turnover for the period, the sector, relevant goods bought and the months covered. For £18,000 of quarterly turnover at a 12% sector rate with £500 of goods:

FigureResult
Limited cost test level for 3 months£360, so £500 of goods passes and the sector rate applies
Flat rate used12%
Box 1£2,160.00
Box 6£18,000.00
Kept compared with 20% charged£840.00

Questions people ask

What goes in box 6 of the VAT return?

Box 6 is the total value of sales and other outputs excluding VAT, including zero-rated and exempt sales. Credit notes you issued reduce it. In the calculator, every sale row's net amount is added to box 6, and negative rows for credit notes are subtracted automatically.

How do I show a credit note on a VAT return?

A credit note you issued reduces your output VAT and your sales. Enter it as a sale row with negative net and VAT amounts, as in the example, and the calculator takes it off boxes 1 and 6. A credit note you received is a negative purchase row.

Are boxes 2, 8 and 9 relevant to me?

Only if you move goods between Northern Ireland and the EU. For most UK businesses they are £0. The calculator fills them only from rows marked EU or Acquisition in the NI column, so leaving that column empty keeps them at zero.

Can I use this on the Flat Rate Scheme?

Yes. Switch the scheme to Flat Rate, enter VAT-inclusive turnover for the period and your sector. The tool applies the limited cost business test for the months in the return, works out box 1 and box 6, and notes that box 4 is normally nil.

Where your data goes

The rows you paste are read and totalled inside the page. Your sales and purchase figures are not uploaded, and the CSV download is generated in your own browser.

Checked against the tool on

Top