A cheque is not a payment. It is a commitment in time. Left untracked, it puts more than cash flow at risk.
Quick answer: Cheque and note tracking works by recording every instrument with its drawer, amount, maturity, bank and status, monitoring whether it sits in the portfolio, is out for collection or has been endorsed, and matching maturities against cash flow. Set up correctly, the current status of every instrument and the balance of inflows against outflows for the next thirty days appear on one screen.
The most common situation a business owner faces is this: there is no cash in hand, but there are cheques to be collected. The problem is not the amount. It is the timing.
Cheques and notes place time between a receivable and its collection. When that time is unmanaged, a profitable business runs out of cash.
Fields that must be tracked
For each instrument, at minimum:
- Drawer and debtor
- Amount and currency
- Issue date and maturity date
- Bank, branch and cheque number
- The account it came from
- Status: in portfolio, out for collection, collected, endorsed, bounced, returned
The field most often skipped is status. The amount of a cheque is known, but its location is not. Since liability continues after endorsement, this field is critical.
Separating received and issued instruments
Two portfolios, managed separately.
Received cheques are receivables. They are collected at maturity, and if they are not, credit risk appears.
Issued cheques are payables. Funds must be available at the bank on the maturity date.
When these two are not merged onto one calendar, a business expects collections and makes payments in the same week, and only notices the imbalance on the final day.
The correct reading: cheque inflows and outflows for the next thirty days should sit side by side.
Liability on endorsed cheques
When a received cheque is endorsed to a supplier, it leaves the business but the liability does not end. If the cheque bounces, the endorser is part of the chain.
Endorsed cheques therefore stay under tracking. Each endorsement records who received it and when, and the instrument stays monitored until maturity.
This is where spreadsheet tracking most often breaks. The cheque is deleted from the file while the liability continues.
Seeing bounced cheque risk early
Risk is managed before the maturity date, not on it.
- Track total exposure per drawer. Heavy dependence on a single account is itself the risk.
- Flag accounts with a history of delay or bounced instruments.
- Set reminders for approaching maturities.
- Reflect any bounced cheque immediately in that account's limit.
The aim is not to prevent every risk. It is to see the risk before the maturity date.
Where spreadsheet tracking breaks
Cheque tracking can start in a spreadsheet. The problem is not the method, it is scale.
As the portfolio grows, the same cheque appears in more than one file. A status change is entered in one and missed in another. An endorsed cheque is removed from the list and becomes untraceable. Maturity reminders live in someone's memory.
The most critical break: the cheque record is not linked to the customer account. An account's real exposure is its open invoices plus the cheques held against it. Kept in separate places, that total is never seen correctly.
Where the system takes over
The working setup:
- Every cheque and note is recorded against a customer account
- Status changes are made in one place and flow into every report
- Received and issued instruments appear on a shared maturity calendar
- Reminders are generated automatically for approaching maturities
- Total exposure per account is calculated from invoices and cheques together
- Bounced and returned instruments are written into the account's history
Once this is in place, the question changes. It is no longer "when will this cheque clear" but "what is my cash balance next month".
Cash flow is not managed by guesswork
Cheque tracking looks like filing. It is the foundation of cash flow management.
When maturities are visible, a payment plan can be made, supplier terms can be negotiated from data, and a risky account is noticed in time.
The question to ask is not how much is in the till today. It is how much will be there in thirty days.
This article is for information only. For legal obligations relating to cheques and notes, consult your accountant.
Frequently asked questions
What should be recorded when tracking a cheque?
Drawer, amount, issue and maturity date, bank and cheque number, the linked customer account and current status. The status field shows whether the cheque is in the portfolio, out for collection or endorsed.
Should endorsed cheques be removed from tracking?
No. Liability continues after endorsement. Record who it was endorsed to and when, and keep it monitored until maturity.
Should received and issued cheques be tracked together?
They are recorded as separate portfolios but displayed on the same maturity calendar. Cash balance can only be read when inflows and outflows sit side by side.
How is bounced cheque risk reduced?
Track total exposure per account, avoid heavy dependence on a single drawer, flag accounts with past problems and set reminders for approaching maturities.
Can cheque tracking be done in a spreadsheet?
For small portfolios, yes. As the portfolio grows, status changes become inconsistent across files, and because the cheque record is not linked to the customer account, real exposure per account cannot be seen.