Free Home Office Deduction Worksheet (Excel Calculator, Fillable PDF, Word)

What is on the home office deduction worksheet

Office and home square footage

Measure wall to wall. The home total is all finished living space (most people use the figure from the lease, appraisal or county record, checked against a tape). Business use % = office ÷ home; the IRS also accepts rooms ÷ rooms if the rooms are similar in size.

Simplified method

$5 per square foot of office, maximum 300 square feet, so at most $1,500 a year, prorated for months of use. No expense records needed beyond the measurement; you still deduct mortgage interest and property tax in full on Schedule A if you itemize, and there is no depreciation to recapture later.

Indirect expenses

Whole-home costs: rent or mortgage interest, property tax, insurance, utilities, general repairs, HOA. Multiply by the business percentage.

Direct expenses

Costs for the office alone: painting the room, a built-in desk, repairing the office window. Deductible in full. Furniture and equipment are not home office expenses; they are deducted or depreciated separately as business property.

Depreciation

For owners using the actual method, the business share of the building (not land) is depreciated over 39 years (2.564% a year after the first). It adds to the deduction now and is recaptured as taxable gain when the home is sold, even if you never claimed it, which is why some owners choose the simplified method.

Income limitation

The deduction cannot exceed the business's net profit before the deduction. Under the actual method, the excess carries forward to future years (Form 8829 line 43); under the simplified method it is lost.

Regular and exclusive use

The space must be used only for business, regularly. A desk in the corner of a bedroom qualifies if that area is used only for work; a guest room that doubles as an office does not. Two exceptions: inventory or sample storage, and licensed daycare.

Principal place of business

Met if you perform administrative or management tasks there and have no other fixed location where you do substantial administrative work. A plumber who does billing at home and works at job sites qualifies; a salaried employee working from home does not (2018-2025).

Which method is better?

Run the comparison sheet; it takes ten minutes. As a rule, the simplified method wins for small offices in inexpensive homes, for renters with low rent, and for owners who plan to sell soon and want no depreciation recapture. The actual method wins when housing costs are high relative to the office size: a 150 sq ft office in a $2,350-a-month rental produces about $4,490 under actual expenses against $750 simplified, as the sample shows. Homeowners with large mortgages and property taxes also usually do better with actual expenses, provided they're comfortable with the depreciation recapture at sale. You can switch methods from year to year (with depreciation rules on switching back), so the comparison is worth repeating annually.

How to complete the worksheet

1. Start with the qualification sheet. If the exclusive-use test fails, stop: the deduction is not available and the fix is to dedicate the space.
2. Measure every room and the office, record them, and photograph the office on a dated phone.
3. On the comparison sheet enter office and home square footage and months of use. Excel gives the business percentage and the simplified deduction.
4. Enter the year's whole-home expenses from statements (rent or mortgage interest, taxes, insurance, utilities, repairs) and any direct expenses. Excel gives the actual-method deduction and flags the larger.
5. Owners taking the actual method: complete the Form 8829 sheet with basis, land value and depreciation rate, and check the income limit and carryover.
6. Give the chosen figure to your preparer or enter it on Schedule C line 30 (simplified) or via Form 8829 (actual). Keep this worksheet and the evidence for at least three years after filing; seven is safer for depreciation.

What is not a home office expense

• Furniture, computers, printers and phones: deducted as business equipment (often in full under Section 179 or de minimis rules), not as part of the home office.
• A dedicated business phone line or business-only internet: 100% deductible as a utility on Schedule C, not prorated.
• Lawn care, landscaping and exterior painting: generally not deductible, unless you meet clients at home and the IRS accepts them as indirect (rare).
• The first phone line into the home: never deductible.
• Mortgage principal: not an expense; only interest, taxes and depreciation count.

Is the home office deduction an audit risk?

Less than its reputation suggests. The deduction was simplified in 2013 precisely to encourage legitimate claims, and the IRS's stated concern is exclusive use, not the deduction itself. What draws questions is a business percentage that looks implausible (40% of a family home as "office"), a loss created or enlarged by the deduction in a business with little revenue, or a claim by a W-2 employee. A measured, photographed, exclusively used space with expenses tied to statements is as defensible as any other business deduction. The qualification sheet exists so that the file answers the questions before they're asked.

Editing the Excel versions

In Excel the business percentage, simplified deduction, prorated indirect expenses, depreciation and the income-limit arithmetic are formulas; enter measurements and statement totals and read the result. Change the $5 rate or the 300 sq ft cap if the IRS adjusts them. Collect the year's figures from the business expense tracker, carry the deduction into the P&L, and tick it off on the tax document checklist.

Questions

Can W-2 employees deduct a home office?

Not on their federal return for tax years 2018 through 2025; the Tax Cuts and Jobs Act suspended unreimbursed employee expenses. Self-employed people, partners and statutory employees can. A few states still allow it on the state return.

How much is the simplified home office deduction?

$5 per square foot of office space, up to 300 square feet, so a maximum of $1,500 per year, prorated if you used the office for part of the year. No depreciation and no expense records beyond the measurement.

Can I claim a home office if I also work somewhere else?

Yes, if the home office is where you do your administrative and management work and you've no other fixed location where you do substantial amounts of it. Meeting clients at home regularly or using a separate structure also qualifies.

Does my office have to be a separate room?

No. A clearly defined area used exclusively and regularly for business qualifies, even without walls. What fails is mixed use of the same space.

What happens when I sell the house?

Depreciation claimed (or allowable) under the actual method is recaptured as gain taxed at up to 25%, and that part cannot be excluded under the home-sale exclusion. The simplified method involves no depreciation, so nothing to recapture. If the office is within the home (not a separate structure), the rest of the gain still qualifies for the exclusion.