Three-way Purchase Matching Workbench
Review ordered, received and invoiced quantities with explicit price tolerances and traceable individual exceptions.
Loading tool…
How to use Three-way Purchase Matching Workbench
Match cumulative rows by your exact purchase line IDs, retain unknown references, compare every billed unit price and reconcile invoice totals without silently rounding.
- Use the example as the schema; replace its labels and entered model assumptions.
- Match cumulative rows by your exact purchase line IDs, retain unknown references, compare every billed unit price and reconcile invoice totals without silently rounding.
- Calculate, inspect the complete witnesses and limitations, then copy or download the JSON report.
Good to know
- 1–100 distinct order lines; up to 300 receipt and 300 invoice rows. Quantities are positive and unit prices/tolerances nonnegative, with decimal-string magnitude at most 1 billion. Each row uses one unchanged unit and currency.
- The snapshot must already include all intended prior receipts/invoices. Partial billing is allowed; excess quantity and absolute per-unit price differences create review flags. Returns, credits, tax, FX, document parsing and payment approval are excluded.
- Local calculation with no upload, input persistence or outside lookup. Model JSON is limited to 30,000 characters and 10,000 values. Decimal quantities are strings with up to six places; count fields use plain JSON integers. Exact fractions are capped at 8,192 bits. The complete JSON output is limited to 1,000,000 characters; approximate numbers preserve their stored values. Unsupported states fail explicitly.
Common questions
Can offsetting price differences hide a review item?
No. Each invoice row is checked against the ordered unit price before totals are combined. Positive and negative differences can cancel in a total while their separate exceptions remain visible.
Are my model inputs saved or sent to a server?
No. This model runs in the current browser tab and creates a local JSON download. It does not save your input or call an external data service.
Keep going with related tools
All calculators →Perpetual Inventory Cost Ledger
Walk receipt and issue events through exact FIFO layers or a moving-average inventory balance.
CalculatorsInvoice Line Rounding and Reconciliation
Inspect exact invoice bases, per-line or per-rate tax rounding, and a discrepancy against your entered total.
CalculatorsInvoice Aging Snapshot
Group entered open invoice amounts at one UTC as-of date with exact cents and explicit age boundaries.
CalculatorsPhysical Stocktake Count Workbench
Compare primary or recount physical observations with book stock, converting package counts to base units and retaining missing counts and signed cost differences.
CalculatorsCustomer Receipt Allocation Ledger
Apply customer receipts to invoices with exact partial balances and visible unapplied credit.