Posts Tagged ‘benchmarking’

Maintaining Supplier Data and Information to Maximize ERP Systems and 1099 Reporting Compliance (Part 1)

Monday, July 12th, 2010

Supplier information is integral to optimizing your relationships with your suppliers and for maximizing the value from your ERP system and other automated solutions.  Used correctly, a well kept supplier master data file is a strategic asset that can be leveraged into time savings, resource savings and dollars to your company’s bottom line. 

The biggest challenge to maintaining the quality of your supplier data is its near immediate decay after being recorded.  Suppliers constantly undergo mergers, purges, acquisitions and employee churn that challenge the integrity of their data.  Dun & Bradstreet (D&B) reports its database of businesses experiences annual changes of 20% for addresses, 17% for business names, and 18% for phone numbers underscoring how quickly and frequently supplier data decays.  ERP systems perform some data quality measures at the time a supplier is set up, but they do little to preserve the integrity of the data over time.  ERP systems are reliant on quality data, but they do not ensure it.

Allowing your supplier data to decay over time is very costly to your enterprise. Inaccurate data delays implementation of ERP systems and other automated solutions and can prevent those solutions from achieving their optimal ROI, effectiveness or their value over time.  Failure to identify overlaps or relationships within your supplier population can lead to missed volume discounts or rebates as well as an increase of duplicate payments by up to 300%.  Poor supplier data quality is also very costly in terms of lost efficiency and time.  Bad addresses alone can lead to miss-sent shipments and checks.  Quality supplier data is also vital to stay in compliance with various external regulations and internal controls.  Failure to achieve this compliance can be both disruptive and very costly while causing great exposure and risk.

Collection and management of supplier data is more important now than ever.  New 1099 tax legislation included in the funding provisions of the Patient Protection & Affordable Care Act (March 2010) requires companies to collect valid Tax Identification Numbers (TINs) on a much larger scale than pre-legislation levels.  Today most companies are expected to perform 1099 reporting for less than 10% of their supplier population. When the new law takes effect, companies can expect reporting levels to rise above 90%.  Companies will need to implement new policies and potentially even new systems to manage supplier information more accurately in pursuit of staying in compliance.

The question arises: How are you going to ensure the ongoing quality of supplier information to achieve optimal project ROI and on-going efficiency while maintaining compliance with controls and regulations? 

Check back for part two.

Dynamic Discounting

Tuesday, May 18th, 2010

In my very unscientific research I have come to discover that Dynamic Discounting is all the rage, but that doesn’t exactly mean people are doing it.  During the “Changing Role of AP/AR” panel discussion at last Wednesday’s Masters Session a number of the panelists and and brave souls from the audience spoke very openly about how they are not really slaying this dragon… yet. 

When one panelist asked aloud if the room was engaging successfully in the practice only about 3 hands when up all the way…  there were one or two of those “half-up-but-not-really hands.”  I will not call anyone out but among the firms successfully using dynamic discounting were two large fortune 50 stalwarts.  Even they had to admit that they targeted vendors were of a select group and that procurement was still very much debating if they should negotiate longer terms and stay away from the early pay discounts.

Just thought I would shed a little light for those in the crowd that think they missed this train.  The conclusion:  People LOVE the idea of a successful dynamic discounting program and this topic has major buzz, but like most things… not many people can really sustain the practice and it remains in “when-I-have-time-to-get-around-to-it” limbo.

Please comment if you have plans to make this practice work internally or if you have input on the topic.  Would love to get more data on this.

IAPP Masters Session at FUSION 2010 (part 1)

Saturday, May 15th, 2010

There is a wonderful story behind IAPP/TAWPI’s Master’s Sessions at FUSION2010…

In addition to record attendance, five guided service provider tours and a blockbuster announcement about the merging of IAPP/IARP & TAWPI, FUSION 2010 also saw the introduction of a brand new track specifically designed for CFO, Controllers and Directors in Shared Services.

The track was conceived almost a year prior to FUSION 2010 and required the successful alignment of many moving pieces.  IAPP’s annual conference has long been considered an event for AP professionals, managers and supervisors.  To its credit the yearly networking and educational bazaar has become the premier event for all things AP and has consistently delivered payables professionals the necessary tools needed to keep up with best practices and excel at their roles.  Unfortunately the event did very little to help dispel that silly little question that has been plaguing AP pros for years, “what’s so difficult about AP?  It’s just paying bills, right?”

