Your repair bill is due on the eighth. The rent report you pull at the end of the month might show every dollar paid. To know how much rent you had to put toward that bill, you need the dates those payments came in.
In my rentals, the biggest share comes in between the first and the fifth. Another round of payments shows up between the sixth and the tenth, and the rest comes in here and there. Put a bill on the eighth and the payments in that second group can land on either side of it.
Picture two versions of a hypothetical month for the same two rentals. Both end with the same rent collected and both have the same repair bill due on the eighth. I'll show you what to pull from a month of your own records so you can tell which unit paid, what was still missing and how much rent had come in when the bill came due.
Mark Which Unit Paid and When
Pick a month you've already closed and a bill that came due in it. Give each unit a line in your review. Write down what rent was due for that month, the amount of each payment, the date it came in, and which month's rent it paid. If a property manager sends one deposit for several units, get the rent detail behind it. The tenant's receipt date tells you when they paid. The manager's transfer date tells you when that money reached you. Use the date the money reached you for both cutoffs. Keep any part of a transfer you can't match to a unit and rent period separate until you can.
I check collections as the month goes along. Suppose a deposit covers some current rent, a pet fee and part of an old rent balance. Record all the cash that came in, with each part on its own line. Only the amount applied to current rent goes into the current month's collection total. If a tenant paid in installments, keep the amounts and dates on separate lines, too. That way, you can see what was there by the bill date and what arrived in the next installment.
Add up the payments applied to the month you're reviewing through the date the bill came due. Then total that month's rent received by the last day. Compare each amount with the same rent due. For a collection percentage, divide rent collected by rent due and multiply by 100, keeping fees separate. If a unit was short on the eighth and paid up by close, the dates show when it caught up. Check when the rent was due before calling a payment late. It can miss your bill date even if the tenant paid on schedule. Start with a unit that shows zero on the eighth.
Explain Why a Unit Shows Zero Rent
When I talk about vacancy, I pay attention to empty units and occupied units where the rent hasn't come in. Either way, the unit can leave you with no rent to put toward a bill. In your records, give empty days one field and the rent due from an occupied unit another. Look at the occupancy record first. That tells you whether to check the work needed to get the place ready or the balance on the tenant's ledger.
One unit in our example sits empty all month in both versions. It needs flooring before it's ready for the next tenant. If one of your units is in that spot, pull the move-out date, the flooring dates, and the date you could actually show the unit. Those dates help you see whether the unit is waiting on a contractor or ready and waiting on a tenant. I like to start advertising when I know a unit is going to be empty. If the flooring date slips, update the date you expect to show the place. The insurance and taxes can still come due while the unit sits. If the flooring is finished and you still can't show the unit, ask what remains on the turnover list. Find out which task is holding up the next tenant.
The other unit stays occupied, and the tenant owes the same rent in both versions. A zero on the eighth means you haven't received that unit's rent as of that date. If a manager collects for you, check the tenant's ledger before treating that zero as an unpaid balance. The tenant may have paid while the transfer to you is still pending. A payment received on the tenth belongs in the month-end cash total, but not in the eighth-day total. A payment received after month-end belongs in the later cash-receipt period, with the original rent period identified separately. Keep any unpaid balance visible for follow-up. You may also estimate what the empty unit could have earned. Keep that estimate separate from rent actually owed so you don't count the same missing money twice. In our example, the empty unit generated the flooring bill that sent you to the ledger.
See Which Rent Was There When the Repair Was Due
Set the flooring invoice beside the rent ledger. Write down the unit, who did the work, what they charged, when the bill is due, and when it was paid if the money has already gone out. Keep the work order next to it. I want to see when somebody asked for the repair, how soon we got to it, and whether it was taken care of. If you keep getting calls from the same unit about the same sink, the invoices will tell you what you've spent so far. Ask whether the tenant is still having the problem before you close the work order. On a vacant unit, ask what work still has to happen before it can be shown.
Now go back to the eighth in our hypothetical. The flooring bill is $500 in both versions, and the empty unit brings in $0. In the first version, the occupied unit pays $1,100 on the fifth. You have received $1,100 in current-month rent by the time the bill comes due. In the second version, the same tenant pays $1,100 on the tenth, so on the eighth you've received $0 in current-month rent. At close, both rent reports show $1,100. To know whether you could pay the $500 on the eighth, you'd still need to check what was in the account at the start and what else went in or out. For the occupied unit, collection by the eighth is 100% in the first version and 0% in the second. Both reach 100% at month-end.
The due date gives you a consistent place to stop and look. If the money went out on a different day, check the receipts as of the payment date too. Use the work order to see what the response time means. I want to know if someone is dealing with a water leak while a loose hinge is waiting for a scheduled visit. Both belong in the repair log. The type of problem tells me what to look for when I see how fast we got to it and what we told the tenant.
Use the review sheet to pull records for a month of your own. Circle one entry that needs attention, then name the record or person that can resolve it. A missing transfer sends you to the manager's payment detail. An empty unit sends you to the turnover list. An open repair sends you to the work order. Keep the rent's actual arrival date for the next property review.
| Metric | Evidence to Pull | Decision It Supports |
|---|---|---|
| Receipts | Rent applied to the month and date received | See what had arrived by the bill date |
| Unit status | Occupancy, readiness dates, and rent due | Follow up on turnover work or an open rent balance |
| Repairs | Invoice due date, payment date, and work status | See when cash went out and what work is still open |
Carry One Observed Date Into the Next Deal
Take one receipt date from the month you reviewed. On the next property, put that later date into a copy of your purchase worksheet and leave an expense on the date you expect it to come due. See how much rent would have arrived by then. If the later receipt leaves projected rent short of that expense, write down how much of the bill would have to come from other cash. That gives you a specific number to check before you spend more time on the deal. A seller's report can show the rent was collected for the month. The dated ledger or receipts can help you see when.
My free BRRRR guide has a deal filter, a cash-flow example, and a worksheet for reviewing a property. Use the worksheet to write down the rent you're expecting, the bill date, and how late the rent could come in before you'd need to cover part of the bill yourself. If you have to rely on that early receipt, ask for the records that support it or check what else would cover the bill. Before you count on the next property's rent, see what happens when it arrives after the bill.



