The Holiday & Weekend Edit: 20% off direct downloads, auto-applied at checkout.Shop all

Shelzy's

Studio Notes ·

Rental Property Bookkeeping Spreadsheet (2026): Rent Roll, Cash-on-Cash ROI, and IRS Schedule E Categories

Manage 1 to 10+ rental doors without $60/month landlord software. Learn how to structure your rent roll, handle tenant security deposits properly, map every receipt to IRS Schedule E lines 5 through 19, and calculate true per-door ROI.

Rental property bookkeeping and landlord cash flow spreadsheet for Google Sheets and Excel

Most small-portfolio real estate investors buy their first one to five doors for cash flow and long-term equity, then accidentally hand back an entire month's net profit to software subscriptions and messy April CPA cleanup bills. Between $55-to-$100/month landlord SaaS tools and shoeboxes of uncategorized Home Depot receipts, DIY bookkeeping breaks down when your ledger is not aligned with how rental real estate is actually taxed.

A clean Google Sheets or Microsoft Excel rental bookkeeping system solves two jobs at once: it gives you real-time monthly visibility into per-door Net Operating Income (NOI) and Cash-on-Cash return, and it hands your tax preparer an itemized, property-by-property summary mapped directly to IRS Schedule E (Form 1040) in ten minutes.

The 4 Accounting Mistakes That Distort Landlord Cash Flow

Before building or choosing a spreadsheet, make sure your ledger enforces four non-negotiable real estate accounting boundaries:

  1. Never co-mingle personal and rental transactions: Run a dedicated checking account for rental inflows and outflows, plus a separate escrow/savings sub-account where tenant security deposits sit untouched.
  2. Keep refundable security deposits off your income statement: Collecting a $2,200 security deposit at move-in increases cash in the bank, not rental revenue. Only forfeited deposit amounts applied to unpaid rent or tenant-caused repairs become reportable income.
  3. Separate mortgage principal from interest and escrow: Your monthly PITI draft contains deductible mortgage interest, property taxes, and insurance alongside non-deductible principal paydown. Logging the full monthly bank draft as a single expense overstates tax deductions and hides equity growth.
  4. Separate routine repairs from 27.5-year capital improvements: Fixing a leaking $180 garbage disposal is a current-year Line 14 Repair; installing $14,500 of new LVP flooring and quartz countertops across a unit turn is a capital asset placed on your depreciation schedule.

Mapping Your Expense Log Directly to IRS Schedule E (Lines 5 to 19)

Generic business P&L templates group expenses into vague buckets like 'Operations' or 'Facilities,' forcing you to re-sort 300 transactions every spring. Because Schedule E reports each physical property in its own column (Property A, Property B, Property C), every row in your spreadsheet's Expense Log should require two dropdown tags: Property ID and exact Schedule E Category:

  • Line 5 -- Advertising: Zillow Rental Manager listing fees, yard signs, professional listing photos, virtual tour hosting.
  • Line 6 -- Auto and Travel: Documented mileage (at the annual IRS standard business mileage rate) driving to properties for inspections, tenant showings, hardware store runs, or out-of-state portfolio visits.
  • Line 7 -- Cleaning and Maintenance: Turnover deep-cleaning crews, lawn care, snow removal, gutter cleaning, pest control contracts, and common-area upkeep.
  • Line 8 -- Commissions: Leasing agent placement fees or tenant-finder commissions.
  • Line 9 -- Insurance: Landlord dwelling policy (DP-3), umbrella liability coverage, flood insurance, and loss-of-rents coverage.
  • Line 10 -- Legal and Other Professional Fees: Lease drafting, CPA tax preparation allocation, LLC annual filing fees, eviction legal costs, and bookkeeping tools.
  • Line 11 -- Management Fees: Third-party property manager monthly percentages or flat lease-renewal fees.
  • Line 12 -- Mortgage Interest Paid to Banks: Annual interest verified against Form 1098 from your mortgage servicer.
  • Line 14 -- Repairs: Plumber, electrician, appliance technician, lock re-keying, and minor fix-it invoices that keep the unit habitable without adding structural value.
  • Line 15 -- Supplies: Smoke detector batteries, HVAC air filters, touch-up paint brushes, lockboxes, and cleaning consumables.
  • Line 16 -- Taxes: County and municipal real estate property taxes, local rental licensing fees, and school district taxes.
  • Line 17 -- Utilities: Landlord-paid water, sewer, trash, gas, or electric during vacancies or included in multi-family leases.
  • Line 19 -- Other: HOA/condo association dues, bank wire fees, and tenant screening credit/background check fees not reimbursed by applicants.

