The present invention relates to a system and method for identifying billing errors.
Companies and other entities (generally referred to herein as “customers”) are heavily dependent upon telecommunications services. A typical customer may purchase telecommunications services from one or more service providers. Each service provider may offer a variety of service plans, each having different rate schedules depending on different characteristics of individual communications. As an example, a customer may purchase international long distance services from a service provider, and may have some rates for certain types of calls negotiated by agreement in a rate schedule. Other types of calls may have rates that are specified in service guides or rate tables published by the service provider. A typical large customer's relationship with such a service provider may involve 50 or more rate schedules.
Further, a customer may have a large number of different accounts (e.g., associated with different divisions or groups within the company), where each account is responsible for paying for its associated telecommunications charges. Many large companies have hundreds of different accounts. Each account may include dozens of individual telephones or calling cards, each of which may be involved in calls subject to the customer's contract with the telecommunications service provider. The customer may pay thousands (or even hundreds of thousands) of dollars each month for the telecommunications services. The total bill is calculated based on the services providers'application of the rate schedules to each individual call. Unfortunately, many (if not most) bills are inaccurate. A seemingly minor misapplication of a rate schedule that assesses an extra dollar to certain types of calls can result in an overall error totaling hundreds or thousands of dollars.
Billing discrepancies often occur and are difficult to identify, particularly where the calculation of billing rates is complex. Many customers lack either the resources or the expertise to identify such billing errors, and therefore often overpay for services. Further, even when a customer is able to identify an error or discrepancy, it can be difficult for the customer to prove the error or discrepancy to the service provider with sufficient detail to secure a refund or credit.
Embodiments provide a system, method, apparatus, and computer program code for identifying billing discrepancies, including receiving billing data from a billing entity, the billing data including an assessed fee and call details associated with each of a plurality of calls made by a customer, identifying, based at least in part on the call details received from the billing data, rate information associated with the customer, generating an expected fee for each of the plurality of calls, and comparing, for each of the plurality of calls, the expected fee with the assessed fee to identify discrepancies.
Pursuant to some embodiments, processing further includes analyzing the discrepancies to identify if the discrepancy is based on a billing error. Pursuant to some embodiments, a set of billing discrepancies which are based on billing errors are generated and provided to the billing entity for resolution. Pursuant to some embodiments, information may be provided which indicates a potential source of each billing error. Pursuant to some embodiments, information which indicates a potential source may include information identifying whether the error appears to have a time-based component and whether the error appears to have a fixed-fee component.
In some embodiments, the reconciliation device 400 may be operated by an entity or entities separate from customer entity 200 (e.g., acting as a service provider on behalf of one or more customer entities) In either configuration, one or more customer entities 200 may interact with reconciliation device 400 to identify billing errors or inaccuracies based on bills or invoices generated by billing entity 100.
The reconciliation device 400 may also be a branch, affiliate, subsidiary, partner, or unit of the billing entity 100, where the billing entity 100 would use the reconciliation device 400 to prevent undetected billing errors, reducing the potential liability of billing entity 100. The billing entity 100 may be any number of service or product providers, retailers, or wholesalers. The customer entity 200 may be any number of service or product subscribers or users that exchange money and/or other consideration with the billing entity 100.
In some embodiments, billing data may include three general types of information: (1) call details, (2) rate information, and (3) the assessed fee for each call. Call details may include information identifying details associated with each call made from telephone numbers of the customer or using calling cards issued to the customer. For example, call details may include information identifying each call made during the billing period, the customer number used in the call, the number called, the nature of the service (e.g., whether the call was placed as a switched call, as a calling card call, etc.), whether the call was made during a peak or off-peak period, the duration of the call, etc.
Rate information may be included in billing data (although some service providers may not provide the rate information in billing data). Rate information included in the billing data may include an identification of the rate schedule and rates applied to each individual call. For example, a set of billing data produced by AT&T may reference the AT&T rate schedule applied to a particular call (such as one of the rate schedules published by AT&T at www.serviceguide.att.com). A set of billing data may also reference rates specified by a particular service agreement in force between a customer and a service provider. Billing data also includes an assessed fee for each call. The assessed fee for each call is generally shown as a dollar amount.
Processing continues at 14 where customer data is received or identified. For example, processing at 14 may include operation of reconciliation device 400 to identify, receive, or retrieve a file (or files) of customer data (such as the data shown in customer database 600 of
For example, the expected rate schedule associated with each call may be retrieved from a separate file or set of files maintained by (or on behalf of) the customer. As described above, a typical customer may have a large number of potential rates associated with the services that it receives from each service provider. Tracking and identifying all of these rates can be very complex. As a result, pursuant to some embodiments, a separate file or set of files is maintained and updated each time a new rate is imposed or each time a rate is modified. Each rate may be associated with information identifying the circumstances under which the rate applies (e.g., a particular rate may apply for all international calling card calls placed during peak hours). By maintaining a separate file or set of files including all current rate schedules applicable, a customer may readily apply the relevant rates to the call details extracted from the billing data to identify an expected fee associated with each call.
In some embodiments, upon completion of processing at 14, a database or set of customer data is generated which includes (1) the individual call details extracted from the billing data received at 12, (2) the expected rate schedule applicable to each call, and (3) a customer-generated expected fee associated with each call.
Processing continue at 14 where data is compared. For example, reconciliation device 400 may be operated to compare the customer data (e.g., from the customer database 600) with the billing data (e.g., from the billing database 500) to identify any potential discrepancies. For example, the reconciliation device 400 may be operated to compare the data sets by identifying records in both data sets that represent a single transaction, and matching those records. The identification process may utilize any number of data fields that are common between the two data sets to identify unique transactions.
Once the records in both data sets are matched, the reconciliation device 400 analyzes the matched records to locate discrepancies. If each field in both matched records for a single transaction is identical, then no discrepancy exists for that transaction. If any field is not identical, then a discrepancy exists. The reconciliation device 400 then generates a set of reconciliation results at 18. The reconciliation results may contain records with identified errors and/or summaries of the identified discrepancies, such as the total dollar value of over-charged billings. In some embodiments, the reconciliation results are primarily intended to identify differences between the assessed or billed fee for a call (from billing database 500) and the customer-calculated expected charge for the call (from customer database 600), however, those skilled in the art will appreciate that embodiments may be used to identify other discrepancies.
Processing at 18 may further include performing additional analyses once a discrepancy has been identified. For example, many telecommunications service providers assess two general types of tees for calls: fixed fees and time-based fees. Embodiments allow a customer to perform additional analyses to identify the type of fee which is likely the source of a billing discrepancy. For example, in some embodiments, a table or database of discrepancies ay be generated as a result of processing at 18. A number of queries may be run against this table or database of discrepancies to characterize the nature of some or all of the discrepancies. Some of the discrepancies, for example, may be identified as having a time variance. As a specific example, queries may be run against the call details associated with the calls having discrepancies which are designed to determine if the overall charge for the calls varies (or does not vary) based on the length of each of the calls. If the proportion does not vary, the discrepancy may be characterized as one that resulted from the misapplication of a time dependant charge. This information about the nature of the discrepancy may be communicated to the billing entity in order to negotiate a correction in the bill.
Other queries and analyses may be performed to identify discrepancies that likely result from misapplication of fixed charges. For example, queries that identify consistent error amounts in similar types of calls may identify fixed charge errors. Other queries may be established to identify discrepancies that are not the result of billing errors. For example, some service providers assess a fixed charge to all calls placed from public pay telephones. The pay telephone fixed charge may be, for example, $0.49. A query may be run to identify all discrepancies which involve a difference of approximately $0.49 between the expected charge and the billed amount to identify calls which were likely placed from a public pay telephone. In this manner, a customer can ensure that it seeks correction only for those calls which actually involve an unexplained discrepancy, thereby improving the customer's chances of receiving a billing correction or credit.
If the billing entity 100 is a long-distance telephone and/or phone card service provider, for example, the billing data 500 may contain fields such as rate type, rate description, call charge, call service type, access type, origination country code, origination phone number, destination country code, destination phone number, total call minutes, additional call seconds, air mileage and mileage band codes. The call charge field may be the sum of an access charge, a variable cost for an initial billing period in seconds, a variable cost for subsequent time charge increments, a charge per minute, a fixed per call charge and variable per call or per time period surcharges. The customer data 600 may contain many of the identical fields that the billing data 500 contains, but would be lacking the actual charge information imposed by the billing entity 100.
The customer information 600 may be associated with a known algorithm, set of formulas, or method to compute the appropriate charge expected 608 to be imposed by the billing entity 100. In the case of the example, international calling card data for given telephone calls made by a particular customer would be used to calculate an expected charge per minute for each call. The reconciliation device 400 could accomplish this, or it could be pre-calculated by the customer entity 200. The resultant expected charge 608 data would then be compared to the actual billed amount 510 data received from the telephone company, for each given telephone call. Any identified discrepancies could be marked for further analysis and/or aggregated to determine a total net loss or gain from the billing inaccuracies. The discrepancy information could then be provided to either or both of the telephone company and the customer. Where the reconciliation device acts as a third-party reconciliation service provider, the underpaying or overcharging party can then be billed for the error. Funds can then also be received from the appropriate entity and transferred to the other entity.
Details of a particular application of embodiments of the present invention will now be discussed. In the example, embodiments are utilized to identify and correct errors in a long-distance company's billing. In the example, reconciliation device 400 and customer entity 20 are operated by the same entity (e.g., the customer who has been subjected to errors in bills received from its long-distance company).
Due to the nature of a long-distance company's international billing platform, errors in billing are obscure, difficult to identify, and difficult to prove. In the example, the customer utilizes services of the long-distance company to make international calls. The long-distance company may establish particular rates for the customer. For example, the long-distance company may establish rate schedules that apply to international calling cards used by the customer. For example, calls made by the customer from Mexico to the United States can be very complicated. The rate table may specify that the calls be billed as follows: (1) there is an $0.80 “Type II Authorization Call Charge”, which is a per call, calling card surcharge, (2) a $0.004 “Type II Switched Access Charge” billed per six (6) second increment of call time, (3) a variable cost for the initial thirty (30) seconds of the call, which is determined based upon a mileage factor (represented by Bands 1-10), and billed at either a Standard, Discount or Economy rate determined by the connect time of the call, (4) a variable cost for each six (6) second interval after the initial thirty (30) seconds based on the same mileage Bands as the variable initial thirty (30) second charge and the rate period (Standard, Discount or Economy) in which the increment occurred and (5) a variable “Point of Connection” charge based on the same mileage Bands.
Dividing the total cost of a call by the length of the call yields an average cost per minute. Inconsistent costs per minute may show that some calls are billed at $23.66 per minute, when the correct charge should have been $2.60 per minute. A 47.4 minute call billed at the incorrect rate produces an overcharge to the customer of $998.24. Larger customers that make many such international calls under an incorrect billing scenario can easily lose $8,000 to $9,000 per month. Applicants have discovered that billing errors capable of producing such errors can occur in multiple ways. One example of a potential billing error is that an incorrect entry is made in the rate table itself. The timing indicators in the rate table may be incorrectly set at 30 and 6, as opposed to 60 and 60 (full-minute rating), for example. This error causes customers that are supposed to be billed $2.34 per minute to be charged $2.34 for the first thirty (30) seconds, and $2.34 for each additional six (6) seconds thereafter. Calls that should be charged $2.34 for Point of Connection are instead charged $14.40, with each additional minute costing $23.40. Similar incorrect entries in rate tables may cause more random and less easily identifiable errors. These errors are difficult to identify and even more difficult to prove to a long-distance carrier not receptive to paying back customers large sums of money.
Embodiments of the present invention may be utilized to avoid such errors. For example, the errors may be caught early enough to prevent significant problems, and identified more precisely to facilitate remedial payments. For example, billing data 500 long-distance company may be received by the reconciliation device 400, from a billing entity 100. The billing data 500 may include the total billed amount 510, $1,110.80 (as an example) total call length (47.4 minutes in the example), and call identification data 502-508 for at least one call made by the customer entity 200. Customer data 600 is then received by the reconciliation device 400, from the customer entity 200. The customer data 600 contains at least the total call length (in the example, 47.4 minutes) call identification data 602-606, and either a pre-computed expected charge data 608, $10.20, or sufficient data to calculate the expected charge data 608. The reconciliation device 400 then compares the total billed amount 510, $1,110.80, to the expected charge 608, $10.20. The discrepancy is recorded and reported to the appropriate entity for reconciliation of payment. In this example, the long-distance carrier may be charged $1,100.60, and payment would be remitted to the customer.
A further example illustrating features of some embodiments will now be provided. As discussed above, many telecommunications service providers offer a wide and complex array of service plans and rates. The rates applicable to a customer may be determined by reference to both a set of published rates and to the terms of any agreement between the customer and the service provider. This complexity often leads to billing errors which can be very difficult to identify and assess. Embodiments allow a customer to generate a set of expected fees for comparison to the assessed fees to identify discrepancies. In some embodiments, a customer establishes and maintains a set of current applicable rates based on published rates and based on rates specified in its service contract. This set of current applicable rates is used to generate customer data and to generate an expected fee for each call.
In the further illustrative example, the service provider's published rate table indicates that outbound international calls made to numbers are governed by rates in Schedules A and B, unless otherwise explicitly stated in a customer's service agreement and unless the calls are made to numbers governed by rates in Schedules X, Y, and Z. In the illustrative example, the customer may have negotiated a service agreement that specifies, for certain outbound international calls that otherwise would have been governed by Schedules A or B, a customer rate table “C”. Rate table C may specify that Singapore and Brazil are included in rate table C.
When billing data is received from the billing entity, the customer may parse or extract the call details from the billing data. The call details may then be used by the customer to identify the rate information the customer believes is applicable. This identification may be performed by comparing the call details to a database or set of rate information maintained by the customer (e.g., based on the published rate schedules and based on the contract rate information). An expected fee can then be calculated for each call included in the call details.
In the illustrative example, two calls are included in the call details. A 0:42 call from the U.S. to Singapore and a 1:18 call from the U.S. to Brazil. The billing entity assessed fees of $2.04 and $1.93, respectively. The customer may independently calculate the expected fee by first identifying that the two calls should be governed by the rates in rate table C, and then by applying the rates of rate table C to the call details. For example, rate table C may indicate that the call to Singapore be calculated using a time-based fee of 0.077 and a fixed fee of 0.080 for a total expected fee of $0.88. Similarly, calculations may show that the call to Brazil should have been calculated as a 0.234 time-based fee and a fixed fee of 0.80 for a total expected fee of $1.05. The customer may then compare the expected tee to the billed fee to identify a discrepancy between the two tees. Further processing may be performed to determine whether the discrepancies are errors that should be disputed with the billing entity.
Embodiments have been described with respect to several embodiments. Those skilled in the art will recognize that various substitutions and alternatives in the embodiment described herein would not depart from the spirit and scope of the present invention.
The present application claims priority benefit under 35 U.S.C. §119 of U.S. Provisional Application No. 60/422,942, filed Nov. 1, 2002, the disclosure of which is hereby incorporated by reference.
Number | Date | Country | |
---|---|---|---|
60422942 | Nov 2002 | US |
Number | Date | Country | |
---|---|---|---|
Parent | 12638869 | Dec 2009 | US |
Child | 13681540 | US | |
Parent | 10700353 | Nov 2003 | US |
Child | 12638869 | US |