Xero VAT return: what each box means and what to check before you submit

Short answer: Xero builds your UK VAT return from the VAT rate on every invoice, bill and bank transaction, and submits it to HMRC under Making Tax Digital once your organisation is connected to HMRC. You open it from the Tax menu, under VAT return. Before you submit, reconcile every bank account to the last day of the period, open the return and click into each box to see the transactions behind it, and compare Box 5 with the VAT account on your Balance Sheet. The return is only as right as the VAT rate on each line, so most of the check is looking for wrong rates. Then look at Box 5: the VAT you collected was never the business’s money, so a quarter’s return can take a big slice of the bank balance at once. In the worked example below, a business with £19,000 in the bank owes £7,800, which leaves £11,200.

The nine boxes on a VAT return

Box	What it is	Comes from in Xero
1	VAT due on sales and other outputs	VAT on sales invoices and money received at 20%, 5% (and any reverse charge VAT you account for)
2	VAT due on goods bought from the EU (Northern Ireland only)	Usually 0 for a business in Great Britain
3	Total VAT due	Box 1 + Box 2
4	VAT you are reclaiming on purchases	VAT on bills and money spent at 20% or 5%, with a valid VAT invoice
5	Net VAT to pay HMRC, or to reclaim	Box 3 − Box 4. If Box 4 is bigger, HMRC owes you
6	Total sales, excluding VAT	Sales at every rate, including zero-rated and exempt sales; “No VAT” lines are left out
7	Total purchases, excluding VAT	Purchases at every rate, including zero-rated and exempt; wages, PAYE and “No VAT” lines are left out
8	Goods supplied to the EU (Northern Ireland only)	Usually 0 in Great Britain
9	Goods bought from the EU (Northern Ireland only)	Usually 0 in Great Britain

Boxes 6 and 7 are whole pounds; Boxes 1 to 5 can include pence. Box 5 is the one you pay.

Not registered for VAT yet? You must register once your taxable sales in any rolling 12 months pass £90,000; the VAT threshold calculator shows how close you are and when you would have to register.

A worked quarter: a plumbing business in Leeds

These figures are made up. Priya’s plumbing company is VAT registered on standard (invoice) accounting at the 20% rate and files quarterly. This is the July to September 2026 quarter, so the return and the payment are both due by 7 November 2026 (one calendar month and seven days after the period ends; HMRC collects a Direct Debit a few working days after that).

Box	What went in	£
6 Total sales excluding VAT	Jobs invoiced in the quarter	60,000
1 VAT on sales	60,000 × 20%	12,000
7 Total purchases excluding VAT	21,000 of parts, fuel and tools at 20%, plus 3,000 of insurance, which is exempt	24,000
4 VAT reclaimed	21,000 × 20% (the insurance has no VAT to reclaim)	(4,200)
5 Net VAT to pay	12,000 − 4,200	7,800

Brackets are minus figures. Wages and PAYE are not in Box 7 at all, because they are outside the scope of VAT.

On 30 September the business has £19,000 in the bank. It made a profit in the quarter, but £7,800 of that balance belongs to HMRC by 7 November. What Priya can actually spend is £11,200, before the next payroll and any bills already due. Moving one sixth of every VAT-inclusive payment received into a separate account, and taking the VAT on purchases back out, would have built the £7,800 up at about £600 a week over the 13 weeks.

Standard or cash accounting: the same quarter both ways

At 30 September, £10,800 of the quarter’s invoices (£9,000 plus £1,800 VAT) are still unpaid.

VAT accounting	Box 1	Box 5	Box 6
Standard: VAT is due when you invoice	12,000	7,800	60,000
Cash Accounting Scheme: VAT is due when the customer pays	12,000 − 1,800 = 10,200	6,000	51,000

On standard accounting Priya pays £1,800 of VAT on invoices customers have not paid yet. If one of them is never paid, the VAT can be reclaimed as bad debt relief once the invoice is more than six months overdue and written off in the accounts (writing off a bad debt in Xero). On the Cash Accounting Scheme that VAT moves to the quarter the money arrives in (this example assumes every purchase was paid in the quarter, so Box 4 is the same both ways). Businesses can join the scheme if they expect taxable turnover of £1.35 million or less in the next 12 months. The basis set in Xero’s financial settings must match what you actually use with HMRC; ask your accountant before changing it. The cash vs accrual reports guide explains how the same choice changes your Profit and Loss.

How to check and submit a VAT return in Xero

