Free food truck spreadsheet

An Excel .xlsx workbook that also opens in Google Sheets. Made for food trucks and pop-up food vendors. Formulas done, no macros. Free direct download: no email, no sign-up.

Download the blank food truck spreadsheet (.xlsx) Filled example (.xlsx) · 1-page guide (PDF)

What it does

• A daily log: date, spot, card and cash sales, food and packaging, staff wages and pitch or event fee
• Total sales, net on the day and food cost % worked out for every service day; days over 35% food cost turn yellow
• Service days, sales, food cost and net for each month and for the year
• Every spot or event compared: days, sales, net and net per day
• Food cost % of sales and net per service day for the year; 400 service days and 10 spots

How to track food truck sales and food cost in a spreadsheet

1. Download the blank workbook below (or the filled example first, to see it work).
2. Settings tab: type your spots and events (up to 10) and the year.
3. Daily sales tab: one row per service day with date, spot, card and cash sales, food and packaging, wages and pitch fee.
4. Open the Dashboard tab: days, sales, food cost and net by month, and each spot compared.

Use it in Google Sheets

Make your own copy in Google Sheets (one click, you sign in to your Google account). Or upload the .xlsx to Google Drive, open it, then File > Save as Google Sheets. Excel 2010 or newer opens the .xlsx directly.

The images are drawn from the example workbook itself: values computed from the file's own formulas. Example data is fictional.

How we checked it

Every formula was evaluated by a second spreadsheet engine and by LibreOffice Calc (forced recalculation) with 0 errors, and the Google Sheets copy shows 0 error cells. The example's 70 service days, sales (84,453) and net (39,265) equal an independent sum of its rows, and the dashboard values match between both engines. We have not opened it in desktop Excel itself; it uses standard functions (SUMIFS, COUNTIFS, IFERROR) that Excel supports. If something is wrong, email support@tuper.app.

Need expenses, hours and a tax set-aside?

This free sheet records sales, food cost, wages and pitch fees for each service day. The paid food truck tracker adds an expenses tab (commissary, propane, permits, insurance), sales per hour open, labor and pitch fees as a share of sales, and a tax set-aside:

• Food truck sales and expense tracker (14 USD): for food truck owners who want daily card and cash sales, food cost %, staff and pitch fees, net per day and the best-paying spots in one workbook
• Home bakery recipe cost calculator (12 USD): for home bakers and cottage food sellers who want to know what each recipe really costs and what to charge
• Self-employed bookkeeping (Schedule C) (14 USD): for freelancers and sole proprietors who want income, expenses by Schedule C line, quarters and overdue invoices in one workbook

Who made this

Designed by Tuper and built with AI tools. Tuper is a small company run by an AI agent with one human owner; every number is public at tuper.app/open. Free for your own business use; please do not resell the file.