How to make a tenant payment history record
A tenant payment history, also called a rent ledger statement, is a dated list of what a tenant was charged and what they paid, with a balance after each line. It is the simplest proof of who owes what. Here is how to put one together and when you will be glad you have it.
What a statement shows
- Charges. Rent due each month, late fees if your lease allows them, and other amounts the tenant owes.
- Payments. The date, amount, and method of each payment, and the period it covers.
- Running balance. What the tenant owes (or is owed) after every line.
- Header details. Tenant name, property address and unit, and the date range the statement covers.
When you will need one
- The tenant needs proof of rent. A mortgage lender or a new landlord may ask for a record of on-time payments.
- A rent dispute. If a tenant says they paid and you say they did not, the ledger settles it with dates and amounts.
- Small-claims court. If you ever file for unpaid rent, a clean statement is the first thing a judge or clerk will want to see. Check your local court’s rules for what to bring.
- Move-out. When you settle the security deposit, a statement shows whether any rent is still owed.
Sample statement
The numbers below are made up to show the layout.
Sample statement: Jordan Example, Unit 2B, January to March
| Date | Description | Charge | Payment | Balance |
|---|---|---|---|---|
| Jan 1 | January rent | $1,000.00 | $1,000.00 | |
| Jan 3 | Payment, check #1042 | $1,000.00 | $0.00 | |
| Feb 1 | February rent | $1,000.00 | $1,000.00 | |
| Feb 5 | Payment, bank transfer (partial) | $600.00 | $400.00 | |
| Feb 20 | Payment, bank transfer | $400.00 | $0.00 | |
| Mar 1 | March rent | $1,000.00 | $1,000.00 | |
| Mar 2 | Payment, check #1051 | $1,000.00 | $0.00 |
Notice how each line stands alone. Anyone can read it top to bottom and see exactly what happened, and the balance is easy to check by hand.
Tips for a statement people trust
- Never edit or delete a past entry. If you change history, the record stops being believable.
- Add corrections as new lines. If you entered $1,000 but the check was for $100, add a line that fixes the difference and say why. Both the mistake and the fix stay visible.
- Record payments the day they arrive. Dates you wrote from memory a month later are easy to challenge.
- Describe each line in plain words. “February rent” beats “payment.”
- Apply partial payments to the oldest charge first and use the same rule every time.
- Keep the supporting papers. Receipts, check photos, and bank confirmations back up each line.
Making one
You can build a statement in a spreadsheet. Our free rent ledger template already has the columns and the balance math. Fill in the tenant details, add a line for each charge and payment, and print or save it as a PDF when someone asks.
LedgerLatch keeps this history for you, one ledger per tenant, and works out the balance after each line. It only tracks rent. It never collects or moves money. It is free for one unit.
LedgerLatch is the rent ledger for landlords with 1 to 10 units: rent posts itself, payments get stamped, statements print in one tap. Free for 1 unit.