ap-duplicate-payment-preflight

AP Duplicate Payment Preflight

English | 简体中文

Catch duplicate vendor payments before money leaves the bank.

Part of the Practical Agent Skills collection.

ap-duplicate-payment-preflight is a local-first agent skill for finance, AP, operations, and founder-led teams that review payment runs before ACH, wire, card, or check release.

It helps an agent inspect exported invoices or bills, find exact and near duplicates, and produce an AP-reviewable exception report without connecting to your ERP or handling credentials.

Problem

AP teams often rely on ERP warnings that catch only exact duplicates. Real duplicate payments often appear as vendor aliases, OCR invoice-number variants, resubmitted bills, or paid-versus-pending collisions that require a repeatable review process.

This skill combines AP-specific review rules with a deterministic local scanner so an agent can produce a payment-run exception report without connecting to accounting systems or handling credentials.

Why Use This Instead Of A Prompt

• Normalizes invoice numbers such as INV-1007, INV1007, and 1007.
• Checks paid-versus-pending collisions, same PO, same amount, close dates, and vendor aliases.
• Separates hold_payment, ap_review, and allowed-with-note cases.
• Keeps the agent inside an operational review boundary instead of approving or cancelling payments.

Contents

• SKILL.md - agent instructions and acceptance checks.
• agents/openai.yaml - OpenAI/Codex style metadata.
• references/duplicate-payment-rules.md - classification rules and failure modes.
• templates/exception-report.md - reviewer-ready report template.
• examples/sample-report.md - expected output shape.
• scripts/ap_duplicate_payment_preflight.py - local scanner for CSV/JSON exports.
• scripts/fixtures/ - smoke-test AP export.
• openclaw/README.md and hermes/README.md - runtime notes and current verification limits.

Run

python3 scripts/ap_duplicate_payment_preflight.py \
  --payments scripts/fixtures/ap_payments.csv \
  --date-window-days 14

The script prints Markdown to stdout. It writes a file only when --output is provided.

Inputs

CSV columns are matched case-insensitively. Preferred fields:

vendor_name,vendor_id,invoice_number,invoice_date,payment_date,amount,currency,status,po_number

JSON exports may be a list of payment objects or an object containing payments, invoices, bills, or rows.

Install Notes

Codex/OpenAI-style agents can use the skill directory directly. Claude Code can copy the mirrored .claude/skills/ap-duplicate-payment-preflight/SKILL.md or the whole directory into its skills folder.

OpenClaw and Hermes support is documented but not claimed as fully verified unless the matching local CLI/spec is available.