Import Statements (under Banking) lets you upload a bank statement file and turn its rows into transactions, instead of typing each one by hand.
Step 1 — Upload File
- Click Import New Statement.
- Select Bank Account (required) — the account this statement belongs to. Only active accounts are listed.
- Drag & drop the file or click to browse. Accepted: CSV or Excel (.xlsx, .xls), max 10 MB. For Excel files, the first sheet is read.
- Click Next: Map Columns.
Step 2 — Map Columns
- Header row detected at row — the app finds the row with column names (bank files often have a few lines of text above it). Pick a different row if the guess is wrong.
- Payment Date (required) — the column that holds the transaction date.
- Debit / Credit — the money out and money in columns. At least one is required.
- Narration and Reference Number — optional.
- Date Format (required) — how dates are written in your file, e.g. dd/MM/yyyy, MM/dd/yyyy, yyyy-MM-dd, dd-MM-yyyy, dd MMM yyyy or MMM dd, yyyy.
- Preview — shows the first 3 rows after the header so you can check the mapping.
- Save this mapping — ticked by default. Next time you import for the same bank, the columns and date format are filled in for you.
Click Import Statement. Rows with a missing or invalid date, or a missing or unreadable amount, are saved as Error rows. Currency symbols and thousands separators in amounts are ignored.
Review the Rows
Click the file name or the eye icon to open an import. The badges at the top (Total, Submitted, Pending, Errors) count the rows — click one to show only those rows, and click it again to show all.
- Account — for each pending row, choose the GL account. The list only shows accounts that fit the row: money out shows Asset and Expense accounts, money in shows Income, Liability and Equity accounts.
- Party — optional.
- ⇄ Bank Transfer — choose this at the top of the Account list when the row is money moving to or from another of your own accounts, then pick the other bank.
- Suggestions — when you tick a row, a small coloured dot appears next to its Account. Hover it to see a suggested account, matched from your earlier transactions or from the narration. The suggestion is not filled in for you.
Submit to Transactions
- Tick the rows you want to submit. A bar appears where you can set one Account and Party (or Transfer Bank) for all ticked rows and click Assign & Review.
- Or click Submit {n} Rows at the top to go straight to the review.
- In Review & Submit, rows are grouped by account. You can still change accounts here. Rows under No Account Assigned (cannot submit) are skipped.
- Click Submit {n} Rows to Transactions.
Each submitted row becomes a transaction on the import's bank account, with the row's date, amount, narration and reference. Bank transfer rows create a linked transfer. Submitted rows show Imported with a link to the transaction. When no pending rows are left, the import's status changes from Pending to Imported.
Managing Imports
- Date range — the list shows imports made between the two dates.
- Download — get the original file you uploaded.
- Delete a row — the trash icon removes one row. Delete all error rows removes every error row at once.
- Delete an import — removes the import and its file. Transactions already submitted from it are kept.