A rent ledger that adds up.
Track charges, record payments, and download a clear tenant statement. Start with our example or make it your own.
Maple House · Unit 2A
184 Maple Street, Portland, OR · Unit 2A · Jordan Ellis
| Date | Transaction | Rent period | Charge | Payment / credit | Rent balance | Actions |
|---|---|---|---|---|---|---|
| 2026-08-01 | Opening rent balance | $0.00 | ||||
| Aug 1, 2026 | Deposit receivedSecurity deposit — held separately | — | — | — | $0.00 | |
| Aug 1, 2026 | Rent / chargeMonthly rent | 2026-08 | $1,200.00 | — | $1,200.00 | |
| Aug 3, 2026 | PaymentBank transfer | 2026-08 | — | $1,200.00 | $0.00 | |
| Sep 1, 2026 | Rent / chargeMonthly rent | 2026-09 | $1,200.00 | — | $1,200.00 | |
| Sep 4, 2026 | PaymentBank transfer | 2026-09 | — | $1,200.00 | $0.00 | |
| Oct 1, 2026 | Rent / chargeMonthly rent | 2026-10 | $1,200.00 | — | $1,200.00 | |
| Oct 5, 2026 | PaymentPartial payment · bank transfer | 2026-10 | — | $800.00 | $400.00 | |
A clearer way to keep
a rent ledger.
A rent ledger records rent charges and payments over time. The running balance shows what is still due or held as a rent credit.
Can I record a partial rent payment?
Yes. Add each payment on the date it was received and assign its rent period. Two payments can settle one monthly charge without charging rent twice.
Does the security deposit reduce rent due?
No. Deposits received and returned have their own balance. They do not automatically settle rent.
Can I use my existing spreadsheet?
Import one CSV or XLSX sheet with a date, transaction type and amount, or separate charge/payment columns. Review the mapping, duplicates and any reported balance differences first.
What happens when I close this free tool?
Unsaved records leave this tool when the page is closed. Download an export or choose “Save workspace” to keep records in an account. Files are read in your browser until you save.