How to Improve Gross Margin Analysis in E-commerce

A strong sales month can still leave an e-commerce business short of cash. The usual cause is not a lack of demand, but an incomplete view of what each sale genuinely costs to fulfil. To improve gross margin analysis, founders need reporting that captures the full cost of trading by product, channel and market - not simply revenue less supplier invoices.

For a growing online retailer, gross margin is one of the clearest indicators of whether growth is creating value or merely increasing operational pressure. It informs pricing, purchasing, advertising spend, stock planning and cash-flow decisions. Yet it is frequently distorted by delayed supplier bills, unrecorded marketplace fees, returns, freight costs and inconsistent stock data.

Start with a gross margin definition that fits the business

The basic calculation is straightforward:

Gross margin = (Revenue - cost of goods sold) / Revenue × 100

The challenge lies in defining cost of goods sold consistently. For many e-commerce businesses, it should include the direct costs required to make a product available for sale: purchase cost, inbound freight, customs duty, import VAT where it is irrecoverable, packaging and relevant product-specific handling costs.

Whether fulfilment, payment processing and marketplace fees sit within gross margin depends on the purpose of the report. A business using a third-party fulfilment provider may reasonably want a contribution margin that deducts pick-and-pack fees and postage as well. That can be highly useful for commercial decisions, but it should not be confused with the statutory gross profit figure in management accounts.

The answer is not to choose one measure and discard the other. Use a clearly defined gross margin for financial reporting, then add contribution measures where they help management assess channel and customer profitability. The key is consistency. A margin trend has little value if the underlying cost treatment changes every month without explanation.

Improve gross margin analysis with complete landed costs

Supplier unit price is rarely the true unit cost. Businesses importing stock into the UK must account for the landed cost of bringing goods to a warehouse or fulfilment centre. Freight, duty, customs clearance, insurance and currency movements can materially alter profitability, particularly for bulky, low-value or international products.

A practical approach is to allocate these costs across a shipment using a logical basis. Unit quantity may be suitable where products are similar; weight, volume or purchase value may be more accurate for mixed consignments. There is no universal method, but the chosen approach should reflect how costs arise and be applied consistently.

Timing also matters. If goods arrive in March but the freight invoice is posted in April, March margin can look artificially healthy. Month-end accruals for known freight, duty and other direct stock costs make the management information more reliable. The same principle applies to supplier rebates, volume discounts and credit notes. Record them in the period to which they relate where the amount can be reasonably estimated.

Currency requires particular care. If inventory is bought in US dollars or euros, a favourable exchange rate can disguise an underlying cost increase for a period. Track standard purchase cost alongside actual landed cost so that the business can separate supplier price changes from foreign exchange movements.

Reconcile revenue before analysing profitability

Revenue in an e-commerce platform is not always revenue in the accounts. Orders can be cancelled, discounted, refunded or settled through a marketplace after deduction of fees. If sales data, payment processors, marketplace statements and Xero are not reconciled, the margin percentage may be built on the wrong denominator.

A disciplined monthly process should reconcile gross sales, discounts, returns, VAT and net sales to the accounting ledger. VAT must be excluded from revenue for margin reporting, as it is generally collected on behalf of HMRC rather than retained by the business. This becomes especially important for businesses selling across multiple jurisdictions or through marketplaces with differing VAT collection arrangements.

Returns need their own attention. A high return rate can make a product appear profitable at the point of sale but loss-making once refunds, return postage, repackaging and unsellable stock are recognised. Reporting returns by product category, reason and sales channel often identifies operational issues that a headline gross margin cannot reveal. Incorrect sizing, misleading imagery and weak product descriptions can all have a direct margin cost.

See the margin by product, channel and customer

A blended company-wide margin is useful, but it can hide the decisions that need to be made. A profitable direct-to-consumer website may subsidise a lower-margin marketplace channel. A best-selling product may be absorbing a disproportionate share of freight costs, while a slower-selling line generates much more profit per unit.

Management reporting should therefore segment gross margin at a level that supports action. For most e-commerce businesses, that means at least product or SKU, product category, sales channel and geographical market. Where order values vary significantly, customer cohort or order-level contribution can add useful insight.

Avoid creating reports with more detail than the business can act upon. A small retailer with 30 SKUs does not need the same reporting architecture as a multi-channel business with thousands of products. Start with the categories and channels that represent the largest share of revenue, stock investment or complaints. Expand the analysis when it changes a decision.

Look beyond averages

Average margin can mislead. A product with a 60% margin may look attractive until paid advertising, fulfilment and returns reduce its contribution below that of a 40% margin product sold through repeat custom. Similarly, a marketplace may deliver high revenue but settle funds after fees, promotions and claims that substantially reduce the cash generated.

For this reason, businesses should review gross margin alongside contribution margin, stock turn, return rate and customer acquisition cost. These measures answer different questions. Gross margin shows the profitability of the product and supply chain; contribution margin shows the profitability of the sale after direct selling and fulfilment costs. Neither should be used in isolation.

Make stock accounting timely and credible

Inventory errors are among the most common reasons for unreliable margins. If closing stock is overstated, cost of goods sold is understated and profit appears better than it is. If stock is not adjusted for damaged, obsolete or missing items, management may continue buying and marketing products that are unlikely to generate a return.

Regular stock counts, clear procedures for write-offs and reconciliation between inventory software and the general ledger are essential controls. Businesses should also consider whether their valuation method is appropriate and consistently applied. For many retailers, weighted average cost provides a workable view where identical items are bought at changing prices. Others may need batch-level tracking to understand the actual cost of specific stock purchases.

Stock provisions deserve commercial judgement. Seasonal goods, short-dated lines, discontinued packaging and slow-moving products may require a reduction in carrying value. Recognising this early can be uncomfortable, but it gives directors a clearer basis for discounting, bundling or stopping further purchases.

Turn margin reporting into a monthly decision process

The value of gross margin analysis comes from what happens after the report is produced. Set a monthly review that compares actual margin with budget, prior month and prior year, then identifies the main drivers of variance. A fall in margin could reflect supplier price increases, discounting, freight, exchange rates, channel mix, returns or an accounting timing issue. Each requires a different response.

Give every material variance an owner and a practical next step. Procurement may need to renegotiate terms or consolidate shipments. Commercial teams may need to revise promotions. Operations may need to investigate return reasons. Finance may need to correct cost allocation or improve the month-end close. This prevents management accounts from becoming a historical document rather than a management tool.

It is also sensible to set margin guardrails before approving promotions or new channels. A sales campaign can look successful in revenue terms while reducing cash available for payroll, stock replenishment and tax liabilities. Knowing the minimum acceptable contribution per order helps the business decide when discounting is justified and when it is simply expensive turnover.

For owner-managed businesses, the objective is not a more complicated spreadsheet. It is timely, trusted information that supports confident decisions. Fortis Accounting helps e-commerce businesses build disciplined reporting processes around their data, stock and commercial priorities, so leaders can see where profit is being made and protect it before small margin leaks become a larger cash-flow problem.

The most useful next step is to review one recent month at product and channel level, test whether every direct cost has been captured, and ask a simple question: which sales would you actively pursue again if you knew their true cost?