Expanding on the years “FUSION” theme the Master Session aimed to create a track that would speak to the combined Master’s audience and planned to placed much emphasis on Shared Services topics with a consistent focus on Accounts Payable themes.   If done correctly the track was intended to discuss AP issues at a level which would be relevant to both the CFO, the AP Manager and all stops in between.

A task force of service providers and financial professionals was assembled and after months of much hard and many iterations the group finally delivered an all-day session consisting of five panels comprised of 4-5 experts.  Topics included:

  • The Top Ten Best Practices of Shared Services
  • The Changing Role of AP and AR
  • Metrics and Benchmarking in Accounts Payable & Shared Services
  • Compliance Management
  • Selecting the Proper Service Delivery Model for your Department

 (check back for part 2)

Days Credits Outstanding – a new metric for managing cash flow

Saturday, April 24th, 2010

Days Sales Outstanding (DSO) and Days Payables Outstanding (DPO) are important, widely used metrics to manage working capital.  Financial managers monitor these statistics very closely and regard them as key performance indicators as they work to maximize overall cash flow as well as transactional efficiency.   Through our audit work communicating with extremely large numbers of vendors for Fortune 1000 enterprises, we have begun delivering significant value to our clients based on a new metric that measures and standardizes an important aspect of accounts payables financial efficiency – Days Credits Outstanding (DCO).   

DCO focuses on open credits that are typically not visible to your internal accounting personnel.  Specifically, these credits are aging on your vendors’ and suppliers’ receivables ledgers and, for a variety of reasons, may be outside of your books, or at least not specifically identified with the vendor.  DCO measures the amount of time that outstanding credits are open and available on your vendors’ accounts receivable records before you are able to actualize them as cash to your bottom line.  Allowing your DCO to grow means your cash inflow is being delayed. Given the time value of money, this represents lost cash, even if eventually you do recover the credits.

While aged vendor-side credits are sometimes known to your company, more often they’re not; they’re essentially unseen or lost dollars.  In fact, based on over a million data points, Lavante research indicates that after an open credit has aged over 90 days, you have less than a 20% chance of recovering that credit without third party intervention.   These “lost” dollars add up and can grow to a staggering one and a half million dollars per every billion dollars spent.  Tracking DCO enables your company to bring the management of these dollars in line with your existing standards for managing working capital.

In addition to cash timing implications, it is also important to consider the financial exposure that increased attention to DCO can reveal about your company.  A growing DCO is an indicator of risk because there is a proven likelihood of vendors using unreturned credits to offset unearned discounts and disputed invoices, or otherwise disposing of them as they age beyond a reasonable period.  Ultimately, unclaimed credits that are not used by the vendor are escheated, that is, turned over to the state.  In all of these scenarios, you are losing the cash forever.  A focus on DCO will help bring visibility to the dollars outstanding while driving the age of these items as low as the aging scope cut-off of your audit will allow.

The introduction of DCO as a key performance indicator is significant because it adds a new measurable element to cash management.   It encapsulates the fact that not only is it important to actualize all open credits, but it is also important to realize these dollars in the fastest time frame possible, thus maximizing cash flow.  The cash flow implications of DCO are as relevant to cash management as preventing early payments, or even taking all of your discounts. 

Lavante, with our unique ability to comprehensively collect and analyze vendor-side AR records and thus uncover these “lost” credits, is calculating the DCO metric as part of our audits.  Our clients use it to help them manage their cash flow and as a key indicator of the transactional efficiency of their accounts payables process.

Vendor Credit Recovery

Saturday, April 24th, 2010

Vendor credit benchmarking from the front lines.

Every industry has its fair share of reports, surveys, data points, and sound bites.  The Profit Recovery industry is no different.  In the last few years we have performed quite a bit of analysis and benchmarking to uncovered some compelling data  about recovering credits from your vendors and suppliers.

From a survey of over 100 clients and prospects we have discovered that most traditional recovery providers sample only the top 5-20% of your vendor population when reviewing vendor-side credits?  Our survey elaborates (based on feed back from AP professionals) that without the aid of a communication compliance engine (Lavante is the only firm with such an app.)  traditional statement audit reviews, whether they are done by third party firms or by internal efforts simply cannot support indepth vendor penetration with manual methods and cap out at 20%. 

Our vendor credit recovery benchmarking demonstrates that 61% of vendor credit opportunity resides in the lower 80% of your vendor file.  To put it another way, traditional manual methods, will find, at most, 39% of credits available to you.

