All templates Free template · Excel · Food truck

The free food truck daily P&L template.

Every service is a different pitch, a different crowd, a different result. Log today’s takings, food cost, staff, fuel and pitch fee — the sheet returns today’s profit and, over a month, shows you which spots are worth going back to.

Direct .xlsx download · no email required · Excel, Google Sheets, LibreOffice & Numbers

Sheet 1

Start here

Tax rate, card fee, monthly fixed costs (loan or lease, insurance, commissary, licences) and how many service days a month — set once.

Sheet 2

Daily P&L

Food-truck columns: cash and card takings, food cost, staff today, fuel & pitch fee, other variable costs, plus a pitch/location note → EBIT per service.

Built in

Pitch note column

Tag each day with where you parked. A month later, sort by profit and the good pitches — and the ones costing you fuel for nothing — are obvious.

A food truck’s P&L is a per-service question

A restaurant asks whether the month paid. A food truck asks whether this pitch, today, paid — because tomorrow you might be twenty miles away in front of a different crowd. Fuel to get there, the pitch fee to stand there, the staff you brought, the stock you prepped: all of it lands on one service, and the honest question is whether that service cleared it.

This template is built around that. Each row is a service, tagged with where you parked. Fuel and pitch fees get their own line because for a truck they’re not overhead — they’re a direct cost of choosing that spot, and they’re exactly what a fixed-location P&L forgets to charge you.

The pitch note is the whole point

The single most valuable thing a food-truck owner can know is which pitches make money — and it’s almost impossible to feel accurately, because a busy-feeling service with a €40 pitch fee and an hour of diesel can lose to a quiet one round the corner for free. Memory won’t tell you; a month of tagged rows will.

So every day you note the location. After a few weeks, sort the sheet by EBIT and the pattern is undeniable: the markets worth booking, the office parks that only work on paydays, the festival that took a third of the gate in fees. That one column turns a month of hard days into a booking strategy for the next month.

How to use it (after you close the hatch)

Once: in Start here, set tax rate, card fee, your monthly fixed costs (truck finance, insurance, commissary kitchen, licences) and how many days a month you actually trade. Trucks trade fewer days than shops, so getting the day count right matters — it sets how much fixed cost each service carries.

Every service: enter takings cash and card, today’s food cost, staff paid, fuel and pitch fee, and the location. The sheet nets tax and card fees, subtracts costs and the day’s fixed slice, and shows whether the pitch paid — and the running month so a strong Saturday doesn’t hide three weak weekdays.

Working out whether a new pitch or a price is worth it? The free break-even calculator tells you the takings a service needs to clear before you commit to the spot.

Fewer trading days, so the number matters more

A truck that trades ten days a month can’t afford a blind one the way a seven-day café can. With fixed costs spread across fewer services, every dead pitch is expensive, and every good one has to carry more than its own weight. That’s exactly why a daily — really a per-service — profit number earns its place faster for a truck than almost any other business.

The spreadsheet does this well and costs nothing. When you’d rather log a service from your phone in the cab before you drive off — and keep the location history without maintaining the file — nouz runs the same per-service P&L. See it on sample data in the demo first; no account, no card.

Free and ungated?

Yes — direct .xlsx download, no email, no form. Opens in Excel, Google Sheets, LibreOffice or Numbers.

Why is there a fuel and pitch-fee line?

Because for a truck they’re a direct cost of choosing a location, not general overhead — the thing a fixed-shop template never charges you. Keeping them on their own line is what lets you compare pitches honestly.

How does the pitch/location note help?

Tag each service with where you parked, then after a month sort by profit. The pitches that pay — and the ones that only felt busy — separate out clearly, which turns into a smarter booking calendar.

My days open per month varies a lot — does that break it?

Set the Start here day count to your realistic monthly average of trading days. Fixed costs get sliced across that number, so each service carries a fair share. If a month runs unusually light or heavy, adjust the count for that month.

Can I track more than one truck?

This sheet is built for one truck to keep entry fast. For a second truck, copy the file. If you’re running a small fleet, that’s the point where an app that keeps every truck’s daily P&L together saves you a folder of spreadsheets.

Or skip the spreadsheet.

nouz runs the same daily P&L — formulas, fixed-cost slicing and history handled — for your food truck. See it working with sample data first; no account needed.

Open the live demo