Transformation Process

Overview

Biatec.cz converts bank statements from various formats (CSV, XML, XLS, PDF) into standardized accounting formats GPC and SEPA XML (camt.053). The entire process consists of six steps, most of which are automated.

Processing steps

1 Uploading the file

The first step is to upload the bank statement to Biatec.cz. Supported input formats:

Format	File extensions	Examples of banks
CSV	.csv, .txt	Most banks, PayPal, Wise, GoPay, Adyen, Amazon, Cdiscount, Kaufland
XML	.xml, .ofx	GoPay, Tatrabanka (OFX 2.11)
XLS / XLSX	.xls, .xlsx	Some bank exports
PDF	.pdf	Raiffeisenbank CZ, Komerční banka

When uploading, select the file type that corresponds to your bank and format. System types are predefined and available to all users. You can also create your own file type with custom column mapping.

2 Automatic analysis

After uploading, the system automatically:

• Recognizes the file encoding (UTF-8, Windows-1250, ISO-8859-2)
• Detect the column separator (comma, semicolon, tab)
• Identify the header and data rows
• Maps columns according to the selected file type (date, amount, name, variable symbol, description, contra account)

3 Editing settings

In the preview of the uploaded file, you can edit:

• Column mapping — assigning CSV columns to transaction fields (date, amount, VS, description...)
• Contra account — selection of the column with the contra account number and optional generation of a virtual account
• Bank account — account number and IBAN for the output format
• Transaction filtering — filtering by date, transaction type
• Account rotation — Mod11 rotation for Pohoda (optional)
• Variable symbol formatting — method of processing the variable symbol (digits, convert, remap)

4 Transformation

After confirming the settings, click Transform. The system:

• Processes all transactions according to the mapping
• Groups transactions by year, month, and currency
• Assigns the correct bank account for each currency (if you have multi-currency accounts set up)
• Generates output files in all supported formats
• Validates the output (GPC structure, SEPA XML against the XSD schema)

5 Unlocking

The transformed file must be unlocked using credits. Once unlocked, you will gain access to download the output files and send them via email. The number of credits consumed depends on the number of transactions in the file.

6 Download

After unlocking, you can download the output file in one of three formats:

Output formats

Format	Accounting Systems	Standard	Description
GPC	Pohoda, Money S3	Czech banking standard	Text format with fixed column width. The most widely used format for Czech accounting systems. Supports account rotation (Mod11) for Pohoda.
SEPA XML SK	Slovak accounting systems	ISO 20022, camt.053	International XML format for Slovak banks. Includes Slovak IBAN and BIC codes.
SEPA XML CZ	Czech accounting systems, Pohoda	ISO 20022, camt.053	International XML format for Czech banks. Includes Czech IBAN and BIC codes. Ideal for import into POHODA.
CB.ua	BAS, 1C, M.E.Doc	1CClientBankExchange v1.03	Text format for Ukrainian accounting systems. Windows-1251 encoding, automatic transliteration of diacritics.

Send via email

After unlocking the transformed file, you can send the output file directly to an email address. This feature is useful if:

• You need to send a statement to your accountant
• You want to keep a backup in your email inbox
• You process statements for multiple clients

The email contains the transformed file as an attachment along with an overview of the number of transactions and the period.

Bulk Download

If you have multiple uploaded and unlocked files, you can use the Download All feature on the main page. The system will create a ZIP archive containing all output files in the selected format (GPC, SEPA SK, SEPA CZ, or CB.ua).