Bank reconciliation checks your own records against the bank’s. Each month, the bank sends a statement for each account. It lists each credit and each debit on the account, with the bank’s opening and closing balances. You key that statement into Beelocity, and you match each of its lines to an entry in your Cash Ledger.
Two balances take part, and they are different figures. Your book balance is what your cash ledger says. The bank’s balance is what the statement says. A reconciliation checks that each movement on the statement is also in your books, so that you can explain any gap between the two.
It finds two kinds of gap:
- Money that the bank moved, and your books do not show yet. It is often a bank charge, a commission or interest, and you can write that entry from the statement line. It can also be a client’s transfer that nobody recorded, or a cheque that nobody cleared yet.
- Money that your books show, and the bank has not moved yet. It is an entry that no line of the statement matches. To see those entries, filter the cash ledger on the account and on Bank reconciliation = Unreconciled.
When every line is matched or ignored and the difference is zero, you lock the statement with Reconcile & lock.
The Cashier can read the statements and their reconciliation. Only the Treasurer and the owner of your organization can key in a statement, add its lines, match or ignore them, and lock it.
Opening Bank Reconciliation
Open Treasury → Bank Reconciliation in the sidebar. The list shows one row for each statement, with these columns:
- Statement number is the statement’s own number, such as
STMT-2026-000001. Click it to open the statement and its reconciliation. - Account is the bank, CCP, e-wallet or other account that the statement is for. CCP is the postal current account at Algérie Poste.
- Period is the first and the last day that the statement covers.
- Statement date is the day that the bank issued it.
- Opening balance and Closing balance are the bank’s balances at the start and at the end of the period.
- Source notes where the statement came from. It is a note only, because Beelocity cannot read a bank’s file.
- Status is Imported, In reconciliation or Reconciled.
- Active is switched off for a statement that you set aside, as the next section says.
The list’s filter button narrows it by any of these columns, and by Period end too (Working with lists).
Importing a statement
You key in each statement yourself, from the bank’s paper, because Beelocity cannot read a bank’s file. The status Imported only means that you keyed the statement in. Press New on the list, and fill in the form:
- Statement number opens on the next number, such as
STMT-2026-000001. Keep it, or type your own. No two statements in your organization can have the same number. - Account is the account that the statement is for. The list does not offer a cash account, because no bank sends a statement for your own cash. The statement takes the account’s currency. You cannot change the account after you save.
- Source is Manual. The other choices only note the format of the bank’s file.
- Statement date is the day that the bank issued the statement. It opens on today. It must fall on the period’s last day or later, and never after today.
- Period start and Period end are the first and the last day that the statement covers. The period must start on or before the day that it ends, and it cannot end after today. Each line that you add later must fall inside the period.
- Opening balance and Closing balance are the bank’s balances, exactly as the statement prints them. They are the bank’s figures, and not your book balance.
Press Save. The statement opens with the status Imported, and you add its lines on its Bank reconciliation tab.
While the statement is Imported, you can still correct its dates and its balances. After you match or ignore its first line, they stay as they are for good, and Beelocity refuses a save that changes them. Only Active can still change. Even if you unmatch every line later, the statement does not go back to Imported.
So if you find a mistake in a statement’s figures later, set the statement aside and key it in again:
- On its Bank reconciliation tab, press Unmatch on each matched line.
- On the statement’s page, switch off Active, and save. Beelocity refuses this while any line is matched.
- Key in the statement again with the right figures, and add its lines.
- Match each line again. For a bank charge or interest that you already wrote, pick that entry in the list. Do not write it a second time.
You can delete a statement only while it has no lines. For a statement with lines, switch off Active instead.
The reconciliation workspace
Open a statement, and switch to its Bank reconciliation tab. The strip at the top shows the Opening balance, the Closing balance and the Difference. It also counts the lines that are Matched, Unmatched and Ignored.
The Difference compares the bank’s two balances with the entries that you matched. Beelocity starts from the bank’s opening balance, and it adds each matched entry, money in as a plus and money out as a minus. The Difference is what is still missing to reach the bank’s closing balance. An ignored line’s money does not count, and your book balance takes no part in this figure.
For example, the bank opens the month at 1,200,000.00 DA and closes it at 1,450,000.00 DA. If you matched a receipt of 300,000.00 DA and a payment of 50,000.00 DA, the Difference is zero.
The grid below the strip lists the statement’s lines, with their Date, Memo, Debit, Credit, Status and Confidence. It has its own filter button. For example, pick Status = Unmatched to see only the lines that are left. You can also narrow the lines by date, by a debit or a credit band, or by confidence.
The Cashier sees the same tab, with a line that says that they can read it and cannot change it.
Adding the bank’s lines
Open the ⋮ menu above the lines, and choose Add line. The Treasurer and the owner of your organization see it while the statement is not locked. Add one line for each movement that the bank printed:
- Line date is the day of the movement on the statement. It opens on today if the period covers today, and on the period’s last day otherwise. It must fall inside the period.
- Value date (optional) is the day that the bank made the money available. It cannot come before the line date.
- Memo is what the bank’s own line says.
- Bank reference (optional) is the bank’s own reference for the movement.
- Which way is Money in for a credit, or Money out for a debit. A line is one or the other, and never both.
- Amount is a figure above zero.
- Balance after this line (optional) is the balance that the bank prints after this line.
Then press Add line in the dialog. Type the memo and the reference as the bank prints them, because Match automatically compares their words with your entries.
Beelocity refuses a second line with the same date, the same amounts and the same bank reference. It checks this only when the line has a bank reference.
This screen cannot edit or delete a line. If you keyed a line’s date, amount, direction or bank reference wrongly, ignore the line, and add it again with the right figures. If only its memo, its value date or its balance is wrong, keep the line, and match it by hand. Beelocity would refuse a new line with the same date, amounts and bank reference, even while the first one is ignored.
Matching lines to your cash ledger
Each line starts Unmatched. You answer each line in one of three ways.
Match automatically is the quickest first pass, in the ⋮ menu above the lines.
- Beelocity looks at each Unmatched line. It takes the entries on the account that no line matches yet, with the same amount and direction, dated within five days of the line.
- It scores each entry on its date, and on the words that the entry shares with the line’s memo and bank reference. An entry’s words are its memo and the numbers behind it, such as its receipt, the invoices that the receipt settled and its cheque.
- It matches the line only when the score is high, and only when no other entry scores almost as well. Without a shared word, it matches only an entry dated within two days of the line.
- A message then counts the lines that it matched, and the lines that have a possible entry. It shows none of those possible entries, so match the lines that are left by hand.
- The Confidence column shows the score of each line that Match automatically matched. A line that you matched by hand shows a dash.
Match pairs a line with an entry by hand. Press Match on the line. The dialog lists every entry on the account that no line matches yet, with the same amount and direction, at any date. Each entry shows its type, its amount, its date, the record behind it and its memo. Pick the one that records this movement, and press Match.
If the list is empty, your books have no entry for this movement yet. If it is a bank charge or interest, write it from the line, as the next paragraph says. Otherwise, record and confirm the receipt or the payment first, or clear its cheque. Then match the line.
Ignore leaves a line out on purpose. Press Ignore on the line, and give a reason if you want to. An ignored line’s money does not count in the Difference. So ignore a line only when its money changes nothing in the end. For example, the bank took a charge by mistake and then gave it back. Ignore both of those lines, because together they move nothing. Later, you can press Match on an ignored line, or Stop ignoring to make it Unmatched again.
When the bank charged a fee or paid interest that your books do not have, write the entry from the line. Press Match on the line, and choose Write the missing entry.
- A Money out line becomes a Bank charge, and a Money in line becomes Interest. You cannot choose another type, so do not use this for a client’s transfer or a payment to a supplier.
- The entry takes the line’s date. It takes the line’s value date too, if that date is not earlier. Beelocity refuses this for a line dated after today, or before the account’s opening balance date.
- SCF reference (optional) opens on 627 for a bank charge and on 768 for interest. The SCF is the Algerian financial accounting system. Beelocity shows the code on the entry, and it uses the code nowhere else.
- Memo (optional) can stay empty. The entry then takes the line’s memo, or the statement’s number if the line has none.
Press Write and match. Beelocity posts the entry to the cash ledger and matches it to the line in one step. The account’s book balance moves by that amount. The entry stays tied to that line. If you unmatch the line, the entry stays in the cash ledger, and the line can match only that entry again.
Locking the statement
When no line is Unmatched and the Difference is zero, press Reconcile & lock above the lines. The button stays greyed out until then, and its tip says what to do. The statement also needs at least one line.
The statement moves to Reconciled. After that, nobody can add, match or ignore its lines, and nobody can change its details. To open it again, press Unmatch on a matched line. The statement goes back to In reconciliation, and that line goes back to Unmatched. A locked statement whose lines are all ignored has no Unmatch to press, so it stays locked.
The status line at the top of the page reads Imported, In reconciliation and Reconciled, and it shows where the work stands. Nobody presses In reconciliation. Beelocity moves the statement there when you match or ignore its first line. It does the same when you unmatch a line on a locked statement. The Reconciled step of the status line makes the same move as Reconcile & lock. Use the button above the lines, because it stays greyed out until the statement balances.
What changes automatically
You never type a balance here. Each step changes these things by itself:
- Match marks the entry Reconciled in the cash ledger, and Unmatch marks it Unreconciled again. Neither step moves a balance.
- Write and match posts a bank charge or interest to the Cash Ledger. So the account’s book balance moves toward the bank’s.
- The first match or ignore moves the statement to In reconciliation, and its dates and balances can no longer change.
- Reconcile & lock moves the statement to Reconciled, which records that this period of the account is checked.
While a line is matched to an entry, nobody can reverse that entry in the cash ledger. Unmatch the line first.
Every entry that you post from here appears in the Cash Ledger, like any other movement of money.