How to Prepare a VAT Return: Boxes and a Worked Example

It is the last week of the quarter, and the portal where you file your VAT return wants nine numbers. You know roughly what your business sold and roughly what it spent. The form wants more than that. Each box splits the VAT from the net value underneath it, and you are not certain which of your purchases you are allowed to claim at all.

There is a version of this where you open the portal already knowing what belongs in every box. It costs about an hour, spent before the quarter closes rather than after. How to prepare a VAT return is almost entirely a data question, so what follows is the data it needs, in the order the form asks for it.

This is about preparation, not submission. It walks through the figures a value added tax return asks for and where each one belongs. The illustration is a nine-box form, because VAT return boxes follow nearly the same shape everywhere. For deadlines, the submission process and what changes when you sell across borders, see how to file a VAT return online.

What a VAT return actually is

A VAT return is a periodic declaration of the VAT you collected and the VAT you paid, filed with a tax authority and resolving to one net figure. That figure is either what you owe or what you are owed.

The word doing the most work there is periodic. What you file is a summary, not a transaction list. You are not submitting invoices, or anything a human at the tax office reads line by line. You are submitting totals.

That is why preparation is the hard part and submission takes four minutes. The portal only ever asks for numbers you should already have.

It also means everything is assigned to a period by its tax point, not by when the money moved. An invoice you issued in March and were paid for in May belongs to March. Getting that backwards is the commonest way a filing goes wrong, and it is invisible once the figures are totaled.

Both outcomes are normal. A business selling steadily will usually owe. One that has spent on infrastructure, contractors and tooling ahead of revenue will usually be owed. A repayment claim is not a sign you have made a mistake.

The four figures every return is built from

Every VAT return, in every country, is built from four totals:

• what you charged on sales, which is your output VAT
• what you were charged on purchases, which is your input VAT
• the net value of those sales, before VAT
• the net value of those purchases, before VAT

Two of those are VAT amounts and two are the values underneath them. Returns ask for both, and that catches people out, because most accounting reports show you one or the other rather than the pair.

The arithmetic is the easy half. Output minus input is your net position, and that is the whole calculation. Three questions sit behind those two tax figures:

• what qualifies as recoverable
• when a purchase counts
• which expenses are excluded outright

That is a longer subject, and we have covered it properly in input VAT vs output VAT.

One piece of it belongs here, though, because it decides which period a figure lands in rather than whether it counts at all. Your right to deduct arises at three different moments depending on the purchase, per the European Commission's rules on VAT deductions:

• for domestic purchases, when the goods or services are supplied
• for intra-EU acquisitions, when you receive the invoice
• for imports, when the goods are imported

None of those is the date you paid. You can earn the right to deduct weeks before the money leaves your account, or well after, and the period follows the right rather than the payment.

The other detail worth fixing early: the value boxes exclude VAT. The form asks for the total value of sales and all other outputs excluding any VAT. Reporting a gross figure there is a quiet, common error, and nothing in the portal will flag it.

Box by box: where each figure goes

Box numbering is national. The shape is not. Almost every VAT return runs in the same order:

1. the output side, meaning what you charged
2. the input side, meaning what you were charged
3. the net figure between them
4. the values underneath both

Once you recognize that shape, any country's form becomes legible in a couple of minutes.

The nine-box structure below is the one used in the UK, which makes a clean illustration because it is fully published. The official labels and the arithmetic come from HMRC's VAT Notice 700/12.

Box	What it asks for	Amount type	How it is derived
1	VAT due in the period on sales and other outputs	VAT amount	From your sales records
2	VAT due on acquisitions of goods from EU member states	VAT amount	From your purchase records
3	Total VAT due	VAT amount	Box 1 plus box 2
4	VAT reclaimed in the period on purchases and other inputs	VAT amount	From your purchase records
5	Net VAT to pay or reclaim	VAT amount	Box 3 minus box 4
6	Total value of sales and all other outputs, excluding VAT	Net value	From your sales records
7	Total value of purchases and all other inputs, excluding VAT	Net value	From your purchase records
8	Total value of supplies of goods and related costs to EU member states	Net value	From your sales records
9	Total value of acquisitions of goods and related costs from EU member states	Net value	From your purchase records

Two of those nine are calculated rather than entered, as the derivation column shows. People routinely type them in by hand, then wonder why nothing reconciles.

The pairing to keep straight is boxes 1 and 6. They describe the same sales, one as VAT and one as net value.

Every sale included in box 1 is also included in box 6, at its value before VAT.

Purchases work the same way across boxes 4 and 7.

