Small Business Tax Deduction Checklist: What Can I Write Off? (Spreadsheet + Worked Example)

You’re a sole proprietor or freelancer, tax season is coming, and you’re wondering which of last year’s purchases actually lower your bill. The short answer: anything ordinary and necessary for the business, as long as you can prove it. The real answer is the checklist below — every common write-off, the Schedule C line it lands on and the proof you need — plus a worked example showing how much money a typical owner leaves behind when the small stuff never gets logged.

Use the checklist first. Then copy the mini-template further down into any spreadsheet, or skip the setup and use the Small Business Tax Deduction Tracker, which has these categories already built in.

This is general information, not tax advice. Rules change and every business is different, so confirm specifics with a tax professional.

The ground rule: ordinary, necessary and documented

A deductible business expense is ordinary (common and accepted in your line of work) and necessary (helpful and appropriate for the business). It doesn’t have to be indispensable and it doesn’t have to be big — a $9 monthly app is as deductible as a $9,000 machine.

Three things kill a deduction:

  1. It’s personal. Mixed-use items (phone, car, home) are deductible only for the business share.
  2. It’s undocumented. You need a record showing the amount, date, payee and business purpose.
  3. It’s specifically excluded — see the “can’t write off” list below.

The small business tax deduction checklist (with Schedule C lines)

Sole proprietors and single-member LLCs report business expenses on Schedule C. Here’s what goes where, and what proof to keep.

✅ Write-off What counts Schedule C line Proof to keep
Advertising & marketing Ads, website, hosting, business cards, design, promo items 8 Invoices, ad platform receipts
Car & truck Business miles × IRS standard rate, or actual business-use costs; plus business parking and tolls 9 Mileage log: date, miles, destination, purpose
Contract labor Freelancers and subcontractors (1099-NEC where required) 11 Invoices, W-9s, payment records
Depreciation / Section 179 Computers, tools, machinery, furniture 13 Purchase receipt, date placed in service
Insurance Liability, professional/E&O, business property 15 Policy and premium statements
Interest Business loans and business credit cards 16b Lender statements
Legal & professional Accountant, bookkeeper, attorney, consultants 17 Invoices
Office expense Postage, printer ink, small office items 18 Receipts
Rent or lease Office, studio, storage, equipment rental 20a / 20b Lease, payment records
Repairs & maintenance Fixing business equipment or property 21 Invoices
Supplies Materials consumed running the business 22 Receipts
Travel Airfare, lodging, rental cars on overnight business trips 24a Receipts (lodging always), itinerary
Meals Business meals — 50% deductible 24b Receipt + who attended and why
Utilities Business-use share of phone and internet; utilities for a separate location 25 Bills + your business-use %
Wages W-2 employees (not yourself) 26 Payroll records
Other expenses Software & subscriptions, bank & processing fees, education, dues 27a (itemized in Part V) Statements, receipts
Home office Regular and exclusive business space 30 Square footage, home expense records

Two important write-offs don’t go on Schedule C even though you can claim them as a self-employed person: self-employed health insurance premiums (if you weren’t eligible for an employer plan) and half of your self-employment tax. Both are adjustments on Schedule 1, so log them, but don’t add them to your Schedule C totals.

The key numbers to know

What you can’t write off

The other half of the checklist matters just as much, because deducting the wrong thing is how a return attracts trouble:

Worked example: how much a typical owner misses

Let’s put real numbers on it. These are illustrative assumptions, not averages: Maya is a solo marketing consultant filing Schedule C, with $78,000 in gross receipts for the year.

Here’s her full year, logged category by category:

Category How it’s calculated Deductible
Advertising (line 8) Website, hosting, LinkedIn ads $1,140
Car & truck (line 9) 2,400 mi × $0.725 (Jan–Jun) + 2,600 mi × $0.76 (Jul–Dec) + $185 parking & tolls $3,901
Contract labor (line 11) Freelance designer $4,200
Insurance (line 15) Professional liability $960
Legal & professional (line 17) Accountant $1,350
Office expense (line 18) Postage, ink $420
Supplies (line 22) Client workshop materials $310
Laptop $1,899, expensed in year one (de minimis or Section 179) $1,899
Travel (line 24a) One conference trip: flight + hotel $1,880
Meals (line 24b) $640 spent × 50% $320
Utilities (line 25) Phone $85/mo × 60% business + internet $70/mo × 40% business $948
Other expenses (line 27a) Software $182/mo ($2,184) + Stripe/PayPal fees ($1,326) + course ($450) $3,960
Home office (line 30) 180 sq ft × $5 (simplified) $900
Total deductions $22,188

Net profit: $78,000 − $22,188 = $55,812.

Now the uncomfortable part. Here’s what Maya would have missed if she only tracked the “obvious” bills — the contractor, the accountant, the laptop — and never logged the quiet, recurring stuff:

Commonly missed Amount
Mileage (no log = no deduction) $3,716
Software subscriptions $2,184
Payment processing fees $1,326
Phone & internet business share $948
Home office $900
Parking & tolls $185
Total missed $9,259

What that costs her: each dollar of deduction cuts self-employment tax by about 14.1% (15.3% × 92.35%) and, assuming a 22% federal bracket, income tax by 22%. So $9,259 × roughly 36% ≈ $3,345 more tax — from expenses she actually paid. (That’s a simplified estimate: it ignores state tax, the half-SE-tax adjustment and the QBI deduction, which move the figure a little either way.)

None of those six items is exotic. They’re missed because they never arrive as one big, memorable bill — which is exactly why they need a home in a log.

