{"product_id":"restaurant-prime-cost-and-tip-tracker-spreadsheet-weekly-scorecard-tip-out-calculator-and-vendor-watch-google-sheets","title":"Restaurant Prime Cost and Tip Tracker Spreadsheet | Weekly Scorecard, Tip-Out Calculator and Vendor Watch - Google Sheets","description":"\u003cp\u003e\u003cstrong\u003eINSTANT DOWNLOAD — HOW IT WORKS:\u003c\/strong\u003e 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.\u003c\/p\u003e\u003cp\u003eWhat's your prime cost this week?\u003c\/p\u003e\n\u003cp\u003eNot 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.\u003c\/p\u003e\n\u003cp\u003eAnd 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.\u003c\/p\u003e\n\u003cp\u003eTransparency note: this spreadsheet was designed with AI assistance, then hand-built and formula-tested by our shop.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eWHAT'S INSIDE — 8 focused tabs:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003e- \u003cstrong\u003eStart Here\u003c\/strong\u003e — a plain-English guide, quick-start steps, and the prime-cost math explained\u003cbr\u003e- \u003cstrong\u003eDashboard\u003c\/strong\u003e — the latest week at a glance, all-weeks totals, your best and worst weeks, and the watch list\u003cbr\u003e- \u003cstrong\u003eWeekly Scorecard\u003c\/strong\u003e — the hero: every week's food %, beverage %, labor %, and prime cost %, flagged OVER TARGET or ON TARGET against targets you set\u003cbr\u003e- \u003cstrong\u003eSales \u0026amp; Purchases Log\u003c\/strong\u003e — the weekly inputs in one row: food and beverage sales, food and beverage purchases, labor cost\u003cbr\u003e- \u003cstrong\u003eInventory Count\u003c\/strong\u003e — weekly shelf counts that turn purchases into true COGS — what you bought but didn't use never inflates your food cost\u003cbr\u003e- \u003cstrong\u003eTip-Out Calculator\u003c\/strong\u003e — split any tip pool by role points and hours worked, rounded to the cent per person, with any penny of rounding shown\u003cbr\u003e- \u003cstrong\u003eVendor Price Watch\u003c\/strong\u003e — first logged price vs. current price on your key items; increases over your threshold flag themselves as PRICE CREEP\u003cbr\u003e- \u003cstrong\u003eExpenses \u0026amp; P\u0026amp;L\u003c\/strong\u003e — rent, utilities, repairs, and other operating costs by category, with the monthly P\u0026amp;L — sales, prime cost, other expenses, and net by month — pulled automatically from the Scorecard and the expense log\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eHOW IT WORKS\u003c\/strong\u003e\u003cbr\u003e1. After checkout you get a PDF with your private link. Click it and choose \"Make a copy\" — the tracker is yours.\u003cbr\u003e2. Each week, enter one row on the Log and one count on Inventory Count. The Scorecard does every calculation.\u003cbr\u003e3. Run the tip-out at week's end, glance at the Dashboard, and check Vendor Price Watch once a month.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eTHE MATH, PLAIN AND SIMPLE\u003c\/strong\u003e\u003cbr\u003eCOGS 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 \u0026amp; 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.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eTHE TIP SPLIT, PLAIN AND SIMPLE\u003c\/strong\u003e\u003cbr\u003ePoints 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.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eWHY THIS ONE\u003c\/strong\u003e\u003cbr\u003eThe 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.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003ePLEASE READ:\u003c\/strong\u003e 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.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eREQUIREMENTS:\u003c\/strong\u003e 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.\u003c\/p\u003e\n\u003cp\u003eThis 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.\u003c\/p\u003e\n\u003cp\u003eFINISHED 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.\u003c\/p\u003e","brand":"InkSheet Studio","offers":[{"title":"Default Title","offer_id":68084221083933,"sku":null,"price":2.69,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1015\/0618\/7549\/files\/01-hero_097abdbb-1296-4ad3-94bd-638653f0960c.jpg?v=1794705526","url":"https:\/\/inksheetstudio.com\/products\/restaurant-prime-cost-and-tip-tracker-spreadsheet-weekly-scorecard-tip-out-calculator-and-vendor-watch-google-sheets","provider":"InkSheet Studio","version":"1.0","type":"link"}