How do I use a template to generate my VAT Return?

We provide a standard spreadsheet template for HMRC returns. This template is in .ods format which should readable by an standard spreadsheet software include Excel and OpenOffice.

CSV template

Once the document is opened, you will see some fields that should be entered for your records, namely:

After this, please work down the fields in Column H to provide each of figures required for your VAT Return. Some of the cell (H11 and H13) are auto-calculated from the other fields, so these will be populated automatically. There are a couple of points to note when filling in column H:

After the spreadsheet has been completed, first save it as a normal spreadsheet in the format of your choice, .xls or .ods are the most common. After that save the file as a CSV (comma separated values). This is normally done by:

This will now be saved as (say) q3_2019.csv. This file is now ready to be imported.

Updated: Thu 12 Sep, 2019, 15:45