Food Truck Spreadsheet — Daily Sales Log, Menu Costing, Inventory Pars and Location Profit Tracker for Google Sheets

Two spots. Same truck, same menu, same you. One of them is quietly making you a lot less than the other — do you know which one, and by how much?

Most food truck spreadsheets are really restaurant or catering spreadsheets with a truck on the cover. This one is built for how a truck actually runs: you work a spot, you log the day, and the sheet tells you what that spot paid you after the site fee, the food cost, and the labor — profit per location, and profit per day. Add menu costing that flags any item drifting over your target food-cost %, and par levels that warn you before you run out mid-rush, and you have the whole operation on six focused tabs.

THE 6 TABS

• Start Here — plain-English quick start, plus the one setting that runs the whole sheet: your target food-cost %

• Daily Sales Log — one row per day: date, location or event, gross sales, hours. Sales per hour figures itself out

• Menu Costing — type an item's ingredient cost per serving and its menu price; food-cost % and margin per serving fill in on their own, and anything over your target flags itself

• Inventory & Pars — set a par level for everything you stock; status reads OK, ORDER SOON, or OUT, with the exact amount to order

• Location P&L — one row per spot you work. Sales pull in from the log by themselves; add site fees, your COGS % for that spot, labor, and other costs — profit and profit per day do the rest

• Dashboard — the month at a glance: total sales, average food-cost %, your best and weakest locations by profit, every expense in one summary, and your truck profit after extra expenses

A FINISHED FILE, DELIVERED INSTANTLY

You receive the finished spreadsheet file exactly as shown — open it, add your own jobs and customers, and use it right away. It is a complete digital file delivered to you, not a service and not a setup project. Nothing about the file is customized, personalized or built to order. If you ever find a genuine error in a formula or a number, tell us and we will send you a corrected copy of the file, free, forever.

This is a digital product: no physical item will be shipped. All sales of digital downloads are final (no returns or cancellations), and your file is available instantly after purchase.

Transparency note: this spreadsheet was designed with AI assistance, then hand-built and formula-tested by our shop.