The Best Way to Track Rent Payments as a Small Landlord (Without a Spreadsheet)
A rent ledger has to answer three questions instantly: who owes what, since when, and what was agreed. Here is how to keep one that does, for one unit or fifty.
The rent spreadsheet starts well. One tab, twelve rows, a column for paid. By the second year it has three tabs, a colour code only you understand, and a tenant who says they paid in March and you cannot prove otherwise. Here is what a rent ledger needs to do, and how to get it without becoming an accountant.
What a rent ledger must answer
- What is owed right now, per tenancy? Not "what was due" — the balance, after every payment and every adjustment.
- Since when? The age of the arrears determines the letter you send and the action you can take.
- What was agreed? The rent, the due day, any increase and when it took effect, any concession and why.
- What happened when? Every charge and every receipt, dated, with a reference.
The structure that works
Per tenancy, two tables: charges (period start, period end, amount due, due date) and payments (date received, amount, method, reference). The balance is the sum of one minus the sum of the other. Rent increases are new charge rows from the effective date; a concession is a credit row with a note. Nothing is overwritten; the history is the table.
In Herarx this is the rent table on a tenancy case, with periods generated in advance by a rule, totals rolled up, and a receipt generated from each payment row. The tenant's statement of account is the two tables printed together with the running balance — one click, and it matches what you would show a court.
Arrears without drama
A rule watches the balance and the due date. Seven days late: a courteous reminder generated from the case and sent from it, so the reply files itself. Fourteen days: a formal notice. Thirty: a task for you to decide next steps. The escalation is the same for every tenant, which is exactly what fairness and most tenancy laws require. The dates and letters sit on the tenancy's timeline.
Connecting it to the books
If you run accounting software, the charge rows can post as invoices and the payment rows as receipts — to QuickBooks, Xero or NetSuite in our case — so the books and the ledger never disagree. The books remain the source of truth for money; the tenancy record is where the story lives. Details in from rent roll to ledger.
For a building
With several units, the building rolls up its tenancies: total due this month, total received, arrears across the block, oldest debt. That is the number the owner asks for, and it should not require opening any tenancy. See managing a building as one record.
If you keep the spreadsheet
Some landlords will, and it can work for one or two units. Two rules: never overwrite a cell (add a row), and never let the spreadsheet be the only place a payment is recorded — the bank statement or a receipt must back every row. When it stops answering the four questions in under a minute, it is time to move.
