On the morning of the sixth, Maria opened her bank app and saw only two deposits where she expected four. One tenant had paid in full, one had paid half, and two had paid nothing at all, yet her notebook showed a single crossed out line that told her nothing about who owed what. By the end of that month she was $3,400 short on mortgage, insurance, and a plumber invoice, and she spent three evenings reconstructing payments from text messages and bank memos. That scramble is the real cost of tracking rent in your head or in a loose notebook.
The short answer is that you track outstanding rent with one ledger per tenant, updated the day money moves, showing rent due, rent paid, fees charged, and the balance left. You check that ledger on the same two days every month, and you follow up in writing the moment a balance passes its due date. A spreadsheet works at first, and a rent collection tool works better once you pass about five units, but the tool matters less than the habit of recording every payment on the day it arrives.
What Counts as Outstanding Rent?
Outstanding rent is any amount the lease says is due that has not yet reached your account in full.
That includes the unpaid part of a partial payment, not only a month with zero payment. If rent is $1,400 and a tenant sends $900, the outstanding balance is $500, even though money did arrive.
Late fees belong in the same ledger, but keep them in a separate column from rent itself.
Courts, accountants, and tenants all read the record more easily when rent, fees, and other charges stay distinct. A security deposit is not outstanding rent, and it is not a payment toward rent unless your lease and your state law allow you to apply it that way, which is rare during an active tenancy.
Other charges can sit beside rent on the same tenant record, such as a returned payment fee, a pet fee, or a utility reimbursement the lease requires.
Record each charge with a date, a reason, and the lease clause behind it. Vague lines like miscellaneous $75 will cause an argument later, and they will weaken your position if you ever need to show the balance to a mediator or a judge.
How Do You Build a Ledger That Actually Works?
Start with one row per charge and one column for each fact you will need later.
The columns that matter most are tenant name, unit, due date, amount due, amount paid, date paid, payment method, fee charged, and balance remaining. Add a notes column for short facts only, such as check cleared on the tenth or tenant promised remainder on Friday.
Update the ledger when the payment clears, not when the tenant says it is sent. A screenshot is not cleared money. If you mark it paid too early, your ledger will tell you the tenant is current while your bank account says otherwise.
Reconcile the ledger against your bank statement once a month, line by line, before you send any statement to a tenant. This check catches a payment recorded twice and a payment recorded under the wrong unit, both easy to fix in week one and painful in month six.
A Numbered Example: Tracking One Tenant Balance
Follow this example slowly, because the same arithmetic applies to every unit you own.
1. Rent for Unit B is $1,450 per month, due on the first, with a late fee of $50 if unpaid after the fifth. 2. On March 3, the tenant pays $1,000, leaving $450 of rent unpaid for March. 3. On March 8, after the grace period ends, you add the $50 late fee, so the total outstanding balance becomes $500. 4. On March 20, the tenant pays $300, which reduces the outstanding balance to $200. 5. On April 1, new rent of $1,450 becomes due, so the total outstanding balance becomes $1,650, made up of $200 carried forward plus $1,450 for April.
That final figure is the number you quote to the tenant, and it is the number your ledger must show without you doing mental math. If any step in that chain lives only in a text thread, you will misstate the balance sooner or later, usually in the tenant’s favor in your own memory and in your favor in theirs.
When Should You Follow Up on a Missed Payment?
Follow up on the day after the grace period ends, not two weeks later when the next rent date is already close, and read how to respond to an eviction notice to see what a clear notice looks like from the other side. A short written message works best, stating the amount due, the date it was due, and the date by which you expect payment. Keep the tone factual and calm, even when you are frustrated, because that message may be read aloud later.
If the tenant replies with a partial payment plan, put the plan in writing before you accept the first partial payment. State each payment amount, each payment date, and what happens if a planned payment is missed. An oral plan that both sides remember differently is barely a plan at all.
Which Tracking Method Fits Your Portfolio Size?
For one to four units, a spreadsheet with one tab per property and a monthly summary tab is usually enough. Build the template once, protect the formula cells, and use the same file every month so you can compare months at a glance. The risk with a spreadsheet is not the math, it is the discipline, since a spreadsheet only works if you open it.
For five to twenty units, a rent collection platform starts to pay for itself in saved time. Automatic reminders, online payment, and a tenant facing balance page remove the weekly question of how much do I owe. Compare the monthly platform fee against the hours you currently spend chasing payments, and include the value of fewer disputes in that comparison.
What Do State Rules Change About Tracking?
State law changes the grace period, the late fee cap, and the notice you must give before you can act on an unpaid balance, so your ledger must record the facts those rules depend on. California, for example, limits late fees to a reasonable amount tied to actual harm from late payment, and it requires specific notice steps before an eviction case can proceed. Texas allows a late fee only if the lease states it clearly, and it sets its own notice timeline. New York restricts late fees more tightly and gives tenants added protections around fees and notices.
Your state may also limit how you apply a partial payment. Some states require you to apply money to rent first, while others let the lease decide the order, and that order changes whether a tenant is behind on rent or only behind on fees. That distinction can decide whether a notice is valid. Read your state statute and your lease together before you write a partial payment rule into your ledger, and keep a note of the rule on the ledger template itself so a future helper follows the same order.
Local rules add another layer, since some cities cap fees, require a longer notice period, or require a specific form for a pay or quit notice, and the timeline in how long does the eviction process really take shows why early written notice protects your later options. A ledger that records only dollars, without due dates, notice dates, and fee authority, cannot support those local steps. If you own units in more than one state, use one template but keep a state notes sheet beside it, listing grace periods, fee caps, and notice periods for each place you operate.
Tenants facing a shortfall often need to understand eviction notice types and tenant rights before they reply, and a landlord who can explain the next step plainly usually gets a faster, calmer response than one who only repeats the balance.
How Do You Handle Partial Payments Without Creating a Mess?
Accept partial payments only with a written acknowledgment that the balance remains due. The acknowledgment should state the amount received, the amount still owed, and the date the remainder is expected. Without that note, a tenant can later claim the partial payment settled the month, and you will have only your memory against theirs.
Never erase an old balance to make a tenant current on paper when the money has not arrived. That kindness, if it is kindness, destroys your ledger, and it teaches the tenant that the balance was negotiable. If you genuinely want to forgive part of a balance, record it as a separate credit with a reason and a date, so the history stays honest.
Watch for a pattern of partial payments that never quite catch up. A tenant who pays $1,100 of $1,450 for four months in a row owes $1,400 by month four, even though every month felt almost paid. Your ledger should show that creeping total in its balance column. The cost of doing nothing here is quiet and steady, since a $350 monthly shortfall becomes $4,200 over a year, and by then the tenant often cannot catch up even with good intentions.
What Should a Monthly Tenant Statement Include?
Send a short statement near the start of each month to any tenant with a balance. List the opening balance, new rent due, payments received, fees charged, and the closing balance, with dates for each line.
How Do You Spot Trouble Early?
Three warning signs deserve your attention before a balance grows large. First, a tenant who paid on the first for a year suddenly pays on the twelfth twice in a row. Second, a tenant who pays in round partial amounts, such as $500 at a time, without explaining the plan. Third, a tenant who stops replying to routine messages while rent slips.
When you see one of those signs, call or write promptly and ask a direct question about timing. Many tenants will tell you about a job loss, a medical bill, or a bank error if you ask early and without accusation. Early information lets you agree a short catch up plan while the balance is still recoverable, rather than facing a large debt later when options narrow.
What Records Should You Keep, and for How Long?
Keep the lease, every ledger version, every payment receipt, every notice, and every written payment plan for at least the length of the tenancy plus the period your state allows for claims after move out. Many landlords keep records for seven years to match tax record habits, and that longer habit costs little once the files are digital.
The Bottom Line
Start with one ledger per tenant, updated on the day money clears, and checked on two fixed days each month. That single habit will prevent most of the confusion that turns a late payment into a lost month of rent.
Choose a method that matches the number of units you actually own, not the portfolio you hope to own someday, and test that method with a partial payment before you trust it. A simple spreadsheet used faithfully beats a powerful platform opened once a quarter.
If a balance is growing, act while it is still small enough for a tenant to repay, and put every agreement in writing with dates and amounts. Your future self will thank you for the record, and your tenant will respect a landlord whose numbers never waver.
