Posts By Jeff Ulanoski

Notes from the Field: Presentation to IFO Chapter Meeting Focuses on Finding Lost Vendor Credits as Part of an Automated Statement Audit Process

Tuesday, August 7th, 2012

Last month I shared some thoughts about a recent trip to Minneapolis where we presented The Future of AP at an industry lunch & learn session.  I’d like to spend a few minutes now with some ideas about a second presentation I made on this same trip, this one at the IFO Northern Lights Chapter meeting.  This presentation focused on vendor credits and how to ensure that credits are identified and taken in a timely fashion.  Attending the meeting were AP professionals from retail, services, and health care, and across the board, the entire group believed that they needed a process to identify and collect their post-audit vendor credits, as they do not presently have a method in place to ensure that all available credits are identified and collected.

The question of how credits that are over 90 days old have an increased chance of disappearing off the suppliers books began the discussion.  This is due to many different issues which Mary Schaeffer, Editor and Publisher of Accounts Payable Now and Tomorrow addresses in her white paper report The Case of the Disappearing Credits.  I had the pleasure of presenting with Mary at Fusion 2012 in Nashville earlier this year on this topic, and was able to share with the IFO chapter group a few valuable insights into where these credits go and how companies can mitigate the risk of losing credits that are due to them.

I found the most important finding  Mary’s report revealed  is that to ensure that you are getting all of your credits you must have an automated process in place that identifies credits on a continuous, timely basis.  A periodic statement audit project — conducted once a year or every two years — will miss many credits.  An ongoing process, however, will point out the root cause issues responsible for the  missed credits – as they happen.  If you receive root cause analysis two years after the fact, you will have two years of credits missing.  Early discovery of why credits are happening is essential to conducting a best practice statement audit methodology.

I then gave an overview of the Lavante Recovery+ solution, which provides a technology-enabled, continuous recovery audit process.  Because the solution is web-based and delivers results in real time, it provides the root cause analysis and vendor compliance statistics that enable our customers to immediately identify what is driving these outstanding credits.

Below is a good example of how customers have used the analytics provided by Lavante Recovery+ to fix process issues and reduce credits.  This chart,  from a global retail pharmaceutical organization, shows that the organization had an issue in 2010 with returns.  Because the company could identify the cause of these credits using the drill-down access to all credit details, they were able to stem the credit tide and eliminate returns as an issue in 2011.  Without a continuous process, discovery and resolution of the problem would have been delayed resulting  in more return credits that disappear.

To assure that all credits are captured, Lavante Recovery+ performs automated outreach and statement requests to the entire vendor master file (excluding any do not audit vendors) and identifies outstanding credits across the breadth of the vendor population, not the typical top 10 or 20 percent traditional recovery solutions target through a supplier profiling process.  This process ensures that the customer is obtaining a best in class solution to their open credits opportunity.

Many of the companies in attendance at both sessions were aware that opportunities existed in their AP processes.  They realize that changes are coming their way and that being proactive in addressing the problems provides them the greatest prospect of success.  Lavante offers tools and applications that assist in driving the success of our customers by providing them with real-time actionable data and control over the recovery processes.

In the coming months look for more information regarding our recovery and supplier information management solutions. I hope to see you at one of our events or seminars in the near future.  In the meantime, please feel free to provide feedback and comments about how you are handling your statement audit process.

 

divider image

A Leading Healthcare Provider Recovers $300,000 in Lost Credits Thanks to a Lavante Recovery Process

Monday, July 16th, 2012

Earlier this year, Lavante Recovery+ recovered an over $300,000 credit for our client, a  leading healthcare provider.  The story of how this credit was identified and recovered is a testament to the effectiveness of an ongoing, continuous audit that leverages technology to update supplier contact details through an extensive supplier network all while providing real time visibility into the relevant supplier communications and audit details.

Here’s how it happened.  In late 2009, a statement was received from a vendor showing little activity and no credits.  A few months later, as a part of the periodic supplier statement refresh process, Lavante requested updated information from this vendor.  At first, the vendor did not respond and the credit, created only two months after the last statement was received at Lavante, went unnoticed.  Luckily for this healthcare provider, however, Lavante’s communications with the supplier didn’t stop there.  When subsequent automated requests went unanswered, they were followed up with phone calls to obtain updated information, a process which was accelerated because several key pieces of contact information (phone number and fax number) were updated automatically through Lavante Supplier Network™.  Once the statement was received from the supplier and processed through Lavante”s automated Fax to OCR technology, the credit was quickly identified.  Immediately, follow up began as Lavante’s experienced audit specialist went to work to contact the vendor and verify the claim.  In subsequent discussions with the vendor, she discovered that the credit was generated when the healthcare company cancelled an already paid-for project and the money was left on the books and overlooked.  The vendor told the auditor that they would be willing to issue a refund check to clear the item.  For nearly two and a half years, the vendor was just waiting for someone to claim this money and was glad when they were able to properly close the transaction.

Lavante Recovery+ shows the number of suppliers changed

Figure 1:  This graph shows the number of vendor details which have  been updated using the Lavante recovery process.
In this example, over 7,000 suppliers have been updated, which equals over 60% of the suppliers contacted.

