Instructions for uploading files – VAT special scheme (Mini One Stop Shop)
You can use your own file to submit the requested data for the VAT period. You must specify the data in the order given in the example file below.
The file must be in CSV format (*.csv). For example, you can save your file as CSV in Excel. If the file you are going to upload is not an Excel file, please make sure to use semicolons (;) for separator characters between data elements.
Example file:
| A | B | C | D | E | F | G | H |
| 1 |
FI12345678 |
AT | 1 | 20 | 10 000 | 2 000 | |
| 2 |
FI12345678 |
BE | 1 | 20 | 10 000,00 | 2 000,00 | |
| 3 |
FI12345678 |
BG | 1 | 20 | 15 123,23 | 3 024,65 | |
| 4 |
FI12345678 |
DK | 1 | 20 | 22 311,00 | 4 462,20 | |
| 5 |
FI12345678 |
PL | 1 | 20 | 34 223,00 | 6 844,60 | SE12345678 |
| 6 |
FI12345678 |
FR | 1 | 20 | 5 033,00 | 1 006,60 | SE12345678 |
| 7 |
FI12345678 |
DE | 1 | 20 | 1 313,00 | 262,60 | EE87654321 |
| 8 |
FI12345678 |
EL | 1 | 20 | 300,00 | 60,00 | EE87654321 |
| 9 |
FI12345678 |
HU | 1 | 20 | 10 011,00 | 2 002,20 | EE87654321 |
| 10 |
FI12345678 |
IE | 1 | 20 | 10 012,00 | 2 002,40 | EE87654321 |
| 11 |
FI12345678 |
IE | 1 | 10 | 100 | 10 | EE87654321 |
Columns:
| A |
Consecutive row number. |
| B |
The VAT number by which the company is registered in the VAT special scheme. The number either has the format FInnnnnnny (where nnnnnnny is the Finnish Business ID without the hyphen) or EU246nnnnnnnn. |
| C |
The code of the Member State of consumption (EU Member State other than Finland). Check the list of VAT numbers issued by different EU countries. |
| D |
Type of VAT rate. |
| E |
The VAT rate at which the service was sold. Do not use more than two decimals. Separate the decimals with a comma, not a dot. |
| F |
Tax basis |
| G |
Amount of tax |
| H |
If the sale involved a permanent establishment, enter its code in the column. Leave column H empty if you have had no sales from permanent establishments. If your CSV file contains a new permanent establishment, add the establishment’s details after you have uploaded the file but before you submit the return. |
|
Columns A–G are mandatory. |
|
In the example, file the company reports the following sales:
-
From Finland to Austria, Belgium, Bulgaria and Denmark (rows 1–4)
-
From a permanent establishment in Sweden (SE12345678) to Poland and France (rows 5–6)
-
From a permanent establishment in Estonia (EE987654321) to Germany, Greece, Hungary and Ireland. On rows 10 and 11, the sales to Ireland are specified separately according to the standard and the reduced VAT rate.
After you have uploaded a file to MyTax, you will see a summary of the uploaded details in the next stage of the return. If there are errors, correct them before you submit the return.
You can correct erroneous rows in two ways:
- Correct the rows in the CSV file and upload it again.
- Correct the erroneous details directly in the return. You can edit the details in MyTax up until you submit the return.
If you want to make corrections to details you have already submitted, file a replacement return in MyTax. In practice, this means that you change details on a return you have filed previously in MyTax and submit the return again. You will not be able retrieve data from a file for a replacement return.