What is a rent ledger?
A rent ledger is a dated record of charges, payments, credits and the running rent balance for one tenancy. It shows what was charged, what was recorded as paid and what remains due or in credit.
Rental ledger, tenant ledger and lease ledger often describe the same kind of record. A tenant ledger may include other charges alongside rent. Whatever you call it, each entry should explain what changed and when. RentLedgerKit currently records amounts in US dollars.
What should a rent ledger include?
Start with the property address, unit, tenant, landlord or manager, and the date your record begins. Record the monthly rent and due day so readers can understand the schedule. Then keep enough detail to trace each transaction:
- Transaction date: when the charge was due or the payment or adjustment occurred.
- Type and description: rent charge, payment, credit or refund, with a useful explanation.
- Amount: the charge or payment amount, entered separately so its effect is clear.
- Rent period: the month an entry relates to, which can differ from the payment date.
- Reference: a receipt number or payment reference you can match to supporting records.
- Running balance: the amount due or in credit after that entry.
Keep security deposit receipts and returns identifiable and separate from the rent balance. A deposit received is not automatically a rent payment in RentLedgerKit.
How does the running balance work?
Begin with an opening balance as of a specific date. A positive opening balance means rent was already due; a negative one means a rent credit. Avoid importing earlier transactions again if their amounts are already included in that opening position.
Rent balance = opening balance + charges + recorded rent refunds − payments − credits. Reversals undo the effect of the original entry. Deposit receipts and returns change the separate deposit balance.
A positive result shows an amount due. Zero means the recorded charges and reductions balance. A negative result shows a rent credit. These figures depend on the entries you supply; a correct calculation does not prove that every payment was recorded. See our worked rent ledger example for partial payments and a carried balance.
Rent ledger, rent roll, receipt or statement?
| Record | What it shows | Typical scope |
|---|---|---|
| Rent ledger | A sequence of charges, payments and running balances. | One tenancy over time. |
| Rent roll | A summary of units, tenants, rents and occupancy. | A property or portfolio at a point in time. |
| Rent receipt | Details of one payment received. | An individual transaction. |
| Tenant statement | A dated presentation of ledger activity and the balance. | A selected period or an as-of date. |
A receipt can support a payment entry without replacing the full ledger. A statement makes the ledger easier to share. RentLedgerKit can export PDF statements and CSV records; its free template includes a separate Excel formula workbook.
How landlords can keep the record useful
Record charges and payments as separate events. If a tenant pays in two installments, enter both payments on their actual dates rather than replacing the first amount. Add a reference and rent period so a later review does not depend on memory.
Compare entries with receipts and your own payment records. A bank record helps establish that a transfer occurred; the ledger explains how you recorded it. When a mistake appears in a saved ledger, add a reversal and a corrected entry. Keeping the original visible explains the change.
How tenants can read and check a ledger
Check the property, tenancy dates and opening balance first. Then match each payment with your receipts or transfer records, paying attention to its date, amount and reference. Ask about a missing payment or unfamiliar charge using the specific entry, rather than only comparing the final total.
In RentLedgerKit, a landlord can invite a tenant to view one tenancy using a matching verified email address. Tenant access is free and read-only, with statement and receipt downloads. The tenant cannot change the landlord’s entries. A tenant’s own record can help a discussion, but it does not become the landlord’s official record automatically.
Start with a template, then keep the evidence
Use the free rent ledger template and generator to start a record or import one CSV or XLSX sheet. Use the rent ledger balance checker to review arithmetic, possible duplicates and differences from reported balances. An empty cell alone does not establish unpaid rent.
Free tools read files in your browser. Export before closing the page, or choose to save records to an account. Read how data and tenant access work and compare saved workspace pricing. A ledger organizes supplied information; it does not determine whether a fee is permitted or guarantee acceptance in a dispute. Seek appropriate advice for a specific legal or tax question.