A bank deposit tells you money arrived. It does not tell you which tenant paid, which month the payment covered, whether the amount was partial, or what is still owed. A separate ledger can fill that gap, even for one unit.
A rent ledger is a running payment history for each property or tenant. Keep one row per payment, update it when money clears, and reconcile it against your bank activity every month. If you want to start in a spreadsheet, download the free blank rent ledger template.
The fields to track
| Field | Why it matters |
|---|---|
| Property and unit | Keeps payments tied to the right rental |
| Tenant | Identifies who made the payment |
| Rental period | Shows which month or dates the payment covers |
| Due date | Makes late payments visible |
| Date received | Records when the money actually arrived |
| Amount due and amount paid | Exposes partial payments and balances |
| Payment method | Helps match the entry to a bank, check, or cash record |
| Note or receipt number | Links adjustments and supporting documents |
Do not put several payments into one row. One row per transaction keeps split payments, roommate payments, refunds, and corrections understandable later.
A five-step monthly workflow
- Set the rent due for each unit. Record the due date and amount before payments arrive.
- Enter each payment when received. Include the date, amount, method, and rental period. For cash, issue a numbered receipt and save a copy.
- Keep partial payments separate. Enter what arrived, then leave the remaining balance visible. Do not overwrite the original amount due.
- Reconcile the ledger. At month end, match non-cash payments to the bank account or payment service. Investigate any payment that appears in only one place.
- Back up the records. Export or copy the ledger somewhere separate from the working file. Keep receipts and related documents with it.
Common mistakes
- Tracking deposits instead of rent. A combined deposit can hide which tenant paid.
- Recording only the amount paid. Without the amount due, partial payments look complete.
- Replacing old entries. Add a correction rather than erasing the history.
- Mixing personal and rental activity. Separate accounts make reconciliation much easier.
- Waiting until tax time. Months of unlabeled transactions are slow to reconstruct and easy to get wrong.
Why this matters at tax time
The IRS says landlords should keep records of rental income and expenses, identify the source of receipts, and support items reported on a return. The IRS says most individuals use cash-basis accounting, under which rental income is generally reported in the year received. A current rent ledger makes that annual total much easier to check.
The ledger is the index, not the only evidence. Keep canceled checks, bank records, receipts, and notes that support the entries. For more detail, see the IRS guidance on rental income, deductions, and recordkeeping.
General information, not tax or legal advice. Check the rules for your location and your tax situation.
Spreadsheet or rent tracker?
A spreadsheet can work if you use it consistently, preserve old entries, and back it up. A dedicated rent tracker saves setup and can calculate balances automatically. Whichever tool you choose, the habit matters most: record each payment once, reconcile monthly, and keep the supporting document.