If Your Walmart Model Is 3% on OTIF Misses, You Are Modelling One of Two Deduction Streams

This one does not need a shipment to explain it.

Since 1 August 2022 Walmart has charged Collect suppliers a percentage of what they deliver, every month, whether or not anything went wrong. It is not an OTIF penalty. No truck, no carton, no ASN and no appointment window appears in the calculation.

If the only Walmart charge in your forecast is 3% of cost of goods on OTIF misses, your forecast is missing a term, and it is the term that grows with your sales.

What the charge is

Talk Business & Politics reported on 6 July 2022 that from 1 August 2022 Collect suppliers share transportation cost accountability through a Collect Pickup charge and a fuel surcharge. It described the Collect Pickup charge as "a monthly department-specific deduction calculated as a percent of the Cost of Goods received across Walmart U.S."

Four clauses, each of which changes the model.

A fuel surcharge lands alongside it, and our research found no public source giving that surcharge a base or a rate. Treat the pair as one deduction arriving on two lines.

The rate has never been published

No source in our research gives the Collect Pickup rate, and that is not an oversight on your part. Walmart's supplier documentation sits behind Retail Link authentication: the retailer publishes a complete fee schedule for marketplace sellers on a page that needs no login, and the rates suppliers are actually charged are not on it.

A charge you cannot read is a charge you cannot forecast from the top down. You can only reconcile it backwards, which is slower, and which nobody does until finance asks why the margin moved.

Backwards works. Take the deduction line for a month, take the cost of goods you received from Walmart that month, and the quotient is the rate applied. On the reading above the department-specific part is the rate and the national part is the base, so your own received-goods figure is the divisor. Three consecutive months gives you the rate and its variance.

Why no scorecard predicts it

OTIF is a score. A shipment either lands inside the appointment window at full quantity or it does not, the month aggregates, and 3% of cost of goods lands on the non-conforming case. Every miss has a cause, a PO number and a timestamp. The three published bases for that 3%, and the monthly waiver beneath it, are in what recovery is actually worth.

The Collect Pickup charge has no event. There is no late truck to go back and check, no carton to recount, no label to re-verify. It is computed from a volume, and the only input that moves it is the volume.

It also has no code. Our portal reference records six Walmart reason codes, WM-OTIF, WM-ASN, WM-CTN, WM-PRC, WM-LBL and WM-RTG, and none of them describes a monthly cost share. WM-RTG is an unauthorised carrier, a different argument about a different deduction. Our reference's Walmart penalty note carries four lines: OTIF at 3% of cost of goods, SQEP variable per incident or PO, ASN and labelling at $50-500 per incident, and routing at the freight-cost difference. Collect Pickup is not among them, and neither is a fuel surcharge.

That is a gap in our record, not evidence that the charge does not exist. Say so plainly to anyone who asks you to prove it.

Collect is why you may not be modelling it

Prepaid versus Collect is a liability switch, not a metric variant. Under Collect you have the goods ready for Walmart's carrier, and you are not liable for an order being late because of a truck breakdown or another transit problem (Talk Business & Politics, 3 September 2020). Under Collect the PO is expected to route within 24 hours of receipt of the PO, or by 4 PM Central, whichever comes first (8th & Walton, 16 May 2024).

So the switch that stopped you paying 3% for somebody else's breakdown is the switch that put you in the population this charge is computed across. The risk moved rather than disappeared.

Our portal reference records the prepaid and Collect distinction for Target, where the dispute window itself differs by mode. It does not record it for Walmart at all, even though the sources above are specific about what Collect requires. Your account's mode is Walmart's documentation to confirm, not something we hold.

Three levers, and one of them is yours

A percentage of goods received has three inputs and they are all there is. The department rate is set by Walmart, never published, and not yours. The volume it is computed on is the goods you received, which is the reward for selling them, and not yours in any month that went well. Disputing it is yours.

The first two are not operational levers at all. You cannot renegotiate a rate you cannot read, and you cannot shrink the charge by shrinking the sales that produced the goods. No label fix, no carrier tender, no ASN timing and no appointment discipline moves this number by a dollar.

That makes it a detect-and-dispute problem rather than a prevent problem, which is the loop this blog is built around: something arrives, something is matched to a rule, something is filed, something comes back.

Two systems, two clocks

OTIF exposure is at least observable, and in practice small: one freight platform's customer base was paying 0.16% of cost of goods in Walmart fines in February 2024 (Forbes, 1 February 2024), an order of magnitude below the headline 3%, because 3% is a per-event rate and not an average bill. The Collect Pickup charge has no published floor and no observed magnitude in our research.

Two systems, two clocks, and a supplier who models one of them mis-forecasts the year. The 3% is bounded by your error rate, which is finite. The Collect Pickup charge is not bounded by anything you control.

A deduction with no reason code in your record is a routing problem before it is an evidence problem, so find out where the line lives before you build a packet. Walmart's OTIF and compliance chargebacks are accounts-receivable deductions routed through HighRadius on a window counted from invoicing; invoice and posting discrepancies go through the AP Disputes Portal in Retail Link, counted from posting. Our record does not say which queue a Collect Pickup deduction sits in. Both queues and both clocks are in APDP versus HighRadius, and every retailer's window is in the dispute window table.

Walmart's window is 30 days, counted from the invoice date for the deductions that run through HighRadius, and this one accrues every month on everything you receive. Pull your Walmart deduction lines for the last twelve months this week, find the line that is not an OTIF code, and start the 30-day clock on it. The next one is already accruing on next month's goods.