How to Track Rent Payments with a Simple Rent Ledger
If you have a few rentals, you probably know who has paid this month. But can you say exactly what a tenant paid in March last year, and whether a late fee was ever settled? A rent ledger makes that a 10-second answer instead of an hour digging through bank statements.
Free printable for this guide: Rent Payment Ledger
What a rent ledger is
A rent ledger is a running record of everything a tenant owes and pays. Each line shows a date, what was charged (rent, a late fee, a utility reimbursement), what was paid, how it was paid, and the balance afterward.
Keep one ledger per tenant or unit, per year. That keeps it short and easy to read.
Why it's worth the five minutes a month
- Fewer disputes. If a tenant thinks they paid and you think they didn't, a ledger with dates and payment methods settles it quickly.
- Easier taxes. The IRS says that in most cases you must include in your gross income all amounts you receive as rent. A ledger gives you a clean yearly total for each property.
- Spotting patterns early. You'll notice if a tenant starts paying later and later, while there's still time for a friendly conversation.
- A clear history. If you ever need to show a payment history, it's already written down.
What to record on every line
- Date the payment was received (not the date it was due).
- Amount due for the period.
- Amount paid.
- Payment method and a reference, like a check number or the last digits of a transfer confirmation.
- Late fees or other charges, if any, as their own line.
- Running balance after the payment.
Late fee rules, including how much you can charge and when, vary by state and city. Check your local rules before adding late fees, and make sure any fee matches your lease.
Tricky payments to watch for
The IRS lists a few kinds of payments that count as rental income and are easy to forget. They're worth recording clearly in your ledger:
- Advance rent. The IRS says to include advance rent in income in the year you receive it, no matter what period it covers. So if a tenant pays January's rent in December, it's income for the year you got it.
- Security deposits. According to the IRS, don't include a deposit in income when you receive it if you plan to return it. If you keep part or all of it because the tenant didn't meet the lease terms, include the amount you keep in income in that year. If a "deposit" is really meant to be the last month's rent, the IRS treats it as advance rent.
- Expenses a tenant pays for you. If a tenant pays a bill that's your responsibility (for example, a repair) and subtracts it from rent, the IRS counts that amount as rental income, and you may be able to deduct the expense.
- Lease cancellation payments. A payment from a tenant to cancel a lease is rent, per the IRS.
You don't need to be a tax expert to record these. Just write a note on the line, and your tax preparer will thank you.
Make it a monthly habit
Pick one day each month, like the 5th, to update every ledger. Match each payment to your bank deposits. If something is missing, you'll catch it while it's fresh.
Get the free ledger: Our Rent Payment Ledger tracks a full year of payments, late fees and running balances for one tenant or unit. Download it free here.
Want to give tenants proof of payment? Pair it with our Rent Receipt. At year-end, your ledger totals drop straight into the Year-End Tax Prep Checklist.
FAQ
Should I keep a separate ledger for each tenant?
Yes. One ledger per tenant or unit per year is easiest to read and makes disputes simple to resolve.
Do I record a security deposit in the rent ledger?
Note it separately so it doesn't get mixed up with rent. The IRS treats deposits you plan to return differently from rent, so keeping them apart makes tax time easier.
How long should I keep old ledgers?
The IRS says you generally need to keep records that support your income and deductions until the period of limitations for that return runs out, which is generally 3 years, and longer in some situations. Many landlords keep them longer to be safe.
The LandlordPrintables team
This article is general information, not legal or tax advice. Laws vary by state and city, so check your local rules.
Sources: IRS, Publication 527, Residential Rental Property; IRS, How long should I keep records?