Free Food Truck Expense Spreadsheet (With Startup Cost Worksheet)

If you want a food truck expense spreadsheet that does more than hold a list, here’s a free one I built, no email required. Copy it to your Google Drive or download the Excel file. Type one row per receipt, and the sheet fills in the Schedule C line and the deductible amount for you.

Before I built the columns, I pulled every receipt from the food trucks and concession businesses in our archive, 53,594 of them. Two of the biggest deductions a truck can take never showed up in a single one. I’ll show you both below, because together they can be worth thousands of dollars a year, and the spreadsheet gives each its own tab.

I run Shoeboxed, a receipt-scanning company that has been turning shoeboxes of paper into tax records since 2007. Food trucks are the hardest test of a receipt system I know. Cash comes in at the window, a card reader skims fees off every sale, and some of the biggest costs never leave a paper trail at all. If your business isn’t a food truck, the small business expense spreadsheet is the general version. This page is for the trucks.

"Across 53,594 receipts from 12 food-truck and concession businesses, Shoeboxed found zero mileage records and zero home-office records: the two biggest deductions a food truck can take leave no paper trail at all."

Shoeboxed customer data, June 2026

Get the food truck expense spreadsheet

Copy the template to my Google Drive →

Prefer another format? Download as Excel (xlsx) · Download as printable PDF

You get six sheets 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. It also cuts meals to the 50% the IRS allows.
• Startup Costs. A worksheet that prices your build with low and high columns, then tracks what you paid.
• Schedule C Summary. Your totals rolled up by tax line, the one page your accountant wants.
• Home Office Log. Both ways to figure the home office deduction, with a quick check that your space qualifies.
• Mileage Log. Four fields per trip for the personal car that does your supply runs, multiplied by the IRS rate for you.
• Bonus tab. 25% off Shoeboxed, on any plan, in case you’d like us to do the typing.

I locked the categories to a dropdown built for trucks, so your prep-kitchen rent, your propane, and your event booth fee each land in their own column instead of a junk drawer. The how-to instructions sit at the top of the first tab, so you don’t have to remember any of this. (Your health department may call the prep kitchen a commissary kitchen. It’s the same place, and the rent is deductible either way.)

If you only do one thing on this page, copy the template. The rest of this article explains the rules built into it, and two of them put real money back in your pocket.

What 53,594 food truck receipts say about where the money goes

Those 53,594 receipts come from 12 food-truck and concession accounts in our archive, going back to 2013. These are our customers, not a national survey, and one big account threw most of the receipts into the pile. Read the numbers as a real stack of paper, not a census.

The thing that eats the most paper isn’t food. Fuel and auto receipts led the pile at 24.1%, and they weren’t one truck’s quirk, because 9 of the 12 accounts logged them. The Walmart and Sam’s Club runs that keep a truck stocked came next at 11.4%, then meals on the road at 9.9%, then groceries at 8%, and each of those showed up in at least 8 of the 12 accounts. Your customers see a kitchen, but your filing cabinet sees a vehicle first.

That’s why the tracker gives the truck its own columns. Truck fuel, oil, and repairs point at Schedule C Line 9, and propane points at Line 22 with the supplies, where your accountant expects to find it. You’re not guessing which column the AmeriGas swap belongs in, because the dropdown already knows.

The receipts that don’t exist: zero mileage, zero home office in 53,594

Here’s what jumped out at me when I sorted the pile: the mileage count came back zero, and the home-office count came back zero. Permit and license receipts came in at 51, which works out to one tenth of one percent. Booth and event fees showed up 15 times, from businesses that live on festival weekends.

In the records they keep with us, the supply runs in the family car left no trace at all. Maybe some owners logged those miles somewhere else, but nothing ever landed in the pile. The same goes for the home office, the permits, and most of the booth fees.

These costs never arrive as paper. The city takes a check or a web payment for the permit, and the festival takes Venmo for the booth. The card reader takes its fee out of the deposit before the money ever lands in your account. Your receipt pile will never remind you to claim any of it.

That’s why the workbook gives mileage and home office their own tabs. Not one of the 12 accounts logged a single mile or home-office cost, and that money never comes back on its own. The next two sections cover both.

Why your food truck isn’t a “vehicle” at tax time

Your business puts miles on two kinds of vehicles: the truck itself, and the regular car or van that runs to the prep kitchen, Restaurant Depot, and the bank. The IRS treats them differently, and mixing them up costs real money in both directions.

Start with the truck. The standard mileage rate, the famous cents-per-mile deduction, is written for smaller vehicles. Here’s the 2026 rate announcement from the IRS:

