Food Truck & Mobile Business Daily Operations Tracker | Google Sheets
Running a food truck means juggling a hundred things at once — sales, supplies, events, staff, permits — with zero margin for chaos. This tracker puts everything in one place.Built specifically for food trucks, mobile kitchens, and event-based food businesses. Track daily sales by menu item, see which locations actually make you money, manage your supply costs, schedule your team, and get a clear weekly P&L — all without leaving Google Sheets.What's inside (6 tabs):→ Daily Sales Log — Track every item sold, every service day. Revenue, COGS, gross margin, and cash vs. card totals calculated automatically.→ Location Profitability Log — See your net profit after pitch fees, fuel, and permits for every spot you work. Know exactly which locations to keep booking and which to drop.→ Supply Cost Tracker — Log every ingredient and supply purchase with cost-per-unit calculations. Instant weekly and monthly totals with automatic margin alerts.→ Event Calendar + Permit Tracker — Visual monthly calendar of upcoming events. Never miss a permit expiry again — color-coded alerts for renewals due in 30 and 90 days.→ Team Schedule + Labor Cost — Schedule shifts, log hours, and see your total labor cost as a percentage of revenue — automatically.→ Weekly P&L Dashboard — One clear snapshot of your week: gross profit, net profit, best-selling item, best location, and actual vs. target revenue. Updates from your other tabs. Zero manual entry.Who this is for:Food truck owners, mobile kitchen operators, catering trailer owners, pop-up food vendors, and anyone running an event-based food business.What you get:One .xlsx file. Works in Google Sheets (free) and Excel. No subscriptions. No accounts. No plugins.Download once. Use it every service day.
Get it → pattybun.gumroad.com