Pro Tip for Multi-Unit Owners: On a duplex, triplex, or fourplex where one roof repair or water bill covers the entire building, tag the transaction to the building address and let a unit-allocation column split shared expenses evenly (or by square footage, especially if you house-hack one unit personally).

Worked Unit Economics: NOI, Cap Rate, and Per-Door Cash-on-Cash ROI

Taxable income (after non-cash depreciation) tells you what you owe the IRS, while Net Operating Income (NOI) and Pre-Tax Cash Flow tell you whether a property is actually outperforming a passive index fund or high-yield Treasury bill. Your spreadsheet dashboard should compute all three metrics automatically.

Consider a single-family rental acquired for $280,000 with 20% down ($56,000 down payment + $6,000 closing/make-ready costs = $62,000 total cash invested) and a $224,000 mortgage at 6.50% ($1,416/month principal and interest, or $16,992/year):

  • Gross Scheduled Rent ($2,350/mo x 12): $28,200
  • Less Vacancy / Credit Loss Allowance (4%): -$1,128
  • Plus Pet Rent / Late Fees / Laundry Income: +$420
  • Effective Gross Income (EGI): $27,492
  • Operating Expenses (Property Tax $3,400 + Insurance $1,450 + Repairs/Maint $2,100 + CapEx Reserve $1,200 + Supplies/Admin $442): -$8,592
  • Net Operating Income (NOI = EGI - Operating Expenses, excluding debt service): $18,900
  • Unlevered Cap Rate ($18,900 NOI / $280,000 Purchase Price): 6.75%
  • Less Annual Debt Service (Principal + Interest): -$16,992
  • Annual Pre-Tax Net Cash Flow ($18,900 - $16,992): $1,908 ($159/month)
  • Cash-on-Cash ROI ($1,908 Annual Cash Flow / $62,000 Cash Invested): 3.08% cash yield (plus ~$2,520 Year-1 principal paydown = 7.14% pre-appreciation equity + cash return)

Seeing that breakdown on one clean dashboard prevents expensive blind spots. A property that looks like it 'clears $934 a month over the mortgage' on paper actually generates $159/month in true distributable cash once property taxes, insurance, vacancy, and routine turn repairs are properly reserved.

Inside Our 7-Tab Rental Property Manager Workbook

Instead of paying $660+/year for landlord software or stitching together fragile tabs from scratch, our Rental Property Manager Spreadsheet ($14.99, or $11.99 with code SAVE20) gives DIY landlords and small multi-unit investors a complete 7-tab system in both Microsoft Excel (.xlsx) and Google Sheets -- including both a Blank template and a Pre-Filled Sample workbook:

  • 1. Portfolio Dashboard: Instant annual and monthly KPIs across all doors -- gross rent collected, total expenses, net cash flow, occupancy rate, and expense category breakdowns.
  • 2. Properties Master Index: Unit addresses, purchase prices, cash invested, monthly target rents, mortgage terms, and per-door performance snapshots.
  • 3. Rent Roll & Payment Tracker: Monthly tenant rent expected vs. paid, date received, late-fee flags, and delinquent balance alerts.
  • 4. Schedule E Expense Log: Filterable transaction ledger tagged by Property, Vendor, Payment Method, Tax-Deductible flag, and IRS Schedule E category.
  • 5. Maintenance & Work Order Log: Track repair requests, vendor contacts, priority status, completion dates, and warranty notes per unit.
  • 6. Tenant & Lease Directory: Move-in/move-out dates, lease renewal windows (60/90-day visibility), security deposit amounts held, and emergency contact details.
  • 7. Step-by-Step README: Fast setup instructions for single-family, duplex/triplex, and multi-property portfolios.

