How do I reconcile the bank month by month?
The Monthly reconciliation screen shows the twelve months of a bank account: how many lines the statement has, how many are still to be resolved and the bank balance at month end against the books. When a month adds up, you close it, and its minutes are kept.
What do I need before I start?
- The month's statement in the ERP. For past months, load it from the bank's file: the bank balance at month end comes from that file.
- The bank account paired with a treasury account that has its ledger account (that bank's 572). Without it there is no book balance to compare with.
How do I do it?
- Go to Treasury and click Monthly reconciliation.
- Choose the account and the year.
- On the month in question, click Reconcile. Bank reconciliation opens with that month's lines.
- Resolve the lines: accept suggestions, reconcile, compose collections or discard what has no counterpart.
- Go back to Monthly reconciliation. When the month shows “Ready to close”, click Close the month and confirm.
What does each status mean?
“No statement”: there are no lines for that month and no file covers it.
“In progress”: something is missing before closing. Below the month it says what: the statement does not cover the whole month, there are unresolved lines or the account is not paired.
“Ready to close”: the statement covers the month, all its lines are reconciled or discarded and there is a book balance to compare with.
“Closed”: the month has its minutes. Its lines can no longer be unreconciled, and no new lines for that month are loaded.
What if the book balance is not the bank's?
The Difference column shows it in red. You can still close, but you have to write why (a bank charge not yet booked, a collection posted to another account…). The explanation is kept in the month's minutes.
The usual thing is to correct the books and close without a difference; the explanation is for what gets fixed later.
How do I use a reconciliation proposal?
When a month has many lines, you can prepare outside the screen what to do with each one —for example, matching them against the sheets where you track a programme's payments or payments to collaborators— and bring it back to confirm it in one go.
- On the month, click Export. A CSV file is downloaded with each unresolved line and the candidates the ERP sees (movements, batches, settlements or the customer's bills, with their score).
- Prepare the proposal: a CSV with the columns
linea;accion;ids;motivo;confianza.lineais the line number from the exported file.accionisaceptar(the ERP's suggestion),movimiento,remesa,liquidacion(with its number inids),cobro(the bill numbers inids, separated by commas) ordescartar(with the reason).confianzaisalta,mediaorbaja.
- Click Reconciliation proposal (CSV) and choose the file. The screen shows each row with what it would do and why. Rows that cannot be applied show in grey with the reason: the line is already resolved, does not exist or the row is badly written.
- Click Tick the high-confidence ones, review and tick or untick as you wish.
- Click Apply the ticked ones. Each line is resolved separately, just as in Bank reconciliation; if one fails, the rest go on, and the Result column says how each one went.
Nothing is applied without ticking it: the proposal is a help, the decision is still yours.
How do I reopen a month?
Click Reopen on the closed month and write the reason. The month goes back to “In progress” and the reason, with your name and the date, is kept in its minutes. When you close it again, the minutes are updated with the new figures.
If something goes wrong
| What you see | What has happened | What to do |
|---|---|---|
| “The statement does not cover the whole month…” | Some day of the month is missing from the loaded files | Load the file for that month |
| Bank balance shows “—” | No loaded file reaches the last day of the month | Load the file that covers it |
| Book balance shows “—” | The account has no ledger account, or there is no accounting year for that date | Pair the account in Bank connections or check the accounting years |
| “Month … is closed in the reconciliation…” when undoing a line | That line belongs to a closed month | Reopen the month in Monthly reconciliation |
| A file will not load because of a closed month | The file brings new lines for that month | Reopen the month, load and close it again |
See also: Load the statement from a file · Reconcile the bank transactions
More about Banks
- How do I use my spreadsheets to reconcile the bank?
- How do I load the bank statement from a file?
- How do I reconcile the bank transactions?
- How do I connect my bank to the ERP?
- How do I balance a POS or payment gateway settlement?
- How do I set up my company’s access to Enable Banking?
- Connecting the bank and reconciling the statement
- How do I review my store’s POS remittances?
- How do I review the transactions that come in from the bank?