All products

Match payments to invoices with AI

Trace receipts from a bank or processor export back to open invoices, with evidence for each proposed match and a queue for money that still needs an explanation.

Match payments to invoices with AI when several customers have paid the same amount or a processor has netted its fee out of a deposit. The payment-reconciliation skill starts with references, invoice numbers and customer identifiers before treating a similar amount or date as a clue. Each proposed link carries its evidence and a confidence rating.

A receipt with no reference may fit two invoices equally well. Keep it in the exception queue until someone finds the remittance advice. Meanwhile the team can see how much of the period’s cash already ties to invoices and which differences come from refunds, partial payments or exchange rates.

What it does

  • Tie a payment reference to its invoice and original transaction ID.
  • Separate processor fees from customer underpayments.
  • Find unapplied receipts and outstanding credits.
  • Compare suspiciously similar payments for a possible duplicate.
  • Prepare proposed ledger actions for an authorised reviewer.

Install and use

  1. Install the skill in your agent and provide permitted bank or processor exports and an invoice register for the same period. Include available remittance references and remove unrelated banking details.
  2. Ask, “Reconcile these Monday receipts. Put exact matches first and show me where an amount alone supports two different invoices.”
  3. Compare the exceptions with the source files before posting any adjustment in your accounting system.

FAQ

Source

Made by JustPaid / Loopfour. Original skill: payment-reconciliation, published on GitHub under the MIT licence.

View on GitHub