Rent ledger for landlords: a free template and how to keep one

A rent ledger is the running record of what a tenant owes and what they have paid. It is the most boring document in your rental business and, on the day something goes wrong, the most important one. If a tenant says they paid in March, if a deposit dispute lands in small claims, or if your tax preparer asks what the property brought in, the ledger is the answer. Here is how to keep one properly, with a template you can copy.

What a rent ledger is (and is not)

A tenant ledger is one ledger per tenant or per lease. Every charge goes in (rent, late fees, other agreed charges) and every payment goes in, in date order, with a running balance. At any moment the last line tells you exactly where that tenant stands.

It is different from two things landlords often confuse it with:

• A rent roll is a snapshot across all your units: who lives where, what the rent is, and who is current. It summarizes the ledgers. It does not replace them.
• A bank statement shows money arriving, but not what it was for, which month it covered, or what is still owed. A $600 deposit on the 4th could be half of March or a catch-up for February. Only the ledger says which.

The columns: a template you can copy

You can keep a ledger in a notebook, a spreadsheet or software. The columns are the same either way. Copy this layout into a spreadsheet and start one tab per tenant.

At the top of each ledger, write the basics once: tenant names, property address and unit, lease start and end dates, monthly rent and due date, the late fee terms from the lease, and the security deposit amount and where it is held.

A filled-in example

Here is one month for an example tenant whose rent is $1,200, due on the 1st, with a $50 late fee if rent is not paid in full by the 5th (example numbers only; use the terms in your own lease and state law).

Two rules make this work: every charge is its own line, and every payment is its own line. Never overwrite a line or net two things together. If you made a mistake, add a correcting line with a note, so the history stays visible.

Recording cash, checks and money orders

Paper payments are where ledgers fall apart, because there is no automatic record. Make it a habit to enter them the same day they arrive:

• Checks: note the check number and the name on the check, especially if someone other than the tenant paid.
• Money orders: note the serial number and keep a copy or photo before you deposit it.
• Cash: always give a written, numbered receipt and note the receipt number on the ledger. Some states require a receipt for cash rent; our rent receipt guide covers what to include.

Then deposit paper payments separately from personal money, so the bank deposit matches the ledger line.

Partial payments and late fees

Partial payments are exactly why the ledger needs a running balance. Record each partial amount as its own payment line and let the balance show what is still owed. Do not mark the month "paid" until the balance reaches zero.

A few practical points:

• Apply payments consistently. Decide how payments are applied (for example, to the oldest balance first) and do it the same way every time. If your lease says how payments are applied, follow it, and check whether your state has rules on this.
• Enter late fees as charges, on the date they apply. A late fee is its own line, not something added to the rent line. That keeps it easy to show that the fee matches the lease. State rules on late fees vary a lot; see late rent fee laws by state.
• Be careful with partial payments during an eviction. In some states, accepting partial rent after you have served a notice can affect the case. Check your state law or a local attorney before accepting money from a tenant you have served.

Keep the security deposit off the rent ledger

The security deposit is not rent and should not be used to reduce the rent balance during the tenancy unless your lease and state law allow it. Track it separately: amount, date received, where it is held, and any interest your state requires. At move-out, the deductions and the refund go on a separate itemized statement. See security deposit laws by state for deadlines.

Why the ledger matters in a dispute

When a disagreement over money reaches a judge, a mediator or a deposit hearing, the question is usually simple: what was owed, what was paid, and when. A ledger with dated lines, payment references and a running balance answers it in one page. A landlord working from memory and bank statements often cannot.

In an eviction for nonpayment, courts commonly expect the landlord to show how the amount claimed was calculated. A clean ledger, with late fees entered as separate lines that match the lease, makes that much easier. Procedures and requirements vary by state and county. This is general information, not legal advice; talk to a local attorney for your specific situation.

How long to keep the records

The IRS generally says to keep records that support your tax return for as long as they may be needed, which typically means at least three years after you file, and longer in some situations. Records about the property itself, such as the purchase and improvements, are generally kept until after you sell, because they affect your gain. Leases, ledgers and deposit records may also matter for disputes long after a tenant moves out, and some states have their own requirements. Ask a tax professional how long you should keep yours. Rent and expenses for the year feed into Schedule E, and a good ledger makes that form much faster.

How RentMerchant fits

If keeping a spreadsheet up to date is the part you keep skipping, software can keep the ledger for you. In RentMerchant, every invoice and payment is kept per tenant. Recurring monthly rent creates the charge each month, automatic late fees are added on the terms you set, and online payments by bank transfer or card post to the invoice with a receipt.

When rent comes in as cash, a check or a money order, you record it against the invoice, including partial amounts, with a note such as the check number. Tenants see their own payment ledger in their portal, so you are both looking at the same numbers. Security deposits are tracked separately. For tax time there are reports with CSV export and an expense tracker with a Schedule E export.

The Free plan covers up to three properties with unlimited units. You can see the full feature list, or create a free landlord account and set up one tenant to see how the ledger looks.