Regularly Recover Duplicate Payments

Regularly Recover Duplicate Payments

AUTHOR

chiefstaff

TIME TO READ

minutes 

UPDATED ON

January 8, 2019

By Doug Hudgeon

The Cost Management Tip

It may seem surprising to those not intimately familiar with vendor payments, but large companies regularly pay vendors twice or more for the same piece of work. An easy way to improve your operating efficiency is to ask for that money back. It’s not difficult to find most of the recoverable duplicate payments and, provided the vendor is still in business, they always give it back without fuss (in my experience). This is such a tried and true method of generating cash that a small industry has sprung up to recover duplicate payments for large enterprises. These Recovery firms typically expect that they will find 0.75% in recoverable payments. This is an astonishing $750K on a $1B in AP transactions. You probably won’t get this much if you do it yourself but, if you haven’t done this before, don’t be surprised if you find $250K in duplicate payments on $1B in AP transactions. The tools and techniques used by these Recovery firms are often quite advanced but you can identify most of your duplicates without their services by following this simple process: 1. Get a data extract from your Accounts Payable system with the following fields:

  • Vendor ID
  • Vendor Name
  • Payment Voucher ID
  • Invoice ID
  • Payment Amount

Start with a couple of years of data if you can. 2. Put the data into Excel and add a new column named Normalised Vendor Name and populate by stripping out spaces and non-alphanumeric characters from the Vendor Name field. For example, “A.B.C Inc.” in the Vendor Name column becomes “ABCInc” in the Normalised Vendor Name column. 3. Add a new column named Normalised Invoice ID and populate by stripping out the spaces and non-alphanumeric characters from the Invoice ID. 4. Add a new column named Normalised Payment Amount and populate by rounding to the nearest $10. For example, $33.24 and $34.55 both become $30. 5. Sort descending by Normalised Vendor Name, Normalised Invoice ID and Normalised Payment Amount. 6. Review the list and look for duplicate Normalised Invoice IDs with the same Normalised Vendor Name. These payments are usually duplicates. 7. Look also at Duplicate Normalised Amounts with the same Normalised Vendor Name. Most of these payments will not be duplicates but some may be. Related web sources I’m taking the easy way out here and simply posting a link to a google search for one of my favourite business euphemisms: Profit Recovery Firms. Related books

  • Cost Recovery: Turning Your Accounts Payable Department into a Profit Center shows how to identify a company’s hidden financial assets.
  • It provides tools to assist organizations generate cash recoveries, stop profit leaks, move away from control issues, and work towards process improvements.
  • The book shows how to incorporate profit recovery technology, and how to pair a company with a recovery expert best suited to the company’s needs to achieve bottom line results.
  • The book discusses how to utilize free services offered by cost recovery consultants, using of top money-saving proves improvements, and how to create a plan to maximize recovering technology.

Doug Hudgeon who is lawyer and vendor management professional who has branched into finance and accounting shared services management.


Copyright - These concepts, frameworks and ideas are copyright of GLOBAL SUPPLY CHAIN GROUP from the time of their creation. Do NOT copy these without permission and proper attribution.

Notes:

  1. These ideas and concepts will be usually expressed by our thought leaders in multiple forums - conferences, speeches, books, reports, workshops, webinars, videos and training. You may have heard us say the same thing before.
  2. The date shown above the article refers to the day when this article was updated. This blog post or article may have been written anytime prior to that date. 
  3. All anecdotes are based on true stories to highlight the key points of the article - some details are changed to protect identification of the parties involved. 
  4. You are encouraged to comment below - your real identity and email will not be revealed when your comment is displayed.  Insightful comments will be  featured, and will win a copy of one of our books. Please keep the comments relevant, decorous and respectful of everyone. All comments represent opinions of the commentators.

chiefstaff

MORE INTERESTING READING
  • Although difficult to admit, it’s likely you’ve invested considerable time and money on sophisticated IT systems, best-in-class processes, and on the strictest controls possible – however, it’s also likely that your company is losing money due to duplicated payments of supplier invoices. Even the best accounts payable departments can’t escape the most common causes of duplicate payments, including human error, such as keying mistakes, duplicate vendor listings and new or temporary staff, as well as other factors such as IT system changes, mergers and acquisitions, and cross-company invoicing.

    Duplicate payments are often discovered through unconventional means such as honest suppliers alerting accounts payable of the mistake or departmental managers discovering double charges that eat into their budgets. According to industry estimates, between 0.1 – 0.5% of total payments are processed twice, which can result in a loss of up to €5 million for a company with a transaction volume of €1 billion. The inconvenient truth is that 70% of duplicate payments can’t be identified using standard measures.

  • Yes, It is the great tool to reduce the cost of projects and management tip. Duplicate payments are often discovered through unconventional means such as honest suppliers alerting accounts payable of the mistake or departmental managers discovering double charges that eat into their budgets. According to industry estimates, between 0.1 – 0.5% of total payments are processed twice, which can result in a loss of up to €5 million for a company with a transaction volume of €1 billion. The inconvenient truth is that 70% of duplicate payments can’t be identified using standard measures.

    Many of today’s systems provide matching and analytical functionality that often identify a duplicate payment, but might not dig deep enough to highlight all types of payment errors. In these cases, duplicate payments could still be made without taking additional measures. These measures include the ongoing review of key reports, together with focusing on the quality of your supplier master file which can be considered components of a P2P controls self-assessment program.

    I would like to Thank Author.

  • Duplicate payments are often discovered through unconventional means such as honest suppliers alerting accounts payable of the mistake or departmental managers discovering double charges that eat into their budgets.

  • {"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

    FOR SENIOR EXECUTIVES AND DIRECTORS

    YOUR HIGHEST VALUE ADDED IN YOUR COMPANY

    >