Invoice Three-Way Match Automation
Automate three-way invoice matching to catch discrepancies and prevent duplicate payments
What You Can Do
You can systematically extract and validate data from invoices, purchase orders, and receiving reports to ensure alignment before payment. Claude identifies discrepancies in quantities, pricing, and terms, flags exceptions for manual review, and generates detailed matching reports that create audit trails for compliance. This automation cuts invoice processing time significantly while preventing payment errors and duplicate submissions.
Features
Claude pulls line-item details from invoices, POs, and receiving reports in seconds
Identifies when invoice quantities differ from PO or RR amounts
Catches unit price discrepancies and total amount overages
Detects repeated invoices or invoice numbers to stop redundant payments
Generates summary reports highlighting only problematic invoices requiring manual review
Documents all matching logic and exceptions for compliance and vendor dispute resolution
Processes invoices above defined amounts (e.g., >$500) to prioritize high-risk transactions
Applies configurable acceptance ranges for minor discrepancies (e.g., 2% price variance)
Example Output
Example 1: Price Variance Detection
Invoice #INV-2024-5847 | Vendor: ABC Supplies
- Line Item: Office Paper (Case)
- PO Unit Price: $45.00 | Invoice Unit Price: $48.50 ❌
- Quantity: 10 cases (match)
- Variance: +$35.00 total (+7.8%)
- Status: EXCEPTION — Price overage. Recommend payment hold pending vendor clarification.
Example 2: Quantity Mismatch
Invoice #INV-2024-5848 | Vendor: XYZ Logistics
- Line Item: Delivery Services
- PO Quantity: 12 shipments | RR Quantity: 12 shipments | Invoice Quantity: 15 ❌
- Amount: $3,600 invoiced vs. $2,880 PO authorized
- Status: EXCEPTION — Quantity overage. Only 12 shipments received; 3 additional charges not authorized.
Example 3: Clean Match (No Exception)
Invoice #INV-2024-5849 | Vendor: Trusted Vendor Inc.
- Line Item: Raw Materials (Batch A)
- PO: $12,500 | RR: Received full quantity | Invoice: $12,500 ✅
- Status: APPROVED — Three-way match confirmed. Ready for payment.
What's Included
- SKILL.md: Complete instruction file for three-way match automation workflow
- Matching Criteria Template: Define tolerance thresholds, variance limits, and exception rules
- Invoice Extraction Checklist: Step-by-step guidance for structuring PO, RR, and invoice data for analysis
- Exception Report Framework: Pre-formatted summary template highlighting discrepancies, variance amounts, and recommended actions
- Audit Trail Worksheet: Document matching decisions, flagged items, and approval sign-offs for compliance records
Who It's For
- Accounts Payable Specialists — Automating repetitive three-way matching tasks to focus on complex exceptions
- AP Managers — Accelerating invoice processing cycles and strengthening internal payment controls
- Finance Controllers — Implementing documented AP procedures and audit compliance requirements
- Procurement Analysts — Validating PO accuracy and investigating vendor pricing discrepancies
- AP Operations Teams — Processing high-volume invoices (50+/week) with consistent accuracy
Best For
- Validating invoices above risk thresholds (e.g., >$500) before payment authorization
- Detecting pricing overages, quantity mismatches, and duplicate submissions
- Generating exception reports that highlight only problematic invoices for manual review
- Creating audit trails and compliance documentation for vendor disputes or audits
- Investigating historical invoice discrepancies and reconciling AP records
You might also like
You can systematically validate employee payroll records, cross-check tax withholding calculations against current tax brackets, verify regulatory compliance across federal/state/local requirements, and flag anomalies that could trigger penalties—all before executing payment runs. This reduces processing time by 40-60% while catching errors that manual spreadsheet reviews typically miss, working across ADP, Workday, Gusto, and manual payroll systems.
by eryet
You systematically extract financial red flags from claim submissions, construct causal narratives linking evidence to fraud conclusions, and quantify potential loss exposure. This skill helps you distinguish between legitimate claim variations and fraud indicators, enabling you to generate investigation summaries defensible in litigation, settlement negotiations, or Special Investigation Unit (SIU) presentations.
by eryet
This skill helps you audit nexus comprehensively by analyzing physical presence rules, economic thresholds, affiliate connections, and marketplace facilitator statutes across all 50 states and relevant localities. You'll document nexus triggers specific to your client's business model—whether they're selling through marketplaces, using drop-shipping, hiring remote employees, or expanding operations. The result is an actionable filing calendar and remediation strategy that minimizes compliance gaps and protects against substantial back-tax assessments, penalties, and interest.
by eryet
You can allocate indirect costs (administration, utilities, depreciation, maintenance) across clinical and non-clinical departments using activity-based costing (ABC) and traditional allocation methodologies. This skill helps you calculate precise allocation rates, model reimbursement scenarios, validate cost driver selections, and document allocation methods for compliance—enabling data-driven decisions on service line profitability, pricing strategies, and payer contract negotiations.
by eryet
You can execute structured compliance audits that map regulatory requirements to operational controls, test control effectiveness with documented evidence, quantify compliance risk exposure, and track remediation progress with clear accountability. The framework produces audit findings in regulatory-acceptable format, transforming ad-hoc reviews into defensible procedures that satisfy internal audit standards (IIA) and regulatory expectations.
by eryet
You can analyze insurance claim files to uncover fraud indicators by synthesizing evidence from policyholder statements, medical/repair records, financial documents, and prior claims history. This skill helps you reconstruct timelines, identify inconsistencies and impossibilities, recognize suspicious financial patterns, and build defensible fraud conclusions suitable for claims adjustment, litigation support, or settlement negotiations. Transform raw claim data into an evidence hierarchy distinguishing confirmed facts, supported inferences, and investigative leads requiring further development.
by eryet
You can systematically classify and track expenses against specific restricted grants and donations, reconcile fund balances with compliance verification, and generate accurate financial statements that separate restricted and unrestricted funds. This skill prevents audit failures, donor relation damage, and grant non-compliance penalties by ensuring every restricted fund expense is properly documented, allowable under grant terms, and traceable to donor/grantor requirements.
by eryet
You can systematically prepare tax provisions that survive audit scrutiny by calculating current and deferred tax impacts, reconciling effective tax rates from statutory to reported amounts, and documenting uncertain tax positions with FIN 48 support. The skill guides you through multi-jurisdictional tax exposure analysis and helps you create audit-ready workpapers with clear audit trails for quarterly (10-Q) and annual (10-K) financial statement filings.
by eryet