When the second rental breaks your spreadsheet

The first rental spreadsheet often feels like a system. Rent, expenses, cash flow, maybe a debt service coverage ratio (DSCR) line — it fits on one tab, and you can hold the whole property in your head.

The second rental is where that tab usually fails. Not because you got worse at math, but because a portfolio is not two copies of one property. Shared cash, shared tax, shared capital expenditure (CapEx) timing, and shared attention do not live inside a single-property sheet.

If you add a rental before you have shared actuals, you mostly scale confusion.

This post is about one book for rentals: rent collected, vacancy, CapEx, and tax — the same facts, for every property, before you bid on the next one. The examples below are rounded; assumptions are noted.

Why one property’s sheet breaks

A single-property workbook usually hides four portfolio problems:

1. Cash is shared. Property 1’s security deposit and Property 2’s furnace do not care which tab you open. Your checking account is one pile.

2. “Rent” on the sheet is often scheduled rent. Collected rent is what pays the mortgage. Mixing them makes Property 2 look fine while Property 1’s late payments quietly fund the optimism.

3. CapEx is lumpy. Two rentals can need water heaters in the same quarter. Average CapEx per property per month is a planning line. Actual CapEx is a week that empties the reserve.

4. Tax is annual and combined. Depreciation, interest, and repairs across properties land on one return (or one partnership return). A tab that never exports actuals becomes an April surprise.

None of that means you stop using per-property underwriting.

Per-property underwriting is still how you decide to buy.

It is not how you should track cash, CapEx, and taxes once you own more than one rental.

The four actuals before another rental

Before you bid on rental number two (or five), require a shared actuals pack that covers every property you already own:

• Rent collected by month, by property — not lease face value. Include concessions and partial payments.

• Vacancy and make-ready days — empty days, turnover cost, and days to re-lease.

• CapEx and large repairs — recorded by property, with date and category (roof, HVAC, plumbing, appliances, flooring).

• Tax inputs — basis, depreciation method you actually use, interest paid, and a folder of statements your Certified Public Accountant (CPA) can trust.

If any of those four is missing — or you only “know” it from memory — pause the next purchase. Get the shared actuals on paper (or in one ledger) first.

A portfolio view is one way to keep the same facts visible. Spreadsheets work if the discipline is real.

The product is optional. The shared actuals and discipline are not.

Worked example: two rentals, one checking account

Assumptions: you own Property 1 already. Property 2 is the offer in front of you. Numbers are rounded for the example.

Property 1 (owned)

• Lease rent: $1,700. Collected last 6 months: $9,200 against $10,200 scheduled (one slow month, one partial).

• Vacancy in the last year: 28 days + $1,400 make-ready.

• CapEx last 12 months: $3,100 (HVAC repair + appliances).

• Principal, interest, taxes, and insurance (PITI): $1,420/month.

Property 2 (offer)

• Underwrite uses $1,800 rent, 5% vacancy, thin CapEx.

• Your Property 1 actuals say collected rent runs ~10% under schedule across a year when you include the slow month, and CapEx was not thin.

If you paste Property 1’s optimism onto Property 2, you buy another fragile tab.

If you paste Property 1’s actuals into Property 2’s assumptions — higher vacancy, real CapEx, collected-rent haircut — Property 2’s cash flow may flip negative.

That negative result is useful. It means the shared actuals caught a weak deal before you wrote an earnest-money check. Better to see that shortfall on the worksheet than after you have earnest money at risk.

Underwrite Property 2 with the actual column’s shape, not the scheduled column’s comfort. You can still buy Property 2. You should not buy it on Property 1’s optimistic schedule.

Shared actuals beat synced copies

A common patch is to duplicate the Property 1 workbook and rename it Property 2. That feels like a system. It is usually two silos with the same bugs.

Synced copies drift. One tab gets a CapEx category the other never had. One owner updates collected rent; the other updates only the lease. At tax time you reconcile by memory.

The fix is not more copies.

It is one ledger with a property tag on every line — or one export that stacks properties without retyping.

Minimum viable shared book for a small portfolio:

• One transactions list (date, property, category, amount, notes).

• One rent-roll actuals list (period, property, scheduled, collected, balance).

• One CapEx list (date, property, vendor, category, amount, warranty if any).

• One document index (insurance, tax bills, loan statements, leases) so April is retrieval, not a dig through old files.

If that sounds heavier than a simple per-property tab, that is expected. Portfolios need more detail than a single-property sheet. The extra care is the point — it is what keeps Property 3 from being justified by a memory of Property 1’s best month.

One book, weekly rhythm

Portfolios fail quietly when updates are a monthly catch-up that looks complete but skips the hard numbers. A light weekly pass beats a large quarterly rebuild:

• Record rent collected and anything still open.

• Log work orders and CapEx the week they hit the card.

• Note vacant days as they accrue, not after the unit is filled.

• Once a month, export or print the four actuals for every property on one page.

Thirty to forty minutes a week is enough for a small portfolio if the categories are stable.

The goal is not pretty charts. The goal is that the next offer uses facts you can see.

Sibling idea on the flip side

Flip operators hit the same wall when the fifth deal arrives before the first four share one book. The flip-track piece on scaling without scaling stress is the sibling idea: systems before volume.

Rentals follow the same pattern. More properties without shared actuals is not scale. It is the same gaps showing up on every property at once.

What “ready for another rental” looks like

You are ready when:

• Every owned property has twelve months of collected rent (or all months since purchase), vacancy days, and CapEx in one book.

• You can state portfolio cash after debt for last quarter without opening five email threads.

• The next offer uses vacancy and CapEx assumptions that look like your actuals, not like a template from the internet.

• Tax documents for the open year are accumulating now, not in a shoebox in March.

You are not ready when Property 1’s sheet still says “rent” without a collected column, or when CapEx is a yearly estimate you never wrote down.

How the second rental should change the underwrite

When you model Property 2, include portfolio-level constraints:

• Reserve cash after close must still cover a vacancy slip on Property 1 and Property 2 in the same quarter.

• Management load — your time or a property manager’s fee — rises nonlinearly when turns overlap.

• Insurance and tax reassessments may land differently on a second purchase in the same entity or limited liability company (LLC) structure. Ask before you assume the Property 1 run-rate.

If Property 2 only works in isolation, and fails when Property 1 has a bad quarter at the same time, the portfolio underwrite failed. Treating properties in isolation is a modeling mistake — the bank account does not isolate them.

A simple go / no-go before Property N

Print one page the night before you write earnest money:

✅ Portfolio cash after debt for the last 90 days (all properties).

✅ Largest CapEx in the last 12 months, and whether reserves rebuilt.

✅ Current vacant properties and days vacant.

✅ Property N underwrite using your actual vacancy and CapEx shape, not a template.

✅ Cash left after close if Property 1 and Property N are both vacant for 30 days.

If you cannot fill those five lines from your records, do not bid yet. Finish the shared actuals first. The market will still have houses next month. A thin reserve after a bad purchase does not come back.

Close the loop

• The second rental breaks the single-property spreadsheet because a portfolio needs shared actuals.

• Rent collected, vacancy, CapEx, and tax — one book — before another purchase.

• Scale the facts you can see. Do not scale a spreadsheet that only works on hopeful numbers.

If you want one set of portfolio actuals for the rentals you already own — before you bid on the next one — start a 30-day trial.

Next up: Analyze the full cash-flow stack before you offer — buy the next rental with the full stack.