Successful credit recoveries after communications between the buyer and the supplier have ceased depends on access to up-to-date supplier contact information.  This credit had been aging undetected for over two years, and without updated records that could drive successful outreach, this large credit could have eventually been lost forever.  Mary Schaeffer, Editor & Publisher of AP Now and Tomorrow, speaks to this danger in the whitepaper, The Case of the Disappearing Credits , in which she exposes the potential for companies to permanently lose vendor credits if an ongoing, comprehensive statement audit is not practiced.  The paper reinforces the lessons learned with this large credit recovery that a continuous recovery methodology is critical to a successful statement audit.  With such an effort, companies realize on-going dollars to the bottom line coupled with the reassurance that no vendor credit goes unnoticed and unclaimed.  Furthermore, it is critical that vendor outreach is part of the Accounts Payable process to ensure credits are identified accurately and on a timely basis.

Another part of this recovery process is giving the user full visibility into the audit process – in real time.  As shown in the Figure 2 below, the Lavante Recovery+ user had full access to all related documents, including the credit verification and check request forms, through an automated workflow interface.  The Lavante auditor was able to coordinate all efforts via this same portal, and the refund was delivered in less than 30 days after it was first identified.


Figure 2: Users can quickly review and process credits online through the Lavante Recovery+ application interface, which provides click-through access to all back-up documents.

Needless to say, the healthcare provider was delighted with the results, and saw yet another benefit from an ongoing recovery process instead of using more infrequent project-oriented audits.  They stated they would have been impressed with a $30,000 credit, but were absolutely amazed that a credit over ten times as large had gone undetected by normal AP controls and was quickly resolved by Lavante.

As Mary Schaeffer finds in The Case of the Disappearing Credits, “…an ongoing process means the maximum credit dollars can be recovered in a timely basis.”  The very real impact of a continuous recovery process detailed in this example reinforces the critical components a recovery solution must contain in order to drive this level of results, which include: including the ability to:

  • •    Perform ongoing outreach to the breadth of the supplier base;
  • •    Leverage an expansive supplier network;
  • •    Provide real-time access to the entire audit process through an on-demand web portal;
  • •    Include an experienced audit team that can see claims through to the end.

A more traditional audit project simply does not have the capability and software to execute this level of success.  Lavante’s process ensures statements are received, credits identified, and accurate results are delivered to customers on a regular basis.  I welcome your feedback about this process and learn more about how you are working to resolve unclaimed credits at your company.

______________

Added note.  Jeff recently joined Lavante as a Sr. Consultant, coming to Lavante after his position as Director of AP at Rite Aid.  Click here to learn more about Jeff’s experience in the AP industry.


 

 

divider image

Notes from the Field – AP Discussion Increases around the need for Effective Supplier Management Processes

Thursday, July 5th, 2012

AP professionals discuss industry trends at Lavante lunch & learnLast month I had the pleasure of visiting Minneapolis to participate in two separate events – a lunch & learn session co-sponsored by Lavante, Basware and the IOFM, followed by the Northern Lights IFO chapter meeting. Here, I’ll focus on discussions that took place at the first event, and I’ll return next week with some thoughts about the second presentation.

The lunch & learn which took place at a great steak house in downtown Minneapolis, The Future of AP: Five Changes Coming to AP, focused on some key challenges facing corporate AP professionals. In attendance were individuals from both small to large organizations and across a range of industries (manufacturing, retail, financial services, education, and healthcare).

As usual, the topic elicited much discussion, with considerable attention given to a challenge facing most of those in attendance–that of keeping their vendor master file accurate. While most attendees agreed that they perform an initial validation of the vendor data while setting up the vendor, there was not as high a consensus that they had an on-going system of checks and balances related to changes to existing vendors and on-boarding of new vendors. It was noted that there break-downs in this process caused many critical issues. For example, the same vendor can, and often does, get setup in the vendor master file multiple times. Or, as a result of mergers and acquisitions, related vendors are not identified. These issues can cause companies to miss purchase volume discounts as well as hinder their ability to take credits for returns. Additionally, it is impossible for the organization to calculate an accurate spend file by vendor, which can negatively impact contract negotiations. And this impacts not only finance, but procurement and in the end, the company’s bottom-line.

As we discussed at the event, there are multiple ways to handle the maintenance of data in the vendor master file, but the best practice which I adhered to during my tenure as Supervisor, AP at Rite Aid, is to:

  • • Start with a thorough cleansing of existing vendors.
  • • Incorporate an ongoing process that ensures new vendors are thoroughly analyzed, compared to the existing vendor master file, with updates made continually.

I found that the most efficient way to accomplish this was to partner with a third party company. Furthermore, that solution should have access to a vendor data network which can be leveraged to assure accuracy of the vendor master file. At the same time the use of a self-service portal application would allow vendors to update information as well as store required documents and validate TIN numbers — in real time. This type of supplier portal will increase collaboration between the buyer and supplier while providing a repeatable, ongoing process that ensures vendor information is accurate, complete and up-to-date.

Lavante has technology-enabled solutions to help deal with this and other related problems – Lavante Recovery+ and Lavante SIM (Supplier Information Management), which offer a way to automate many of these processes through our on-demand, SaaS-based software solutions. With them, users have a way to not only collaborate with suppliers via a web-based tool, but they allow complete visibility in the supplier base to identify related and duplicate vendors (all in real-time!), and to keep vendor information current. Part of this process is collecting and validating critical regulatory items – such as TIN matching and OFAC screening. And, the solutions leverage Lavante’s comprehensive supplier network, which increases vendor data accuracy and speeds up the cleansing process.

Here is one screen shot from the Lavante application showing the supplier compliance dashboard pharmaceutical company, demonstrating the number of suppliers which were updated and possible related suppliers identified through the update process.

For more information about Lavante solutions please visit www.lavante.com

I’ll have more notes on my second presentation in Minneapolis next week. In the meantime, please feel free to contact me with questions or comments.

Jeff Ulanoski, Sr. Consultant Lavante

 

divider image