Restaurant Profit Tracker Excel with food cost calculator, menu pricing, labor cost, and a monthly P and L dashboard. Know what every dish actually costs — and whether the month actually made money. Built for…
About this template
Restaurant Profit Tracker Excel with food cost calculator, menu pricing, labor cost, and a monthly P and L dashboard. Know what every dish actually costs — and whether the month actually made money. Built for restaurant, cafe, and food truck owners who need to know, dish by dish and day by day, whether the price covers the plate and the payroll — without accounting software. If a dish is losing money, this workbook flags it before the next menu print.
$49
Excel & Google Sheets template — instant download on Etsy
Menu Items and Food Cost — plate cost (ingredients only), menu price, food cost percent, margin in dollars and percent, and a suggested price at your target food cost percent for every dish. Dishes over target are flagged. Change a plate cost or a price and the whole workbook follows.
Daily Sales — date, covers, food and beverage sales, food cost, labor, daily profit, and margin for every day. Food cost uses the blended food cost percent from the menu sheet; labor is the monthly labor cost from the Labor sheet spread across the days logged.
Labor — staff roster with hourly wage and hours per week, weekly cost, monthly wages, payroll taxes and benefits as a percent, total monthly labor cost, labor cost percent, and labor cost per cover.
Monthly P and L — covers, food and beverage sales, food cost, labor, rent, utilities, and other expenses by month, Jan-Dec, with net profit, margin, food cost percent, and labor cost percent. All formulas from sheets 1 to 3.
Dashboard — total sales, covers, average spend per cover, food and labor cost, prime cost, net profit and margin, best and worst days, and your highest-margin and highest-cost dishes.
Cover and How to Use — start here. Yellow cells are the only ones you edit.
Try the headline numbers for a typical month. The full template does this job by job with a monthly P&L and dashboard.
Frequently asked questions
What does the Restaurant Profit & Food Cost Tracker track?
The Restaurant Profit & Food Cost Tracker tracks Menu Items and Food Cost; Daily Sales; Labor; Monthly P and L; Dashboard.
What do the example numbers show?
The included example shows: Total sales 75,534 (food 60,621, beverage 14,913) from 3,052 covers; average spend per cover 24.75.
Does it work in Excel and Google Sheets?
Yes. The workbook works in Microsoft Excel and in Google Sheets (upload the .xlsx file to Google Drive to open it in Sheets). It is an instant digital download from Etsy — no physical item is shipped.
This template is a bookkeeping and planning tool only — not tax, legal, or CPA advice. Built by an accountant: B.S. Accountancy, ASU W. P. Carey.
VickeryFinance — “Know your numbers — without the accounting software.”
Gear that pairs with this tracker
Some links below are affiliate links. If you buy through them, Vickery Finance may earn a small commission at no extra cost to you. We only list gear genuinely used in this trade.