Landlord Rental Income & Expense Tracker Spreadsheet

Your accountant does not want to see a shoebox of receipts. They do not want a handwritten ledger. They do not want to sort through twelve months of bank statements trying to figure out which transfers were rent deposits and which were personal. What they want — and what makes your tax preparation faster, cheaper, and more accurate — is a clean, categorised record of every dollar of rental income and every dollar of rental expense, organised by the categories that appear on IRS Schedule E.

This spreadsheet is that record. It is designed specifically for landlords, with expense categories that mirror Schedule E line items exactly. Every entry you make during the year transfers directly to the tax form at year-end. No translation required. No reconciliation needed. No forensic accounting necessary.

The secondary benefit is equally valuable: the spreadsheet is also a real-time property performance dashboard. At any point during the year, you can see your net operating income, your expense ratio, your cash flow, and how each property in your portfolio is performing relative to the others. You are not just tracking expenses — you are monitoring your investments.

Disclaimer: This tracker is provided for informational and educational purposes only. It does not constitute tax, financial, or legal advice. Tax rules for rental property income and deductions are complex and vary by situation. Consult a qualified tax professional for guidance specific to your circumstances. SpreadsheetTemplates.info is not responsible for decisions made based on the information provided.

Why Schedule E Alignment Matters#

IRS Schedule E (Supplemental Income and Loss) is the tax form that reports rental property income and expenses. It has specific line items for specific expense categories: advertising, auto and travel, cleaning and maintenance, commissions, insurance, legal and professional fees, management fees, mortgage interest, other interest, repairs, supplies, taxes, utilities, depreciation, and other expenses.

Most generic expense trackers use categories like “miscellaneous,” “office,” or “other” — which are useless at tax time because they do not map to the form. Your accountant must reclassify every entry, which costs you billable hours and increases the risk of misclassification.

This spreadsheet uses Schedule E categories as its default structure. When you record a $150 plumber invoice, it goes into “Repairs.” When you record $200 for pest control, it goes into “Cleaning and Maintenance.” When you record $1,200 for a property management fee, it goes into “Management Fees.” At year-end, each category total transfers directly to the corresponding Schedule E line. Your accountant reviews the totals, verifies a few entries, and files the return. That is the goal: zero friction between your record-keeping and your tax filing.

What the Spreadsheet Tracks#

Income Section#

For each property, the income section tracks monthly rent received (date, amount, and tenant name), late fees collected, application fees, pet fees or pet rent, laundry or parking income (if applicable), security deposit transactions (received, held, returned, or applied to damages — note that security deposits are not income unless forfeited), and other income (early lease termination fees, damage reimbursements).

The monthly summary shows total gross income per property and across all properties. A vacancy tracker records vacant unit-months, calculating your actual vacancy rate versus the budgeted rate used in your acquisition analysis.

Expense Categories (Schedule E Aligned)#

Every expense is categorised into the following Schedule E lines:

Advertising — listing fees, signage, online rental advertising, photographer for listing photos.

Auto and travel — mileage to properties for management, inspections, and maintenance (at the IRS standard mileage rate), and travel costs for out-of-area properties.

Cleaning and maintenance — cleaning between tenants, pest control, HVAC maintenance, gutter cleaning, landscaping, snow removal.

Commissions — leasing agent commissions, tenant placement fees.

Insurance — landlord insurance premiums, umbrella policy premiums allocated to rental properties.

Legal and professional fees — attorney fees (for lease drafting, evictions, entity formation), accounting and tax preparation fees allocated to rental properties.

Management fees — property management company fees (typically 8–12% of collected rent), or an allocated value for self-management time if you choose to track it.

Mortgage interest — interest portion of mortgage payments only (not principal, which is not deductible but is tracked separately for balance monitoring).

Repairs — plumbing, electrical, appliance repair, painting, drywall repair, lock changes, and all maintenance that restores the property to its existing condition (as opposed to improvements, which must be capitalised and depreciated).

Supplies — cleaning supplies, light bulbs, air filters, tools, hardware.

Taxes — property taxes, any local rental taxes or business licence fees.

Utilities — landlord-paid utilities (water, sewer, trash, electricity, gas — if included in rent or paid during vacancy).

Depreciation — the annual depreciation amount from your tax preparer’s depreciation schedule (residential rental property is depreciated over 27.5 years). This is an entry field, not a calculation — your accountant determines the depreciation amount.

Other — any rental expense not fitting the above categories, with a description field for each entry.

Per-Property Tracking#

For landlords with multiple properties, the spreadsheet tracks each property independently on its own tab. A portfolio summary tab aggregates all properties, showing total rental income across the portfolio, total expenses by category across all properties, net operating income per property and total, cash flow per property (after debt service), and the best-performing and worst-performing properties by cash flow and expense ratio.

This portfolio view is where the spreadsheet becomes an investment management tool, not just a bookkeeping tool. If one property consistently runs a 60% expense ratio while the others run 45%, the data tells you exactly which property needs attention — and the category-level detail tells you where the costs are concentrated.

Monthly Dashboard#

The top of each property tab shows a monthly summary: gross income, total expenses, net operating income, mortgage payment, and cash flow. A year-to-date running total tracks cumulative performance against budget. Traffic light indicators (green, yellow, red) flag months where expenses exceed normal ranges, providing an early warning for cost problems.

2026 Expense Trends Every Landlord Should Track#

Several cost trends in 2026 make diligent expense tracking more important than ever.

Insurance premiums are significantly higher. Landlord insurance (dwelling fire policies) has followed the same upward trajectory as homeowners insurance: up 46% since 2021 nationally. If your expense tracker still shows last year’s premium, your cash flow projection is already wrong. Update insurance costs at renewal and factor the increase into your property performance analysis.

