Rental Property Expense Tracker For Google Sheets
Track every dollar per property. Income, expenses, and deductions in one Google Sheet — no shoebox of receipts.
- Who it’s for
- Landlords and small real estate investors who want clean per-property income and expense records without hiring a bookkeeper.
- Problem it solves
- Most landlords track rentals in their head or a notes app, then scramble at tax time to remember which repair belonged to which unit. This tracker keeps income and expenses separated by property all year, so your numbers are ready when you need them.
We’ll email you a copy and open the template in a new tab. No spam.
Key benefits
- Per-property income and expense tracking in one sheet
- Common deductible categories — repairs, maintenance, insurance, mortgage interest, property management
- Net cash flow and profit per property at a glance
- Receipt links and notes for every transaction
- Schedule E-friendly category structure for year-end
- Works alongside Avery bank sync — no manual entry
The Rental Property Expense Tracker is Avery's expense tracker rebuilt for landlords. Where a personal tracker stops at "where did my money go," this one answers the questions that actually matter for a rental: which property made money this year, and is every deductible expense documented?
Who it's for
- First-time landlords renting out a single property who want clean records from day one.
- Small portfolio investors juggling several units who need income and expenses separated per property.
- House hackers and accidental landlords who moved out and kept the old place as a rental.
- Anyone who dreads tax season because their rental costs live in a notes app and a pile of receipts.
What's inside
A pre-built Google Sheet with everything wired up:
- Properties — list each rental or unit so every transaction can be tagged and totaled per property.
- Income log — rent and other rental income, tagged to the right property.
- Expense log — common deductible categories like repairs, maintenance, insurance, and property management.
- Per-property cash flow — income minus expenses for each property, calculated automatically.
- Year-end totals — organized to line up cleanly with how landlords report on Schedule E.
The honest part
A tracker only works if the numbers are actually in it. Most landlord spreadsheets go stale because nobody wants to type in transactions every month. This template assumes Avery handles that part — auto-syncing and categorizing your property transactions per account — so the tracker stays current and your deductions are never guesswork.
One note: this is a record-keeping tool, not tax advice. The categories follow how landlords commonly organize rental income and expenses, but confirm what applies to your situation with an accountant.
Want the full walkthrough with deductible categories and per-property examples? Read the complete rental property expense tracker guide, or jump to the most-asked landlord tracking questions. Need a simpler personal spending log instead? Try the Expense Tracker.
More Templates
See All Templates- SpendingFree
Expense Tracker
A clean Google Sheets expense tracker for logging transactions, spotting spending patterns, and keeping personal finances organized — use it manually or let Avery sync your bank automatically.
- expenses
- transactions
- BudgetingFree
Budget Spreadsheet
A free Google Sheets budget spreadsheet template with automatic calculations, smart categories, and budget-vs-actual tracking — use it manually or let Avery sync your bank transactions in.
- budget
- spreadsheet
- SpendingFree
Business Expense Tracker
A free Google Sheets business expense tracker for small business owners — separate business spending, sort it into deductible categories, and keep clean records your accountant will love.
- business
- expenses
Frequently Asked Questions
Is this rental property expense tracker really free?
Can I track more than one property?
Does it help with rental property taxes?
Do I need Avery to use it?
Helpful next steps
Related guides
Questions & answers
17 answers on setup, deductions, categories, and taxes — written for answer engines and people in a hurry.
Browse all 17 Q&As →