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 kind of document that produced the movement.
- Reconciliation — whether the movement has been matched to a line on a bank statement.
- Memo — a short description of the movement.
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.
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, exchange rate and base-currency amount, the running balance after it, the document that produced it, its reconciliation status, the SCF reference code, and the memo.
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.
- 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.
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.