Most Australian landlords start in a spreadsheet. Some never leave. This is the honest case for switching to a proper rent ledger app — from someone who spent five years running rent through Excel before building PropLedger.
Let’s be fair to spreadsheets. They’re flexible, they’re free, they live wherever you want them to, and they’re infinitely customisable. For tracking total rent received over a year against total expenses paid out, a spreadsheet is genuinely fine.
That’s the version of rent tracking that fits in a spreadsheet: end-of-year totals. Two columns, twelve rows, sum at the bottom. Most landlords start there and it works.
The trouble starts when you need to model state, not just amounts. A rent ledger isn’t a list of dollar amounts on dates — it’s a running set of statuses across overlapping leases. Each weekly charge can be open, paid, partially paid, written off, or credited from a previous overpayment.
Spreadsheets don’t naturally express this. You can fake it with conditional formatting and a hand-maintained “status” column, but the moment you have two leases, two tenants, and a partial-payment scenario, the spreadsheet starts to require active maintenance. You’re no longer just recording — you’re engineering.
Tenant pays $400 of the $630 owed. In a spreadsheet, what do you write? Mark it “paid” and lose the $230? Mark it “unpaid” and forget the $400 ever came in? Most landlords end up with a workaround that involves a running “balance owed” cell that’s perpetually wrong by the end of the year.
Tenant overpays by $90 in week 8, says “apply it to next week’s rent.” In a spreadsheet, this is a manual cross-reference that you have to remember next week. In a ledger app, it’s a credit applied automatically against the next open charge.
How many days overdue is each unpaid charge? A spreadsheet can compute it with a formula referencing today, but that formula recalculates every time you open the file. Historical aging — “when did this become 30 days overdue” — is essentially impossible to reconstruct.
Lease ends, you renew at a higher rent. In a spreadsheet, you either start a new tab (losing the relationship to the previous lease) or you change the rent figure inline (losing the historical record of what was charged before). A ledger app creates a new lease record and keeps the old one — both visible.
Spreadsheets become genuinely painful with two-plus properties. You can have a tab per property, but then your portfolio view is a manual roll-up — a separate summary tab that you have to remember to refresh. By the time you have three properties, the spreadsheet is probably wrong somewhere and you don’t know where.
A real ledger handles the cases above structurally. Partial payments split into “paid” and “remaining balance”. Overpayments become credits with a clear linkage to the future charge they’ll apply to. Aging is a property of each charge, computed against its due date. Renewals create new records; old records persist.
The result isn’t just “less manual work” — though it is that. It’s that the data is structurally capable of answering questions a spreadsheet can’t. “What was my total arrears at the start of last quarter?” “How much did this tenant actually pay across the relationship?” “What was my vacancy rate last year?” These are one-click questions in a ledger and unanswerable in a spreadsheet.
Generic accounting software is a partial upgrade over spreadsheets. It handles bank reconciliation properly, it tracks bills, and it produces a clean P&L. But it doesn’t model leases. Rent is just “income” on a date. Arrears aren’t tracked. There’s no rent roll. No lease history. The reports an accountant wants for a rental return aren’t natively there.
You can force it to work — categorise income by property, track an “invoice” per week per tenant, build custom reports — but at that point you’re doing the engineering work yourself. A purpose-built rent ledger does it for you.
Spreadsheets are free. PropLedger is free to start. Xero is $50–$100/month per file. The dollar comparison isn’t really the point — it’s the time comparison.
With a clean rent ledger app, monthly reconciliation is 20 minutes. With a spreadsheet, it’s anywhere from 45 minutes to a full Sunday afternoon depending on how many edge cases came up that month. Multiply by 12 months and you’re looking at 4–40 hours a year you’d rather have back.
You probably know the answer if you’ve read this far. Some honest tells:
Any of those, and a purpose-built rent ledger pays for itself in the first month. See how PropLedger’s rent ledger worksor just sign up — it’s free to start, no credit card required.
Set up your first property in minutes. Free to start — no credit card required.