Data requirements
• Standard in use https://tools.ietf.org/html/rfc4180
• Character set can be any
• Column separator can be ; : , tab, space
• Column escape character is ” (quotation mark)
• Line break character can be any, usually \n
Other considerations
• It is a good idea to have a header row first in the data, which states the column names. Based on the header names, the columns can be automatically aligned when uploading the file.
• The non-standard separator row csv sep=? used by Microsoft is not possible.
• Number series and document number are only used in extended CSV import.
Specifications
-
1 in required means one of colums must be given.
|
Title (Finnish) |
Title (English) |
Type |
Length |
Required |
Example |
Description |
|---|---|---|---|---|---|---|
|
Numerosarja |
Number series |
String |
35 |
|
11 |
Receipt number series (prefix) |
|
Tositenumero |
Receipt number |
String |
35 |
Y |
11-123 |
Full Receipt number (prefix and number) |
|
|
|
|
|
|
|
|
|
Kirjauspäivä |
Booking date |
String |
10 |
Y |
1.1.2020 or 2020-01-01 |
Receipt booking date, Finnish or ISO 8601 format |
|
Vientiselite |
Entry description |
String |
210 |
|
January rent |
Entry description |
|
Tili |
Account |
Integer |
9 |
Y |
3000 |
Accounting account in the chart of accounts |
|
Kustannuspaikka |
Cost center |
Integer |
9 |
|
100 |
Cost center in the register |
|
Työnro |
Job number |
String |
35 |
|
P2020123 |
Job number in the register |
|
|
|
|
|
|
|
|
|
Alv-koodi |
VAT code |
Integer |
9 |
|
20 |
VAT code in the register |
|
Alv-% |
VAT-% |
Integer |
9 |
|
24 |
VAT percentage |
|
Alv-tili |
VAT account |
Integer |
9 |
|
29391 |
VAT account in the chart of accounts |
|
|
|
|
|
|
|
|
|
Veroton summa |
Tax-free amount |
Amount |
22 |
1 |
1240 or 1240.00 |
Entry amount without value-added tax |
|
Verollinen summa |
Taxable amount |
Amount |
22 |
1 |
1537.60 or 1537.6 |
Entry amount with value-added tax |
|
Alv summa |
VAT amount |
Amount |
22 |
|
297.6 |
Value-added tax amount |
|
Käsiteltävä alv |
Taxable VAT |
Amount |
22 |
|
297.6 |
Value-added tax amount for VAT declarations |
|
|
|
|
|
|
|
|
|
Tase-erittelyssä |
In balance sheet breakdown |
Enum |
1 |
|
Y or N |
Entry line included in balance sheet breakdown |
|
Tase-erittelykohde |
Balance sheet breakdown item |
String |
250 |
|
Rents |
Allocation information for breakdown |
|
Tase-erilltekykohdeteen nro |
Balance sheet breakdown item number |
Integer |
20 |
|
100 |
Allocation information for breakdown |
|
Tase-erittely ryhmä |
Balance sheet breakdown group |
String |
35 |
|
Depreciation |
Allocation information for balance sheet breakdown report |
|
Erittele aina |
Always break down |
Enum |
1 |
|
Y or N |
Entry is always broken down in balance sheet breakdown |
|
Erittelyselite |
Breakdown description |
String |
210 |
|
January rent |
Description for balance sheet breakdown report |