To total home office expenses from bank statements, pull a year of rent or mortgage interest, utilities, insurance and repair rows into one sheet, add each category up, then multiply by the share of your home used only for business. Statements give you the amounts and dates. A floor measurement and a few saved bills finish the record.
Which bank statement rows count as home office expenses?
The rows that count are the costs of keeping up and running the whole home, plus any cost spent only on the office itself. On a typical statement that means rent, mortgage payments (for the interest part), electricity, gas, water, trash, home insurance and repairs. IRS Publication 587 calls these indirect and direct expenses.
The distinction matters because the two kinds are treated differently. IRS Publication 587, Business Use of Your Home describes direct expenses as costs only for the business part of the home, such as painting or repairs inside the office, and indirect expenses as costs for keeping up and running the entire home, such as insurance, utilities and general repairs. Direct costs count in full. Indirect costs count only at the business percentage.
Rows to pull from checking and cards
- Rent, if you rent. The publication says a renter who meets the business-use rules can deduct part of the rent.
- Mortgage payments, but only the interest and property tax portions, which come from your lender's year-end statement, not from the payment row.
- Utilities: electricity, gas, water, sewer and trash.
- Renter's or homeowner's insurance.
- Repairs to the whole home, such as a furnace service.
- Repairs or painting inside the office only, which are direct expenses.
Rows that look relevant but are not home costs
Office furniture, a printer and software are business expenses, but they are not costs of the home. They go on the business side of your return on their own lines. Keep them on a separate tab so they are not multiplied by a home percentage by mistake. Telephone costs are a special case covered in the phone section of Publication 587. The basic charge for the first landline into the home is personal, while business long-distance calls and a second business-only line are business costs. A lawn service or a remodel of the kitchen has no connection to the office and stays out.
The same row-by-row habit works for other deductions too. A charity gift paid by card can sometimes be supported by the statement row, with limits explained in when a bank statement works as proof of a donation.
Business-use percentage for a home office: the square-foot share
The business-use percentage is the office floor area divided by the home's total floor area. Publication 587 describes this area method directly: divide the area used for business by the total area of the home. A 120 square foot office in a 1,200 square foot apartment gives 10%, and that 10% applies to every indirect expense.
Measure once and write the numbers down with the date. Length times width gives each room's area. Use the same rule for both numbers. If you measure the office wall to wall, measure the home wall to wall too.
The space has to qualify first
A percentage only matters if the space qualifies. Publication 587 sets out an exclusive use test, meaning the area is used only for the business, and a regular use test, where incidental or occasional business use does not count. A corner of the living room where the family also watches films fails the exclusive use test. A spare room used only for client work passes. The publication has exceptions, such as for daycare providers and inventory storage, so read the relevant part if either applies to you.
When the percentage changes during the year
If you moved, or turned a bedroom into an office in July, the percentage is not the same for all twelve months. Split the year. Total the statement rows for the months the office existed, and apply the percentage only to those months. A month column on your sheet makes this a filter rather than a recount.
Totaling home office rows: a worked year of rent and utilities
The arithmetic is a sum per category followed by one multiplication. With twelve months of rows in a sheet and a category on each, a SUMIFS per category gives the yearly totals. Multiply each indirect total by the business percentage, add direct costs in full, and the result is the actual expenses figure for the year.
The example below uses made-up numbers for a renter with a 120 square foot office in a 1,200 square foot apartment, so the business share is 10%.
| Category | Statement rows | Yearly total | Type | Business share | Counted |
|---|---|---|---|---|---|
| Rent | 12 | 21,600.00 | Indirect | 10% | 2,160.00 |
| Electricity | 12 | 1,140.00 | Indirect | 10% | 114.00 |
| Gas | 12 | 720.00 | Indirect | 10% | 72.00 |
| Water and trash | 4 | 360.00 | Indirect | 10% | 36.00 |
| Renter's insurance | 1 | 216.00 | Indirect | 10% | 21.60 |
| Painting the office | 1 | 180.00 | Direct | 100% | 180.00 |
| Total | 42 | 24,216.00 | 2,583.60 |
Two habits keep this table honest. Keep the row count next to each total, so a missing month stands out: eleven rent rows means a statement is missing or a payment went through another account. Keep the direct costs on their own line, so nobody applies the 10% to them by accident.
Building the sheet from statements
The rows have to get out of the PDFs first. A CSV download from online banking, if your bank offers one for a date range, is the quickest route. Otherwise a converter turns each monthly PDF into rows with a date, description and amount. CheapBankConvert is getting ready to open with one-time pricing per statement and free previews of the first two pages, which suits a once-a-year job like this. If you convert files away from home, read about uploading a bank statement on public WiFi first.
Simplified home office method or actual expenses: which fits your statements?
The simplified method skips the statement totals entirely. Publication 587 sets it at $5 per square foot of qualifying office space, up to 300 square feet. The actual expenses method uses the totals you built from your statements. Run both and compare, because the bigger figure depends on your rent and floor area, not on a rule of thumb.
For the example above, the simplified method gives 120 square feet times $5, which is $600. The actual expenses method gave $2,583.60. In that example the statements are worth the effort. A homeowner in a large house with low utility bills and a small office could see the opposite result.
What the simplified method gives up
Under the simplified method, Publication 587 says you cannot deduct the home expenses themselves, such as utilities and insurance, for the business use of the home. You still need records proving the space qualifies, but you do not need the statement totals for the home costs. That makes it a fair choice if your statements are incomplete or your office is small.
A quick comparison
| Question | Simplified method | Actual expenses |
|---|---|---|
| What you multiply | Office square feet by $5 | Home costs by business percentage |
| Ceiling | 300 square feet | Limited by business income |
| Statement totals needed | No | Yes |
| Best fit | Small office, thin records | High rent or bills, full statements |
Publication 587 says Schedule C filers use Form 8829 to figure the deduction under actual expenses. It also limits the deduction for some expenses to the gross income from the business use of the home, so a business with a small profit may not be able to use the full figure in one year.
Home office edge case: employees, shared rooms and business losses
The home office deduction is for people who work for themselves. The decision chart in Publication 587 asks whether you use the space as an employee, and a yes leads to no deduction. If you work from home only for an employer, tidy statement totals will not produce a deduction on your own return.
Several other situations call for care rather than a quick calculation.
- Shared rooms. A guest room that doubles as the office fails the exclusive use test. A desk in a bedroom does too.
- Two businesses, one office. Splitting one room between two lines of work raises questions the area method alone does not answer. Ask a preparer before you divide it.
- A business at a loss. The gross income limit can stop part of the deduction for the year, so a large actual expenses figure may not all count. Read that section of Publication 587 before you rely on the full number.
- Mortgage payments. The payment row on the statement includes principal, which is not a deduction. Use the lender's year-end figures for interest and taxes instead.
Other deductions that share the same sheet
Once you have a year of rows in one sheet, the same file helps with other tax jobs. Medical payments are a common one, because they sit on cards and checking alongside everything else. The method for tracking medical expenses for taxes from statements uses the same category column and a filter.
Home office records to keep beside the statement totals
The statements prove what you paid, but they do not prove the office existed or how big it was. Publication 587 says your records must show the part of the home used for business, that you used it exclusively and regularly for business, and the expenses and depreciation for that part. It does not require a particular recordkeeping method.
Keep these with the year's tax folder:
- The statement PDFs for every month, and the sheet built from them.
- The bills for utilities and insurance, which show the service address and period.
- A floor sketch with the office and home measurements and the date measured.
- A photo of the office showing it set up for work only.
- Your lease, or the lender's year-end mortgage statement.
- Receipts for any repair made only to the office.
- Records of the home's cost and improvements, if you own it, for depreciation.
Publication 587 says to keep records for as long as they matter for any tax law, usually at least three years from filing. For a homeowner claiming depreciation, the purchase and improvement records matter until the home is sold, which can be many years later. Store the folder somewhere you will still find it then.