Skip to main content
Bonsai Software
All field notes
Field Note10 September 20266 min read

Matching a purchase order to a supplier confirmation: three lessons learned

Automating the matching of purchase orders to supplier confirmations fails more often than expected, and almost always for the same three reasons. Not because the technology falls short, but because the preconditions are underestimated: format variation, an overly permissive matching model, and missing business rules. These are the lessons we encounter time and again.

By Yeslin Beljaars

Lesson 1: suppliers do not stick to a single format

The first assumption to fall is that suppliers deliver their confirmations consistently. In practice, supplier A sends a PDF with a fixed table structure, supplier B a scanned letter, supplier C a reply in the body of an email, and supplier D an Excel export that differs by region. A rigid parser built on fixed field positions or a fixed template fails the moment one supplier changes its layout or a new region adopts its own format. You are not building a system at that point; you are building a stack of exceptions. The approach that works: document extraction that targets content rather than position. That means language understanding, not pixel parsing. But even then: test with the full set of supplier formats before going to production, not with three sample documents. The amount of variation in a real document stream is consistently surprising.

Lesson 2: an overly permissive matching model ignores silent discrepancies

The second problem arises when you configure the system to auto-approve as much as possible. Logical from an efficiency standpoint, but dangerous in practice. A confirmation priced five euros per unit higher than the purchase order, or a delivery date pushed back two weeks, passes silently into the approved pile. The buyer never sees it, accounting only notices at the invoice stage, and planning has already calculated against the wrong date. A matching automation must therefore not only match on order number and item reference, but also actively flag discrepancies: price, quantity, delivery date, item description. And those flags must be visible to a person, not buried in a log file. Human in the loop is not a buzzword here; it is the only way the system adds value without creating risk.

Lesson 3: the real bottleneck is the business rule, not the extraction

This is the lesson that meets the most resistance: the technology is not the problem. The question an automation system cannot answer is: what constitutes an acceptable discrepancy? Is a price difference of two percent auto-approvable? Can a delivery date shift by three working days without escalation? Who decides when the confirmed quantity is ten percent below what was ordered? These rules rarely exist in explicit form. They live in the head of the buyer who has worked with the same supplier for twelve years. Once you automate, you have to write them down, and that conversation is uncomfortable because it exposes the fact that there was no consistent approach to begin with. What we also see: the automation project becomes the catalyst for formalizing procurement policy, which is valuable, but it takes time and requires commitment from the organization, not just from IT.

When does an AI worker add value here, and when does it not?

An AI worker that matches purchase orders to supplier confirmations makes sense when the volume is large enough to justify the manual workload, the document stream is diverse enough to render a rigid parser impractical, and the organization is willing to make the associated business rules explicit. It works less well when the underlying problem is process discipline: suppliers who do not send confirmations, purchase orders created after the fact, or orders placed verbally and only entered into the system later. An AI worker solves a data problem, not a process problem. If the input is unreliable, the output will be too. The honest question to ask upfront is: do we want to build a smarter system, or do we need to get the front end of the procurement process in order first?

How do you approach purchase order matching to supplier confirmations in practice?

Start small: select the five suppliers with the highest volume and the most consistent confirmation patterns. Build the extraction and matching on those, validate the results manually for the first few weeks, and use that period to define the tolerance rules. Only then do you scale out to the broader supplier base. This is not a waterfall approach, but it is not a big bang either. The trap is the opposite: building a system that must handle all suppliers simultaneously before a single business rule has been defined. That produces a matching engine that works technically but delivers nothing operationally, because no one knows what to do with the exceptions.

Seeing this in your own operations?

Book a call

Frequently asked questions

How do you automate the matching of a purchase order to a supplier confirmation?

You combine document extraction based on language understanding with a matching layer that compares order number, item references, price, quantity, and delivery date. Discrepancies are flagged to a buyer, who decides based on pre-defined tolerance rules. Fully automatic approval without a human check is risky when price or delivery date differences are involved.

What are common mistakes when automating purchase order confirmations?

The three most common mistakes are: building on a rigid parser that fails with every new format, using a matching model that silently approves discrepancies, and starting without explicit business rules about what constitutes an acceptable discrepancy. The last one takes the most time to fix.

What is the difference between two-way and three-way matching for purchase orders?

Two-way matching compares the purchase order with the supplier confirmation or invoice. Three-way matching adds the goods receipt: only when all three align is the invoice approved. Three-way matching provides greater certainty but also requires reliable receipt registration.

When is an AI worker the right choice for purchase order matching?

When the procurement volume is large enough to structurally justify the manual workload, the document stream is diverse, and the organization is willing to make business rules explicit. If the problem is primarily process discipline, such as suppliers not sending confirmations, an AI worker will not solve that.