Browse templates →

Restaurant Bookkeeping Template

Track the numbers that decide a restaurant month: plate cost, labor, daily sales, prime cost, and the monthly profit left after every operating cost.

Prime costfood cost + labor, reviewed weekly
$49Restaurant Profit & Food Cost Tracker
Daily + monthlysales detail and P&L in one workbook

Restaurant bookkeeping is a weekly operating system

A restaurant does not discover its profit at tax time. It creates that profit in purchasing, portioning, scheduling, and daily sales discipline. Bookkeeping should therefore separate food cost, labor, and the monthly P&L while they can still be changed. Prime cost—food cost plus labor—is the number to watch weekly because those are the costs management most directly controls.

The Restaurant Profit & Food Cost Tracker is built around that rhythm. It connects menu-item costs, daily sales, a labor roster, and a monthly P&L, then summarizes sales, covers, average spend, food and labor cost, prime cost, net profit, best and worst days, and the highest-margin and highest-cost dishes.

A restaurant bookkeeping workflow that works

Keep daily entry brief and consistent. The workbook uses the blended food-cost percentage from the menu sheet for daily food cost and spreads monthly labor across logged days, so the month can be reviewed without recreating every number by hand.

  1. Price each dish from its plate cost. Enter ingredients only, menu price, food-cost percent, and margin. Dishes over your target food-cost percent are flagged, with a suggested price at that target.
  2. Log daily sales and covers. Record food and beverage sales, food cost, labor, daily profit, and margin for every operating day.
  3. Maintain the labor roster. Enter each employee’s wage and weekly hours. The workbook calculates weekly and monthly wages, payroll taxes and benefits, total labor cost, labor percent, and labor per cover.
  4. Review prime cost weekly. Add food and labor, then divide by sales. Investigate purchasing, waste, portioning, and scheduling before the month closes.
  5. Close the monthly P&L. Review covers, sales, food cost, labor, rent, utilities, and other expenses by month, with net profit and margin calculated from the working sheets.
  6. Act on the dashboard. Compare best and worst days, average spend per cover, and the dishes with the highest margin and highest cost before changing the menu.

Prime cost, using the course example

In the Restaurant course example for October, food cost was $16,582.15 and labor was $21,150.83. Prime cost was therefore $37,732.98, or 50.0% of sales—below the common “under 60%” watch line used in the lesson. The percentage matters more than either dollar amount alone because a busy month can spend more and still be better controlled.

What this tracker does—and does not do

It is a focused profit workbook, not a point-of-sale system or a full accounting ledger. Enter sales and cost information consistently, reconcile the monthly totals to your records, and use the dashboard for management decisions. It does not need to replace the restaurant’s POS reports; it turns them into a monthly profit picture.

  • Do not judge food cost without labor.
  • Do not average away a bad week inside a good month.
  • Do not reprice a dish before checking its plate cost.

Get the Restaurant Profit & Food Cost Tracker

The $49 workbook includes Menu Items and Food Cost, Daily Sales, Labor, Monthly P&L, and a Dashboard. It works in Excel and Google Sheets; yellow cells are the only cells you edit.

Frequently asked questions

What is prime cost?

Prime cost is food cost plus labor cost. As a percentage, divide that total by sales and review it weekly.

Can the workbook suggest a menu price?

Yes. For each dish, it calculates a suggested price at your target food-cost percentage and flags dishes above target.

Does it track daily profit?

Yes. The Daily Sales sheet records covers, food and beverage sales, food cost, labor, daily profit, and margin.

Guides

Restaurant Bookkeeping: The System That Actually Gets Done · Restaurant Break-Even: How Many Covers Cover Your Costs?