PropPilot

How to Track Rent as a Self-Managing Landlord in Australia

Rent and arrears9 July 20266 min readBy The PropPilot team

If you self-manage a rental property, rent tracking is the one job you cannot afford to do loosely. Not because it is hard, but because the consequences of doing it badly arrive months later, at the worst possible time, in front of a tribunal member.

Here is a practical system that takes a few minutes a week and holds up when it matters.

Why a rent ledger matters

Arrears disputes and tribunal matters run on ledgers. When a tenancy goes wrong, the first thing anyone asks for is a complete record of what was due, what was paid, and when. A landlord who can produce a clean ledger walks in with the strongest evidence available. A landlord who cannot is reconstructing history from bank statements and memory, and every gap works against them.

The ledger also matters long before anything goes wrong. It is how you notice a tenant drifting from paying on the due date, to paying two days late, to paying a week late. That drift is the early warning system for arrears, and you only see it if the record is complete.

What to record for every payment

A rent ledger does not need to be complicated. It needs to be complete. For every payment, record six things:

  • Date received. The date the money actually arrived, not the date it was due.
  • Period covered. Which rental period this payment pays for.
  • Amount due. What the tenancy agreement says should have been paid for that period.
  • Amount received. What actually arrived. These two numbers are often different, and the difference is the whole story.
  • Method. Bank transfer, cash, or an online payment. If a dispute ever turns on whether a payment happened, the method tells you where the supporting evidence lives.
  • Running balance. The cumulative position after this payment. This single column is what turns a list of payments into a ledger.

If the running balance is zero, the tenancy is on track. If it is negative and growing, you have arrears, and you knew the day it started rather than the month after.

Weekly, fortnightly, or monthly: match the ledger to the rent

Your checking rhythm should match the payment cycle in the tenancy agreement. Weekly rent means a weekly check. Fortnightly rent, a fortnightly check. Monthly rent, monthly.

The common failure is a mismatch: rent is due weekly but the landlord reconciles quarterly, usually when something else prompts them to look. By then a small problem has had twelve weeks to become a large one. Whatever the cycle, the check itself is the same two questions: did the expected amount arrive, and does the running balance say what it should say?

Catch arrears early

Check for payment within a day or two of each due date. Not a week later, not at the end of the month. The earlier you notice, the more options everyone has.

If a payment is missed, contact the tenant promptly and keep it factual: the payment due on this date has not been received, when can we expect it? Most missed payments are cock-ups, not crises, and a quick conversation resolves them.

If the tenant is in genuine difficulty, a payment plan agreed in writing beats silence every time. It gives the tenant a realistic path back to zero, and it gives you a documented agreement to point to if things do not improve. Whatever is agreed, record it, and keep the ledger updated against the plan rather than the original schedule so you can see whether it is being kept.

Every state and territory has its own rules about arrears notices and the timelines that follow, so know the requirements where your property is before you need them.

The tools: paper, spreadsheets, software

Paper fails. Not immediately, but reliably. Pages go missing, entries get skipped in busy weeks, and nothing calculates a running balance for you. When you need the record most, a paper ledger is usually incomplete.

Spreadsheets work, with discipline. A well-built spreadsheet handles the arithmetic and produces something you can print for a tribunal. The catch is that every entry is manual, and the ledger is only as good as your habit of updating it. If you go the spreadsheet route, start from something structured rather than a blank grid: our free Rent Ledger Template has the six columns above with automatic variance and running arrears calculations built in.

Software builds the ledger for you. PropPilot records rent as it is paid, keeps a full ledger per tenant with dates, amounts, and a running balance, and flags overdue rent on your dashboard automatically so the early-warning check happens without you remembering to do it. You can start free with one property, no credit card required.

The system, in one paragraph

Record six things per payment, keep a running balance, check within a day or two of every due date, respond to the first missed payment rather than the fourth, and put any arrangement in writing. Do that in whatever tool you will actually maintain, and your rent tracking will be better than most.

This article is general information only, not legal, tax, or financial advice. Tenancy rules differ between Australian states and territories. Check your state or territory tenancy authority for current requirements.

Get the free Rent Ledger Template

A ready-to-use spreadsheet with automatic variance and running arrears calculations. Works in Excel and Google Sheets.