Monthly COGS Tracking: The Foundation of Gross Margin Management That Most SMBs Skip

Why Gross Margin Is More Important Than Revenue#

A business growing revenue 20% year on year looks impressive. If gross margin simultaneously declines from 45% to 38%, the growth is destroying value. More revenue at lower margin means more COGS spending, more supplier payments, more inventory — for the same or less residual profit. Revenue growth with margin discipline is the goal; revenue growth with deteriorating margin is often worse than no growth at all, because it consumes working capital and management attention while delivering diminishing returns.

Calculating COGS Correctly Every Month#

COGS = Opening Stock + Purchases − Closing Stock. For a retailer: opening stock (what you had at the start of the month, at cost), plus purchases (what you bought from suppliers this month — from Xero bills), minus closing stock (from your stock count or AskBiz inventory system). The result is what you actually consumed in sales this month at cost. Divide by revenue to get your gross margin percentage. This calculation requires a monthly stock count or a perpetual inventory system. Without it, your COGS is guesswork.

What Causes Gross Margin to Drift#

Supplier price increases not passed on to customers — your cost goes up 8%, your price stays the same, margin erodes 8 points. Product mix shift — lower-margin products selling better than higher-margin ones. Discounting — promotions that reduce selling price without reducing cost. Wastage — spoilage and write-offs that increase COGS without generating revenue. Theft — stock consumed but not sold. Each driver has a different fix. Tracking COGS monthly surfaces the issue early enough to identify the cause and apply the right solution.

COGS by Product Category#

An average gross margin of 42% across all products masks enormous variation. Premium products might carry 58% margin. Entry-level ranges might carry 28%. If promotions drive customers toward the 28% products, blended margin falls — even if total revenue holds. AskBiz connects POS sales mix data to product cost data and calculates gross margin by product category every month. You can see which categories are driving margin expansion and which are dragging it down.

Setting and Holding a Gross Margin Target#

Your gross margin target should be set annually in your budget, broken down by month accounting for seasonal product mix changes, and by category. AskBiz tracks actual gross margin against your target weekly — using POS revenue data and Xero COGS data. If your target is 44% and you're running 39% in week two of October, the shortfall is worth investigating now. Five weeks of early intervention recovers margin; five weeks of undetected drift becomes an end-of-quarter P&L problem.

• Gross margin is your survival metric — the percentage of revenue left after the direct cost of what you sell.
• A retailer with 42% gross margin on $500,000 revenue has $210,000 to pay all overheads and generate profit.
• If COGS creeps up 5 points to 63% of revenue (gross margin drops to 37%), that's $25,000 less to cover the same overheads.