DIY Accounting Submit

How to file a VAT return from a spreadsheet

Send the nine boxes from your spreadsheet to HMRC under Making Tax Digital

Submit sends the nine boxes of your VAT return to HMRC. You keep your records in your own spreadsheet, work out the boxes there, and enter the figures here. HMRC sends back a receipt with a Form Bundle Number.

File a VAT return

What you need before you start

The steps

  1. Ask HMRC

    Screenshot: Ask HMRC

    Type the VAT registration number. Then the stretch of time to look at.

  2. The periods on file

    Screenshot: The periods on file

    HMRC answers with every period it holds. An open period is still waiting for a return.

  3. Start the return

    Screenshot: Start the return

    Start a return for that open period.

  4. Box 1, VAT on sales

    Screenshot: Box 1, VAT on sales

    Box 1 is the VAT due on your sales.

  5. Box 2, usually zero

    Screenshot: Box 2, usually zero

    Box 2 is VAT on EU acquisitions, usually zero now.

  6. Box 3 adds it up

    Screenshot: Box 3 adds it up

    Box 3 adds boxes 1 and 2 for you.

  7. Box 4, VAT reclaimed

    Screenshot: Box 4, VAT reclaimed

    Box 4 is VAT you can reclaim on purchases.

  8. Box 5, the net total

    Screenshot: Box 5, the net total

    Box 5 works out what you owe overall.

  9. Box 6, total sales

    Screenshot: Box 6, total sales

    Box 6 is your total sales, without VAT.

  10. Box 7, total purchases

    Screenshot: Box 7, total purchases

    Box 7 is your total purchases, without VAT.

  11. Boxes 8 and 9, EU trade

    Screenshot: Boxes 8 and 9, EU trade

    Boxes 8 and 9 cover EU trade, usually zero now.

  12. Confirm the declaration

    Screenshot: Confirm the declaration

    Tick the declaration to confirm the return is accurate.

  13. Authorise again

    Screenshot: Authorise again

    Submitting needs a wider grant, so HMRC asks once more. Sign in to HMRC and say yes again.

  14. Submitted

    Screenshot: Submitted

    HMRC confirms the return is filed. The receipt is your record that it went through.

  15. Read back what you filed

    Screenshot: Read back what you filed

    Back to the activities, to read the return you filed.

  16. Open View VAT Return

    Screenshot: Open View VAT Return

    Open the return you have just sent.

  17. Choose the period

    Screenshot: Choose the period

    Then the period you filed.

  18. Ask HMRC for the record

    Screenshot: Ask HMRC for the record

    Ask HMRC for the return on file.

  19. HMRC sends the record

    Screenshot: HMRC sends the record

    HMRC sends back the return as it holds it.

  20. Your record, as submitted

    Screenshot: Your record, as submitted

    This is your record: the totals and the declaration, as submitted.

Watch the video: How to submit a VAT return under MTD.

Price

The Resident VAT bundle covers this filing and costs £9.99 a year or £0.99 a month.

The day pass is free and gives you 3 submissions to try it first.

When it is due

Every VAT-registered business sends its returns to HMRC through Making Tax Digital software.

Businesses need to have signed up to Making Tax Digital for their first VAT return starting on or after 1 April 2022.

See every date on the MTD calendar.

Ready to file

File a VAT return

Other filings

Each filing and the channels that offer it are in the availability table.