A portfolio's blended numbers hide the property that loses money. This guide sets up per-property books — rent, expenses, and cash flow by address — so every property has to justify itself.
Hi, I'm Max — I run Vickery Finance, and this page is one room in the workshop. Everything here walks the same path: from shoebox-and-guesswork to a clean close you can defend, one honest number at a time. Work through it with your own figures in hand — that's when a guide turns into a result. And when you're ready to do the close instead of just reading about it, start with the Free Month-End Close Checklist: it's page one of the 18-step close my templates run, printable and yours to keep. Know your numbers.
Tax reporting already thinks per property — each rental's income and expenses are reported on their own schedule — so books kept any other way must be re-sorted every spring. Per-property records also answer the questions that actually arise: which property carries the portfolio, which one's expenses keep creeping, and what each unit truly nets after vacancy and repairs.
Two handling rules protect landlords more than any software choice. Security deposits are liabilities, never income, and they live in their own ledger (and, in many states, a separate account with its own rules). And personal and rental money never share an account: one checking account per property is ideal, one for the whole portfolio with per-property records is workable, a mixed personal account is neither.
An hour a month per property, on the same day, keeps the year-end painless.
Routine repairs and maintenance that keep a property in working order are current expenses. Work that adds to the property, extends its life materially, or replaces a major system is a capital improvement, recovered over years through depreciation. The distinction is factual, not elective — keep the invoice, the photos, and a one-line note of what was done for every significant job, and let your tax professional classify borderline items with that record in hand.
Four units rent for $1,700 each. One unit was vacant for half the month. Cash costs for the month, by category:
| Line | Math | Amount |
|---|---|---|
| Rent received | $6,800 scheduled − $850 half-month vacancy | $5,950 |
| Mortgage payments (portfolio) | Principal & interest | − $2,900 |
| Taxes and insurance | Monthly share | − $860 |
| Repairs and maintenance | One plumbing call, one turnover clean | − $540 |
| Management | 8% of rent received | − $476 |
| Utilities and other | Common-area electric, lawn | − $210 |
| Portfolio cash flow | $5,950 − $4,986 | $964 |
Small disciplines, applied monthly, prevent the expensive reconstructions:
The Rental Property ROI and Cash Flow Analyzer tracks rent, expenses, cash flow, and return per property in Excel or Google Sheets. The Rental and Airbnb Revenue Reconciliation Tracker handles the rent-roll side — scheduled versus received, across properties and platforms.
No. A refundable security deposit is a liability — money you hold for the tenant — until some part is properly applied to damages or unpaid rent under the lease and state law. Record it in the deposit ledger, not in rent income.
You can, if the per-property records are disciplined — every transaction tagged to a property and reconciled monthly. Separate accounts per property make the discipline easier and the audit trail cleaner, and some states' deposit rules effectively require separation for deposits.
Split every shared cost on a documented, reasonable basis (square footage or unit count are common) and keep the split consistent year to year. Owner-occupied multi-unit properties have their own tax rules — flag yours to a tax professional at purchase, not at filing.
A landlord's December close starts with money that is not yours. I reconcile the security deposit liability account tenant by tenant: across a four-unit portfolio I might be holding $6,400 in deposits — $1,600 a unit — and that balance on the books must match the segregated account and the lease file exactly. Deposits applied to December damage or unpaid rent become income and expense entries when they are applied, with the tenant's itemized statement attached; deposits still held stay a liability and never touch the profit and loss. Getting this wrong in either direction misstates the year.
Then I line up the two filings landlords most often miss. First, Form 1099-NEC by January 31 for every unincorporated contractor I paid $600 or more: in a typical year that is my plumber at $1,850 and my painter at $2,400, and the totals come straight from the per-property expense records — which is why I collect a W-9 before the first job, not in January. Second, the depreciation schedule gets a full review: I confirm each property's annual depreciation is posted, add the year's capital work — a $7,800 roof section, a $1,650 water heater — to the schedule at the right life, and remove anything disposed of. I also check that December's rent roll matches deposits received, that any prepaid January rent a tenant sent early is recorded as a liability rather than December income, and that mileage and home-office records are filed with the year's leases.
My closing checklist: deposit liability tied to the bank balance and each lease; W-9s on file and 1099-NEC totals pulled for every contractor at $600 or more; depreciation schedule updated for additions and disposals; prepaid rent and December move-outs recorded in the right period; and a per-property profit and loss printed for the return — one property per page, because that is how the return asks for it.
When a unit turns over, I face the same choice every landlord faces: raise the rent on the unit as it stands, or renovate and raise it further. I let the payback period decide. Take a unit renting at $1,450. A market raise alone to $1,525 adds $75 a month — $900 a year — at zero cost and zero added vacancy beyond the normal turn. The renovation quote is $9,600 for a kitchen refresh, and renovated units nearby support $1,600 a month. That is $150 a month over the current rent, or $1,800 a year, which pays the $9,600 back in 5.3 years — and that is before I charge the project its real costs: three extra weeks of vacancy during the work at roughly $1,100 in lost rent, pushing the true payback past six years.
Now I compare like with like. The raise alone earns $900 a year forever for nothing. The renovation earns $900 a year more than the raise — the extra $75 a month — so the honest payback on the $9,600 is not 5.3 years against the old rent; it is $9,600 divided by the $900 it adds beyond the simple raise, which is 10.7 years, plus the vacancy cost. On those numbers I take the raise, do the $620 of paint and hardware that make the unit feel cared for, and save the kitchen for the turnover where the cabinets are actually failing — or for the year when renovated rents in the building support $1,700, which would cut the incremental payback to about 4.6 years. Renovations should be bought with arithmetic, not with before-and-after photos.
1 — Your first win (10 minutes): the Free Month-End Close Checklist — page one of the 18-step close, printable, free.
2 — Do it with the workbook: find your trade's template — every workbook runs this same clean-close ritual, with example data and a guided first step inside.
3 — Keep the rhythm: one practical numbers email a week — Know Your Numbers, free to subscribe.
The way back: start any visit at the Start Here hub, or email a human — [email protected]. I answer.
Know your numbers. — Max
Some links below are affiliate links. If you buy through them, Vickery Finance may earn a small commission at no extra cost to you.
Every Landlord's Tax Deduction Guide, 22nd Edition — Stephen Fishman (Nolo) — the landlord's deduction bible, January 2026 edition.
Deduct It!: Lower Your Small Business Taxes — Stephen Fishman (Nolo) — for owners who suspect they're leaving deductions on the table.
Victor 1208-2 Printing Calculator — for counters that want a big display and a printed tape at a working price.
Cost Accounting For Dummies, 2nd Edition — Kenneth W. Boyd — for makers and job shops that need to know what a unit actually costs.
More books and gear live on the Resources page.