Import PostFinance statements into bexio with importly
importly recognizes PostFinance statements automatically. You download the file from E-Finance, drag it into the entries table – and importly already knows which format it is and what each column means.
Which files importly reads from PostFinance
| File | Description |
|---|---|
| Account statement CSV | The current format since February 2024 as well as all older variants |
| Credit card statement CSV | PostFinance Visa and Mastercard, including Business Card |
| camt.053 XML | The ISO 20022 statement, if you get it instead of CSV |
The language of the file doesn’t matter: importly understands German, French, Italian and English column headers. Accounts in CHF, EUR and USD are all recognized.
Step 1: Download the statement in E-Finance
- Log in to PostFinance E-Finance.
- Open the account whose transactions you want to post.
- Choose the export function for the account transactions and CSV as the format.
- Set the desired period and download the file.
The export contains a few header rows at the top with period, account number and currency. You don’t need to remove them – importly skips them automatically.
Step 2: Import the file into importly
- Open the entries table in importly.
- Drag the CSV file anywhere onto the page. The import opens automatically.
- importly shows you the detected format – for a PostFinance statement, PostFinance is at the top. If something doesn’t match, pick a different format in the Detected format field or create a new template via Create / edit template.
- Select your bank account from the chart of accounts, for example 1020.
- Check the preview and click Import.
If your table already contains rows, importly asks whether the new entries should be appended or the existing ones replaced.
What importly does with each column
For the current account statement format, importly maps as follows:
| Column in the statement | Field in importly |
|---|---|
| Datum | Date |
| Avisierungstext | Description |
| Gutschrift in CHF | Amount, bank account in Debit |
| Lastschrift in CHF | Amount, bank account in Credit |
| Bewegungstyp, Label, Kategorie | not imported |
The sign is resolved into debit and credit: when money comes in, your bank account is in Debit; when money goes out, in Credit. importly leaves the contra account empty – you set it in the table or through your rules.
For credit card statements, some of the columns are named differently and the date is in
the format 2024-08-24 instead of 24.08.2024. importly recognizes that automatically
too.
Adjusting document number and description
The two pattern fields in the import window let you decide what ends up in the description and document number. When you click into the field, importly suggests the available values as placeholders. importly remembers your setting for your next PostFinance import.
If something doesn’t work
importly doesn’t recognize the format Check that you actually downloaded the CSV file and not the PDF. importly cannot read PDF statements. If the file is correct and still nothing is recognized, you can send it to us directly from the import window – we’ll add the format.
Umlauts are displayed incorrectly Don’t open the file in Excel and don’t re-save it – import it exactly as you downloaded it. PostFinance delivers the file in an older character encoding that importly reads correctly – Excel often rewrites it when saving.
Rows are missing The export is limited to the selected period. Check the header rows of the file: they show the start and end. An import can contain at most 5,000 rows.
Amounts end up on the wrong side This happens when the wrong bank account was selected. The debit-credit decision depends solely on the sign in the statement and the selected bank account.