To rebuild rent payment history, pull every bank and payment-app statement for the period, list each deposit that could be rent, match each one to a tenant and a rental month, and enter the results in a ledger that carries any shortfall forward. What you cannot match gets marked as unverified rather than guessed.
That last part matters. A reconstructed ledger is only useful if someone else — a tenant, an accountant, a judge — can see which lines are backed by a statement and which are your best recollection. This guide walks through the process with a worked example that includes partial payments and a carried balance.
Why landlords end up rebuilding payment history
The usual triggers are a security-deposit dispute, a tenant who says a month was paid when you think it wasn’t, a tax return that needs rental income by month, or a sale where the buyer wants a payment history. In every case the question is the same: for each month, how much was due, how much came in, and when?
If rent was collected through Zelle, Venmo, cash, or checks deposited by hand, the bank statement is often the only record. It was never designed to be a rent ledger, so you have to build one from it.
Step 1: Gather every statement for the period
Collect statements for every account rent could have landed in — the account tenants send Zelle to, the account you deposit checks into, and any payment app with its own history. Download them as PDF or CSV rather than screenshotting a mobile view; you want the full transaction description, not a truncated one.
Cover the whole period plus one month on either side. A December rent payment sent on November 30 or January 2 is easy to miss if you stop at the calendar year.
Step 2: Pull out every deposit that could be rent
Go through each statement and list every incoming transfer or deposit that could plausibly be rent. Do not filter yet. Write down:
- Date the money posted
- Amount
- Sender name or memo exactly as it appears
- Which account it landed in
A Zelle deposit usually shows the sender’s registered name and any memo they typed. A check deposit shows a date and amount but not who wrote it unless you kept the check image. Cash deposits show nothing about the source, which is why cash rent needs a receipt at the time of payment — after the fact, a cash deposit is only circumstantial.
Step 3: Match each deposit to a tenant and a month
Now assign each deposit to a tenant and a rental period. Use these clues, then confirm uncertain allocations:
- The memo names the month. “Oct rent” on a $1,500 transfer is the easiest match.
- The amount equals the rent and it arrived within a few days of the due date. Treat that month as a candidate, not a confirmed match.
- The amount equals the rent but arrived mid-month. It could be current rent, an earlier balance, or an advance payment. Check the memo and correspondence.
- The amount is a round fraction of rent — half, a third — and there’s another deposit that completes it. Check whether both payments cover the same period before combining them.
- Nothing fits. Leave it unassigned for now.
Keep transactions in date order, but distinguish the date money arrived from the rent period it was applied to. Follow applicable allocation rules and the lease. Where the records do not establish an allocation, ask the tenant and label the entry provisional.
Step 4: Separate verified payments from gaps
You will end up with three kinds of lines:
| Line type | What it means | How to record it |
|---|---|---|
| Verified | A statement shows the deposit and it clearly matches a month | Enter the amount and posted date |
| Unallocated | The payment is confirmed but its rent period is not | Keep it in the payment list; flag the allocation for review |
| Unverified | No matching payment found in the records reviewed | Mark the month unresolved; list the records still needed |
A missing bank deposit is not proof of unpaid rent: cash, another receiving account, an offset, or incomplete records may explain the gap. Keep the working balance provisional until those possibilities are checked. Do not use an unresolved reconstruction as the sole basis for a demand for payment.
Worked example: six months with partial payments and a carried balance
Tenant: Maria G. Rent: $1,500, due on the 1st. Statements for January through June show these incoming transfers with her name on them:
| Posted | Amount | Memo |
|---|---|---|
| Jan 2 | $1,500.00 | ”rent” |
| Feb 3 | $1,500.00 | (none) |
| Mar 5 | $1,000.00 | ”march” |
| Mar 20 | $500.00 | ”rest of march” |
| Apr 1 | $1,500.00 | ”april rent” |
| Jun 1 | $1,500.00 | (none) |
| Jun 15 | $750.00 | ”catching up” |
There is no deposit that fits May. For this example, assume the tenant confirms that the February payment covers February, June 1 covers June, and June 15 is intended toward May. The remaining May amount is still unverified. A receipt-date summary looks like this:
| Month | Rent charged | Received that month | Date(s) | Record status | Provisional running balance | Note |
|---|---|---|---|---|---|---|
| January | $1,500 | $1,500 | Jan 2 | Paid | $0 | Verified |
| February | $1,500 | $1,500 | Feb 3 | Paid | $0 | Verified |
| March | $1,500 | $1,500 | Mar 5 + Mar 20 | Paid (2 parts) | $0 | Verified, partial then completed |
| April | $1,500 | $1,500 | Apr 1 | Paid | $0 | Verified |
| May | $1,500 | $0 found | — | Unverified | $1,500 | Check cash and other records |
| June | $1,500 | $2,250 | Jun 1 + Jun 15 | Payments verified | $750 | June 15 designated toward May |
Six months of charges total $9,000, and the deposits total $8,250. The $750 difference is provisional until the May gap is resolved. This table groups cash by receipt month; a separate allocation record assigns the June 15 payment to May. Keeping those two views distinct avoids treating all $2,250 received in June as June rent.
Need to build this yourself? Create a rent ledger from your payment records — enter the monthly totals for verified records. The online tool accepts one amount and date per monthly row, so keep the individual payment dates and allocation notes in a separate record or an expanded spreadsheet. Its automatic “Unpaid” label does not mean an unresolved month has been proved unpaid.
Step 5: Write down what you couldn’t verify
Beneath the ledger — in a notes column if you’re using the blank Excel template, or in a short paragraph under the exported PDF — list every assumption:
May 2026: no incoming transfer from M. G. found on Chase statements Apr 15–Jul 15. Tenant states rent was paid in cash on May 3; no receipt on file. May payment remains unverified; working balance is provisional pending review of the cash-payment claim.
Keep those notes with the source statements. They let a tenant or reviewer distinguish a confirmed transaction from an open question.
Handling the messy cases
Two tenants, one account. Sort by sender name first, then by amount. If both tenants pay the same rent and one of them sends without a memo, you may not be able to tell them apart from the statement alone — ask each tenant for their own confirmation screenshots.
Rent changed mid-year. Enter the correct amount due for each month. A $1,500 payment against $1,600 rent is a partial payment, not a full one.
Late fees. Keep fees separate from rent rather than folding them into the month’s rent due. That makes it possible to explain the rent and fee balances separately. If you change Amount Due in the Excel template, document the rent and fee components. In the online generator, track fees outside the ledger. If you’re not sure what fee applied, calculate the late fee from your lease terms and note the basis.
Deposits, pet fees, utilities. Same rule — separate lines, or leave them out of the rent ledger entirely and track them elsewhere.
Going forward
Once the history is rebuilt, the way to avoid doing this again is to record each payment the day it arrives. Recording the date, reference, and rental period when a payment arrives avoids having to infer them months later. Our guide to keeping track of rent payments covers a simple monthly routine, and if tenants pay through Zelle, see how to issue a receipt that references the Zelle transfer so each month is documented as it happens.
open the rent ledger template, enter the verified amounts, and keep the source records and unresolved questions with any export. Resolve the gaps before treating the working balance as an amount to collect.