Another fact you may not be aware of is that 37% of vendor-side claims come from product returns.  This category is by far the largest we are tracking.  And it has huge implications not only to the existing process you have for returns transactions, but also on where your profit recovery audits should focus.  In contrast, we’ve found that only 9% of vendor-side claims are the result of duplicate payments.  Keep in mind that hese numbers vary depending on industry.   

Some other interesting metrics indicate that the average claim amount from a vendor credit recovery review is $817.  (with a range of about $400-$1200)  We have also discovered that the actual recovery potential for vendor credit recovery is $600,000 -$900,000 per $1Billion in addressable spend volume. Although we are the only recovery provider to project recoveries below the typical industry benchmark ($1M per $1B in spend) we feel confident that this carefully calculated metric passes both the scientific test and a gut test as well.  When we approach new prospects and we explain that depending on their industry they stand to recovery within this range that data is always well received based on what they have actually seen from other firms and not what they have been promised.

Based on our discoveries, we have also determined that for every month you do not perform an in depth automated vendor credit review you risk  losing $63,000 per billion dollars of spend with no chance of recovering it.  While $63,000 may not be a huge amount for you, if you spend multiple billions of dollars, and delay just a quarter’s time, that $63,000 figure becomes a large sum of money.

If you have any more questions about our benchmarking survey please join the conversation…

IAPP Masters Session

Thursday, April 1st, 2010

From the IAPP website:  THE MASTERS SESSION (At Fusion 2010 – for CFOs, Controllers, and Senior Shared Service Leaders) Wednesday, May 12, 2010 9:45 am – 5:15 pm

The Masters Session is not a seminar. It is an opportunity to engage in thoughtful discussion with your peers in the business world. There will be no Powerpoint presentations. There will be no team building exercises. There may be some motivational speakers, but they will be sitting right across the table from you. Or, it may even be you.

The Masters Session is not for everyone. CFOs, Controllers, and Senior Shared Service Leaders are invited to participate because you represent the pinnacle of leadership in AP, AR, and financial accounting. Invitations are non-transferable, however, you are welcome to bring one member of your team, and if you do – your attendance is free of charge.

The Masters Session is designed for you. This event is being developed by some of the world’s most innovative business finance leaders. These experts will initiate discussion and moderate the discourse, ensuring a valuable, high-quality experience for top-ranking financial executives. See core topics for discussion here.

The Masters session is designed by you. This is an invitation not just to attend, but to help formulate the event. What issues do you need to address? Which challenges do you need the most help with? Tell us, and we will include it in the discussion. Chances are, what matters to you also matters to your peers. And that’s what matters to us. Upon registration, send your discussion topics in advance of the event to masters@theIAPP.org

The Power of the Software Demo

Tuesday, March 30th, 2010

I have noticed a pretty compelling trend as it relates to our sales cycle and trade shows. 

Most shows in the AP space place a heavy emphasis on attendee education and offer a number of tracks for everyone to attend and learn about the latest trends in the Accounts Payable.  All of these shows accept sponsorship from service providers and create a forum for professional in the space to interface with service providers to encourage education about service providers’ offerings.

The most common type of attendee/sponsor interaction is a tradeshow floor which as most of you know consists of colorful booths and clever give aways. Shows which offer these types of forums are very helpful and always fun.  Another type of interaction are the shows that, in favor of a tradeshow floor, offer a series of one-on-one meetings between professionals representing major corporations and service providers.  These shows are typically smaller and have a very different feel about them.

SO why am I bringing all this up?  In our business we usually experience a 120-150 day sales cycle.  That is to say, it takes about 4-5 months to meet a new company, educate them on our software products and begin doing business with them.  This average is actually good for our particular market, but it is certainly not the fastest sales cycle.

An interesting trend has been revealed; when we attend typical trade shows we close business in our average sales cycle, but when we attend shows with one-on-one meetings we drop our sales cycle down to 60-75 days.  In other words when we meet with buyers and show them our software on “day one” they buy from us in half the time.

It has ocurred to me that this particular blog may be better suited for a marketing blog, but I think this empirical data says a lot about the AP industry.  I believe professionals in this space are open to adopting new technology, but it is sometimes difficult to convince buyers that we have a new and unique approach.  A lot of providers are using the same phrases, ”faster,” “new techology,” more recoveries,” etc.   In most cases the first half of the 120-150 day sales cylce is convincing the buyer that we really are different.  When we finally get that point across and we earn the right to demonstrate our software… that is when the sale begins to accelerate.

Days Credits Outstanding – a new metric for managing cash flow

Thursday, March 18th, 2010

