Email a colleague    

October 2011

Invoice Audit Productivity: From 19th Century Textile Mill to SaaS

Invoice Audit Productivity: From 19th Century Textile Mill to SaaS

Contact Telecom’s offices are in a converted 19th century textile mill.  In fact, the heavy timber floors above and below you in each office are the same ones that supported the spinning machines, looms and thousands of workers in the mill.

Working in a place like that is a daily reminder of how automation has taken us from sweat factories to air-conditioned offices in just a few generations.  Wonder what those factory workers would say if they knew that 160 years later a SaaS server in the same mill would do the work of hundreds of employees?

Of course, each generation has its own definition of what constitutes “tough work.“ Most of us have probably held a job where either the hard physical demands or sheer boredom of the job taught us the value of the phrase: “Work smarter, not harder.”

For me, the “job from hell“ came in the summer after graduating from college.  While waiting for my first engineering job to start in September, I took a stint helping my kid brother install lawn sprinkling systems.  The work was back-breaking and quite boring, but I took heart in the thought that in a few short weeks I would never again lay plastic pipe in orange-burnt lawns.

Later on, when I worked for a wireless service provider, the leadership supplied the tools to make our tasks less tedious, more interesting.  They also pushed us to “re-invent“ our work and get jobs done quicker and better.  That, in turn, enabled the company to launch and thrive.

Today, of course, automation is everywhere in telecom.  The Excel workbooks of the early ‘90s have given way to predictive analytics on databases.  And innovations in least cost routing and other real-time analysis are making service delivery better, more efficient and more profitable.

What’s Your State of Automation?

So when it comes to invoice reconciliation, are your processes and tools modern and efficient, or is your company stuck in a 19th century time warp?  How do you know if you’re processes need an overhaul?  Well, here’s a quick list of process problems that we’ve seen at service providers:

Your Invoice Reconciliation is behind the times when ...

  • Most of the invoice data is siloed in static Excel spreadsheets or Access databases on various desktops.
  • Your colleagues in the audit process pass work to you via email, phone call or paperwork dropped in your desk’s in-basket.
  • You are constantly reacting to audit fire drills instead of methodically following a process.
  • You struggle to or can’t complete your invoicing audits before the following month’s bills arrive.
  • Further development of your internal audit software won’t happen until the recession ends and IT starts hiring again.
  • You are filing claims for wholesale invoice errors that are costing you more to file than you will actually recover in revenue.
  • You file audit forms and claims via manual or paper processes.

Invoice Reconciliation Automation Case

Service providers often underestimate the staff hours being wasted due to process inefficiencies like the ones I just described.  To give you an idea of the productivity gains you can achieve, I’ve summarized the Before and After case of applying our SaaS tool, BDA, at a U.S. carrier.  It’s a tier 3 carrier in the local telecom and CLEC businesses that grew by acquiring eight to 10 other telecoms in recent years.  The company serves both residential and business customers.

invoice productivity chart

In the chart above, we estimated the number of man hours spent by the company before and after they implemented the SaaS.

The company’s processes were heavily mired in manual processes.  Overall, the “Before“ breakdown shows roughly 80 percent of man hours were devoted to clerical and IT (Red) tasks and only 20 percent on actual auditing (Green) tasks.

In particular, the company was performing lots of data entry to get invoice data into a format suitable for running reports on a home-grown system.  About six of nine people involved in reconciliation were devoted to the data-entry task, and it’s a big reason why it took the company all month to audit its invoices.

Even running the reports was time-consuming because it required auditors to sit at the machine and select “Yes“ or “No” options from hundreds of prompts.

Another big time-waster came from inter-team communication and passing audit steps to back and forth.  These human interactions — emailing, using paper forms, and phoning — slowed the process down considerably.  In addition, if people were pulled away to perform more urgent work, there was no way on checking the status of individual audits so they could be managed and moved forward.  Instead, people needed to wait for the output of other people’s work.

The smaller chart on the right side shows the amazing “After“ results of implementing the SaaS.  First of all, the company was able to reduce the invoice audit team from nine to three people.  Even still, the small team could finish the invoice review cycle in a fraction of the original time, with the staff of three devoting less than two hours a day to meet the schedule.

Overall, audit cycle man-hours were reduced an incredible 90 percent — from approximately 1,100 to only 96 per month.  Best of all, by outsourcing IT functions to the SaaS and eliminating setup tasks such as invoice conversion and poor communications, the actual time spent on high-value tasks (research, auditing, and claim resolution) rose to 92 percent.  Using automation, the analysts are able to focus on the task that requires their attention and knowledge, while the clerical tasks are completed with minimal oversight: invoice collect, tracking, data management, and claim creation, submission and tracking.

