Why your cheque register shouldn't be a spreadsheet

Property management software built in London or Austin makes a reasonable assumption: rent arrives monthly, by card or direct debit, and the system's job is to reconcile payments against a schedule.

Here, rent arrives as four pieces of paper handed over on the day the contract is signed, dated across the coming year, each of which may or may not clear.

That difference is not cosmetic. It changes what the system has to be.

What a cheque actually is

A post-dated cheque is a promise with a date and a failure mode. Between signing and clearing, it can be:

• held, uncashed, because the tenant asked
• deposited and pending
• cleared, at which point rent has genuinely been collected
• returned, at which point you have a legal position, an angry landlord and a conversation to have this week

A spreadsheet can record all four states. What it cannot do is notice. It will sit there, showing "deposited", for as long as nobody opens it. The bounce is discovered when the landlord asks where their money is — which is the worst possible moment to discover it, because by then you've also issued a statement that is wrong.

The register should be the ledger

The useful design principle is this: the cheque register is not a record of the rent ledger, it is the rent ledger. Nothing gets posted as collected until a cheque clears, and when one clears the posting happens automatically.

That single rule fixes a surprising number of downstream problems:

• Owner statements reconcile by construction, because every line traces to a cheque.
• The owner balance reflects cleared funds, not promised funds.
• A bounce raises an exception the same day rather than creating a silent gap.
• Nobody has to remember to update two places.

What good looks like

A cheque register that is doing its job will tell you, without anyone preparing a report:

• which cheques are due for deposit in the next fortnight
• which have been returned and what has been done about each
• what has actually been collected this period, per property and per landlord
• what that means for the owner's payout before you send the statement

None of that is exotic. It just requires the software to treat the cheque cycle as the core model rather than as a note attached to an invoice.

The migration question

Firms usually ask whether their existing spreadsheet can be brought across. Almost always yes — the data is usually there, it's the state transitions that are missing. The practical approach is to import the outstanding cheques with their current status, and let everything from that point forward run through the register.

The spreadsheet stays as history. It just stops being the thing your landlord relationships depend on.