Days Sales Outstanding (DSO) and Days Payables Outstanding (DPO) are important, widely used metrics to manage working capital.  Financial managers monitor these statistics very closely and regard them as key performance indicators as they work to maximize overall cash flow as well as transactional efficiency.   Through our audit work communicating with extremely large numbers of vendors for Fortune 1000 enterprises, we have begun delivering significant value to our clients based on a new metric that measures and standardizes an important aspect of accounts payables financial efficiency – Days Credits Outstanding (DCO).   

DCO focuses on open credits that are typically not visible to your internal accounting personnel.  Specifically, these credits are aging on your vendors’ and suppliers’ receivables ledgers and, for a variety of reasons, may be outside of your books, or at least not specifically identified with the vendor.  DCO measures the amount of time that outstanding credits are open and available on your vendors’ accounts receivable records before you are able to actualize them as cash to your bottom line.  Allowing your DCO to grow means your cash inflow is being delayed. Given the time value of money, this represents lost cash, even if eventually you do recover the credits.

While aged vendor-side credits are sometimes known to your company, more often they’re not; they’re essentially unseen or lost dollars.  In fact, based on over a million data points, Lavante research indicates that after an open credit has aged over 90 days, you have less than a 20% chance of recovering that credit without third party intervention.   These “lost” dollars add up and can grow to a staggering one and a half million dollars per every billion dollars spent.  Tracking DCO enables your company to bring the management of these dollars in line with your existing standards for managing working capital.

In addition to cash timing implications, it is also important to consider the financial exposure that increased attention to DCO can reveal about your company.  A growing DCO is an indicator of risk because there is a proven likelihood of vendors using unreturned credits to offset unearned discounts and disputed invoices, or otherwise disposing of them as they age beyond a reasonable period.  Ultimately, unclaimed credits that are not used by the vendor are escheated, that is, turned over to the state.  In all of these scenarios, you are losing the cash forever.  A focus on DCO will help bring visibility to the dollars outstanding while driving the age of these items as low as the aging scope cut-off of your audit will allow.

The introduction of DCO as a key performance indicator is significant because it adds a new measurable element to cash management.   It encapsulates the fact that not only is it important to actualize all open credits, but it is also important to realize these dollars in the fastest time frame possible, thus maximizing cash flow.  The cash flow implications of DCO are as relevant to cash management as preventing early payments, or even taking all of your discounts. 

Lavante, with our unique ability to comprehensively collect and analyze vendor-side AR records and thus uncover these “lost” credits, is calculating the DCO metric as part of our audits.  Our clients use it to help them manage their cash flow and as a key indicator of the transactional efficiency of their accounts payables process.

AP Best Practices: Its all about the people

Friday, March 12th, 2010

In the December-January time frame we ran a contest asking AP professionals what was their great idea for 2010.  We were a little bit surprised by the high number of responses, but what was even more surprising was a very consistent trend throughout the responses.

2009 was a challenging year and many AP departments were forced to downsize drastically while, at the same time, finding new an more effective methods to hold onto cash and absorb the exponentially growing work load.  We kind of expected to read about new an innovative ways to outsource duties or to utilize new technology.  We also expected to see responses that outlined clever approaches to cash management.  And we did get some of that.  But what we heard above all else was a focus on people.

Hands down, staff development is the single most important concern for AP professionals based on our survey.  Some people summed it up by saying “we need to go back to basics, and empower the staff”  others pointed out that “technologies and processes are only as strong as the people pulling the levers.”  Regardless of how it was stated… it was stated.  Last year the battle cry heard round the industry was “cash is king.”  Perhaps this year’s new mantra is, ”people are gold.”

Maybe you can think of a better one ;-)

Benchmarking: the Brussels Sprouts of Business

Tuesday, March 9th, 2010

I work with a professional organization in the Accounts Payable space that is currently spending a lot of time on bringing members together to network and to share ideas about best practices.  There is no shortage of people that are willing to speak about their experiences.  People are often eager to dispense anecdotal wisdom.  What is more difficult to come by however, are the benchmarks and metrics that help to gauge and measure success.  Either people to not want to reveal the the report card they have compiled along their bumpy road or they did not keep a report card to begin with.

Benchmarking, Dashboards, Metrics, Report Cards, these things are a lot like the vegetables of the corporate world.  We all know that they are good for us, but we do not always want to partake.  Not surprisingly however the people and companies that use tools to measure and improve their performance are usually in the best operational and financial health.  They same can be said of physical health for those among us who love the green food group.

Find links to key industry benchmarking docs below.  Take a look and see how you stack up.  You will need to either download or become a member to view the data.