Food Truck Profit Tracker Spreadsheet | Daily Sales, Inventory & Waste, Mileage, Expenses | Excel & Google Sheets

Long shift. Line out the window. Cash in the box. And you still can't say whether today actually made money.

If that's you, this tracker was built for you, the food truck owner who wants real numbers without a bookkeeping degree or an expensive monthly software subscription.

TYPE IN YOUR DAY. SEE YOUR PROFIT.

Enter your sales and costs in a few minutes after service. The sheet does the math and shows your net profit, margin, and sales per hour for that day. Days that fall under your target margin turn red, so you notice the slow ones fast.

SOUND FAMILIAR?

- "We were slammed, so we must have made money." (Did you?)

- Food cost creeping up and no idea why

- Product thrown out because nobody tracked counts

- Mileage and receipts lost in the glove box until tax time

- Card and delivery app fees quietly eating the margin

WHAT'S INSIDE

1) START HERE: set your card fee %, delivery app commission %, mileage rate, and target margin once

2) DAILY INCOME: cash, card, and delivery app sales; tips tracked separately; food and supply cost; labor; automatic card and delivery fees; NET PROFIT; margin %; sales per hour

3) INVENTORY & SPOILAGE: beginning count, deliveries, ending count, waste, usage cost, waste cost, waste %, and an automatic REORDER flag when you hit your par level

4) MILEAGE & EXPENSES: odometer log with an automatic mileage deduction, plus an expense log with categories (propane and fuel, permits, commissary rent, insurance, repairs, marketing, and more)

5) MONTHLY SUMMARY: sales, food cost %, labor, fees, profit, expenses, average sales per day, waste cost, and a chart. No typing needed.

YOU GET TWO FILES

- A BLANK template, ready for your truck

- A filled-in EXAMPLE so you can see how it works (the sample numbers are made up)

EASY TO USE

Yellow cells are where you type. Grey cells calculate automatically. Built-in dropdowns keep your categories tidy. Works in Microsoft Excel and Google Sheets.

FORMULAS READY TO GO

Room for about 200 service days, 150 inventory rows, 100 mileage trips, and 200 expenses per file. Save a fresh copy each year.

INSTANT DIGITAL DOWNLOAD

After purchase, download your files directly from Payhip. A ‘Read Me First’ guide shows you how to open them in Excel or Google Sheets.

GOOD TO KNOW

- Net Profit is calculated before overhead such as truck payments, rent, and insurance; log those on the Mileage & Expenses tab to see profit after expenses on the Monthly Summary.

- Sample numbers in the example file are made up and are not typical or expected results.

- A bookkeeping aid, not tax, legal, or accounting advice. Ask your accountant about mileage and deductions.

- For your own business use. Please don't resell, share, or redistribute the file.

Questions before you buy? Send a message. I'm happy to help.