Invoice control in distribution: how to avoid margin leaks with 800 invoices a month

A food distribution company in Valencia with 180 active suppliers processes 950 invoices per month. Its average operating margin is 3.2%. Every euro overpaid on an undetected error is a euro that comes straight out of profit.

This article is not about theory. It is about the real numbers that move daily in a distribution company, the most frequent errors in supplier invoices, and what you can do to stop paying them. If you are still managing this with spreadsheets, we also explain why Excel does not scale at high invoice volume.

Why distribution is especially vulnerable to invoicing errors

Distribution has four traits that make it fertile ground for invoice errors:

1. High volume, low margin. With 800-1,200 invoices per month and 2-5% margins, there is no cushion to absorb errors. A 1% variance on an operation can represent 20-50% of that operation's profit.
2. Huge catalogues with changing prices. A mid-sized distributor handles 3,000-10,000 SKUs. Prices are negotiated by season, by volume, by promotion. It is impossible for a person to remember whether the price on each line is correct.
3. Constant partial deliveries. Suppliers cannot always ship the full PO. They send what they have and complete it later. But the invoice can arrive for the full order amount, not for what was actually delivered.
4. Multiple receipt channels. The same invoice arrives by email, through the supplier portal, by EDI and sometimes by post. Duplicates are inevitable without a detection system. You can see how we approach automatic duplicate invoice detection in detail.

The 5 most frequent errors in distribution invoices

1. Prices that do not match the agreement

It is the most common error and the hardest to catch by hand. The supplier updates their tariff and applies it before the new agreement takes effect. Or simply uses the wrong tariff.

Real example:

SKU	Agreed price	Invoiced price	Quantity	Variance
Olive oil 5L	EUR 18.50	EUR 19.20	200 units	+EUR 140.00
Wheat flour 25kg	EUR 12.80	EUR 12.80	150 units	EUR 0.00
White sugar 1kg	EUR 0.95	EUR 1.02	500 units	+EUR 35.00

EUR 175 extra on a single invoice. If this supplier sends 4 invoices per month, that is EUR 700. Annually, EUR 8,400. And this is one supplier out of 180.

The root of the problem is structural: prices are negotiated in a WhatsApp conversation or in an email, recorded in a spreadsheet nobody updates and when the invoice arrives, nobody has the correct reference at hand. The solution is not to be more careful: it is to automate the cross-check. To understand why price errors are the most frequent type in supplier invoices, there is a full analysis with sector data.

2. Quantities that do not match the delivery note

You order 500 cases, 480 arrive, but you are billed for 500. The warehouse signs the delivery note in a hurry and nobody cross-checks the quantities afterwards. In distribution, with multiple daily deliveries, this error multiplies.

A 4% difference in quantity on 500 cases at EUR 25 each is EUR 500. Every day.

The difficulty here is that the delivery note and the invoice usually arrive separately, sometimes days apart. The delivery note is held by the warehouse, the invoice by accounting. Without a system that cross-checks them automatically, manual reconciliation is practically impossible at scale. This is exactly the problem that three-way matching: PO, delivery note and invoice solves.

3. Duplicate invoices across channels

The supplier sends the invoice by email to accounting and also uploads it to their portal. Your ERP imports it from both sources. Without a system that cross-checks invoice number, supplier, amount and date, it gets paid twice.

According to IOFM data, 4-6% of the invoices a company receives are duplicates. In a distributor with 1,000 invoices per month, that is 40-60 potential duplicates.

Duplicates are especially treacherous because they trigger no accounting alarm: everything matches, the supplier exists, the invoice has a valid number and the amount does not look abnormal. They are only detected when somebody explicitly cross-checks. Automating duplicate detection with document hashing and metadata cross-checking is the only way to do it at scale.

4. Unapplied volume rebates and bonuses

In distribution, volume discounts, prompt-payment bonuses and quarterly rebates are standard. If the supplier does not apply them on the invoice, and nobody checks, they are lost.

