A rental property that collects $1,800/month in rent and costs $1,400/month in mortgage, taxes, insurance, and maintenance generates $400/month in cash flow. But if you're not tracking expenses against the right tax categories, you're leaving deductions on the table and overpaying the IRS by hundreds or thousands per property per year.
The IRS reports rental income and expenses on Schedule E (Form 1040). Every expense category on that form has a corresponding line. If your tracking system doesn't match those lines, you're creating translation work at tax time and increasing the odds of missed deductions.
Each rental property gets its own tab. This isn't optional. The IRS requires separate reporting for each property on Schedule E, and your lender will want property-level P&L if you ever refinance or buy another property. Mixing properties into one ledger creates a mess that costs real money to untangle.
Each property tab tracks two things: monthly income and monthly expenses. Income is straightforward. Expenses need the right categories.
Gross rental income includes more than the monthly check from your tenant. Track each source separately:
Vacancy tracking matters: The national residential vacancy rate was 6.6% in Q4 2025 (U.S. Census Bureau). If your property is vacant 2 months per year, that's a 16.7% vacancy rate. The difference between 5% and 15% vacancy on a $1,800/month rental is $2,160/year in lost income.
Schedule E lines 5-19 define the categories. Use these exact categories in your spreadsheet and tax time becomes a 15-minute data transfer.
| Schedule E Line | Category | Examples |
|---|---|---|
| Line 5 | Advertising | Zillow listing, yard sign, photos |
| Line 6 | Auto and Travel | Mileage to property ($0.70/mile in 2026) |
| Line 7 | Cleaning & Maintenance | Turnover cleaning, lawn care, HVAC filter service |
| Line 9 | Insurance | Landlord policy, umbrella policy |
| Line 10 | Legal & Professional | Attorney fees, CPA, lease review |
| Line 11 | Management Fees | 8-10% of gross rent if using a PM company |
| Line 12 | Mortgage Interest | Interest portion only (not principal) |
| Line 14 | Repairs | Plumbing fixes, appliance repair, drywall patch |
| Line 16 | Taxes | Property tax, any local assessments |
| Line 17 | Utilities | Water, sewer, trash (if landlord-paid) |
| Line 18 | Depreciation | Cost basis / 27.5 years (calculated annually) |
This is where landlords lose the most money at tax time. A repair is fully deductible in the year you pay for it. An improvement must be capitalized and depreciated over 27.5 years. The dollar difference is massive.
Replacing a broken garbage disposal: repair. Deduct the full $350 this year. Replacing all the kitchen cabinets: improvement. Depreciate the $8,000 cost over 27.5 years, deducting $291/year.
The IRS safe harbor for routine maintenance says you can deduct amounts under $2,500 per item as expenses (the de minimis safe harbor election). Your spreadsheet should flag any single expense over $2,500 for review.
For a $200,000 property where the land is assessed at $40,000: ($200,000 - $40,000) / 27.5 = $5,818/year deduction. That's real tax savings you miss if you don't track it.
Your spreadsheet needs to show both numbers, and they will be different.
Cash flow is what hits your bank account: rent collected minus all cash expenses (mortgage payment including principal, repairs, insurance, taxes, management). This tells you if the property puts money in your pocket each month.
Tax profit (Schedule E net income) is rent collected minus deductible expenses including depreciation but excluding mortgage principal. This is what you owe taxes on.
A property can have positive cash flow and a tax loss in the same year, because depreciation is a non-cash deduction. That's the power of real estate tax treatment. But you only capture it if your spreadsheet calculates both numbers.
Once a month, spend 15 minutes per property:
Skip this for 3-4 months and you're reconstructing transactions from bank statements. That's the work you're trying to avoid.
Shopfolio's Rental Cash Flow Tracker handles income, expenses, depreciation, cash flow, and tax profit across multiple properties. $29, works in Google Sheets and Excel.
See the Rental TrackerWhat expenses can landlords deduct on Schedule E?
Schedule E (Form 1040) allows deductions for: advertising, auto and travel, cleaning and maintenance, commissions, insurance, legal and professional fees, management fees, mortgage interest, other interest, repairs, supplies, taxes (property), utilities, and depreciation. Each property gets its own column on Schedule E. The most commonly missed deduction is depreciation: residential rental property is depreciated over 27.5 years using the straight-line method, starting when the property is placed in service.
Should I use a spreadsheet or property management software to track rental income?
For 1-5 properties, a spreadsheet gives you more control and costs nothing. Property management software like Buildium ($55/month) or AppFolio ($1.40/unit/month, $280 minimum) makes sense once you're managing 10+ units or need tenant portals for online rent payment. The key advantage of a spreadsheet is that your categories map directly to Schedule E lines, so tax prep is a data transfer, not a translation exercise.
How do I calculate net cash flow for a rental property?
Net Cash Flow = Gross Rent Collected - Operating Expenses - Debt Service (mortgage principal + interest). Operating expenses include property taxes, insurance, repairs, management fees, vacancy costs, and HOA dues. Depreciation is NOT included in cash flow because it's a non-cash deduction. A common mistake is confusing accounting profit (which includes depreciation) with cash flow (which doesn't).