ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
INSTRUCTIONS
2
To use this spreadsheet, you need to make your own copy, you cannot edit the central copy. Select 'File' in the top left, then 'Make a copy'. You will need a google account to save your own copy.
3
If you do not have a google account it is free to create one, alternatively this spreadsheet can be used as the template for your own spreadsheet in any application.
4
Use a separate spreadsheet for each foreign property. Use one spreadsheet per foreign property per tax year - figures are submitted separately for each property (for tax years prior to 2026/27 one spreadsheet per country should be used, rather than one per property).
5
This spreadsheet is for Foreign Property income. Other sheets are provided for Self-Employment and UK Property. The correct spreadsheet should be used, as they all use different categories.
6
The updates you submit to HMRC are cumulative, so keep using the same spreadsheet for the entire tax year and submit the totals for the year-to-date each quarter.
7
8
Using The Spreadsheet
9
Enter income and expenses in the 'Income' and 'Expenses' sheets.
10
Income and expenses should both be entered as positive numbers.
11
Include the date and amount of each transaction, and select the category from the dropdown menu.
12
If you have unused residential finance costs brought forward from previous years enter them in the 'Finance Costs Bfwd' sheet.
13
Each quarter, download the 'Download' sheet as a csv file, then upload it at taxupdates.co.uk. To download, first ensure you are on the 'Download' tab. Then go to 'File' -> 'Download', and select 'Comma Separated Values .csv' as the file type.
14
Alternatively, create a csv file at https://csv-download.o.uk using the data in the 'Download' sheet
15
Upload your csv file at https://taxupdates.co.uk for submission to HMRC.
16
17
Adapting The Spreadsheet
18
You are welcome to adapt this spreadsheet in any way you like.
19
This spreadsheet doesn't take VAT into account. If you are VAT registered amounts should be entered net of VAT.
20
If you mess up, create a new copy and start again.
21
Don't change or add categories - the categories included are the only ones allowed by HMRC. It's fine to remove unused categories if you want to.
22
23
Disclaimer
24
This spreadsheet is provided as a tool to help organise information and perform calculations. No guarantee is given that the calculations produced by this spreadsheet are correct or suitable for your specific circumstances. You are responsible for ensuring the figures submitted to HMRC are correct and you should seek professional advice if you are unsure about your tax obligations.
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