A 2% rebate on EUR 50,000 of monthly purchases is EUR 1,000 a month. EUR 12,000 a year that evaporates if nobody reviews.

The problem with rebates is that tracking them requires historical memory: knowing how much you have bought in the quarter from each supplier, comparing it with the agreed thresholds and claiming the discount if it has not been applied. This is exactly the kind of task that does not scale by hand when you have 180 suppliers.

5. Incorrect VAT or mis-applied exempt items

Products with reduced VAT (10%) invoiced at the general rate (21%). In food this is common. The 11% difference on a EUR 5,000 order is EUR 550 of extra input VAT that, although deductible, generates accounting variances and more reconciliation work.

In a food distributor handling simultaneously products at 0% VAT (staples), 4% (bakery, milk), 10% (most foods) and 21% (alcoholic drinks, first-stage processed products), the chance that a supplier applies the wrong rate on some line is high. By hand, verifying VAT rate on 15,000 lines per month is unfeasible. Automatically, it can be validated in seconds.

How much money a distributor loses on invoicing errors

Let's run the numbers for a typical distributor:

• Invoices per month: 1,000
• Average invoice amount: EUR 2,500
• Monthly purchasing spend: EUR 2,500,000
• Estimated error rate: 1.5% of invoices
• Average variance per erroneous invoice: EUR 175

That is 15 invoices with errors per month × EUR 175 = EUR 2,625/month. Annually, EUR 31,500 in avoidable overcharges.

If we add duplicates (assume just 1% gets paid twice, with an average amount of EUR 2,500), that is another EUR 25,000 per year.

Total: EUR 56,500/year coming straight out of profit.

For a distributor with a 3% operating margin, that equals the profit on EUR 1.9 million in sales. Revenue you have to generate just to offset what you lose by not reviewing invoices.

Put differently: if your distribution company bills EUR 30 million a year on a 3% margin, your profit is EUR 900,000. The EUR 56,500 in errors represents 6.3% of your total profit. It is not a marginal problem.

How automatic reconciliation works in distribution

The manual process requires someone to open the invoice, look up the corresponding PO, find the delivery note, and compare line by line. With 1,000 invoices and 15-20 lines per invoice on average, that is 15,000-20,000 lines per month.

Automatic reconciliation follows the same logic, but without human intervention:

1. Ingestion. Invoices arrive by email (Gmail, Outlook) and are classified automatically. PDF, image, XML. Format does not matter.
2. PO identification. The system finds the correct PO. Even if the number has an OCR typo or the supplier's name is written differently, it finds it.
3. Line-by-line cross-check. Each SKU on the invoice is compared with the PO and delivery note: unit price, quantity and product. If there is a difference above tolerance (typically 5%), it is flagged.
4. Outcome. What matches, green. What does not, red with the exact variance amount. Ready for someone to decide whether to pay, dispute or investigate.

The accounting team goes from reviewing 1,000 invoices to reviewing only the 15-30 that have a real problem. The rest are approved automatically. If you want to see how this end-to-end process is built, visit the how ininvoice works page.

Partial deliveries: the distribution-specific problem

In distribution, partial deliveries are the norm, not the exception. A 1,000-unit order can arrive in 3 deliveries: 400, 350 and 250. Each delivery has its own note. But the invoice can arrive:

• For the full PO (1,000 units), even though only 750 have been received.
• Per delivery separately, generating 3 invoices for a single PO.
• Grouping several deliveries from several POs into a single invoice.

Without a system that cross-checks each invoice line with each delivery note, the differences are lost. And in distribution, with 2-5% margins, every difference counts.

Complexity increases when there are returns. If you receive 750 units but return 30 in poor condition, the supplier should issue a credit note. If they do not issue it, or issue it for a different amount, without a system tracking it automatically you never know. This is one of the most common cases we describe in the article about the most frequent errors in supplier invoices.

How to prioritise which suppliers to review first

