Skip to content

Import guide for your accountant — Abra Flexi CSV

Hand this document to your accountant together with the generated CSV file. It describes the procedure for importing the generic CSV (UTF-8 with BOM encoding, comma separator, RFC 4180) into the application Abra Flexi.

The CSV (Abra) option in Danito produces a generic CSV with the same header as the Generic CSV option — a file ready for the Abra Flexi import wizard. The VAT classification travels in the Rezim_DPH column as a symbolic regime name that you map to an Abra Flexi classification in the mapping step.

Prerequisites

  • A working installation of Abra Flexi with access to the web user interface.
  • A target accounting entity with the standard Czech chart of accounts for businesses.
  • The export file downloaded from Danito (name typically abra-RRRR-MM.csv or similar).

Import guide

  1. Log in to Abra Flexi (web UI) to the target accounting entity.
  2. Tools → Data import → Excel/CSV import (the exact menu item name may differ depending on the Abra Flexi version).

Placeholder for a screenshot.

  1. Select the exported .csv file and confirm that the wizard recognised:
    • the UTF-8 with BOM encoding (EF BB BF at the start),
    • the field separator , (comma, RFC 4180),
    • the line separator CRLF,
    • 20 columns with a header.
  2. In the column mapping step, assign the source CSV columns to the target Abra Flexi fields (table below). The wizard routes the row by the Typ_dokladu column into the appropriate agenda (Issued invoices / Received invoices / Internal documents).

Placeholder for a screenshot.

  1. Click “Import” and capture any warnings or errors (screenshot or exact text).

Placeholder for a screenshot.

Table of column mapping → target Abra Flexi fields

CSV column Target Abra Flexi field (suggestion)
Datum_plneni Date of taxable supply (datUcto / datPlnDPH)
Datum_vystaveni Date of issue (may remain empty — Abra Flexi fills it from Datum_plneni)
Typ_dokladu determines the target agenda (INVOICE → Issued invoices; COST_DOCUMENT → Received invoices; PLATFORM_INCOME → Internal documents)
Cislo_dokladu Document number
Protistrana_nazev Business partner — Company name
Protistrana_DIC Business partner — VAT ID (DIČ)
Protistrana_zeme Business partner — Country (ISO-3166-1 alpha-2 country code)
Mena_originalu Document currency
Zaklad_orig Tax base in the document currency
DPH_orig VAT amount in the document currency
Celkem_orig Total amount in the document currency
Kurz Currency exchange rate (for CZK = 1.000000)
Kurz_datum Rate date
Zaklad_CZK Tax base in CZK
DPH_CZK VAT amount in CZK
Celkem_CZK Total amount in CZK
Sazba_DPH VAT rate in per cent
Rezim_DPH VAT classification — symbolic regime name, remap to the Abra Flexi code (DOMESTIC_OUTPUT → UD, EU_B2B_OUTPUT → RE, THIRD_COUNTRY_OUTPUT → UR, REVERSE_CHARGE_OUTPUT_EU → RD)
Ucet_MD Debit account (MD)
Ucet_DAL Credit account (Dal)

Checks by agenda

a) Issued invoices

Documents of type INVOICE are imported into the Issued invoices agenda. For each randomly selected record, check that:

  • The business partner (company name, VAT ID (DIČ), country) matches the columns Protistrana_nazev, Protistrana_DIC, Protistrana_zeme.
  • The date of taxable supply matches the Datum_plneni column.
  • The VAT classification in the invoice header matches the regime from the Rezim_DPH column as remapped in the wizard (e.g. DOMESTIC_OUTPUT → UD, EU_B2B_OUTPUT → RE, THIRD_COUNTRY_OUTPUT → UR, REVERSE_CHARGE_OUTPUT_EU → RD).
  • The MD / D account in the accounting entry matches the Ucet_MD / Ucet_DAL columns (default for domestic output 311 / 602, or an override from the mapping editor in Danito).

b) Received invoices

Documents of type COST_DOCUMENT are imported into the Received invoices agenda. Regimes in the Rezim_DPH column: DOMESTIC_INPUT, REVERSE_CHARGE_INPUT_EU, REVERSE_CHARGE_INPUT_THIRD_COUNTRY, NON_VAT_PAYER_INPUT. The default accounting entry for domestic input 518 / 321.

c) Internal documents

Documents of type PLATFORM_INCOME (income from platforms) are imported as Internal documents. Check that:

  • The header has Datum_plneni filled in and Rezim_DPH NON_VAT_PAYER_OUTPUT (output from a non-payer).
  • Protistrana_nazev contains the name of the platform / operator; Protistrana_DIC is empty (platform income typically has no counterparty with a VAT ID (DIČ)); Protistrana_zeme contains the operator's country code.
  • The accounting entry reflects the stamped Ucet_MD / Ucet_DAL (default for platform income 311 / 602).

VAT check

For each VAT rate present in the export (0%, 12%, 21%), verify that:

  • Zaklad_CZK and DPH_CZK for rows with the 21% rate match the corresponding values in Danito.
  • Zaklad_CZK and DPH_CZK for rows with the 12% rate match Danito.
  • DPH_CZK is 0.00 for rows with a zero rate (reverse charge, outside the scope of VAT).

Diacritics

The CSV is in UTF-8 with BOM encoding (the first 3 bytes EF BB BF). Open a random record with Czech diacritics in Abra Flexi and verify:

  • Business partner displays everything without lost characters (no ? nor empty spaces in place of háčky / čárky).
  • Document number displays including uppercase letters with a háček (e.g. Š, Č, Ž).

UTF-8 universally covers the Czech alphabet, but it is worth verifying that the import wizard has not mixed up the BOM with the start of the first column (in which case the first header column is displayed as Datum_plneni with three invisible characters before D).

Foreign-currency documents

Documents with a Mena_originalu other than CZK carry the exchange rate and rate date. After import, verify that:

  • Mena_originalu, Kurz, Kurz_datum are displayed in the document header.
  • Base / VAT / Total in the document currency (Zaklad_orig, DPH_orig, Celkem_orig) match the original amounts in Danito.
  • Base / VAT / Total in CZK (Zaklad_CZK, DPH_CZK, Celkem_CZK) match the amounts converted at the given exchange rate.

What to do on an import error

If Abra Flexi reports an error during import or one of the checks above fails, record:

  • The path to the field in Abra Flexi (e.g. Issued invoices → Header → VAT ID (DIČ)).
  • The expected value (from the corresponding CSV row or from Danito).
  • The value imported into Abra Flexi.
  • The Abra Flexi version (e.g. Abra Flexi 2026.1.0) and the database type.
  • Any Abra Flexi error message (code + text).

Placeholder for a screenshot of the error message.

Send this information to the Danito user, who will pass it on to support. For typical errors (an incorrectly set agenda, an account not existing in the chart of accounts, an incorrectly mapped column) the fix is in the Abra Flexi chart of accounts or in the account mapping editor in Danito.