1 / 10
Tap any image to enlarge, then swipe or use the arrows to page through every sheet.
What this does that most food-truck cost templates do not: it tracks freshness and par. Your proteins and produce spoil in days, and serving something past its date is a health-code problem, not just a weak review. On the Freshness / Par sheet you enter a received date and a shelf life for each perishable, and the kit gives you the best-by date, the days left and a clear OK / USE SOON / EXPIRED flag against your working date. It also carries a par level for each item and pulls the on-hand quantity straight from your stock room, so the top-up column tells you exactly how much to prep or buy before you roll out — the two questions a service actually turns on. Many costing sheets stop at the food cost and never touch either one.
On top of that it does the money properly. On Ingredients you list what you buy — ground beef, chicken, carnitas, tortillas, buns, cheese, lettuce, tomato, onion, limes, potatoes, frying oil, sauces, drinks and packaging — with the pack price, the pack size and the usable % after trim, peel and griddle cook-loss (an 80/20 patty shrinks about 12% on the flat-top), and the cost of one gram, millilitre or piece is worked out for you. On Recipes you build each item’s bill of materials; on Products the ingredient cost, your prep and serve labour and a share of overhead — propane, commissary, permit — roll up into the true cost of one taco, burger, bowl or order of fries. Trays, boxes, cups, napkins and cutlery are counted per item, so packaging is costed and stocked too, not left out.
Pricing shows both numbers, named correctly: margin as a share of the price and markup as a share of the cost, side by side, plus the exact price for a target margin — so a "70%" target is never mistaken for the other one. Then it answers the question a truck lives or dies on: break-even in covers per day. It takes your monthly fixed costs, your trading days and your average gross profit per cover and tells you how many servings each day has to clear before the day pays for itself. And because the Sales sheet tags every line with an event or location, the Dashboard compares your pitches head to head — revenue, profit and margin for the downtown lot vs the brewery Friday vs the weekend festival — so you book the spots that actually pay.
It is also a full stock room: a reorder point built from your own daily usage and supplier lead time flags every ingredient OK, REORDER or OUT OF STOCK before you run dry mid-service. Built for Excel 2016+ and Google Sheets with classic, compatible formulas only — no macros, no add-ons, nothing locked. Any currency (one symbol cell). Sample data for a real taco-and-burger truck is filled in so every number and the chart are alive on first open; clear the yellow cells and it is yours. Every headline figure in this listing was measured from the built file, recalculated by LibreOffice and checked against an independent model of the same arithmetic.
What you get
- Freshness / Par sheet: received + shelf life → best-by, days left and an OK / USE SOON / EXPIRED flag, plus a par level and the top-up needed — nothing expired goes out, and you prep the right amount
- On-hand is pulled live from the stock room into the par sheet — top-up = par − on hand, no double typing
- 8 sheets: Start Here, Ingredients, Freshness, Recipes, Products, Sales, Dashboard, Checks
- Per-ingredient cost from pack price, pack size and a usable-yield % for trim, peel and griddle cook-loss
- Recipes → Products: ingredient cost + prep/serve labour + overhead (propane, commissary, permit) per item → true cost per item
- Margin % and markup % side by side, the price for a target margin, and break-even units per menu item
- Daily break-even in COVERS PER DAY — how many servings each day must clear to pay for itself
- Event-vs-location profit comparison — revenue, profit and margin per pitch, side by side
- A full stock room — proteins, produce, packaging, drinks: on-hand, stock value, reorder point and a REORDER / OUT OF STOCK flag
- Any currency · no macros · nothing locked · instant download (.xlsx + PDF guide) · checked against an independent model — 0 errors
Preview every page
Click any page to zoom.
What's inside
Questions
How does the Freshness / Par sheet work?
You enter a received date and a shelf life in days for each perishable. The kit works out the best-by date, the days left against your stock as-of date, and flags each one OK, USE SOON or EXPIRED. It also holds a par level for each item and pulls the on-hand quantity from your stock room, so the top-up column shows exactly how much to prep or buy before a service. Most costing templates handle neither food safety nor par.
What is break-even in covers per day?
A cover is one serving. The Dashboard takes your monthly fixed costs, divides by your trading days to get a daily fixed cost, and divides that by your average gross profit per cover — so you get the number of servings each day has to clear before the day pays for itself. It is the single figure a food truck runs on, and most spreadsheets in this genre do not show it.
Can it compare different events and locations?
Yes. Every line on the Sales sheet is tagged with an event or location, and the Dashboard totals revenue, profit and margin for each one side by side — the downtown lot vs the brewery Friday vs the weekend festival — so you can see which pitches actually pay and book accordingly.
Does it work in Google Sheets?
Yes. Upload the .xlsx to Google Drive and choose File → Save as Google Sheets. Every formula (SUMIFS, VLOOKUP, COUNTIF, IFERROR) and the chart are Sheets-compatible. A short PDF walks you through it.
Which currency does it use?
Any. You set a currency symbol on Start Here; it is decorative only — the arithmetic uses plain numbers, so the file works in any country with no tax rules baked in.
Does it account for cook-loss and trim?
Yes. Each ingredient has a usable-yield %, so beef that shrinks on the griddle and produce that is cored and peeled cost per edible portion, not per raw pound. That is what makes the cost per item real rather than optimistic.
What is the difference between margin and markup?
Margin is profit as a share of the price; markup is profit as a share of the cost. A 50% markup is only a 33% margin. The Products sheet shows both, named correctly, so you never confuse them again.
Is it only for tacos and burgers?
No. Add, rename or remove items on Products and Recipes freely — bowls, wraps, loaded fries, wings, desserts, drinks. The same structure fits any truck, trailer, cart or pop-up menu.
Is anything locked or macro-based?
No. No macros, no protected sheets, no external links. Blue-on-yellow cells are your inputs; black cells are formulas.
Reviews
No reviews yet — this product is new. Every review here comes from a verified purchase.
Personal-use license for one household. No resale or redistribution. Delivered as a ZIP download immediately after payment. No physical item will be shipped.
Food Truck Business Kit
True cost per item, freshness/par tracking, daily break-even in covers, stock and profit for a food truck — one Excel & Google Sheets file, any currency, no subscription
Pay with PayPal or any card
- Works in any country · your own currency
- Download link on the confirmation page and by email
- What you need: Excel 2016+ · Google Sheets
- Full refund within 24 hours — just message us, no reason needed
- 8 sheets · 2,362 formulas
- Formats: .xlsx (Excel 2016+, Google Sheets) + PDF guide
- ZIP: 96 KB
Ask within 24 hours of paying and we refund the whole amount — no form, no reason needed. Up to 30 days we still refund, minus the 4% payment processing fee. Files that will not open are always refunded in full, with no time limit.