"Beginning Jan. 1, 2026, the standard mileage rates for the use of a car, van, pickup or panel truck will be: 72.5 cents per mile driven for business use, up 2.5 cents from 2025."

IRS Publication 463 caps that list at vehicles under 6,000 pounds. A full kitchen build usually runs heavier than that. The sticker inside the driver’s door shows your truck’s weight rating, and that number settles it for yours. If your truck is over the line, it deducts its actual costs, receipt by receipt: fuel, oil, repairs, insurance, and registration. The truck’s purchase price depreciates too, and Section 179 often lets you write the whole thing off the first year (your accountant can confirm it fits your situation). A lighter van-based rig that stays under the weight limit can use the cents-per-mile rate instead.

Our pile backs this up. Fuel made up a quarter of all the paper these trucks generated, and every one of those receipts belongs on Line 9.

The 72.5 cents a mile belongs to the other vehicle, the personal car doing the unglamorous supply runs. Those are the miles nobody in our data was writing down. A 22-mile round trip to Restaurant Depot every week adds up to 1,144 miles a year, and the IRS lets you knock $829 off your taxable income for it. Add the prep kitchen runs, the bank deposits, and the drive out to walk an event site, and the family car becomes one of your bigger deductions.

The Mileage Log tab takes four fields per trip: the date, where you went, why, and the miles. If you don’t want to keep it by hand, the mileage log template article walks through the easier ways, including letting our app log the drives for you.

How you lose the deduction: claiming the mile rate and the fuel receipts on the same vehicle. The IRS makes you pick one method per vehicle: the truck on actual costs, the car on the standard rate.

The home office most food truck owners can claim (and restaurants usually can’t)

The sit-down restaurant down the block usually can’t take a home office deduction. You probably can.

The restaurant owner already has a fixed place of business with a back office in it, so the IRS expects the books to happen there. Your kitchen drives away every night. If one spot at home handles all the ordering, the scheduling, and the books, the IRS wrote an exception for your exact situation. The only other test is that no other fixed place does that work. Publication 587 says your home office qualifies if:

"You use it exclusively and regularly for administrative or management activities of your trade or business. You have no other fixed location where you conduct substantial administrative or management activities of your trade or business."

To be fair to the restaurant owner, if they truly did all their admin at home and had no office at the restaurant, the same exception would apply to them too. Most just don’t, because the back office is right there.

The simplest way to claim it is the IRS’s simplified option: $5 a square foot up to 300 square feet, so a 200-square-foot spare room is a clean $1,000 deduction with no receipts to dig up. You can stop there, but the simplified method caps at $1,500. Use the actual method and you’ll likely save more if you rent or carry a mortgage, and the Home Office Log tab figures both side by side so you can see which one wins.

Want the math done for you? Our home office calculator pulls your home’s square footage from your address and runs the numbers in about thirty seconds. Type what it finds into the Home Office Log tab and you’re done.

How you lose the deduction: using the space for anything personal. One family movie night in the office corner and the room fails the exclusive-use test. Keep it business-only.

What it costs to start a food truck (and the worksheet to price yours)

Everybody asks what it costs to start a food truck, and the honest answer is that it depends on your city. A used truck in a town with cheap permits is nothing like a custom build in a city that buries food trucks in paperwork. I won’t hand you a made-up national average, because the one real study on this measured the city-by-city spread, and the spread is enormous.

That study comes from the U.S. Chamber of Commerce Foundation, which sent researchers through 20 cities in 2017 to count what the rules cost. Their Food Truck Nation report found food trucks averaged $28,276 a year on permits, licenses, and legal compliance, spread across 45 separate procedures that ate 37 business days. The numbers are getting old, but the shape of the problem hasn’t changed.

Permits, licenses, and inspections are a real cost center, and every dollar of them is deductible on Line 23. Our pile says the receipts for them barely exist, so log every one.

The Startup Costs worksheet in the workbook prices your own build. It ships with low and high columns filled with labeled placeholder examples, you overwrite those with real quotes from your city and your builder, and a third column tracks what you paid once the bills arrive.

One tax rule is worth knowing before opening day. The IRS treats money you spend before you open as startup costs with their own first-year math. Section 195 lets you deduct up to $5,000 of them the first year. The rest spreads out over the next 15 years, and the $5,000 allowance shrinks once your startup spending passes $50,000. The truck and the equipment depreciate separately, often in full the first year under Section 179. Two minutes with a CPA before you file is worth real money here, and keep every receipt either way.

Every food truck cost, mapped to its Schedule C line

You don’t have to memorize any of this, because the sheet fills in the line for you. The table is here so you can see where your propane, your prep-kitchen rent check, and your booth fee land.

