Today's Agent Skill: Invoice Reconciliation Bot

What It Does

Finance and ops teams lose hours every week manually matching vendor invoices against purchase orders and receiving logs, hunting for quantity mismatches, price discrepancies, and duplicate billing. A single missed overcharge can cost thousands, but nobody has time to line-item audit every invoice by hand. This skill turns that tedious cross-referencing into a five-minute automated check.

How It Works

The agent pulls the invoice, its matching PO, and the receiving record, then compares line items on quantity, unit price, and totals. It flags any variance above a configurable tolerance, catches duplicate invoice numbers against a payment history log, and produces a structured discrepancy report ranked by dollar impact.

How to Deploy It

Drop the SKILL.md file into any SKILL.md-compatible agent's skills directory (for example ~/.claude/skills/invoice-reconciliation/SKILL.md) and point the agent at your invoice, PO, and receiving data sources — a shared drive folder, an accounting API export, or a spreadsheet works equally well. Once installed, trigger it by name or let it fire automatically whenever a new invoice lands in the watched folder.

SKILL.md — Ready to Deploy

## Description
Reconciles vendor invoices against purchase orders and receiving records to catch pricing errors, quantity mismatches, and duplicate billing before payment is issued.

## Trigger
Activates when a new invoice file arrives in a watched location, when a user asks to "reconcile this invoice" or "check this invoice against the PO," or on a scheduled batch run against a pending-invoices queue.

## Input
- Invoice document (PDF, image, or structured export) with vendor name, invoice number, date, and line items
- Matching purchase order (PO number, line items, agreed unit prices)
- Receiving record or delivery confirmation (quantities actually received)
- Optional: payment history log for duplicate detection, tolerance threshold (default 2%)

## Steps
1. Extract line items, quantities, unit prices, and totals from the invoice.
2. Locate the matching PO by PO number or vendor + date proximity.
3. Compare each invoice line against the corresponding PO line: quantity ordered vs. billed, unit price agreed vs. charged, extended totals.
4. Cross-check billed quantity against the receiving record — flag billing for goods not yet received.
5. Search payment history for the invoice 

Copy the full SKILL.md and drop it into your agent's skills directory to activate this skill.

← Back to All Posts | Home — MD AI Tools