If box 6 is ever smaller than box 1, you have put a gross figure somewhere it does not belong.

One case lands in two places at once. Buy goods and services from a supplier abroad under the reverse charge and you account for the VAT yourself, as though you had charged it. That purchase then appears on both the output and the input side of the same filing, usually netting to nothing but belonging in both. Omitting it is an error even where the net effect is zero.

For the country-specific version of the form, our UK VAT filing guide covers the submission requirements in full.

A worked example: one quarter, two outcomes

Structure is easier to trust once it has carried real numbers, so here is how to prepare a VAT return end to end, twice. Take a small digital products company, everything standard-rated at 20%, no EU goods movements, filing a domestic quarterly return.

In its first quarter it sold £48,000 of net sales and bought £12,000 of net purchases with recoverable VAT on them.

Box	Description	Amount
1	VAT due on sales	£9,600
2	VAT due on EU acquisitions	£0
3	Total VAT due (1 + 2)	£9,600
4	VAT reclaimed on purchases	£2,400
5	Net VAT to pay (3 - 4)	£7,200
6	Net sales, before VAT	£48,000
7	Net purchases, before VAT	£12,000

Boxes 8 and 9 stay at zero, because no goods crossed a border.

Now the same business one quarter later. It has rebuilt its billing stack, prepaid a year of infrastructure and hired two contractors, so purchases outran sales: £21,000 of net sales against £39,000 of net purchases.

Box	Description	Amount
1	VAT due on sales	£4,200
3	Total due, before reclaims	£4,200
4	VAT reclaimed on purchases	£7,800
5	Net VAT to reclaim (3 - 4)	£3,600
6	Net sales, before VAT	£21,000
7	Net purchases, before VAT	£39,000

Box 5 is negative, so the authority owes the business £3,600. Nothing has gone wrong. Repayment quarters are ordinary for any company whose spending runs ahead of its revenue, which describes most software businesses in their first two years.

The figure most at risk in either table is box 4. Move a single prepaid annual invoice into the wrong period and it splits across two filings.

£1,300 lands in this quarter, £6,500 in the next. Both are then wrong, in ways the portal accepts without comment.

The records that have to exist before you file

A deduction is only as good as the evidence behind it. To claim input VAT you generally need a valid VAT invoice, and for intra-EU purchases the requirement is firmer still. The European Commission puts it plainly: a business "must hold a valid VAT invoice and provide the information required in its VAT return."

Some countries relax this and accept alternative evidence, so confirm locally rather than assuming either way.

How long the records live is not negotiable. OSS records must be kept for 10 years from the end of the year the transaction was made, and that obligation survives you leaving the scheme.

The useful test is not whether you hold the documents but whether they produce the four totals on demand. Your records need to give you:

• sales broken down by country and by rate
• purchases and expenses, with recoverable VAT separated from non-recoverable
• a tax point on every line

If any of those three needs a manual pass through a spreadsheet, filing will take a day rather than an hour. Our list of mistakes to avoid when filing VAT covers what tends to go wrong from there.

A pre-filing check that catches most errors

The last step in how to prepare a VAT return is checking it. Work through these in order. Each one exists because it catches a specific error rather than because it sounds prudent.

1. Do the derived boxes reconcile? Box 3 should equal box 1 plus box 2, and box 5 should equal box 3 minus box 4. If they do not, something was typed rather than calculated.
2. Are the value boxes net? Box 6 and box 7 exclude VAT. A gross figure here inflates your reported turnover without changing what you pay, which is the worst combination.
3. Is every line in the right period? Check by tax point, not payment date, and pay particular attention to anything prepaid or invoiced near the period boundary.
4. Have non-recoverable items been excluded? Purchases wholly for personal use and business entertainment do not belong in box 4.
5. Have credit notes been applied on both sides? A credit note you issued reduces what you charged, and one you received reduces what you can reclaim. Missing the second is more common than missing the first.
6. Have reverse charge purchases been accounted for on both sides? They belong on the output side and the input side, even where they net to zero.

A VAT return that reconciles against its own arithmetic and its own period is one you will not be revisiting in eighteen months.

Once the figures hold up, the rest is submission: picking the right portal, hitting the deadline and knowing whether a nil return is expected. That is all in how to file a VAT return online.

Where the figures come from

How to prepare a VAT return is a reporting problem before it is a tax problem, and the four totals have to come from somewhere. Quaderno's tax reports break your sales and purchases down by country, rate and period as the transactions land. The numbers each box asks for are already calculated by the time you open the portal. If you would rather not open it at all, we file through trusted partners in the EU, the US and elsewhere.