Business case
Instead of retyping account movements, you upload an electronic bank statement as PDF. The application processes it server-side, recognises the statement structure, and creates lines (date, amount, payment reference text, counterparty, and so on). You then match each line to business records in the system:
- Incoming payments: you typically select a client and one or more open invoices the payment covers.
- Outgoing payments: you select a supplier and link to open expenses where appropriate.
The bank statement list is the overview: history of imported statements, processing status, available balances per bank where the UI shows them, opening all lines of one statement, downloading or previewing the original PDF, and working on lines that still need attention.
Automation speeds up capture, but business control (correct pairing, currency, taxes, internal rules) remains with users and approvers.
Where to find it and access
- Open the CRM area in the menu. You will usually see two related items: for import / matching and for the statement list (exact labels and icons depend on your language pack).
- The pages correspond to /crm/bankstatementimport (import and matching grid) and /crm/bankstatementlist (list and unresolved lines).
- If you cannot see the entries or you get a no-access message, you need specific permissions—contact your organisation’s administrator.
Bank statement list
Use this screen to review all statements loaded for your company.
Summary cards
Above the grid, cards often appear per bank, showing for example available balance, currency, statement date, and sometimes a link to preview the source document. There may also be a card with totals by currency when that summary is enabled.
Search and filters
- A text search box and date from / to range.
- In Statements mode: extra filters for banks (multi-select), statement type (for example domestic, foreign currency, card—wording on screen), and processing status (such as new, ready for processing, in progress, failed, completed).
- Click Search. Clear resets filters.
Two view modes
- Statements — a table of all statements (bank, type, statement number, date, opening and available balance, line count, processing status, creation timestamp).
- Unresolved lines — individual transaction lines that still need work (bank, statement, date, sequence fields, debit / credit, counterparty). Search in this mode may use a different placeholder in the product.
You can sort columns where arrows are shown. Use paging and optional rows per page.
Actions on one statement (typically in Statements mode)
- Reprocess (Rerun) — runs processing again, for example after correcting the bank name or statement type. If some lines are already linked to payments, the app may show a warning before you confirm.
- Statement lines — opens a dialog with all lines for that statement; each line shows amounts, description, counterparty, and whether it is resolved; you can sort inside the dialog.
- Download and Preview the statement PDF.
- Edit (if permitted) — for example bank name and statement type on the row.
- Delete a single statement (if your role allows), with confirmation.
Selection and bulk actions
On desktop, select statements with checkboxes; you can select all rows on the page or manage a wider selection from the banner above the grid where available. The Select / bulk-actions dropdown usually offers reprocess for the selection and, with the right permission, delete multiple statements at once.
Unresolved lines
In that view, each line typically has actions such as opening statement lines, downloading, and previewing the PDF so you can compare with the source document quickly.
Import and matching
The import page is where you submit PDF statements and link extracted lines to CRM documents.
What you can upload
- PDF files only, up to 10 MB each.
- You may pick several PDFs in one go. If you send ten or more files in one batch, the app shows a warning that processing usually continues in the background; monitor progress and final status on the statement list.
- The system tries to verify that each file is really a bank statement. Files that fail that check may be reported as rejected—use the correct export from your bank or contact support if you believe the file is valid.
Your organisation can also turn on inbound email for bank statement PDFs from Company administration → CRM Settings, so forwarded messages with PDF attachments enter the same processing flow. See CRM — turn on email import for bank statements and expense invoices.
Steps after you click upload
- In the dialog, choose one or more PDF files and confirm. Files are stored securely and processed server-side (this can take time; large batches may continue in the background).
- When processing finishes (or while background work runs), new or updated statements appear on the statement list with the appropriate status.
Existing statements
A button opens a picker of statements already in the system. You can filter by text (bank, number, file name) and date range, sort, select one or many, and load them into this working session without uploading the PDF again from disk.
Clear
Removes the temporary loaded rows from the current page session (it does not delete statement history in the system).
Matching grid
For each statement line the table typically shows:
- Row number / reference on the statement, date, and direction: incoming vs outgoing—often green and red directional icons.
- A column with payment text / counterparty; there may be buttons for full text and copy to clipboard.
- The amount (debit or credit depending on direction).
- For incoming: client and open invoices (multi-select). For outgoing: supplier and open expenses.
- An indicator of how much of the line amount is covered by selected documents (for example ratio / progress bar).
- Save for that row when you are happy with the match; successful saves may mark the row visually as processed. A Save all button in the grid header attempts to save all ready rows in one step.
Grid filters
When data is loaded, narrow the view with text, statement number, and type (incoming/outgoing), then Search or Clear filters.
Summary below the grid
Often shows row counts and total debit/credit for the currently filtered set—useful for quick reconciliation.