How to fill in a VAT return from the books

A VAT return has nine boxes. Five hold amounts of VAT and four hold the values of sales and purchases. Every figure comes from the day books and the cash book.

Updated By Ledger Drill

What a VAT return is

A VAT return is a summary of one VAT period. It has nine boxes, and they are the same for every business. Each box is a total of figures already in the books.

The nine boxes of the VAT return
BoxWhat goes in it
1VAT due on sales and other outputs
2VAT due on goods brought into Northern Ireland from the EU
3Total VAT due: box 1 plus box 2
4VAT reclaimed on purchases and other inputs
5Net VAT to pay or reclaim: the difference between box 3 and box 4
6Total sales, excluding VAT
7Total purchases, excluding VAT
8Goods sent from Northern Ireland to the EU, excluding VAT
9Goods brought into Northern Ireland from the EU, excluding VAT

Boxes 1 to 5 are amounts of VAT. Boxes 6 to 9 are not VAT: they are values before VAT.

Boxes 2, 8 and 9 are only for goods moving between Northern Ireland and the EU. A business with none of that trade enters nil in all three, and its box 3 is the same as its box 1.

This guide follows standard VAT accounting, where VAT belongs to the period of the invoice, paid or not. The special schemes work differently. The rates of VAT, the date a return is due and what happens when one is late all change, so they are not given here. They are on GOV.UK.

Where each figure comes from in the books

The five boxes a business fills from its books
BoxFrom the books
1VAT columns: the sales day book, plus cash sales in the cash book, less the sales returns day book
4VAT columns: the purchases day book, plus cash purchases in the cash book, less the purchases returns day book, less any VAT that cannot be reclaimed
5The difference between box 3 and box 4
6Net columns: the sales day book, plus cash sales in the cash book, less the sales returns day book
7Net columns: the purchases day book, plus cash purchases in the cash book, less the purchases returns day book

Zero rated and exempt sales carry no VAT, but they are still sales. Their value goes in box 6. Zero rated and exempt purchases go in box 7 in the same way.

Box 7 takes stock, equipment and expenses. Wages, and money the owner takes out, are not purchases for VAT and are left out.

Box 5 is never a minus figure. It is the difference, and the return shows which way the money goes.

The steps in order

Work through a return in the same order every time: the VAT boxes first, then the value boxes, then the check.

  1. Make sure every invoice and credit note dated in the period is in the books. Box 1 follows the date of the invoice, not the date the customer paid.
  2. Work out box 1 from the VAT columns for sales. The VAT on credit notes sent to customers comes off.
  3. Enter box 2, which is nil with no Northern Ireland or EU trade. Box 3 is box 1 plus box 2.
  4. Work out box 4 from the VAT columns for purchases. The VAT on credit notes from suppliers comes off, and so does any VAT that cannot be reclaimed, such as the VAT on entertaining customers.
  5. Work out box 5: the difference between box 3 and box 4. If box 3 is bigger, the business pays HMRC. If box 4 is bigger, HMRC repays the business.
  6. Work out box 6 from the net columns for sales, and box 7 from the net columns for purchases. Credit notes come off both.
  7. Enter boxes 8 and 9, which are nil with no Northern Ireland or EU trade.
  8. Check box 5 against the balance on the VAT account in the books. The two should agree.
  9. Send the return, then pay. The payment is a debit to VAT and a credit to Bank.

A worked example

Northgate Framing frames pictures. It trades only in England, so boxes 2, 8 and 9 are nil.

Northgate Framing: VAT columns of the books for the quarter
From the booksVAT £
Sales day book5,260.00
Cash book: cash and card sales1,140.00
Sales returns day book120.00
Purchases day book2,870.00
Cash book: cash and card purchases330.00
Purchases returns day book96.00

Box 1 is £5,260.00 plus £1,140.00, less £120.00 on credit notes to customers: £6,280.00. Box 3 is the same figure.

The cash and card purchases include a lunch for a gallery owner, with VAT of £42.00 that cannot be reclaimed. Box 4 is £2,870.00 plus £330.00, less £96.00 on credit notes from suppliers and £42.00 on the lunch: £3,062.00.

Box 5 is £6,280.00 less £3,062.00, which is £3,218.00. Box 3 is the bigger figure, so Northgate pays HMRC.

Northgate Framing: net columns of the books for the quarter
From the booksNet £
Sales day book26,300.00
Cash book: cash and card sales5,700.00
Cash book: art books sold, zero rated850.00
Sales returns day book600.00
Purchases day book14,350.00
Cash book: cash and card purchases1,650.00
Cash book: art books bought, zero rated410.00
Cash book: shop insurance, exempt380.00
Purchases returns day book480.00
Cash book: wages9,800.00
Cash book: drawings by the owner4,500.00

Box 6 is £26,300.00 plus £5,700.00 plus £850.00, less £600.00 of sales returns: £32,250.00.

Box 7 is £14,350.00 plus £1,650.00 plus £410.00 plus £380.00, less £480.00 of purchases returns: £16,310.00. The wages of £9,800.00 and the drawings of £4,500.00 are left out.

Northgate Framing: the finished return
Box£
16,280.00
20.00
36,280.00
43,062.00
53,218.00
632,250.00
716,310.00
80.00
90.00

Common mistakes

  • Putting gross sales in box 6. Box 6 excludes VAT.
  • Using the date the customer paid. Box 1 follows the date of the invoice.
  • Leaving zero rated sales out of box 6 because they have no VAT. They add nothing to box 1, but they are still sales.
  • Putting wages or drawings in box 7. Neither is a purchase of goods or services from a supplier.
  • Adding the VAT on credit notes. A credit note to a customer takes VAT out of box 1. A credit note from a supplier takes VAT out of box 4.

How to check your work

  • Box 3 is box 1 plus box 2, and box 5 is the difference between box 3 and box 4.
  • Box 5 agrees with the balance on the VAT account for the period. If it does not, something is missing or wrong in the books or in the return.
  • Boxes 6 and 7 hold no VAT, no wages and no drawings.

Box 6 is a quick check on box 1. If every sale carries VAT at the same rate, box 1 is that rate applied to box 6. When some sales are zero rated or exempt, box 1 is lower than that.

Practise it

Practise it nowOutput tax and input tax: which is which?

Words used here

VAT return
A VAT return is a summary of one VAT period: the VAT due on sales, the VAT reclaimed on purchases and the difference.
Output tax
Output tax is the VAT a business charges on its sales. It is owed to HMRC.
Input tax
Input tax is the VAT a business pays on its purchases and expenses. It can usually be claimed back from HMRC.
Day book
A day book is a book of prime entry that lists credit sales or credit purchases, one line for each invoice.
Cash book
The cash book records every receipt into the bank and every payment out of it. It is also the Bank account in the ledger.
Credit note
A credit note reduces what a customer owes. It is the opposite of an invoice.

Questions

Which boxes of a VAT return hold VAT?

Boxes 1 to 5. Boxes 6 to 9 hold the values of sales and purchases with the VAT left out.

Do zero rated sales go on a VAT return?

Yes. They add nothing to box 1, but their value goes in box 6 with the other sales.

Do wages go in box 7 of a VAT return?

No. Paying staff is not buying goods or services from a supplier, so wages are left out of box 7. So is money the owner takes out.

What if box 5 does not agree with the VAT account?

Something is missing or wrong in the books or in the return. Find the difference and put it right before the return is sent. A box is never changed just to make the two match.

Ledger Drill is practice, not tax or accounting advice. If this looks wrong, tell us at contact@mohbi.net.