How to Build a Google Sheets Rental Income Tracker for Landlords

If you own one rental property, you can probably track income in your head. If you own two or more, you already know that "in your head" stops working fast. Repairs, late fees, mortgage adjustments, insurance renewals — the numbers multiply quickly, and at tax time, scattered records become a serious problem.

A Google Sheets rental income tracker solves this without a subscription, without a learning curve, and without sharing your financial data with a third-party app. Here's how to build one from scratch.

---

Tab 1: Properties

Your Properties tab is the master list — one row per property, never changes except when you acquire or sell a property or your fixed costs change.

Set up these columns:

| Column | Type | Notes | |--------|------|-------| | A: Property Name | Text | Short label — "Oak Street Duplex" | | B: Address | Text | Full street address | | C: Type | Text | Single-family / Multi-unit / Condo | | D: Monthly Rent | Number | Current listed rent amount | | E: Mortgage Payment | Number | Full PITI or P+I depending on how you escrow | | F: Insurance | Number | Monthly cost (annual ÷ 12) | | G: HOA | Number | Zero if none | | H: Other Fixed Costs | Number | Property management fee, trash, etc. | | I: Net Monthly Cash Flow | Formula | See below |

In cell I2, enter this formula and drag it down for all rows:

=D2-(E2+F2+G2+H2+I2)

Wait — column I can't reference itself. Adjust the formula to use your actual column letters. If Other Fixed Costs is in column H:

=D2-(E2+F2+G2+H2)

This gives you baseline net cash flow — what you'd make if only fixed, predictable costs existed. In practice, variable expenses (repairs, cleaning, vacancies) reduce this number. But baseline cash flow is what you use to evaluate a property's health month over month.

Formatting tip: Apply conditional formatting to the Net Monthly Cash Flow column. Set values below zero to red fill — a property operating at a loss should be immediately visible without scanning numbers.

---

Tab 2: Income Log

Create a new tab called Income Log. This is where you record every payment received, every month, across every property.

Columns:

| Column | Header | Notes | |--------|--------|-------| | A | Month | Format as YYYY-MM (e.g. 2026-07) for easy sorting and SUMIF matching | | B | Property | Dropdown validated from your Properties tab (use Data → Data validation) | | C | Rent Received | Amount actually paid (may differ from listed rent if partial) | | D | Late Fee | Any late fee collected | | E | Other Income | Pet fees, parking, storage, etc. | | F | Total | =SUM(C2:E2) |

Log every income event as its own row. If a tenant pays rent in two installments, that's two rows. This keeps the log as a source-of-truth ledger rather than a pre-aggregated summary — and SUMIF on your Dashboard will handle the aggregation later.

Set up dropdown validation for the Property column (Data → Data validation → Dropdown from a range, pointing to column A on your Properties tab). This prevents typos that would break your SUMIF formulas on the Dashboard.

---

Personal Finance Tracker (Google Sheets) ($19) → — if you want a pre-built tracker that handles rental income alongside personal savings, investments, and monthly budgets, this template has it all wired up already.

---

Tab 3: Expenses Log

Create a third tab called Expenses Log. Variable costs — repairs, cleaning, landscaping, professional services — get logged here.

Columns:

| Column | Header | Notes | |--------|--------|-------| | A | Month | YYYY-MM format, same as Income Log | | B | Property | Dropdown validated from Properties tab | | C | Category | Dropdown: Repairs / Maintenance / Cleaning / Utilities / Professional / Other | | D | Amount | Cost in dollars | | E | Notes | Vendor, description, receipt reference number |

The Category dropdown is important for tax prep. When your accountant asks for repair vs. improvement breakdown (a common IRS distinction), you can filter this column and export the answer in 30 seconds instead of hunting through bank statements.

To set up the Category dropdown: select the C column, go to Data → Data validation → Dropdown, and enter your categories manually. Use the same list every time — consistency is what makes filtering useful.

Freeze the header row on all three tabs: View → Freeze → 1 row. This keeps headers visible when you scroll through months of data, which you'll thank yourself for come December.

