Food Truck Profit Tracker Excel with menu food cost calculator, event profit by location, fuel and expenses by category, and a monthly P and L dashboard. Know what every item actually costs, what every event actually…
About this template
Food Truck Profit Tracker Excel with menu food cost calculator, event profit by location, fuel and expenses by category, and a monthly P and L dashboard. Know what every item actually costs, what every event actually made, and whether the month actually made money. Built for food truck owners who need to know, item by item and event by event, whether the price covers the plate, the event fee, and the fuel — without accounting software. If an item is losing money, this workbook flags it before the next menu print.
$39
Excel & Google Sheets template — instant download on Etsy
Menu and Food Cost — plate cost (ingredients only), menu price, food cost percent, margin in dollars and percent, and a suggested price at your target food cost percent for every item. Items over target are flagged. Change a plate cost or a price and the whole workbook follows.
Events and Locations — event, date, location, customers, food sales, drink sales, food cost, event fee, profit per event, and margin for every event. Food cost uses the blended food cost percent from the menu sheet.
Fuel and Expenses — date, category, description, and amount for fuel, permits and licenses, supplies and packaging, maintenance and repairs, insurance, commissary, and other costs. Category totals are summed below the log.
Monthly P and L — customers, food and drink sales, food cost, event fees, and operating expenses by month, Jan-Dec, with net profit, margin, food cost percent, and average spend per customer. All formulas from sheets 1 to 3.
Dashboard — total sales, customers, average spend per customer, food and event costs, net profit and margin, best and worst events, your highest-margin and highest-cost items, and costs by category.
Cover and How to Use — start here. Yellow cells are the only ones you edit.
Quick profit check — Food Truck Profit Tracker
Try the headline numbers for a typical month. The full template does this job by job with a monthly P&L and dashboard.
Frequently asked questions
What does the Food Truck Profit Tracker track?
The Food Truck Profit Tracker tracks Menu and Food Cost; Events and Locations; Fuel and Expenses; Monthly P and L; Dashboard.
What do the example numbers show?
The included example shows: Total sales 21,060 (food 18,075, drinks 2,985) from 1,780 customers; average spend per customer 11.83; average sales per event 1,755.
Does it work in Excel and Google Sheets?
Yes. The workbook works in Microsoft Excel and in Google Sheets (upload the .xlsx file to Google Drive to open it in Sheets). It is an instant digital download from Etsy — no physical item is shipped.
This template is a bookkeeping and planning tool only — not tax, legal, or CPA advice. Built by an accountant: B.S. Accountancy, ASU W. P. Carey.
VickeryFinance — “Know your numbers — without the accounting software.”
Gear that pairs with this tracker
Some links below are affiliate links. If you buy through them, Vickery Finance may earn a small commission at no extra cost to you. We only list gear genuinely used in this trade.