Rental Property Expense Tracker Template for Google Sheets (Free, 2026)

Owning a rental property is mostly invisible work until tax season, when one question suddenly matters a lot: where did the money go, and on which property? A rental property expense tracker answers that all year long. It keeps income and expenses separated per property, organizes costs into the categories landlords actually report, and turns a year of receipts into a few clean totals. This guide walks through a free Google Sheets rental property expense tracker template and how to keep it updated without manual entry.

What a rental property expense tracker actually does

A good landlord tracker does three things a notes app never will:

1. Separates by property. Every dollar of rent and every repair is tagged to a specific property or unit, so the totals never blur together.
2. Organizes by category. Costs land in the buckets that matter for rentals — repairs, insurance, mortgage interest, property management — instead of one undifferentiated pile.
3. Shows cash flow. Income minus expenses, per property, so you know which rental is making money and which is quietly bleeding it.

The payoff is twofold. During the year, you can make decisions — raise rent, fire a contractor, sell a unit — based on real numbers. At tax time, your totals are already organized the way you need to report them, which makes filing faster and cheaper.

Why Google Sheets is the right home for it

You could track rentals in dedicated property software, but most of it is overkill for a handful of units and carries a monthly fee. Google Sheets hits the sweet spot for landlords:

• Free and cloud-based. No license, and it auto-saves so you never lose a year of records.
• Works everywhere. Log a repair from your phone at the property, review cash flow on your laptop later.
• Easy to share. Hand your accountant view access instead of emailing a folder of receipts.
• Automatable. It connects to Avery, which imports and categorizes your bank transactions per account, so the tracker stays current without manual entry.

That last point is the difference between a tracker you keep for one quarter and one that's still accurate next April.

How to set up a rental property expense tracker (step by step)

You can build one from scratch, but starting from a template means the per-property structure and formulas already work. Here's the full process either way.

Step 1: List your properties

Create a Properties tab and add a row for each rental or unit — a short label like "123 Oak St" or "Duplex Unit B" is enough. Everything else in the tracker references these labels, so this is the backbone that keeps each property's numbers separate.

Step 2: Record your rental income

Log all the money each property brings in, not just base rent. That includes late fees, pet fees, parking, laundry income, and any tenant reimbursements. Tag each entry to the right property.

One nuance worth getting right: a refundable security deposit you're holding is generally not income. Record it separately so it doesn't inflate a property's earnings. If you keep part of it for damages at move-out, that portion is usually treated as income — confirm with your accountant.

Step 3: Build your expense categories

List the categories landlords use most down the expense log. A solid starter set:

• Repairs
• Maintenance
• Insurance
• Mortgage interest
• Property management
• Property taxes
• Utilities (the ones you pay)
• HOA dues
• Advertising and tenant screening
• Supplies
• Legal and professional fees

Tag every expense to both a property and a category. This is the structure that makes year-end totals a copy-paste instead of a reconstruction project.

Step 4: Track income and expenses

You have three options, in increasing order of "set it and forget it":

1. Manual entry — add each transaction as it happens. Most accurate, most effort.
2. Monthly catch-up — sit down once a month with your statements and enter everything.
3. Automatic sync — connect Avery and your transactions import and categorize themselves, per account.

For landlords, option 3 matters even more than for personal budgeting, because rental transactions are spread across rent deposits, contractor payments, and recurring bills that are easy to forget.

Step 5: Review monthly, file at year-end

A tracker is only useful if you look at it. Put 15 minutes on your calendar each month to confirm categories and check each property's cash flow. When tax season arrives, your income and deductible expense totals are already organized per property — no shoebox, no guessing which repair belonged to which unit.

Deductible rental property expense categories (general, not tax advice)

This is the part most landlords most want help with: what counts. The categories below are the ones landlords commonly track and deduct. Treat this as general organization guidance — it is not tax advice, and you should confirm what applies to your situation with a qualified accountant.

Repairs

