Telecommunications Wholesale settlement Reconciliation

Level 2: The Wholesale Settlement Process – End-to-End Flow

Standard monthly settlement cycle:

1. Traffic exchange & CDR/EDR generation
2. File exchange (via SFTP, API, portal)
3. Mediation & normalization (format alignment)
4. Rating & valuation (apply agreed rates)
5. Reconciliation & matching (volume, value, call-by-call)
6. Dispute identification & resolution
7. Netting & invoicing/payment
8. Archiving & audit trail

Illustration: Settlement as an 8-step assembly line — every step must be perfect or money disappears 🏭💰.

Pro Tip: “The earlier you catch mismatches, the cheaper they are to fix.” Most disputes happen in step 5 — automate it heavily.

Level 3: Common Causes of Settlement Mismatches – Know the Enemies

Top reasons numbers don’t match:

1. Timing differences (CDR generation windows)
2. Rounding rules (per-second vs per-minute)
3. Rating discrepancies (different rate tables applied)
4. Dropped/unbilled records (switch → mediation failure)
5. Fraudulent traffic (not filtered on one side)
6. Format/conversion errors
7. Duplicate CDRs
8. Incomplete files (transmission errors)

Illustration: Mismatches as leaks in a pipeline — each leak type needs a different patch 🚰🔧.

Worst one? Fraudulent traffic — one side bills it, the other doesn’t recognize it → dispute → delayed payment → cash flow pain.

Level 4: Reconciliation Tools & Automation – Stop Doing It Manually

Essential tools & approaches:

• Mediation platforms (Nokia, Oracle, PortaOne built-in)
• Dedicated RA/settlement systems (Subex, cVidya, Neural Technologies, RaBit)
• Custom scripts (Python + Pandas for CDR matching)
• Cloud-based reconciliation (AWS Glue, Google BigQuery)
• File comparison & diff tools (for initial checks)

Best practice: Automate 95%+ of matching — humans only handle exceptions & disputes.

Illustration: Manual reconciliation as using a spoon to empty the ocean — automation is the pump 🪣→🚀.

Rule: “If you’re still opening Excel for settlement — you’re losing money daily.” Invest in automation — payback is usually <6 months.

Level 5: Dispute Management & Resolution – Turn Conflicts into Cash

Standard dispute workflow:

1. Identify mismatch > threshold (usually 1–5%)
2. Issue formal dispute notice (within ICA timeline – typically 30–60 days)
3. Provide evidence (CDRs, logs, packet captures)
4. Partner review & counter-evidence
5. Negotiation or escalation (arbitration per ICA)
6. Adjustment & re-invoice

Illustration: Disputes as a courtroom drama — evidence wins, emotion loses ⚖️📜.

Pro Tip: “Good interconnect partners resolve 90%+ of disputes within 30 days.” Keep detailed audit trails — screenshots & logs save thousands $.

Level 6: Revenue Assurance in Wholesale Settlement – Plug the Leaks

Revenue assurance focus areas in interconnect:

• Unbilled / under-billed traffic (your side missing CDRs)
• Over-billed / rejected traffic (partner not recognizing)
• Fraudulent traffic not filtered
• Incorrect rating applied
• Late/incomplete file exchange

Best practice: Reconcile 100% of CDRs monthly + run RA analytics daily.

Illustration: RA as a security guard watching every dollar entering/leaving your network 🚨💵.

Golden rule: “If it’s not reconciled — it’s not revenue.” Automate RA checks — catch 95% of leakage before it becomes permanent.

Level 7: Telecom Wholesale Settlement Reconciliation Legend Status Unlocked!

Congrats! You’re ready to run accurate, automated, dispute-proof wholesale settlement reconciliation that maximizes revenue and minimizes leakage. Combine with 6X protected interconnects = cleanest, most profitable wholesale business!

Want advanced settlement training (automated dispute engines, multi-party multilateral reconciliation, AI-powered mismatch detection)? Email support@6xcom.com — we’ll make you a settlement legend, free!