SourceDay

Follow
Finance

3 Way Invoice Matching for Manufacturers, Distributors, and CPG Companies

Invoice matching is a common process handled by accounting teams. In its simplest form, it means comparing vendor invoices with the corresponding purchase orders and material receipts to make sure key pieces of information, like the cost and quantity of what was purchased, are the same on both documents. 

For many teams, invoice matching is just part of their process for closing the books. But for businesses that deal largely in direct spending, like manufacturers, distributors, and CPG companies, which typically see about 80-90% of their spend tied to a purchase order, these documents may contain hundreds (if not thousands) of lines and each invoice could include lines from several purchase orders. 

Many accounts payable teams solve this problem by printing these documents, pulling their ERP system up on a screen, and going line-by-line with a pen marking the status of each invoice line. That’s not fun—nor an efficient use of anyone’s time. Luckily, there’s plenty that can be done to speed up the process

Why Is Invoice Matching Important? 

Matching invoices with their corresponding purchase orders is standard practice for accounting or bookkeeping professionals. Without this step, companies might overspend on invoices, pay fraudulent invoices, miss early payment discounts, or otherwise waste valuable company resources. 

In other words, invoice matching is an important safeguard for companies. And in the case of companies that spend heavily on direct materials, the sheer volume of transactions they have to review elevates the risk.

Based on a company’s needs, there are a few different processes they can follow. The most common is the three-way match process, which compares a goods receipt with the invoice and purchase order. Two-way match and four-way match are also options, depending on a business’s invoice approval process and the rigor with which they want to review their outbound payments. 

2-Way Matc​​​​hing, 3-Way Matching, & 4-Way Matching

While three-way match is the most common process AP teams follow, let’s quickly review the differences between the options. 

  • 2-Way Matching: AP teams match an invoice and a receipt of goods. 
  • 3-Way Matching: AP teams match an invoice, purchase order, and receipt of goods. 
  • 4-Way Matching: AP teams match an invoice, purchase order, receipt of goods, and quality check.

As their names imply, these matching methods increase in rigor with each additional ‘way’—as does the time required to complete them. 

Tolerance (noun): When a company orders 300 parts, suppliers are often allowed some flexibility in how many parts they actually deliver. For example, a manufacturer might allow for a 10% tolerance, meaning the supplier could deliver between 270 and 330 parts, while still being within the terms of their agreement. This is one reason three-way matching is difficult—the PO says 300, but the receipt might show 327 parts were delivered.

Check out SourceDay’s custom matching rules.

The 3-Way Matching Process

Because three-way matching is the most common for manufacturers, distributors, and CPG companies, that is where we will focus our attention for the rest of this article.

To complete the three-way matching process by hand, here are the steps you’d take. (If you’d like to skip ahead and learn how this process can be automated, feel free to do so here.) 

Step 1: Invoice Received

A vendor or supplier sends you an invoice, requesting payment for the goods they provided. You’ll make sure that invoice is uploaded to your ERP, which also stores receipts and purchase orders. 

Step 2: Goods Received 

In many cases, especially when goods are shipped from overseas, the invoice arrives before the goods themselves. If that’s the case, you’ll classify the invoices as “Pending” until the goods are received. At this point, a receiving report is generated. 

Now you’ll have to get precise details about how many parts or what volume of materials were actually received. Remember, in many cases ordering 300 parts does not mean exactly 300 will show up. This is the step when quantity variances are identified. 

Step 3: Confirm Invoice Details

With the goods in the warehouse, it is time to gather the purchase order, invoice, and receipt of goods and make sure that what you received is what was ordered, and that costs are consistent across all three documents, given the company’s tolerance thresholds. 

In some cases, the ERP can quickly pull PO numbers, receiving reports, and invoice numbers so the accounting team can compare the documents side-by-side. This is often the case for indirect spend purchases, like new chairs for an office. You place one order for chairs, all of which arrive on the same day and show up on a single invoice. As long as a manager approves the expense, the AP team can pay the invoice and move on.  

For companies with heavy direct spend, an invoice might include lines from several purchase orders. Each purchase order could include several ship dates, meaning that goods will arrive and be entered into the system on a staggered timeline. 

This is where AP starts to have a hard time. Rather than looking across three documents and just making sure the numbers line up, they have to look across dozens, maybe even hundreds, of documents, honing in on specific line items and taking partial shipments and tolerances into consideration. And because quantity, dates, and pricing change throughout a purchase order’s lifecycle, it’s likely that an invoice line will not match the final PO.

Step 4: Voucher & Issue Payment