Costs that keep the property in working condition — fixing a leak, replacing a broken appliance, patching drywall, repainting. Repairs are usually deducted in the year you pay them.

Maintenance

Routine upkeep that prevents problems: landscaping, gutter cleaning, pest control, HVAC servicing. Recurring and predictable, and easy to forget if you're not logging it.

Insurance

Landlord or rental property insurance premiums for each property. Keep these separate from any personal homeowner's policy.

Mortgage interest

The interest portion of your mortgage payment is a common deductible expense. The principal portion is not an expense — it's paying down the loan. Log them separately, or note the split, so your deductible totals are accurate.

Property management

Fees paid to a property manager or management company, plus leasing fees and tenant-placement charges.

Property taxes

The annual property taxes assessed on each rental. If your lender escrows them, pull the actual tax amount rather than the escrow deposit.

Utilities and HOA dues

Any utilities you pay on the tenant's behalf, plus HOA or condo association dues for the property.

Advertising and tenant screening

Listing fees, photography, and background or credit checks when you're filling a vacancy.

Repairs vs. improvements

This distinction trips up new landlords. A repair restores something to working order and is usually deducted now. An improvement adds value or extends the property's life — a new roof, a kitchen remodel, a room addition — and is usually depreciated over several years rather than deducted all at once. The tracker lets you flag improvements separately so you and your accountant can handle them correctly.

How this maps to Schedule E

Many individual landlords report rental income and expenses on Schedule E. You don't need to memorize the form — the point is that it expects your income and expenses grouped into categories very similar to the ones above. Because the tracker already organizes everything that way, transferring your year-end totals (or handing them to a preparer) is straightforward.

Depreciation is the one piece the tracker doesn't calculate for you. It deliberately focuses on income and operating expenses, while giving you a place to log dated purchases and improvements. That record is exactly what your accountant or tax software needs to build the depreciation schedule quickly.

Again: this is organization, not tax advice. Rules change and situations differ, so confirm the specifics with an accountant.

Per-property tracking is the whole point

If you take one thing from this guide, make it this: never let two properties share a column. The moment a repair on the duplex gets logged in the same bucket as a repair on the single-family rental, you lose the ability to answer the questions that matter — which property is profitable, which one keeps needing work, whether it's time to sell.

Per-property tracking is also what makes the tracker scale. One property or twelve, the structure is the same: tag everything to a property, let the totals roll up. The rental property expense tracker template is built around exactly this, and the landlord tracking Q&A covers the per-property setup questions landlords ask most.

Keeping the tracker current (the part that matters)

Here's the uncomfortable truth about every rental spreadsheet: it dies the moment you stop entering data. Rental transactions are especially easy to neglect because they're irregular — a contractor here, an insurance renewal there, rent deposits on different days. Miss a few weeks and you're reconstructing from bank statements.

That's the problem Avery solves. Connect your bank with a read-only link and Avery:

• Imports every transaction automatically into the tracker.
• Categorizes each one with AI, learning your corrections over time.
• Syncs per account, so each property's dedicated account can flow into its own section.

You go from "reconstruct a year of expenses" to "spend a few minutes a month confirming categories." The tracker stays current, which means it's actually ready when tax season arrives.

Related templates and guides

• Rental Property Expense Tracker template — the free Google Sheet this guide is built around.
• Rental property tracking Q&A — quick answers to the most common landlord setup and deduction questions.
• Expense Tracker template — a simpler personal spending log if you don't need per-property reporting.
• Budget Spreadsheet template — a flexible budget for your personal finances alongside the rentals.
• Simplify bookkeeping in Google Sheets — how to keep clean books without an accounting app.
• Free monthly budget template guide — the companion walkthrough for monthly personal budgeting.
• Browse all free templates — the full Avery library.

A rental property expense tracker gives you control over your numbers; automation keeps them accurate. Start with the free template, organize your properties, and let Avery handle the data entry so the tracker is still ready for you next tax season — not gathering dust.