Tracking Rental Property Expenses in ExpenseBot
If you own rental properties, the IRS requires you to report income and expenses separately for each property on Schedule E. ExpenseBot has a dedicated rental property flow that solves three problems a generic expense tracker can't:
- Per-property partitioning. Every receipt, every rent deposit, attributed to the correct property automatically.
- Deterministic address matching. Receipts that mention a property address (merchant memo, subject line, line items) get tagged to that property without Gemini having to guess — zero false-positive risk for properties that share a street.
- Schedule E-shaped reporting. One report per property with IRS line-item layout, plus manual entry fields for mortgage interest and depreciation.
Step 1 — Set up your properties
- Go to Settings → Rental Properties
- Click + Add a rental property
- Fill in:
- Nickname — short name for the tag (e.g. "Brooklyn duplex"). Max 20 chars.
- Street number and Street name — both required for deterministic address matching to work
- City and Postal / ZIP code — optional but help with matching
- Purchase date — used for depreciation start date in the Schedule E report
- Rental % — default 100; lower for house-hacks where you occupy part of the property (e.g. 75% if you live in one unit of a duplex)
- Property type — residential (27.5-yr depreciation) or commercial (39-yr)
- Click Save property
ExpenseBot creates a tag named Prop – <nickname> (e.g. Prop – Brooklyn duplex) in your Tags list. Every future receipt or rent deposit that mentions the property address gets auto-tagged.
Step 2 — Receipts auto-tag as they come in
Three ways a receipt gets attributed to the right property:
A. Address match in subject / content (fully automatic) Forward a receipt with the address in the subject or body:
Subject: Fwd: Home Depot materials for 123 Main St repair
ExpenseBot's deterministic matcher sees "123 Main" token pair, finds the matching property, tags it Prop – Brooklyn duplex. Zero Gemini guesswork.
B. Explicit tag shorthand
Subject: Fwd: your plumbing invoice tag:prop-brooklyn
Works on any receipt even if the body doesn't mention the address.
C. Manual tag in the app Edit Column K in the master sheet or use the ExpenseBot app's tag dropdown.
Ambiguity handling: if you have two properties on the same street (123 Main and 127 Main), the matcher requires the exact street number to disambiguate. If a receipt just says "Main Street" with no number, it falls through to Gemini's normal tag classification instead of auto-applying the wrong tag.
Step 3 — Run your Schedule E report
- Go to My Reports → Create Report → Schedule E Rental
- Pick a single property, or All properties for a consolidated view
- Pick the tax year
- ExpenseBot generates a Google Sheet with IRS Schedule E line layout:
Property: 123 Main St, Brooklyn NY 11201
Rental % applied: 100%
EXPENSES
Line 5 Advertising $ 180
Line 7 Cleaning and maintenance $ 1,250
Line 9 Insurance $ 1,800
Line 10 Legal and other professional fees $ 340
Line 11 Management fees $ 2,400
Line 12 Mortgage interest [manual entry] $ 0
Line 14 Repairs $ 890
Line 15 Supplies $ 210
Line 16 Taxes $ 5,400
Line 17 Utilities $ 2,100
Line 18 Depreciation [manual entry] $ 0
Line 19 Other — HOA/Condo Fees $ 3,600
TOTAL EXPENSES $18,170
Mortgage interest and depreciation are manual-entry fields because they come from loan statements (not receipts) and depend on IRS calculation rules you customize yourself. ExpenseBot links to IRS Publication 527 for depreciation guidance.
What happens to the Expense Accounts list?
When you add your first rental property, ExpenseBot adds three new Expense Accounts to your spreadsheet:
- Cleaning and Maintenance (Schedule E Line 7 — distinct from "Repairs and Maintenance" which is Line 14)
- Property Management Fees (Schedule E Line 11)
- HOA and Condo Fees (Schedule E Line 19 "Other")
These only appear once you have a rental property configured — non-landlord users won't see them.
Frequently asked questions
What if I sell a property mid-year? Set the property's Active end date to the sale date. The Schedule E report honors the activeStart/activeEnd window and will only include receipts from the ownership period.
What if I do short-term rentals (Airbnb, VRBO)? Short-term rentals may be Schedule E (passive) or Schedule C (active business) depending on level of service. ExpenseBot tracks either way — the tag and matching behavior is the same. Work with your accountant on which Schedule the income belongs on.
What if the property is owner-occupied (house hack)? Set Rental % to the portion actually rented (e.g., 50% if you rent half a duplex). The Schedule E report prorates shared expenses (utilities, HOA) by that percentage before reporting. Fully-owned-portion receipts should go to Personal.
What about mortgage interest — can ExpenseBot track that automatically? Not yet. Mortgage interest comes from a 1098 statement, not a receipt. Enter it manually in the Schedule E report. Future updates may auto-extract from forwarded 1098 PDFs.
What about depreciation? Manual entry. Depreciation math depends on the land-vs-building cost basis allocation which is property-specific and something you set up once with your accountant. ExpenseBot provides the entry field and a link to IRS Pub 527.
Can family members forward receipts from their own accounts? Yes — add their email as a forwarding email (Settings → Forwarding Addresses). Forwarded receipts land in your spreadsheet with the property tag applied, same as if you forwarded them.
Does this work for rental income too? Yes — rent deposits detected by ExpenseBot's Gmail income scanner use the same address matching. A Zelle or ACH deposit with "123 Main rent" in the memo auto-tags to Prop – Brooklyn duplex. Once income tracking is live in your account, the Schedule E report shows per-property net (rent received − expenses).
Works for any portfolio size
The flow scales from 1 property to 20+. Each property gets its own tag, its own matching rules, and its own Schedule E page. The consolidated view shows all properties side-by-side for your accountant.