Skip to product information
1 of 8

InkSheet Studio

Restaurant Prime Cost and Tip Tracker Spreadsheet | Weekly Scorecard, Tip-Out Calculator and Vendor Watch - Google Sheets

Restaurant Prime Cost and Tip Tracker Spreadsheet | Weekly Scorecard, Tip-Out Calculator and Vendor Watch - Google Sheets

Regular price $2.69 USD
Regular price $9.99 USD Sale price $2.69 USD
Sale Sold out
Quantity

INSTANT DOWNLOAD — HOW IT WORKS: This is a digital download, not a physical product — nothing is shipped. After checkout, your download link appears right on the confirmation page and is also emailed to you. Use the files in your favorite apps and projects, or print the PDF files at home or at a local print shop.

What's your prime cost this week?

Not last quarter. Not "roughly." This week. Prime cost — food, beverage, and labor against sales — is the one number independent restaurant owners are told to check every single week, and the one most check never, because the math is scattered across invoices, shelf counts, and a POS report. This tracker puts the whole review on one scorecard: log the week, count the shelves, and food %, beverage %, labor %, and prime cost % appear, flagged against your own targets. One over-target week can't hide anymore.

And when the shift ends, the same file settles the tip pool: set the pool, list who worked and their hours, and it splits by role points to the cent — no more calculator arguments at the pass.

Transparency note: this spreadsheet was designed with AI assistance, then hand-built and formula-tested by our shop.

WHAT'S INSIDE — 8 focused tabs:

- Start Here — a plain-English guide, quick-start steps, and the prime-cost math explained
- Dashboard — the latest week at a glance, all-weeks totals, your best and worst weeks, and the watch list
- Weekly Scorecard — the hero: every week's food %, beverage %, labor %, and prime cost %, flagged OVER TARGET or ON TARGET against targets you set
- Sales & Purchases Log — the weekly inputs in one row: food and beverage sales, food and beverage purchases, labor cost
- Inventory Count — weekly shelf counts that turn purchases into true COGS — what you bought but didn't use never inflates your food cost
- Tip-Out Calculator — split any tip pool by role points and hours worked, rounded to the cent per person, with any penny of rounding shown
- Vendor Price Watch — first logged price vs. current price on your key items; increases over your threshold flag themselves as PRICE CREEP
- Expenses & P&L — rent, utilities, repairs, and other operating costs by category, with the monthly P&L — sales, prime cost, other expenses, and net by month — pulled automatically from the Scorecard and the expense log

HOW IT WORKS
1. After checkout you get a PDF with your private link. Click it and choose "Make a copy" — the tracker is yours.
2. Each week, enter one row on the Log and one count on Inventory Count. The Scorecard does every calculation.
3. Run the tip-out at week's end, glance at the Dashboard, and check Vendor Price Watch once a month.

THE MATH, PLAIN AND SIMPLE
COGS is not just purchases: food COGS = purchases + last week's count − this week's count. Prime cost = food COGS + beverage COGS + labor. In the fictional sample restaurant (Maple & Main Kitchen), five of six weeks run 57–59% prime — and the week ending Sep 27 flags OVER TARGET at 68.0%, naming food, beverage, AND labor as the costs that ran hot, so you know exactly where to look. If a log row or a count is missing, the row says CHECK INPUTS instead of quietly showing a wrong number.

THE TIP SPLIT, PLAIN AND SIMPLE
Points are yours: the samples run servers at 1.0, bartenders at 0.8, hosts and bussers at 0.5, runners at 0.4. In the sample week, a $1,842 pool splits across 8 staff — the lead server's 32 hours come out to $376.64 — and the sheet shows the exact rounding, down to the cent.

WHY THIS ONE
The established restaurant spreadsheets on Etsy are Excel workbooks and six-file bundles. This is one Google Sheets file, built around the weekly rhythm independents actually run: scorecard first, tip-outs built in, vendor price-creep flags included. It comes loaded with six fictional sample weeks so you can watch every flag fire before you replace them with your own numbers.

PLEASE READ: This is an organization and calculation tool. It is not payroll, tax, or legal advice, and it does not tell you what to pay anyone. Tip pooling, tip-out, wage, and overtime rules vary by state and city — follow your local rules and check with your accountant or payroll provider. The sample targets (food 32%, beverage 25%, labor 30%, prime 60%) are common starting points, not prescriptions.

REQUIREMENTS: a free Google account. Your tracker lives in Google Sheets — no Excel needed, and it works in the office, on the line, and on your phone.

This is a digital product — no physical item will be shipped, and all sales are final (we can't accept returns or cancellations on digital downloads). Your files are available instantly after checkout. But don't worry: if anything isn't working right, message us anytime and we'll fix it for you — no time limit.

FINISHED FILE — PLEASE READ: This listing is for the finished file exactly as shown — nothing is customized, personalized or revised. If anything prints wrong or you find an error in a file, message us and we will fix it — error fixes are always free, with no time limit.

View full details