A Schedule E Excel template for rental income and expenses works best when its columns match the form line by line, with a summary tab pulling totals from one tab per property. Build it that way and filing becomes a transfer of verified totals rather than a reconstruction from receipts. Schedule E is where you report rental real estate income, royalties, and your share of income or loss from partnerships, S corporations, estates, and trusts, so the workbook has to accommodate all of those if they apply to you.1Internal Revenue Service. About Schedule E (Form 1040), Supplemental Income and Loss
How to Structure the Workbook
Start with a summary tab as the first sheet. This is the page you’ll actually copy from at filing time. It should pull totals from each property tab and each K-1 entity tab using cell references, never retyped numbers, so that a correction anywhere in the workbook flows through automatically.
Give every rental property its own tab. Schedule E requires a property-by-property breakdown, so mixing two properties on one sheet defeats the purpose.2Internal Revenue Service. Schedule E (Form 1040) – Supplemental Income and Loss At the top of each property tab, put the physical address, the number of days rented at fair market value, and the number of days used personally. Those two day counts affect how expenses get allocated and whether some deductions apply at all.
Within a property tab, structure the transactions chronologically with one row per entry. The core columns are date, payee or income source, category, amount, and payment method. Set the category column as a dropdown list matching Schedule E’s expense lines, which prevents typos and makes filtering trivial. At the bottom of the sheet, a SUM formula for each category delivers the totals that map straight to the form.
Columns That Match Schedule E’s Expense Lines
The category dropdown should contain exactly the line items Schedule E uses. Anything else forces you to reallocate at filing time.
- Advertising: listing fees, online platform charges, signage
- Auto and travel: mileage or actual vehicle costs for property-related trips
- Cleaning and maintenance: routine upkeep between tenants or during the lease
- Insurance: landlord policies, liability coverage, flood insurance
- Legal and professional fees: attorney costs, accountant fees, eviction filings
- Management fees: payments to a property management company
- Mortgage interest paid to banks or other lenders
- Other interest on loans used for the property that aren’t traditional mortgages
- Repairs to restore broken items to working condition
- Supplies such as cleaning products, light bulbs, small hardware
- Taxes: real estate taxes and local assessments
- Utilities you pay as landlord: water, electric, gas, trash removal
- Depreciation, which is tracked on a separate tab
For income rows, track gross rents received each month and any royalty payments separately. Do not net expenses against income inside the workbook; Schedule E wants gross figures on each side.
A Separate Tab for Depreciation
Depreciation belongs on its own tab because the math is unlike the other expenses. Residential rental buildings are depreciated over 27.5 years using the straight-line method and a mid-month convention, so the first year gives you only a partial deduction based on the month the property was placed in service.3Internal Revenue Service. Publication 527 (2025), Residential Rental Property Land is never depreciated, so your purchase price has to be split between building and land, and most taxpayers use the property tax assessment ratio to do it.
List each depreciable asset on its own row: the building, appliances, carpeting, fencing, and any capital improvements added after purchase. Each has its own recovery period and its own placed-in-service date.4Office of the Law Revision Counsel. 26 USC 168 – Accelerated Cost Recovery System Include columns for cost basis, placed-in-service date, recovery period, current-year depreciation, and accumulated depreciation. The accumulated column is the safeguard that keeps you from claiming more than the asset’s cost basis, which is easy to overshoot on older properties.
Add one more column: a flag for de minimis safe harbor items. The safe harbor lets you immediately deduct items costing $2,500 or less per invoice, or $5,000 if you have audited financial statements, rather than capitalizing and depreciating them.5Internal Revenue Service. Increase in De Minimis Safe Harbor Limit for Taxpayers Without an Applicable Financial Statement An $1,800 dishwasher replacement can be expensed in full the year you install it. The election is made annually on your return, so flagging these items in your template means you know exactly what to elect.
A Mileage Log Tab
Vehicle deductions require contemporaneous records, and a tab in your workbook is a reasonable place to keep them. Include columns for date, starting location, destination, purpose of the trip, and miles driven. Trips to the property for maintenance, tenant showings, and supply pickups qualify. Commuting to an unrelated full-time job does not.
Decide up front whether you’re using the standard mileage rate or actual expenses. For 2026 the standard mileage rate is 72.5 cents per mile.6Internal Revenue Service. IRS Sets 2026 Business Standard Mileage Rate at 72.5 Cents Per Mile, Up 2.5 Cents If you own the vehicle and want to use this rate, you must choose it in the first year the vehicle is available for rental-related use. For a leased vehicle, the choice is locked in for the entire lease. If you go with actual expenses instead, add columns for gas, insurance, maintenance, and vehicle depreciation, and apply the business-use percentage.
A Contractor Payment Tracker
If you pay an unincorporated contractor $2,000 or more during the tax year for services related to your rental, you have to file Form 1099-NEC. The threshold rose from $600 to $2,000 for payments made in 2026 and will be indexed for inflation. Plumbing, electrical, landscaping, and property management performed by individuals or unincorporated businesses all count.
Build a contractor tab with columns for payee name, address, tax identification number, cumulative amount paid during the year, and a yes/no column for whether a W-9 is on file. Sorting by cumulative paid shows you instantly who has crossed the $2,000 line. The 1099-NEC filing deadline is January 31 of the following year.7Internal Revenue Service. Publication 1099 (2026), General Instructions for Certain Information Returns Missing it costs $60 per form within 30 days, $130 per form through August 1, and $340 per form after that, with intentional disregard raising the penalty to $680 per form with no cap.8Internal Revenue Service. Information Return Penalties
Tracking Personal-Use Days
If you rent out a home you also use as a personal residence for fewer than 15 days during the year, you don’t report the rental income at all, and you also cannot deduct the rental-related expenses tied to those days.9Office of the Law Revision Counsel. 26 USC 280A – Disallowance of Certain Expenses in Connection With Business Use of Home, Rental of Vacation Homes, Etc. Cross 14 rental days and the full rental income and expense rules take effect, with allocation between personal and rental use required.
For any property you also live in or vacation at, add two counter cells at the top of the property tab: rental days and personal-use days. Update them as bookings and stays happen. A running count in the workbook is what prevents the surprise of stumbling past 14 without noticing.
A Column for Suspended Loss Carryforwards
Rental real estate is a passive activity for most taxpayers, so rental losses generally cannot offset wages or other active income. Excess losses are suspended and carried forward to future years with passive income, or until you sell the property in a fully taxable transaction.
Active participants get a partial exception: up to $25,000 in rental losses can be deducted against non-passive income, phasing out at 50 cents per dollar of modified adjusted gross income above $100,000 and disappearing entirely at $150,000.10Office of the Law Revision Counsel. 26 USC 469 – Passive Activity Losses and Credits Limited Losses limited in a given year get reported on Form 8582, which feeds back into Schedule E.11Internal Revenue Service. Publication 925 – Passive Activity and At-Risk Rules
Put a cumulative suspended loss column on each property tab, updated every year. When you eventually sell, those suspended losses become fully deductible against the gain, and a workbook that has tracked them cleanly year after year is the difference between claiming them and losing them.
A Tab for K-1 Entities
Parts II and III of Schedule E work differently from Part I. You are not entering individual expense lines; you are transferring figures from Schedule K-1 documents issued by each partnership, S corporation, estate, or trust you have an interest in. The IRS matches those figures against what the entity reported, so exact agreement matters.2Internal Revenue Service. Schedule E (Form 1040) – Supplemental Income and Loss
Create a K-1 tab listing each entity’s name, EIN, your ownership percentage, and columns for passive income, passive loss, nonpassive income, and nonpassive loss. Enter figures as K-1s arrive and let them roll up to the summary tab. If a corrected K-1 arrives after you’ve already filed, you can see at a glance what changed and decide whether an amended return is needed.
An Hours Log for the 199A Safe Harbor
If you want your rental to qualify for the Section 199A qualified business income deduction under the IRS safe harbor, the rental has to reach 250 hours of rental services performed per year, with separate books and records and contemporaneous time logs identifying who performed each service and when. The workbook is the natural place to keep those logs. Add a tab with columns for date, description of service, person performing it, and hours spent. This is documentation that has to exist before the return is filed, not reconstructed afterward.
A Quarterly Estimated Tax Tab
Rental income has no withholding, so quarterly estimated payments are usually required. The IRS expects estimated payments if you’ll owe $1,000 or more when you file.12Internal Revenue Service. Estimated Taxes Deadlines fall in April, June, September, and January of the following year.
A quarterly summary tab should show cumulative net rental income, estimated tax owed, and payments made to date. Safe harbor from the underpayment penalty comes from paying at least 90 percent of your current-year tax liability, or 100 percent of the prior year’s tax, rising to 110 percent if your AGI exceeded $150,000.13Internal Revenue Service. Underpayment of Estimated Tax by Individuals Penalty For seasonal rentals, the annualized income installment method allows payments to be weighted toward higher-income quarters.
Reconciling Before You File
Before the summary totals move onto your return, reconcile each property’s income against bank deposits and each expense total against bank and credit card statements. This is the step that catches missed entries and duplicates, and it turns the workbook into an audit trail rather than a working document.
Several third-party providers sell downloadable Schedule E templates with the basic headers already built. They’re fine starting points, but verify that the expense categories match the current Schedule E and add the tabs described above: depreciation, mileage, contractor payments, personal-use days, suspended losses, K-1s, 199A hours, and quarterly estimates. Generic templates rarely cover all of them.
Once reconciled, transfer the summary figures into your tax software. Most e-filing systems accept direct entry into Schedule E fields, and when your columns already match the form’s line items the transfer is mechanical. Electronic returns are typically acknowledged by the IRS within 48 hours.14Internal Revenue Service. Form 9325 – Acknowledgement and General Information for Taxpayers Who File Returns Electronically