Import & reconciliation
Import and reconciliation
Statement list
The Bank statements page lists all imported CAMT.053 files with filters:
| Filter | Description |
|---|---|
| IBAN | Filter by account number |
| Date from / to | Statement date (dd.mm.yyyy) |
| Year | Fiscal year |
Table columns: File name / Statement ID, IBAN, Date, Opening balance, Closing balance, Matched entries, Total entries.
Importing CAMT.053
Click Import statement and select an XML file in CAMT.053 format. The system parses the file and creates a record with all entries.
Statement detail
Clicking a statement opens the detail page with a full entry table and filters:
| Filter | Options |
|---|---|
| Match status | All / Unmatched / Auto-matched / Manually matched / Ignored |
| Search | By reference, counterparty name… |
Entry table columns:
| Column | Description |
|---|---|
| Date | Booking date |
| Amount | Amount and currency |
| Counterparty | Name and IBAN of the other party |
| Payment reference | Reference from the bank entry |
| Status | Unmatched / Auto / Manual / Ignored |
| Linked invoice | Link to outbound or inbound invoice if matched |
| Actions | See below |
Automatic matching
The Auto-match button runs an algorithm that compares payment references and amounts between bank entries and open invoices. A toast notification shows the number of entries matched.
Manual matching
For an Unmatched entry click the link icon (🔗). A search modal opens:
- Toggle between Outbound invoices and Inbound invoices
- Search by invoice number, partner, payment reference, or amount
- Results table (15 rows per page) with columns: Invoice number, Partner, Date, Payment reference, Amount, Remaining
- Automatically record payment on invoice checkbox — when checked, a payment record is also created on the linked invoice
Click Confirm to save the match and set the status to Manually matched.
Ignoring entries
For entries that don’t need reconciling (e.g. bank fees, commissions) click the eye-off icon (👁️). The entry is set to Ignored and excluded from the match count.
Undoing a match
Click the broken-link icon on a matched entry to reset it to Unmatched. The same action is available for ignored entries.
Match statuses
| Status | Description |
|---|---|
| Unmatched | Entry awaiting reconciliation |
| Auto-matched | Matched by the automatic algorithm |
| Manually matched | Matched by a user |
| Ignored | Intentionally skipped |