Blog · Finance metrics and formulas · Consumer goods
Connect brand net sales, trade spending, margins and working capital in one operating review. Follow a worked CPG example from sales and accrual exports to a checked contribution and cash bridge.
Consumer packaged goods financial analysis links net sales, trade spending, margins and working capital by brand. Begin with the gross-to-net sales bridge, then explain product costs and the cash needed to support the business. A rise in shipments can coexist with weaker contribution or declining cash.
Choose a reporting month and compare it with the same basis in your budget and prior period. Use shipment or revenue dates appropriate to the company's policy, identify the reporting currency and retain credits posted after the cutoff for review.
Net sales of tangible products are presented after discounts, returns and allowances under SEC Regulation S-X, Rule 5-03. For an internal CPG review, define each deduction category and map it to the controller's revenue policy. A retailer payment's label does not establish its accounting treatment.
This example is an illustrative US packaged-food company reviewing September 2026. All trade spending shown is classified as a revenue reduction. Product costs follow the ledger's cost-of-goods-sold policy; outbound freight sits below gross profit. This is an operating review, rather than a detailed SKU cost build.
| File | Fields needed | What must reconcile |
|---|---|---|
| Sales and credit register | Invoice line ID, date, brand, customer, gross billings, returns | Gross and net sales accounts |
| Trade program and accrual workbook | Program ID, brand, period, new accrual, settlement, adjustment | Trade-spending expense and liability movements |
| Product cost export | Invoice line or summarized brand-period, COGS | Cost-of-goods-sold accounts |
| Freight and brand expense workbook | Brand, period, cost category, amount | Assigned operating cost accounts |
| Balance sheet detail | Brand where available, date, AR, inventory, AP | Closing ledger balances |
Aggregate trade programs to the intended brand and period before joining to invoice summaries. Joining a customer-level allowance to every invoice can multiply it. Retain an unassigned category when an expense cannot be traced reliably to a brand.
For the broader review sequence, see financial analysis. The CPG sales KPI guide covers retail activity measures; they help explain the operating result but do not replace the finance reconciliation.
Enter the following in columns A:H, with brand rows 2:3. Deductions are positive amounts to subtract. Dollar amounts are exact; displayed percentages later are rounded to one decimal place.
| Brand | Gross billings (USD) | Trade deductions (USD) | Net sales (USD) | COGS (USD) | Gross profit (USD) | Outbound freight (USD) | Contribution (USD) |
|---|---|---|---|---|---|---|---|
| Pantry | 600,000 | 90,000 | 510,000 | 300,000 | 210,000 | 30,000 | 180,000 |
| Beverages | 400,000 | 100,000 | 300,000 | 190,000 | 110,000 | 25,000 | 85,000 |
| Total | 1,000,000 | 190,000 | 810,000 | 490,000 | 320,000 | 55,000 | 265,000 |
Calculate net sales in D2, gross profit in F2 and contribution in H2, then fill down:
=B2-C2
=D2-E2
=F2-G2
Trade-deduction rate uses gross billings; gross margin uses net sales:
=IF(B2=0,"",C2/B2)
=IF(D2=0,"",F2/D2)
Pantry's deduction rate is $90,000 / $600,000 = 15.0%; Beverages is $100,000 / $400,000 = 25.0%. Gross margins are $210,000 / $510,000 = 41.2% and $110,000 / $300,000 = 36.7%. The company margin is $320,000 / $810,000 = 39.5%, calculated from totals rather than the average of brand percentages.
The contribution total must prove the full bridge: $1,000,000 - $190,000 - $490,000 - $55,000 = $265,000. It remains before brand marketing, central overhead, financing and taxes.
Customer settlements often arrive after the sale. Analyze the accrual and its settlement separately, even when both files describe the same promotion.
| Trade liability movement | Amount (USD) |
|---|---|
| Opening accrued liability | 70,000 |
| Plus current-period accruals | 190,000 |
| Less settlements against accruals | 175,000 |
| Closing accrued liability | 85,000 |
The example has no estimate revisions or other adjustments. The closing liability is $70,000 + $190,000 - $175,000 = $85,000. Settlements consume the liability; adding them again to the $190,000 of deductions would overstate the period's spending.
Ask commercial finance which programs created the allowance and which accounts settled it. Review unmatched claims with the account owner. A deduction with a missing program ID is an exception to resolve before attributing its margin effect to a brand.
Use opening and closing balances from the same ledger basis. The following working-capital subtotal includes trade receivables, inventory and trade payables; it excludes the separately reviewed trade-promotion liability.
| Balance | Opening (USD) | Closing (USD) | Change (USD) |
|---|---|---|---|
| Trade receivables | 120,000 | 170,000 | 50,000 |
| Inventory | 200,000 | 230,000 | 30,000 |
| Trade payables | 110,000 | 125,000 | 15,000 |
| AR plus inventory less AP | 210,000 | 275,000 | 65,000 |
The selected working-capital increase is $50,000 + $30,000 - $15,000 = $65,000, an operating cash use before other adjustments. With balances in B:C, each change in D is =C2-B2; the subtotal change is:
=D2+D3-D4
This subtotal alone is not cash flow. To finish the operating cash reconciliation, include the trade-liability change, other accruals, noncash charges and any other operating balance movements. Use the full cash conversion cycle guide if the next question is how long money remains tied up.
Check stock quantities as well as valuation. IRS Publication 538's inventory guidance describes adjusting book inventory to physical inventory and keeping cost records for goods purchased or produced. It is tax guidance; the management review should retain the company's financial-reporting inventory policy and reconcile any tax-basis differences separately.
Commercial finance owns the gross-to-net bridge with account managers. Supply planning explains inventory changes, and the controller owns cost classification and ledger ties. Review brand spending only after those owners agree on the numbers.
Beverages warrants a trade-program review because its deduction rate is higher in this example. That observation does not establish waste: promotional commitments, customer mix and timing may explain the difference. Compare like programs and comparable periods before changing terms. Use consumer goods financial ratios for the separate ratio review, with appropriate peer and accounting-policy checks.
Bring a sample of your own sales, trade-accrual, cost and balance sheet exports to Covirage. Covirage maps the columns; its tools compute and check the brand bridges, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account and set up your business with your own files.
See Covirage for consumer goods brands for supporting industry context.
Use the company's accounting policy and the substance of each arrangement. Many customer allowances reduce revenue, while a payment for a distinct service may be treated differently. Keep a classification field and reconcile the operating review to the controller's approved ledger presentation.
Sales may be uncollected, inventory may build ahead of shipments and customer deductions may settle after the related promotion. Compare receivables, inventory, payables and trade liabilities at consistent cutoffs. Growth in reported contribution does not establish that cash increased.
Gross margin measures what remains after product costs under the company's classification policy. It can omit outbound freight, brand marketing and other support. Show a separate contribution measure and identify which costs are assigned before ranking brands for additional spending.
Usually that would double count at least some activity. A settled deduction may consume an existing accrual rather than create another expense. Match settlement records to their programs, retain unmatched items for review and distinguish new estimates from payments against existing liabilities.