- Home
- Skills
- Finance & Accounting
- AI Invoice Reconciliation Assistant
Works with the AI tools you already use
AI Invoice Reconciliation Assistant
Automate three-way matching between invoices, POs, and payments to flag variances and missing records.
$5
AI Invoice Reconciliation Assistant
Example session with this skill installed
I have 3 invoices (INV-001 for $500, INV-002 for $1200, INV-003 for $300) and 2 POs (PO-88 for $500, PO-89 for $1150). Payment data shows $500 to Vendor A and $300 to Vendor B. Reconcile this.
- Read your context and instructions
- Compiled the ai invoice reconciliation
- Generated the document
The reconciliation review for the provided 3 invoices, 2 purchase orders, and 2 payment records is complete. A variance was identified in the second transaction set, and one invoice remains unmatched.
Invoice Reconciliation Report
1. Scope and Data Sources
- Sources: 3 Invoices, 2 Purchase Orders, 2 Payment Records.
- Reporting Period: Not specified.
- Currencies: USD (assumed based on symbols).
2. Reconciliation Summary
- Exact Matches: 1 (INV-001)
- Amount Mismatches: 1 (INV-002 vs PO-89)
- Unmatched Records: 1 Invoice (INV-003), 1 Payment ($300).
3. Reconciliation Table
| Invoice ID | Vendor | PO Ref | Invoice Total | PO Value | Payment | Variance | Match Result |
|---|---|---|---|---|---|---|---|
| INV-001 | Vendor A | PO-88 | $500.00 | $500.00 | $500.00 | $0.00 | Full Match |
| INV-002 | Unknown | PO-89 | $1,200.00 | $1,150.00 | Not Found | ($50.00) | Price Variance |
| INV-003 | Vendor B | Not Found | $300.00 | Not Found | $300.00 | $0.00 | No PO Found |
4. Discrepancy / Exception Log
| Exception ID | Type | Records Involved | Observed Difference | Evidence | Review Needed |
|---|---|---|---|---|---|
| EXC-01 | Amount Mismatch | INV-002, PO-89 | $50.00 | Invoice is higher than PO | Verify shipping/tax |
| EXC-02 | Missing PO | INV-003 | N/A | No PO reference provided | Locate PO or check auth |
| EXC-03 | Missing Payment | INV-002 | $1,200.00 | No payment found for INV-002 | Check pending wires |
5. Action Checklist
- Review INV-002: Confirm if the $50 variance on PO-89 is due to unquoted freight or a price increase.
- PO Search: Locate the purchase order associated with INV-003 to validate the $300 charge.
- Payment Verification: Confirm if the $300 payment to Vendor B was intended for INV-003, as no PO was linked.
Next steps
- Upload the specific vendor names for INV-002 to refine the matching logic.
- Provide shipping and tax rules to see if the $50 variance falls within acceptable tolerances.
- Check the bank statement date for the $300 payment to confirm timing against INV-003.
ai-invoice-reconciliation-assistant.pdf
PDF · document
Example file from a real run - the skill writes it into your workspace.
Connects securely to your tools. The creator never sees your data.
What you get
About this skill
Manual reconciliation between invoices, purchase orders, and bank statements is slow and prone to oversight. This skill automates the cross-referencing process, flagging variances in quantities, unit prices, and tax calculations while maintaining a strict audit trail.
What it does
- Multi-source matching compares invoice IDs, PO references, and payment remittance data to identify discrepancies.
- Variance detection calculates differences in totals, subtotals, tax, and shipping at the line-item level.
- Exception classification labels issues as missing records, price mismatches, or potential duplicates with specific evidence.
- Data normalization handles inconsistent formatting in vendor names, dates, and currency identifiers without altering original source values.
- Follow-up generation creates a prioritized checklist of review actions for finance teams to resolve outstanding items.
How it works
- Supply invoice data, PO records, and payment files via CSV, table, or raw text.
- Define matching rules such as specific tolerances for rounding or tax variations.
- Review the generated reconciliation table that maps each transaction across all three data sources.
- Execute the suggested follow-up actions for items flagged in the exception log.
Frameworks & tools
Built for integration with ERP exports, bank CSVs, and procurement logs. Compatible with standard bookkeeping formats and currency conventions.
Why this beats prompting it yourself
Generic prompts often "hallucinate" missing transactions or fail to account for tax and shipping nuances. This skill enforces strict safeguards that prevent the AI from marking items as "paid" or "fraudulent" without definitive evidence, ensuring audit-level accuracy.
Use cases
- Auditing monthly vendor statements against internal procurement records.
- Identifying double-billing or duplicate payments across multiple datasets.
- Reconciling partial payments and deposits against open invoices.
- Preparing for year-end audits by logging all unmatched POs and invoices.
Known limitations
Does not initiate bank transfers or modify accounting software records directly. Requires manual entry or file uploads of source data.
How to install
Works the same in every agent - Claude, Cursor, Codex, Copilot and 20+ more.
- 1
Download the ZIP
Free skills download straight away. Paid skills unlock right after purchase.
- 2
Unzip into your skills folder
Every agent reads skills from one folder on your machine. Drop the unzipped folder in there.
- 3
Ask your agent to use it
Restart the agent if it was already running. It picks the skill up automatically - no config needed.
Skills folder by agent
Click the path to copy it. Create the folder if it does not exist yet.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill passes our trust checks below.
Security scanned
Passed our 8-point scan before listing
Fresh listing
Recently published to Agensi
30-day refund
Not a fit? Get your money back
Trust & safety
Security scanned
Verified clean today
- Passed all security checks, Safe to install