Free download
Rental property tax preparation checklist
Everything a rental return needs, in the order it gets filled: documents, income, expenses line by line, depreciation, the traps that change the number, and the tie-out before you hand anything over. 50 checks, and every expense row names the Schedule E line it lands on and what proves it. Plain XLSX, no email, no signup.
- Six phases: documents, income, expenses, depreciation, the traps, the tie-out
- Every row carries its Schedule E line and the document that proves it
- Second sheet: Schedule E Part I line by line, with a column for your totals
- Status dropdown per row and a live ready counter
Educational template, not tax advice. Line numbers follow Schedule E (Form 1040), Part I.
Why the line number belongs on the checklist
Most landlord tax checklists are a list of nouns: insurance, repairs, utilities, mortgage. That gets you a pile of paper and leaves the hard part untouched, because the question at tax time is never "did I pay for insurance", it is "which of the twenty lines does this belong on, and can I prove it". So every expense row here carries three things: the item, the line it lands on, and the document that supports it. Work the sheet and you finish holding a per-line total rather than a folder. If you want to check one expense at a time instead, the Schedule E categorizer answers a single cost, and the Schedule E worksheet is where the totals go once you have them.
The five that change the number most
| The trap | What it costs you |
|---|---|
| Mortgage payment deducted whole | Principal is not deductible on any line. A lump entry overstates the deduction and loses the line 12 figure the IRS matches to Form 1098. Split it with the mortgage payment worksheet |
| A roof or HVAC sitting in repairs | Moves from line 14 to line 18 and depreciates over 27.5 years. The repair or improvement tool runs the BAR test and the safe harbors |
| Reporting the manager's net deposit as rent | Hides both the gross rent on line 3 and every expense the manager paid out of it. Report gross, deduct what they kept |
| Security deposits booked as income | A deposit is the tenant's money until you keep it. Only the kept part is income, in the year you keep it |
| A depreciation schedule that skipped a year | Depreciation is recaptured at sale whether or not you claimed it. Carry the schedule forward unbroken, or the gap costs you twice |
Cash basis, and what that means in January
Almost every individual landlord files cash basis, which settles a lot of the year-end questions. January rent paid in December is December income. Rent owed and never paid is not income at all, so there is no bad-debt deduction to take for it. An expense you charged in December is deductible in December even if the card was paid in January. Advance rent counts in the year received however many months it covers. The checklist counts income this way in phase 2, and the phase 6 tie-out is what proves it: the rent roll says units times months, the deposits say what arrived, and every difference gets a reason.
One Schedule E per property
Schedule E gives you three property columns per copy, and a portfolio of ten means four copies. That matters before tax time, not during it: a combined P&L cannot be split back into per-property columns without someone billing you for the hours. Keep the books per property all year, and the checklist is a printing job. The rental P&L template keeps that shape, and the rental chart of accounts maps your categories to the Schedule E lines one to one so nothing needs translating in April.
Depreciation is the line to start early
Phase 4 is the one that takes real time the first year and almost none afterwards, which is why it is worth doing properly once. Each property needs an in-service date, a cost basis with land split out, and every improvement on its own clock. The cost basis worksheet collects the purchase and closing figures, the depreciation schedule template carries them year by year, and the depreciation calculator checks a single property in a few seconds.
What a preparer actually wants
Two documents, per property: a profit and loss that ties to the bank, and a depreciation schedule that continues last year's. Everything in phase 6 exists to produce those two. Tax work is billed by the hour and cleanup is the expensive hour, so the difference between a folder of receipts and a pair of tied-out reports is most of the bill. Phase 5 is where that bill usually hides: improvements in repairs, unsplit mortgages, and a manager's net deposit each take a preparer real time to unwind, and none of them are visible in a shoebox.
Doing it continuously instead of in April
A checklist worked once a year is a rescue. Our bookkeeping product does the same work as the transactions land: it splits the mortgage payment, holds deposits as a liability until they are kept, keeps improvements off line 14, tags every expense to its Schedule E line, and carries the depreciation schedule forward on its own. The year-end package comes out of that, rather than out of a weekend. This sheet is the same standard, run by hand.
Frequently asked questions
What documents do I need to do taxes on a rental property?
Per property: Form 1098 from every lender, the property tax bills and what was actually disbursed, insurance invoices, twelve months of statements for every account the property touched, the closing statement for anything bought, sold or refinanced, the property manager's year-end statement, any 1099-K or 1099-MISC you received, W-9s for contractors and the 1099-NECs you filed, a mileage log, and receipts for capital items at any price. Then last year's return, which carries the depreciation schedule and any suspended passive losses forward.
What is the most commonly missed rental property deduction?
Depreciation, and it is missed in two different ways. Some owners never start it, usually because the property was converted from a home and nobody set an in-service date or a cost basis. Others start it and lose a year in a software change or a preparer switch. Both cost twice, because depreciation is recaptured at sale as allowed OR allowable: the IRS computes the recapture on what you could have claimed, not on what you did. After depreciation, the usual misses are the escrow-paid property tax and insurance hiding inside the mortgage payment, and mileage nobody logged.
Do I report the gross rent or what my property manager deposits?
Gross. Report the full rent the tenant paid on line 3, then deduct the management fee on line 11 and every other expense the manager paid out of it on its own line. Reporting the net deposit understates income and silently throws away the deductions, and it will not match the 1099 the manager files. The annual owner statement is the document that gets you from the deposit back to gross.
Is a repair or an improvement the harder call?
The improvement is, because it is the one that moves money between years. A repair keeps the property in ordinary operating condition and deducts now on line 14. An improvement is a betterment, an adaptation or a restoration, and it depreciates over 27.5 years on line 18. Test against the affected system rather than the whole building, so a $6,000 HVAC replacement is a restoration even though it is small next to the house. If you elect the de minimis safe harbor, anything at $2,500 or less per item deducts currently regardless.
How many Schedule E copies do I need for multiple properties?
One copy covers three properties, so it is the number of properties divided by three, rounded up: four properties need two copies, ten need four. Only the first copy carries the totals lines. The practical consequence comes earlier than the form: your books have to be per property all year, because a combined profit and loss cannot be split back into columns without someone spending billable hours on it.
Can I deduct a rental loss?
Sometimes, and the checklist points at the form that decides. A rental loss is passive under section 469. If you actively participate, up to $25,000 of it can offset other income, but that allowance phases out at 50 cents on the dollar starting at $100,000 of modified AGI and is gone at $150,000. What you cannot take this year is suspended on Form 8582 and carries forward, and it is deductible in full when you sell the property in a taxable sale. Real estate professionals under section 469(c)(7) are outside those limits entirely.