ToolJovia
Calculators

Purchase Order Three-way Match

Reconcile purchase-order lines with accumulated receipt and invoice quantities and invoice unit prices using explicit absolute tolerances.

✓ Browser-local processing

Loading tool…

How to use Purchase Order Three-way Match

A payable invoice should agree with the approved order and the supplied receiving evidence. Compare all three sides without treating a missing receipt as zero or silently removing orphan rows.

  1. Enter approved PO lines, authorized receiving records and invoice-line metadata in one currency.
  2. Set explicit absolute quantity and unit-price tolerances and inspect all line and orphan findings.
  3. Resolve differences against original documents before an accountable human approves a payment outside this tool.

Good to know

  • No returns, tax, freight, currency conversion, source-document authenticity or accounting approval is inferred.
  • Quantities accumulate by exact PO/line; every invoice unit price is checked separately. Tolerances are not percentages or invoice-value limits.
  • Each input field is limited to 8,000 UTF-16 characters and each exact-header CSV to 100 data rows. Quoted commas/newlines and doubled quotes are supported. Unsupported controls and unpaired surrogates are refused. Decimal magnitudes are at most 999,999,999 with a smallest nonzero magnitude of 0.000000001; exponents are refused and whole counts are checked exactly. Rational results show at most 18 fractional digits and an ellipsis when more remain.
  • Editable Markdown and long-form CSV both retain all summary metrics, context, detailed findings, entered source rows and scope limitations. CSV columns are Record type,Section,Source row,Field,Value; spreadsheet-looking text is apostrophe-prefixed. These are review artifacts, not proof of source truth or a completed real-world task.
  • Runs deterministically in this browser. No AI, API, vendor connection, upload, outreach, calendar change, payment, storage or background monitoring. Use authorized pseudonymous records; inspect exports before sharing.

Explore a related business case

These cases explain the business mechanism. The workbench is ToolJovia's independent adaptation, not a claim about the company's internal workflow or an endorsement.

Common questions

Does a matching result authorize payment?

No. It only checks supplied arithmetic and identities within stated tolerances. Original documents, authority, taxes and accounting treatment require separate review.

What does an absent receiving record mean?

The received quantity remains unknown and the line is held. It is not interpreted as a verified zero delivery.

Keep going with related tools

All calculators →