Host Guides › Rent Ledger Template: How to Track Rent Payments, Partial Payments and Late Fees
Rent Ledger Template: How to Track Rent Payments, Partial Payments and Late Fees
A rent ledger is the one record that answers "who owes what, and since when?" in a few seconds. Receipts prove single payments; the ledger shows the whole history for a tenant, with a running balance. If you've ever scrolled through bank statements trying to work out whether a tenant caught up after a short month, a ledger fixes that.
This guide shows the columns a rent ledger needs, how to record the tricky cases (partial payments, late fees, credits), and a worked example. If you'd rather not build it yourself, there's a ready-made Excel and Google Sheets version at the end.
Not legal advice. Late fees, grace periods and how payments must be applied vary by state and city. Use only what your lease and local rules allow.
The columns every rent ledger needs
Keep one ledger (or one tab) per tenant or unit. Each row is one event: a charge or a payment.
| Column | What goes in it |
|---|---|
| Date | The date of the charge or the date you received the payment |
| Description | "October rent", "Late fee (Oct)", "Payment – check #1043", "Credit – repair reimbursement" |
| Charge | Amount the tenant owes from this row (rent, fees, other charges) |
| Payment | Amount received on this row |
| Running balance | Previous balance + charge − payment |
| Method / reference | Cash, check number, bank transfer, app |
| Receipt # | The number on the receipt you gave (R-0045) |
The running balance is the column that matters. A positive number means the tenant owes you; zero means they're current; a negative number is a credit.
Worked example: a partial month
| Date | Description | Charge | Payment | Balance |
|---|---|---|---|---|
| Oct 1 | October rent | $1,450 | $1,450 | |
| Oct 3 | Payment – bank transfer | $1,000 | $450 | |
| Oct 6 | Late fee (Oct), per lease | $50 | $500 | |
| Oct 15 | Payment – check #1043 | $500 | $0 | |
| Nov 1 | November rent | $1,450 | $1,450 |
Two payments, two receipts, one clear history. If this tenant ever says "I paid October in full," the ledger shows exactly when and how.
How to record the tricky cases
- Partial payments: record the amount actually received. Never round up to the rent amount or write "paid".
- Late fees: give them their own row, dated when they apply. Mixing fees into the rent row makes year-end totals wrong.
- Credits and reimbursements: enter them as a payment (or negative charge) with a clear description, so the balance stays right.
- Security deposits: keep them out of the rent ledger. A deposit isn't rent and is often held under separate rules.
- Bounced payments: add a row that reverses the payment (as a charge) plus any allowed returned-payment fee on its own row.
Paper, spreadsheet or software?
| Option | Good for | Watch out for |
|---|---|---|
| Paper ledger book | 1 tenant, cash or check | No totals, easy to lose, hard to share |
| Spreadsheet (Excel / Google Sheets) | 1–20 tenants, any payment method | You need formulas that don't break |
| Property management software | Larger portfolios, online rent collection | Monthly fees; receipts only for payments made through the platform |
For most small landlords, a spreadsheet is the sweet spot: one file, every tenant, no subscription.
A ready-made rent ledger (Excel + Google Sheets)
The Key & Kit Rent Ledger & Rent Receipts template does the running balance for you: up to 20 tenants, partial payments, an optional automatic late fee after a grace period you set, other charges and credits, a 12-month rent roll, and numbered receipts that fill themselves from any payment row. It also includes a fillable PDF receipt and an editable Word receipt for cash and check tenants. It's a one-time $12 (20% off with code LAUNCH20 through Nov 10).
Just need receipts? The free fillable rent receipt template is two receipts per page and costs nothing.
Frequently asked questions
What is a rent ledger?
A rent ledger is a running record of every charge and payment for a tenant, with a balance after each row. It shows at a glance whether the tenant is current, behind or in credit.
Is a rent ledger the same as a rent receipt?
No. A receipt confirms one payment to the tenant. A ledger is your full history of charges and payments. Most landlords use both.
Can I use Google Sheets for a rent ledger?
Yes. A spreadsheet ledger works well in Google Sheets or Excel as long as the balance formulas are set up once and protected from accidental edits.
How long should I keep rent ledgers?
The IRS generally says to keep records supporting income until the period of limitations for that return runs out, usually 3 years after filing and longer in some cases (IRS: How long should I keep records?). Many landlords keep ledgers for the whole tenancy plus several years.
Key & Kit templates are organizational tools, not legal or tax advice, and they aren't state-specific forms.