---

Tab 4: Dashboard

The Dashboard is where the four tabs connect into something usable. Create one section per property.

Per-Property P&L

For each property, you want four numbers: Total Income, Total Expenses, Net Cash Flow, and YTD Cash Flow. Use SUMIF to pull them from your logs.

For Oak Street Duplex (assuming property names are in column B of both logs):

Total Income:    =SUMIF('Income Log'!B:B, "Oak Street Duplex", 'Income Log'!F:F)
Total Expenses:  =SUMIF('Expenses Log'!B:B, "Oak Street Duplex", 'Expenses Log'!D:D)
Net Cash Flow:   =TotalIncome - TotalExpenses  (reference the cells above)

To make these month-specific rather than all-time, add a second criteria for the Month column using SUMIFS:

=SUMIFS('Income Log'!F:F, 'Income Log'!B:B, "Oak Street Duplex", 'Income Log'!A:A, "2026-07")

Occupancy Rate Tracker

Add a simple column showing months rented vs. months owned. If you bought a property in January and it's now July, that's 7 months owned. If rent was received all 7 months, occupancy is 100%. If one month was vacant, it's 86%. Tracking this annually helps you model whether vacancy risk justifies your current pricing.

=COUNTIF('Income Log'!B:B, "Oak Street Duplex") / months_owned

YTD Cash Flow with Sparkline

Add a column for each month of the year, pulling net cash flow using SUMIFS for that property + that month. In the final column, add a sparkline to visualize the trend:

=SPARKLINE(B5:M5, {"charttype","line"; "color","#16a34a"})

This gives each property row a small line chart showing cash flow across the year — immediately visible if a property's numbers are declining.

---

Pro Tips for Managing the Tracker

Color-code by property. Pick a color for each property and apply it as a background to every row in that property's section of the Dashboard. When you scan the sheet, you immediately know which property you're looking at without reading names.

Share read-only with your property manager. If you use a property manager, go to File → Share, enter their email, and set permission to Viewer (not Editor). They can see income logs and expense totals without being able to change formulas or add data. This keeps your records clean while giving them visibility into cash flow conversations.

Create a separate tab for large capital expenses. Roof replacements, HVAC installs, and major renovations don't belong in the monthly Expenses Log — they're capital expenditures with different tax treatment. Create a CapEx tab with columns for Date, Property, Description, Amount, and Depreciation Schedule. Link to it from your Dashboard as a note, but keep it separate from operating expenses so your monthly cash flow numbers aren't distorted by a $12,000 roof.

---

Frequently Asked Questions

Can I track rental income in Google Sheets? Yes — using four tabs: Properties (fixed costs + baseline cash flow formula), Income Log (monthly rent and fees), Expenses Log (variable costs by category), and a Dashboard using SUMIF to pull per-property P&L. This setup scales to 10+ properties without slowing down and gives you tax-ready records by category.

What expenses should I track for a rental property? Track fixed costs (mortgage, insurance, HOA, property management fees) in the Properties tab, and variable costs (repairs, maintenance, cleaning, utilities, professional services) in the Expenses Log. Use a Category dropdown for variable expenses so you can filter by type at tax time. Keeping fixed and variable costs in separate places makes it easier to see baseline cash flow vs. actual monthly profit after all costs.

How do I calculate cash flow in Google Sheets? For baseline cash flow, use =Monthly Rent - (Mortgage + Insurance + HOA + Other Fixed Costs) in your Properties tab. For actual monthly cash flow on your Dashboard, use SUMIFS to pull total income and total expenses for each property by month, then subtract expenses from income. Add a YTD column with SUMIFS for all months year-to-date, plus a sparkline for trend visualization across the row.

---

A well-built rental income tracker doesn't just organize numbers — it tells you which properties are actually performing, which are quietly bleeding cash, and where your next decision point is. Google Sheets handles all of it for free, with formulas you can understand and audit yourself.

Monthly Budget Planner (Google Sheets) ($19) → — manage your rental income alongside your personal finances, savings goals, and monthly spending in a single connected spreadsheet system.