Duplicate invoice keys
Normalizes invoice numbers and groups by vendor, currency and amount to surface repeated payments.
Free AP review starter
AP Duplicate Payment SQL Checks
SQLite-compatible checks for finance, internal audit and data teams reviewing authorized accounts-payable exports for duplicate invoice payments, same-day same-amount payments and credit/cancelled markers.
Download SQL View repository Use GitHub Action Share sanitized SQL feedback
Use only with data you are authorized to review. Do not upload or share supplier names, bank details, invoices, contracts, personal data or account identifiers in public systems. Findings are review leads, not proof of overpayment.
Same-day same-amount
Finds repeated vendor payments on the same invoice date even when invoice numbers differ.
Credit or cancelled markers
Flags paid rows with credit, cancelled, void or refund terms, plus negative amounts.
Run the test sample
Clone the repository and run python3 tests/run_checks.py or python3 scripts/audit_duplicate_payments.py examples/invoices.csv --output artifacts/sample-audit.json. The included CSV is synthetic and safe for local verification.
Run it in GitHub Actions
The repository includes a Marketplace-compatible action for scheduled or manual checks on authorized, sanitized CSV exports. Use BluePeakFoundry/ap-duplicate-payment-sql-checks@v0.2.0-csv-audit-action with csv-path, output-path and fail-on-findings.
Never commit live supplier, banking, tax, invoice, account, personal or confidential information to a repository.
Safe feedback channel
If a check misses a pattern or creates a false positive, open the sanitized AP SQL feedback form. Use only synthetic examples or generalized column names; do not post supplier names, bank details, tax IDs, invoice images, contracts, personal data or confidential vendor information.