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, CCP or other 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, CCP, e-wallet or other account this statement is for. A cash account is not offered: nobody sends you a statement for your own cash box. 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 is dated on the period’s last day or after it. A statement covers days that are over, so neither its date nor the end of its period can be after today — and every line you add later has to fall inside the period.
- 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. The date opens on today when the statement covers it, and on the statement’s last day otherwise, so it is always a day the line may carry.
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. The reference is the line’s wording compared with the entry’s memo and with the documents behind the entry — the receipt or payment, the invoice it settled, the cheque it was paid by — so a line that quotes only the invoice number, or only the cheque number of one that came back unpaid, still finds its entry. 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, each with its date, the document it belongs to — or, for an entry that reverses another, that entry’s type and date — and its memo; 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 Write 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. The entry stays with that line from then on: if you unmatch the line, matching it again takes the same entry back rather than writing a second one — as long as the line still shows that entry’s amount — and the line can no longer be deleted. The line’s date becomes the entry’s date, so it can’t be after today or before the account’s opening balance. You can type a memo for the new entry; left empty, the entry takes the bank’s own wording for the line, or the statement’s number when the line has none.
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.
- Writing 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.