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 rapidly design, document, and validate internal control frameworks aligned with COSO 2013, SOX compliance, and audit standards. Claude helps you map business processes to control objectives, create control matrices linking risks to preventive and detective controls, generate control narratives for auditors, and identify control gaps for remediation planning—compressing what typically takes 200+ annual hours into a fraction of that time while improving control design quality.
by eryet
Analyze your organizational spending across departments and cost categories to uncover waste and inefficiencies. Identify specific, actionable cost-saving opportunities with quantified savings potential and implementation feasibility. Build professional, data-driven business cases with detailed ROI calculations, payback periods, and strategic recommendations to justify and accelerate your cost reduction initiatives.
by eryet
You can systematically process court orders, IRS levies, and child support withholdings by validating order authenticity, calculating accurate deductions accounting for state exemptions and federal limits, sequencing multiple garnishments by legal priority, and generating compliant documentation for courts and creditors. This skill handles the highest-risk payroll functions—reducing legal exposure, audit risk, and manual processing time while ensuring every deduction meets federal and state regulations.
by eryet
You receive a comprehensive framework for evaluating diversified passive income streams, assessing client risk profiles, and recommending portfolio structures that maximize income while maintaining alignment with financial objectives. The skill analyzes income sources (real estate, dividends, bonds, peer lending, digital assets), models cash flow projections, evaluates tax efficiency, and provides data-driven strategy recommendations ranked by performance potential.
by eryet
You can trace financial transactions across multiple accounts and entities, document complete chain-of-custody for audit evidence, identify fraud indicators and anomaly patterns, and construct defensible audit conclusions that satisfy both forensic rigor and legal admissibility requirements. This skill provides structured protocols for adversarial skepticism, hostile cross-examination preparation, and quantification of losses or damages with transparent methodologies.
by eryet
You can systematically validate payroll calculations against state-specific tax codes, withholding rules, and overtime thresholds across all 50 states plus DC. This skill cross-references your employee data against current regulatory requirements, identifies compliance gaps before submission, and generates documentation for audit purposes—reducing penalty exposure and audit risk for multi-state payroll operations.
by eryet
You can input invoice data, PO details, and receipt information to automatically identify variance types, trace root causes, and generate resolution recommendations. The skill creates documented audit trails for each discrepancy, enabling faster month-end close and reducing manual investigation time from hours to minutes. It handles quantity mismatches, pricing discrepancies, duplicate submissions, GL coding errors, and tax/freight charge validation.
by eryet
You'll systematically segment your delinquent portfolio using risk-based criteria including account value, days past due, payment history, customer type, and collection effort ROI. This allows you to apply differentiated collection strategies that maximize recovery dollars per hour invested, increase DSO recovery, reduce write-offs, and prevent agent burnout by eliminating pursuit of uncollectible accounts.
by eryet