How do I track inventory for a restaurant?
Restaurant inventory tracking doesn’t require counting every ingredient daily. Most restaurants do well with weekly counts of high-value and high-volume items combined with monthly full counts. The goal is knowing your food cost percentage and catching problems before they eat your margins.
Start with a master inventory list organized by storage location. Walk-in cooler items together, dry storage together, bar inventory separate. This makes counting faster and more accurate because you’re not jumping between areas. Count the same items at the same time each week, ideally when inventory is relatively low. Sunday night or Monday morning before deliveries works for most places.
Calculate your food cost percentage after each count. Take beginning inventory plus purchases minus ending inventory to get cost of goods sold. Divide that by food sales for the period. Most restaurants should run between 28% and 35% food cost depending on concept. Fine dining runs higher. Pizza and pasta concepts typically run lower.
Compare actual food cost to theoretical food cost when possible. Your theoretical cost is what you should have used based on recipes and sales. If your menu says a burger uses 6 ounces of beef and you sold 200 burgers, you should have used 75 pounds. The gap between theoretical and actual is waste, theft, over-portioning, or counting errors. High-variance items need attention. If prime rib is consistently 15% off but chicken runs at 2%, you know where to focus.
Your POS system probably has inventory features you’re not using. Most modern systems can track theoretical usage based on sales. The data isn’t perfect but it’s useful for spotting trends. Dedicated inventory software like MarketMan or BlueCart works well if you’ll actually use it consistently.
For bookkeeping purposes, inventory counts feed directly into cost of goods sold. Your monthly books should reflect actual inventory values, not estimates. This makes your profit and loss statements accurate and helps with tax planning. A bookkeeping service familiar with restaurants can set up your chart of accounts so inventory and COGS flow correctly.
Don’t overcomplicate the system. A spreadsheet works fine for most independent restaurants. The discipline of counting regularly matters more than the sophistication of your software. If you’re not reviewing the numbers weekly and asking why food cost spiked, you’re not actually managing inventory. You’re just counting things.
San Diego's Small Business Bookkeeper
The Next Step:
A Short Conversation
A quick call to tell us about your business. We'll listen, answer your questions, and give you a clear price quote.
More Questions
What is COGS for a restaurant?
COGS (cost of goods sold) represents the direct cost of food and beverages you sell to customers. It includes everything that becomes a menu item but excludes labor, rent, and other operating expenses.
Read answerWhat is the difference between direct and indirect costs?
Direct costs can be traced to a specific job, product, or project. Indirect costs support the business overall but can't be assigned to one job. Understanding this distinction is essential for accurate pricing and knowing whether individual projects are actually profitable.
Read answerWhat happens if I miss a sales tax filing?
Missing a sales tax filing triggers penalties and interest that grow the longer you wait. In California, you'll face a 10% late filing penalty plus interest on unpaid amounts. The best move is to file as soon as possible, even if you can't pay the full amount immediately.
Read answerWhat is double-entry bookkeeping?
Double-entry bookkeeping records every transaction in two accounts, with one side balancing the other. This method provides built-in error checking and produces the financial statements businesses need for taxes, loans, and decision-making.
Read answerWhat is the chart of accounts and how do I set one up?
A chart of accounts is the list of categories where your business transactions get recorded. Most accounting software includes a template based on your industry, so you customize that rather than building from scratch.
Read answerCan I use QuickBooks for job costing?
Yes, QuickBooks Online handles job costing through its Projects feature. The software tracks costs and revenue by job, but proper setup determines whether your reports actually show project profitability.
Read answer