Integrated receivables solution supports customer focus at MSC Industrial Supply

September 17, 2021

Automating accounts receivable with U.S. Bank VantagePoint dramatically reduces manual processing and frees up staff time at distributor

 

MSC Industrial Supply Co. is a distributor of metalworking and maintenance, repair and operations products and services — everything from hole-making tools and saw blades to fasteners to janitorial and facility maintenance supplies. Once known for its 3,000-plus-page The Big Book paper catalog, the company today has an online catalog featuring over 1.5 million ready-to-ship products and has become the Amazon of the metalworking and tooling world.

Helping its many customers keep their operations running efficiently requires MSC to be nimble. That means not only having the right part or product and delivering it promptly, but also making it painless to do business with the distributor.

The high-level customer focus this requires takes an enormous amount of staff time, a challenge MSC’s Accounts Receivable (A/R) team has met in recent years thanks to its partnership with U.S. Bank. Since 2016, the U.S. Bank VantagePoint® online receivables management solution has provided the A/R team with what its managers gratefully refer to as “the gift of time” — more available staff hours.

“VantagePoint has helped the A/R team drive down to a mere 3 percent the number of our incoming payments requiring manual research to match with remittance data to enable posting, and use that improved efficiency to restructure staff positions to realize even greater customer focus,” says Nick Gallo, senior director of credit and A/R for MSC.

How MSC Industrial Supply is benefitting from U.S. Bank VantagePoint

  • Increased automatic receivable matching rate to 97 percent from 62 percent
  • Freed up A/R associates to be cross trained on both exceptions and rework, turning them into more nimble cash application analysts
  • Allowed staff to shift their focus to strategic tasks they previously didn’t have time for, like cleaning up unapplied cash
  • Enabled the A/R team to better weather staffing challenges during the pandemic
  • Better positioned the A/R team to manage the expected increase in incoming payments as business conditions improve post-pandemic

Minimizing manual accounts receivable work

Annual revenues for MSC, which also offers inventory management and supply chain solutions, top $3.3 billion. By selling its wide variety of products to thousands of customers, MSC generates a high volume of both small- and large-dollar invoices. As a result, every month MSC receives an average of 100,000 lockbox checks. The company also receives approximately 20,000 Automated Clearing House (ACH) payments, about half of which don’t include remittance information because customers have sent remittance advices separately.

Before 2016, MSC’s A/R team had to manually re-associate those remittance advices with the original payments. The company needed a way to improve its automatic match rate for ACH payments, specifically CTX formatted payments, and met that need by moving its transaction flows to VantagePoint.

Previously, MSC could match only about 62 percent of CTX payments with corresponding invoices and purchase orders. With VantagePoint, the match rate jumped to roughly 92 percent.

“This quickly and significantly reduced the number of payments our team had to manually process, which was key because some payments cover hundreds or even thousands of invoices,” Gallo says.

VantagePoint supports the payment mapping that’s critical to automated posting. It retains changes made to the CTX/EDI remittance item in the system and can reapply them to future payments received from the same payer.

“Previously, MSC could match only about 62 percent of CTX payments with corresponding invoices and purchase orders. With VantagePoint, the match rate jumped to roughly 92 percent.”

Working through an ERP system conversion

MSC first implemented VantagePoint in mid-2016 on its legacy enterprise resource planning (ERP) system. The distributor began using VantagePoint’s remittance re-association capabilities, providing the benefit of automatically matching ACH payments and invoices. This saved considerable time and eliminated the need for employees to key in remittance details and manually post thousands of electronic payments.

When MSC migrated to SAP, its new ERP system, in 2017, changes to the receivables management process were necessary for both MSC and U.S. Bank.

During the implementations, MSC and U.S. Bank held weekly meetings to update the status and work through challenges.

 

Partnering on A/R Matching

Following the transition to SAP, the A/R team experienced time-consuming rework due to the ERP system mapping some of its bank accounts to the wrong customer numbers. “When you are dealing with a $300,000 or $400,000 payment referencing 100 or 200 different invoices, rework can be quite tedious,” Gallo says.

In 2018, the company asked U.S. Bank if there was a way for the bank to pre-empt some of this rework, where items had to be identified, reversed and then reapplied. This kicked off the development of the A/R Matching feature of VantagePoint, and for about a year MSC worked closely with U.S. Bank, collaborating and acting as the primary pilot customer for the feature.

A/R Matching allows U.S. Bank to ingest a client’s open A/R file and match data against incoming payments, pulling in missing remittance data and correcting errors to automate cash posting and reporting. With this feature, VantagePoint’s effectiveness in minimizing manual reconciliation work took another leap forward.

Since implementing A/R Matching in 2019, MSC has seen match rates rise from 90-92 percent to about 97 percent, in large part due to the new feature, Gallo says. “That match rate is outstanding,” he says. “I don’t know if we can get much higher.”

 

Accounts receivable automation gives ‘gift of time’

VantagePoint has improved the A/R team’s workflow. More open A/R files are being matched within VantagePoint while fewer items are being researched or reworked once they reach the company’s ERP system.

