Real estate investment tracker: track ROI across all your properties

Why real estate investors need a dedicated tracker

Unlike a traditional business with a single revenue stream, a real estate investor manages:

• Multiple properties, each with its own purchase price, loan terms and cash flow
• Complex expense categories: mortgage interest, property taxes, repairs, depreciation, capital improvements
• Tax optimization: deductible expenses, 1031 exchanges, depreciation schedules
• Performance analysis: ROI, cap rates and cash-on-cash returns, compared across properties
• Strategy tracking: BRRRR properties, fix-and-flip timelines, rent-or-flip decisions

Real estate accounting software like AppFolio or Landlord Studio charges $50-300 a month and locks you into its interface. Google Sheets and SheetLink give you complete control, plus one-click transaction syncing, for a fraction of the cost.

Tracking multiple rental properties in Google Sheets

The key to managing multiple properties is separation with aggregation: each property gets its own detailed sheet, plus summary sheets that compare performance across all of them.

Recommended structure

• Property summary tab: every property with purchase price, current value, cash flow, ROI and a performance ranking
• Individual property tabs: one sheet per property tracking monthly income and expenses
• Income tab: all rental income across properties, by month and by property
• Expenses tab: all operating expenses, grouped by property and category
• ROI calculations tab: cash-on-cash return, cap rate, IRR and appreciation
• Tax deductions tab: pre-filtered for your accountant (all deductible expenses by category)

ROI calculations for real estate: cash-on-cash, cap rate and IRR

Real estate investors use three main metrics to evaluate property performance.

1. Cash-on-cash return

Measures annual cash profit against the cash you invested. It’s your real return on the cash you put into the deal.

Annual Cash Flow = Rental Income - Operating Expenses - Debt Service
Cash-on-Cash Return = (Annual Cash Flow / Initial Cash Investment) × 100

Example: a property you bought with $50,000 of your own cash generates $600 a month in rental income ($7,200 a year) minus $3,000 in operating expenses and debt service, so $4,200 in annual cash flow. Cash-on-cash return: ($4,200 / $50,000) × 100 = 8.4%.

2. Cap rate (capitalization rate)

Measures annual income as a percentage of property value. Higher cap rates mean better returns (but can signal higher risk or lower-priced markets).

Net Operating Income (NOI) = Gross Rental Income - Operating Expenses
Cap Rate = (NOI / Property Value) × 100

Example: a property worth $300,000 generates $7,200 in rental income minus $3,000 in expenses, so $4,200 NOI. Cap rate: ($4,200 / $300,000) × 100 = 1.4%. This property relies on appreciation and mortgage paydown, not cash flow.

3. Internal rate of return (IRR)

Captures the total return, including cash flow, mortgage paydown and appreciation. It’s the most complete measure of your real return.

=IRR(array of annual cash flows including final sale proceeds)

Example: for a 10-year hold with $5,000 in annual cash flow and $100,000 of appreciation, IRR might be 12-15% a year, depending on the initial investment and timing.

SheetLink tip: build these calculations into your Google Sheet once, and they update with the expense data from every sync. You’ll always know your portfolio’s true performance.

Fix-and-flip expense tracking

Fix-and-flip projects are all about margin. You need every acquisition cost, renovation expense and holding cost to know your true profit.

Core fix-and-flip expenses to track

• Acquisition: purchase price, inspection, appraisal, title, closing costs
• Renovation: labor, materials, permits, contractor costs (broken down by trade)
• Carrying costs: mortgage payments, property taxes, insurance, utilities (while holding)
• Soft costs: project management, design, permits, insurance premiums
• Exit costs: real estate commission (6%), closing costs, title insurance

Create a dedicated “Flip Projects” spreadsheet with a tab for each active project, and a master tab with these columns:

With SheetLink: sync every flip-related expense from your business account (contractor payments, materials, holding costs) and tag each transaction with the project name, so you can SUMIF expenses by project. Your profit tracking stays current as the project progresses.

BRRRR strategy tracking (Buy, Rehab, Rent, Refinance, Repeat)

BRRRR investors need to track each phase of the strategy to make sure projects are profitable.

BRRRR phases and key metrics

• Buy: purchase price, down payment (cash invested), inspection costs, funding source
• Rehab: renovation budget vs. actual spend, timeline, contractor management
• Rent: market rent (from comps), operating expenses, cash flow projection
• Refinance: new appraised value, new loan amount, cash pulled out, cash-on-cash return after the refi
• Repeat: initial capital recovered for the next deal, cash flow for ongoing management

Track BRRRR deals in a dedicated sheet with these columns for each property:

The goal of BRRRR is to recover your initial cash investment through refinancing, then repeat with new properties while the refinanced ones generate positive cash flow. Your spreadsheet should show cash recovered against cash deployed for each cycle.

Monthly and annual expense tracking

Rental property expenses come in three varieties (monthly recurring, annual and variable). Organize them accordingly.

Monthly recurring expenses

• Mortgage payments (separate principal and interest for tax purposes)
• Property taxes (monthly escrow or paid annually)
• Insurance (homeowner’s or landlord’s policy)
• HOA fees (if applicable)
• Utilities (if landlord-paid)
• Property management fees (if you use a manager)

