With ten units, you can track rent collection by looking at your bank app on the 2nd of the month. With fifty or more, the same approach quietly breaks. Payments arrive with the wrong reference, joint tenants pay separately, a housing payment lands a week late, and one tenant pays twice while another pays half. By the time you notice, the arrears are two months old and the owner statement is wrong. This guide explains a method that works at portfolio scale: a rent roll as the single source of truth, bank matching instead of checking by eye, clear handling of partial payments, arrears ageing and a steady reminder routine.
Why the spreadsheet stops working around 50 units
Spreadsheets are fine tools, and most landlords start with one. The problem is not the software, it is the workflow. A spreadsheet rent tracker is a copy of the truth, updated by hand, and every manual step is a place where a figure goes missing.
- The bank export and the rent roll live in different files, and matching them means scrolling and ticking.
- A payment with a missing reference sits unmatched until someone remembers it.
- Partial payments are typed as notes, not balances, so the arrears total is wrong.
- Rent changes and new leases need a formula edited in several places.
- Only one person really understands the file, and month end stops when they are away.
Past about fifty units, a typical manager spends a day or more each month on reconciliation alone, and the arrears list is always slightly out of date. The fix is not a better template, it is a different process.
Step 1: a rent roll as the single source of truth
The rent roll is a list of every unit, the tenant, the rent due, the due date and the status for the period. It is generated from the leases, not typed. When a lease starts, ends or has a rent increase, the rent roll changes by itself the next month.
| Unit | Tenant | Due day | Rent due | Received | Balance | Status |
|---|---|---|---|---|---|---|
| Flat 1 | J. Patel | 1st | 1,250.00 | 1,250.00 | 0.00 | Paid |
| Flat 2 | M. Owens | 1st | 1,100.00 | 600.00 | 500.00 | Partial |
| Flat 3 | A. Kim | 5th | 1,400.00 | 0.00 | 1,400.00 | Unpaid |
Everything else in rent collection hangs off this table: the reminders, the late fees, the arrears report and the owner statements. If it is right, the rest follows. If you are still on a spreadsheet, the rent ledger template shows the columns to keep, and rent roll software builds the same view from your leases automatically.
Step 2: match bank payments instead of checking by eye
Most rent in the US and UK still arrives by bank transfer, ACH or standing order. Tenants pay the way they always have, and there is no reason to change that. What changes is how you record it.
Download the bank statement as a CSV, import it, and match each credit to a tenant ledger. A good matcher uses the amount, the reference and the payer name together, and remembers the match for next month, so the tenant who always pays as "SMITH J FLAT2" is matched automatically from then on.
- Import weekly, not only at month end, so late payers stand out early.
- Review unmatched credits the same day. Most are a tenant paying from a new account or a relative paying on their behalf.
- Never delete an unmatched credit. Park it and investigate: an unidentified payment is often someone's rent.
- Keep refunds and deposits out of the rent ledger, or post them to their own lines.
Letting does exactly this: it imports your bank CSV, matches credits to tenant ledgers, and learns the references each tenant uses. It tracks and reconciles; it does not process card payments, so nothing changes for your tenants.
Step 3: record partial payments as balances, not notes
Partial payments are where spreadsheet trackers lose money. A tenant pays 600 of 1,100, someone writes "paid 600, rest Friday" in a comment, Friday passes, and the remaining 500 disappears from view because the row looks paid.
Treat every partial payment as a balance on the tenant ledger. The rent roll shows the unit as partial, the balance carries into the arrears report, and the reminder routine keeps running until the balance reaches zero. When the rest arrives, it is matched to the same ledger and the status changes to paid.
The same rule applies to overpayments. A tenant who pays twice has a credit on their ledger, which you either apply to next month or refund. Either way, it is recorded, not remembered.
Step 4: age your arrears
A single "total arrears" number hides the difference between a tenant who is three days late and one who is three months late. Ageing splits the balance by how old it is, which tells you where to spend your time.
| Band | What it usually means | Typical action |
|---|---|---|
| 1 to 30 days | Missed transfer, payday timing, a forgotten share | Automated reminder, then a late rent notice |
| 31 to 60 days | A real problem with income or a dispute | Phone call, agree a written payment plan |
| 60+ days | Serious arrears | Final notice, check the formal options for your jurisdiction |
Look at the report every week. The goal is to keep balances from moving from the first band into the second. Most of the arrears that end up in the 60+ band were visible in the first band for weeks.
Step 5: automate reminders and late fees
Chasing by hand is where a manager's week goes. It is also where inconsistency creeps in, because the tenants who get reminders are the ones someone remembered. Automated reminders fix both problems.
- A friendly reminder a day or two after the due date for every unit still unpaid.
- A late rent notice after any grace period, with the late fee if the lease allows it.
- A final reminder at around two weeks late, before any formal step.
- Reminders stop the moment the payment is matched, so a tenant who paid never gets a chase.
Late fee rules should follow the lease and the local rules: the amount, the grace period and the cap. The late rent notice guide covers the wording and the jurisdiction caveats. Automated reminders and late fee rules are part of the Agency plan and above.
Step 6: close the month and report to owners
When rent is matched weekly and costs are recorded as jobs close, month end becomes a check rather than a project. Confirm there are no unmatched credits, review the arrears for each owner, close the period, and generate the statements.
If you manage for other landlords, the reconciled rent roll feeds straight into each owner's statement: rent received, fees, repairs and net payout. The owner statement template guide shows the layout owners expect, and property management accounting software produces the statements from the same data.
A weekly rent collection routine for 50+ units
- Monday: import the bank CSV, confirm the matches, investigate unmatched credits.
- Monday: review the arrears ageing report and note any balance that moved into a new band.
- Tuesday: call tenants in the 31 to 60 day band and record the outcome on their profile.
- Wednesday: check that payment plans are on schedule against the ledger.
- Friday: second bank import, so late week payments are matched before the weekend.
- First working days of the month: close the period, produce owner statements and send them on the set day.
This routine takes a couple of hours a week at fifty units, and it scales. The work grows with the number of problems, not the number of units, because every unit that pays on time is handled by the import.
What to look for in rent collection software
If you are moving off a spreadsheet, check that the tool does the work described above rather than adding another screen to fill in.
- A rent roll generated from leases, with rent increases on schedule.
- Bank CSV import that matches credits to tenant ledgers and remembers references.
- Partial payments and credits as real balances.
- Arrears ageing in clear bands.
- Automated reminders and late fee rules you control.
- Owner statements built from the same ledgers, if you manage for others.
- Tenants keep paying the way they do now, with no new payment app to adopt.
Letting's rent collection software is built around this workflow, alongside lease management software for the leases that drive the rent roll. Plans start at $59 per month for up to 25 units, and the Agency plan covers up to 150 units. See property management software pricing for the unit bands.