Quantity mismatch
Invoice quantity that does not match PO or GRN stays as an exception.
PO / Invoice / GRN matching
Compare a purchase order, a supplier invoice, and a goods received note. AuditExport is not an ERP replacement. It is a structured check on the procurement files you already export.
Try the free duplicate invoice checker
Three-way matching in spreadsheets usually means three tabs and a set of lookups that break when a partial receipt arrives. Quantity, price, and missing documents need a result a reviewer can walk through.
How it works
Step 1
Purchase order, invoice, and GRN or receiving export.
Step 2
PO number, SKU or line, quantity, price, and invoice reference.
Step 3
Compare quantity and price across the three sides.
Step 4
Missing GRN, overbilling, missing PO, duplicates, and partial receipts.
Step 5
Hand AP a structured exception list instead of a marked-up workbook.
What this workflow is designed to do with uploaded files.
Invoice quantity that does not match PO or GRN stays as an exception.
Unit price differences between PO and invoice are listed with both values.
Invoices without a receiving document do not silently clear.
Billed quantity or amount above the PO or receipt is visible.
Invoices that cannot be tied to an order stay unmatched.
The same invoice presented twice is flagged.
Received quantity below ordered quantity remains visible instead of being forced to match.
PO-1044 orders 100 units at $18.00. GRN shows 80 received. Invoice bills 100 at $18.50. The result shows a partial receipt and a price mismatch — not a clean three-way match.
Sample preview
Sample procurement lines. Fictional SKUs.
| Line | PO qty | GRN qty | Invoice qty | PO price | Invoice price | Status |
|---|---|---|---|---|---|---|
| A-100 | 100 | 80 | 100 | $18.00 | $18.50 | Partial receipt + price mismatch |
| B-220 | 40 | 40 | 40 | $62.00 | $62.00 | Matched |
| C-015 | 12 | — | 12 | $9.50 | $9.50 | Missing GRN |
| D-880 | — | — | 6 | — | $41.00 | Missing PO |
Procurement files still live in spreadsheets for many teams. A structured check reduces the chance that an overbill or missing receipt is buried in a lookup column.
Continue with the workflows that usually sit next to this one.
No. It checks spreadsheet-based procurement data. It does not create POs, receipts, or payments.
Yes. Upload the sides you have. A missing third file is itself a finding when three-way is expected.
Where amount or quantity tolerances are configured for the run, close differences can be classified instead of treated as exact.
Upload PO, invoice, and receiving files. Review quantity and price exceptions.