Annual expenses

• Inspections and maintenance
• Roof, HVAC or major system replacements
• Legal and accounting fees

Variable expenses

• Repairs and maintenance (emergency fixes)
• Tenant turnover costs (cleaning, minor repairs)
• Vacancy losses
• Eviction and legal costs

Use a matrix to track every expense by month and property:

The SheetLink advantage: expenses from your business accounts sync with one click, ready to tag by property. You see cash flow trends without manual data entry.

Rental income vs. expenses analysis

The core metric for rental properties is monthly cash flow: rental income minus operating expenses and debt service. It should be your spreadsheet’s centerpiece.

Create separate rows for:

• Gross rental income: actual rent collected
• Vacancy loss: an expected vacancy rate (for example 5%) deducted
• Operating expenses: everything except the mortgage
• Net operating income (NOI): gross income minus operating expenses, used for cap rate
• Debt service: principal plus interest
• Cash flow: NOI minus debt service, what you pocket each month

Depreciation and capital improvements

Two critical tax concepts for real estate investors:

Depreciation

The IRS lets you deduct the cost of a residential rental building (not the land) over 27.5 years. It’s a non-cash deduction that reduces your taxable income.

Annual Depreciation = (Property Cost - Land Value) / 27.5 years

Example: a property bought for $300,000 with a land value of $75,000 has a building value of $225,000. Annual depreciation = $225,000 / 27.5 = $8,182 a year.

Track depreciation in your spreadsheet: it reduces taxable income while the property produces cash flow.

Capital improvements vs. repairs

Repairs (deductible immediately) restore existing systems to their original condition. Capital improvements (depreciated over time) upgrade the property or add value to it.

Tag every expense in your spreadsheet as “Repair” or “Capital Improvement” so your accountant can categorize it properly for taxes.

1031 exchange preparation

A 1031 exchange lets you defer capital gains taxes by reinvesting sale proceeds into a similar property. Your spreadsheet should track:

• Property cost basis: original purchase price plus improvements
• Accumulated depreciation: total depreciation deductions taken
• Sale proceeds: sale price minus closing costs and commissions
• Capital gain: sale proceeds minus cost basis (deferred with a 1031)
• Replacement property: must be of equal or greater value, within 180 days

Create a dedicated “1031 Exchange” tab with these columns:

Example 1: an investor with 5 rental properties

Jennifer owns 5 single-family rentals in different states:

• Property A (Ohio): $150k value, $800 a month cash flow
• Property B (Kentucky): $180k value, $1,100 a month cash flow
• Property C (Tennessee): $200k value, $600 a month cash flow (a newer acquisition, not yet optimized)
• Property D (Georgia): $165k value, $950 a month cash flow
• Property E (North Carolina): $190k value, $400 a month cash flow (a high-appreciation area)

Her spreadsheet

• A summary sheet ranking properties by cash flow, cap rate and 1-year appreciation
• A sheet for each property with monthly income and expenses
• A master expense sheet showing where the money goes (property taxes highest in Ohio, insurance highest in Georgia)
• A tax deductions sheet pre-filtered for her accountant (deductible and non-deductible separated)
• A 1031 exchange tracker showing that Property C is underperforming and might be replaced

With SheetLink: Jennifer’s business checking account syncs all 5 properties’ expenses with one click. She sees month-to-month trends and spots underperforming properties quickly. Property C turned out to have a management problem (renter issues) that kept its cash flow below expectations, and she’s now evaluating replacements through a 1031 exchange.

Example 2: a house flipper with 3 active projects

Marcus is a professional flipper managing 3 projects at once:

• Project A: acquisition phase (just closed, starting renovations)
• Project B: mid-renovation (2 months in, 4 months to go)
• Project C: ready to list (renovations complete, getting appraised)

His spreadsheet

• A master flip tracker with all 3 projects: purchase price, rehab budget vs. actual, projected exit price and estimated profit
• A sheet per project tracking daily and weekly expenses by trade (plumbing, electrical, general labor, materials)
• Budget variance analysis (is Project B over budget? By how much?)
• A hold-time projection (when will cash be free for the next deal?)
• A profit-to-date dashboard showing total capital invested against the forecast return

With SheetLink: Marcus’s business account syncs every contractor payment, material purchase and holding cost. His budget-vs-actual column flags overruns after each sync: Project B was tracking 5% over budget on labor, and he caught it early and adjusted. His accountant gets an up-to-date tax deduction sheet every month.

Comparing SheetLink vs. real estate-specific software

Verdict: if you invest in 1-10 properties and want to own your data at low cost with high customization, SheetLink and Google Sheets win. If you need tenant management and rent collection, AppFolio adds value. For most investors, Google Sheets is the right balance.

Getting started with your real estate investment tracker

Build your system in 3 steps:

Within days, you’ll see cash flow, expenses and ROI across all your properties. Within weeks, you’ll spot optimization opportunities (underperforming properties, over-budget projects, missed deductions).

Pricing

Compare every plan ›

Questions