Trade marketing analytics: reconcile spend and sell-through

Trade marketing analytics reconciles manufacturer trade spending with retailer sell-through, inventory and contribution. It answers whether funded programs are moving products through the channel while preserving an acceptable commercial return. Keep the physical movement of goods separate from the manufacturer's accounting result until both reconcile.

Define the commercial boundary first

For a US packaged-food manufacturer, trade programs might include temporary allowances, display fees and retailer advertising support. The useful unit of analysis is a retailer, product and promotion period, with store coverage stated. A retailer-wide allowance compared with sales from only participating stores produces a misleading result.

Sell-in measures goods entering the retailer. Sell-through measures purchases by consumers. The Census Bureau's wholesale definitions distinguish wholesalers selling to businesses from sales to the general public. Its retail definitions describe sales to final consumers and separately define inventory held for sale. That distinction matters inside a trade program too.

These are manufacturer channel programs. Category share by trade answers a different question about contractor customer groups. For research into buyer attitudes rather than recorded channel movement, use marketing research analytics.

Bring four exports to the same grain

Start with invoices and credits identifying the retailer, SKU, shipment date, units and manufacturer sales amount. Add retailer sales by SKU and week, beginning and ending inventory, and a funding register containing the promotion ID, funding type, amount and status. Product costs should cover the units underlying the manufacturer contribution calculation.

Map retailer product codes to the manufacturer's SKU before combining totals. Convert cases into consumer units using a documented pack size. Retain the original quantities so someone can explain a conversion later. A missing retailer sales report is unknown demand, not zero demand.

Give every funding obligation a unique reference. An approved display fee that later becomes an accrual and then a settled deduction is still the same obligation. For a completed period, finance should reconcile the final obligation to settlements plus the remaining accrual, with any release documented.

Reconcile the physical units

An illustrative US snack brand reviews September 2026 at two retailers. Quantities below are consumer units of the same product. Assume no shrinkage, interstore transfers or other adjustments; those would need their own columns in a real reconciliation.

Ending inventory = Beginning inventory + Receipts − Consumer sales − Returns to manufacturer

Sell-through rate here = Consumer sales / (Beginning inventory + Receipts − Returns)

Cedar's check is 500 + 2,000 − 1,800 − 100 = 600. Prairie's is 300 + 1,500 − 1,200 = 600. The overall check is 800 + 3,500 − 3,000 − 100 = 1,200. Rates are rounded to one decimal place; the total uses 3,000 / 4,200, rather than averaging retailer percentages.

This denominator is inventory available during the period after manufacturer returns. Label it explicitly because some teams use different sell-through conventions. Neither retailer sold all its receipts to consumers, and the total inventory balance increased despite recorded sales.

Reconcile the manufacturer dollars separately

Now compare the manufacturer's shipment economics. All amounts are USD. Returned goods reverse both their sales value and associated product cost; the cost column below is already net of that reversal. Program allowances have not yet been deducted from the sales column.

Contribution after listed funding = Gross shipment sales − Return credits − Net product cost − Program allowances − Display fees

The proof is 34,000 − 20,400 − 3,600 = $10,000, which also equals 5,400 + 4,600. Funding is 2,500 + 1,100 = $3,600. Funding percentages use sales before program funding and are rounded to one decimal place.

If your ledger already nets an allowance against revenue, do not subtract it again. Build this management bridge from the ledger's actual presentation. This contribution excludes unlisted distribution and overhead costs, so it is not company net profit; gross profit margin explains another boundary.

Turn the comparison into a decision

Cedar has the stronger defined sell-through rate and the larger funding burden relative to sales. Prairie has fewer consumer purchases while finishing with the same inventory. The account teams should discuss replenishment and the conditions attached to the next funding commitment, rather than treating shipment volume as proof of demand.

Sales owns retailer coverage and execution evidence. Supply planning owns the inventory bridge. Finance owns funding completeness and the dollar reconciliation. Review the measures together before renewing a program. For estimated incremental return against a baseline, use the separate trade marketing ROI calculation.

Where it goes wrong

• Mixed periods. Manufacturer calendar months and retailer fiscal weeks need an agreed crosswalk and cutoff.
• Funding counted repeatedly. Commitments, accruals and deductions can describe the same obligation.
• Retail dollars treated as manufacturer revenue. Retail selling prices include economics belonging to the retailer.
• Shipment contribution called consumer profitability. Unsold channel inventory breaks that interpretation.

Reconcile your own trade program in Covirage

Bring a sample of your own shipment, retailer sales, inventory and funding exports to Covirage. Covirage maps the columns; its tools compute the agreed comparisons and check the figures, while the external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring your own files.

See Covirage for CPG brands for the industry context.