Once AP has matched the receipt, invoice, and purchase order, they are likely to face one of two different scenarios. In the first, everything matches within their company’s tolerance threshold and they can voucher the invoice in the ERP and begin the payment process. In this scenario, when things go according to plan, they may also be able to take advantage of early payment discounts—an incentive many suppliers offer. 

If, on the other hand, the team has uncovered problems and the documents don’t match, AP will need to decide whether to voucher the payment anyway or bring in procurement and receiving to help investigate. This can lead to a back-and-forth with suppliers that takes time, especially when buyers and suppliers need to go through their emails to prove whether pricing, quantity, or date changes were, in fact, agreed upon. 

Go straight to the source.

Watch the webinar recording featuring Napoleon Products, as they discuss SourceDay’s AP Automation product.

Direct Procurement & 3-Way Match

The method of performing three-way matches described above is problematic for AP and the business as a whole. Most matching solutions on the market are geared toward businesses that purchase finished goods, like the office chairs mentioned earlier, and direct spend has long been written off as “too complex to automate.” 

What that creates is a payable process that doesn’t reflect modern business operations. Worse still, it impacts the bottom line. From needing to hire more people in order to scale AP operations to overpaying invoices in the name of speed, the payable process is rife with cost savings opportunities. 

AP Automation for Direct Spend

Is it possible for companies with predominantly direct spend to embrace AP automation? You bet. It just requires a different kind of solution

An automated AP solution will compare the total invoice amount to the total purchase order amount. If they match, it will allow the accounting department to voucher and pay the invoice without any manual work. 

When it comes to direct spend, automation requires reading the entire purchase order and invoice, rather than just the total amounts. In order for automation to do its job, the software must match items on the line level. This requires a few additional steps to complete, but the software exists to handle this complexity. 

Step 1: Digital Extraction

The first step is extracting all of the information from the documents in question: the purchase order, invoice, and receipt data. Because invoices are generated by suppliers and can vary widely from one supplier to the next, this is the hardest document to extract data from. 

In SourceDay’s AP Automation product, suppliers simply have to email their invoices and the software will read and digitize their contents. If there are any anomalies or inaccuracies, a support team is standing by to resolve them—by exception only.

Step 2: Smart PO Association

Some AP automation solutions don’t include smart PO association, but it is absolutely critical. SourceDay’s software compares the extracted information from the invoice to the purchase order and receipt data. Because there are so many variables involved in this kind of matching, we also call this step “multivariate association.” 

Let’s say you’ve placed an order for 300 bike seats, 600 tires, and 450 bike brakes from your top supplier. They ship 302 seats early and include that line item on an invoice with a dozen other items. Software has the ability to compare those bike seats to the purchase order line—even though the numbers don’t match exactly and the other items didn’t ship yet.

For most AP teams, this is the most time-consuming step in the process. But it doesn’t have to be anymore.

Step 3: Automated 3-Way Matching by PO Lines

After the hard work of multivariate association is done, three-way matching is a breeze. You’ve found the right line items on your invoice and purchase orders. Now, as long as they match within your pre-set tolerances, you can voucher the payment. 

Of course, setting your tolerances correctly goes a long way here. This is why it’s crucial to find a solution like SourceDay’s that allows you flexibility in how you match. You might set a rule that says as long as the total line item amount is within 2% of the original purchase order cost, it’s a match! For certain suppliers, you might want to constrain them to 1%. 

How you determine a match will vary depending on your business and your supplier relationships. 

Step 4: Voucher & Pay 

When matching is complete, a simple button click is all it takes for AP to voucher an invoice to the ERP. They can even set auto-vouchering rules for certain invoices and skip that button-click altogether. 

Benefits of AP Automation for Direct Spend

  • Time to complete root cause analysis of incorrect orders.
  • Avoid overpaying on incorrect invoices. 
  • Take advantage of early payment discounts from suppliers. 
  • Strengthen supplier relationships through on-time payments. 
  • Payables operations that can scale with company growth. 
  • Tangible cost savings. 

With all the time saved in the steps above, automation allows accounts payable teams more time to get to the bottom of any mismatches—or the orders that fall outside of your tolerance thresholds. Best of all, if purchase orders are also tracked in software (and not in dreaded email), checking on an order’s complete history takes minutes instead of days. 

This means companies can avoid paying more than they owe due to human error and that they can take advantage of early payment discounts and other supplier incentives if they choose. 

Automatic three-way invoice matching has come a long way in recent years. If your business is still struggling through the process manually, it might be time to upgrade to an automated solution. Meet SourceDay’s AP Automation solution, which was tailor-made for manufacturers, distributors, and CPG companies.

TAGS   ,