Most GMs know what a good inventory count looks like. The problem is building the habit around it: a consistent day, a consistent method, and a sheet organized the way your storage areas actually are, not the way a generic spreadsheet template was designed.
This template is the starting point. It covers the weekly count, the food cost calculator, and a basic actual vs. theoretical tracker, in one file, ready to use this week.
What is included in the template
The template is a Google Sheets file with four tabs. Each one does a specific job.
Tab 1. Weekly count sheet: Organized by storage area rather than alphabetically. Walk-in cooler, dry storage, freezer, and bar each have their own section so the GM can walk the count in order, not back and forth across the kitchen. Columns include item name, unit of measure, par level, count quantity, unit cost, and a calculated extension. A notes column captures anything unusual: short delivery, damaged product, suspected spoilage.
Tab 2. Food cost calculator: Pulls from Tab 1 to compute your cost of goods sold and food cost percentage for the week. Enter your beginning inventory value, purchases received, and ending inventory count. The tab calculates COGS and your weekly food cost percentage automatically, no manual math. The formula: (Beginning Inventory + Purchases - Ending Inventory) / Food Revenue x 100 = Food Cost %. Most casual dining and fast casual operators target 28 to 35% (National Restaurant Association, 2025 Restaurant Operations Data Abstract). If your number is running above that consistently, the count itself is not the problem. The AvT tab tells you where to look next.
Tab 3. Actual vs. theoretical (AvT) tracker: Category-level AvT is where the biggest dollar variances hide. Proteins running 3 percentage points over theoretical is a $400 problem this week. The tab surfaces that in under five minutes, comparing what you should have used against what the count shows you actually used, by category. Item-level AvT tracking requires integrated software.
Instruction tab: A plain-English walkthrough of how to set up the template for your location, how to run the weekly count, and how to read the food cost and AvT outputs. New team members can onboard without additional training.
How to use the template
Setup takes about 30 minutes the first time. Add your standard inventory items by storage area, enter their unit costs (update these when invoices change), and set par levels based on your typical usage and ordering schedule.
After that, the weekly count takes 45 to 90 minutes depending on location size. Count at the same time every week. Sunday night before close and Monday morning before first delivery are the two most common schedules. Consistency in timing is what makes week-over-week comparison meaningful. A count done Monday one week and Wednesday the next produces variance that reflects scheduling, not operations.
After the count, open Tab 2, update the beginning inventory, purchases, and ending count values, and your food cost percentage calculates automatically.
If your food cost percentage runs more than 2 percentage points above target two weeks in a row, check these three things first: your ending count accuracy, your last delivery against the invoice, and your highest-cost category in Tab 3. Nine times out of ten, the answer is in one of those three places.
Who this template is built for
GMs and unit managers who are currently counting on clipboards, in personal notes, or on a spreadsheet they built themselves. This template replaces all of that with one organized, consistent system. The time savings come from better organization, not less thoroughness.
Owner/Franchisees managing a small portfolio who want to standardize the count process across locations. Each location gets its own copy. When every GM is using the same structure, the numbers they send back are calculated the same way, which means your ops call can ask "why is location 7 running 35%?" and get a real answer, not five different spreadsheets.
A note for operators managing multiple locations
When the manual reconciliation across locations takes more time than the counts themselves, the template has done its job. That usually happens somewhere between 5 and 15 locations depending on how actively the food cost data is being used.
Rosnet customers typically start with a process similar to this one. They use it to build count discipline, verify that their basic food cost calculations are accurate, and get clear on what they need to see at scale. Our customers currently span 204 companies and 5,281 locations. The ones running the most efficient operations share one habit from their manual days: they counted consistently, at the same time, every week, before they had software to do it for them. When you are ready to automate the count, connect it to your POS and supplier invoices, and see food cost and AvT by item and by location in real time, that is what Rosnet is built for.
Frequently asked questions
What format is the template? Google Sheets. You will receive a link to make your own copy after submitting the form. An Excel version is available on request, email the address in the confirmation and we will send it within one business day.
Can I use this template for multiple locations? Yes, with one copy per location. There is no built-in consolidation across stores. For cross-location food cost comparison and AvT reporting in a single view, you need an integrated platform rather than a manual template.
How often should I run a full inventory count? Weekly is standard for most operators. High-cost categories like proteins are often counted daily or at the start and end of each shift. The count sheet supports both approaches.
What is actual vs. theoretical food cost? Actual food cost is what you spent. Theoretical food cost is what you should have spent based on your recipes and what the POS says you sold. The gap between them, called AvT variance, is where waste, over-portioning, and receiving discrepancies appear. Tab 3 of this template tracks that variance at the category level. Rosnet's platform tracks it at the item, location, and shift level in real time.
When does this template stop being enough? When the manual reconciliation across locations takes more time than the counts themselves. Most operators hit that wall somewhere between 5 and 15 locations. At that point, the discipline you built on the template transfers directly to how you use an integrated system.
