ExpenseBot

The One Tax Form That Trips Up DIY Landlords (Schedule E & T776)

Per-property reporting is required by the IRS and CRA — and every generic expense tool gets it wrong.

Here's a conversation that happens in every accountant's office in April: the landlord drops off a shoebox of receipts, and the accountant asks, "OK — which property was this one for?" The landlord shrugs. The accountant sighs. Two billable hours later, the return is finally ready.

The root cause isn't the landlord being disorganized. It's that almost every expense tracker on the market — Mint, Expensify, generic Google Sheets templates, even landlord-specific budget apps — treats rental receipts as a single "Rental" category. That works for your monthly budget. It does not work for your tax return.

The IRS (Schedule E) and the CRA (T776) both require per-property reporting. You cannot lump expenses from three rentals into one number. Every receipt has to be attributed to a specific property, and the forms are built that way on purpose. If your tracking system doesn't have a "which property?" dimension on every receipt, you're going to spend April doing manual rework.

This is the piece of the rental-property tax puzzle that DIY landlords miss most often, and it's the piece that costs the most hours in cleanup. Here's what the forms actually require, why generic tools fail, and what a good per-property tracking system looks like.

What Schedule E Actually Requires

IRS Schedule E, Part I, is the form for reporting passive rental real estate income. The structure itself tells you the answer: the form has three columns labeled A, B, and C, one per property. Each column is a separate vertical strip of the page, and each has its own set of line items.

Key Schedule E line items (per property):

  • Line 1a/1b: Property address and type
  • Line 2: Fair rental days and personal use days
  • Line 3a: Rents received
  • Lines 5–19: Expense categories (advertising, auto, cleaning, commissions, insurance, legal, management, mortgage interest, other interest, repairs, supplies, taxes, utilities, depreciation, other)
  • Line 20: Total expenses
  • Line 26: Net income or loss for this property

If you own four or more rental properties, you cannot combine them. The IRS requires you to attach additional Schedule E forms, using columns A/B/C on each, until every single property is reported separately. That's in the Schedule E instructions and reinforced in IRS Publication 527, which is the official residential rental property guide.

Why does the IRS care so much about separation? Because rental losses are subject to passive-activity rules (the $25,000 offset limit, the active-participation test, the phase-out at $150,000 AGI). Those rules apply per property, not in aggregate. If the IRS audits you and you hand them a spreadsheet with "Rental: $42,000 expenses," they cannot apply the rules correctly — and they'll ask you to re-do the return.

If you're a US landlord and want a Schedule-E-first tracking system, the US expense tracker feeds into the same per-property worksheet builder we describe later in this post.

What T776 Actually Requires (Canadian Landlords)

Canada goes even further than the US: the CRA requires one T776 (Statement of Real Estate Rentals) per property. There is no "up to three in one form" shortcut. If you own four rentals, you file four T776s as part of your T1 return.

Key T776 line numbers:

  • Line 8141: Gross rents
  • Line 8521: Advertising
  • Line 8690: Insurance
  • Line 8710: Interest and bank charges
  • Line 8960: Maintenance and repairs
  • Line 8871: Management and administration fees
  • Line 9180: Property taxes
  • Line 9220: Utilities
  • Line 9369: Total expenses
  • Line 9946: Net income (loss) for this property

The CRA's T776 guide (also published as Guide T4036) spells out every line number and what qualifies. If you have a co-owner (spouse, partner, relative), you also have to split each property's income and expenses by ownership percentage and each co-owner reports their share on their own T776.

Canadian landlords working across multiple properties often find the Canadian expense tracker easier than trying to build a T776-shaped spreadsheet from scratch. The line numbers above are the canonical CRA-defined output, and you want the tool to map to them directly.

Why Generic Expense Trackers Fail Landlords

Every generic expense tracker — Mint, Expensify, SimplyWise, the built-in Google Sheets "monthly budget" template — has the same architecture: a transaction has a date, an amount, a merchant, and a category. That's it. No property dimension. No way to say "this Home Depot receipt was for the plumbing at 123 Main, not the painting at 456 Elm."

