Blog · Demand planning

How CPG brands forecast revenue from open KeHE purchase orders

A purchase order is not revenue until it ships, delivers, invoices, and settles. Most forecasts collapse those stages into one number. This post walks through the PO lifecycle, where visibility breaks down, and how to build a forecast that accounts for the gap between shipped and settled.

For CPG operations and finance teams managing KeHE wholesale accounts.

Direct answer

Track at the PO level. Forecast at the settlement level.

The unit of forecasting in CPG wholesale is the purchase order, not the shipment and not the invoice. A sound forecast tracks every PO through seven stages — from open through settled — and applies the trailing deduction rate to estimate the gap between what ships and what you actually collect.

One sales manager on a recent demo call put it simply: “We’re tracking to forecast based on what is open and shipped… that’s the other thing that has not been super easy for our team to streamline.”

The PO lifecycle

Seven stages from PO to cash.

Every KeHE purchase order passes through these stages. Revenue recognition, cash timing, and deduction exposure are different at each one.

1

Open

KeHE issues the PO via EDI 850. The order exists but has not been acknowledged, picked, or shipped. Revenue: $0 recognized.

2

Acknowledged

Your system sends the EDI 855 (due within 24 hours). The PO is confirmed and enters the fulfillment queue. Revenue: still $0.

3

Committed

Inventory is allocated, pick/pack is scheduled, and the EDI 753 (ready to ship) is sent 3 business days before pickup. Revenue: still $0, but the order is now operationally committed.

4

Shipped

Product leaves the warehouse. The EDI 856 (ASN) is transmitted with lot-level detail. For many CPG brands, this is the revenue recognition event.

5

Delivered

Product arrives at the KeHE DC. The receiving team counts cases against the ASN. Any discrepancy becomes a UDR, and the 48-hour response window starts.

6

Invoiced

The EDI 810 invoice is accepted (only after the 855 was sent). Payment terms begin. Revenue is booked.

7

Settled

Remittance arrives. Deductions are applied. The gap between invoiced and settled is where deduction management lives.

Where forecasts break

Four visibility gaps that inflate or deflate the pipeline.

Open vs. committed is invisible

Most ERPs show a PO as "open" from the moment the 850 arrives. But there is a meaningful operational difference between an order that exists on paper and one with allocated inventory and a scheduled pickup. Without that distinction, forecasting treats unacknowledged orders the same as orders ready to ship.

Shipment ≠ delivery ≠ payment

Many CPG brands recognize revenue at shipment (when the ASN fires). But the PO is not settled until the remittance arrives, which may be 30-60 days later and reduced by deductions. Forecasting from shipped POs overstates near-term cash unless deduction rates are factored in.

Split shipments create phantom POs

A single PO can ship in multiple loads across different days. Each partial shipment generates its own ASN. If the forecast counts each ASN as a separate PO, the pipeline inflates. If it ignores partials, it undercounts. The PO, not the shipment, is the unit that matters.

Deductions are invisible until remittance

A shipped PO looks like a $10,000 revenue event. The remittance may settle at $9,200 after a CN pass-through, a fill-rate fee, and a placement free-fill. The $800 gap is not a bad debt — it is a cost of doing business through KeHE — but it only becomes visible after settlement.

A working framework

Three numbers to track weekly.

Open pipeline

Total dollar value of POs in open, acknowledged, and committed stages. This is your forward-looking demand signal.

Shipped not settled

Dollar value of POs that have shipped but not yet received remittance. Apply trailing deduction rate to estimate expected cash.

Settlement gap

The difference between invoiced and settled dollars over the trailing 90 days. This is your actual deduction rate — the number that makes the other two useful.

Frequently asked

When should a CPG brand recognize revenue from a KeHE PO?+

Most CPG brands recognize revenue at shipment (when the ASN is transmitted). However, the cash impact depends on KeHE payment terms and the deduction rate at settlement. A sound forecast tracks both: revenue at shipment and expected cash at settlement.

How do I forecast deduction impact on open POs?+

Use your trailing deduction rate by category. If your historical KeHE deduction rate is 8% of gross, apply that to your open PO pipeline to estimate net expected cash. The prefix-code reference shows which deduction types are contractual passthrough versus potentially disputable.

What is the difference between a PO and a shipment for forecasting?+

A PO is the retailer-issued order. A shipment is a physical movement of goods. One PO can generate multiple shipments (split loads). For forecasting, track at the PO level with shipment status as an attribute, not at the shipment level with PO as a tag.

How does the Intelligent PO help with demand planning?+

The Intelligent PO workspace tracks every PO through its full lifecycle: open, acknowledged, committed, shipped, delivered, invoiced, and settled. It shows the current status, the deduction history, and the gap between invoiced and settled — giving operations, sales, and finance the same live view.

Related reading

From pipeline visibility to deduction prevention.