POHODA XML
POHODA XML import of bank transactions (Banka 2.0)
An XML import pays off where statements are processed centrally or for several clients. Here is how a Banka record is created and what has to match in the XML for POHODA to take it.
2 min readUpdated
What the import file looks like
The file is a dataPack: an envelope with the company ID (IČO) of the target company containing one item per transaction. Each item holds a version 2.0 bank record with a header and summary.
- Transaction type: receipt or expense.
- The code of a bank account that exists in POHODA.
- Statement number and transaction order in the statement.
- Statement date and payment date.
- Variable symbol up to 10 characters, constant up to 4 and specific up to 16 characters.
- Transaction text and a note with the counterparty and reference.
Foreign currency in XML
For a foreign currency transaction, the currency, the foreign currency amount and possibly the rate and quantity are filled in instead of the CZK amount. VýpisFlow adds the CNB rate valid for the booking date when it is available.
Import steps
- In POHODA find the code of the bank account you will import into.
- In VýpisFlow choose POHODA XML and fill in the account code and company ID (IČO).
- Pass the downloaded file to POHODA XML import under a user with rights to the Banka agenda.
- Review the responsePack and check that all records were created.
When to choose XML and when Homebanking
Homebanking is simpler for one account and a regular monthly import. XML pays off for several clients, foreign currencies with the CNB rate and when you want to control the import process centrally.
Common XML import errors
XML import is stricter than Homebanking: a record that fails validation is not created, and you find the reason in the response.
- The company ID (IČO) in the envelope differs from the open company.
- The bank account code does not exist in the target company or is written differently.
- The importing user has no rights to the Banka agenda.
- The same file is imported twice; XML import creates the transactions again, so keep track of what has been loaded.
- Back up the company before the first import into a live company.
Frequently asked questions
Where do I find the bank account code?
In POHODA under Nastavení / Bankovní účty (Settings / Bank accounts). The XML uses the account abbreviation, not the account number at the bank.
Why does the import report a company ID error?
The company ID (IČO) in the dataPack envelope differs from the open company. Check which company you are importing into.
Does XML import match payments to invoices?
The import creates bank transactions. Matching them to documents happens in POHODA according to symbols and your settings.
Convert a statement
VýpisFlow converts PDF, CAMT.053, MT940, ABO/GPC, CSV and XLS into POHODA XML, GPC/ABO or MultiCash and checks the balances before download.
Open the statement converter