Home › Guides › Rent ledger template
Rent ledger template: what to include and how to keep it
A rent ledger is the most useful document a small landlord keeps. It shows, for one tenant, every charge and every payment in date order, with a running balance. When a tenant asks "what do I owe?", when you prepare for tax time, or when a dispute ends up in front of a judge, the ledger is what you reach for. Here's what a good one contains and how to keep it accurate.
Rent ledger vs rent roll vs bookkeeping
Three records often get confused:
- Rent ledger (tenant ledger): one tenant, over time. Every charge, payment and credit with a running balance.
- Rent roll: all units, at one moment. Who pays what, what was received this month, and the status of each unit.
- Bookkeeping: your own income and expenses per property, organized for taxes.
The ledger feeds the other two: the rent roll summarizes ledgers for one month, and your bookkeeping records the payments as income.
The header: tenancy details
At the top of each ledger (or in a separate tenants list it refers to), record:
- Tenant name(s) and contact details
- Property address and unit
- Lease start and end dates
- Monthly rent and due day
- Grace period and late fee rule, exactly as written in the lease
- Security deposit amount and date received
- A tenant or unit ID, so every ledger line can be linked to the right tenancy
The columns
| Column | What goes in it |
|---|---|
| Date | When the charge applies or the payment was received |
| Type | Rent, payment, late fee, other charge, credit |
| Description | "March rent", "Payment – check #1042", "Late fee – Feb" |
| Charge | Amounts the tenant owes |
| Payment / credit | Amounts received or credited |
| Balance | Previous balance + charge − payment/credit |
| Method / reference | ACH, check number, money order, receipt number |
| Notes | Payment plan, dispute, bounced check |
A receipt number for each payment makes it easy to issue receipts and to refer to a payment in a conversation or a letter.
A worked example
A made-up tenant with rent of $1,450 due on the 1st, a 5-day grace period and a $50 late fee in the lease:
| Date | Description | Charge | Payment / credit | Balance |
|---|---|---|---|---|
| Jan 1 | January rent | $1,450.00 | $1,450.00 | |
| Jan 3 | Payment, ACH | $1,450.00 | $0.00 | |
| Feb 1 | February rent | $1,450.00 | $1,450.00 | |
| Feb 4 | Payment, check #1042 | $900.00 | $550.00 | |
| Feb 7 | Late fee (balance unpaid after grace period) | $50.00 | $600.00 | |
| Feb 15 | Payment, ACH | $600.00 | $0.00 | |
| Mar 1 | March rent | $1,450.00 | $1,450.00 | |
| Mar 1 | Credit: approved repair paid by tenant (receipt on file) | $120.00 | $1,330.00 | |
| Mar 2 | Payment, ACH | $1,330.00 | $0.00 | |
| Apr 1 | April rent | $1,450.00 | $1,450.00 | |
| Apr 3 | Payment, ACH | $1,500.00 | −$50.00 |
Totals: charges $5,850.00, payments $5,780.00, credits $120.00, ending balance −$50.00. The negative balance means the tenant has paid $50 ahead, which reduces May's amount due.
What makes this ledger useful:
- The partial payment in February is visible, and so is when it was cleared.
- The late fee is its own line, dated the day after the grace period ended, rather than being hidden in a changed rent amount.
- The credit is explained, with a note that the receipt is on file.
- The overpayment carries forward instead of being "rounded off".
Rent Ledger & Late Rent Tracker
Know who paid, who owes, and for how long. Add your tenants once and log payments as they come in. Rent is charged on each due day, late fees follow your rule, and every balance updates by itself.
Excel & Google Sheets · sample + blank file · PDF guide
Security deposits: record them, but separately
The tenant also paid a $1,450 security deposit at move-in. It does not appear in the balance above, and it shouldn't. A deposit is money you hold, usually under specific state rules about where it's kept, whether interest is due, and how quickly it must be returned with an itemized list of deductions. Track it on its own: date received, amount, where it's held, and later any deductions and the amount returned.
For taxes, IRS Publication 527 says a deposit you plan to return isn't income when you receive it; if you keep part or all of it, that part becomes income in the year you keep it.
Rules that keep a ledger trustworthy
- Never delete or overwrite a line. If something was entered wrong, add a correcting line (for example "Reversal – check #1042 returned"). A ledger with edits you can't trace is much weaker evidence.
- Charge rent on the due date, even before it's paid. The balance should always reflect what's owed today.
- Record payments on the day received, for the amount received.
- Keep fees separate from rent. Late fees, returned-check fees and repair charges each get their own line, and only if your lease and local law allow them.
- Match every payment to a bank deposit once a month.
- Keep notes short and factual. "Tenant called 2/5, will pay balance 2/15" is useful; opinions are not.
Statements and receipts
Two outputs come straight from a good ledger:
- A tenant statement: the ledger lines for a period with the opening and closing balance. Handy when a tenant asks what they owe, or when you send a balance reminder.
- A rent receipt for a single payment: date received, amount, who paid, the property, the period it covers and the payment method. Some states require receipts in certain situations (New York, for example, for rent paid in cash or by anything other than a personal check), and they're good practice everywhere.
Common rent ledger mistakes
- Only recording payments. Without charges, there's no balance, and no way to show what was owed when.
- Editing the rent amount to include a fee or a discount, instead of adding a separate line.
- Mixing tenants in one list without IDs, which makes per-tenant balances unreliable.
- Putting the deposit in the balance, which makes the tenant look paid ahead.
- Not carrying balances into the new year. If you start a new file each January, bring each tenant's opening balance across as a dated line.
How often to update it
Log payments as they arrive, or at least weekly, and check every tenant's balance once a month right after the grace period ends. If you have more than a few units, a monthly rent roll built from the ledgers shows everything on one screen.
A spreadsheet that does this for you
You can keep a ledger in any spreadsheet, but the error-prone part is the arithmetic: charging rent every month, applying late fees consistently, and keeping every running balance correct across many tenants. That's what our Rent Ledger & Late Rent Tracker automates: rent is charged on each due day, late fees follow your rule, balances and aging update by themselves, and statements and receipts print from the ledger.
Landlord Complete Bundle
Analyse it. Collect the rent. Keep the books through tax time. The three Spruce Sheets workbooks together, for $39 instead of $55.
Excel & Google Sheets · sample + blank file · PDF guide
General information, not legal or tax advice. Deposit, receipt and late-fee rules vary by state and city; check the rules where your property is.
Frequently asked questions
What is a rent ledger?
A rent ledger, also called a tenant ledger, is a dated record of every charge to a tenant (rent, fees, other charges) and every payment or credit, with a running balance that shows what the tenant owes at any point.
Should the security deposit be in the rent ledger?
Record it, but keep it separate from the rent balance. A deposit is held money, not a rent payment, and mixing the two makes the balance misleading. Note the date and amount received, and later any deductions and the amount returned.
Is a rent ledger the same as a rent roll?
No. A ledger follows one tenant over time. A rent roll is a snapshot of all units at one moment, showing rent due, rent received and status for each.