One row deserves a hard look at year-end: the card-processing fees. Square and its cousins take their cut out of the deposit before the money lands, so no receipt ever shows up. Your card reader’s app keeps a year-end report of the fees it took (look under Reports). Book that total on Line 10. For a busy truck, that one line is real money.

Four mistakes that cost a food truck the deduction

I’ve watched good food truck owners hand money back to the IRS over small slips, and here are the four I see most.

Receipts that never get a category. In our food-truck pile, 1 in 5 receipts sat with no category at all. How you lose the deduction: a charge you can’t explain is the first thing the IRS throws out in an audit. Tag receipts the week you get them, not next April.

Free-typing the category. The same cost gets four spellings, and the deduction scatters. Our archive includes “Food truck suppies” and “Maintanace,” typos and all, each one sitting as its own orphan column. How you lose the deduction: fuel that should stack into one big Line 9 number sits split across five labels nobody adds up. The dropdown keeps the spelling identical every time.

Running the business out of the cash drawer. Food trucks live on cash, and cash that buys ingredients without a paper trail is hard to defend when the IRS asks. How you lose the deduction: you can’t prove the farmers-market cash buy was for the business, so you skip claiming it and overpay. Run a separate business account and card, and ask for a receipt even when you pay cash.

Letting thermal receipts cook. Gas-pump and big-box receipts print on thermal paper, and thermal paper parked in a hot truck fades to blank within months. How you lose the deduction: the proof goes gray before the return is even due. Snap a photo the day it prints, and if one already vanished, the lost receipt guide shows how to rebuild the record. The IRS keeps the right to look back three years after you file, and a faded slip proves nothing.

The easy way: let us do the typing

I stand behind the sheet, but I’ll be straight with you about the catch: somebody still has to type every receipt into it. Our pile shows what happens when that somebody is busy running a window rush: 1 in 5 receipts never got tagged.

That’s the whole reason Shoeboxed exists. We do the typing for you, whether you snap a photo with the app, forward an email receipt, sync your Gmail, or stuff a shoebox of paper into our postage-paid Magic Envelope. Our team in Durham scans the paper, 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 for food trucks. Put the app on your phone and it tracks your drives by GPS in the background, then texts you the list at the end of the day. Reply with which ones were business, and a tax-ready log of your supply runs builds itself: the date, the miles, the IRS rate, the total. The miles that showed up zero times in 53,594 receipts get captured without anyone keeping a notebook in the glove box.

Either way, the template is yours, no signup and no strings. Shoeboxed Pro runs $29 a month with a 30-day money-back guarantee. Scan a season of receipts, and if it isn’t for you, we refund the money.

Start a Shoeboxed account →

Copy the sheet, claim the miles on the car that does your supply runs and the home office the restaurant down the block usually can’t, and you’ll keep more of what the truck earns than most owners ever do.

Frequently asked questions

Can I deduct mileage on my food truck? Usually not at the cents-per-mile rate. The IRS writes the standard mileage rate for cars, vans, pickups, and panel trucks under 6,000 pounds, and a full kitchen build usually weighs more than that. The truck deducts its actual costs instead: fuel, repairs, insurance, and depreciation. The standard rate does apply to the personal car you drive for supply runs, bank trips, and event scouting, at 72.5 cents per mile for 2026.

Can a food truck owner claim the home office deduction? Often, yes. If the only fixed place you do the ordering, scheduling, and bookkeeping is a space at home you use only for the business, the administrative-functions exception in Publication 587 applies. The simplified method pays $5 per square foot up to 300 square feet, and the actual method often pays more.

Where does my food cost go on Schedule C? Ingredients and the food you sell flow through Part III, the cost-of-goods-sold section, and land on Line 4. They don’t mix with the regular expense lines, and the tracker’s dropdown routes them to the right spot for you.

How much does it cost to start a food truck? Your city matters more than anything else. A U.S. Chamber of Commerce Foundation study that walked 20 cities in 2017 found trucks averaged $28,276 a year on permits, licenses, and legal compliance alone, before the truck, the build-out, and the inventory. The Startup Costs worksheet in the free template prices your own build with real quotes from your city.

Is the food truck expense spreadsheet free? Yes, with no email, no signup, and no trial. Copy it to your Drive or download the Excel file, and it’s yours. The only pitch is a bonus tab with 25% off Shoeboxed, on any plan, if you’d like us to do the typing.

How long should I keep food truck receipts? Three years from the date you filed, in the normal case, and longer in a few situations like under-reporting income. Keep a 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 food trucks feed me more often than my own kitchen does.