Skip to content

Operating a rental

The weekly review that stops a rental file from drifting

By KTJ Krug LLC · Updated November 19, 2026

One dated row a week is enough. The point is not the total. It is that last week's numbers can never change afterwards, so any earlier week can still be checked, explained or defended.

Rule one: the live figure is not the record

A running balance in a sheet is a live figure. It changes the moment a payment settles or a refund is paid. If every review row pointed at that live figure, your history would silently rewrite itself.

So at each review you paste the live amount as a value into the dated row. That row then stays fixed. If a later transaction changes the past, you add a new row that says so instead of editing the old one. A review file with one row a week and no blanks in the evidence column is worth more than a dashboard nobody can audit.

The twenty fields, in the order they work

Week ending, reservations reviewed, sources checked, guest balance at review, settled payments this week, pending funds at review, pending over 14 days, refunds paid this week, turnovers due, turnovers completed, issues opened, issues resolved, issues past target, quotes compared, decision this week, next action, action owner, review date, notes, entry check.

Three of those are the ones operators skip and later regret: sources checked (which statement or processor ledger you actually read), pending over 14 days (a count, not an amount) and action owner (a person, not a team).

Case one, fictional: part of the money has not settled

One reservation, one currency. Original charges $530. An approved credit of $50 reduces what the guest owes. The guest has paid $300 so far and no refund has been paid. A further $180 has been initiated but has not settled. Processor fees on the settled amount are $9.

MeasureCalculationResult
Net guest due$530 charged minus $50 approved credit$480
Retained payments$300 settled minus $0 refunds paid$300
Guest balance$480 minus $300$180
Net cash after fees$300 minus $0 minus $9$291
Pending fundstracked separately, excluded from both figures above$180

Two numbers, two different questions. The $180 guest balance is what is still owed under the entered charges. The $291 is cash you actually hold. Neither moves because of the pending $180, and a pending amount sitting over fourteen days belongs on the review as a count.

When the $180 finally settles, record the move once: retained payments becomes $480, the guest balance becomes $0 and net cash becomes $471. If it fails instead, leave the settled figure alone and record the failure with its date.

Case two, fictional: a negative balance is a credit to review

Same file, different reservation: charges $500, an approved credit of $100, and the guest has paid $500 with no refund paid. Fees are $15. Net guest due is $400 against $500 retained, so the guest balance is minus $100, while net cash after fees is $485.

A negative guest balance is never an instruction to charge or pay anyone. It means the credit still has to be reconciled against the agreement and the transaction evidence before anyone treats it as settled, refunded or carried forward.

Rule two: compare quotes only at equal scope

From the same fictional file: a $540 tiling quote including materials and labour, a $624 quote at a higher unit price with materials only, and a $400 lump sum described as "tile work." Only the first two share a scope wording and quantity, and even then the second excludes labour and consumables, so its unit price is not comparable until the excluded items are added. The $400 lump sum has no area, no materials and no exclusions stated at all.

Record the scope item, unit of measure, quantity, what is included, what is excluded, the vendor's stated assumptions, the lead time and the quote expiry. Then mark equal scope confirmed yes, partial or no. A cheaper number at unknown scope is not a lower price. It is a missing number.

Rule three: a cleaning quote is a rate plus a minimum

Cleaning is the quote a small operator buys most often, so the number that decides it is the effective cost per turnover at the turnovers you actually have, not the headline rate. From the same fictional file: vendor A quotes $70 per turnover with a three-turnover minimum per visit, and vendor B quotes $95 per turnover with no minimum.

Week with two turnoversCalculationEffective cost each
Vendor A, $70 rate, minimum three$70 times 3, charged once$105.00
Vendor B, $95 rate, no minimum$95 times 2$95.00

The lower rate billed $210 for two turnovers while the higher rate billed $190, so the cheaper quote cost $10 more per turnover that week. The same pair reverses in a week with four turnovers: vendor A bills $280, or $70 each, and vendor B bills $380. A minimum is a fixed charge that only disappears when you have the volume.

Record the per-turnover rate, the minimum call-out or visit charge, whether supplies and laundry are included or billed separately, the travel charge, the cleaning standard expected, the deep clean interval if there is one and the effective cost at last week's actual turnover count. Compare two vendors as if you were buying the same week from each, and mark the scope equal, partial or no before comparing the totals.

Rule four: an issue is not closed because it was reported

An unresolved property issue is invisible unless it carries an open date and a target, because "still waiting" is not a status anybody can count. Each row needs the date it was opened, the target in days, the days open at review, the named owner and the next action.

Fictional example: an issue opened 2026-09-30 with a ten-day target, reviewed on 2026-10-19, is 19 days open and 9 days past target. It counts once in issues past target. Days open is a subtraction on the review date; do not carry last week's number forward, and do not backdate the target to make the row look closed.

Track the count of issues past target, not an average age. One issue nine days late matters more than four issues one day late, and an average of the two hides which one you are living with. A repair without a fix-by date is a wish with a photo attached.

What to keep, and what a review is not

  • Keep the processor statement or transaction ledger with dates, allocation and references, and link it from the reservation row.
  • Enter 0 for a known absence and leave an unknown amount blank. Blank and zero are different facts.
  • Keep one photo and one checklist line per turnover, named by date and unit, so a damage claim or a missed deep clean has something behind it.
  • Use one currency per file. A workbook that mixes currencies without recorded rates cannot be totalled honestly.
  • A completed review is a record of what was checked. It is not a tax position, an audit, and it does not certify title, permits or ownership.

The Rental Operations Toolkit already carries this weekly review layout, a reconciliation sheet, turnover, issue and vendor-comparison records, plus an isolated fictional worked example. The bundle of both kits adds the research side if you are still buying. If you would rather build your own, use the field list above as-is and keep the dated-snapshot rule.

Published by KTJ Krug LLC. Figures on this page are fictional and illustrative; they are not provider rates. The kits are one-time purchases, no subscription. Use your own source records and an appropriate professional for accounting or property decisions.

Local guides

Condado parking guide·Cell phone service in Puerto Rico·Grocery stores near Condado·Cafes to work in Condado·Cleaning services in San Juan·How we manage our Condado rentals