How do restaurants track COGS for food and beverage separately?
The reason restaurants separate food and beverage COGS is that the target percentages are very different. Food cost typically runs 28-35% of food sales. Beverage cost should land between 18-25% of beverage sales. If you lump everything into one COGS line, you get a blended number that tells you almost nothing. Food costs could be creeping up to 40% while cheap beer sales mask the problem in the combined number.
The separation starts in your chart of accounts. You create distinct COGS accounts for food and for beverages. Most restaurants benefit from splitting beverages even further into beer, wine, and liquor because the margins on each are meaningfully different. Draft beer might run 20% cost while a quality wine program could hit 30% or more. If you only have one “beverage” account, you won’t see those differences until something has already eaten into your profit for months.
Every purchase needs to be coded to the right account when it’s entered. When your food distributor invoice comes in, that goes to food COGS. Your liquor distributor invoice gets split across the appropriate beverage sub-accounts. This is where consistency matters. If the person entering invoices doesn’t know the difference or doesn’t care, the reports downstream are unreliable. Setting up vendor defaults in QuickBooks helps because most of your vendors sell either food or a specific beverage category, not both.
To calculate your actual food cost percentage for a given period, you take beginning food inventory plus food purchases minus ending food inventory, then divide by food sales for that same period. The same formula applies to each beverage category. Running these numbers monthly at minimum gives you a trend line. Running them weekly gives you the ability to catch problems before they compound.
Inventory counts are the piece that makes COGS accurate rather than just an estimate based on purchases. Without regular physical counts, your COGS reflects what you bought, not what you actually used. Waste, theft, over-portioning, and comps all create a gap between purchases and actual usage. Monthly counts are the minimum. Weekly counts on high-value items like proteins and liquor give you tighter control.
The reporting side is where this pays off. When your restaurant bookkeeping is set up correctly, your monthly financial statements show food cost and beverage cost as separate line items with their own percentages against their respective sales. You can see immediately if food cost jumped from 31% to 36% and start investigating whether it’s a pricing issue, a vendor cost increase, waste, or portioning problems.
Getting this structure right from the start saves a lot of headaches. If your books currently dump everything into one COGS account, it’s worth restructuring. Rock Steady Bookkeeping can set up the accounts properly and make sure your vendor invoices flow to the right categories so you actually get the visibility you need to protect your margins.
Wisconsin's Small Business Bookkeeper
The Next Step:
A Quick Conversation
Tell us about your business. We'll talk through what you need, answer your questions, and give you a clear quote.
More Questions
What's the annual report requirement for a Wisconsin LLC?
Every Wisconsin LLC must file an annual report with the Department of Financial Institutions. The fee is $25 online or $40 by paper, and it's due by the end of the calendar quarter in which your LLC was originally formed.
Read answerWhat Wisconsin sales tax applies to restaurant sales?
Wisconsin restaurants collect 5% state sales tax plus 0.5% county tax in most counties, bringing the total to 5.5% on prepared food and beverages. A few jurisdictions add additional local taxes for stadium or exposition districts.
Read answerWhat's the best way to track client retainers for a law firm?
Client retainers go into your IOLTA trust account and are recorded as a liability until earned. Track each retainer by client, then move funds to your operating account only after you've billed against the matter and the fees are earned.
Read answerHow do I calculate gross profit margin on a janitorial contract?
Subtract your direct costs (labor, supplies, travel, and equipment depreciation) from the contract revenue, then divide by revenue. Most janitorial operators target 30-40% gross margin to cover overhead and leave room for profit.
Read answerHow do I track recurring cleaning contracts in QuickBooks?
Use recurring invoices for each contract and set up classes or customer types to separate monthly contract revenue from one-time jobs. This gives you a clear view of your monthly recurring revenue.
Read answerHow much does QuickBooks Online cost?
QuickBooks Online ranges from about $35 to $235 per month depending on the plan. Most small businesses need either Essentials or Plus. Intuit frequently discounts new subscriptions for the first three months.
Read answer