From a shoebox of invoices to a P&L you'd act on
The minimum data set that produces a real operating P&L for an independent restaurant, and the order to build it in.
Most independents have a P&L. It arrives from the bookkeeper somewhere between the 15th and the 25th, it is accurate, and it changes nothing, because by then the month is gone. An operating P&L is a different document: slightly less precise, available now, and specific enough to act on this week.
The minimum data set
- Every purchase invoice, coded to a category. This is the piece people skip, and it is the piece that makes the rest work.
- Daily net sales, split at least into food and beverage.
- Labour hours and cost by day, from payroll or the schedule.
- An inventory count at period start and end. Even a rough count of the top 20 items by value beats none.
- Fixed costs, entered once: rent, insurance, utilities, subscriptions, debt service.
The order to build it
Start with invoices, because purchases are the largest variable line and the hardest to reconstruct later. Add daily sales next — fifteen seconds a day, or a CSV from the POS. Add labour third. Do inventory counts last, and only for high-value items at first. Each step makes the P&L more accurate; the first step alone already tells you about price increases and category drift.
Theoretical vs actual is where the money hides
Once you have recipes and sales, you can compare what your food cost should have been against what it was. The gap is waste, theft, over-portioning, or a costing error — and naming which one is a conversation, not a report.