1. Reconcile every bank account and credit card to the last day of the period. Unreconciled lines are not in the return yet, and a missing purchase is VAT you could have reclaimed. The bank reconciliation report guide shows how to confirm Xero agrees with the bank statement.
2. Open the VAT return from the Tax menu (in Xero’s older menu: Accounting, then VAT returns) and choose the period. Check the VAT scheme and basis in the return’s settings.
3. Click into each box. Xero shows the transactions behind each figure, and its “transactions by VAT box” view lists them in one place. Read down Box 4 for items that should carry no VAT, and look for any big sale missing from Box 1.
4. Compare the Balance Sheet at the period end: the VAT account should be close to Box 5, plus anything older still unpaid. A gap usually means a transaction coded straight to the VAT account or a manual journal.
5. Submit to HMRC from Xero. The first time, you connect the organisation to HMRC with your Government Gateway login. Under Making Tax Digital, VAT returns go from software like Xero, not by typing figures into HMRC’s website.
6. Set a lock date at the end of the period (in Xero’s advanced settings) so nobody changes a period HMRC already has.
7. Pay it, or plan for it. Record the payment against the VAT account when it leaves the bank, so the Balance Sheet goes back to zero for that quarter. If the cash is not there, file on time anyway and ask HMRC for Time to Pay before day 15 (what to do if you can’t pay your VAT on time).

Menu names differ a little by Xero plan and change between releases; search Xero Central for “VAT return” if your screen does not match.

Common mistakes

• Wrong VAT rates. Wages, bank fees, insurance, HMRC payments, loan repayments and owner transfers carry no VAT. Coding them at 20% reclaims VAT you never paid. Use Exempt for insurance and No VAT for transfers and wages, so Box 7 stays right too.
• Reclaiming without a VAT invoice, or from a supplier who is not VAT registered, or on most business entertaining.
• Overseas software subscriptions coded at 20% when the supplier did not charge UK VAT. These usually need the reverse charge rate instead; check with your accountant.
• Treating the bank balance as spendable in the weeks before the return is due. The VAT in it belongs to HMRC, and so does the corporation or income tax building up on your profit (how much to set aside for tax works out one percentage for all of it).
• Editing a period after it has been submitted. Small errors can go on the next return; larger ones need telling HMRC separately (see below).
• Leaving it to the week it is due. A monthly look at the VAT account on the Balance Sheet makes Box 5 a number you saw coming.
• Confusing MTD for VAT with MTD for Income Tax. Submitting VAT returns under Making Tax Digital does not by itself cover the separate quarterly updates that sole traders and landlords above £50,000 of turnover now have to send for income tax: see Making Tax Digital for Income Tax.

Common questions

Where is the VAT return in Xero? In the Tax menu, under VAT return. If your Xero still shows the older menu, it is under Accounting, then VAT returns. Choose the period to see Boxes 1 to 9 worked out from your transactions, and click a box to see the invoices, bills and bank lines behind it.

How do I check my VAT return before submitting it? Reconcile every bank account to the period end, click into each box and read the transactions, then compare Box 5 with the VAT account on the Balance Sheet. Most errors are VAT charged on lines that should have none, such as wages, bank fees, insurance and loan repayments.

What do boxes 6 and 7 include? Box 6 is total sales excluding VAT and Box 7 is total purchases excluding VAT. Both include zero-rated and exempt items. Wages, PAYE, loan repayments and anything else outside the scope of VAT are left out.

When is my VAT return due? The return and the payment are both due one calendar month and seven days after the end of the VAT period. For a quarter ending 30 September that is 7 November.

How do I correct a mistake on a VAT return I have already submitted? If the net error is £10,000 or less, or up to 1% of Box 6 with a ceiling of £50,000, you can correct it on your next return. Larger or deliberate errors have to be reported to HMRC separately, for example on form VAT652. Ask your accountant if you are unsure.

What happens if I file or pay VAT late? Each late return earns a penalty point, and once a quarterly filer reaches four points there is a £200 penalty for each further late return. For late payment, HMRC charges 3% of what is still unpaid on day 15, another 3% of what is unpaid on day 30, then 10% a year, on top of interest.

How much should I set aside for VAT? At the 20% standard rate, one sixth of every VAT-inclusive payment you receive, less one sixth of VAT-inclusive purchases with VAT on them. In the example above that is £7,800 for the quarter, or about £600 a week.

See the VAT coming in your Monday email

ReportPilot reads your Xero figures and sends a short plain-English email every Monday. It covers sales and profit against last month and the same month last year, the cash in the bank against the end of last month, money owed to you that is past due and by whom, and bills due in the next two weeks against your cash. It does not prepare or submit a VAT return. It asks Xero for read-only access, and there is a 14-day free trial with no card.