Free Rent Ledger Template
Build a monthly rent ledger with automatically calculated running balances. Download your rent ledger as PDF or CSV for free, without login.
Private to this page · No account required · Download before leaving
What is a rent ledger?
A rent ledger is a chronological record of the rent charged and the payments received for a tenancy. Each monthly row connects a due date with an amount due, an amount paid and a payment date. The running balance carries the unpaid difference into the next row. A positive balance means charges exceed recorded payments; a negative balance means recorded payments exceed charges. A ledger gives landlords and tenants a shared starting point for reviewing account history, but its accuracy depends entirely on the entries and the supporting payment evidence.
When to update your ledger
Update the ledger when rent becomes due and when a confirmed payment is received. Enter rows in chronological order because this template calculates the balance in the displayed order. Use one ledger for one tenancy rather than combining unrelated properties. If you need to record earlier arrears, add an opening row showing that verified amount before the monthly rows. For multiple payments in a month, record the total confirmed amount and keep the individual payment references separately. The CSV is useful for further spreadsheet work, while the PDF provides a fixed copy for a dated account review.
What to include in your records
Use the full names of the landlord and tenant, the complete rental address and the unit identifier. Check dates against the lease and your payment records rather than relying on memory. Amounts should refer to a specific rental period, charge or payment so that someone reviewing the record later can understand it without an explanation. Add a short factual note when a payment is partial, when there is a correction, or when a reference number helps identify the transaction. Do not include bank account numbers, card details or unnecessary personal information.
Common mistakes to avoid
Do not treat a draft as evidence of payment, silently overwrite a disputed entry, or use a general template in place of a required state form. Review the completed document before sharing it and keep a dated copy alongside the underlying records. This tool does not verify transactions, send documents or save your entries to an account. Entries remain in this open page and are lost when you reload or leave it. Download your finished copy before closing the page. For legal requirements, consult the official state guidance below or a qualified local professional.
Frequently asked questions
How is the running balance calculated?
Each row adds its amount due and subtracts its amount paid from the previous balance, starting at zero.
Can the balance be negative?
Yes. A negative balance indicates that recorded payments exceed recorded charges; verify any credit against your actual records.
Can I export to a spreadsheet?
Yes. Download the CSV and open it in a spreadsheet application. The export contains the calculated balance for every row.
How do I include an opening balance?
Add an opening row before the monthly entries with the verified outstanding amount due, or a verified credit as amount paid.
Does this ledger collect rent?
No. It records the amounts you enter; it does not charge tenants, verify payments or connect to a bank.
