Appearance
Invoice matching
Also known as
- Invoice matching workbench
- 3-way match
- three-way match
- 2-way match
- two-way match
- match exception
- bill on hold
- price variance
- quantity variance
- tolerance
Every vendor bill that references a purchase order is matched against the order and its receipts. This list shows the result per bill, exceptions first, so accounts payable and buyers can clear the bills that are on hold.
How matching works
When a bill with purchase order lines is submitted in Finance (from Create bill on a purchase order or in Vendor bills), each line is checked:
- Quantity: the billed quantity (this bill plus earlier bills) against the received quantity (three-way match) or the ordered quantity (two-way match, and non-stock lines when that setting is on), within the Quantity tolerance %.
- Price: the billed net unit price against the PO price, within the Price tolerance % or the Amount tolerance per line.
- Currency: the bill must be in the order's currency.
If every line passes, the bill is Matched and continues to approval and posting. Otherwise it is an Exception: Finance keeps the bill in draft and on hold, and the buyer is notified. Tolerances are set in Matching and receiving (demo: quantity 5 %, price 2 %, amount 10).
Clear an exception
- Open ProcurementInvoice matching. Exceptions are listed first; the Notes column says why, for example "line 1: billed 25 exceeds received 20".
- Select the bill to open the match detail.
- Fix the cause:
- goods still to arrive: receive them on the purchase order;
- wrong PO price: Revise the purchase order;
- wrong bill: correct the bill in Finance (Open bill in finance).
- Select Re-check on the match detail. The bill is matched again and, when it passes, goes on to approval and posting.
- If the difference is accepted, a user with Permission:
finance.bill.override_matchselects Release hold on the bill in Finance; the match shows Overridden.
Filters
| Filter | Use |
|---|---|
| Match | Pending, Matched, Exception, Overridden, Not required. |
| Vendor, Date | Narrow the list. |
| On hold | Bills held by Finance. |
Match statuses
| Status | Meaning | What you can do next |
|---|---|---|
| Pending | Not checked yet (draft bill not submitted). | Submit the bill, or Re-check. |
| Matched | Within tolerance. | Nothing; the bill continues to approval and posting. |
| Exception | Outside tolerance; the bill is on hold. | Fix the cause and Re-check, or release the hold in Finance. |
| Overridden | Finance released the hold despite the exception. | None. |
| Not required | The bill has no purchase order lines. | None (counts as maverick spend in Spend analytics). |
Posts when a matched bill is posted in Finance
| Account | Debit | Credit |
|---|---|---|
| GRNI (stock lines) | ✓ | |
| PO line expense account (non-stock lines) | ✓ | |
| Input tax | ✓ | |
| Accounts payable | ✓ |
