Skip to product information
1 of 8

InkSheet Studio

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

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

Regular price $2.69 USD
Regular price $9.99 USD Sale price $2.69 USD
Sale Sold out
Quantity

INSTANT DOWNLOAD — HOW IT WORKS: This is a digital download, not a physical product — nothing is shipped. After checkout, your download link appears right on the confirmation page and is also emailed to you. Use the files in your favorite apps and projects, or print the PDF files at home or at a local print shop.

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.

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

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

HOW LOCATION PROFIT IS FIGURED — ONE METHOD, NO HIDDEN MATH
You set one COGS % per location (your blended food-cost rate for that spot). Estimated COGS = that location's sales × its COGS %. Profit = sales − site fees − estimated COGS − labor − other costs. Adjust the % any time and every profit updates.

YOUR TARGET FOOD-COST %
The toolkit starts with a 32% target. Many food trucks aim for a food-cost percentage somewhere around 28–35% — that's a common industry benchmark, not a rule, and your right number depends on your menu and your prices. Change the target in one cell on the Start Here tab and every flag on the Menu Costing tab follows it.

It comes loaded with a fictional sample month (a downtown lunch lot vs. a riverside night market) so you can watch every formula work before you delete the samples and type your own. Formulas are pre-filled down the columns — 24 sales days, 14 menu items, 16 stock items, 8 locations ready to go.

FINISHED FILE — This listing is a digital item, delivered instantly as a file at checkout. The file is finished and ready to use — nothing is customized or personalized. If anything ever breaks or a formula misbehaves, message us and you will receive a corrected file free — forever, no time limit.

REQUIREMENTS: a free Google account. Your toolkit lives in Google Sheets — nothing to install, and it works on your phone at the truck, at home, or wherever you plan your week.

This is a digital product — no physical item will be shipped, and all sales are final (we can't accept returns or cancellations on digital downloads). Your files are available instantly after checkout. But don't worry: if anything isn't working right, message us anytime and we'll fix it for you — no time limit.

View full details