Monthly COGS Tracking: The Foundation of Gross Margin Management That Most SMBs Skip
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. AskBiz tracks COGS monthly against your target and alerts you when the margin is sliding.
- Why Gross Margin Is More Important Than Revenue
- Calculating COGS Correctly Every Month
- What Causes Gross Margin to Drift
- COGS by Product Category
- Setting and Holding a Gross Margin Target
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.
Worked Example: Tracing a Margin Drop to Its Source#
A hardware shop with $850,000 annual revenue noticed gross margin had drifted from a historical 41% to 36% over four months — $42,500 of lost margin on an annualised basis. Monthly COGS tracking made the timeline visible: the drop started precisely the month a major fastener supplier raised prices 11%, a change the shop had absorbed without adjusting its own shelf prices because nobody had flagged it as significant at the time. Category-level tracking confirmed it — fasteners and fixings, 18% of revenue, had margin fall from 38% to 24%, while every other category held steady. A targeted 6% price increase on that category alone, still below the shop's competitors, recovered most of the lost margin within a single month without affecting sales volume, because customers hadn't been comparison-shopping fasteners closely enough to notice.
Monthly Stock Counts: The Unglamorous Foundation of Accurate COGS#
COGS accuracy is entirely dependent on knowing your closing stock value accurately, and this is where most SMBs cut corners. A full physical count monthly is the gold standard but time-consuming for larger inventories; a practical middle ground is a full count quarterly with a rolling cycle count of your highest-value categories monthly — count the 20% of SKUs that represent 80% of stock value every month, and true up the rest quarterly. Businesses using a perpetual inventory system like AskBiz reduce the burden further, since the system tracks stock movements in real time from sales and purchases, and physical counts become a periodic accuracy check rather than the sole source of the closing stock number. Skipping counts entirely and estimating closing stock is the single most common cause of wildly inaccurate monthly COGS and gross margin figures.
People also ask
What is a good gross margin for retail?
Highly variable by sector: fashion retail 50–65%, food retail 25–40%, electronics 20–35%, hardware 35–50%. The benchmark matters less than your consistency — know your target, track it monthly, and investigate deviations promptly.
Does COGS include labour?
In product-based businesses, COGS typically includes direct materials and sometimes direct production labour, but excludes overhead labour. In service businesses, direct labour is often in COGS. The key is consistency — define what's in COGS and apply it the same way every month.
Our team combines expertise in data analytics, SME strategy, and AI tools to produce practical guides that help founders and operators make better business decisions.
Try AskBiz Free — Track Your COGS and Gross Margin by Category in Your Dashboard Today
Connect your POS and Xero supplier invoices to AskBiz. See gross margin calculated automatically every month. Free 14-day trial.
Connects to Shopify, Xero, Amazon, QuickBooks, Stripe & more in minutes