Conclusion

The case study I just described is not an exceptional one.  Most of clients have seen similar results.  It’s typical to see audit man-hours reduced by between 80 and 90 percent or more.  Automation removes unnecessary labor and clutter, streamlines the process so the user can be an analyst, and provides a high return on the time invested.

Even with pivot tables and home-grown BASIC routines, the individual user spends considerable time reviewing and manually pushing the process along.  With automation however, you’re able to apply documented rules and criteria to real-time data sets.

In a SaaS application like BDA, an administrator sets the rules and only exceptions are presented for review.  In this way, your priorities naturally float to the top of your audit reports.  What’s more, the conversion of invoices is completely outsourced.  Forms are automatically filled out by the system.  Even claims are filed automatically.  Rather than wasting time sending emails and administering the flow, work is pushed automatically to the user, filling up his or her queue.

Finally, with greater process automation, auditors are freed to what they are trained to do best: audit.  In other words, running the monthly audit check will not longer be a “job from hell.“ Having an excellent tool and process backing them up, your auditors will spend their time productively, chasing down high-value inventory issues as opposed to filing billing claims on issues that cost more to go after than they’re actually worth.

This article first appeared in Billing and OSS World.

Copyright 2011 Telexchange Journal

 

About the Experts

Peter Yelle

Peter Yelle

Peter Yelle is a partner at Contact Telecom LLC .  With more than 20 years of professional engineering and product management experience in the telecom and wireless industries, he has been instrumental in bringing effective telecom solutions to market.  Yelle holds a Bachelor of Science in Electrical Engineering from Northeastern University in Boston.

Related Stories

  • Carrier Usage Audits: Why Regular Checkups Are the Key to a CSP’s Bottom-Line Health by Brian Silvestri — Many telecoms are wholly unaware of the risks of not having a solid usage auditing program for interconnect bills.  Rather than a once-a-year or once-a-quarter audit, this article makes the case for regular monthly audits.  Also discussed are: the different types of audits and organizations involved; the dangers of not auditing often; and factors to consider when selecting a cost-management vendor.
  • Invoice Audit Productivity: From 19th Century Textile Mill to SaaS by Peter Yelle — When it comes to invoice reconciliation, are your processes and tools modern and efficient, or is your company stuck in a 19th century time warp?  This article show how operators can vastly reduce their manual audit steps by automating via a SaaS solution.  The  detailed case study and diagram show which tasks were automated to achieve an 80%+ productivity gain.
  • An Automated Self-Audit Approach to Telecom Cost Assurance interview with Jim Buttafuoco — What’s the value of an automated approach to invoice validation?  This article explains the power of the SaaS model where the vendor supplies the data-processing expertise, relieves the operator of tedious manual work and boosts auditor productivity so more money is saved.
  • Cost Assurance: Dealing with Rating Variety in Wholesale Bills by David West — Validation of intercarrier wholesale invoices seems like a fairly straight forward process.  But regulatory rules and a variety of bill rating methods have made it very complex.  This article details the challenge by walking through a wireless carrier case, then laying out the argument why operators should opt for a custom solution based on a core reporting engine.

