A rent ledger is a running record of charges, credits and payments for one tenancy. Each row should explain what changed and leave a balance you can trace back to supporting records. The downloadable template keeps that structure simple enough to use in a spreadsheet or import into another system.
Start with the blank file or the worked example
Download the blank rent ledger CSV
Includes column headers and a zero opening row; replace it with the verified opening balance.
Download the worked rent ledger CSV
A fictional $1,500 rent charge, two payments and a correction.
Keep one ledger per tenancy. Use a property or tenancy code when possible, and store any file containing resident information securely. These downloads contain no real resident data and do not send your entries to this site.
The CSV is a portable record, not an automated accounting system. It contains values rather than spreadsheet formulas. After importing it, either maintain the balance column carefully or add your own running-balance formula.
Give every change a clear explanation
| Column | What to enter |
|---|---|
| Date and period | The entry date and the rental period it concerns |
| Reference | A payment, invoice or adjustment reference you can retrieve |
| Description | A plain explanation of the charge or change |
| Charge / credit / payment | Use the matching column; do not count the same amount twice |
| Balance | Previous balance + charges − credits − payments |
| Status / evidence | Pending or settled status and the location of the supporting record |
A positive balance means an amount remains outstanding in this example; a negative balance means a credit remains. Use a consistent convention and explain it to anyone reading the file. The IRS’s general business recordkeeping guidance calls for income and expense records supported by documents such as receipts and statements. [1]
A partial payment is easier to follow on its own row
| Entry | Charge | Payment or credit | Balance |
|---|---|---|---|
| Opening balance | $0 | $0 | $0 |
| Monthly rent charge | $1,500 | $0 | $1,500 |
| First settled payment | $0 | $1,000 | $500 |
| Second settled payment | $0 | $500 | $0 |
| Illustrative duplicate charge | $75 | $0 | $75 |
| Correction reversing duplicate | $0 | $75 credit | $0 |
The correction leaves a visible trail. Deleting the duplicate row would hide why an earlier statement showed a different balance. Use an explanation and a reference so another reader can follow the change without asking you to reconstruct it.
Do not treat a scheduled payment as settled money. If you record a pending transaction, keep its status clear and ensure the balance calculation follows your chosen accounting process. Reconcile against the payment service and bank records before treating the period as complete.
Reconcile before sending a statement
- Confirm the opening balance against the previous period.
- Match every payment to its supporting transaction.
- Check that refunds, returns and credits are recorded once.
- Review the closing balance and unresolved items.
- Save a dated copy with the supporting documents.
A ledger explains arithmetic; it does not establish whether a particular fee is permitted or an amount is legally due. Check the agreement and applicable requirements before posting a charge. This template does not calculate late fees, manage deposits or replace jurisdiction-specific notices.
When changing software, export a small sample first. Check dates, references and signs on credits, then compare the closing balance in both systems. A file that opens successfully can still contain a mapping error.
Sources
- IRS: What kind of records should I keep?Source checked Sep 21, 2026.
Have a correction? See our editorial policy and correction process.