Rent Ledger Template
A rent ledger is a running record of every charge and payment for a tenant. Generate one for the next 12 months, then download it for Excel or Google Sheets or print it.
Fill in the details. The document below updates as you type.
How to use a rent ledger
Record every charge (rent, late fees, other charges allowed by the lease) and every payment on the date it happens. The running balance column tells you instantly whether a tenant is up to date. Keep one ledger per tenant, per lease.
- Charges: add rent on each due date, plus any late fees or other charges the lease allows.
- Payments: record the date received, amount, and method or reference (check number, transfer ID).
- Balance: previous balance + charges − payments. A positive balance means the tenant owes money.
Why a ledger matters
A clean ledger is the single most useful document if there's ever a dispute: in small claims, an eviction case, or when deducting from a security deposit. Courts expect to see a clear, dated record of what was charged and paid. It also makes tax time easier because your rental income is already totalled. See how to document late rent payments.
When a spreadsheet stops working
A ledger per tenant works well for a handful of units. Past that, the hard part isn't recording payments. It's noticing who hasn't paid and chasing them on time. That's where automated reminders and tracking help.
Frequently asked questions
What's the difference between a rent ledger and a rent roll?+
A rent ledger is the detailed payment history for one tenant. A rent roll is a summary of all units at a point in time: tenant, rent, lease dates, and current balance.
How long should landlords keep rent ledgers?+
Keep them for at least as long as the IRS can audit you, generally three years after filing (longer in some cases), and at least until any deposit dispute or legal claim is fully resolved. Many landlords keep them for seven years.
Related resources
Let Ping send the reminders for you
Ping emails your tenants before rent is due, on the due date, and follows up automatically if it's late. Free while we're in early access.