So landlords do one of two things. Either they tag every receipt as "Rental" or "Maintenance" — which produces a single lumped total that fails both Schedule E and T776 — or they try to use the memo field as a pseudo-property-tag, which works until you have 300 receipts and no index.

Come April, the landlord has to manually re-split every receipt by property. An hour per property if you're organized. A weekend per property if you're not. Now multiply that by three or five or ten rentals.

Mint is the worst offender (and it's being retired, but the app-category problem remains). Expensify was built for business-trip reimbursement, not property tracking. SimplyWise is a receipt scanner with no multi-property model. Generic Google Sheets templates from "personal finance blog #437" all assume you have one budget, not five properties.

This is a category-wide failure, not one bad app. The product is solving the wrong shape of problem.

Tag every receipt to the right property — automatically.

ExpenseBot's rental tracker auto-matches receipts to your properties and outputs a Schedule E or T776 worksheet.

See the Rental Property Tracker →

$10/month flat · Any number of properties · US Schedule E + Canada T776 output

The Three Workarounds — And Why They Break

Landlords who recognize the per-property problem usually attempt one of three workarounds. All of them are better than lumping, and all of them have failure modes.

Workaround 1: A separate spreadsheet per property

You open a Google Sheet tab for each rental and enter receipts manually. This works — if you do it religiously. The failure mode is human: you travel for a week, skip entering five receipts, come back and don't remember which property the Home Depot run was for. By August, three tabs are out of date. By December, it's easier to dump everything in one tab "temporarily" and deal with it at tax time. You've regressed to lumping.

Workaround 2: QuickBooks with Classes

QuickBooks Online lets you tag every transaction with a "Class" (treat each property as a class). This is the accountant-approved solution. It also costs $30–$90/month for the Plus tier that unlocks Classes, plus most landlords need a bookkeeper to maintain it ($150–$400/month). You're looking at $2,000–$5,000/year in tooling and labor to solve a tagging problem.

Workaround 3: Landlord Studio or similar

Purpose-built landlord software does per-property tagging correctly. The gotcha: most of these tools price per property. Landlord Studio is roughly $12–$20/month per property at the time of writing. If you own five rentals that's $60–$100/month — $720–$1,200/year — before you've paid for anything else. The economics break as your portfolio grows, which is precisely when you need the tool most.

What Good Per-Property Tracking Looks Like

Strip away the pricing and UI differences, and a good rental-property tracking system needs to do four things:

  1. Property setup as a first-class object. You register each property once with its address, purchase date, and rental percentage (for house hacks). Every receipt references a property by ID, not by a typed-in text field.
  2. Deterministic receipt-to-property tagging. When a Home Depot receipt comes in at 11pm, the tool should know which property it belongs to without you having to tag it manually. The cleanest signal: address match on the receipt (delivery address, ship-to, or merchant location near the property). Gemini or similar can supplement when the address isn't on the receipt, but deterministic match is the foundation.
  3. Rental percentage proration for house hacks. If you live in 40% of a duplex, the tool automatically multiplies shared expenses (utilities, insurance, property tax) by 60% before putting them on the Schedule E worksheet. You set the percentage once; the math is consistent every time.
  4. Country-branched worksheet output. At year-end, you want a Schedule E column (US) or T776 line numbers (Canada) — not a generic expense dump. The tool should know your country and output the form your accountant actually needs.

If you already capture receipts from Gmail — vendor emails, Amazon orders, utility bills, insurance renewals — a Gmail receipt scanner gets you 80% of the way, and the per-property dimension is what turns it into a tax-ready dataset. For a general-purpose comparison of rental vs. self-employment reporting, the Schedule C expense tracker page covers the freelancer side.

Edge Cases That Trip People Up

Beyond the basic per-property split, a handful of scenarios catch DIY landlords every year.

Security deposits are not rental income (until you keep them).

Landlord receives a $2,000 security deposit, deposits it in the operating account, sees it flow through a Plaid feed as "rent," and — on a lumped tracker — it gets counted as rent received. Wrong. Deposits are trust funds. They become income only in the year you apply them to unpaid rent or damages. A good tracker categorizes deposits separately and excludes them from Schedule E line 3a until a status change.

Mid-year purchases and sales.

If you bought a property on June 15, only expenses from June 15 onward belong on that property's Schedule E column. If you sold on September 30, expenses after that date aren't yours. Your tool needs a purchase/sale date per property and should refuse receipts outside the ownership window (or at minimum flag them).

House hacks and rental percentage.

The rental percentage is a contract between you and your tax return. Set it wrong and every shared-expense line is wrong all year. The rental percentage is also audit-relevant: the IRS and CRA have both asked for supporting documentation (square footage, number of bedrooms, etc.) when the percentage looks aggressive.

Two properties on the same street.

Deterministic address match breaks when you own 123 Main St and 125 Main St. If your tracker matches by "Main St" alone, every receipt lands on whichever property got created first. The match needs to be on full address, not tokens.

Deleted properties with historical receipts.

You sell a property in 2025, but in April 2026 you still need to file 2025's Schedule E for it. Deleting the property in your tracker to clean up the UI should not delete the historical receipts attached to it. Soft-delete only. This is the sort of detail that reveals whether a tool was built with tax filing in mind.

What's Still Manual (For Every Tool, Not Just ExpenseBot)

Full disclosure: even a perfect per-property tracker does not automate every line on Schedule E. Two big items stay manual for every tool on the market.

Mortgage interest.

Your lender sends Form 1098 in January with the total interest paid. That's your number for Schedule E line 12 (or T776 line 8710). It doesn't come from receipts — it comes from the 1098. Any tool that tries to infer mortgage interest from bank transactions is going to be wrong, because most payments bundle principal and interest. Wait for the 1098.

Depreciation.

Depreciation is the single biggest deduction most landlords take, and it is not a receipt. Residential rental property is depreciated on a 27.5-year straight line (39-year for commercial) against the building value — not the total purchase price. You have to allocate your purchase between land (not depreciable) and building (depreciable), usually based on the property tax assessor's land/building ratio. IRS Publication 527 walks through this calculation in detail. Your accountant or TurboTax handles it once you provide the allocation.

A tracking tool's job is to get every receipt to the right property in the right category. The 1098 and the depreciation schedule happen once a year, at your accountant's desk. No tool, including ours, changes that.

How ExpenseBot Solves This

ExpenseBot's rental property tracker was built specifically around the four requirements above:

  • Property setup as a first-class object — register each rental with its address, purchase date, and rental percentage. Every receipt gets tagged with a property ID.
  • Deterministic address match — receipts from Gmail, Amazon, or scanned photos are auto-matched to the correct property by delivery address, full-address token-subset match, and Gemini fallback for edge cases. Same-street properties are handled correctly.
  • Rental percentage proration — set once per property; shared-expense math is applied uniformly on every worksheet generation.
  • Country-branched output — US users get a Schedule E worksheet with columns A/B/C per property (and overflow sheets for 4+ properties). Canadian users get per-property T776 worksheets mapped to lines 8141, 8521, 8690, 8710, 9180, 9220, 9369, and 9946.

Pricing is flat $10/month — not per property. Two rentals or twenty, it's the same price. The rental tracker lives inside the same ExpenseBot spreadsheet you already use for other receipts, so your Schedule E worksheet and your Schedule C worksheet come out of the same dataset without switching tools.

If you've been running shoebox, Mint, or a half-maintained per-property spreadsheet, the switch takes about 15 minutes: register your properties, connect Gmail, let ExpenseBot backfill the past year of receipts, and review the auto-matched assignments.

For related reading, our T2125 Uber driver guide is the sister post for self-employed Canadians, and the Schedule C deductions guide covers the US self-employment side. Both pair well with rental income if you have mixed sources.

Stop re-splitting receipts in April.

ExpenseBot tags every rental receipt to the right property all year, and outputs Schedule E or T776 worksheets at tax time.

Start Tracking Rentals Free →

$10/month flat · Any number of properties · 60-day free trial · US + Canada

Frequently Asked Questions

Do I need a separate Schedule E for each rental property?
Schedule E has three columns (A, B, C) on a single form, so you can report up to three properties on one sheet. If you own more than three rentals, the IRS requires you to attach additional Schedule E forms until every property is listed separately — you cannot lump them together. Each property gets its own column with its own rents received (line 3a), its own expenses on lines 5 through 19, and its own net income or loss on line 26. IRS Publication 527 is the authoritative guide for how each column should be filled out, and it makes per-property separation mandatory.
What's the difference between Schedule E and Schedule C for rental income?
Schedule E is for passive rental income from real estate — typical long-term residential rentals where you collect rent and pay expenses. Schedule C is for active business income, which for landlords generally means short-term rentals where you provide substantial services (cleaning between guests, meals, concierge). Most Airbnb hosts who do not offer hotel-like services still file Schedule E. Schedule C triggers self-employment tax (15.3%), while Schedule E income is not subject to SE tax. If you are a freelancer comparing the two, our Schedule C expense guide covers the self-employment side in detail.
How do Canadian landlords file rental income — T776 or T2125?
Canadian landlords file Form T776 (Statement of Real Estate Rentals) with their T1 return, one T776 per property. T2125 is for self-employment and business activities, not rentals, unless you provide enough services that the CRA classifies the activity as a business rather than a rental. For most passive landlords — collecting rent, paying the mortgage, handling repairs — T776 is the right form. If you run a short-term rental with cleaning, meals, and guest services, the CRA may require T2125 instead. When in doubt, ask your accountant which form matches your activity level.
What expenses can I deduct on Schedule E?
Schedule E lines 5 through 19 cover the standard categories: advertising, auto and travel, cleaning and maintenance, commissions, insurance, legal and professional fees, management fees, mortgage interest paid to banks, other interest, repairs, supplies, taxes, utilities, and depreciation. There is also an 'other' line for anything not fitting the standard categories. Every expense must be tied to a specific property — you cannot deduct a repair receipt without knowing which rental it was for. Security deposits you hold for tenants are not income unless you keep part of the deposit. IRS Publication 527 lists every allowable category with examples.
Are security deposits taxable rental income?
No — security deposits held in trust for tenants are not rental income when you receive them, because you expect to return them. They become income only in the year you keep part or all of the deposit (typically to cover damage or unpaid rent). If you apply a deposit to the final month's rent, it becomes rental income in the month you apply it. The CRA takes the same position on T776. Tools that automatically pull every bank transaction labeled 'rent' will often miscount deposits as income — one more reason per-property tracking with clear categorization matters.
How do I handle rental expenses for a house hack on Schedule E?
A house hack is when you live in one unit and rent out the others (duplex, basement suite, or roommate). You can only deduct the rental portion of shared expenses. For a duplex where you live in one unit and rent the other, that is typically 50%. For renting out a basement suite that is 30% of your home square footage, you deduct 30% of shared utilities, insurance, and property taxes. Mortgage interest and repairs specific to the rental unit are 100% deductible. The IRS calls this 'rental percentage' and it must be applied consistently to every shared expense.
Can I use a spreadsheet to track rental property expenses for taxes?
Yes, and the IRS and CRA both accept spreadsheets as a record-keeping system as long as each expense is supported by a receipt you can produce on audit. The challenge is discipline — most landlords start with a per-property spreadsheet in January and stop updating it by March. Common failure modes: forgetting to tag a receipt to a property, copying last year's tab and not resetting numbers, miscounting security deposits as income, and losing the spreadsheet when a laptop dies. A Google Sheet with linked receipt images in Drive solves the backup problem and is still audit-acceptable.
What's the easiest way to generate a Schedule E worksheet?
The easiest approach is a tool that already tags every receipt to a specific property and outputs a worksheet matching Schedule E line items — or T776 line numbers for Canadian filers. ExpenseBot's rental property tracker does this: you register each property address once, it matches incoming receipts to the correct property by address, and at year-end it generates a per-property worksheet with totals by Schedule E line (or T776 line for Canadian users). That worksheet goes straight to your accountant or into TurboTax/H&R Block. Flat $10/month covers any number of properties.
Share:

Track Mileage Automatically with ExpenseBot

Google Maps calculates your distances. Current IRS & CRA rates applied automatically. Tax-ready mileage log in seconds.

No credit card required · Deploys in 30 seconds