Appearance
Import a bank statement
FinanceBank statementsStatement importPermission:
finance.bank_statement.viewOpen in Roari ERP (new tab)Also known as
- import bank statement
- upload statement
- CSV
- OFX
- bank export
- column mapping
- date format
- decimal comma
- duplicates
- bank feed
The import reads the CSV export of your online banking into a statement in three steps: File → Columns → Preview. The column mapping is saved per bank account, so next month you only drop the file and confirm.
Import a statement
- Go to FinanceBank statements and select Import statement.
- File: choose the Bank account and drop the file on Drop a CSV export here or browse (CSV or OFX-style CSV, up to 10 MB). File sample shows the first rows. Select Next.
- Columns: check how the file is read (table below) and map each column. Use a heading from the file or a column number. Select Preview.
- Preview: check the period, the number of new lines ("… new lines"), the Net movement, the opening and closing balance and the first lines. Rows that could not be read are listed with their row number.
- Leave Save this mapping for the bank account on, then select Import … lines (the button shows the count). The new statement opens ("Imported BST-…").
| Setting (Columns step) | What to enter |
|---|---|
| Delimiter | Comma, semicolon or tab. |
| Date format | For example dd/MM/yyyy, MM/dd/yyyy, dd.MM.yyyy, yyyy-MM-dd, or auto. |
| Decimal separator | . or , (for example German exports use ,). |
| Rows to skip before the headings | Bank banners above the table, 0–50. |
| First row has headings | Clear it when the file has no heading row; then map by column number. |
| Invert signs | When the bank exports money out as positive amounts. |
| Date | Required. |
| Amount (signed) | One signed amount column, or Debit (money out) and Credit (money in). |
| Description, Reference | At least one of them. |
| Counterparty, Running balance | Optional. A balance column gives the opening and closing balance. |
| Opening balance | "Leave empty to continue from the previous statement or the balance column." |
| Name | An optional name for the statement. |
Duplicates
Lines already imported for the account (same date, amount, reference and description) are skipped: "3 lines were imported before and are skipped". Select Import them anyway only when the bank really has two identical transactions. "No transactions were read with this mapping." means the mapping does not fit the file.
Differences by role
- Importing needs Permission:
finance.bank_statement.import.
