Volume Rebate Reconciliation
A five-stage annual workflow. Processors and distributors submit velocity reports in three different formats; DJ Co-Ops ingests them, normalizes to a canonical shape, matches against RA numbers, resolves exceptions, and generates per-district payouts. The full reconciliation loop is what made volume-rebate season the credibility test of the production system.
Inbound velocity reports
Three processors submitted velocity reports for the 2013-14 school year, each in their preferred reporter format. Click Import all reports to ingest them into the workspace and unlock the next stage.
Normalize reporter formats to canonical shape
Three reporter formats (K12foodservice · ProcessorLink · Lunchline) become one canonical line shape: { processorId, raNumber, districtId, qty, dollars, period }. The normalizer also resolves the ProcessorLink Mfr_Abbr lookup against dbo.ProcessorLinkMfrLookup and coerces format-anomaly values (commas in dollar fields, suffixes in qty fields).
RA number cross-reference
Each normalized line must match to a known district by canonical districtId and have a valid Rebate Authorization (RA) number. Lines with both pass through to the payout calculation; lines with either missing fall to the Exception list.
Matched lines —
Unmatched lines —
Resolve exception cases
Lines that didn't match cleanly. Each exception has a resolution action: Assign RA (for missing RA), Reformat (for format mismatches), Map district (for unmatched districts), or Skip (omit from payout). Exception resolutions persist across sessions.
Per-district payout summary
Final per-district rebate dollars after matching, exception resolution, and rebate-rate computation. Districts receive these credits applied against next year's USDA Foods entitlement allocation.