Tax and GST

Cash book not tallying: where to look first

Cash book not matching the till? Check in this order: swapped digits, wrong-side entries, double deposits, missed payments and unlogged withdrawals.

Editorial illustration for Cash book not tallying: where to look first

When the cash book and the till disagree, first recount the cash, then work out the exact difference, and let that number tell you where to look. A difference divisible by nine usually means two digits were swapped, twice the amount of one entry means it went on the wrong side, and a round figure usually means a deposit or withdrawal was missed or written twice.

Step 1: is the cash really what you think it is?

Count the drawer again, slowly, and include small notes, coins and any slips of paper standing in for cash. Set aside anything that is not shop money. Say the book shows ₹12,480 but the drawer holds ₹12,840. The difference is ₹360 and the drawer has more than the book. Write that number down before you touch anything else.

Step 2: does the difference look like a swapped pair?

If you wrote ₹480 where the real figure was ₹840, the book is out by ₹360. A swap of two digits always leaves a difference that divides evenly by 9, and 360 divided by 9 is 40. When the difference divides by 9, scan the day's entries for a figure whose digits could have been reversed: 480 and 840, 1,350 and 1,530, 69 and 96.

Step 3: could one entry be on the wrong side?

Suppose a ₹180 receipt was written in the payments column. The book is now ₹360 lower than the drawer, because it lost the ₹180 it should have gained and also subtracted ₹180. Halve the difference and look for an entry of exactly that amount. In our example, ₹360 halves to ₹180.

Step 4: the common culprits, in order

CheckDifference it leavesWhere to look
Swapped digitsDivisible by 9Amounts in the day's lines
Entry on the wrong sideTwice the entryReceipts against payments
Bank deposit written twiceEqual to the deposit; book is shortDeposit slip against the book
Missed paymentEqual to the payment; book is higher than the drawerChai, courier, small purchases
Personal withdrawal not loggedEqual to the amount; book is higher than the drawerOwner or family took cash
Missed receiptEqual to the receipt; drawer is higherCash sales without a bill

A deposit logged twice is a favourite. The deposit slip shows one amount, but the book carries two lines. Hold the slip against the book to check.

What if the difference is small, like ₹20 or ₹50?

Small differences are usually change given wrongly or a tiny payment that was never written. Look at the busiest hour first. Do not spend two hours hunting ₹20. Write the difference as a separate line, mark the date, and move on. If it keeps happening on the same day of the week, or with the same person at the counter, that is the pattern to watch.

How do you stop it happening again?

  • Write each entry at the moment of the transaction, not at closing time.
  • Total the day's receipts and payments twice, once down the columns and once from the opening balance.
  • Tick each deposit slip against the book on the same day.
  • Log every family withdrawal, however small, with the date and a short word such as "home".

If you also import your bank statement into a tool such as SpendixAI, which flags possible duplicate imports and lists same-amount charges to the same merchant within two days, a doubled bank entry shows up faster than in a handwritten book. The cash side still depends on your own count.

When to ask for help

If the difference is large, grows over weeks, or the book cannot be reconciled to the bank statement even after the checks above, ask your accountant to go through it with you. Do not pay anyone to rewrite the book. Ask them to show you where the break is.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports