Purchase Order to Invoice Converter

Paste the purchase order lines, set what this invoice is billing on each, and this checks the result against the quantities the PO authorises — before it goes anywhere near the buyer's system.

What this tool does

A purchase order is not a promise, it is an authorisation with a ceiling — and the ceiling is per line, not per document. On the buyer's side an invoice is compared against the PO and against the goods receipt, and any line where the invoiced quantity exceeds what was ordered fails that comparison automatically. It is not refused with an explanation; it goes into an exception queue, and nobody tells the supplier.

That is the asymmetry this tool addresses. The buyer can see the mismatch instantly and you cannot see it at all, so the useful thing to compute is not your total but their verdict. Every line here is scored against the ordered quantity, and the panel says plainly whether this invoice will be held.

The second half is the running balance. Purchase orders are frequently billed across several invoices, and the quantity that matters is the cumulative one — what earlier invoices already claimed plus what this one claims. A line that looks fine on its own can break the PO once the previous invoice is counted, which is a mistake nobody makes twice and almost everyone makes once.

How it works

  1. Read the ordered quantities off the PO

    Paste the PO lines — description, ordered quantity, unit price. Those three are the authority: the quantity caps what can be billed, and the price is what the buyer's system expects to see. Changing either on the invoice is what breaks the match.

  2. Count what earlier invoices already took

    Each line carries a "billed before" figure. Against a PO billed in instalments, the test is never this invoice alone — it is the cumulative quantity against the ordered quantity, so an earlier partial invoice has to be counted here or the check is meaningless.

  3. Score each line, not the total

    Lines come back as not billed, part billed, fully billed, over but inside tolerance, or over the PO. A comfortable overall total hides a single over-billed line, and it is the line that holds the invoice — the buyer's system never nets one line against another.

  4. Apply tolerance only if you have been told it

    Many buyers allow a small over-delivery — a few percent — before a line fails. It is their configuration, not yours, so the default here is zero. Assuming a tolerance you have not been given produces an invoice that looks fine on this screen and stops on theirs.

Worked example

PO-44821 authorises 100 steel brackets at £12.50 and 20 fixing kits at £8.00. Sixty brackets were delivered and invoiced last month; this delivery is 50 more.

Inputs

PO value
£1,410.00
Steel brackets ordered
100
Billed on the previous invoice
60
Billing on this invoice
50
Tolerance
0%

Result

Cumulative quantity
110 of 100
Line status
Over the PO
Value over the authority
£125.00
This invoice will be
Held in an exception queue

Why it matters: The invoice for 50 brackets is correct, deliverable and completely unpayable. Ten units over the PO is £125 of value and an indefinite delay on the whole £625, because the buyer needs the PO amended before anything on it can be released — and until someone chases, nobody on their side is looking.

Best practices

  • Put the PO number on the invoice, in the field the buyer asked for. Most accounts payable systems match on it automatically and route anything without it to manual handling.
  • Invoice at the PO's unit price even when your list price has moved. A price mismatch fails the match exactly as hard as a quantity mismatch, and it is the harder of the two to argue after the fact.
  • Keep the line descriptions the buyer used. Their system matches on the PO line, and a supplier who renames the lines makes a person do the matching instead.
  • Get the PO amended before you invoice over it, not after. An amendment takes a buyer minutes in advance and weeks once an invoice is already sitting in an exception queue.
  • Bill one PO per invoice. Splitting an invoice across two purchase orders means it can only fail both, and no system will part-approve it.
  • Track the remaining balance and reference the same PO on every invoice against it, so the buyer can close the order off when it reaches zero.

Common mistakes

Reading the PO total as the limit

The authorisation is per line. An invoice can sit comfortably under the PO value in total and still be blocked because one line went over its own quantity — the buyer's system does not allow a surplus on one line to cover a shortfall on another.

Forgetting what earlier invoices already claimed

Against a PO billed in stages, the quantity that counts is cumulative. A 50-unit invoice against a 100-unit order is fine on its own and over the ceiling if 60 were billed last month — and the failure surfaces on the buyer's side, weeks later.

Assuming a tolerance exists

Over-delivery allowances are common and are entirely the buyer's setting. Treating "a few percent is always fine" as a rule produces invoices that pass your check and stop at theirs, which is worse than no check at all.

Waiting quietly once an invoice is held

An exception queue is not a rejection and generates no message. The invoice simply stops, ages, and appears overdue in your ledger while appearing unapproved in theirs. If a PO-backed invoice passes its due date in silence, assume it is held rather than late.

Frequently asked questions

What is a three-way match?

The buyer's check that three documents agree before payment: the purchase order (what was authorised), the goods receipt or service confirmation (what arrived), and your invoice (what is being charged). All three have to line up per line. Where they do not, the invoice is held rather than paid — which is why what your invoice says matters more than whether it is correct.

Can I invoice more than the purchase order authorises?

You can send it, but it will not clear the match. Ask for the PO to be amended or for a second PO covering the excess, and invoice the amended figure. Getting that done before the invoice exists takes minutes; getting it done afterwards means someone has to find the held invoice first.

Can one invoice cover several purchase orders?

Technically often yes, practically no. Matching runs per PO, so an invoice spanning two of them cannot part-clear — it fails until both are satisfied. One invoice per PO is slower to raise and dramatically faster to get paid.

What if the PO price is wrong?

Invoice at the PO price and raise the discrepancy separately, or get the PO corrected first. Invoicing at your price against an authorised price is a mismatch, and a mismatch is resolved by a human at the buyer's convenience rather than yours.

How do I know a PO invoice is being held rather than just late?

You usually cannot from the outside, which is the point. If an invoice against a PO passes its due date with no query, ask accounts payable whether it has been matched — that question gets an answer, whereas a payment reminder to your usual contact often does not.

Turn the answer into an invoice

The result above transfers straight into the invoice generator — dates, amounts and terms already filled in. Free, no account needed.

Open the invoice generator

Sources & further reading

Related

Invoice types

Published · General information, not legal, tax or financial advice.