Related Articles

  • Tier 1 International Access Solved: Sidestepping the Low QoS & High Cost Risks of Wholesale Connections interview with Manoj Jain — A new wholesale service allows smaller operators to secure indirect Tier 1 access and minimize the hassles, high cost, and risks of tacking up international routes on their own.
  • Connectivity as a Service: Providing Last Mile Access to the Cloud with Private Networks interview with Mary Stanhope — The cloud revolution can‘t leap to the next level till “last mile” access issues are solved.  This article explains how “connectivity as a service” firms deliver access for cloud application providers, enterprises, small business, and telecoms.
  • Roaming Strategy in the Bill Shock Age: Fresh Ideas to Win the Trust of Silent Roamers interview with Jason Bryan — Despite WiFi competition and pricing rules, smart operators can figure out ways to turn roaming into a big winner.  A roaming expert talks about strategies and poses questions that people in the roaming biz need to consider.
  • Coping with Chaos: The Copernican Revolution in Wholesale interview with Jan Dingenouts — Vaporized margins have changed the  wholesale business forever.  A consultant explains the shakeup, the staff cuts, and the new reliance on automation.  Where is wholesale headed and how can retail operators leverage their partner relationships?
  • A Global Voice Network on the Fly: Own It & Manage It Virtually with a Cloud BSS/OSS interview with Rene Mendez — Lease a global IP voice network together with a real-time intelligent BSS/OSS to manage it.  In this interview, you’ll learn the benefits of a virtual network business, one that launches quickly and removes the maintenance headaches and the vast majority of costs needed to build a network from scratch.
  • White Paper: 16 Top Features of a World-Class Wholesale Billing System by Dan Baker — Wholesale billing is one of the most complex areas in the telecom business.  This white paper organizes the capabilities to be considered into 16 advanced billing features.  The paper is a reference guide that will help you plot your path to billing excellence.
  • Solution Vendor & Integrator Partnering: The Key to Enabling an Operator to Meet its Strategic Goals interview with Kirill Rechter — Working with strategic partners is an essential component to the success of any on-going billing project.  In this interview, a billing vendor CEO explains how a software vendor, systems integrator and service provider can best work together to drive the service provider’s business strategy.
  • The Shifting Winds of Wholesale: Building Systems that Adapt to Business Change & Greater Partnering interview with Hassan Iftikhar — Telecom wholesale is radically transforming itself today to support the retail and enterprise wings of the business as they greatly expand their portfolio of digital and partner-supplied services.  This interview discusses the forces driving the change and systems needed in the new era.
  • Why it’s Time to Modernize Financial Clearing for Mobile Roaming interview with Guy Reiffer — The beauty of the roaming clearinghouse is it gives an operator a one-stop-shop for billing and payments.  This interview explains initiatives to improve financial clearing and provide value-added services such as steering and marketing campaigns.
  • Book Review: A Playbook of Tactics on Internet, Cloud, and Network Partnering by William Norton — The internet is a magnificent feat of engineering, but the internet has a commercial side too.  Before anyone receives his flow of internet electrons, an ISP somewhere in the world must get paid — or rewarded in some other way — for making that connection.  So how is this behind the scene interent trading done?  This book opens up the fascinating world of the commercial internet for you to understand.
  • Payment Assurance: Getting a Handle on Poor Billing & Credit Card Processes that Disrupt the Subscription Journey interview with Paul Larsen — As operators increasingly partner with OTTs to distribute video, music, and other content, it’s important to  understand the many issues OTTs deal with in the payments area.  This interview with a payments and direct markteing expert explains the transaction challenges that all subscription billers face.
  • The Business Case for a B2B Collaboration Platform between Operators and OTTs interview with Landry Ndikumasabo — Wanted: a flexible, open software platform that enables operators and OTTs to collaborate, innovate, and make boatloads of money together.  Learn why a European research study concludes that the revenue impact of such a platform could be great.
  • Wholesale Systems: What They Are & Why They are Important to Telecom’s Future interview with Daniel Ölvebrink — Defining whole systems is problematic because it includes a host of functions: from interconnect billing and roaming to routing and partner web portals.  This interview explains the major functions and challenges in a tutorial.
  • The Power Behind Telecom Thrones: Virtual Comms Technologies & Their Vendors interview with Ben Bannister — Virtual communications providers — who provide telecoms with IPX, messaging, roaming, and other network services — are changing the industry landscape.  A leading vendor discusses how the market is evolving and what to watch as the digital ecosystem matures.
  • Special Report: The Road to a Unified Wholesale Platform by Dan Baker — A unified wholesale platform is an idea that’s been floating around the industry for some time.  And in recent years, carriers have made great progress toward the goal.  This TRI-authored white paper explores the top benefits of a unified platform, advanced system features, likely enhancements coming, and vendor selection questions.
  • CABS Revenue Assurance: How Rural LECs can Recover $284 Million in Revenue Shortfalls interview with Darrell Merschak — Independent rural LECs in the U.S. still rely on the AMA/EMI billing formats for CABS billing, even as that format has proven to be highly inaccurate as a source of inter-carrier records.  This interview includes an analysis and discussion of revenue recovery techniques ILECs can use by leveraging SS7 probes.  Also discussed are billing strategies, traffic dumping threats, and the possible fallout from the FCC’s bill-and-keep mandate.
  • Data Integrity Issues Go Global in the Telecom Wholesale Exchange interview with Vic Bozzo — Wholesale systems enable operators to expand their global reach and work efficiently with partners in an increasingly interdependent telco business.  In this article, you’ll learn about: how many subsystems work together in support of the global trading exchange, why data integrity has become critical, and how wholesale business trends are affecting wholesale systems at Tier 1 and mobile operators.
  • Roaming — if Managed Correctly --  Can Be a Spark to Revenues by Brian Silvestri — Major analyst firms are predicting that roaming revenues will almost double in five years.  What’s more, roaming remains at the pivot point of Wireless Carrier strategy.  Drawing lessons from the incredible rise of AT&T’s Digital One Rate Plan, this article points to future challengtes and raises key  questions about how mobile operators will ultimately come to terms with smartphone market profitability, service quality, and data roaming.
  • LTE Analytics:  Learning New Rules in Real-Time Network Intelligence, Roaming and Customer Assurance interview with Martin Guilfoyle — LTE is telecom’s latest technology darling, and this article goes beyond the network jargon, to explain the momentous changes LTE brings.  The interview delves into the marriage of IMS, high QoS service delivery via IPX, real-time intelligence and roaming services, plus the new customer assurance hooks that LTE enables.
  • Virtual Operator Life: Enabling Multi-Level Resellers Through an Active Product Catalog interview with Rob Hill — The value of product distribution via virtual operators is immense.  They enable a carrier to sell to markets it cannot profitably serve directly.  Yet the need for greater reseller flexibility in the bundling and pricing of increasingly complex IP and cloud services is now a major channel barrier.  This article explains what’s behind an innovative product catalog solution that doubles as a service creation environment for resellers in multiple tiers.
  • Partner Settlement: The Adaptable Chameleon that Lives Between Wholesale and Retail Billing interview with Arun Kalavath — Partner settlement has been around a long time, but its profile is on the rise because wholesalers are offering new services and content services are bringing settlements into the retail sector.  In this article, you’ll learn about the market forces changing the wholesale business, the expanded portfolio of services that require settlement, and advice on how to pick a settlements solution vendor.
  • Carrier Usage Audits: Why Regular Checkups Are the Key to a CSP’s Bottom-Line Health by Brian Silvestri — Many telecoms are wholly unaware of the risks of not having a solid usage auditing program for interconnect bills.  Rather than a once-a-year or once-a-quarter audit, this article makes the case for regular monthly audits.  Also discussed are: the different types of audits and organizations involved; the dangers of not auditing often; and factors to consider when selecting a cost-management vendor.
  • Partners in Carrier Management: The Success Story Behind T-Mobile’s Fiber Rollout in Wireless Backhaul interview with Bryan Fleming — Wireless backhaul is the unsung hero of the smartphone’s success.  This interview with T-Mobile’s carrier management architect for backhaul reveals the behind the scenes game plan for one of the most ambitious wireless interconnect programs ever.  You’ll learn about: the reasons for adopting a full-scale fiber strategy; the challenge of finding carrier partners; the clever techniques T-Mobile used to simplify and cut costs; advice on building great relationships with suppliers; and the key role that analytics, assurance, and visualization software played.
  • CABS Revenue Assurance Disputes: May the Carrier With the Best Data Win by David West — Revenue assurance innovation is far easier when partners cooperate to make it happen.  This articles shows how a U.S. operator, software vendor, and consultant teamed to develop a breakthrough in Carrier Access Billing (CABS) assurance.  Learn about: the dispute resolution data gap that needed to be filled, the partnering strategy, the implementation challenges, and payback results.
  • Invoice Audit Productivity: From 19th Century Textile Mill to SaaS by Peter Yelle — When it comes to invoice reconciliation, are your processes and tools modern and efficient, or is your company stuck in a 19th century time warp?  This article show how operators can vastly reduce their manual audit steps by automating via a SaaS solution.  The  detailed case study and diagram show which tasks were automated to achieve an 80%+ productivity gain.
  • Roaming Fraud: The Importance of Real-Time Data Exchange and Analysis interview with James Stewart — The Near Real Time Roaming Data Exchange (NRTRDE) is a GSM standard allowing operators to gain fast access to the roaming records of service providers half way around the world.  The article explains how 65 carriers are using this data to combat fraud through a service bureau.  Learn about the dangers of international roaming fraud and the value a roaming service bureau brings to the table.
  • Is Your Company Penny-Smart and Dollar-Foolish in Auditor Productivity? by Peter Yelle — Operators who fail to automate their invoice reconciliation process could be seriously undermining the morale and efficiency of their most valuable auditors.  This article explains the many subtle ways that manual auditing process can cost operators money.  Also presented is an analysis of the typical returns achieved by CSPs with mature cost assurance programs.
  • An Automated Self-Audit Approach to Telecom Cost Assurance interview with Jim Buttafuoco — What’s the value of an automated approach to invoice validation?  This article explains the power of the SaaS model where the vendor supplies the data-processing expertise, relieves the operator of tedious manual work and boosts auditor productivity so more money is saved.
  • Cost Assurance: Dealing with Rating Variety in Wholesale Bills by David West — Validation of intercarrier wholesale invoices seems like a fairly straight forward process.  But regulatory rules and a variety of bill rating methods have made it very complex.  This article details the challenge by walking through a wireless carrier case, then laying out the argument why operators should opt for a custom solution based on a core reporting engine.