How do I track food cost percentage at the end of each week using QuickBooks?
The formula is Beginning Inventory + Purchases - Ending Inventory = Cost of Goods Sold. Then divide COGS by your food revenue for the same period. That gives you your food cost percentage. Most restaurants should fall between 28% and 35%, though your target depends on your concept and pricing. The important part is doing this every week, not once a month, because waiting 30 days to discover a problem means you’ve already bled margin for four weeks straight.
In QuickBooks, start by making sure your chart of accounts separates food purchases from other expenses. You want a dedicated Cost of Goods Sold account for food, and ideally separate ones for beverages and paper goods if those are significant. Your revenue accounts should also separate food sales from bar sales so you can calculate each percentage independently. Lumping everything together hides where the real issues are.
The weekly workflow starts with a physical count. Every week on the same day, someone counts what’s in the walk-in, the freezer, dry storage, and the line. You don’t need to count every last item to the ounce. Focus on the high-value categories that move the needle: proteins, seafood, dairy, and produce. Assign dollar values based on your most recent invoice prices and total it up. That’s your ending inventory for the week and your beginning inventory for next week.
Record your ending inventory value in QuickBooks using a journal entry. Debit the inventory asset account for the new count value and credit it for the old value, with the offset going to your food COGS account. Then make sure all food purchases for the week are entered and categorized correctly. Pull your food revenue from your POS system and confirm it matches what’s in QuickBooks. Now you can run the calculation.
Build a simple spreadsheet alongside QuickBooks if the reporting feels clunky. List each week with beginning inventory, purchases, ending inventory, COGS, food revenue, and the resulting percentage. Trends matter more than any single week. One week at 33% isn’t alarming. Three consecutive weeks creeping from 30% to 34% to 37% tells you something changed and you need to find out what.
Common causes of rising food costs include portion creep, waste that isn’t being tracked, vendor price increases that went unnoticed, and theft. Weekly tracking lets you investigate while the details are still fresh. If your food cost jumped this week, you can check receiving logs, look at what was 86’d, and talk to the kitchen while people still remember what happened.
If you need help getting QuickBooks configured for inventory accounting in a restaurant setting, the setup matters more than most people realize. A generic chart of accounts won’t give you the reporting you need. And if your books are already behind or messy, getting caught up first is essential before weekly tracking will mean anything. Zacosta Bookkeeping provides inventory accounting in Orlando with the kind of food and beverage finance background that understands how restaurants actually operate, not just how the software works.
Central Florida's Trusted Bookkeeping Firm
Start Here:
A 30-Minute Consultation
Tell us about your business and what's going on with your books. We'll figure out exactly what you need, and give you a straightforward quote.
More Questions
How do I account for consignment inventory when I don't own the product I'm selling?
Consignment goods don't go on your balance sheet as inventory because you don't own them. When a consigned item sells, you only record your commission as revenue and the consignor's share as a liability until you pay them.
Read answerWhat is prime cost in a restaurant and why is it the most important number to track?
Prime cost is your total cost of goods sold (food and beverage) plus your total labor costs (wages, benefits, and payroll taxes). It should fall between 55% and 65% of total revenue, and it matters more than any other number because it covers the two largest controllable expenses in your restaurant.
Read answerWhat causes inventory shrinkage and how does it show up in my bookkeeping?
Shrinkage happens when your physical inventory count is less than what your books say you should have. The most common causes are theft, damage, spoilage, receiving errors, and miscounts. You record the difference as an inventory adjustment that flows into cost of goods sold or a dedicated shrinkage expense account.
Read answerWhat bookkeeping mistakes do first-time franchise owners make that cause problems later?
First-time franchise owners commonly mix personal and business finances, mishandle royalty fee tracking, skip sales tax setup, and assume the franchisor handles the accounting side. These mistakes compound quickly and create expensive problems at tax time.
Read answerHow do I track project-based revenue and expenses as a consultant or creative agency?
Set up each project as a separate tracking category in your accounting software, then assign every invoice and direct expense to the right project. Pair that with consistent time tracking and you'll know exactly which projects and clients are actually profitable.
Read answerHow do I track raw materials vs finished goods in QuickBooks for a small manufacturer?
Set up separate sub-accounts under your Inventory Asset account for raw materials and finished goods, create individual inventory items mapped to each, and use inventory assemblies or a third-party app to move costs from materials to finished products when you build.
Read answer
