The simplest way to keep track of rent payments is to maintain one rent ledger for each tenant or rental property.
Every month, the ledger should show:
- The rent due
- The due date
- Each payment received
- The date and method of payment
- Any remaining balance
- The running balance across months
That sounds straightforward. The problem is that many landlords track only the money arriving in their bank account. A bank transaction proves that money moved, but it does not explain which month the payment covered, whether it was the full amount, or what the tenant still owes.
A reliable system connects every payment to a specific rent charge. Once that connection exists, the rest becomes much easier.
If you need a ledger immediately, use TenantHub’s free rent ledger template. It calculates payment statuses and running balances and lets you download the finished record as a PDF or CSV without creating an account.
What a rent payment tracker should show
A useful rent payment tracker needs more than a list of deposits. At minimum, record these details for every rental period:
| Field | What it tells you |
|---|---|
| Rent period | The month or period the charge belongs to |
| Due date | When the full payment was expected |
| Amount due | The rent charged for that period |
| Payment date | When money was actually received |
| Amount paid | How much the tenant paid |
| Payment method | ACH, check, cash, Zelle, or another method |
| Balance | The amount still owed after all recorded payments |
| Status | Unrecorded, upcoming, unpaid, partial, or paid |
The distinction between amount due and amount paid matters. If May rent is $2,000 and the tenant sends $1,500, the record should not simply say “payment received.” It should show a $500 remaining balance.
The same rule applies when a tenant splits one month’s rent into several payments. Record each payment, then apply the total against that month’s charge.
The best way to keep track of rent payments
Use the same process every month instead of rebuilding the history when you need it.
1. Create one ledger for each tenant or property
Do not combine every deposit from every rental into one unlabeled list. Keep a separate ledger for each tenancy so there is no ambiguity about who paid and which property the payment belongs to.
At the top of the ledger, include:
- Tenant name
- Property address and unit
- Monthly rent
- Rent due day
- Ledger start and end dates
This makes the document understandable when you return to it months later or share it with an accountant, property manager, tenant, or attorney.
2. Add the rent charge before recording the payment
Rent becoming due and rent being paid are two different events.
For example:
| Month | Due | Amount due | Amount paid | Balance | Status |
|---|---|---|---|---|---|
| January | Jan. 1 | $2,000 | $2,000 | $0 | Paid |
| February | Feb. 1 | $2,000 | $1,500 | $500 | Partial |
| March | Mar. 1 | $2,000 | $0 | $2,500 | Unpaid |
March’s running balance is $2,500, not $2,000, because the unpaid $500 from February carries forward.
Recording only payments hides this information. Recording charges and payments separately makes the balance visible.
3. Record payments when they happen
Update the ledger as soon as a payment clears or is received. Include the payment date, amount, and method. If your payment provider supplies a transaction reference, keep that reference with your records.
Waiting until the end of the year creates unnecessary detective work. Bank descriptions can be vague, tenants may pay from different accounts, and one rent payment may arrive in multiple pieces.
4. Keep partial payments separate
Suppose July rent is $2,500 and the tenant pays:
- July 1: $1,500
- July 5: $500
- July 12: $500
Those are three payments against one $2,500 charge. Preserve the individual dates and amounts, even if your summary row eventually shows $2,500 paid in total.
This gives you an accurate timeline and prevents three bank deposits from looking like three months of rent.
If you collect rent through a payment app, be especially careful about split payments. A tenant’s bank may limit how much can be sent at once. Our guide to Zelle rent payment limits explains why this happens and how it affects the ledger.
5. Use a running balance
A monthly balance shows what was missing that month. A running balance shows what is still owed across the entire tenancy.
The calculation is:
Previous balance + new charges − payments = current balance
This is the number a landlord usually needs. Without it, an older short payment can disappear from view as soon as the calendar changes.
6. Create a receipt for each payment
The ledger is the long-term history. A receipt confirms an individual payment.
For each receipt, include the tenant, property, payment date, amount, payment method, and the rent period the payment covers. You can create one with the free rent receipt generator.
Keep the receipt and ledger consistent. If the receipt says a $1,500 payment covered February rent, the February ledger row should reflect the same payment.
7. Reconcile the ledger every month
Once a month, compare the ledger with the account where rent is deposited.
Check that:
- Every rent deposit appears on the correct tenant’s ledger
- The dates and amounts match
- Split payments add up correctly
- Returned or failed payments are not marked paid
- The running balance is correct
- Each completed payment has a receipt
This review should be quick when the ledger is updated throughout the month. It becomes difficult only when several months are allowed to pile up.
Spreadsheet, bank account, or rent collection software?
Several systems can work. The right one depends on how much manual work you are willing to do.
A notebook or printed ledger
A printed rent ledger is easy to start and does not require software. It can work for one property if every update is made consistently.
Its weakness is calculation. Partial payments, corrections, and running balances have to be recomputed by hand. Paper can also be lost or damaged.
A spreadsheet
A spreadsheet gives you more control and can calculate balances automatically. It is a reasonable option for a landlord who prefers to enter every payment manually.
The main risk is not the spreadsheet itself. It is forgetting to update it. A perfect formula cannot help if three months of payments are missing.
A separate bank account
Using a dedicated rental account is good organizational practice, but the bank account should not be your only rent tracker.
Bank activity shows money movement. It usually does not show the rent period, running tenant balance, receipt, due date, or whether a deposit combined rent with another charge.
Rent collection software
Rent collection software connects the payment to the tenant, property, amount due, and payment period. The useful systems also create receipts, update the ledger, and show whether rent is paid, partial, late, or outstanding.
That removes the repeated step of copying each transaction from the bank into a separate spreadsheet.
A simple monthly rent-tracking routine
If you are tracking payments manually, use this routine:
- Before rent is due: Confirm the monthly charge and send a reminder. The rent reminder generator can help you write one.
- When a payment arrives: Record the amount, date, method, and rent period immediately.
- After each payment: Recalculate the running balance and create a receipt.
- After the due date: Review any unpaid or partial balances and follow the communication and notice process required by your lease and local rules.
- At month-end: Reconcile every ledger against your rental bank account and preserve a backup.
The system is not complicated. Consistency is the hard part.
Common rent-tracking mistakes
Automatically marking old months paid
Past months are not necessarily paid months. When reconstructing a ledger, mark them unrecorded until you verify the payment history. Otherwise, the document presents an assumption as a fact.
Treating the bank balance as the tenant balance
Your bank balance includes deposits and withdrawals unrelated to one tenant. The tenant balance should come from charges and payments on that tenant’s ledger.
Replacing payment dates with the due date
If rent was due on June 1 and paid on June 8, record both dates. Replacing the payment date with the due date erases part of the payment history.
Combining multiple tenants
One spreadsheet can contain several tenants, but each tenancy should still have a clearly separated ledger. A deposit without a tenant and rent period is not enough.
Overwriting corrections
If a payment fails, is returned, or was entered incorrectly, preserve enough information to understand the correction. Do not leave a record that says “Paid” when the money did not remain collected.
How long should landlords keep rent payment records?
Record-retention requirements can depend on jurisdiction, tax rules, the type of record, and whether a dispute is active or reasonably expected. Keep leases, ledgers, payment confirmations, receipts, and relevant communications together, and ask a qualified tax or legal professional about the retention period for your situation.
Whatever period applies, digital backups make records easier to preserve and retrieve.
The easiest system is the one that updates itself
A manual ledger can be accurate. It just depends on the landlord remembering to update it after every payment, every month.
TenantHub is designed to remove that repeated work. Rent payments stay connected to the correct tenant and property, successful payments create a record, and the payment history remains available without rebuilding it from bank notifications later.
Start with the free rent payment tracker and ledger. When you are ready to stop entering payments manually, start tracking rent with TenantHub.
Frequently asked questions
What is the best app for tracking rent payments?
The best app is one that connects rent due, payments received, receipts, and the tenant’s running balance. For a manual record, a well-designed ledger or spreadsheet can work. For less data entry, use a rent collection system that updates the payment history when rent is paid.
Can I track rent payments for free?
Yes. You can use a spreadsheet or TenantHub’s free online rent ledger without signing up. The ledger supports payment dates, partial payments, automatic statuses, running balances, PDF downloads, and CSV exports.
Should I track rent by tenant or by property?
Track each tenancy separately and include both the tenant and property on the ledger. If tenants change, start a new ledger for the new tenancy instead of continuing under the previous tenant’s history.
What if a tenant pays only part of the rent?
Record the amount and date of every partial payment. Apply the payments to the correct rent period and carry the unpaid amount into the running balance. Follow your lease and applicable local rules when deciding how payments are applied or what notices are required.
Is a rent ledger the same as a bank statement?
No. A bank statement shows transactions in an account. A rent ledger shows what a tenant owed, what was paid, which period the payment covered, and the remaining balance.