Copy-ready mini template

If you want to build your own tracker, these columns and formulas are the core of it. Paste them into Excel or Google Sheets.

Expense Log columns: Date | Vendor | Description | Category | Amount | Business % | Deductible | Receipt? | Notes

Purpose Formula
Deductible amount (row 5) =E5*F5 (Business % as 100%, 60%, etc.)
Meals at 50% =IF(D5="Meals",E5*F5*0.5,E5*F5)
Total per category =SUMIF(D:D,"Software & Subscriptions",G:G)
Total deductions =SUM(G:G)
Rows missing a receipt =COUNTIFS(H:H,"No",E:E,">=75")
2026 mileage deduction (Mileage Log: Date in A, Miles in H) =SUMIFS(H:H,A:A,"<"&DATE(2026,7,1))*0.725+SUMIFS(H:H,A:A,">="&DATE(2026,7,1))*0.76
Simplified home office =MIN(OfficeSqFt,300)*5
Rough tax value of deductions =TotalDeductions*(0.9235*0.153+YourBracket)

The “missing receipt” check is the one most people skip — run it monthly and you’ll never face a February scramble for proof.

Five mistakes that cost owners deductions

  1. Mixing business and personal accounts. It turns every statement into a sorting project and makes the business share of everything harder to prove. Open a separate account and card.
  2. Reconstructing mileage in April. A log written months later is weak evidence. Log trips the day you drive them — date, miles, destination, purpose.
  3. Ignoring per-transaction fees. A few dollars per client payment adds up to four figures a year. Your processor’s annual summary is your proof.
  4. Claiming 100% of a mixed-use phone or car. Pick a defensible business percentage, write down how you got it, and apply it consistently.
  5. Treating the checklist as the system. Knowing software is deductible doesn’t help if you can’t show the $182 you paid each month. The checklist tells you what; only a running log tells you how much.

From checklist to tracker

The checklist above is what’s deductible. The spreadsheet is what actually gets those dollars onto your return. The Small Business Tax Deduction Tracker turns every category on this page into a ready-made bucket:

It works in Excel and Google Sheets, so you can log an expense from your phone the moment it hits your card.

Related guides

Featured on ReadySheetGo

Small Business Tax Deduction Tracker Spreadsheet — 7 tabs (Dashboard, Expense Log, Mileage Log, Home Office, Quarterly Taxes, Categories, Instructions) with 20 IRS deduction categories mapped to Schedule C lines and over 300 built-in formulas. Every entry rolls into a live deductions-by-category and estimated-tax-savings view. Compatible with Microsoft Excel and Google Sheets. $17.99. Instant digital download.

Frequently Asked Questions

What can a small business legally write off on taxes?

A small business can deduct any expense that is 'ordinary and necessary' for the business — common in your field and helpful to running it. That covers advertising, supplies, software, contract labor, the business share of your vehicle, phone, internet and home, business travel, 50% of business meals, professional fees, insurance, bank and payment processing fees, rent, repairs and education that maintains your current skills. The test isn't size; it's whether the expense was genuinely for the business and you can document it.

Do I need a receipt for every business expense?

You need a record of every expense you deduct, but not always a paper receipt. Bank and card statements show the amount, date and payee, and a log entry adds the business purpose. For travel, meals and gifts, IRS rules relax the documentary-receipt requirement for individual expenses under $75 — except lodging, which always needs a receipt. The safe habit is a logged entry for everything plus a photo of the receipt for anything meaningful.

What are the most overlooked small business tax deductions?

The usual misses are the business share of your phone and internet, the home office (up to $1,500 with the simplified method), payment processing fees from Stripe, PayPal or Square, small recurring software subscriptions, parking and tolls on business trips (deductible on top of the standard mileage rate), startup costs, and self-employed health insurance premiums. They get missed because they are small, automatic or never arrive as an obvious business bill.

Can I write off my car and home if I'm self-employed?

Yes, for the business-use portion only. For your car, deduct business miles at the IRS standard mileage rate (for 2026: 72.5 cents per mile from January 1 to June 30 and 76 cents from July 1 to December 31) or your actual business-use costs, backed by a mileage log. For your home, a space used regularly and exclusively for business qualifies for $5 per square foot up to 300 square feet under the simplified method, or a percentage of actual home costs under the regular method.

What can't a small business write off?

Personal expenses, commuting from home to a regular workplace, everyday clothing you could wear outside work, fines and penalties, political contributions, entertainment such as concert or sports tickets, federal income tax, and your own time or labor. Business meals are only 50% deductible, and business gifts are capped at $25 per recipient per year.

Can I deduct expenses from before my business officially started?

Often, yes, as startup costs. You can deduct up to $5,000 of startup costs in the year the business begins, reduced dollar-for-dollar once total startup costs pass $50,000, and amortize the rest over 180 months. Keep those pre-launch receipts in the same log, tagged as startup costs, so they aren't forgotten.

Can I deduct a new laptop or equipment in full the year I buy it?

Often you can. Items costing $2,500 or less per invoice or item can usually be expensed under the de minimis safe harbor election, and larger equipment can typically be deducted in the year it's placed in service using Section 179 or bonus depreciation, subject to limits. Log the purchase date, cost and business-use percentage, and let your tax preparer choose the method.

Never Miss a Tax Deduction Again

The Tax Deduction Tracker — 7 tabs, 20 IRS deduction categories mapped to Schedule C lines, mileage log, home office calculator and quarterly tax estimator. Works in Excel and Google Sheets.

View on Etsy — $17.99