What a Rent Ledger Actually Needs to Track (and Why Most Spreadsheets Get It Wrong)

Every landlord ends up keeping some kind of rent ledger, whether they call it that or not. It might be a spreadsheet, a notebook, or a column in a banking app. The problem is not that people don't track rent - it's that most home-grown ledgers are missing two or three things that only turn out to matter the day a tenant disputes an amount, or the day you're standing in front of a Tenancy Tribunal adjudicator trying to explain a number.

Here is what a rent ledger actually needs to record, and the two design decisions that separate a ledger that holds up from one that doesn't.

What Counts as a Rent Ledger

A rent ledger is a chronological record of what rent was owed and what was paid, tenancy by tenancy. At minimum, each entry needs:

• The date the payment was received (not the date it was due)
• The amount paid
• The period the payment covers
• The amount that was owed for that period
• A running balance - what's owed, paid, or outstanding as of that date

That looks simple, and for a single tenant paying the same amount every week it is. It stops being simple the moment a rent increase takes effect partway through your record, a payment covers part of one week and part of the next, or a tenant pays late and you need to show exactly how much they owed on a specific day. Those three situations are where most spreadsheet ledgers fall apart, because they weren't designed to handle them from the start.

The First Thing Most Ledgers Get Wrong: Anchoring

A rent ledger needs a fixed anchor point that every period is measured from, and it should be the tenancy start date - not the date you started keeping records, and not the date of the most recent rent change. If your anchor drifts, your period boundaries drift with it, and a week that should run Monday to Sunday quietly becomes Tuesday to Monday six months later because a rent increase or an ad-hoc adjustment nudged the counting.

This matters more than it sounds like it should, because arrears are calculated period by period, not as one lump total. If your periods are misaligned, your arrears figure is wrong even though every individual payment in the ledger is recorded correctly - the totals just get sliced up differently than the tenancy agreement actually specifies.

RentManager anchors every rent period to the tenancy start date and keeps a dated rent schedule underneath it, so when the rent changes the old rate stays on the record with its own effective date instead of being overwritten. The ledger doesn't need to guess which rate applied to which week; it already knows.

The Second Thing: Partial Payments Need to Stay Partial

The other place a simple ledger breaks down is a partial payment. If a tenant owes $600 for the week and pays $400, a lot of spreadsheets just show "$400 paid" as if that were the whole story, or worse, quietly roll the missing $200 into next week's total and lose the fact that a specific week was short.

A ledger that's actually useful shows the shortfall against the period it belongs to - something like "PARTIAL $400/$600, $200 owed" - and keeps allocating future payments against the oldest unpaid amount first (first in, first out), rather than always crediting the most recent period. That FIFO allocation is what makes a ledger legible six months later: you can look at any single week and see exactly what was owed, what was paid, and whether it's still short, without mentally reconstructing a chain of adjustments.

Why This Matters at the Tribunal, Not Just Day to Day

An arrears claim at the Tenancy Tribunal lives or dies on whether your numbers are clean and explainable period by period. An adjudicator wants to see, for each week or month in dispute, what was owed and what was received - not a single lump "$1,400 behind" figure with no breakdown. A ledger that anchors correctly and shows partial payments as partial is the same document whether you're checking your own numbers on a Sunday night or printing an arrears schedule for a hearing. That's the actual test of whether a ledger is doing its job: can it stand on its own in front of someone who has never seen your spreadsheet before.

If you're at the point of preparing for a hearing, the evidence side of this - what to bring and how a hearing actually runs - is covered in the Tribunal guide; this article is about keeping the underlying numbers right in the first place, not the Tribunal process itself.

Spreadsheet, Notebook, or Software?

A spreadsheet can absolutely work as a rent ledger if you build the anchoring and the partial-payment handling into it deliberately from the start - it just takes real discipline to keep doing that correctly every week for years, across a rent increase or two, without a formula quietly breaking. I've written separately about the exact spreadsheet approach I used to run, and why I eventually moved off it - not because a spreadsheet can't work, but because the maintenance cost compounds every time something about a tenancy changes.

The alternative is a ledger that does the anchoring and FIFO allocation automatically, so a rent increase, a late payment, or a partial payment updates the record correctly without you having to remember which formula to adjust. That's the entire job of RentManager's rent ledger: the period boundaries, the running balance, and the partial-payment tracking happen without manual upkeep, and the arrears schedule it produces is the same thing you'd hand to a Tribunal adjudicator.

Open the live demo and look at the rent ledger directly, or start a free trial - plans start at $9 a month.

Common questions

What's the difference between a rent ledger and a rent tracker spreadsheet? They're the same underlying idea - a record of what's owed and paid, period by period. "Ledger" is the accounting term; a lot of landlords build one in a spreadsheet first. The difference that matters is whether it correctly anchors periods to the tenancy start date and allocates partial payments FIFO, not what you call it.

Do I legally have to keep a rent ledger in New Zealand? Yes. Section 25 of the Residential Tenancies Act 1986 requires every landlord to keep proper business records of all rent paid, retained for seven tax years. Inland Revenue also requires accurate rental income figures for tax purposes.

What should I do about an old partial payment I never resolved? Record it as a partial against the period it actually belongs to, not folded into a later week's total, and let FIFO allocation catch it up as future payments come in. Backdating a fix like this is far easier before a dispute than during one.

Can RentManager handle rooms let at different rates? Yes. Each room keeps its own rent schedule with effective dates, and incoming bank payments are matched to the right tenancy by amount and sender, with partial payments tracked per period.