If you have 180 suppliers and you cannot review them all at once, where to start? The answer is analytical. Classify your suppliers by three criteria:

1. Purchase volume. 20% of your suppliers probably represent 80% of your spend. Start with them. A 1% error on a EUR 500,000/year supplier is EUR 5,000. The same error on a EUR 5,000 supplier is EUR 50.
2. Frequency of price changes. Fresh-product suppliers or commodities with market prices change tariffs frequently. They are the most prone to price errors, intentional or not.
3. Incident history. If a supplier has had 3 variances in the last 6 months, the chance of a fourth is high. Putting more attention on that supplier is rational.

An automatic reconciliation system solves this problem at the root: it reviews all suppliers with the same level of detail, with no need to prioritise manually. But if you start with an improved manual process, this classification gives you the highest return per hour invested. Check the ininvoice features to see how supplier analysis is implemented.

ERP integration and approval workflows

One of the most frequent questions from distributors considering automating reconciliation is: how does it fit with the ERP we already have?

The answer depends on the ERP, but the general pattern is the same:

• The ERP holds POs and delivery notes already received.
• The reconciliation system reads that data and cross-checks it with incoming invoices.
• The cross-check result (approved / pending review / rejected) is written back to the ERP or displayed in a separate interface for the admin team.

Most ERPs in the distribution sector (Sage, SAP Business One, Navision/Business Central, SAP S/4, Oracle NetSuite) have APIs or data exports that enable this integration. Implementation time varies depending on ERP complexity and data structure, but in standard cases does not exceed 2-4 weeks.

The approval workflow is equally relevant. An invoice that passes the automatic cross-check can be approved without human intervention (level 0 approval). An invoice with a variance below a threshold (for example, EUR 50) may require level 1 approval (the controller). An invoice with a significant variance requires level 2 (the finance director). This configurable escalation workflow is what turns automatic reconciliation into a real financial control tool, not just detection.

Practical checklist for distributors

If you manage invoices in a distribution company, these are the questions you should be able to answer:

• How many invoices last month had a price different from the PO?
• How many invoices were paid for quantities greater than the delivery note?
• How many duplicate invoices were detected? How many were paid twice?
• Which suppliers have the highest error rate?
• How many hours per month does your team spend reconciling invoices manually?
• How many rebates and volume discounts went unclaimed last quarter?

If you cannot answer any of these questions, the problem is not that you lack the data. It is that you are not cross-checking it.

Sectors with similar issues

Distribution is not the only sector where high invoice volume and tight margins create this kind of risk. If you operate in adjacent sectors or are evaluating solutions for several verticals in your group, it can be useful to see how the same problem is tackled in:

• Hospitality invoices: fresh-product prices changing weekly, deliveries without weight control and food cost drift.
• Construction invoices: subcontractors billing more than executed, materials not received and duplicates between site and HQ.

Frequently asked questions

How many invoices does a distributor process per month?

A mid-sized distributor with 100-300 active suppliers processes between 800 and 1,200 invoices per month. Large distributors can exceed 3,000.

What percentage of invoices have errors in distribution?

Between 1% and 3%. With 1,000 invoices per month, that is 10-30 invoices with variances that are normally paid without review.

How do invoicing errors affect margin?

With 2-5% margins, a 1% billing error can represent between 20% and 50% of an operation's profit. In volume, a distributor can lose between EUR 15,000 and EUR 60,000 per year.

What is a partial delivery and how does it affect reconciliation?

A partial delivery is when the supplier sends only part of the PO. It is very common in distribution because of stock-outs. The risk is that the invoice arrives for the full PO amount, not for what was actually delivered. Three-way matching solves this by cross-checking PO, delivery note and invoice line by line. According to APQC 2026, distributors with automatic matching reduce partial-delivery disputes by 74% compared with those reconciling manually.

Related reading: AP automation in Spanish distribution, how fuzzy matching of POs and delivery notes works when references are not exact, and the benefits of touchless AP in accounts payable.