How to match invoices to purchase orders
Learn to match invoices to purchase orders, check receipts and prior bills, and document quantity, price, and duplicate exceptions for finance review.
Free app. Runs on your Mac with the Claude or Codex plan you already have.
What it means to match invoices to purchase orders
When you match invoices to purchase orders, you check whether the supplier billed the buying entity for the right items at the agreed prices and whether the quantities billed are supported by records of what arrived. The approved purchase order, or PO, records what was ordered. The goods receipt records what was received. Checking the invoice against both is called a three-way match. Prior bills, credits, and returns matter when the supplier delivers or bills against the same order more than once.
Start with one buying entity and a dated cutoff so every balance answers the same question about the same period. Compare records line by line, keep the evidence for each discrepancy, and prepare a draft for a qualified finance reviewer. The reviewer needs to be able to follow a disputed invoice line back to the order, receipt, and billing history, then decide whether to ask for a correction or gather more evidence.
What it does for the business
- Catch repeat billing before payment reviewChecking supplier invoice numbers across billing history catches a repeat submission even when it appears under a different PO. Finance can trace the two records and resolve their identity before making a decision.
- Get precise corrections from suppliers and receiving teamsAn exception that identifies the PO line, the billed quantity, and the receipt gives the recipient something specific to investigate. The supplier can check its invoice against the dispatch, while receiving can check whether a delivery or return was recorded correctly.
- Give purchasing evidence for follow-upRepeated price differences tied to the approved order give purchasing a basis to review supplier billing and order maintenance. The purchase owner can check whether a change was agreed, update future orders through the approval process, or ask the supplier to correct its billing.
- Keep month-end review focused on unresolved itemsA dated exception list lets finance see where a missing export or disputed receipt still affects the review. Each assigned reviewer can follow up on a defined set of records and return the evidence the team needs for the next pass.
How to match invoices to purchase orders, step by step
Establish the buyer, cutoff, and complete source set
A comparison is only as complete as the billing and receipt history behind it.
What to do
- Set the buying entity and cutoff date. Identify the invoice lines you are reviewing and collect the latest approved purchase order versions for their scope.
- Gather receipts and returns from the start of each order through the cutoff. Gather pending and posted bills, linked credits, and evidence of any reversals over the same period.
- Check the invoice register for the target suppliers, including relevant invoice numbers beyond the selected orders. Keep paid bills in history because they still consume PO quantities.
- Confirm the periods and records each export covers with its owner or with dated export evidence. Record missing periods, excluded drafts, and future records with reasons.
Why
An empty export leaves two possibilities open. The order may have no prior billing, or your export may omit the records that show it. Only confirmed coverage gives you a basis for treating the prior balance as zero. The same applies to missing receipts and returns.
Link lines and check their comparison basis
Every matched line needs a source reference that another reviewer can verify.
What to do
- Use stable supplier, item, and PO line identifiers. Link receipts to evidenced PO lines and ask the owner to confirm any necessary mappings between source systems.
- Compare the unit of measure, currency, and pricing basis before comparing quantities or amounts. Check for differences such as a purchase order priced per case and an invoice priced per item.
- Preserve the source file and page, row, or cell for each header and line. Record any documented normalization so another reviewer can reproduce the comparison.
- Route charges or terms outside your matching rules for manual review. Keep freight, discounts, and other adjustments visible so the reviewer can explain how the invoice total was reached.
Why
Equal amounts and similar item names can hide a link to the wrong order line. Quantities and prices only compare directly when the units and currency agree. Recording source locations also helps finance tell the difference between a supplier discrepancy and a mistake in preparing the comparison.
Recalculate charges and reconcile cumulative quantities
Each new bill needs to fit the remaining order and receipt balances.
What to do
- Compare the invoice unit price to the approved PO price. Recalculate the line net amount before tax, check tax arithmetic against the supplied basis, and reconcile line sums to the invoice header.
- For each PO line, subtract recorded returns from receipts and combine current billing with prior billing and valid linked credits. Compare cumulative billed quantities and values with both the ordered and net received amounts.
- Verify which original billed line a credit note corrects. Track price-only credits as reductions in value and quantity credits as reversals of billed units. Record any physical return in the receipt history.
- Compare the supplier ID and normalized invoice number against the register. Preserve leading zeroes and punctuation. Hold suspected duplicates and conflicting bills together while gathering evidence.
Why
In a partial delivery, an invoice can be within the ordered quantity and still exceed what arrived. Two bills can also fit separately while exceeding the balance together. Calculating on the whole batch prevents the order in which you open the invoices from deciding which bill gets the remaining capacity.
Prepare the exception queue for review
Each exception should tell the reviewer what to check and where to find it.
What to do
- Verify that the checked current lines agree with the intake list. Review held rows and distinguish missing evidence from differences supported by the available records.
- For each difference, record the invoice and PO line, currency, unit, exact amounts or quantities, and source locations. Show which other records the reviewer needs to inspect.
- Assign a concrete next action to a responsible role. Receiving can investigate a missing goods receipt, while purchasing can check whether a different price was ever approved.
- Mark any affected balances as provisional until the evidence is corrected. Keep checked lines available so the reviewer can see the full scope alongside the exceptions.
Why
A general note about a quantity problem leaves the next person to reconstruct the check. A source-linked queue gives that person the exact records and a task they can complete. It also shows whether one unresolved discrepancy affects several bills.
Confirm the evidence before an accounting decision
A matching result gives finance evidence for a decision.
What to do
- Have a qualified finance reviewer check source rows for the disputed quantities, prices, document versions, and any gaps in coverage.
- Record which facts are confirmed, what needs correction, and which items remain unresolved or received manual review. Attach the evidence behind each decision.
- Keep the original matching results with the reviewer notes. When corrected records arrive, use a fresh cutoff for the new export and recalculate the affected balances.
- Hand off unresolved bills with the source needed and the next action, such as obtaining a linked credit or confirming a return.
Why
Accounts payable automation can surface discrepancies and reduce the work of tracing them. A qualified reviewer still needs to assess coverage, resolve disputed facts, and follow the business's approval process. Keeping the original calculation makes it easier to explain what changed when a new export arrives.
Common mistakes
- Comparing each bill in isolationCheck current and prior bills together against the PO and net receipts so the same delivery supports only the recorded quantity.
- Assuming a blank export proves there was no activityAsk the ledger owner to confirm which entities, dates, and statuses the export actually covers.
- Matching by description or amountConfirm the source link to the PO line and check the item, unit, and currency before comparing values.
- Treating a credit as a receiptUse the credit to adjust billing and record a physical return through its own receipt event.
- Closing a suspected duplicate without evidenceConfirm the identity of both records and retain the source copies before recalculating.
What a good result looks like
- The worksheet identifies the buyer, cutoff, current bills, and coverage for each source.
- Each finding points to the invoice line and the related order, receipt, or billing record.
- Cumulative balances include pending bills, posted bills, valid credits, and returns.
- The exception queue states the exact conflict, responsible role, and next action.
- Review notes show what finance confirmed and what evidence is still needed.
And then what? Using the result
- Send the assigned receiving or purchasing owner the source references needed to verify their exception.
- Ask the supplier for a corrected bill or linked credit when the finance reviewer confirms the discrepancy.
- Collect the updated exports, set a fresh cutoff, and rerun the checks after corrections are recorded.
- Share recurring mismatch causes with purchasing and receiving so they can improve their order and receipt records.
When to run it
- Before a payment reviewUse the worksheet to organize unresolved bills and give the finance approver the supporting evidence.
- When one order has several deliveries or invoicesCheck how much was ordered, received, and billed across the whole history. Include returns and credits before comparing balances.
- After discovering gaps in an exportRun the comparison again once the owner provides the missing source. Use the dated review to track which conclusions changed.
Questions people ask
How do you match invoices to purchase orders?
Link each invoice line to its approved PO line, check units, prices, and amounts, then reconcile cumulative billing against the order and net receipts. Include prior bills and linked credits and document exceptions for a qualified finance reviewer.
What is a three-way match in accounts payable?
A three-way match compares the invoice, approved purchase order, and receipt record. Together they show what the supplier billed, what the buyer ordered, and what the buyer recorded as received.
How do you match an invoice after a partial delivery?
Compare cumulative billed units with cumulative received units less returns, and also check the PO limit. Include pending and posted bills and any valid quantity credits. Hold conflicts for review if the paperwork shows more billing than the receipts support.
How do you spot a duplicate invoice?
Check the supplier ID and normalized invoice number against current bills and the invoice register. Trim surrounding spaces and compare without case differences while keeping punctuation and leading zeros. Ask finance to verify the identity of records that match.
How does a credit note affect invoice matching?
A valid price credit reduces billed value, and a valid quantity credit reverses billed units and their value. Link the credit to the original billed line and check that the total credits stay within that line's amount and quantity.
What do you do when a receipt is missing?
Hold the affected bill for review and ask receiving to confirm the delivery and supply the relevant record. Check whether the receipt is missing from the export or absent from the original records, then rerun the comparison with corrected evidence.
More jobs in Finance
Match invoices to purchase orders, on your own Mac.Free app. Runs on your Mac with the Claude or Codex plan you already have. Your files stay on your computer.
Download for Mac