Content authored by practitioners with experience at Amazon India, Intuit QuickBooks, and the Tata Group. Meet the team →
Cheques that are outstanding, uncleared, stale, post-dated or returned often end up as unexplained differences in a bank reconciliation instead of dated, aged items.
Test five cheque states in a demo using one real cheque per state from last quarter, and check that each is aged from the cheque date, flagged at three months and linked to its voucher.
Test set: issued not presented, deposited not cleared, stale after three months, post-dated, returned with charges; ageing from cheque date with a stale flag at the three-month mark.
An ageing report by cheque state and a proposed reversal or reissue entry awaiting approval, rather than a silent posting.
If your business still issues or receives cheques, test five cheque states in every reconciliation demo: issued but not presented, deposited but not cleared, stale after three months, post-dated, and returned with charges. Each must remain a dated, aged item linked to its voucher. A tool that turns them into a single unexplained difference will cost you a day at every close.
The manual method is covered in the bank reconciliation statement guide and the bank charges guide.
Which five cheque states should you test?
Pick one real cheque per state from last quarter and add it to your test pack.
| State | Bank statement view | Books view | Expected tool treatment | Ageing-report column |
|---|---|---|---|---|
| Issued, not presented | Nothing yet | Payment recorded | Open item, aged from cheque date | Days outstanding |
| Deposited, not cleared | Nothing yet, or clearing next day | Receipt recorded | Open item, expected to clear in 1 to 2 working days | Days in clearing |
| Stale (over three months) | Nothing | Payment still recorded | Stale flag and proposed reversal for approval | Stale since date |
| Post-dated | Nothing | Should not be in the bank ledger yet | Warning if booked before its date | Date due |
| Returned with charges | Return debit plus charge and GST | Receipt recorded | Return matched to receipt, receivable restored, charge matched | Return date |
How should a tool age and flag cheques?
Validity runs from the date on the cheque. The RBI cut validity from six months to three months with effect from 1 April 2012, so a cheque dated 14 July cannot be paid if presented after 14 October. Ask the vendor to show:
- days outstanding counted from the cheque date, with the voucher date beside it;
- a stale flag at the three-month mark, not at a fixed 90 days;
- a reversal or reissue prompt linked back to the original voucher;
- an ageing report by account that your auditor can filter and reproduce.
If you issue cheques of ₹50,000 or more, ask whether the tool records the Positive Pay details you confirm to the bank, a system the RBI introduced from 1 January 2021, so a cheque rejected for a Positive Pay mismatch is not mistaken for an ordinary return.
Post-dated cheques need a different rule. They should not sit in the bank ledger before their date, and the tool should warn when one does.
How should a returned cheque be handled?
A return shows up as a debit for the cheque amount, often with a return charge and 18 percent GST on that charge. A good tool will match the return to the original receipt, show the customer’s receivable as open again, and match the charge and GST to their own ledgers. For example, a returned customer cheque of ₹1,25,000 with a return charge of ₹500 and GST of ₹90 should produce three linked items: the ₹1,25,000 reversal against the original receipt and ₹590 of charges split between the charge and GST ledgers. Ask whether it can flag a customer whose cheques have bounced more than once in a quarter. Dishonour can also start the 30-day notice window under Section 138 of the Negotiable Instruments Act, 1881, so the return date must be clear.
What does a worked stale-cheque case look like?
A vendor cheque of ₹62,300 is dated 14 July and still unpresented on 20 October, 98 days later (17 days in July, 31 in August, 30 in September and 20 in October). The tool should have shown it as outstanding from 14 July, flagged it stale once 14 October passed, and on 20 October proposed this entry for approval: debit Bank ₹62,300, credit Vendor ₹62,300. The vendor balance comes back as payable, and the team decides whether to reissue by cheque or pay by NEFT. Nothing should post without a named approver.
What questions should you ask the vendor?
- Do you age from cheque date, voucher date or both?
- Where is the stale rule set, and does it follow calendar months?
- Is a proposed reversal ever posted without approval?
- Can I see last quarter’s returned cheques in one report?
Fold these into your month-end close checklist so the same checks continue after go-live.
How Terra Insight fits
TransactIG delivers bank-to-books reconciliation that keeps open cheques and returns in an exception queue, with audit-ready exports. A formal BRS document module is on the roadmap, not delivered. Bring your five test cheques to a representative-sample fit benchmark; see the bank reconciliation software page.