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 track cost of goods sold when my supplier prices change every order?
Use a consistent inventory costing method like weighted average or FIFO. QuickBooks Online calculates FIFO automatically when inventory tracking is enabled, so your COGS stays accurate even as purchase prices shift.
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 does a food truck owner handle bookkeeping differently than a restaurant?
Food truck bookkeeping revolves around tracking revenue by location, managing vehicle expenses, handling commissary kitchen costs, and staying on top of variable event fees and permits. The mobility that makes the business model appealing is exactly what makes the financial tracking more complex than a fixed-location restaurant.
Read answerHow do I categorize Amazon FBA fees, storage fees, and referral fees in my books?
Create separate expense accounts for each major fee type. Lumping them into one 'Amazon Fees' account hides where your margins are actually going and makes it impossible to control costs.
Read answerHow 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 are the most common QuickBooks mistakes that create cash flow blind spots?
The biggest blind spots come from not reconciling bank accounts monthly, letting QuickBooks auto-categorize without review, and recording owner draws as expenses. These mistakes make your reports unreliable and hide your true cash position.
Read answer
