Cashbook and daily cash management guide

What a cashbook is for retail

A cashbook is not a final report. It is a live record of money as it moves. In a small shop it tracks the opening float, cash sales, card settlements, refunds, expenses paid out of the drawer and cash deposited into the bank. When it is part of a POS, the cashbook updates automatically as transactions happen instead of waiting for a late-night calculation.

The reason this matters is simple: most retail leaks happen in small cash movements, not in one large mistake. A few missed expenses, an unrecorded supplier payment or a refund without a receipt quickly turn a profitable day into a confusing one. A connected cashbook catches those movements before they become problems.

Cash-in and cash-out

Every rupee that enters or leaves the drawer needs a reason. In a busy shop this includes sales, customer collections, refunds, supplier cash payments, owner withdrawals and small expenses. When these are written on paper, it is easy to forget the reason or the user behind the entry. A POS cashbook tags each cash-in and cash-out to a user, a category and a shift, so the history is always readable.

That discipline protects the owner and the staff. If a shortage appears, the system already shows which transactions happened, when and by whom. There is no guessing, no argument and no need to rely on memory at the end of a twelve-hour day.

Shift open and float

The cashbook starts with the float. When the cashier opens the shift, they record the cash already in the drawer — for example, Rs. 5,000. Every sale, refund and cash-out from that point is added or subtracted from that base. The system keeps a running total, so the cashier always knows how much cash should be in the drawer before they count it.

Without an opening float recorded properly, the entire day becomes a math puzzle. The owner asks why the drawer is short, but nobody can say what the starting amount was. Recording the float fixes the starting line so the rest of the cashbook can be checked against it.

Day close and counted cash

At the end of the shift the cashier counts the cash in the drawer and enters the total. The system compares that count to the expected balance. If the count is different, the variance is shown immediately. A small difference may be a rounding issue or a missed entry; a large one needs investigation before the next shift starts.

Day close should be a gate, not an afterthought. Once the close is locked, the cashbook entry for that day is also locked, preventing late changes that hide a problem. This is why a day close routine is the strongest control a small shop can build.

Reconcile by payment type

A shop today takes cash, cards, QR codes and wallet payments. Each of these arrives in a different place and on a different schedule. Reconciling them as one lump sum hides mismatches. The better approach is to reconcile each payment type separately: cash against the drawer count, card totals against the machine settlement, QR and wallet against their app statements.

When you split the day close by payment type, a delay in a card settlement does not look like theft, and a cash shortage does not hide inside a QR delay. Each stream has its own explanation, which makes the cashbook a map instead of a mystery.

Tie to the general ledger

A cashbook that lives on its own is only half useful. When it is tied to the general ledger, every cash movement posts to the right account automatically. Sales feed revenue, expenses feed their categories, and customer collections reduce receivables. The owner no longer re-types the day into another system.

That link is what makes modern accounting software different from a spreadsheet. The cashbook and the ledger share the same source, so the P&L, balance sheet and day book stay consistent without anyone copying numbers between apps.

Common questions

• What is the difference between a cashbook and a ledger? A cashbook tracks cash and bank movements. The ledger records every account in the business. A POS cashbook feeds the ledger, but the ledger also includes credit, inventory and non-cash accounts.
• How often should day close be done? Ideally at the end of every shift. At minimum, once a day before the cashier leaves. The sooner a variance is caught, the easier it is to fix.
• Can cash-in and cash-out be tracked by user? Yes. A proper POS cashbook records which user recorded each cash event, so the audit trail is clear.
• Does the cashbook update the P&L? Indirectly. Cashbook entries like sales and expenses post to the ledger, which the P&L reads from.
• What if the counted cash does not match the system? The system shows the variance by payment type. Investigate the difference before locking the close, then record any adjustment with a reason.

Next step

If your daily cash is still tracked in a notebook or Excel, start with one week of shift opens and day closes in a POS cashbook. You will see the variance while it is still small and the books will match the drawer for the first time.