What is a rent ledger?
A rent ledger is a running account for one tenancy: each row shows the period, the amount charged, any late fee, the payment received and the balance after it. It answers the questions a landlord, a tenant or a court asks most often, which is how much is owed and since when. The worksheet above builds it from the lease terms and the payments you enter, and the button under the result downloads the ledger as a CSV file you can open in Excel, Google Sheets or Numbers and keep adding to.
The example tenant pays $1,800 rent and $50 pet rent. In April they paid $1,000, so the month was short by $850 and a $75 late fee was added; May's $2,775 cleared both. September was missed entirely, so the ledger ends the year at $1,925: the $1,850 rent plus a second late fee.
How to keep a rent ledger
- One ledger per tenancy. Start it on the first rent due date of the lease, with any balance carried in from before.
- Post charges on the due date, separately for rent and for other charges such as pet rent or parking, so a partial payment is easy to trace.
- Post every payment on the day it is received, with the method and reference (check number, transfer ID). Record the actual amount, not the amount due.
- Add late fees only as the lease allows. Whether a fee can be charged, when and how much depends on the lease and on state and local law.
- Keep the security deposit off the rent lines. It belongs to the tenant until it is applied under the lease.
- Reconcile monthly against bank deposits, and give the tenant a copy or a receipt when asked.
| Month | Charged | Late fee | Paid | Balance |
|---|---|---|---|---|
| Jan 2026 | $1,850 | – | $1,850 | $0 |
| Feb 2026 | $1,850 | – | $1,850 | $0 |
| Mar 2026 | $1,850 | – | $1,850 | $0 |
| Apr 2026 | $1,850 | $75 | $1,000 | $925 |
| May 2026 | $1,850 | – | $2,775 | $0 |
Rent ledger and taxes
For a cash-basis landlord, the "rent received" total is the figure that matters for the tax return. Most individual taxpayers use the cash method and report income in the year they actually or constructively receive it, regardless of when it was earned.[1] That is why the ledger tracks payments, not just charges:
- Advance rent, any amount received before the period it covers, is income in the year received, whatever accounting method you use.[1]
- Security deposits are not income when received if you plan to return them; any part you keep is income, and a deposit to be used as the final month's rent is advance rent.[1]
- Expenses a tenant pays for you, such as a utility bill deducted from rent, count as rental income, and you can deduct them if they are deductible rental expenses.[1]
- A payment to cancel a lease is rent in the year you receive it.[1]
Unpaid rent that never arrives is not income to a cash-basis landlord, so the balance owed on the ledger is not taxed until it is paid.[1]
How long to keep rent records
The IRS says to keep records that support income on a return until the period of limitations for that return runs out, generally 3 years, and 6 years if income left off the return is more than 25% of the gross income shown.[2] Records connected to the property itself, such as purchase and improvement costs used for depreciation, are kept until the period of limitations expires for the year you dispose of the property.[2]
Rent ledger template (CSV)
The download is a plain CSV: one row per month with the charged amount, late fee, payment and balance, plus a total row. To keep using it as a template, add a row each month and set the balance cell to the previous balance plus charged plus late fee minus paid. The numbers come from your own entries; nothing is sent anywhere. For the property's whole-year picture, carry the rent received into the rental property spreadsheet or the rental cash flow calculator, and check a planned raise with the rent increase calculator.
Not legal or tax adviceLate-fee limits, grace periods, receipt and notice rules are set by state and local law and by the lease. This ledger only does the arithmetic. See the investment disclaimer.
Frequently asked questions
What is a rent ledger?
A month-by-month record of rent and other charges, late fees, payments received and the running balance for one tenancy.
What should a rent ledger include?
The tenant and unit, each due date and amount charged, each payment with its date and method, any late fee or credit, and the balance after every entry. Keep the security deposit on a separate line.
Is unpaid rent taxable income?
Not for a cash-basis landlord: rent is reported in the year it is actually or constructively received. Advance rent is income in the year received.
How long should a landlord keep rent records?
Generally 3 years after filing the return they support, 6 years if more than 25% of gross income was left off, and property records until the limitations period ends for the year the property is sold.