Automate Three-Way Matching of Supplier Invoices
Stop paying wrong invoices — automatically match each supplier invoice against its purchase order and goods receipt, flagging any discrepancy.
- 1
Receive the Invoice
Add a
Gmail Triggernode on an invoices label and extract the amount, PO number and line items. - 2
Look Up PO and Receipt
Add
Google Sheetsnodes fetching the matching purchase order and goods receipt by PO number. - 3
Compare the Three
Add a
Codenode checking quantities and amounts across invoice, PO and receipt within tolerance. - 4
Approve or Flag
Add an
IFnode auto-approving matches for payment and posting mismatches to Slack for review. - 5
Activate and Test
Activate the workflow and send a matching and a mismatched invoice. Confirm each is handled correctly.
Frequently asked questions
What tolerance should I allow?
A small percentage tolerance handles rounding and minor freight differences without flagging every invoice.
Can it handle partial deliveries?
Track received quantities cumulatively so invoices for partial shipments still match correctly.
Keep every recipe free
FlowRecipesHub is free and always will be. If a workflow saved you time, chip in what you like — it helps us keep the lights on and build the next batch of automations for everyone.
Secure checkout via Paddle · one-time, no account needed
