Description
Food Truck Business Tracker for Excel and Google Sheets
Know which spots and events are worth going back to, price every menu item right and see your real profit on every shift. Built for food trucks, food trailers, coffee carts and pop-up vendors.
What you get
- Event Calculator: organizer fee (flat or % of sales), expected orders, average ticket, hours, staff and miles in; profit after the fee, food, staff, card fees, fuel and propane out. Break-even orders, orders needed for your target, the highest flat fee you can pay, a Book it / Maybe / Skip it verdict and a what-if table for smaller or bigger crowds.
- Sales Log: one row per shift with location, orders, sales, tips and fees. Food cost, labor, card fees, fuel, profit, sales per hour and average ticket fill in by themselves.
- Locations: every spot and event with shifts, average sales, profit per hour and average profit, rated Book again, OK or Drop it for you.
- Menu Costing: ingredient cost and price for every item, food cost %, profit per plate and a suggested price that hits your target food cost.
- Dashboard: sales, net profit, food cost %, labor %, shifts, average sales per shift, sales per hour and event fees paid, with a monthly chart, your best locations and month-by-month totals.
- Expenses and Settings: commissary, permits, propane, repairs, insurance and more; food cost %, staff pay, card fee, cost per mile, propane per hour, setup time and your profit target.
Details
- Up to 2,000 shifts, 60 locations and 60 menu items.
- Two files: one with example data so you can see it working, and a blank one to start fresh.
- Format: .xlsx for Microsoft Excel 2016+ and Excel 365. Opens in Google Sheets.
- No macros, no subscription, nothing locked. Instant download after payment.
- Every total is checked against independent calculations before release.
Want to test an event first? Use the free food truck event profit calculator. Need it changed for your truck? Ask us.
Customer Reviews
There are no reviews yet.