Rental Property Expense Tracker: Your Questions Answered
Clear, direct answers to the questions people ask most about the Rental Property Expense Tracker — setup, categories, taxes, and automation — all in one place.
Get the Rental Property Expense Tracker (Free)
We’ll email you a copy and open it in a new tab.
We’ll email you a copy and open the template in a new tab. No spam.
Getting started
How do I set up the rental property expense tracker?
Copy the Google Sheet to your Drive, list each property on the Properties tab, then either log income and expenses manually or connect Avery for automatic bank sync. Setup takes about 10 minutes.
What is a rental property expense tracker?
A rental property expense tracker is a structured sheet that records rental income and expenses for each property you own, organized into categories like repairs, insurance, and property management, so you can see cash flow per property and have clean records at tax time.
Can I use it for multiple units or a whole portfolio?
Yes. Add a row per property or unit on the Properties tab and tag each transaction to one. Whether you own one duplex or a dozen single-family rentals, every property gets its own income, expense, and net total.
Can I use the tracker on my phone?
Yes. The Google Sheets mobile app opens the full sheet, so you can log a repair bill or check a property's cash flow in about 30 seconds from anywhere.
Income and expenses
What rental income should I record?
Record all rent collected plus any other money the property brings in — late fees, pet fees, parking, laundry income, and tenant reimbursements. Tag each one to the right property so the per-property totals stay accurate.
Which rental property expense categories are included?
The tracker ships with the categories landlords use most — repairs, maintenance, insurance, mortgage interest, property management, utilities, property taxes, HOA dues, advertising, and supplies — each tagged to a property so nothing gets missed.
How is net cash flow calculated per property?
For each property the sheet subtracts total expenses from total income, so you can see at a glance which units are profitable and which are draining cash. The numbers update automatically as you log or sync transactions.
How do I handle a security deposit?
A refundable security deposit is not income while you are holding it, so record it as a liability or in a separate column rather than as rent. If you keep part of it for damages at move-out, that portion is generally treated as income — confirm with your accountant.
How do I record a mortgage payment?
Split the payment into its parts. The interest portion is a common deductible expense, while the principal portion is not an expense. Log them separately (or note the split) so your deductible totals are accurate at year-end.
Deductions and Schedule E
Which rental property expenses are commonly deductible?
Landlords often deduct ordinary and necessary costs of operating a rental — repairs, maintenance, insurance, mortgage interest, property management fees, property taxes, utilities you pay, HOA dues, advertising, and travel related to the property. This is general information, not tax advice — confirm what applies to you with an accountant.
What is the difference between a repair and an improvement?
A repair keeps the property in working condition (fixing a leak, patching drywall) and is usually deducted in the year you pay it. An improvement adds value or extends the property's life (a new roof, a remodel) and is usually depreciated over time. The tracker lets you flag improvements so you can discuss them with your accountant.
What is Schedule E and how does the tracker help?
Schedule E is the IRS form many individual landlords use to report rental income and expenses. The tracker's categories are organized to map cleanly onto the kinds of lines Schedule E uses, so your year-end totals are easy to transfer or hand to a preparer. It is not tax advice.
Does the tracker handle depreciation?
The tracker focuses on income and operating expenses and gives you a place to note improvements and asset purchases. Depreciation schedules are best calculated with your accountant or tax software, but having your purchases logged and dated makes that step much faster.
Is this tracker tax advice?
No. It is a record-keeping tool that organizes your rental income and expenses into clear categories. Tax rules vary by situation and change over time, so confirm what is deductible and how to file with a qualified accountant.
Automation and sharing
How does Avery keep the tracker updated?
Avery connects to your bank through a read-only link, imports every new transaction, and uses AI to sort each one into your categories — and because it syncs per account, you can route each property's account into its own section without manual entry. You just review monthly.
Can I share it with my accountant or partner?
Yes. Share the Google Sheet directly or export clean per-property summaries to Excel or PDF. Because the records arrive categorized by property, your accountant spends less time sorting and more time filing.
Is my financial data secure?
The sheet lives in your own Google Drive — you own it, not a third-party app. Avery's bank connections are read-only and bank-grade encrypted, and it can never move money. Enable two-factor authentication on your Google account for an extra layer.
Keep going