How to Calculate Liquor Store Profit Margin Using Inventory and COGS

A strong sales month can still end with a thin bank balance. Your liquor store profit margin — and the inventory and COGS behind it — usually holds the first clue.
A big spirits delivery lands on Tuesday, sales stay strong all month, and the bank balance still comes in lower than you expected. Your liquor store profit margin can hold the first clue.
That margin is net sales minus cost of goods sold (COGS), divided by net sales. The catch is the inputs: a reliable inventory count, correctly valued purchases, and separate margins for beer, wine, and spirits.
This blog covers the formulas, the records to pull, and a hypothetical example that shows where profit is earned and where it leaks.
How do you calculate liquor store profit margin?
Liquor store profit margin is measured as gross margin. Gross margin = (net sales − COGS) ÷ net sales × 100. Net sales are gross sales less returns, allowances, and discounts, excluding sales tax you collect for the state.
COGS comes from inventory: beginning inventory, plus net purchases and freight-in, minus ending inventory. Net purchases are purchases after returns, credits, and discounts, recorded under a consistent method. The IRS describes the same structure for Schedule C filers in Publication 334 (2025 edition), where the result is your cost of goods sold deduction.
Gross margin is not markup. Markup divides gross profit by cost, so it always looks larger. Gross margin divides by sales. Pick one measure and use it consistently across categories and vendors.
Gross margin is also not net profit, taxable income, or cash flow. Rent, payroll, card fees, and owner compensation (where applicable) come out after it. A healthy margin can still leave little cash if inventory purchases outrun sales.
What goes into liquor store COGS?
Liquor store COGS is the cost of the product you sold, plus costs to bring it to the shelf, such as freight-in, less vendor discounts and credits. Rent, payroll, and other selling costs stay out.
Pull these records each month:
- Wholesaler invoices and credit memos
- Freight bills
- Your point-of-sale (POS) item sales report
- A month-end inventory valuation at cost
Check that the cost field in your POS matches the latest invoice cost. Stale costs distort every category margin built on them.
Cost flow matters when wholesale prices change. If you cannot identify the specific bottle or case you sold, first-in, first-out (FIFO) assumes the oldest purchases sold first, and last-in, first-out (LIFO) assumes the newest did. With rising prices, the two methods give different COGS and margin on the same sales. Publication 334 says you need a method for identifying inventory items and must apply it consistently, and it refers to Publication 538 for the details. LIFO carries its own election rules, so do not switch methods without your CPA.
Recording sales is the easy part. Recording cost correctly is liquor store inventory accounting. Some stores book purchases as expenses and never adjust for ending inventory. That overstates cost in a month when stock builds up and understates it when stock runs down.
For tax, the method matters too. The IRS describes a small business exception from keeping a formal inventory, based on average annual gross receipts and adjusted for inflation each year. Whether your store qualifies, and which method fits, are decisions to confirm with your CPA for the tax year in question.
How do discounts and rebates affect liquor store COGS?
Discounts lower your inventory cost, but they raise margin only if they are recorded against that cost. Case discounts and invoice credits reduce what you paid for the product.
Early-payment cash discounts need consistent handling. Publication 334 says you can deduct them from purchases or credit them to a separate discount income account, and you must use the method you choose consistently. If you use the discount account, you do not reduce cost of goods sold by the discounts.
Ask how each rebate arrives: a credit memo, a check, or a payment-term discount. Then track which products earned it, so category margins reflect true cost. Rules on what alcohol wholesalers may offer retailers vary by state, so confirm discount and credit practices with your state's alcohol authority.
How does inventory shrinkage change profit margin?
A gap between what your books say you hold and what a physical count finds is first an inventory variance. Inventory shrinkage is the part left unexplained after timing and recording errors are checked. Either way, the lost value raises COGS and lowers margin.
Common causes include theft, breakage, spoilage, receiving errors, and case-versus-bottle entry mistakes. Review count sheets, receiving logs, and a variance report by category. A single store-wide number hides whether the problem sits in spirits, beer coolers, or the back stockroom.
Count more often than once a year if you can. Counting one category each month limits the damage of an error and makes the cause easier to trace. Record every adjustment with a date and a reason, so the entry holds up when a lender or the IRS asks about it.
Tax treatment of damaged or unsaleable inventory depends on your accounting method. Document the items, and review the applicable rules in Publication 538 before recording a tax write-down.
How do you review gross margin by product category?
Gross margin by product category means running the same margin formula separately for beer, wine, and spirits, using each category's net sales and COGS. A blended number can look fine while one category quietly loses ground.
Here is a hypothetical example for a beer, wine, and liquor retail store. It is not a UKP client result or a benchmark.
Assumptions for one month: beginning inventory $150,000; purchases net of discounts $420,000; freight-in $3,000; counted ending inventory at cost $160,000; net sales $560,000.
- COGS: $150,000 + $420,000 + $3,000 − $160,000 = $413,000
- Gross profit: $560,000 − $413,000 = $147,000
- Gross margin: $147,000 / $560,000 = 26.25%, or about 26.3%
| Category (illustrative example only) | Net sales | COGS | Gross profit | Gross margin |
|---|---|---|---|---|
| Beer | $200,000 | $166,000 | $34,000 | 17.0% |
| Wine | $170,000 | $120,000 | $50,000 | 29.4% |
| Spirits | $190,000 | $127,000 | $63,000 | 33.2% |
| Total | $560,000 | $413,000 | $147,000 | 26.3% |
These figures are illustrative only. Your own category margins depend on your market, your vendor terms, and how you price.
Now add a count difference. Suppose the books showed ending inventory of $164,000, but the count found $160,000. That $4,000 gap is an inventory variance first. Timing and recording errors can cause it, so check receiving dates, unposted invoices, and unit-of-measure entries. If those are ruled out, it is shrinkage. Before the adjustment, COGS looked like $409,000 and gross margin looked like 27.0% ($151,000 / $560,000). The count corrected it to 26.3%, so the variance cost about 0.7 points of margin.
In this example, beer has the lowest margin, but margin alone should not decide its shelf space. Review volume, how quickly it sells, and how much cash it ties up. Decisions that could follow include repricing, renegotiating vendor terms, adjusting order quantities, or tightening receiving and count procedures.
Talk to a CPA about your inventory and margin reports
A margin report is not about explaining last month perfectly. It is about seeing a count variance or a weak category early, while you still have choices. If you count at year-end, plan the count date and cutoff now.
At Uday K Patel CPA LLC, our Client Accounting Services include monthly accounting with cloud access in QuickBooks or Xero, plus financial statement preparation and reporting. We built our Beer, Wine & Liquor Retail practice around the numbers package store owners rely on: inventory, margin, and compliance. It is how we help owners see the count, COGS, and category margins together.
Ready to look at your inventory, COGS, and margins before your next count? Call (860) 430-5875 or email info@ukpcpa.com.
Want help applying this to your situation?
We're a fully virtual CPA firm taking on new clients nationwide. Let's talk about your numbers.


