Bank reconciliation is how you tie your own records to the bank’s. Each month the bank issues a statement listing every credit and debit that actually hit an account. You import that statement into Beelocity and match each line against the matching entry in your Cash Ledger, until the bank’s closing balance agrees with your own — to the dinar.
Reconciliation is the control that keeps your recorded cash honest. It surfaces two kinds of difference:
- What the bank knows that your books don’t — account charges, commissions, and interest the bank applied without you recording them.
- What your books recorded that hasn’t cleared the bank yet — cheques still in transit, post-dated bills of exchange not yet presented.
When every line is matched or ignored and the difference is zero, you lock the statement.
Opening Bank Reconciliation
Open Treasury → Bank Reconciliation in the sidebar. You will see one row per statement, showing:
- Number — the statement reference (statements start with
STMT-). Click it to open the statement and its reconciliation workspace. - Account — the bank or cash account the statement reports on.
- Period — the date range the statement covers.
- Statement Date — when the bank issued it.
- Opening and Closing — the balances the bank reported at the start and end of the period.
- Source — how the statement was loaded (today this is Manual entry).
- Status — Imported, In reconciliation, or Reconciled.
Importing a statement
Click New, then fill in the form:
- Statement Number — leave it blank and Beelocity numbers it for you (
STMT-2026-000001); type your own if you prefer. - Account — the bank or cash account this statement is for. Its currency becomes the statement’s currency automatically.
- Source — how you’re loading it. Choose Manual entry to key the lines in by hand.
- Statement Date, Period Start, and Period End — when the bank issued the statement, and the range it covers. The period must start on or before it ends, and the statement date can’t fall before the period starts.
- Opening Balance and Closing Balance — the balances the bank reported, exactly as printed. Reconciliation proves your books roll forward from the opening balance to exactly the closing one.
Save it. The statement opens at status Imported, ready for you to add its lines and reconcile.
The statement list narrows on its filter button by Account, Status, Source, Active, a Period (from) / Period To or Statement Date window, or an opening / closing balance band (Working with lists).
The reconciliation workspace
Open a statement and switch to the Reconciliation tab. At the top you see a running summary: the opening and closing balances, the difference, and how many lines are matched, unmatched, and ignored. The difference is the bank’s closing balance minus your opening balance rolled forward by the movements you’ve matched — when it reaches zero (and no line is left unmatched) you can lock the statement.
The lines grid has its own filter button: pick Status = Unmatched to see only what is still to be explained, or narrow by date, by debit / credit band or by match confidence. The statement is already on the page, so these filters apply instantly.
Adding the bank’s lines
For a manually-entered statement, click Add for each movement the bank reported. A line is either money in (a credit) or money out (a debit), never both — pick the side, enter the amount and date, and (optionally) the bank’s reference and running balance.
Matching lines to your cash ledger
Each line starts Unmatched. There are three ways to resolve it:
- Auto-match — the quickest first pass. Beelocity scans your unmatched lines against the cash-ledger entries on the account that aren’t reconciled yet, scoring each candidate by amount, date, and reference, and automatically binds the clear, confident matches. Anything it isn’t sure about it leaves for you.
- Match — bind a line to the cash-ledger entry it corresponds to by hand. You’re shown the entries on the account whose amount and direction agree with the line; pick the right one.
- Ignore — mark a line as deliberately not reconciled (a duplicate the bank reversed, or a line tracked elsewhere). It no longer blocks locking, and you can un-ignore it later.
When the bank recorded something your books don’t have yet — typically a bank charge (money out) or interest credited to you (money in) — use Create the missing entry inside the Match dialog. It posts a new cash-ledger entry straight from the line and matches it in one step, so your balance catches up with the bank’s.
Locking the statement
Once every line is matched or ignored and the difference is zero, click Reconcile & lock. The statement moves to Reconciled and its lines and matches are frozen as a record. If you later need to change a match, unmatch the line first — that re-opens the statement.
The statement’s status line, across the top of the page, reads Imported · In reconciliation · Reconciled and shows where the work has got to. In reconciliation is never something you click: a statement reaches it on its own the moment you match or ignore the first line. Reconciled is a step you can take from there if you hold the reconcile right, and it is the same lock — the button beside the lines is the one to use, because only it can tell you the difference is not yet zero.
What changes automatically
You never adjust balances by hand here:
- Matching a line marks the cash-ledger entry it points to as reconciled. Unmatching reverses that.
- Creating the missing entry posts a new charge or interest movement to your Cash Ledger, so the account balance moves to agree with the bank.
- Locking records that the account is tied out for the period.
Every movement you post from here appears as a row in the Cash Ledger, the single record behind every balance.