Standard accounting: from rows to boxes
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.
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.
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.
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.
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.
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,
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:
| Figure | Result |
|---|---|
| Limited cost test level for 3 months | £360, so £500 of goods passes and the sector rate applies |
| Flat rate used | 12% |
| 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