Bookkeeping and P&L Spreadsheet for Food Trucks

A food truck earns in bursts at street service, festivals and private events, while food cost, propane, commissary rent and booth fees hit every week. Daily sales reports alone won't show whether an event was worth the fee.

This workbook is set up for food trucks. It has 5 income categories (Street service sales, Private events & catering, Festivals & fairs, Brewery & venue pop-ups, Delivery-app & online orders) and 13 expense categories (Food & ingredients, Packaging & disposables, Propane & generator fuel, Truck fuel, Commissary kitchen rent, Event & festival booth fees, Permits, licences & inspections, Staff wages, POS & app subscriptions, Truck repairs & maintenance, Insurance (truck & liability), Ice & water, Marketing & truck wrap), each with a note on what goes there, plus spare lines for your own. Fees kept by your card processor or platform are entered next to each sale and reported as their own expense line (card, pos & delivery-app fees).

The Monthly P&L totals every category by month, then shows net profit, margin, a tax set-aside at the rate you choose and your monthly service days. The Dashboard compares any month with the year to date and tracks 5 trade KPIs against your targets: food & packaging cost % of sales; revenue per service day; labour % of sales; booth fees % of festival & pop-up sales; propane & fuel per service day. The Annual Summary gives quarterly totals, your best month, the largest cost and the receipts still missing.

Included: a worked-example copy filled with a fictional food truck year, a blank copy, and a 6-page quick-start guide in US Letter and A4 (category map, KPI guide, worked example, tips for the trade). 7 sheets, 6,710 formulas, room for 1,000 income and 1,500 expense entries a year.

General information, not tax or accounting advice.