Skip to content

Import guide for your accountant — Generic CSV

Hand this document to your accountant together with the generated CSV file. The generic CSV is a vendor-neutral format with 20 columns and a canonical header, UTF-8 with BOM encoding, a comma separator, per RFC 4180. The file is suitable for manual processing in a spreadsheet program (Excel, LibreOffice Calc) or for manual mapping into any accounting program that supports CSV import (Pohoda, Money S3, Abra Flexi and others).

File structure

The file has 20 columns in this order (canonical header):

Order Column Description
1 Datum_plneni Date of taxable supply (ISO 8601, RRRR-MM-DD)
2 Datum_vystaveni Date of issue (ISO 8601, RRRR-MM-DD) — may be empty
3 Typ_dokladu INVOICE (issued invoice) / COST_DOCUMENT (received cost) / PLATFORM_INCOME (platform income)
4 Cislo_dokladu Document number (internal, from Danito)
5 Protistrana_nazev Business partner — company name
6 Protistrana_DIC Business partner — VAT ID (DIČ) (may be empty)
7 Protistrana_zeme Business partner — ISO-3166-1 alpha-2 country code (e.g. CZ, DE)
8 Mena_originalu Document currency (ISO 4217, e.g. CZK, EUR, USD)
9 Zaklad_orig Tax base in the document currency
10 DPH_orig VAT amount in the document currency
11 Celkem_orig Total amount in the document currency
12 Kurz Currency exchange rate against CZK (for CZK = 1.000000)
13 Kurz_datum Rate date (ISO 8601, RRRR-MM-DD)
14 Zaklad_CZK Tax base in CZK
15 DPH_CZK VAT amount in CZK
16 Celkem_CZK Total amount in CZK
17 Sazba_DPH VAT rate in per cent (e.g. 21.00, 12.00, 0.00)
18 Rezim_DPH Symbolic VAT-mode code (DOMESTIC_OUTPUT, EU_B2B_OUTPUT, THIRD_COUNTRY_OUTPUT, DOMESTIC_INPUT, REVERSE_CHARGE_INPUT_EU, REVERSE_CHARGE_INPUT_THIRD_COUNTRY, REVERSE_CHARGE_OUTPUT_EU, OUTSIDE_SCOPE_THIRD_COUNTRY, NON_VAT_PAYER_INPUT, NON_VAT_PAYER_OUTPUT)
19 Ucet_MD Debit account (MD)
20 Ucet_DAL Credit account (Dal)

Procedure A — opening in a spreadsheet program

Excel

  1. In Excel, Data → From Text/CSV (or File → Open → Browse → CSV (*.csv)).

Placeholder for a screenshot.

  1. Select the exported .csv file.
  2. In the Load data dialog, confirm:
    • File origin: 65001: Unicode (UTF-8),
    • Delimiter: Comma,
    • Data type detection: based on the first 200 rows.
  3. Click Load (or Load To, if you need to select a target sheet).

Placeholder for a screenshot.

Excel can automatically convert the 20 columns into a table. The Cislo_dokladu column may be detected as a number — in that case convert it to text, so that leading zeros are preserved.

LibreOffice Calc

  1. File → Open and select the exported .csv.
  2. In the Text Import dialog, confirm:
    • Character set: Unicode (UTF-8),
    • Separator: Comma,
    • Text delimiter: ".

Placeholder for a screenshot.

  1. In the preview at the top, set the column type of Cislo_dokladu to Text (so that leading zeros and punctuation are preserved).
  2. Click OK.

Procedure B — manual mapping into a vendor accounting program

If you use an accounting program that has a CSV import wizard (e.g. Pohoda, Money S3, Abra Flexi or any other), use the following recommended mapping. The vendor VAT-breakdown code list differs — Rezim_DPH from the generic CSV is symbolic (e.g. DOMESTIC_OUTPUT); the accountant must manually remap it to the vendor code.

Pohoda — manual mapping (fallback without Pohoda XML)

If for some reason the Pohoda XML cannot be deployed directly, import the generic CSV via File → Data communication → CSV import.

  • Datum_plneni → Date of taxable supply
  • Datum_vystaveni → Date of issue
  • Cislo_dokladu → Document number
  • Typ_dokladu → determines the target agenda (INVOICE → Issued invoices; COST_DOCUMENT → Received invoices; PLATFORM_INCOME → Internal documents)
  • Protistrana_nazev, Protistrana_DIC, Protistrana_zeme → Business partner
  • Zaklad_orig, DPH_orig, Celkem_orig, Mena_originalu, Kurz, Kurz_datum, Zaklad_CZK, DPH_CZK, Celkem_CZK → amounts
  • Sazba_DPH → VAT rate (in per cent)
  • Rezim_DPH → VAT classification — remap the symbolic code to the Pohoda code (e.g. DOMESTIC_OUTPUT → UD, EU_B2B_OUTPUT → RE, THIRD_COUNTRY_OUTPUT → UR)
  • Ucet_MD, Ucet_DAL → MD / D account

Money S3 — manual mapping (fallback without Money S3 XML)

File → Tools → CSV import (the menu item name may differ).

  • The field mapping is analogous to Pohoda — only remap the symbolic Rezim_DPH to the Money S3 code (DOMESTIC_OUTPUT → UD, EU_B2B_OUTPUT → DD, THIRD_COUNTRY_OUTPUT → VS, NON_VAT_PAYER_OUTPUT → UN).

Abra Flexi — manual mapping

Tools → Data import → Excel/CSV import.

  • The CSV (Abra) option produces the same file; remap the symbolic Rezim_DPH to the Abra Flexi code (DOMESTIC_OUTPUT → UD, EU_B2B_OUTPUT → RE, THIRD_COUNTRY_OUTPUT → UR, REVERSE_CHARGE_OUTPUT_EU → RD).

Post-import checks

Regardless of the import path (Excel / LibreOffice / vendor CSV wizard), check on randomly selected rows that:

  • The business partner (company name, VAT ID (DIČ), country) matches Danito.
  • The date of taxable supply matches Danito.
  • The VAT classification is correctly remapped to the vendor code (if you use a vendor wizard) or remains as the symbolic code (if you read the CSV directly in a spreadsheet program).
  • The MD / D account matches the mapping in Danito (default according to the chart of accounts: domestic output 311 / 602, domestic input 518 / 321, platform income 311 / 602).
  • The amounts in the document currency and in CZK match Danito.

Diacritics

The CSV is in UTF-8 with BOM encoding. If the diacritics display as corrupted (?, Ž?, Žluťoučký etc.), the problem is in the choice of encoding in the import dialog — always select UTF-8 (or 65001: Unicode (UTF-8) in Excel).

What to do on an error

If the import dialog reports an error or one of the checks above fails, record:

  • The path to the field in the target program where the value does not match.
  • The expected value (from the corresponding CSV row or from Danito).
  • The value imported into the target program.
  • The target program's version and the database type.
  • Any error message.

Placeholder for a screenshot of the error message.

Send this information to the Danito user, who will pass it on to support.