Property taxes are rising in most markets. Municipal governments have increased assessments to reflect the home price appreciation of 2020–2024. If your property was reassessed at purchase, the current tax reflects market value. If it was not, a reassessment triggered by a sale, refinance, or routine cycle could significantly increase your tax expense. The spreadsheet tracks property taxes as a separate line so year-over-year increases are visible.

Maintenance costs are elevated. Tariff-driven increases in building materials, elevated labour costs, and supply chain friction have pushed routine maintenance and repair costs 10–15% above 2023 levels. A $200 plumber visit is now $230. A $3,000 HVAC repair is now $3,400. The spreadsheet’s category-level tracking reveals whether maintenance costs are trending above historical norms for each property.

Vacancy costs money you cannot see. A vacant unit generates zero income but still incurs fixed expenses: mortgage payment, property taxes, insurance, utilities (you still pay for water, heat, and electricity during vacancy to prevent damage), and marketing costs for the next tenant. The spreadsheet’s vacancy tracker quantifies this cost and makes it visible alongside the gross income figures — preventing the common mistake of evaluating property performance based on occupied-period income only.

How to Use the Spreadsheet#

Step 1: Set up a tab for each property. Enter the property address, acquisition date, purchase price, current mortgage balance, and monthly mortgage payment. If you self-manage, this takes 10 minutes per property.

Step 2: Record income as it arrives. Enter each rent payment on the date received. Track late payments and any additional income (fees, parking, laundry). This takes 2–5 minutes per property per month.

Step 3: Record expenses as they occur. Enter each expense on the date paid, categorised into the Schedule E line item. Keep the receipt (a photo saved to a cloud folder named by property and year is sufficient). A weekly 10–15 minute session covers most landlords’ expense volume.

Step 4: Review the monthly dashboard. At month-end, review income, expenses, and cash flow for each property. Flag any unusual expense spikes. Compare vacancy against your budget assumption.

Step 5: Hand the annual summary to your accountant. At year-end, the Schedule E summary is ready for your tax preparer. Total income and category-level expense totals transfer directly to the form. Your accountant’s time is spent reviewing and filing, not reconstructing — which means lower fees for you.

Download: Landlord Income & Expense Tracker — Excel (.xlsx)

When to Switch to Property Management Software#

The spreadsheet works well for landlords with 1–5 properties who self-manage or use a management company (which provides its own income/expense reports that you reconcile into the spreadsheet). Consider dedicated property management software when you exceed 5–10 units and the tracking volume becomes burdensome, you need online rent collection and automated late fee tracking, you need tenant screening and lease management integrated with financial tracking, you need maintenance request workflows and vendor management, or you want automated bank feed integration (similar to accounting software).

Popular options include Stessa (free for basic features — excellent for small portfolios), Buildium ($55–$174/month — full-featured for growing portfolios), AppFolio ($1.40/unit/month minimum $280 — enterprise-grade), and Rentec Direct ($45–$55/month — mid-range with good reporting).

For analysing the ROI and cash flow of properties in your portfolio, see our rental property ROI calculator. For the broader set of real estate investment tools, see our complete guide to real estate investment spreadsheet tools. And for estimating your tax liability across all income sources including rental income, see our tax estimator spreadsheet.

Frequently Asked Questions#

What is the difference between a repair and an improvement for tax purposes?

Repairs restore the property to its existing condition and are fully deductible in the year incurred (entered in the “Repairs” category). Improvements add value, extend the useful life, or adapt the property to a new use — and must be capitalised and depreciated over their useful life. Replacing a broken faucet: repair. Replacing all plumbing in a bathroom: improvement. Patching a section of roof: repair. Replacing the entire roof: improvement. When in doubt, ask your accountant — the distinction has significant tax implications.

Should I track my own time as a self-managing landlord?

The IRS does not allow landlords to deduct the value of their own labour as an expense. However, tracking your time is valuable for two reasons: it helps you calculate the true cost of self-management versus hiring a property manager (if your time is worth $50/hour and you spend 10 hours/month on management, the implicit cost is $500/month — which may make an 8% management fee look reasonable), and it supports a schedule of rental activities that could be relevant for real estate professional status (which has specific tax benefits).

How do I handle security deposits?

Security deposits are not income when received — they are a liability (you owe them back to the tenant). They become income only if forfeited (applied to unpaid rent or damages). The spreadsheet tracks deposits received, held, and returned separately from rental income. Only the forfeited portion appears in the income total.

Can I deduct my mortgage payment as an expense?

Only the interest portion of your mortgage payment is deductible. The principal portion is not an expense — it is debt repayment that builds your equity. The spreadsheet tracks the full mortgage payment for cash flow purposes but only categorises the interest portion as a Schedule E expense. Your monthly mortgage statement or amortisation schedule shows the interest/principal split.

How do I handle depreciation in the spreadsheet?

Depreciation is calculated by your tax professional based on the property’s cost basis, the land value allocation, and the 27.5-year residential rental schedule. The spreadsheet includes a depreciation line where you enter the annual amount from your accountant. Do not attempt to calculate depreciation yourself — the rules for cost basis, improvements, and partial-year calculations are complex enough that errors are costly.

I have a property managed by a management company. Do I still need this spreadsheet?

Yes, but your data entry is simpler. Your management company provides monthly owner statements showing income collected, expenses paid, and your net distribution. Enter these into the spreadsheet as they arrive — verifying the categories match Schedule E lines. The spreadsheet becomes your reconciliation tool and your year-end tax summary, ensuring the management company’s records match your own.