Match supplier invoices with AI
Compare orders, receipts and invoices line by line before payment, and give the buyer a short list of discrepancies with the figures behind each one.
Match supplier invoices with AI when the invoice says one hundred units but the warehouse has recorded two separate deliveries. The three-way-match skill works from the order, receipt and invoice tables you provide. It keeps the ordered, received and billed quantities visible so an approver can see what gave rise to a difference.
The comparison first uses the order number, then the supplier and item details where necessary. A missing receipt can remain an open question. A price outside an agreed tolerance can carry a proposed next action. Neither requires guessing that something was delivered or deciding that a supplier is at fault.
What it does
- Compare the invoiced unit price with the purchase order.
- Distinguish a missing receipt from a recorded short delivery.
- Flag a possible duplicate using supplier, invoice number and amount together.
- Identify the amount at risk if an exceptional line were paid as billed.
- Send an approver the relevant figures and the evidence needed to settle each question.
Install and use
- Supply three CSV files or pasted tables with order, receipt and invoice details. Provide any agreed tolerances. The review needs no banking access.
- Ask, “Match these invoices to the orders and receipts. List each quantity difference and what we would need to verify it.”
- Check the exception counts against the table and have the responsible person decide how to proceed.
FAQ
Source
Made by Open Financial Technologies Private Limited (Open Money). Original skill: three-way-match, published on GitHub under the MIT licence.
View on GitHub