Unit
- Billing lifecycle phases: The end-to-end process includes data collection, mediation, rating, charging, invoice generation, and payment collection. Each phase transforms raw usage data into financial transactions.
- Data collection: Network elements generate CDRs containing call details like duration, destination, and timestamp. These are collected via protocols such as FTP or SFTP from switches, routers, and service nodes.
- Mediation: Raw CDRs undergo normalization, validation, and enrichment. The mediation system converts vendor-specific formats into a standard format used by downstream billing systems.
- Rating: The rating engine applies pricing plans, discounts, and taxes to each usage event. It calculates the chargeable amount based on subscriber profiles and tariff structures.
- Charging: For prepaid, real-time charging deducts balance from the subscriber's account. For postpaid, charges are accumulated and billed at the end of the cycle.
- Invoice generation: Aggregated charges are formatted into invoices. This includes applying adjustments, taxes, and late fees before presenting the final amount due.
- Payment collection: Payments are received via multiple channels (online, bank, agent) and reconciled against invoices. Remittance processing matches payments to open items.
- Dispute management: Subscribers may challenge charges. The disputes team investigates and processes adjustments or corrections through predefined workflows.
- Data retention and archival: Billing records such as CDRs, invoices, and payment logs must be retained per regulatory requirements, often for several years. Archival systems compress and store historical data while still allowing audit access and retrieval for legal or compliance needs.
- Tax calculation and compliance: Telecom bills include taxes like VAT, sales tax, and sector-specific surcharges. The billing system must apply correct tax rates per jurisdiction, handle exemptions, and generate tax reports for authorities, ensuring full regulatory compliance.
- Customer notification and dunning: Prior to invoice due dates, automated reminders are sent via SMS, email, or app notifications. For overdue accounts, dunning workflows escalate reminders and may eventually suspend services, all while tracking communication history for dispute resolution.
- Reconciliation and general ledger posting: After payments are collected, the billing system reconciles received amounts against invoices and posts journal entries to the financial ledger. This ensures accuracy in revenue recognition and enables month-end closing with auditable trails.
Code Example
SQL
SELECT cdr_id, subscriber_no,
call_duration, call_start_time,
rated_amount, tax_amount
FROM billing.cdr_processed
WHERE bill_cycle_id = 202401
AND rating_status = 'success';This query retrieves processed CDRs for a specific billing cycle. The rating_status column indicates whether the CDR passed rating successfully. Used for validation and reporting.
Quick Revision
- The telecom billing lifecycle spans data collection through payment collection.
- Mediation normalizes raw CDRs from various network elements.
- Rating applies tariffs to usage events; charging deducts from prepaid or accumulates for postpaid.
- Invoice generation and payment collection complete the cycle.
- Dispute management handles subscriber billing challenges.