Food truck profit tracker that tells you which events to rebook
Some events look busy and still lose money. The booking fee, the organizer’s commission, a temporary permit, a tank of generator fuel, two extra crew members and a higher food cost add up fast. The Curbtally food truck profit tracker turns every event into one honest number: event profit, and event profit per hour of your time. Then it ranks every event you work so next season’s calendar fills itself with the winners.
Curbtally is a spreadsheet for Microsoft Excel and Google Sheets. Log an event in about two minutes from your POS report, and the Dashboard, Rebook Ranking, Calendar and Monthly P&L update on their own.
What the food truck event tracker does
- Calculates true event profit. Sales by payment type minus sales tax, card and app processing fees, organizer commission, booking fee, permits, generator fuel, other costs, travel, labor and food and packaging.
- Measures profit per hour. Setup, service and teardown hours turn profit into a per-hour figure you can compare across a 3-hour lunch and a 3-day festival.
- Gives every event a verdict. REBOOK when it beats your profit-per-hour and margin targets, NEGOTIATE when it’s profitable but below target, DROP when it lost money.
- Ranks your events automatically. The Rebook Ranking sorts every event or venue by lifetime profit per hour, with times worked, last date and next booked date.
- Answers “should I book it?” The Break-Even Planner compares three offers side by side: expected sales, break-even sales and customers, projected profit per hour and a bad-weather case.
Who it’s for
Food truck, food trailer and food cart owners who work farmers markets, festivals, fairs, breweries, corporate lunches, sports nights and private catering. It also suits coffee carts, dessert trucks, concession stands and pop-up vendors who pay vendor fees or a share of sales.
What’s included
10 tabs in one workbook
- Start Here: four-step quick start, links to every tab, color and verdict key.
- Dashboard: 12 KPI tiles (net sales, event profit, net profit, profit per hour, food cost %, best event, fees and commissions, lost fees, upcoming bookings, tips) and 6 charts: monthly sales and profit, sales by payment type, top 10 events, profit by event type, where the money goes, and weather impact.
- Events: a 400-row event log with date, event, status, weather, attendance, five payment types, tips, fees, commission, permits, generator gallons, other costs, miles, actual food cost, hours and crew hours.
- Event List: up to 100 events or venues with organizer, contact, typical fee, commission, application deadline, notes and lifetime results.
- Rebook Ranking: every event sorted by profit per hour with a clear verdict.
- Calendar: pick any month to see booked, worked and cancelled days with profit on each date.
- Monthly P&L: sales, sales tax, each cost line, event profit, fixed overhead and net profit for every month, plus event stats.
- Overhead: commissary rent, truck payment, insurance, software and other fixed costs by month.
- Break-Even Planner: test up to three event offers before you commit.
- Settings: currency, tracking year, payment fees, sales tax, tips, cost defaults, targets and your dropdown lists.
Plus
- An illustrated Word user guide with screenshots, formulas, tips, troubleshooting and FAQ.
Features food truck owners asked for
- Sales tax backed out automatically if your POS totals include tax.
- Tips tracked separately, and only counted as income if your business keeps them.
- Rained-out events logged as “Cancelled – fee lost” so non-refundable fees count against that event.
- Weather and attendance on every row, so you can see what a rainy day really costs.
- Default food cost % for quick logging, or enter the actual cost for big events.
- Any currency: one setting changes every money label and KPI tile. $ is the default.
- Protected formulas (no password) and input rules that stop typos such as 4:30 instead of 4.5 hours.
How it works
- Open Settings and set your currency, tracking year, payment fees, food cost %, staff pay and target profit per hour.
- Add the events and venues you work to the Event List.
- After each event, add a row on the Events tab from your POS report and receipts.
- Use the Dashboard and Rebook Ranking to decide what to book next season, and run new offers through the Break-Even Planner.
File format and software requirements
- One .xlsx workbook plus a .docx user guide, delivered as an instant digital download.
- Works in Microsoft Excel 2016 or newer (Windows and Mac), Microsoft 365, and Google Sheets (free Google account).
- No macros, add-ins or subscriptions. Standard formulas only.
- Print-ready tabs on US Letter, fit to page width (also prints on A4).
Customize it
Rename payment types, event types and weather options on the Settings tab and every dropdown follows. Change the currency once. Unprotect any sheet (no password) to change colors or add your logo.
Real ways to use it
- Compare a $650 festival with a no-fee brewery night by profit per hour, not just sales.
- Prove to an organizer that their 20% commission makes the event unprofitable, and negotiate.
- Plan next year’s calendar from the Rebook Ranking before applications open.
- Hand your accountant a clean Monthly P&L at tax time.
- Decide whether a new parade or chili cook-off is worth the fee, before you pay it.
FAQ
Does this food truck spreadsheet work in Google Sheets?
Yes. Upload the .xlsx to Google Drive and open it with Google Sheets, or use File > Import. It also works in Excel 2016 or newer and Microsoft 365.
Do I need accounting experience?
No. You type event numbers into the yellow cells; everything else calculates. The guide explains each formula in plain English.
How is profit per hour calculated?
Event profit divided by your setup, service and teardown hours for that event.
Can I track multi-day festivals?
Yes. Log one row per day to compare days, or one row for the whole event.
Can I use a currency other than dollars?
Yes. Set your currency symbol once on Settings and every money label updates.
Is this a menu costing or recipe calculator?
No. Curbtally focuses on events and profit. Enter your typical food cost % or the actual cost per event.
Is it tax software?
No. It is a planning and record-keeping tool. Talk to your accountant about taxes.
Digital download and license
This is a digital product; nothing is shipped. Download the files right after purchase. Personal use only (or use within your own business for business templates). You may not resell, share, or redistribute the files. © 2026 Taskdale. All rights reserved.




Reviews
There are no reviews yet.