This weekend — through Sunday at 11:59 PM: BUNDLE-NOV21 takes 10% off the Practice in a Box + Everything Vault bundle. VAULT-NOV21 takes 15% off the Everything Vault. WEEKEND15 takes 15% off everything else, and the new Close the Month + Close the Year bundle is $149.
Browse templates →

Restaurant Expense Tracker: The Weekly View That Protects Margin

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.

9 categoriesorganized around the weekly close
$4,918tracked costs in the worked week
Weeklybecause food cost will not wait a month

Why restaurant expenses need their own system

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.

How to track restaurant expenses, step by step

The rhythm is daily capture, weekly close — nothing here needs more than a few minutes a day.

  1. Enter every supplier invoice the day it is delivered. Food, beverage, and dry goods each get their own row with the vendor and amount. Checking the delivery against the invoice at the door catches short shipments while they can still be credited.
  2. Split mixed invoices at entry, not at month-end. Restaurant-specific rule: a broadline delivery containing food, disposables, and chemicals is three expenses wearing one invoice number. Split it into the three categories while the cases are still on the counter.
  3. Record delivery-app statements gross each week. Enter total app sales as revenue and the commission as an expense row. The tracker then shows what the delivery channel truly contributes after its percentage is taken.
  4. Log payroll by department when the schedule posts. Kitchen, front of house, and management wages go in as separate weekly lines, with employer taxes attached, so labor percentage can be read alongside food cost as prime cost.
  5. Count key inventory weekly before ordering. Proteins, dairy, and top produce items get counted before the big weekly order. Purchases minus inventory change is what the kitchen actually consumed — the only honest food-cost numerator.
  6. Close the week with three percentages. Food cost, labor, and prime cost for the week, written next to the same weeks last month. Trends in these three lines are the earliest warning system a restaurant has.

Nine restaurant expense categories for the weekly tracker

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.

From expense rows to food cost you can trust

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.

Worked example: one week at a neighborhood bistro

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.

CategoryAmount
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

Restaurant tracking habits that survive a busy service

The system has to work on a Friday night, not just in a quiet office:

  • Keep a single invoice tray at the pass; nothing enters the office until it has been checked against what was actually delivered.
  • Photograph the weekly inventory count sheet — counts taken on paper and entered later are where food cost goes to be approximated.
  • Enter the delivery-app statement on the day it issues, while the week's service is still memorable enough to spot anomalies.
  • Give every recurring fee — POS, linen, pest control — a standing row so a missed or doubled charge stands out in the weekly list.

Track the week in a restaurant-ready workbook

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.

Frequently asked questions

Why track weekly instead of monthly like other businesses?

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.

How do I handle an invoice that covers food and supplies together?

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.

Do delivery commissions belong in food cost?

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.

Gear we use

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.