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.
Log Stripe Payments from Zapier into a Google Sheets Accounting Ledger
An n8n workflow that receives successful Stripe charges relayed by Zapier, calculates fees and net amount, and appends a clean bookkeeping row to a Google Sheets ledger — giving small businesses a real-time revenue log without paying for accounting software.
Free recipeGenerate a Weekly Cohort Retention Report Automatically
Know if customers are sticking — build a weekly cohort retention report from your usage data and deliver it to the team without touching a spreadsheet formula.
Free recipeGet Alerted the Moment a Supplier Changes Their Prices
An n8n workflow that periodically fetches your suppliers' price lists, compares them to the last known prices, and alerts you to any increases or drops with the exact delta — so cost creep never silently erodes your margins and you can renegotiate or re-price in time.