Find invoice totals above the purchase order
Sum split invoices by supplier and purchase order, compare them with the PO amount, and flag currency mismatches or unmatched references.
How do I compare several invoices with one purchase order?
Group invoices by the same supplier and PO reference, then compare their combined amount with the purchase order. PO Exposure adds split invoices using exact supplier + PO keys and checks whether the sum exceeds the supplied PO amount.
Input requirements and report limits ↓Inputs
Copy a table from Excel or Google Sheets, including its header row, and paste it below. CSV/TSV files also work. Use “Map your columns” for different headers. IDs stay as text.
Free: UTF-8 CSV/TSV · 200 KB / 500 rows per input · 5 successful reviews per browser per day. CSV calculations run locally.
Need larger files or repeat batches? View editions →
Reuse a column profile
A profile stores column names only. It does not store your file contents.
Review report
Before you use this review
| Bring | PO amounts and individual invoice amounts with supplier, PO and currency; invoices also need unique invoice IDs. |
|---|---|
| Match | Exact supplier + PO; sum matching-currency invoice amounts. Use consistent tax treatment. |
| Read the result | A PO of 1,000 with invoices of 600 and 450 has 50 excess. Currency mismatches leave the total incomplete. |
| Cannot establish | Payment, liability or three-way matching with receipts. Multi-PO invoice allocations are outside this template. |
Required inputs
Purchase orders need supplier, po, amount, currency. Invoices need supplier, invoice_id, po, amount, currency. PO keys must be unique, as must supplier + invoice ID keys. Amounts are nonnegative with at most two decimal places.
Interpret the report
A synthetic PO of 1,000 with invoices of 600 and 450 is 50 over the PO. Currency mismatches require review; the displayed matching-currency total is incomplete rather than a converted total. Invoices without a matching PO are listed separately.
Use consistent tax-inclusive or tax-exclusive amounts. This does not track payments, credit notes, accruals or ledger postings, and an over-PO result does not establish liability. To compare physical delivery quantities instead, use Receipt Gap.
Is this a three-way match of purchase order, invoice and receipt?
No. This check compares purchase-order amounts with invoice totals. It does not compare invoice lines with goods received. Use Receipt Gap for partial receipt quantities as a separate review; the two reports do not automatically establish a three-way match.
What if one invoice covers several purchase orders?
The input expects one PO reference per invoice row and a unique invoice ID per supplier. A multi-PO invoice needs an allocation workflow outside this tool. Do not copy its full amount to each PO or invent invoice IDs to bypass the duplicate check.
Prepared by Supplier Desk Team · Updated . Examples are synthetic.
Who this is for
Small retail and wholesale operations teams reviewing supplier exports before changing catalog, stock or purchasing records. This is a focused review worksheet; it does not connect to your store or post transactions.
Related background
Read the source discussion or documentation. This describes the broader workflow. Use the input requirements and calculation rules above to decide whether this particular check fits your task.
Free tools with optional offline batch editions. Higher file limits, saved batch configurations and grouped report exports. No automatic store changes.