Operating short-term rentals, real estate listings, or multiple LLCs too? Unlock all 6 commercial operator systems -- including our Luxury Real Estate OS, Luxury Airbnb & STR Host OS, and Business Finance + Net Worth Dashboard -- inside the Q4 B2B Commercial Suite for $31.20 with code SAVE20 ($92.94 individual value).

Monthly 15-Minute Landlord Bookkeeping Routine

  1. On the 5th of each month, confirm every tenant rent payment on the Rent Tracker tab and trigger late-fee notices immediately if any balance remains open past your lease grace period.
  2. Log every repair invoice, utility draft, and mileage trip from your dedicated rental checking/card statement into the Expense Log tab, selecting the exact Property and Schedule E category.
  3. Snap a PDF or photo of every receipt over $75 (and every repair invoice regardless of amount) into a matching Google Drive folder organized by Property -> Year -> Month.
  4. In January, reconcile your lender's Form 1098 mortgage interest and county tax bills against Lines 12 and 16, then export your annual summary tab straight to your CPA.

FREE PRINTABLE GIFT TAG PACK + 20% OFF

Grab 8 free printable gift tags + 20% off any template.

Enter your email to unlock our print-ready US Letter gift tag sheet plus code SAVE20 for 20% off any spreadsheet or bundle at Stripe checkout.

Details

Questions, answered.

What expense categories are on IRS Schedule E for rental properties?

IRS Schedule E (Form 1040), Part I breaks rental property expenses into Lines 5 through 19: Advertising (Line 5), Auto and travel (Line 6), Cleaning and maintenance (Line 7), Commissions (Line 8), Insurance (Line 9), Legal and professional fees (Line 10), Management fees (Line 11), Mortgage interest paid to banks (Line 12), Other interest (Line 13), Repairs (Line 14), Supplies (Line 15), Taxes (Line 16), Utilities (Line 17), Depreciation expense (Line 18), and Other itemized expenses such as HOA dues (Line 19).

Is a tenant security deposit counted as rental income when received?

No. Under IRS rules, a refundable security deposit intended to be returned to the tenant at lease end is a liability on your balance sheet, not taxable rental income when collected. You only record part or all of a security deposit as gross rental income if the tenant forfeits it for unpaid rent, lease breakage, or chargeable property damage -- and do not collect final month rent disguised as a refundable deposit, because advance rent is taxable in the year received.

What is the difference between a deductible repair and a capital improvement?

A repair restores a component to working condition without extending the asset's useful life -- such as snaking a clogged drain, patching drywall, or replacing a faulty thermostat -- and is 100% deductible in the current tax year on Schedule E Line 14. A betterment, restoration, or adaptation -- such as a full roof replacement, new HVAC system, or kitchen remodel -- is a capital improvement that is generally depreciated over 27.5 years for residential rental real estate unless eligible for specific safe-harbor elections through your CPA.

Is the entire monthly mortgage payment deductible on a rental property?

No. When you make a $1,850 monthly PITI payment, mortgage interest (Line 12), property taxes escrowed and paid (Line 16), and hazard/landlord insurance (Line 9) are deductible operating expenses, whereas principal paydown builds your equity and is not a deductible Schedule E expense. Always split principal from interest using your lender's Form 1098.

Do DIY landlords with 1 to 10 units need monthly property management software?

Rarely. SaaS platforms charging $55 to $100+ per month ($660 to $1,200 per year) make sense when you manage dozens of doors requiring automated tenant screening portals and multi-owner trust accounting. For an independent investor managing 1 to 10 long-term doors, a structured Google Sheets or Excel workbook with per-property tags and Schedule E categories keeps 100% of that $660+ annual software spend inside your net cash flow.

Start Small or Grab Everything

Plans that don't take your whole Sunday.

Test-drive our $0.80 Quick-Start Budget Duet, unlock all eight flagship workbooks in the 2027 Vault, or browse bachelorette and hosting templates.