What a Schedule E worksheet is
Schedule E (Form 1040), Part I is where rental real estate income and expenses are reported — one column per property. A Schedule E worksheet is simply the working document behind it: your rents and expenses, sorted into the form's own categories, per property, ready to copy onto the return or hand to your CPA. The form itself has not changed much in years. What changes is how painful it is to fill in — and that depends entirely on how you kept records during the year.
Here is the structure, in plain English:
| Line | What goes there |
|---|---|
| 3 | Rents received — all rent actually received during the year, plus amounts like forfeited deposits you kept and tenant-paid expenses you agreed to cover. Advance rent counts when received, even if it covers next year. |
| 5 | Advertising — listing fees, “for rent” ads, sign costs, placement advertising. |
| 6 | Auto and travel — mileage or actual costs for trips to the property, plus travel to collect rent or manage the rental. |
| 7 | Cleaning and maintenance — cleaners, lawn care, snow removal, gutter cleaning, routine upkeep labor and services. |
| 8 | Commissions — leasing commissions and fees paid to others for securing tenants. |
| 9 | Insurance — landlord/rental dwelling policies, liability, flood and similar premiums for the property. |
| 10 | Legal and other professional fees — eviction counsel, lease drafting, your CPA's fee for the rental portion of your return. |
| 11 | Management fees — what you pay a property manager or leasing agent to run the place. |
| 12 | Mortgage interest — the interest portion only, from your Form 1098. Never the whole payment. |
| 13 | Other interest — interest not on Line 12, such as on a loan used for the rental activity. |
| 14 | Repairs — work that keeps the property in operating condition: fixing a leak, patching, replacing a broken component with a like-kind one. |
| 15 | Supplies — small consumables used at the property: paint, filters, batteries, cleaning supplies. |
| 16 | Taxes — real estate taxes and similar property-level taxes (not income tax). |
| 17 | Utilities — water, sewer, electric, gas, trash and internet that you pay for the rental. |
| 18 | Depreciation — the annual depreciation amount for the building and any capitalized improvements or appliances. |
| 19 | Other — legitimate rental expenses that fit nowhere else (HOA dues, pest control, bank fees), listed item by item. |
| 20 | Total expenses — the sum of Lines 5 through 19. |
| 21 | Net income (or loss) — Line 3 minus Line 20, per property. |
Line 4 (royalties) belongs to a different activity and most landlords leave it blank. Lines 22–26 then deal with losses and passive-activity limits — one more reason your per-property numbers need to be right before they reach that section.
The classification mistakes landlords make most
- Repairs vs. improvements. A new roof, a full remodel or a replacement HVAC system is usually a capital improvement that gets depreciated (Line 18), not a repair on Line 14. Misclassifying is the single most common Schedule E error.
- The whole mortgage payment. Only interest is deductible on Line 12. Principal paydown is not an expense at all — it just feels like one.
- Security deposits as income. A refundable deposit is not rent when you receive it. It only becomes income if you keep some of it — and then only the amount kept.
- Mixing properties together. Pooling three houses into one expense pile breaks the per-property columns the form demands, and hides which door is actually losing money.
- Personal/rental splits. If you use part of a property yourself — or stayed in your short-term rental — expenses need a defensible rental-use split, not a guess in April.
- Everything in “Other.” A fat Line 19 with no itemization invites questions. Most of those costs belonged on a named line all along.
Notice the pattern: none of these are math errors. They are sorting errors made months after the fact, when receipts no longer say what the money was for. The fix is to classify each expense into its Schedule E line on the day you log it — which is exactly how the Rental Property Tracker is built.
How the Tracker turns logs into a Schedule E summary
- The Expenses Log's category dropdown is the Line 5–19 list above — there is no second sorting step, ever.
- The Schedule E Summary sheet uses SUMIFS formulas to total every category per property, and outputs Rents Received (Line 3), each expense line, Total Expenses (Line 20) and Net (Line 21) in the form's own layout.
- The Dashboard and Monthly P&L read the same logs, so the numbers you manage by all year are the numbers you file with.
- A Sample Filled file (a complete worked year for two properties) is included, so you can see a finished summary before entering your own data.
Buy the Tracker — $29 one-time
Also available: the Bundle with the Airbnb / short-term rental module — $49. See also our rent roll template guide and the comparison of landlord bookkeeping options.
FAQ
Is this worksheet a substitute for filing Schedule E?
No. It is a record-keeping worksheet that organizes your numbers into Schedule E categories. You (or your CPA) still complete and file the actual form. See the disclaimer below.
I have three properties. Do I need three worksheets?
Schedule E wants one column per property. The Tracker handles up to 10 properties in one workbook and produces a per-property summary, so one file covers your whole portfolio.
What about depreciation — does the spreadsheet calculate it for me?
It has a Depreciation category (Line 18) and includes whatever amount you enter in the totals. Calculating the depreciation schedule itself — basis, placed-in-service dates, recovery periods — is a job for your CPA or tax software; the Tracker keeps the resulting number in the right place.
Does it work in Google Sheets?
Yes. It is a standard .xlsx built on ordinary formulas and dropdowns; upload it to Google Sheets and it works the same. No macros.
My rentals are short-term (Airbnb). Does this still apply?
Short-term rentals have their own reporting wrinkles (Schedule E vs. Schedule C depends on services provided and average stay). The Airbnb income tracker page covers the numbers hosts need to track, and the Bundle adds a dedicated STR sheet to the same workbook.