Three-Way Match: Supplier Invoices Paid Only for What Was Ordered and Received

Invoice lines matched to POs and receipts before payment runs.

What it solves: Invoice lines, purchase orders and receipts are matched in one Kylon room. Agents fill gaps from the invoice detail in Box, set follow-up tiers and reassess after late receipts and credit notes, and the AP lead approves each status before a payment run is built.

How it runs

  1. First match Each invoice line is matched to its PO line and receipt, and a blank invoiced quantity is filled from the Box line-detail note first Who decides: The AP lead approves statuses before Airtable is written
  2. Follow-up tiers Each unmatched line gets a tier: buyer follow-up, supplier query or payment hold Who decides: Buyers accept their follow-ups
  3. Match report review The generated report is checked against the lines as they stand Who decides: The AP lead corrects and releases it
  4. Late receipts Lines touched by newly posted receipts are reassessed Who decides: The receiving lead confirms the receipts; the AP lead approves
  5. Tolerance revision Only lines currently at quantity variance are reassessed, and every line is still reported Who decides: The controller approves the revised tolerance
  6. Credit notes and closeout Credit notes are matched by invoice id, and the five supplier payment runs are closed out Who decides: The AP lead approves each payment run

Tools it connects

  • Airtable: Holds the invoice, PO and receipt lines, their match status and the payment run records.
  • Box: Holds the invoice PDFs and the line-detail notes used to fill blank quantities.
  • Google Drive: Keeps the match policy, the tolerance table and the match report.
  • Gmail (optional): Carries buyer threads with suppliers, with follow-ups drafted for the buyer to send.
  • Outlook (optional): Carries the AP inbox where suppliers send invoices and credit notes.
  • Slack (optional): Is where receiving posts late deliveries and split shipments.

Set-up prompt

Paste this into Kylon, or start it in one click below.

Set up our three-way match desk in this Room. Take it one step at a time and wait for my OK before you move on.

1. Connect Airtable, Box and Google Drive first, since the first run needs them. Tell me which ones still need connecting. Gmail, Outlook and Slack can wait until a step uses them.
2. Ask me who works this desk: the AP lead, the buyers, the receiving lead and the controller. Help me invite them to this Room.
3. Build an Invoice Match App with Invoice line, PO line, Match and Status columns, one record per line. Fill it from the open invoice lines in Airtable and the invoice PDFs in Box.
4. Match each invoice line to its PO line and receipt. Fill any blank invoiced quantity from the Box line-detail note. Check each match against the threshold we set. Propose a status and a follow-up tier for every line, and show me the ones that fail.
5. Draft supplier follow-ups and credit note replies for buyers to send from Gmail. Never write a status to Airtable and never send any mail until the AP lead approves each match status, the buyers accept their follow-ups, and the AP lead approves each payment run.
6. Write our rules, our checks and who approves what into this Room's guideline, so every match cycle follows the same rule set.
7. After one clean week, offer to turn the match cycle into an Automation.

Start with step 1. Once the tools are connected, or I say the rest can wait, ask me for our rules one at a time.

Start in Kylon · Full page on kylon.io