Rental Ledger Generator
Build a rental ledger from agreed rent and actual payments, then reconcile and export the record.
Working rental ledger
Example inputsCheck the marked entry to create your ledger.
- $1,000.00
- $2,650.00
- $1,650.00
- 2
Unverified working ledger
Fictional Harbour tenancy
5 Jan 2026 to 1 Feb 2026
Positive balance means owing. Negative balance means credit.
Records to review
Charges and Payments
| Date / record | Debit | Credit | Balance |
|---|---|---|---|
| 5 Jan 2026 Opening balance Entered opening balance | $0.00 | $0.00 | $0.00 |
| 5 Jan 2026 Rent charge 5 Jan 2026 to 11 Jan 2026 | $650.00 | $0.00 | $650.00 |
| 5 Jan 2026 Payment Example A 5 Jan 2026 to 11 Jan 2026: $650.00 | $0.00 | $650.00 | $0.00 |
| 12 Jan 2026 Rent charge 12 Jan 2026 to 18 Jan 2026 | $650.00 | $0.00 | $650.00 |
| 12 Jan 2026 Payment Example B 12 Jan 2026 to 18 Jan 2026: $325.00 | $0.00 | $325.00 | $325.00 |
| 19 Jan 2026 Rent charge 19 Jan 2026 to 25 Jan 2026 | $675.00 | $0.00 | $1,000.00 |
| 26 Jan 2026 Rent charge 26 Jan 2026 to 1 Feb 2026 | $675.00 | $0.00 | $1,675.00 |
| 26 Jan 2026 Payment Example C 12 Jan 2026 to 18 Jan 2026: $325.00; 19 Jan 2026 to 25 Jan 2026: $350.00 | $0.00 | $675.00 | $1,000.00 |
Period Allocations
| Period | Rent | Payments | Other credits | Unpaid |
|---|---|---|---|---|
| 5 Jan 2026 to 11 Jan 2026 | $650.00 | $650.00 | $0.00 | $0.00 |
| 12 Jan 2026 to 18 Jan 2026 | $650.00 | $650.00 | $0.00 | $0.00 |
| 19 Jan 2026 to 25 Jan 2026 | $675.00 | $350.00 | $0.00 | $325.00 |
| 26 Jan 2026 to 1 Feb 2026 | $675.00 | $0.00 | $0.00 | $675.00 |
Based on entered records. No issuer verification or lender acceptance is established.
Enter the Tenancy and Payments
This rental ledger generator separates rent charges from the payments you actually enter. It creates a running account for the selected period, with payment allocations and an export you can reconcile against the original records.
Enter the agreed rent and its frequency, then choose the first charge date and the ledger end date. Start on an agreed due date where possible. Carry an existing debt or credit into the opening balance instead of recreating payments outside the selected period.
Paste each actual payment as a separate comma-separated row: ISO date, amount and reference. Use a reference you can trace to a receipt or transaction. Amounts accept up to two decimal places; enter plain numbers without thousands separators, or quote a cell containing a comma.
The rent changes box takes an effective date, the new agreed amount and weekly, fortnightly or monthly. Each change starts a new rent cycle. Enter an agreed credit, correction or refund in Adjustments with its date and signed amount, plus the reason.
A negative adjustment reduces the amount owing. A positive adjustment increases it. Keep bond and utility payments out of the rent payment list, and retain the document supporting every adjustment.
Charges and Running Balance
The closing balance equals the opening balance plus rent charges and signed adjustments, less actual payments. A positive result is an amount outstanding in the entered account; a negative result is credit.
Weekly cycles contain seven days and fortnightly cycles contain fourteen. Monthly cycles keep the original day of the month, using the last valid day when necessary. A shortened final cycle or a rent change within a cycle uses the actual days in that cycle, rounded to cents.
The ledger posts each charge at the period’s start. On the same date, it posts opening balance first, rent charges next, adjustments next and payments last. This ordering makes the running balance reproducible.
Payments and other credits reduce the oldest outstanding debit first. The allocation column shows which periods each credit covers, while the period table separates actual payments from other credits. An advance payment stays as credit until a charge uses it.
The fictional example has four weekly charges: $650 twice, then $675 twice. Actual payments total $1,650 against $2,650 charged, leaving $1,000 outstanding. The final two periods retain unpaid amounts of $325 and $675.
The example’s second payment is only $325, and one rent period has no payment entry. The generator keeps those facts visible. It never creates a receipt to fill a missing period or changes an actual payment date to its due date.
Reconcile and Export
Reconcile the generated ledger against the tenancy agreement, agreed rent changes and original payment evidence. Match every entered payment to its receipt or bank transaction. A period with unpaid rent identifies a gap in this entered account; it does not prove why the gap exists.
Identical payment dates, amounts and references trigger a possible duplicate warning. Both rows stay included until you correct the input. Two real payments with the same details need separate supporting records; an accidental repeated row must be removed.
The allocation method is a calculation convention. Compare its allocations with the landlord or property manager’s record, especially where an opening balance or adjustment changes the periods covered. Resolve differences before using the export in a lending file.
NSW Fair Trading’s rent record guidance lists payer and recipient details, the property and the payment period alongside the payment date and amount. Obtain the issuer’s record when you need that evidence. This working ledger uses a tenancy label and does not replace the issuer’s record.
The Queensland Residential Tenancies Authority’s rent ledger example keeps the due date distinct from the actual payment date. Preserve that distinction when reconciling a late or partial payment.
Download CSV for spreadsheet reconciliation. Its dates remain in ISO format and money remains in plain numbers with cents. Download HTML for a readable document, or use Print / save PDF for the complete ledger.
Generation and downloads happen in your browser. Entries stay in this page’s memory without upload or account storage. Download before reloading or closing the page; Reset example restores the fictional records.
Generating a ledger does not make it an issuer-verified rental history or establish lender acceptance. A broker still needs the lender’s evidence requirements and the original records that substantiate the history.