Food Truck Cash Flow Template

Download the .xlsx file and open it in Excel or Google Sheets. Start with the 13-Week Cash Flow sheet — rename the revenue rows to match how your truck actually makes money. Most operators use four rows: street service (your regular daily stops), private catering (weddings, birthday parties, private events), corporate (office lunch routes or company events), and festivals/rallies. Enter your expected collections for the next 13 weeks using your calendar, confirmed bookings, and typical daily street revenue as your guide. Fill in your weekly expense estimates for food costs, commissary, fuel, and payroll, then check the ending balance row to see where you stand.

Move to the Event Revenue Tracker and log every confirmed booking — enter the event date, the deposit you've already collected, and the balance due date. This is the most important step for catering-heavy operators: it shows you which forward cash flows are locked in versus which are still street-dependent. Once your bookings are entered, the tracker feeds your committed revenue into the 13-week view so your projections reflect what's actually in the pipeline. Update it whenever you book a new event or collect a balance payment, and review it at the start of each week alongside your service schedule.

At month-end, fill in the actual figures in the Monthly Cash Flow sheet and reconcile them against your bank statement. After a few months of actuals, the Annual Summary will start showing you your food cost percentage trend and commissary cost ratio — the two numbers that most food truck operators cite as the difference between a profitable truck and one that's always short on cash. Review the Dashboard each month to see your revenue channel mix. Trucks that start tracking see patterns quickly: which festival weekends spike cash, when the slow season actually starts, and whether catering bookings are growing as a share of revenue.

Food trucks run on variable cash flows in a way that even other food-service businesses don't. A restaurant has fixed seating and a predictable daily rhythm. A food truck has a calendar full of decisions — which corner to park on, which festival to register for, whether to take a catering inquiry that conflicts with a busy Saturday route. Each of those decisions has a cash consequence, and making them well requires knowing your actual cash position, not just your bank balance after a weekend of events.

The two cash flow dynamics that distinguish food trucks are the catering deposit cycle and the seasonality gap. Catering deposits — typically 25–50% paid weeks before the event — create a gap between cash received and revenue earned. An operator who spends a deposit on food costs for next week's street service will be short when the catering event arrives and the remaining expenses hit. Separately, most northern-climate food trucks see revenue drop 40–60% from November through February, but expenses don't drop proportionally: commissary fees, insurance, loan payments, and permit renewals continue. Operators who haven't modeled their slow-season cash position often face a cash crunch in February that surprises them even when the math was always visible.

The practical workflow is straightforward: update your event tracker weekly, use the 13-week view to plan service days and decide whether to take new bookings, and reconcile actuals monthly. Operators who run this review consistently stop making the common mistakes — registering for a $500 festival without checking whether cash will cover food inventory that week, or taking a catering deposit in October without modeling whether it will last through a slow January. Cash flow management in a food truck isn't complicated; it just requires looking at the numbers before the calendar fills up.