The short answer
Keep a dated record of charges, payments, credits and reversals for each tenancy. Each entry should identify the period, amount and supporting reference so the running balance can be explained.
On this page
Record charges and receipts separately
A rent charge increases the amount owed; a payment reduces it. Identify the property, unit, tenant and rental period. Keep deposits identifiable and follow the applicable accounting and deposit-handling rules rather than treating all incoming money as rent.
Preserve the history
Correct mistakes with a clear adjustment or reversal record instead of silently replacing a past entry. Example: a $1,500 charge and $900 payment leave $600 due before other valid entries. If the payment is returned, preserve both the payment and its reversal.
Reconcile regularly
Compare the ledger with payment-provider and bank records. Distinguish pending transactions from completed ones and record outside payments only once. Save receipts and notes explaining adjustments, then provide a clear account statement when needed.
Identify the opening balance and review date
Use the existing blank worksheet for one clearly identified tenancy and period. Keep the lease reference, start/end dates, statement cutoff, preparer and review date with it. Before entering new activity, verify any opening balance against the prior statement and source records; an empty cell means missing information, not a verified zero.
Record each separate event with the appropriate charge or payment fields and supporting reference. Keep credits, reversals and disputed allocations identifiable in the notes or a linked adjustment record. Review which obligation a payment reduces under the actual agreement and applicable rules. Explain the resulting balance from supported entries; the CSV supplies blank fields and does not calculate or certify it.
Use and share the ledger for its defined purpose
A rent ledger supports a tenancy's charge and payment review. It does not replace the signed lease, bank reconciliation, complete accounting books or tax return. IRS rental-income guidance distinguishes recognition timing, advance rent and refundable deposits; have tax treatment reviewed separately from the displayed amount owed.
Give an authorized recipient a dated copy limited to the relevant tenancy and purpose, retaining source references and explanations for corrections. Let the renter identify a missing payment or disputed entry and investigate it against the underlying evidence. Record the reviewer and unresolved issue; a signature does not resolve a disagreement or prove every balance.
Keep contact preferences, pet details, repair logs and sensitive personal information in their appropriate protected records rather than adding them indiscriminately to a shared payment statement. A ledger may support professional review, but the recipient's evidentiary or underwriting requirements still need checking. Software records and a template do not guarantee a court or financing outcome.
Your next-step checklist
- Identify the tenancy and period
- Separate charges, payments and deposits
- Explain every adjustment
- Reconcile to supporting records
Sources and further reading
Take the worksheet with you
Download the blank rent ledger (CSV). Open it in your spreadsheet app and fill it with your own records.
Common questions
Is a rent ledger the same as the lease?
No. The lease records the agreed tenancy terms; the ledger records relevant charges, payments and adjustments. Include a lease reference, but retain the signed agreement separately.
How does a rent ledger differ from a rent roll?
A tenant ledger follows one tenancy's financial activity. A rent roll summarizes units, lease terms, scheduled rent and occupancy for its stated scope and date. Read each report's columns; scheduled rent is not proof of receipt.
Should a renter review the rent ledger?
A dated tenancy statement can help identify omitted payments or disputed entries. Protect unrelated records and investigate discrepancies. Do not treat a requested signature or silence as proof that the balance is correct.
Does a completed ledger template guarantee acceptance in court?
No. Retain the dated record, source documents and correction history, and check the relevant proceeding's evidence requirements with qualified help. A filled template or signature does not guarantee authenticity or admissibility.
Written and maintained by the Rentari team. Examples explain a decision; they are not customer results. Found an error or an unclear step? Send a correction with this page's address and the detail to review.
Your next step
Follow rent activity in Rentari