CSV - Import - Accounting Receipt
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 |