PowerDev have developed a system for the Energy Networks Association (ENA) to reconcile call charges for the electricity supply single emergency number (SEN) 105. This number is usually called to report electricity supply power cuts. The system imports call data from a downloaded text file and checks each call to ensure it has been charged at the correct tariff. The system also creates invoice information based on where each call has been made from, so that calls can be charged to the correct service recipient.
The system was developed as an MS Access front-end, with a SQL Server back-end, and processes hundreds of thousands of records each month. The system outputs PDF and MS Excel reports for validation and invoicing purposes. The call reconciliation uncovers frequent tariff discrepancies that are taken up with the provider.