Demo 16 · Channel Data Clean-Room · for manufacturers
Your channel data, cleaned in front of you.
Four distributors, four file formats, one quarter of point-of-sale data. Watch it become one clean table, then see which rep really earned the commission, which rebate claims match the agreement, and what is wrong with next year's price file before a distributor finds it.
Sample data · fictional companies Manufacturer: Talbrook Fluid Power (fictional)
01 · Normalize
Fourteen lines. Six date formats. One truth.
This is a real-looking slice of what arrives each month: an EDI 867 extract, a CSV, a spreadsheet with merged headers and a PDF report. Part numbers typed four ways, one customer spelled five ways, boxes mixed with eaches, a line sent twice.
EDI 867 extract · dates CCYYMMDD
CSV export · dates MM/DD/YY
XLSX, merged headers · dates DD/MM/YYYY or Excel serial
PDF report · dates Mon D, YYYY
| Distributor | Invoice | Date | Part | Qty (each) | Ext $ | End customer | Shipped to | Result |
|---|---|---|---|---|---|---|---|---|
| Meridian Sample | M-88410 | 202603072026-03-07 | TB-TC-2150TB-TC-2150 | 4 BX40 | $1,640.00 | STILLCREEK FABStillcreek Fabrication | SHIPTO 77029TXZIP | Clean |
| Meridian Sample | M-88422 | 202603092026-03-09 | TC2150TB-TC-2150 | 12 EA12 | $492.00 | Stillcreek Fabrication IncStillcreek Fabrication | SHIPTO 77029TXZIP | Clean |
| Meridian Sample | M-88437 | 202603112026-03-11 | TBQC0375TB-QC-0375 | 2 CS50 | $1,150.00 | CINDERVALE MTLWKSCindervale Metalworks | SHIPTO 48209MIZIP | Clean |
| Meridian Sample | M-88450 | 202603142026-03-14 | TB-TC-3300TB-TC-3300 | 30 EA30 | $2,340.00 | OAKHURST PKGOakhurst Packaging | SHIPTO 30318GAZIP | Clean |
| Meridian Sample | M-88461 | 202603162026-03-16 | TB-SC-0800TB-SC-0800 | 60 EA60 | $7,980.00 | MERIDIAN SAMPLE DC(own stock) | MERIDIAN SAMPLE DC COLUMBUS OH (TRANSFER)OHdistributor warehouse | Stock move · held |
| Harborview | 220915 | 03/09/262026-03-09 | QC-375TB-QC-0375 | 100 EA100 | $1,210.00 | Brightwater PumpsBrightwater Pumps | Raleigh NCNCcity, state | Clean |
| Harborview | 220931 | 03/12/262026-03-12 | qc 0500TB-QC-0500 | 40 EA40 | $736.00 | BRIGHTWATER PUMPS LLCBrightwater Pumps | Raleigh NCNCcity, state | Clean |
| Harborview | 220940 | 3/132026-03-13 ? | SPECIAL CLAMP ASSYUNMATCHED | 3 EA3 | $414.00 | Oakhurst PackagingOakhurst Packaging | Atlanta GAGAcity, state | Needs a person |
| Pinecrest | PX-5512 | 13/03/20262026-03-13 | TB HF 0612TB-HF-0612 | 5 BX50 | $212.50 | COPPERBEND AG EQUIPCopperbend Ag Equipment | (blank)COresolved by address | Clean |
| Pinecrest | PX-5519 | 460932026-03-12 | HF0816TB-HF-0816 | 30 EA30 | $219.00 | Copperbend Ag EquipmentCopperbend Ag Equipment | (blank)COresolved by address | Clean |
| Pinecrest | PX-5530 | 16/03/20262026-03-16 | 2150 TOGGLE CLMPTB-TC-2150 | 8 EA8 | $328.00 | Stillcreek Fabr.Stillcreek Fabrication | Houston TXTXcity, state | Clean |
| Tri-County | T-1043 | Mar 11, 20262026-03-11 | TB-TC-1100TB-TC-1100 | 24 EA24 | $696.00 | CINDERVALE METALWORKSCindervale Metalworks | Detroit MI 48209MIZIP | Clean |
| Tri-County | T-1043 | Mar 11, 20262026-03-11 | TB-TC-1100TB-TC-1100 | 24 EA24 | $696.00 | CINDERVALE METALWORKSCindervale Metalworks | Detroit MI 48209MIZIP | Duplicate · removed |
| Tri-County | T-1051 | Mar 17, 20262026-03-17 | TB-SC-1200TB-SC-1200 | 6 EA6 | $1,086.00 | Tri-County stock(own stock) | TRI-COUNTY WHSE FORT WAYNE ININdistributor warehouse | Stock move · held |
One line honestly stays open: "SPECIAL CLAMP ASSY" matches no part number, and one date arrived without a year (marked ?, inferred from the file's period). The clean-room never guesses silently; those go to a person with the evidence.
Under the hood Meridian's first line, as the EDI 867 actually carries it illustrative
The table above flattens each feed to one row. A real 867 does not arrive flat: the ship-to sits in its own name loop with a street address, the item carries three different IDs, the quantity carries its unit and the resale price rides along. This is invoice M-88410 segment by segment, beside what the clean-room reads from it.
ST*867*0001~Transaction set: 867 product transfer and resale reportBPT*00*MER-POS-202603*20260331*SS~Report header: original, report number, report date, sales reportN1*DS*MERIDIAN SAMPLE SUPPLY*91*MER~Reporting distributor, with Talbrook’s account code for itPTD*SS~Product transfer detail loop: one resale (a sale, not a stock transfer)DTM*003*20260307~Invoice dateREF*IV*M-88410~The distributor’s invoice numberN1*ST*STILLCREEK FABRICATION*92*EC-01~Ship-to (end customer), with the code Talbrook assigned itN3*4410 CEDAR BEND INDUSTRIAL DR~Ship-to street addressN4*HOUSTON*TX*77029~Ship-to city, state, ZIP: drives territory creditQTY*39*4*BX~Quantity resold, in the unit the distributor sold itLIN**VP*TB-TC-2150*BP*MS-TC2150*UP*084217021508~Item: Talbrook part (VP), the distributor’s own SKU (BP), the UPC (UP)UIT*BX*410.00~Resale price per unit to the end customerCTT*1~Totals: one line in this reportSE*14*0001~End of transaction set (segment count)
| Invoice · date | M-88410 · 2026-03-07 |
|---|---|
| Ship-to | STILLCREEK FABRICATION (EC-01) 4410 CEDAR BEND INDUSTRIAL DR, HOUSTON TX 77029 |
| Territory | TX → South Central |
| Item (VP · BP · UP) | TB-TC-2150 · MS-TC2150 · 084217021508 Toggle clamp, 150 lb hold |
| Quantity | 4 BX = 40 EA (Talbrook's pack table) |
| Resale price | $410.00 per BX · $41.00 per EA |
Illustrative 867-style layout. Segment order, qualifiers and required fields follow each manufacturer’s implementation guide. Street address and IDs are fictional.
02 · Territory credit
Who earned the commission? Flip it.
Credited by bill-to, every dollar lands where the distributor's headquarters is. Credited by ship-to, it lands where the product actually went. Same data, same quarter. Watch the money move between rep agencies.
The numbers behind the map
| Rep agency (fictional) | Bill-to credit | Ship-to credit | Change | Commission change at 5% |
|---|---|---|---|---|
| Lakeshore Sample Reps (fictional) | $1,520,000 | $713,000 | −$807,000 | −$40,350 |
| Atlantic Example Agency (fictional) | $520,000 | $749,000 | +$229,000 | +$11,450 |
| Gulf Demo Rep Group (fictional) | $0 | $456,000 | +$456,000 | +$22,800 |
| Frontier Sample Reps (fictional) | $611,000 | $515,000 | −$96,000 | −$4,800 |
| Held: warehouse stock moves | $0 | $218,000 | +$218,000 | not credited yet |
| Total POS | $2,651,000 | $2,651,000 | $0 | $34,250 moves between agencies |
03 · SPA claim audit
Every claim, checked against the agreement as written.
Sixteen ship-and-debit claims from 11 monthly batches, filed Apr 2 to Aug 1, 2026. Each is matched to the distributor's own resale line and the special pricing agreement it cites, in the order the claims arrived, so a resale claimed twice across batches and a quantity cap that runs out are both caught. The check is neutral: it catches claims the agreement doesn't cover and claims where the distributor asked for less than it's owed.
See the distributor's side → The Rebate Desk runs these same rules before the claim leaves the distributor.
| Claim | Distributor | SPA | Item | Qty | Debit/unit | Claimed | Verdict |
|---|---|---|---|---|---|---|---|
| batch 2026-04 | Meridian Sample | SPA-2231 | TB-TC-2150 | 400 units | × $11.00 | = $4,400.00 | Valid as written |
Pays as written. Resale found in the POS, end user named on SPA-2231, inside the term and the claim window, debit matches. Payable under the agreement $4,400.00 · claimed $4,400.00 | |||||||
| batch 2026-07 | Meridian Sample | SPA-2231 | TB-TC-3300 | 200 units | × $13.00 | = $2,600.00 | Outside the term−$2,600.00 |
Payable under the agreement $0.00 · claimed $2,600.00 | |||||||
| batch 2026-05 | Meridian Sample | SPA-2231 | TB-TC-2150 | 600 units | × $11.00 | = $6,600.00 | End user not on SPA−$6,600.00 |
Payable under the agreement $0.00 · claimed $6,600.00 | |||||||
| batch 2026-07 | Harborview | SPA-2240 | TB-QC-0375 | 2,000 units | × $2.70 | = $5,400.00 | Filed late−$5,400.00 |
Payable under the agreement $0.00 · claimed $5,400.00 | |||||||
| batch 2026-06 | Harborview | SPA-2240 | TB-QC-0375 | 1,500 units | × $2.70 | = $4,050.00 | Qty over POS−$1,350.00 |
Payable under the agreement $2,700.00 · claimed $4,050.00 | |||||||
| batch 2026-06 | Harborview | SPA-2240 | TB-QC-0375 | 800 units | × $3.70 | = $2,960.00 | Rate over SPA−$800.00 |
Payable under the agreement $2,160.00 · claimed $2,960.00 | |||||||
| batch 2026-07 | Pinecrest | SPA-2256 | TB-HF-0612 | 5,000 units | × $1.15 | = $5,750.00 | No resale found−$5,750.00 |
Payable under the agreement $0.00 · claimed $5,750.00 | |||||||
| batch 2026-07 | Pinecrest | SPA-2256 | TB-HF-0612 | 3,000 units | × $0.85 | = $2,550.00 | Owed to distributor+$900.00 |
Payable under the agreement $3,450.00 · claimed $2,550.00 | |||||||
| batch 2026-08 | Pinecrest | SPA-2256 | TB-HF-0612 | 2,500 units | × $1.15 | = $2,875.00 | Valid as written |
Pays as written. Resale found in the POS, end user named on SPA-2256, inside the term and the claim window, debit matches. Payable under the agreement $2,875.00 · claimed $2,875.00 | |||||||
| batch 2026-07 | Harborview | SPA-2240 | TB-QC-0375 | 1,200 units | × $2.70 | = $3,240.00 | Valid as written |
Pays as written. Resale found in the POS, end user named on SPA-2240, inside the term and the claim window, debit matches. Payable under the agreement $3,240.00 · claimed $3,240.00 | |||||||
| batch 2026-06 | Tri-County | SPA-2263 | TB-SC-1200 | 20 units | × $35.50 | = $710.00 | Rate over SPA−$250.00 |
Payable under the agreement $460.00 · claimed $710.00 | |||||||
| batch 2026-06 | Harborview | SPA-2240 | TB-QC-0375 | 600 units | × $2.70 | = $1,620.00 | Resale over ceiling−$1,620.00 |
Payable under the agreement $0.00 · claimed $1,620.00 | |||||||
| batch 2026-05 | Meridian Sample | SPA-2231 | TB-TC-2150 | 400 units | × $11.00 | = $4,400.00 | Already claimed−$4,400.00 |
Payable under the agreement $0.00 · claimed $4,400.00 | |||||||
| batch 2026-06 | Meridian Sample | SPA-2231 | TB-TC-2150 | 750 units | × $11.00 | = $8,250.00 | Cap used up−$1,650.00 |
Payable under the agreement $6,600.00 · claimed $8,250.00 | |||||||
| batch 2026-06 | Pinecrest | SPA-2256 | TB-HF-0612 | 12 BX | × $1.15 | = $13.80 | Owed to distributor+$124.20 |
Payable under the agreement $138.00 · claimed $13.80 | |||||||
| batch 2026-07 | Tri-County | SPA-2263 | TB-SC-1200 | 15 units | × $35.50 | = $532.50 | Valid as written |
Pays as written. Resale found in the POS, end user named on SPA-2263, inside the term and the claim window, debit matches. Payable under the agreement $532.50 · claimed $532.50 | |||||||
Select any claim number to see the evidence. The audit only applies the agreement's own terms. What to do about a flag (pay, deny, or ask the distributor) stays your decision, and nothing here goes to a distributor automatically.
The answer goes back line by line
The 849-style response each distributor gets
After a person approves the audit, each distributor receives a line-by-line answer: paid, adjusted, rejected or held, with the reason and the amount. One response per distributor, built from the verdicts above. Illustrative 849-style layout. Response codes here are the demo’s plain-language reason codes, not the X12 code list.
Meridian Sample 5 lines · claimed $26,250.00 · paid $11,000.00
| Claim | Invoice | Answer | Claimed | Paid |
|---|---|---|---|---|
| C-1001 · 2026-04 | M-90112 | PAID | $4,400.00 | $4,400.00 |
| C-1002 · 2026-07 | M-90877 | REJECTED R03 | $2,600.00 | $0.00 |
| C-1003 · 2026-05 | M-90345 | REJECTED R02 | $6,600.00 | $0.00 |
| C-1013 · 2026-05 | M-90112 | REJECTED R01 | $4,400.00 | $0.00 |
| C-1014 · 2026-06 | M-90266 | ADJUSTED R04 | $8,250.00 | $6,600.00 |
Segment view (illustrative 849-style)
# Illustrative 849-style layout. Response codes here are the demo’s plain-language reason codes, not the X12 code list. ST*849*0001 BRC*00*RSP-MER N1*DS*MERIDIAN SAMPLE SUPPLY*91*MER CON*CT*SPA-2231 PAD*PAID REF*IV*M-90112 REF*CT*C-1001 LIN**VP*TB-TC-2150 QTY*39*400*EA AMT*AP*4400.00 CON*CT*SPA-2231 PAD*REJECTED*R03 REF*IV*M-90877 REF*CT*C-1002 LIN**VP*TB-TC-3300 QTY*39*0*EA AMT*AP*0.00 CON*CT*SPA-2231 PAD*REJECTED*R02 REF*IV*M-90345 REF*CT*C-1003 LIN**VP*TB-TC-2150 QTY*39*0*EA AMT*AP*0.00 CON*CT*SPA-2231 PAD*REJECTED*R01 REF*IV*M-90112 REF*CT*C-1013 LIN**VP*TB-TC-2150 QTY*39*0*EA AMT*AP*0.00 CON*CT*SPA-2231 PAD*ADJUSTED*R04 REF*IV*M-90266 REF*CT*C-1014 LIN**VP*TB-TC-2150 QTY*39*600*EA AMT*AP*6600.00 CTT*5 AMT*TP*11000.00 SE*41*0001
Harborview 5 lines · claimed $17,270.00 · paid $8,100.00
| Claim | Invoice | Answer | Claimed | Paid |
|---|---|---|---|---|
| C-1004 · 2026-07 | 221204 | REJECTED R07 | $5,400.00 | $0.00 |
| C-1005 · 2026-06 | 221388 | ADJUSTED R11 | $4,050.00 | $2,700.00 |
| C-1006 · 2026-06 | 221512 | ADJUSTED R05 | $2,960.00 | $2,160.00 |
| C-1010 · 2026-07 | 221690 | PAID | $3,240.00 | $3,240.00 |
| C-1012 · 2026-06 | 221455 | REJECTED R12 | $1,620.00 | $0.00 |
Segment view (illustrative 849-style)
# Illustrative 849-style layout. Response codes here are the demo’s plain-language reason codes, not the X12 code list. ST*849*0001 BRC*00*RSP-HAR N1*DS*HARBORVIEW DEMO INDUSTRIAL*91*HAR CON*CT*SPA-2240 PAD*REJECTED*R07 REF*IV*221204 REF*CT*C-1004 LIN**VP*TB-QC-0375 QTY*39*0*EA AMT*AP*0.00 CON*CT*SPA-2240 PAD*ADJUSTED*R11 REF*IV*221388 REF*CT*C-1005 LIN**VP*TB-QC-0375 QTY*39*1000*EA AMT*AP*2700.00 CON*CT*SPA-2240 PAD*ADJUSTED*R05 REF*IV*221512 REF*CT*C-1006 LIN**VP*TB-QC-0375 QTY*39*800*EA AMT*AP*2160.00 CON*CT*SPA-2240 PAD*PAID REF*IV*221690 REF*CT*C-1010 LIN**VP*TB-QC-0375 QTY*39*1200*EA AMT*AP*3240.00 CON*CT*SPA-2240 PAD*REJECTED*R12 REF*IV*221455 REF*CT*C-1012 LIN**VP*TB-QC-0375 QTY*39*0*EA AMT*AP*0.00 CTT*5 AMT*TP*8100.00 SE*41*0001
Pinecrest 4 lines · claimed $11,188.80 · paid $6,463.00
| Claim | Invoice | Answer | Claimed | Paid |
|---|---|---|---|---|
| C-1007 · 2026-07 | PX-6999 | HELD R06 | $5,750.00 | $0.00 |
| C-1008 · 2026-07 | PX-6120 | PAID R13 | $2,550.00 | $3,450.00 |
| C-1009 · 2026-08 | PX-6188 | PAID | $2,875.00 | $2,875.00 |
| C-1015 · 2026-06 | PX-6155 | PAID R09 | $13.80 | $138.00 |
Segment view (illustrative 849-style)
# Illustrative 849-style layout. Response codes here are the demo’s plain-language reason codes, not the X12 code list. ST*849*0001 BRC*00*RSP-PIN N1*DS*PINECREST EXAMPLE FLUID POWER*91*PIN CON*CT*SPA-2256 PAD*HELD*R06 REF*IV*PX-6999 REF*CT*C-1007 LIN**VP*TB-HF-0612 QTY*39*0*EA AMT*AP*0.00 CON*CT*SPA-2256 PAD*PAID*R13 REF*IV*PX-6120 REF*CT*C-1008 LIN**VP*TB-HF-0612 QTY*39*3000*EA AMT*AP*3450.00 CON*CT*SPA-2256 PAD*PAID REF*IV*PX-6188 REF*CT*C-1009 LIN**VP*TB-HF-0612 QTY*39*2500*EA AMT*AP*2875.00 CON*CT*SPA-2256 PAD*PAID*R09 REF*IV*PX-6155 REF*CT*C-1015 LIN**VP*TB-HF-0612 QTY*39*120*EA AMT*AP*138.00 CTT*4 AMT*TP*6463.00 SE*34*0001
Tri-County 2 lines · claimed $1,242.50 · paid $992.50
| Claim | Invoice | Answer | Claimed | Paid |
|---|---|---|---|---|
| C-1011 · 2026-06 | T-1102 | ADJUSTED R05 | $710.00 | $460.00 |
| C-1016 · 2026-07 | T-1188 | PAID | $532.50 | $532.50 |
Segment view (illustrative 849-style)
# Illustrative 849-style layout. Response codes here are the demo’s plain-language reason codes, not the X12 code list. ST*849*0001 BRC*00*RSP-TRI N1*DS*TRI-COUNTY SAMPLE DISTRIBUTORS*91*TRI CON*CT*SPA-2263 PAD*ADJUSTED*R05 REF*IV*T-1102 REF*CT*C-1011 LIN**VP*TB-SC-1200 QTY*39*20*EA AMT*AP*460.00 CON*CT*SPA-2263 PAD*PAID REF*IV*T-1188 REF*CT*C-1016 LIN**VP*TB-SC-1200 QTY*39*15*EA AMT*AP*532.50 CTT*2 AMT*TP*992.50 SE*20*0001
04 · Price-file pre-flight
Your distributors will find these in their line review. Find them first.
Next year's list, eleven parts, five quantity breaks each. It looks finished. Run the pre-flight before it ships.
| Part | Description | 1–9 | 10+ | 25+ | 50+ | 100+ | This year | UPC / GTIN |
|---|---|---|---|---|---|---|---|---|
| TB-TC-1100 | Toggle clamp, 100 lb hold | 28.40 | 27.00 | 25.60 | 24.20 | 22.90 | 27.10 | 084217001104 |
| TB-TC-2150 | Toggle clamp, 150 lb hold | 39.90 | 37.90 | 36.00 | 34.10 | 32.30 | 38.00 | 084217002156 |
| TB-TC-3300 | Toggle clamp, 300 lb hold | 37.50 | 35.60 | 33.80 | 32.00 | 30.40 | 71.50 | 084217003306 |
| ||||||||
| TB-TC-4500 | Toggle clamp, 500 lb hold | 96.80 | 92.00 | 87.40 | 83.00 | 78.90 | 92.00 | 084217004501 |
| TB-SC-0800 | Swing clamp, 800 lb | 141.00 | 134.00 | 127.30 | 120.90 | 114.90 | 133.00 | — |
| ||||||||
| TB-SC-1200 | Swing clamp, 1,200 lb | 188.00 | 178.60 | 169.70 | 161.20 | 153.10 | 181.00 | 084217001203 |
| TB-QC-0375 | Quick coupler, ISO-B, 3/8 in | 12.90 | 12.30 | 11.70 | 11.10 | 10.50 | 12.10 | 084217000374 |
| TB-QC-0375-SS | Quick coupler, ISO-B, 3/8 in, stainless | 11.80 | 11.20 | 10.60 | 10.10 | 9.60 | 24.60 | 084217000381 |
| ||||||||
| TB-QC-0500 | Quick coupler, ISO-B, 1/2 in | 194.00 | 184.30 | 175.10 | 166.30 | 158.00 | 18.40 | 084217000503 |
| ||||||||
| TB-HF-0612 | Hydraulic fitting, 3/8 JIC x 3/4 ORB | 4.55 | 4.35 | 4.10 | 4.30 | 3.70 | 4.30 | 084217006123 |
| ||||||||
| TB-HF-0816 | Hydraulic fitting, 1/2 JIC x 1 ORB | 7.60 | 7.25 | 6.90 | 6.55 | 6.20 | 7.30 | 084217008163 |
| ||||||||
Run this on your own channel
Clean POS, honest claims, a price file your distributors trust.
The Channel Data Desk does this every month on your real feeds, inside your own isolated workspace: normalize every distributor's point-of-sale file, credit territory the way your rep agreements say, check each claim against its agreement, and pre-flight every price file before it goes out.
Distributors' customer identities stay protected: you see what your distributor agreements allow, and one distributor's data is never shown to another.
Monthly desk
Channel Data Desk
Starting at $2,500/mo
For manufacturers: clean point-of-sale data, validated claims, and price files your distributors trust.
More demos: all demos · PO intake · Tenure Capital
Next step
Want your POS data this clean?
Bring one quarter of point-of-sale files from your distributors, in whatever shape they arrive. Mike will tell you what a clean table, honest claims and a pre-flighted price file would take.
Quick question first? AI