Three-way reconciliation in Spain: what it is, how it works and how to automate it
Three-way reconciliation («triple conciliación» in Spain) is the accounts payable control that matches three documents before a supplier invoice is paid: the purchase order (what you agreed to buy), the delivery note (what you actually received) and the invoice (what the supplier charges). The match is made line by line, on unit prices before tax, with a typical tolerance of 2% or €1.50 per line. If the three pieces match, the invoice is reconciled and ready to pay. If not, payment is blocked and an exception is opened.
If you are the CFO
What it is exactly, how it differs from two-way matching and why matching on totals approves overpayments.
If you are a controller
The full example in euros, the variance formula and the tolerances AP teams use in the mid-market.
If you run the company
How much money leaks out without this control and how to automate it in days, with no consulting project and no change of ERP.
An invoice arrives by email. Someone opens it, looks for the purchase order, asks the warehouse whether everything arrived, finds out the delivery note is in a folder (or in a lorry cab) and, two weeks later, it gets paid "because the supplier is trustworthy". Multiply that scene by 300 invoices a month and you have the most expensive silent hole in your finance department.
Three-way reconciliation exists to close that hole. This guide explains what it is, how to do it properly (line by line, never on totals), which tolerances to use and how to automate it without setting up an endless project.
What is three-way reconciliation?
Three-way reconciliation is the cross-check of three documents that ininvoice performs before the payment of a supplier invoice is approved:
- Purchase order (PO): what you agreed to buy. Items, quantities, unit prices, terms.
- Delivery note: what actually came through the door. Quantities received, date, issues noted by whoever receives the goods.
- Invoice: what the supplier wants to charge. Lines, prices, taxable base, VAT.
If the three documents tell the same story, the invoice can be paid. If they do not, payment stops until the reason is understood.
The same control appears under several names: «conciliación a tres bandas» and «conciliación de tres vías» in Spanish, 3-way match, or invoice, purchase order and delivery note matching. It is the same control under different names. What changes is how well each system executes it.
What does each document contribute to three-way reconciliation?
In three-way reconciliation each document proves something different, and ininvoice uses all three on every line.
| Document | What it proves | Critical fields for the match |
|---|---|---|
| Purchase order | What was agreed: what, how much and at what price | Reference, line description, quantity, pre-tax unit price |
| Delivery note | The actual physical delivery | Quantity received per line, date, remarks (shrinkage, rejections) |
| Invoice | What is being charged | Invoiced lines, quantity, unit price, taxable base, VAT |
Each pair of documents answers a different question. Invoice against purchase order: am I being charged the agreed price? Invoice against delivery note: am I being charged for what I received? Purchase order against delivery note: did the supplier deliver what was ordered? Three-way reconciliation answers all three at once.
How does three-way reconciliation work step by step?
Three-way reconciliation follows five steps. ininvoice applies the same logic as a person with the three documents on the desk.
- Capture. The invoice arrives (email, portal, scanned paper). The purchase order lives in your ERP or your purchasing tool. The delivery note is signed by whoever receives the goods.
- Line-by-line extraction. The lines are taken from each document: description, quantity, unit price. Without lines there is no real reconciliation, only matching of totals.
- Invoice ↔ purchase order match. For each invoice line its purchase order line is located (by item code or description similarity — fuzzy matching between purchase orders and delivery notes works out that "Tóner HP CF410A" and "HP 410A Tóner negro" are the same thing) and the unit price is compared.
- Invoice ↔ delivery note match. The invoiced quantity is compared with the quantity actually received, net of any issues noted at receipt.
- Verdict. All lines within tolerance → invoice approved for payment. Any line outside → exception with the specific reason: which line, which dimension (price or quantity) and how many euros.
Why is three-way reconciliation done line by line and not on totals?
Three-way reconciliation is done line by line because, when you match totals, errors cancel each other out. That is why ininvoice does not compare header totals: it compares every line.
Minimal example. Purchase order: 100 units at €2.00 and 50 units at €4.00 = €400. 100 and 40 units arrive, and the invoice charges 100 units at €2.40 and 40 units at €4.00 = €400. The total matches the purchase order to the cent, but the first line carries a 20% overcharge (€40) that is hidden by the short delivery on the second: the correct amount was €360. The total can mislead; the lines cannot.
That is why three-way reconciliation is defined on pre-tax unit prices, line by line. The full breakdown of this shortcut, with numbers, is in matching on totals is not enough.
What is the difference between two-way, three-way and four-way matching?
Two-way, three-way and four-way matching differ in how many documents are matched against the invoice. ininvoice matches purchase order, delivery note and invoice; it does not record quality inspections.
| Control | Documents | What it covers | When to use it |
|---|---|---|---|
| Two-way matching (2-way) | Purchase order + invoice | Agreed price and quantity | Services, subscriptions, purchases with no physical delivery |
| Three-way reconciliation (3-way) | Purchase order + delivery note + invoice | The above + that the goods really arrived | Any purchase with physical delivery. The standard in distribution, hospitality, construction, manufacturing and retail |
| Four-way matching (4-way) | + quality inspection | The above + that what was received passed quality control | Regulated sectors: pharma, chemicals, critical food |
Two-way matching leaves one question unanswered: did you receive the goods? For physical goods, that gap is exactly where overpayments slip through. The full comparison, with a decision matrix by type of purchase, is in two-way vs three-way matching. And if your sector requires documented quality control, see 4-way matching.
What tolerance should three-way reconciliation use?
The tolerance decides which difference holds an invoice in three-way reconciliation, because no real-world transaction always matches to the cent. Rounding, prorated freight, discounts applied on a different line. If you demand an exact match, everything ends up in manual review and automation dies. If the tolerance is too wide, you are back to approving overpayments.
The reference configuration we use at ininvoice:
- Absolute tolerance: €1.50 per line.
- Percentage tolerance: 2% of the line amount.
- Combined in OR mode: the line fails if either of the two is exceeded. It is the strict mode: a €40 deviation on a €10,000 line is only 0.4%, but it is €40 of real money.
The comparison is strict: a value exactly equal to the threshold is within tolerance. The full guide — including when AND mode makes sense as a "noise floor" and how to calibrate with your historical data — is in how to set the tolerances (in Spanish).
What does three-way reconciliation look like in a euro example?
This synthetic example shows how ininvoice reconciles a three-line packaging purchase order:
| PO line | Quantity | Unit price | Amount |
|---|---|---|---|
| B1 box 350×250 | 500 | €0.62 | €310.00 |
| PP tape 48mm | 36 | €1.10 | €39.60 |
| Stretch film 17μ | 12 | €6.80 | €81.60 |
The delivery note confirms 500 + 36 + 12. The invoice arrives like this:
| Invoice line | Quantity | Unit price | Match |
|---|---|---|---|
| B1 box 350×250 | 500 | €0.62 | Matches |
| PP tape 48mm | 36 | €1.12 | Within tolerance: +€0.02 (1.8%), variance €0.72 |
| Stretch film 17μ | 12 | €7.45 | Exception: +€0.65 (9.6%), variance €7.80 |
The variance is calculated with the formula price_variance = (invoice_price − po_price) × invoice_quantity. Two lines are within tolerance. The third goes to purchasing with the exact reason: the film has gone up 9.6% with no prior agreement. Nobody reviews the whole invoice; one line is reviewed. Five more examples — including the totals trap and the partial delivery — in three-way reconciliation: worked examples (in Spanish), and the formula in detail in how to calculate price variance.
What happens when three-way reconciliation does not match?
When three-way reconciliation does not match, ininvoice holds the invoice and flags the line and the euros of the difference. That way human judgement is focused where there is a real discrepancy. The typical causes of an exception:
- Price variance: the supplier invoices above the purchase order price. An uncommunicated price increase or an error.
- Quantity variance: more units are invoiced than the delivery note confirms. A partial delivery invoiced in full, shrinkage not deducted.
- Unsupported line: an invoice line with no purchase order line or delivery note behind it. Surprise freight, extra charges.
- Duplicate: the same invoice comes in twice, weeks apart. Without a systematic control, it is paid twice. How to catch them: duplicate invoice detection.
Each exception should reach the right person with the context already assembled: which line, which document disagrees, how many euros. The design of that routing is in invoice exception management. And if the invoice arrives with no purchase order behind it, the alternative workflow is in invoice without a purchase order: how to handle it.
How is three-way reconciliation done in a Spanish company?
Three-way reconciliation in a Spanish company changes because of the documents and the way they arrive, not because of the method. Four situations shape how it is organised:
- Valued or unvalued delivery note («albarán valorado» or «sin valorar»). Many Spanish suppliers deliver delivery notes with no prices. With an unvalued delivery note, the delivery note only proves quantities and the price is checked against the purchase order; with a valued delivery note, a price increase can be spotted before the invoice arrives.
- Monthly invoice grouping delivery notes. In distribution and supplies a month-end invoice covering every delivery note of the period is common. Each invoiced line has to be split across the delivery notes and purchase orders it belongs to; comparing the monthly invoice with a single purchase order makes no sense.
- Receipt recorded in the ERP or on paper. If the warehouse records the goods receipt in the ERP (SAP, Business Central, Sage 200, A3 or another), the delivery note exists as data; if it only signs the carrier's paper, someone has to digitise it before the invoice arrives.
- Groups with several legal entities. The same supplier serves several entities in the group and invoices each one under its tax ID (NIF). Three-way reconciliation starts by assigning the invoice to the right entity: a purchase order from one entity is never matched against another entity's invoice (see invoice assignment by legal entity).
From 2027, mandatory B2B e-invoicing changes the format of the invoice, not the control: the invoice will arrive as a structured message and will still have to be compared with the purchase order and the delivery note, line by line. The six reconciliation cases with the difference in euros walk through the situations that hold the most invoices, and the definition of three-way matching compares 2-way, 3-way and 4-way.
Want to match purchase order, delivery note and invoice today? The three-way matching Excel template does it line by line with formulas and tolerances; the three-way matching guide explains each step. Download the three-way matching template
Why does three-way reconciliation in the ERP only go halfway?
Three-way reconciliation in the ERP goes only halfway because of what it receives, not because of its engine. Many ERPs come with a matching engine. And even so, in many companies a large share of invoices is still matched by hand. The reason is almost never the engine: it is what it receives.
- The invoice comes in as a PDF in a mailbox. Nobody turns it into structured lines.
- The delivery note is signed on paper and recorded late, or never.
- The ERP match is configured at header level (totals), not per line.
The engine cannot match what it does not have. That is why useful automation starts before the ERP: capture, extract lines and reconcile; and hand the ERP the entry already verified. The full diagnosis, with the five points of failure and how to fix them, is in why three-way matching fails in the ERP.
How much does not doing three-way reconciliation cost?
Not doing three-way reconciliation costs time, overpayments and a worse close:
- Time: processing and matching an invoice by hand takes between 15 and 30 minutes when the delivery note has to be chased.
- Overpayments: undetected erroneous or duplicate payments are usually between 0.1% and 0.5% of supplier spend. In a company that buys €5M a year, that is between €5,000 and €25,000 going out without anyone seeing it.
- Close: without systematic reconciliation, closing accruals are estimated by eye and discrepancies surface weeks after payment, when claiming money back is already an uphill struggle.
You can estimate your case with the accounts payable ROI calculator.
How is three-way reconciliation automated with ininvoice?
ininvoice runs full three-way reconciliation without you changing your ERP or keying in data:
- Connect your mailbox. Gmail. Invoices and delivery notes that arrive as attachments are captured automatically.
- Line-by-line extraction. Each document is turned into structured lines: description, quantity, pre-tax unit price. No per-supplier templates.
- Match and verdict. Invoice against purchase order and against delivery note, with a 2% / €1.50 tolerance in OR mode (configurable). Whatever matches is reconciled; whatever does not is held with the line and the euros flagged. The result is exported to your accounting system.
The operational goal is your team's touchless rate: the percentage of invoices that match with no manual checking. That percentage depends mainly on how many purchases have a recorded purchase order and delivery note. Your team works only on the rest, which is where its judgement adds value.
If you want the full implementation plan — requirements, 30-day pilot and KPIs — it is in how to implement three-way reconciliation step by step (in Spanish).
Frequently asked questions
- Are «triple conciliación» and three-way matching the same thing?
- Yes. «Triple conciliación», «conciliación a tres bandas», «conciliación de tres vías», three-way reconciliation and three-way matching all name the same control: matching purchase order, delivery note and invoice before paying.
- Can you do three-way reconciliation without a delivery note?
- Not strictly: without a delivery note you can only match purchase order and invoice (two-way matching). What you can do is accrue the expense when you have the purchase order and delivery note but the invoice has not arrived, and run the full match when it does.
- How does it differ from two-way matching?
- Two-way matching compares only purchase order and invoice. It verifies the agreed price, but not that the goods arrived. For purchases with physical delivery, that gap is what allows units that were never received to be paid.
- What tolerance should I configure?
- A reasonable starting point for the mid-market: 2% or €1.50 per line, in OR mode (it fails if either is exceeded). Adjust by category: raw materials with volatile prices allow more; agreed price lists, less.
- Does any regulation require three-way reconciliation?
- No Spanish regulation requires it under that name. But it is the standard internal control auditors expect to see in the purchasing cycle, and documentary traceability of invoices is a general obligation (keeping invoices and supporting documentation). Verifactu and B2B e-invoicing under the Crea y Crece Law do not require it, although they push the whole flow towards structured data that makes it easier.
- Does it work for services with no physical delivery?
- For pure services there is no delivery note, so the natural control is two-way matching against the contract or purchase order. The equivalent of the delivery note in recurring services is the signed progress certificate or timesheet, if there is one.
- From what volume does it pay to automate it?
- Manual matching holds up to a practical limit of around 200-300 invoices a month with one person putting serious hours into it. Beyond that, you either add people or automate. The breakpoint analysis is in Excel does not scale to 300 invoices/month.
What should you remember about three-way reconciliation?
Three-way reconciliation matches purchase order, delivery note and invoice line by line, never on totals. The per-line tolerance decides what is held, and it is worth calibrating with your own data. Without structured invoice and delivery note lines no ERP reconciles, so automation starts with capture.
Every invoice line, matched against its purchase order and delivery note
ininvoice matches every line against its purchase order and delivery note, with partial deliveries, grouped invoices, credit notes and rebates, and configurable tolerances (2 % or €1.50 by default). Send me 3–5 supplier invoices and, if you have them, the purchase order and delivery note for one of them.
Request a demo with your own invoicesRelated content
- Interactive three-way matching checker
- Two-way vs three-way matching: which one your company needs
- Five worked three-way reconciliation examples (in Spanish)
- Three-way reconciliation tolerances: 2% / €1.50 and OR vs AND (in Spanish)
- Your ERP says it reconciles and it does not
- Implementing three-way reconciliation without an endless project (in Spanish)
- Three-way matching: the line-by-line technical guide
- Delivery note reconciliation: from paper to automatic matching
- The invoice does not match the delivery note: what to do
- Delivery note vs invoice: the definitive guide
- What is 3-way matching and why you need it