ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Can't edit? (How to use it)
2
Get our Free Add-on for Google Spreadsheets to file your VAT return from this spreadsheet.Make a copy
3
1VAT due on sales and other outputs0.00Just go to File and select ‘Make a copy’ from the menu
4
2VAT due on acquisitions of goods made in Northern Ireland from EU Member States0.00
5
3Total VAT due (sum of boxes 1 and 2)0.00
6
4VAT reclaimed on purchases and other inputs (including acquisitions from the EU)0.00
7
5Net VAT to be paid or reclaimed (difference between boxes 3 and 4)0.00
8
6Total value of sales and other outputs (excluding VAT)0
9
7Total value of purchases and other inputs (excluding VAT)0
10
8Total value of supplies of goods and related costs (excluding VAT) to EU Member States0
11
9Total value of acquisitions of goods and related costs (excluding VAT) from EU Member States0
12
To learn more about calculating VAT, visit GOV.UK
13
14
Please note:
To use this template for filing a VAT Return, you'll need to make sure that it
contains all of your transactions from the current period.

A recent change in the MTD process means that this spreadsheet will be
referenced as your VAT Records as well as using the values in the 9 boxes.
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100