Restaurant Budget Template Excel: Prime Cost and Expenses

Quick Answer: A restaurant budget template in Excel is built around prime cost: food and beverage purchases plus all labor, measured against sales every week. Set up a daily sales sheet (sales by category, sales tax, tips, card versus cash), a monthly expenses sheet filled from supplier payments and processor deposits on your statements, and a budget-versus-actual tab that compares each cost to plan as a percentage of sales.

Restaurants fail on margins measured in a few percentage points, so a restaurant spreadsheet has to show costs as a share of sales, not just in dollars. The structure below fits a single location with one bank account and one card processor. It is free to build, and it tells you each week whether food, labor and occupancy are where you planned them.

What is prime cost, and why watch it first?

Prime cost is cost of goods sold (food, beverage, packaging) plus total labor (wages, payroll taxes, benefits). It is the largest controllable cost in most restaurants, which is why operators track it weekly.

Food cost for a period, done properly, adjusts for inventory:

Food cost = Opening inventory + Purchases − Closing inventory

Prime cost percentage = (Food and beverage cost + Labor cost) ÷ Net sales.

Your target depends on your concept, menu prices and rent. A quick-service counter, a full-service steakhouse and a coffee bar run very different splits. Rather than borrowing a benchmark, set your first budget from your own menu costing and staffing plan, then tighten it as real weeks come in.

Setting the first food budget from plate costs

Before you have a few months of history, the food line of the budget comes from your menu. Cost each dish from its recipe: a burger with a 6 oz patty at $0.62 an ounce ($3.72), a bun at $0.45, cheese, produce and sauce at $0.88, and fries at $0.70 comes to $5.75. On a $15 menu price that plate runs 38.3%. Do the same for your ten best sellers, weight each by how many you expect to sell from your POS mix (or your best guess before opening), and the weighted average is your starting food cost percentage. It will be lower than reality, because waste, staff meals and comps are not on any recipe card, so add a few points and replace the estimate with real weekly numbers as soon as you have them. When a supplier raises prices, update the recipe cost sheet the same week; it shows which plates need a new price before the month-end variance does.

The daily sales sheet

One row per day, closing out from your point-of-sale report:

Keeping sales tax and tips out of net sales matters: if they are mixed in, every cost percentage looks better than it is. Tips also come with rules for staff. The IRS tip recordkeeping and reporting page says employees must keep a daily record of tips and report cash tips to the employer by the 10th of the following month unless they total less than $20 for that month, and that service charges added to the bill are wages, not tips. Your payroll provider handles the withholding; the spreadsheet only needs to keep tips separate.

Expense categories for a small restaurant

Keep the list short enough to code every payment consistently:

1. Food purchases — broadline distributor, produce, meat, bakery
2. Beverage and alcohol purchases
3. Packaging and disposables
4. Labor — gross wages, employer payroll taxes, benefits, staffing agency
5. Occupancy — rent, common area charges, property tax if passed to you, insurance
6. Utilities — gas, electric, water, waste removal
7. Repairs and maintenance — hood cleaning, refrigeration service, pest control
8. Card processing fees
9. Technology — POS subscription, online ordering, reservations
10. Delivery platform commissions
11. Marketing
12. Smallwares and linens
13. Professional fees — bookkeeping, licenses, permits

Filling the monthly expenses sheet from statements

Almost every supplier is paid by bank transfer, check or card, so the statements are a complete record of what went out. Each month:

• Download the bank and card statements. Get them into spreadsheet rows, by CSV export if your bank offers it or with a converter for PDFs; QuickBankConvert is one option and gives date, description and signed amount for each line.
• Paste them into an Expenses tab and add a Category column. Distributor names repeat every week, so a lookup table of payee to category (your broadline distributor → Food purchases, the landlord's LLC → Occupancy) codes most rows automatically.
• Check the processor deposits against your daily sales sheet: card total minus fees and refunds should equal the deposit. A missing or short deposit is worth chasing the same day.
• Remove transfers between your own accounts and owner draws so they do not inflate expenses.

The general method for coding statement lines is in tracking business expenses from bank statements. The monthly total by category is then one formula per cell: =-SUMIFS(Expenses[Amount],Expenses[Category],$A5,Expenses[Month],C$2).

Note that statements show purchases, not food cost. For the true food cost figure you still need the opening and closing inventory counts from the formula above.

Building the budget-versus-actual tab

Lay each category as a row, with Budget %, Budget $, Actual $, Actual % and Variance. Budget dollars come from forecast sales times the budget percentage, so when sales swing, the budget flexes with them.

Example month, net sales $86,000:

The percentages are this restaurant's own plan, not a recommendation. What the sheet reveals: labor came in under, but food ran over by more than labor saved. The next step is the weekly food cost, item by item, to find whether it was price increases, waste or portioning.

Is a spreadsheet enough for accounting for a small restaurant business?

For budgeting and weekly cost control, yes. For the books themselves, most restaurants use accounting software connected to payroll, because payroll taxes, tip reporting and sales tax filings are easy to get wrong by hand. The spreadsheet then sits on top as the management tool. Whichever you use, the IRS recordkeeping guidance asks you to keep the documents behind the numbers: supplier invoices, POS reports, deposit records and statements.

If you are still on a spreadsheet for the books, the general ledger layout in a bookkeeping spreadsheet template pairs with this budget, and the business-wide view sits in a small business budget template. Mobile operators have a different cost mix built around events; see the food truck expense spreadsheet.

A weekly routine that keeps the sheet current

• Monday: close last week's daily sales rows; enter labor from the payroll report.
• Tuesday: count high-value inventory (proteins, alcohol) and compute weekly food cost.
• Mid-month: code bank and card lines to date.
• Month end: full inventory count, final coding, budget versus actual, and a note on the two biggest variances and what will change.