How does bank statement import work?
On Finance → Bank Import you upload the statement file from your bank (CAMT.053 XML or the bank's CSV export); with a connected bank the transactions arrive automatically. The system matches the entries to open invoices automatically, and you review and confirm the matches.
1. Upload the statement. Drag the file onto the upload area. Supported are CAMT.053 (XML) and the CSV exports of Raiffeisen, OTP, UniCredit, Erste and MBH Bank. The format is usually recognised; if not, pick it in the Bank / format list and click Process again.
2. Preview. After uploading you see the bank account, the period, the opening and closing balance and the number of entries. If the statement belongs to an account the system does not know yet, Register this account adds it right away. Entries imported before are recognised and left out, so overlapping periods do not create duplicates.
3. Automatic matching. After Start import the system tries to match the entries to open invoices. Amounts are compared within the tolerances set for the currency.
4. Review and apply. Open the import to review, accept or change the suggestions, match by hand, and finally record the cash movements on the invoices with Apply. The article "How does the matching session work?" has the details.
When the bank entry's currency differs from the invoice's, the system does not guess an exchange rate: the entry cannot be applied until you enter, in the Amount field of the panel on the right, what it is worth in the invoice's currency. Such an entry cannot be split across invoices: match it to a single invoice.
Automatic source. If you have connected your bank (Bank connections (Open Banking) on the Currencies page), transactions arrive by themselves three times a day, and every sync that brings new entries shows up in the list as its own import; for these the upload and preview steps are skipped.
Statuses in the list:
- Pending – no entry has been recorded or skipped yet.
- In progress – the system is matching or recording the cash movements right now.
- Partial – some entries are recorded or skipped, the rest are still open.
- Applied – every entry is recorded or skipped.
- Reverted – the import has been reverted.
Bank accounts and tolerances are set on the Currencies page, which you can also reach from the Bank Import page with Manage currencies. Skip Rules, Counterparty Mappings and Preferences open from there too. Importing needs the finance manage permission.