Tax and GST

Cheque issued but not cleared: why your books and bank differ

Books and bank balance mismatch from a cheque not cleared: how to mark pending cheques, reconcile the two balances, and clear items when the debit lands.

Editorial illustration for Cheque issued but not cleared: why your books and bank differ

Your books and bank balance differ because a cheque you issued has reduced your books on the day you wrote it, but the bank reduces the balance only when the cheque is presented. Mark each such cheque as pending in a short list, subtract the pending total from the bank balance, and the figure should match your books. When the debit appears, mark it cleared instead of entering it again.

Why does a pending cheque create a gap?

Suppose you write a cheque on the 26th, post it to a supplier, and the supplier deposits it on the 3rd of next month. For seven or so days your books say the money has gone while your bank balance still includes it. A post-dated cheque stretches that gap further, because it sits in the supplier's hand until the date written on it.

Example: two cheques, one gap

Say your books show ₹56,300, and the bank shows ₹71,300. The gap is ₹15,000. You issued two cheques that have not yet been presented.

Cheque no.PayeeDate on chequeAmountStatus
000412Paper supplier26 October₹9,800Pending
000413Shop landlord, rent5 November₹5,200Pending, post-dated
Total pendingTwo chequesNot applicable₹15,000Equals the gap

Bank balance ₹71,300 less pending ₹15,000 gives ₹56,300, which equals your books. The mismatch is fully explained and nothing is missing.

How do I mark items as pending?

  1. Keep a small cheque register: number, date written, payee, amount, status.
  2. Write status Pending the moment you hand over the cheque.
  3. Never enter the same cheque a second time when it clears. The expense was recorded when you issued it.
  4. At month end, add up the Pending rows and compare with the gap between bank and books.

In Excel or Google Sheets, if amounts are in D2 to D200 and statuses in E2 to E200, the pending total is =SUMIFS($D$2:$D$200,$E$2:$E$200,"Pending"). The expected books figure is the bank balance minus that total, and the formula needs only the status to change from Pending to Cleared to remove an item.

What do I do when the debit lands?

  • Find the debit in the statement by cheque number or amount.
  • Change the status to Cleared and add the date the bank debited it.
  • Check the amount. If the bank debited something different, find out why.
  • Update the totals. Pending should shrink by exactly the cleared cheque.

What if a cheque never clears?

Sometimes a cheque stays pending because the supplier forgot to deposit it, lost it, or is holding it for a later date. Ask them politely. Cheques have a validity period, and you should check the one printed or stated by your bank rather than relying on memory. If a cheque is lost, speak to your bank about stopping payment and follow their steps.

Should I spend from the bank balance or the books figure?

Plan using the books figure, which has the pending cheques already taken out. The higher bank figure is not truly free money, because ₹15,000 of it will leave when the cheques are presented. Many small businesses get into trouble by treating the bank balance as the spendable amount.

It also helps to glance at the register before any large payment. If ₹15,000 is about to leave the account, a ₹60,000 purchase planned for the same week may not be as comfortable as the bank balance suggests.

Where does SpendixAI fit?

SpendixAI flags possible duplicate imports, but a line you entered by hand for a cheque and the same debit arriving later in an imported statement are for you to check. If you do find a double, delete one; deleted transactions go to a recycle bin for 30 days. The cheque register itself remains your own sheet.

A closing checklist

  • Every issued cheque has a register line.
  • Pending total equals bank balance minus books balance.
  • Cleared cheques are marked, not re-entered.
  • Old pending cheques are chased.
SPENDIXAI JOURNAL

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

Explore your reports