General

Why your purchase orders live in three places and what that costs you

5 min read
Active Orders41 live
Harbourne Merchandise - Polo shirtsJB-0441In Production
Fenwick Studios - Tote bagsJB-0439Awaiting PO
Marlowe Promotions - HoodiesJB-0438On track
Horizon Events - LanyardsJB-0435At risk
Vertex Group - MugsJB-0432Ready to Invoice

Callum BoydTrade and Industry Analyst

Published

Callum Boyd is an editorial byline rather than a member of staff. Zigaflow's market analysis and industry resources are published under this name; they are written by Zigaflow's AI content agent, and Zigaflow is responsible for what they say.

Most small distributors have purchase orders in three places: an email thread, a spreadsheet, and an accounts package. None of those systems talks to the others. This piece explains what that fragmentation costs in committed supplier cost, missed delivery dates, and billing errors.

Having a purchase order form doesn't mean having purchase order visibility. A typical small distributor sends purchase orders by email, tracks them on a spreadsheet, and records the resulting invoices in an accounts package. Each of those systems holds a fragment of the picture: the email thread holds what was agreed with the supplier, the spreadsheet holds a running list of what's on order, and the accounts package records what has been paid. None of them updates the others when something changes. That is why a business that places supplier orders every week can still struggle to answer the most basic question a customer asks: when will my goods arrive?

A purchase order in three systems is not one purchase order

When someone in your business needs to check the status of a supplier order, they typically look in all three places. They search the email thread to confirm what quantity was agreed, check the spreadsheet to find the current status line, and query the accounts package to see whether the invoice has come in. If goods have been received, that information is somewhere else again - a signed delivery note in a filing cabinet or a photograph on someone's phone. The answer they actually need - what is committed, has it arrived, what do we owe - requires four separate lookups that may not agree.

The problem compounds when orders go off-script. A supplier emails to say a line item is delayed by two weeks. Someone updates the spreadsheet row - if they remember to. The accounts package has no idea. The linked customer order has no idea. Three weeks later, a customer calls asking where their goods are, and the honest answer is that nobody is quite sure, because the system that should know is actually three systems that don't agree with each other.

Spreadsheet updates lag behind reality

A delayed delivery only affects your records if someone updates the row. Suppliers don't update your spreadsheet for you, and email confirmations don't reach your accounts package automatically. The gap between what you were told and what your system shows grows with every order you're managing at once.

Committed cost that nobody can see

When a purchase order is raised but not yet invoiced, the cost is committed - your business owes that money even though the invoice hasn't arrived. For a distributor with fifteen open orders at any given time, the gap between what the accounts package shows and what is actually committed to suppliers can run to tens of thousands. Every management decision made before month-end - about margin, about cash, about whether to take on another order - is based on an incomplete picture.

SSSON's 2025 Future of Order-to-Cash report found that 47% of organisations cite too many manual steps as their top challenge in the order process. That manual overhead isn't just slow: it creates a structural gap between what has been committed to suppliers and what finance can actually see. The cost is real before the invoice arrives. The spreadsheet doesn't know that.

Delivery dates that drift without anyone owning them

An expected delivery date on a spreadsheet is a date someone wrote down once. It doesn't update when the supplier calls to say the goods are delayed, and it doesn't flag when a date passes with no delivery recorded. The spreadsheet can only tell you what someone typed; it cannot tell you what actually happened after that.

For a distributor, the practical consequence is that customer-facing promises decouple from supplier reality. A sales person quotes two weeks because that's what the PO spreadsheet says. The supplier is already running late, but nobody has updated the row. The customer expects delivery on Friday. The goods won't arrive for another ten days. The business finds out when the customer calls.

This is margin erosion at the information level. A missed delivery doesn't just affect that order - it affects the relationship, the reorder, and the time staff spend managing the fallout from a promise the business never should have made.

Manual steps in the order cycle

According to the Clarasys 2024 Order-to-Cash report, 51% of organisations see billing mistakes in more than a quarter of their invoices. When purchase orders, deliveries, and invoices aren't linked in one record, the error rate at billing is almost structural rather than accidental.

Connecting the purchase order to the customer order

The deepest version of this problem is when the purchase order and the customer order have no connection in the system at all. A customer sale sits in one place - a quote, a CRM, an email thread - and the supplier purchase order sits somewhere else. Nobody has formally linked them. When goods arrive, matching the delivery to the right customer sale is a manual exercise. When the supplier invoice arrives, the same matching happens again, against the same disconnected records.

Without a direct link between the purchase order, the delivery note, and the customer sale, billing errors are almost inevitable. The information required to bill correctly is spread across systems that don't share it. PwC's Digital Procurement Survey found that 64% of enterprises plan to digitalize procurement by 2027, up from just 36% in 2024 - reflecting widespread recognition that disconnected purchasing creates costs that are hard to see but easy to feel.

The fix is not a more detailed spreadsheet or a tighter email protocol. It is connecting the purchase order to the customer sale, the expected delivery date, and the incoming supplier invoice in one record that the whole business can see. When a purchase order sits against the same job record as the customer sale, committed cost is visible before the invoice arrives. When a delivery note is processed, it updates that job record rather than a separate document. When the supplier invoice arrives, it matches against the purchase order without a separate lookup. The inventory position updates when goods are received, not when someone remembers to update a spreadsheet row. And reporting can show committed costs alongside posted invoices, so the picture finance sees reflects what is actually owed, not just what has been processed.

The question a distributor should be able to answer at any moment is straightforward: what have we ordered from each supplier, when is it due, and how much does it commit us to? Most businesses have all the pieces to answer that. The pieces just aren't in the same place.

Sources

Related pages

Ready to run your business on one platform?

Book a demo and see how Zigaflow fits your team.