Less manual posting work has enabled MSC to convert four of seven A/R associates previously dedicated to managing exceptions into “hybrid rework associates.” Cross-training has enabled those associates to both research exceptions and handle rework.

“We’ve been able to train more of our associates to be true cash application analysts and do work we haven’t had time to do before, such as collaborating with our collections department and closing out older, unapplied cash,” Gallo says.

The VantagePoint “gift of time” is enabling the A/R team to post cash more efficiently while doing a better job of keeping customer accounts in order.

That increased efficiency has been especially welcome during the pandemic, better enabling the A/R team to accommodate unanticipated time off for employees. But the real payoff is expected when the pandemic abates and business conditions improve, Gallo says. “With VantagePoint and its A/R Matching, we’re in a much better position to handle the higher volume of incoming payments we’re expecting.”

Related content

Drive digital transformation with payments innovation

Tailor Ridge eBill case study

Buying or leasing? Questions to ask before signing a contract

Want AP automation to pay both businesses and consumers?

Automate accounts payable to optimize revenue and payments

How RIAs can embrace technology to enhance personal touch

Colleges respond to student needs by offering digital payments

New technology streamlines M&A transactions

What corporate treasurers need to know about Virtual Account Management

3 emerging technology trends for bankers

CFO survey: A shifting focus on ESG in business

Zelle® helps Sunriver Resort make payments efficient and secure

CFO report: Driving growth via new business models and technology

CFO insights: Leading the recovery for sustainable growth

Why ecommerce for small business strategy is integral

6 timely reasons to integrate your receivables

The ongoing evolution of custody

How blockchain technology is changing treasury

Blockchain: Separating hype from substance

Enhancing the patient experience through people-centered payments

4 ways to make practical use of real-time payments

How small businesses are growing sales with online ordering

What government officials should know about real-time payments

Digital Onboarding helps finance firm’s clients build communities

10 ways a global custodian can support your growth

Insource or outsource? 10 considerations

Delivering powerful results with SWIFT messaging and services

Unexpected cost savings may be hiding in your payment strategy

Webinar: Digitizing receivables to transform B2B rent payments

Authenticating cardholder data reduce e-commerce fraud

How AR technology is helping advance payment processing at Avera Health

P2P payments make it easier to split the tab

Banking connectivity: Helping businesses deliver the easier, faster, more secure customer experience of the future

Collateral options for ABL: What’s eligible, what’s not?

Luxembourg's thriving private debt market

Integrated receivables management solution supports customer focus at MSC Industrial Supply

Emerging A/R solutions use artificial intelligence to target efficiency

ABCs of APIs: Drive treasury efficiency with real-time connectivity

Private equity and the full-service administrator

How emerging banking solutions enable better decisions

Flexibility remains essential for public sector workforces

Empowering managers with data automation and integration

Hybridization driving demand

Supply chain analysis: Merging technology and commerce

Easier onboarding: What to look for in an administrator

Common pitfalls to avoid in the equipment financing process

The secret to successful service provider integration

The cyber insurance question: Additional protection beyond prevention

How running a business that aligns with core values is paying off

Meet the Milwaukee businessman behind Funky Fresh Spring Rolls

How electronic billing platforms improve government payments

How to identify what technology is needed for your small business

Key considerations for online ordering systems

Planning for restaurant startup costs and when to expect them

Staying organized when taking payments

How does an electronic point of sale help your business keep track of every dime?

How iPads can help increase efficiency in your salon

Tools that can streamline staffing and employee management

How to redefine challenges with business collaboration

3 ways to gain loyalty with your customers

Finance or operating lease? Deciphering the legalese of equipment finance

Time is money: Intelligent Payment Routing saves businesses both

Digital trends poised to reshape hotel payments

Digital banking for business: How connectivity improves customer experience

How AI in treasury management is transforming finance

Automate escheatment for accounts payable to save time and money

Collect utility and telecom bill payments faster

Treasury management innovations earn Model Bank awards

The AI journey in finance: How to make it part of your strategy

The benefits of a full-service warehouse custodian

3 questions to ask your equity, quant and CTA fund administrator

The future of financial leadership: More strategy, fewer spreadsheets

Tech tools to keep your restaurant operations running smoothly

Enhancing liquidity management: 4 benefits of visibility

Webinar: CRE technology trends

Webinar: Robotic process automation

Webinar: CRE treasury leader roundtable

U.S. Bank VantagePoint is not affiliated with MSC Industrial Supply Co. and does not endorse or guarantee its products or services. U.S. Bank VantagePoint is a trademark of U.S. Bank National Association. U.S. Bank and SinglePoint are registered trademarks of U.S. Bank National Association. Credit products and services may be subject to credit approval. Eligibility requirements, restrictions and fees may apply.

Start of disclosure content

Loan approval is subject to credit approval and program guidelines. Not all loan programs are available in all states for all loan amounts. Interest rate and program terms are subject to change without notice. Mortgage, home equity and credit products are offered by U.S. Bank National Association. Deposit products are offered by U.S. Bank National Association. Member FDIC.