What goes in the register
One line per cheque, written down on the day you receive it:
- The cheque number and the bank
- The customer who gave it, and who collected it
- The amount
- The date written on the cheque, which is its due date
- A status: waiting, deposited, cleared or returned
The four statuses
Waiting means you hold the cheque and its date has not come. Deposited means it is at the bank. Cleared means the money is in your account. Returned means the bank sent it back unpaid, which people also call a bounced or dishonoured cheque.
A daily and a weekly routine
- Every morning: deposit the cheques whose date has arrived, and mark them deposited
- Every day: check the bank, and mark cheques cleared or returned
- On a return: add the amount back to what the customer owes, and tell the collector that day
- Every week: look at the cheques due in the next 14 days, so you know the cash that is coming
- Every month: go through old cheques that were never marked, and settle each one
Mistakes that cost money
- Counting a cheque as cash on the day you receive it
- Keeping cheques in a drawer with no list of due dates
- Finding out about a return weeks later, after delivering more goods
- Taking another cheque from a shop that returned one last month, because nobody remembered
Doing it in Excel, and where that breaks
A spreadsheet with the columns above works for a few cheques a week. It breaks when collectors take cheques in the field, because the sheet is updated late or not at all, and it cannot put a returned cheque back on the customer's balance by itself.
How Cashrovo does it
In Cashrovo the collector records the cheque at the shop, and the office moves it from waiting to deposited to cleared or returned. A return re-opens the shop's balance at once and flags the shop, and the overview shows the cheques coming due in the next two weeks.