Rent ledger template: columns, a worked tenant ledger and when to move on

What a rent ledger is, and how it differs from a rent roll

A rent ledger (also called a tenant ledger) follows one tenancy over time. Every charge and every payment gets its own dated line, and a running balance tells you at any moment whether the tenant is paid up, in credit or in arrears.

A rent roll is the other view: one line per unit for a single month, showing rent due, rent received and what is outstanding across the whole portfolio. You need both. The rent roll tells you where to look this month; the ledger tells you the full story for a single tenant, which is what you need when a payment is disputed, a tenant leaves or a court or deposit scheme asks for evidence.

• Rent ledger: one tenancy, many months, running balance.
• Rent roll: one month, many units, totals. See rent roll software for how the two connect.

The columns every rent ledger template needs

Keep the ledger narrow. Every extra column is one more thing to fill in wrong. These columns cover residential lettings in the US and the UK.

Two columns deliberately stay out of the rent ledger: the security deposit and your own expenses. The deposit is not rent and, in many places, is held in a protected scheme or a separate account, so track it in its own record. Repairs you pay for belong in your income and expense records, and only appear in the tenant ledger when you recharge them to the tenant.

A worked tenant ledger for one tenant

Here is a tenant ledger template filled in for one tenancy: Flat 2B, rent 1,450 per month due on the 1st, a 5 day grace period and a late fee of 50 under the lease. The lease starts on January 1, 2026.

Read it top to bottom and the story is clear. January was paid on time. February was paid in two parts, and the late fee was raised on the 6th because the balance was still open after the grace period. March was fine. April was missed entirely, and the May 9 payment was applied to April, the oldest open period, which leaves May outstanding. On May 9 the tenant is one month behind, and the arrears are 8 days old, not 38, because the April debt is cleared and only May is open.

That last point is where most spreadsheets go wrong. If you apply the May 9 payment to May instead, the ledger says April is 38 days late, and every reminder, notice and conversation that follows is based on the wrong number.

Rules that keep a rent ledger accurate

• One line per event. Never overwrite a charge with a payment on the same line.
• Charge rent on the due date, even if you expect the payment on time. The balance should always say what is owed right now.
• Record payments on the date the money reaches your account, not the date the tenant says they sent it.
• Apply payments to the oldest open period first, unless your lease or local rules say otherwise.
• Never delete a line. If something is wrong, add an adjustment line with a note explaining why.
• Keep fees separate from rent in the Type column, so you can show rent arrears on their own when needed.
• Reconcile against the bank statement every month: the payments in the ledger should add up to the rent received on the statement.
• Keep deposits out of the running balance until the tenancy ends and a deduction is agreed.

Reading arrears from the ledger

A running balance tells you how much is owed. It does not tell you how old the debt is, and age is what drives your next step. Group open balances into three buckets: 1 to 30 days, 31 to 60 days and 60+ days. A tenant who is 5 days late needs a friendly reminder; a tenant in the 60+ bucket needs a formal process under your local rules.

To age arrears from a ledger by hand, take each open rent period, find its due date and count the days to today, remembering that payments cleared the oldest periods first. With a handful of units that is a few minutes. With fifty it is an afternoon, every month. Our guide on how to track rent collection covers a monthly routine, and late rent notice covers what to send once a balance is overdue.

From tenant ledger to portfolio view

If you let more than a few units, keep one tab per tenancy and a summary tab that pulls the closing balance of each into a monthly rent roll: unit, tenant, rent due, received, balance, oldest open period. When you manage property for other owners, add an owner column, because each owner's monthly statement starts from the rent actually received on their units, minus your fees and any repair costs. The owner statement template shows how that statement is laid out.

The summary tab is where spreadsheets tend to break. Formulas reference the wrong row after someone inserts a line, a tab is copied for a new tenant and still points at the old one, or a renamed file breaks every link. None of these errors is visible until an owner or tenant questions a number.

When to move off a spreadsheet rent ledger

A spreadsheet is a good start. It stops being good when the time you spend maintaining it is larger than the cost of a tool. These are the usual signs.

• Month end takes more than an hour because you match bank lines to tenants by hand.
• You have had a partial payment applied to the wrong month and only noticed later.
• More than one person edits the file, and nobody knows who changed a figure.
• You manage for other owners and build their statements from the ledger by copy and paste.
• Arrears ageing is a separate calculation you redo every month.
• You cannot answer "what did this tenant pay in the last twelve months" in under a minute.

Letting does the ledger work as part of rent collection software: import your bank CSV, and payments are matched to tenant ledgers, partial payments are recorded, arrears are aged into 1 to 30, 31 to 60 and 60+ days, and on the Agency plan reminder emails go out on your schedule. Letting tracks rent and reconciles bank payments; tenants keep paying the way they do now. Plans start at $59 per month for up to 25 units, and there is no unit minimum. See property management software pricing, or run month end on a demo portfolio first.