How to keep a rent ledger
Post every charge and payment on one lease ledger, apply cash to the oldest charge, and keep the balance you would defend later.
On this page
The short answer
A rent ledger lists every charge and payment on one lease and the balance still open. Post charges and payments on separate lines, apply a partial payment to the oldest charge first, and do not delete a line you later waive. A credit explains the change. The balance should match the rent receipt and the cash that reached the trust account. One ledger per lease, from move-in through move-out, is the record you collect from.
Key takeaways
- Keep one ledger per lease, with the date, description, charge, payment, and running balance.
- Post charges even when the check is already in hand, dated the day they were due.
- Apply a partial payment to the oldest charge first, and credit a waiver instead of erasing the charge.
- Match each payment to a trust-account deposit before you send the owner statement.
A rent ledger is the running list of what the tenant was charged, what they paid, and what is still open. Keep one ledger per lease, in date order, and do not delete a line after you send a receipt. The balance on the ledger is the balance you collect, the balance you put on a rent receipt, and the rent income you report to the owner.
"Rent ledger" is searched about 4,400 times a month in the United States. Most of those searches want a printable sheet. A sheet helps only if every line ties to a charge or a deposit. A spreadsheet that starts over each January hides the March balance that was never paid.
What is a rent ledger?
A rent ledger is the tenant's account. Each line is either a charge (money they owe) or a payment (money you received). The balance is charges minus payments, from the first day of the lease through today.
It is not the owner's statement. The owner statement shows income, fees, and bills for the property. The rent ledger shows one lease. If you manage 30 units, you have 30 ledgers, and the owner statement adds up the rent those ledgers earned.
Which columns should the ledger have?
Use the same columns on every lease so a new hire can read a file without asking you.
| Column | What it holds |
|---|---|
| Date | The charge due date, or the day the payment arrived |
| Description | The charge name and the period, or the payment method |
| Charge | Amount added to what they owe |
| Payment | Amount you received |
| Balance | Running total after that line |
Leave the payment cell blank on a charge line, and the charge cell blank on a payment line. Putting both on one line hides whether the month was billed.
How do you post a normal month?
April 2026 at 14 Maple Street, Unit 2. Rent is $1,850. Parking is $75. Both are due April 1. The tenant pays $1,925 by check 4412 that day.
| Date | Description | Charge | Payment | Balance |
|---|---|---|---|---|
| Apr 1, 2026 | Rent, April 2026 | $1,850.00 | $1,850.00 | |
| Apr 1, 2026 | Parking, April 2026 | $75.00 | $1,925.00 | |
| Apr 1, 2026 | Payment, check 4412 | $1,925.00 | $0.00 |
Post the charges even when you already have the check in hand. A ledger that only shows payments cannot tell you what was billed. Post charges on the due date, then the payment on the day it arrives. If the check arrives April 3, the April 1 lines stay, and the payment is dated April 3. That gap is the late-fee clock, if the lease has one.
How do you post a partial payment?
Apply the payment to the oldest charge first. March pet rent of $48.39 is still open. On April 3 the tenant pays $1,000.
The $1,000 clears $48.39 of pet rent and puts $951.61 against April rent. April rent was $1,850, so $898.39 of April rent remains, and April parking of $75 remains. The running balance is $973.39. Write that balance. Do not start a fresh April ledger and leave the $48.39 on a March tab nobody opens.
If you waive a charge, post a credit line with the reason: "Credit, March pet rent waived, owner approval April 4." Do not erase the original charge. The owner, and a later manager, need to see that the charge existed.
How does the ledger stay tied to the trust account?
Every payment on a tenant ledger should match a deposit into the trust account, the same day or the next banking day. Cash is the usual break. Count the cash, write the receipt, post the ledger, and deposit the cash. If the ledger says $1,000 cash and the deposit slip says $900, stop and find the $100 before you send the owner statement.
Tivio is property management software for independent property managers. Charges and payments sit on the lease, payments apply to the oldest charge first, and the open balance is what the who-owes report exports to CSV. The monthly owner statement PDF uses the rent those lines earned, not a number typed beside them.
A clean ledger has four habits:
- One ledger per lease, from move-in through move-out.
- Charges and payments on separate lines.
- Oldest charge first, unless the lease says otherwise.
- No deleted lines. Credits explain a change.
When the balance on the screen matches the balance you would defend in a hearing, the ledger is done for the day.
Frequently asked questions
Is a rent ledger the same as an owner statement?
No. The ledger is one lease. The owner statement is the month's income, fees, and bills for the property. The statement adds up rent the ledgers earned. It does not replace them.
Should I start a new ledger every January?
No. Keep the same ledger from move-in through move-out. A fresh sheet hides a balance that was never paid.
What if I waive a charge?
Post a credit with the date and the reason. Leave the original charge in place so the file still shows that it was billed.
How do partial payments hit the ledger?
Apply them to the oldest open charge first, unless the lease names a different order. Write the remaining balance. Do not mark the new month paid while an older charge is open.
Sources
- How to write a rent receipt (with a sample), Tivio
- California Tenants: obtaining receipts for rent payments, California Department of Real Estate
