The Cash Ledger | Beelocity

The Cash Ledger is the complete, date-ordered record of every confirmed money movement in and out of your treasury accounts — receipts, payments, transfers, cleared cheques, bank charges, interest, and opening balances. It is the single place to answer “what actually happened to our money, and when?”

Every account balance you see in Beelocity comes straight from this ledger: an account’s balance is simply the running total of its ledger rows. Because of that, a balance can never disagree with the movements behind it.

Opening the Cash Ledger

Open Treasury → Cash Ledger in the sidebar. You will see one row per money movement, newest first, showing:

Date — when the movement was booked against the account. Click it to open the full entry.
Account — which treasury account the money moved through.
Type — the kind of movement (receipt, payment, transfer, opening balance, and so on).
Direction — whether money came in (Inflow) or went out (Outflow).
Amount — the amount of the movement. Inflows show as positive, outflows as negative, so the column reads like a bank statement.
Running Balance — the account’s balance immediately after that movement, so you can follow the balance change step by step.
Reference — the document that produced the movement, by its own number — a receipt RCT-2026-000042, a transfer TRF-2026-000014, a bank statement — and a link that opens it. An entry that reverses another names that entry instead, by its type and date, and opens it. An opening balance or an adjustment you post by hand has no document behind it, so the column shows its kind.
Reconciliation — whether the movement has been matched to a line on a bank statement.
Memo — where the movement comes from, in words. Most rows show the number of the document that moved the money, such as RCT-2026-000042 or TRF-2026-000014, followed by the memo written on that document if it has one. The entry posted when a payment or a transfer is cancelled, or when a cheque comes back unpaid, shows that document’s number alone. An entry you post by hand shows the explanation given when it was posted; a charge written from a bank statement line shows the bank’s own wording, or the statement’s number when the line has none. An opening balance has no memo: its type and its account already say what it is.

Where the rows come from

You do not type ledger rows in by hand. They are posted automatically whenever you confirm something that moves money — confirming a receipt or payment, clearing a cheque, completing a transfer, or giving an account an opening balance. Each row points back to the document that created it, so you can always trace a movement to its paperwork.

Searching

Type in the search box to find movements by their memo, or by the number of a document behind them — not only the receipt, payment or transfer that moved the money, but the invoices a receipt or payment settled and the cheque it was paid with. A search for a cheque’s number finds the receipt it paid and, if the cheque came back unpaid, the entry that reversed it, though neither memo shows that number.

Filtering

Click the filter button (the funnel beside the search box — see Working with lists) to narrow what you see:

Account — show only one account’s movements (its account statement).
Type — show only one kind of movement, for example only payments or only bank charges.
Direction — inflows or outflows only.
Reference — the kind of document behind the movement.
Reconciliation — unreconciled rows only, the bank-reconciliation worklist for the account.
Date and Value Date — a From and a To to limit the range.
Amount and Running Balance — a band. The amount band is on the figure as stored, always positive; the column shows it signed by direction.

The choices are written into the page’s address, so a month’s statement for one account can be bookmarked. Clear all at the bottom of the panel removes every filter at once.

Viewing an entry

Click a row’s Date to open the entry. The detail page shows everything about that single movement — its account, direction, type, amount, value date and base-currency amount, the running balance after it, its reconciliation status, the SCF reference code, and the memo. An entry in a foreign currency also shows the exchange rate it was converted at. Under Reference, the Document row names the document that produced it — or, for a reversal, the entry it reverses — and opens it.

Corrections: posting an adjustment

A posted movement is permanent — it is never edited or deleted, so the history always tells the truth. When something needs correcting, you post an adjustment: a new, opposite movement that cancels the original’s effect on the balance while leaving both rows in the ledger.

There are two ways to do this (both need the Treasury account-manage permission):

Reverse a specific entry. Open the entry and choose Reverse Entry. Beelocity posts an equal, opposite movement on the same account that nets the balance back exactly. For example, reversing a 250,000.00 DA outflow posts a 250,000.00 DA inflow, restoring the balance. The new entry’s memo names the kind of movement it reverses and that movement’s date, in the language you are using when you reverse it.
Post a free adjustment. Click Post Adjustment on the Cash Ledger list to record a manual correction. Choose the account, the direction (inflow or outflow), the amount, the date, and a memo explaining why. The amount is always a positive number — the direction carries the sign. A bank account also takes the bank’s value date; a cash account has none to give, so it is not asked.

Tip: Made a reversal by mistake? Reversals are themselves movements, so simply reverse the reversal to put things back. Nothing is ever lost.

Why some movements can’t post

A movement only posts to an account that is Open. If an account is Frozen or Closed, an adjustment to it is refused — unfreeze the account first, or pick another account. An outflow that would push a normal account below zero is also refused, unless the account is set up to allow an overdraft.