Blog · Board and management reporting · FMCG and CPG brands
How a CPG brand reads its retailer chargebacks and deductions from the remittance and deduction files: chargebacks by retailer, by reason code and by distribution centre, the share that is disputable against the brand's own shipment and delivery records, the reasons that recur at one retailer and nowhere else, the cost per case shipped by retailer, and the two conversations, the brand's own logistics and the retailer's compliance team, that the split points to.
A CPG brand's remittances arrive short, and the deductions file explains why in codes nobody reconciles. Grouped, mapped and joined to the brand's own delivery records, the deductions split into money owed, money to dispute, and money nobody can trace. This guide sets out chargebacks by retailer, reason and DC, the three-way split, cost per case, and the two conversations.
Per deduction:
Reason, mapped from the retailer's code State: valid, disputable, unmatched, from the join to shipment and delivery records
Per retailer, per reason, per DC, per period:
Deductions, and the split by state Cost per case = deductions ÷ cases shipped to the retailer Recurrence = periods in the trailing six with the reason above a floor
Retailer identifiers only.
deductions = valid + disputable + unmatched, per retailer per period
And remittance received plus deductions equals invoiced, per retailer, or the difference is listed.
| Retailer | Cases shipped | Deductions | Cost per case | Valid | Disputable | Unmatched | Top reason |
|---|---|---|---|---|---|---|---|
| R-2207 | 840,000 | $610,000 | $0.73 | 48% | 41% | 11% | Late delivery |
| R-4471 | 520,000 | $120,000 | $0.23 | 80% | 15% | 5% | Short shipment |
| R-9034 | 310,000 | $340,000 | $1.10 | 30% | 60% | 10% | ASN errors |
Retailer R-9034 charges more than a dollar a case and six in ten of its deductions contradict the brand's own records. Retailer R-2207 is the largest in dollars, and nearly half is late delivery the brand's proof-of-delivery agrees with.
| Pattern | Conversation | With |
|---|---|---|
| Valid, recurring, one reason | The brand's own process: the DC, the carrier, the labelling | Logistics |
| Disputable, recurring | Dispute with evidence; then the retailer's compliance team about the rule | Account manager, deductions |
| Unmatched | Reference mapping; get the retailer's detail | Deductions team |
| Brand DC | Shipments | Late-delivery deductions | Share late by POD |
|---|---|---|---|
| DC-North | 1,100 | $230,000 | 18% |
| DC-South | 1,050 | $40,000 | 3% |
One DC, one carrier lane, most of the valid charges. That is the logistics conversation with a number.
Deductions written off as cost of doing business. Forty percent disputable, never disputed.
Reason codes not mapped. Every retailer's codes analysed separately, or not at all.
Not joined to delivery records. Valid and disputable indistinguishable.
Ranked by dollars. The strict small retailer hidden behind the large one.
Mapped once, the deduction file, the shipment and delivery records and the reason mapping produce the three-way split, cost per case by retailer and the recurrence by reason and DC every month. Covirage builds this from the exports as they are. The CPG brands page describes the setup, and the sell-in versus sell-out guide covers the other retailer-level view from the same shipment records.
The retailer's deduction file or the remittance advice, each retailer with its own codes. A mapping from each retailer's codes to a short list of the brand's own reasons is written once, and the analysis runs on the brand's list.
The brand's own record contradicts it: a late-delivery charge on a shipment the proof-of-delivery shows on time; a short-shipment charge where the bill of lading matches the order. The report lists them with the evidence, and the deductions team disputes with the document attached.
Because a retailer with high chargebacks and high volume may be cheaper per case than a small one with a strict compliance regime. Cost per case shipped, by retailer, is the fair ranking, and it is the number the account manager takes to the retailer's compliance team.