1 / 13

End to End Bill Reconciliation with

End to End Bill Reconciliation with. Telesoft Consulting Ltd. Vienna , 20 . 02 .200 6.

mead
Download Presentation

End to End Bill Reconciliation with

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. End to End Bill Reconciliationwith Telesoft Consulting Ltd. Vienna, 20.02.2006

  2. The InvoiceControl™ is a tool for reconciliation of all services invoiced to post-paid customers. It compares the customers invoiced revenue to the revenue billed and revenue captured at various network checkpoints. InvoiceControl™runs either in a batch mode which allows automatic reconciliation of a huge amount of subscribers or on-demand in order to verify a particular charging scenario. InvoiceControl™is a scalable solution, which is capable to handle an unlimited amount of customers for a short time period. Introduction

  3. InvoiceControl™manages customer hierarchies, tariffs, rates and discounts. It allows import, selection and synchronization of the customer and usage data in order to perform the rating, billing and discounting functionality. InvoiceControl™has a built-in rating and billing agent with flexible configuration possibilities which suits almost all requirements. The discounting module of InvoiceControl™allows the calculation of volume discounts based on the used service or group of services, combination of origin/destination zones. It allows definition of one or more discounts with pre-defined calculation priorities. Introduction

  4. InvoiceControl™imports the customer data, tariff and product information from the invoice print file produced by the in-house billing system. Price and product definitions can be specified by using the build-in InvoiceControl™user interface or imported from the in-house billing system. InvoiceControl™provides charging sources synchronisation interfaces which avoids missing or duplicates of records during the reconciliation procedure. After rating, billing and discounting stages InvoiceControl™ compares the results with the invoices produced by the billing system and creates detail reports for the differences. Architecture

  5. The rating agent delivered with the InvoiceControl™ is capable of calculating charges from EDR’s (Event Data Record), coming from different kinds of network elements – mobile and land-line switches, TAP, SMS/MMS centres, WAP gateways, GPRS/UMTS nodes, IN platforms etc. InvoiceControl™ supportsalmost any known charging scenarios like MOC/MTC/CF charging, Friends & Family, VPN groups, VAS (Value Added Services), wholesale and retails revenue sharing models etc. The price calculation is based on the following groups of parameters: Supported Charging Scenarios • Geographical – network, distance, origin/destination, routing. • Service related – service id, kind of service, direction. • Volume related – duration, volume, number of events, pre-priced. • Time dependency – daily time block (peak/off-peak), weak day, holiday. • Customer related – tariff indicator in the customer tree, VPN (F&F) • dependency, relation to assigned products and bundles.

  6. InvoiceControl™ has an internal data representation of the tariffs, products and discounts definitions used in the in-house billing system. InvoiceControl™ is capable to import prices, tariffs and products from the external system or to use API (Application Programming Interfaces) to access this directly. Optionally InvoiceControl™ can be delivered with a WEB based GUI (Graphical User Interface) for maintaining all related data. Tariffs, Products and discounts setup

  7. Formatting runs permanent and converts the input EDR files in to internal InvoiceControl™format. Formatting is scalable and can process an unlimited number of files. Formatting can incorporate filtering and merging functionality. The controller manages the whole formatting stage. Raw EDRs Formatted EDRs Formatting Formatting Formatting Controller Process Flow - Formatting

  8. The produced invoice is used for the master source of the reconciliation. Account № 103623834 Telephone № 01/1234567 Tariff TikTak Preferred Zones +49 359 Amount from usage: 48,27 Process Flow - Loading

  9. InvoiceControl™ supports different kinds of invoice print formats. Loading parses and loads the needed information in the internal data structures stored in the memory, data base, flat fails etc. Accounts Resources Tariffs Relations Amounts Process Flow - Loading <InvoiceList> <Invoice> <Header AccNo=”103623834” ……………………………… InvNo=”290086917387”> </Header> <Resource …………………………………… RatePlanName = “TikTak” ResourceID=”01/1234567” FriendZone1 = “+49” FriendZone2 = “+359”> </Resource> <RecurringCharges ………………………………… Amt=”10.00”> </RecurringCharges> <OneTimeCharges ……………………………… Amt=”10.00”> </OneTimeCharges> <UsageCharges ………………………………… Amt=”48.27”> </UsageCharges> </Invoice> ……………… <InvoiceList>

  10. Reconciliation Chain Stage Relations Amounts RT, Zones Resources Accounts Tariffs Node Item EDR Report Relating Accounting Rating Guiding Billing Dispatcher Controller Pricing Rec. reports Control STREAM Invoiced Items Billed EDRs Data STREAM Formatted EDRs Process Flow - Reconciliation QUERY UPDATE QUERY QUERY QUERY UPDATE LOAD LOAD LOAD LOAD LOAD LOAD RECONCILATE END OK OK START START

  11. Resources Accounts Accounting Dispatcher Guiding Guiding Dispatcher Accounting Accounts Resources Process Flow - Scalability HOST C HOST A P1 P1 Billed EDRs Formatted EDRs 0..4 0..4 0..4 Last Resource Digit Last Number Digit Last Account Digit Billed EDRs Formatted EDRs 5..9 5..9 5..9 P2 P2 HOST D HOST B

  12. InvoiceControl™is a reliable and easy to implement solution – commissioning times less then 3 months. InvoiceControl™is a billing system independent solution. InvoiceControl™guarantee results 3-6 hours after the invoice print. InvoiceControl™current bench marks (2 processor Linux based server with 2 GB memory): Conclusion • Formatting throughput – about 6.000.000 records per hour. • Loading from Invoice files (250 000 mobile subscribers bill cycle) – 15 min. • Reconciliation for one period (monthly based) – 1.5 hours. • Reconciliation report creation – 5 minutes. • Upload of the results in the DB (Oracle with direct path loader) – 1 hour.

  13. Thank you! Tel: +43-1-7968412, Fax: +43-1-20833999, Telesoft Consulting GmbH, Gumpendorfer Straße 83, A-1060 Vienna, Austria office@telesoft-consulting.at http://www.telesoft-consulting.at

More Related