Three-Way Match PO GRN Invoice Field-By-Field Test
Compare purchase-order, goods-received, and invoice quantity and amount fields and report each mismatch reason without rounding returned differences.
Description
Compare purchase-order, goods-received, and invoice quantity and amount fields and report each mismatch reason without rounding returned differences.
Three-Way Match PO GRN Invoice Field-By-Field Test: Compare purchase-order, goods-received, and invoice quantity and amount fields and report each mismatch reason without rounding returned differences.
When to use Three-Way Match PO GRN Invoice Field-By-Field Test
Use this procedure as a reproducible screening or independent-recalculation step over records prepared on a consistent accounting basis.
- Amount tolerance (percent)
- Required number input.
- Document values
- Required object input.
How Three-Way Match PO GRN Invoice Field-By-Field Test works
Compare purchase-order, goods-received, and invoice quantity and amount fields and report each mismatch reason without rounding returned differences. The tool evaluates the supplied inputs together and returns the named outputs below; it does not infer omitted operating conditions or change the units shown.1
- Invoice minus PO amount
- The resulting invoice minus po amount returned as a number.
- Invoice minus PO quantity
- The resulting invoice minus po quantity returned as a number.
- Received minus PO quantity
- The resulting received minus po quantity returned as a number.
- Matched
- The resulting matched returned as a boolean.
- Mismatch reasons
- The resulting mismatch reasons returned as a list.
Limitations and assumptions
- A flag identifies a record for investigation; it does not by itself establish error, fraud, or control failure. Completeness, authorization, materiality, holidays, tolerances, and source-system semantics require separate evidence.
- Use finite inputs in the displayed units and preserve more precision than the final presentation requires. Independently verify safety-critical, financial, compliance, or production decisions.
Alternative or Complementary approaches
Combine the result with source-document inspection, population reconciliation, exception sampling, and documented professional judgment. Preserve the tested population and parameters for reperformance.
References
-
Audit — Wikipedia contributors
Similar or alternative tools
- Same-Day Duplicate Invoice Exact-Match Flagger
Flag groups of invoices that share the same case-insensitive trimmed vendor, exact finite amount, and calendar date.
- Journal Entry Weekend Holiday Posting Date Flagger
Flag journal entries posted on configured weekend days or supplied holiday dates, preferring the holiday reason.
- Construction Percent Complete Cost-to-Cost Recompute
Recompute construction percent complete and cumulative revenue from costs incurred to date, estimated cost to complete, and contract price using the cost-to-cost method.