Copy link
If you want an Excel spreadsheet for business expenses that does more than hold a list, here’s a free one I built. You don’t have to hand over an email to get it. You copy it, type one row per receipt, and it fills in the Schedule C tax line and the deductible amount for you. No formulas to write, no categories to invent.
If you would rather keep it on paper, the printable business expense tracker maps every line to the same Schedule C categories.
That last part is where most expense templates leave money on the table. A blank Excel sheet lets you type “gas,” “fuel,” and “Shell” into three rows, and at tax time those look like three small costs instead of one real deduction. This template locks every category to the line it belongs on, adds up the total, and hands your accountant a clean page. I’ll show you the data behind that further down, because it surprised me.
I run Shoeboxed, a receipt-scanning company. We’ve sorted business receipts for 20 years, so I built this template around what shows up in the pile, not around a generic budget grid. If you’ve got employees and payroll to track, you want the small business expense spreadsheet instead, which adds income and a profit-and-loss. This page is for tracking what your business spends, in Excel, and getting every dollar onto the right tax line.
Food truck owners get their own version too: a food truck expense spreadsheet with a startup-cost worksheet built in.
And if your work is solo 1099 contracting rather than running a shop, grab the template built for 1099 contractors instead.
Get the Excel template
Download the Excel file (.xlsx) →
Prefer to work in the cloud? Copy it to your Google Drive instead. Tap that link, sign in to Google, and choose Make a copy, and the sheet is yours to type in. Or print the PDF and fill it in by hand. It opens in Excel, Numbers, or Google Sheets, and nothing you type touches my copy.
You get four ready-to-use spreadsheets in one workbook:
- Expense Tracker. One row per receipt. Pick a category from the dropdown and the sheet fills in the Schedule C line and the deductible amount, and cuts business meals to the 50% the IRS allows.
- Schedule C Summary. Your totals rolled up by tax line, the one page you hand your accountant.
- Home Office Log. Both ways to figure the home office deduction, the simple one and the one that usually pays more.
- Mileage Log. Four fields per trip, and the sheet does the per-mile math for you.
Plus a bonus tab with 25% off Shoeboxed, in case you’d like us to do the typing.
If you only do one thing on this page, download the template. The rest of this article explains the rules built into it, because two of them put real money back in your pocket.
What 2.5 million receipts say about the columns you need
Before I built the columns, I looked at our own data. We’ve processed 2,506,000 receipts from 12,407 small businesses since the start of 2024, so I pulled what those businesses spend money on. These are our customers, not a national survey, but it’s a real pile of receipts.
A handful of categories cover most of what a business spends. Meals, general purchases, and fuel lead, then travel, office supplies, software, professional fees, and mileage. That’s why the template ships with those exact categories instead of a blank slate. You’re not guessing what to track, because the columns already match the way money leaves a business.
Why a blank Excel sheet quietly loses you money
Here’s the part that surprised me. Even inside an app where tagging a receipt is one tap, 28.7% of those 2.5 million receipts showed up with no category at all. In a blank Excel file, where you type the category yourself every time, it’s worse.
And it’s not just blank rows. When people type their own categories, the same expense gets spelled four ways. In our data, the cost of the goods a business resells showed up as “Cost of Goods Sold,” “COGS,” “Cost of Goods,” and “Purchases Cost of Goods,” all at once. We even have a few thousand receipts filed under “Cash Reciepts,” typo and all.
Each spelling looks like a small, separate cost. Add them up under one name and it’s one of the biggest line items on the return.
That’s the quiet leak in a do-it-yourself spreadsheet. Your biggest deduction gets scattered across four rows, none of them big enough to notice, and the total you hand your accountant comes out low. So this template doesn’t let you free-type the category. You pick it from a dropdown, the spelling stays the same every time, and every dollar of the same expense stacks in one place. That single change turns a list into a deduction you can defend.
Every business expense, mapped to its Schedule C line
Most templates list your costs but never tell you where each one goes on the tax form. The dropdown in this template does it for you, and so does the table below. You don’t have to memorize any of it. The sheet fills in the line, and this is here so you can see where your money lands.
| What you spent money on | Examples | Schedule C line |
|---|---|---|
| Advertising | Ads, your website, signage, business cards | Line 8 |
| Car and truck | Business miles (logged on the Mileage Log tab) | Line 9 |
| Commissions and fees | Sales commissions, referral fees you pay out | Line 10 |
| Contract labor | A 1099 subcontractor, an installer, a freelancer you paid | Line 11 |
| Depreciation and Section 179 | Machinery, computers, big gear (often deductible in full the first year) | Line 13 |
| Insurance | Liability, property, workers comp | Line 15 |
| Interest | Interest on a business loan or line of credit | Line 16 |
| Legal and professional | Your accountant, a lawyer, a bookkeeper | Line 17 |
| Office expense | Printing, postage, software, small office costs | Line 18 |
| Rent or lease | Your shop, warehouse, or rented equipment | Line 20 |
| Repairs and maintenance | Fixing the gear and the space you work in | Line 21 |
| Supplies | Materials you use up doing the work | Line 22 |
| Taxes and licenses | Business license, permits, payroll taxes | Line 23 |
| Travel | Flights, hotels, out-of-town work trips | Line 24a |
| Meals | Business meals, deductible at 50% | Line 24b |
| Utilities and phone | Power, water, business phone and internet | Line 25 |
| Wages | What you pay W-2 employees | Line 26 |
| Other expenses | Bank and card fees, dues, anything that doesn't fit above | Line 27b |
| Home office | The room you run the business from (logged on the Home Office Log tab) | Line 30 |
Two of these are worth a gut check. If you use a phone, internet, or a vehicle for both work and your own life, deduct only the business share, not the whole bill. That’s what the Business % column is for. Put 80% next to a phone you use for both, and the sheet deducts 80% of the bill. For a vehicle, the business share is your business miles divided by all the miles you drive in the year.
The other one is big-ticket gear. You can usually deduct a computer, a machine, or other equipment in full the year you buy it, instead of in pieces over many years. That’s the Section 179 write-off, and it’s a real cash boost the year you invest. Your accountant can confirm it fits your situation.
And if tax prep is the whole reason you're building a spreadsheet, the tax expense spreadsheet version comes with a Deduction Finder tab that walks every write-off.
The two deductions that never arrive as a receipt
Two of the biggest deductions a business owner can take never show up as a receipt, so they’re the easiest to forget. The template gives each one its own tab.
The home office is the one most owners skip, usually because they’ve heard it’s an audit magnet. That story is stale. The IRS now builds a simplified method right into the form. What keeps you safe isn’t skipping it, it’s meeting one rule:
"Allowed only if that portion is exclusively used on a regular basis for business purposes."
Exclusively means that spot is for work and nothing else. The spare room you turned into an office counts, but the kitchen table where the family also eats does not. Meet that test and you pick one of two ways to figure it, and the Home Office Log runs both. The simplified method is a flat rate:
"Standard deduction of $5 per square foot of home used for business (maximum 300 square feet)."
So a 200-square-foot office is a $1,000 deduction, and the 300-square-foot cap works out to $1,500. The actual method usually pays more if you rent or carry a mortgage. You figure what share of your home the office takes up. Then you deduct that share of your rent or mortgage interest, utilities, insurance, and repairs, with no cap. The tab figures both side by side so you can see which one wins. Want it done for you? Our home office calculator pulls your home’s square footage from your address and works out the savings at your bracket.
The miles you drive for work are the other one. For 2026 the IRS lets you deduct 72.5 cents for every business mile. Drive 8,000 business miles in a year and that’s $5,800 off your taxable income, for trips you were taking anyway. The IRS wants a simple record of each trip: the date, where you went, why, and the miles. The Mileage Log gives you those four fields and multiplies by the rate for you. If you don’t want to keep it by hand, our mileage log template walks through the easier ways, including letting an app log the drives for you.
Four mistakes that cost you the deduction
I’ve watched good owners hand real money back to the IRS over small bookkeeping slips. Here are the four I see most, and you can avoid all of them.
Receipts you never categorize. Almost 3 in 10 receipts in our data sat with no category. How you lose the deduction: a charge you can’t explain is the first thing the IRS throws out at audit time. Tag it the day you get it, not next April.
Free-typing the category. When the same expense gets four spellings, your total looks too small to bother claiming. How you lose the deduction: real money sits scattered across rows nobody adds up. Use the dropdown so every dollar of one kind stacks in one place.
Mixing business and personal in one account. When a vendor payment and a grocery run live in the same account, tax time turns into a treasure hunt. How you lose the deduction: you can’t prove a charge was for business, so you skip it and overpay. Run a separate business account and card.
Faded receipts. The thermal paper most receipts print on goes blank inside a year. How you lose the deduction: the print fades to gray before your return is even due, and a blank slip proves nothing. Snap a photo the day it prints, and the digital copy outlives the paper. The IRS is fine with that:
"Your supporting documents should identify the payee, the amount paid, proof of payment, the date incurred, and include a description of the item purchased or service received that shows the amount was for a business expense."
The easy way: skip the typing
The template is free and it works, and I stand behind it. But I’ll be honest about the catch. Someone still has to type every receipt into it, and our data shows what happens when that turns into a chore. Receipts go untagged, the spelling drifts, and the books fall behind.
That’s the whole reason Shoeboxed exists, because we do the typing for you. We’re a 20-year-old receipt scanning and mileage tracking app. Snap a receipt with the app, forward an email, or mail us a shoebox of paper in our Magic Envelope. Our team in Durham scans the receipts, and our software pulls out the date, total, vendor, and category, so every cost lands in your account already sorted, with the same spelling every time.
The mileage piece is my favorite. The app tracks your drives by GPS, texts you the list at the end of the day, and you reply with which ones were business, so a tax-ready mileage log comes together without anyone keeping it by hand.
Either way, the template is yours, no signup and no strings. If you’d like your receipts captured and sorted for you, that’s what we do. Shoeboxed Pro runs $29 a month with a 30-day risk-free guarantee. Scan a year of receipts, and if it isn’t for you, we refund the money.
Frequently asked questions
Does Excel have a business expense template? Excel ships with a few generic budget and expense-report templates, but none of them tie your costs to the tax form or add up your deduction. The free template on this page does both. Its dropdown fills in the Schedule C line, a Business % column handles costs you split between work and home, and a summary tab totals it all for your accountant.
Should I use Excel or Google Sheets? Either works, and the download gives you both. Excel is better if you work offline or already live in it. Google Sheets is better if you want it on your phone and your laptop without emailing files around. The math and the dropdowns are identical in each.
Is the template free? Yes, with no email, no signup, and no trial. Download it and it’s yours, and the only pitch is a bonus tab with a discount on Shoeboxed in case you’d like to hand the receipts to us instead.
How many expense categories should a business track? Enough to match where your money goes, which for most small businesses runs around fifteen to twenty. The template ships with the full Schedule C set so nothing important gets dumped into “miscellaneous,” and you’ll only ever use the rows that fit your business.
How long should I keep the receipts behind my spreadsheet? Three years in the normal case, counted from the date you filed, and longer in a few situations. Keep a digital photo of each receipt and you can toss the fading paper.
About the author
I’m Doug. I bought Shoeboxed in late 2025 with an SBA loan and 5% down, so I run a small business and sweat the same receipts and the same tax bill you do. Before this I spent years running Earth Class Mail. I write these guides because the surest way to grow Shoeboxed is to help people keep more of what they earn, and because I use this template on my own business too.
4.4 / 5 on
