First page of the Home Office Deduction WorksheetExcel workbook preview

IRS records and US tax

Home Office Deduction Worksheet

Home office deduction worksheet in Excel: regular method laid out like Form 8829 and simplified method from Pub 587, with an expense log and method comparison.

Excel workbook · 17 KB Built on free official texts

3 free downloads per account. Just your email and a 6-digit code.

Need more than 3? Every template for $249, once. Lifetime access, including the templates we add later. See pricing

About this template

A home office deduction worksheet shows how the deduction for business use of a home was calculated: the business percentage, which expenses were included, the gross income limit and depreciation. A sole proprietor or bookkeeper needs it when preparing Schedule C and Form 8829, and again when a preparer or the IRS asks how the figure was reached, often years after the receipts were filed away.

The workbook follows IRS Publication 587 for 2025 returns. The regular method sheet mirrors Form 8829 line by line, from the business percentage through allowable operating expenses, depreciation of the home and carryovers. The simplified method sheet applies the rate per square foot to the allowable area. A comparison sheet shows which method gives more on your figures, and every number is a live formula.

Who it is for

The sole proprietor or bookkeeper preparing the year's return who has to show how the home office deduction was worked out.

What is inside

  • Inputs sheet with the Pub 587 use tests, areas, income limit, home basis, land and carryovers
  • Expense log with direct and indirect classification and 11 worked entries plus 20 blank rows
  • Regular method sheet following Form 8829 (2025) line numbers, including depreciation and carryovers
  • Simplified method sheet: USD 5 per square foot up to 300 square feet (Pub 587, 2025), limited to the gross income limit
  • Comparison sheet that nets out mortgage interest and taxes Schedule A would allow anyway
  • Every result is a live formula off yellow input cells
  • Worked example: a 240 square foot office in an 1,850 square foot home

How to use it

Answer the use questions on the Inputs sheet first, then enter each home expense in the Expense log.

Files

  • XLSXhome-office-deduction-worksheet.xlsx17 KB

Opens in Microsoft Word or Excel, Google Docs or Sheets, and LibreOffice. Built on free, official texts that anyone can read: laws, regulations, standards and guidance published by public bodies. A template to adapt, not legal, tax or accounting advice.

Questions about this template

What is the simplified method for the home office deduction?

Publication 587 for 2025 returns allows USD 5 per square foot of the area used for business, up to 300 square feet, limited to the gross income from the business use of the home. There is no depreciation and no carryover under this method. Check the current edition for the rate.

Can an employee claim the home office deduction?

Publication 587 says no deduction is allowed for use of a home as an employee. The deduction applies to self-employed people and others who meet the exclusive use, regular use and principal place of business tests. The Inputs sheet asks these questions and shows the result.

Which method gives the larger deduction?

It depends on the size of the office, the home's costs and whether you itemize. The Comparison sheet takes the regular method result, removes the mortgage interest and taxes that Schedule A would allow anyway if you itemize, and compares it with the simplified method.