All tools

Three-way match

Match purchase order, goods receipt and invoice, and see which difference blocks payment.

Result

Receipt vs order
-2
Invoice vs receipt
2
Exceptions raised
2

Download the workbook

The method

  1. The three quantities are compared, and any difference is an exception documented before payment.
  2. An invoice exceeding what was received is the case that blocks payment, not one to adjust away.

Built forAn accountant reviewing an entry or balance before close

When you need it

You have connected figures that need testing before they enter the close file. Match purchase order, goods receipt and invoice, and see which difference blocks payment.

The decision it supports

Use the result to decide whether the work can be accepted or a difference or classification needs tracing. The tool shows its method beside the result so you can review it.

What you receive

Three-way match result

A shareable interactive result with findings, calculation method and an Excel workpaper carrying the same figures.

An example you can inspect

A ready-to-run example

The tool opens with: Ordered quantity = 100, Received quantity = 98, Invoiced quantity = 100. Change any value to see its effect immediately.

Continue the workflow