Bank statement reconciliation
A bank statement shows the family payment received yesterday. The receipt is already posted, so the next task is to match the statement evidence to that entry—not record the income again.
On this page
Import the statementMatch a statement rowCorrect a matchNo candidate appearsContinue withImport the statement
- Open Accounting > Banking and select Import statement.
- Choose the bank account and upload the statement file in the supported CSV layout.
- Review imported dates, descriptions, direction, amount and currency before matching.
| CSV column | Meaning |
|---|---|
| transaction_date, value_date | Transaction and value dates |
| description, reference | Bank narrative and payment reference |
| deposit, withdrawal | Amount on the appropriate side |
| currency | Statement currency |
| source_row_id | Stable source-row identifier for duplicate detection |
Match a statement row
If the transaction has not yet been recorded, prepare the correct receipt, payment or transfer first. Reconciliation identifies the evidence for a posting; it is not a shortcut for creating an unexplained journal.
- Open Reconciliation. Find the statement row using its date, reference and amount.
- Choose Match from the row actions and inspect the Candidate journal options.
- Confirm the journal belongs to the same bank account and represents the same transaction. Review the amount being reconciled before confirming.
- Check the updated reconciliation status and History.
Correct a match
Use Undo reconciliation when an authorized reviewer identifies a wrong match. The history remains available. Removing a match does not reverse the underlying receipt, payment or journal; correct that source separately if it is wrong.
No candidate appears
- Verify the selected bank mapping, currency, amount and date.
- Check that the source accounting document is submitted.
- Look for an existing match or duplicate imported row before importing the file again.