Restaurants do not lose money monthly — they lose it weekly, one unlogged invoice and one over-portioned special at a time. This tracker runs on the restaurant's real clock: the week, closed before the next order goes in.
The defining feature of restaurant spending is speed. Food arrives daily, labor is scheduled weekly, and cash leaves through a dozen small channels — a produce top-up here, a linen shortage there, a plumber on a Saturday. A monthly expense summary can describe that spending, but it arrives too late to change any of it.
The second distortion is netted money. Card batches and delivery payouts arrive after fees are removed, so an owner who records only deposits understates both sales and fee expense. The tracker insists on gross figures: record the sale at full value and the fee as its own expense row, and the true cost of each channel stays visible.
The rhythm is daily capture, weekly close — nothing here needs more than a few minutes a day.
The categories follow the path of a dollar through a restaurant — goods in, service delivered, money settled — so the weekly percentages assemble themselves.
Food purchases. Proteins, produce, dairy, dry goods, and bakery bought for menu production. This is the numerator of food cost, kept clean of anything not eaten or drunk.
Beverage purchases. Alcohol, coffee, tea, juices, and soft drinks, tracked apart from food because beverage cost percentages run on different targets.
Disposables and paper. To-go containers, napkins, straws, gloves, and foil — costs that surge with takeout volume and vanish if lumped into food.
Linen and laundry service. Table linen, uniforms, and towel service, or in-house laundry costs if you run your own machines.
Kitchen labor. Cooks, prep, and dish wages plus employer taxes — the production half of prime cost.
Front-of-house labor. Servers, hosts, bartenders, and bussers, recorded separately because scheduling levers differ from the kitchen's.
POS, card, and delivery fees. Point-of-sale subscriptions, card processing percentages, and delivery marketplace commissions, each visible as the cost of its channel.
Repairs and small equipment. Refrigeration call-outs, smallwares replacement, and equipment servicing — irregular, but large enough to deserve their own trend line.
Rent, utilities, and occupancy. The fixed floor: rent, gas, electric, water, trash, and insurance, entered monthly and spread across weeks for the close.
Food cost percentage is only as honest as its inputs, and its inputs are purchases and inventory counts — both of which live in this tracker. The weekly discipline above produces the formula's pieces automatically: opening count, plus the week's food rows, minus the closing count, divided by food sales. When the percentage jumps, the tracker lets you ask whether purchases spiked, counts fell, or sales mix shifted, instead of guessing in the walk-in.
Prime cost — food, beverage, and all labor together — is the number to tape inside the office door. Because the tracker collects labor by department in the same weekly view, prime cost is a Friday calculation rather than a quarterly revelation, and schedule or menu changes can be judged against it within a week of making them.
A 48-seat bistro records a typical week with $13,940 in gross sales (including delivery apps at full value). The week's tracker rows:
The tracked rows total $4,918. Food and beverage purchases of $2,658 against the week's sales frame the starting point for food cost once inventory change is counted. Delivery commissions of $391 — invisible in netted deposits — are now a line the owner can weigh against the delivery channel's sales before renewing the app's terms.
| Category | Amount |
|---|---|
| Food purchases | $2,146 |
| Beverage purchases | $512 |
| Disposables and paper | $164 |
| Linen service | $96 |
| Kitchen labor with taxes | $1,185 |
| POS and card fees | $238 |
| Delivery-app commissions | $391 |
| Small equipment and a faucet repair | $186 |
| Total tracked | $4,918 |
The system has to work on a Friday night, not just in a quiet office:
The Restaurant Profit and Food Cost Tracker is built around this weekly rhythm — food cost, prime cost, and channel fees in Excel and Google Sheets, with the categories on this page pre-loaded.
Because a restaurant's two biggest costs are set weekly — the order and the schedule. Monthly tracking describes losses after both decisions have repeated four times; weekly tracking interrupts them.
Split it into category rows at entry using the invoice's own line items. The broadline distributor already itemizes the cases; the split takes a minute at delivery and saves an hour of guessing later.
Keep them out of food cost and in their own fee category. Food cost should measure the kitchen's purchasing and portioning; commissions measure a sales channel. Combining them corrupts both readings.
Some links below are affiliate links. If you buy through them, Vickery Finance may earn a small commission at no extra cost to you.
QuickBooks for Restaurants — Zachary Weiner — bookkeeping and accounting set up the way restaurants actually run.
Adams Guest Check Pads, 2-Part Carbonless, 10-Pack — for restaurants and food trucks: order pads that leave a copy for the kitchen and the books.
Panda Planner Pro A4, Black — the large-format six-month Panda Planner for desk-based planning.
Casio fx-991ES Plus, 2nd Edition — Casio's full scientific calculator for statistics and formula-heavy work.
More books and gear live on the Resources page.