Invoice & Expense Reconciliation Assistant
Compares a list of invoices against a list of payments/expenses and flags mismatches, missing entries, and duplicates for manual review.
Invoice & Expense Reconciliation Assistant is a free AI skill for finance & admin support. Compares a list of invoices against a list of payments/expenses and flags mismatches, missing entries, and duplicates for manual review. It works with Claude, ChatGPT, Cursor and is ready to use out of the box.
About this skill
Invoice & Expense Reconciliation Assistant takes two lists — invoices issued/received and payments recorded — and cross-references them to flag discrepancies: invoices with no matching payment, payments with no matching invoice, amount mismatches, and likely duplicate entries. It produces a clear reconciliation report ranking issues by dollar impact so a bookkeeper or founder can resolve the highest-impact discrepancies first. Built for small business owners and freelance bookkeepers doing manual reconciliation without full accounting software automation.
What it does
Given two lists — invoices and payments/expenses — the skill outputs a matched/unmatched breakdown, flags amount discrepancies and likely duplicates, and ranks all issues by dollar impact with suggested next actions.
What is included
- Matched vs unmatched invoice/payment breakdown
- Amount discrepancy flagging
- Likely duplicate detection
- Dollar-impact-ranked issue list
- Suggested next action per discrepancy
How to use it
1. Download the SKILL.md file 2. Upload it to a new Claude conversation 3. Paste your invoice list and your payment/expense list 4. Receive a full reconciliation report
Examples
INVOICES: INV-101 $500 ClientA, INV-102 $1200 ClientB, INV-103 $300 ClientC PAYMENTS: $500 ClientA 6/1, $1200 ClientB 6/3, $300 ClientC 6/5, $300 ClientC 6/5 (again)
RECONCILIATION REPORT MATCHED: INV-101 ($500, ClientA) ↔ Payment $500 6/1 ✓ INV-102 ($1200, ClientB) ↔ Payment $1200 6/3 ✓ INV-103 ($300, ClientC) ↔ Payment $300 6/5 ✓ FLAGGED ISSUES (ranked by dollar impact): 1. Likely duplicate payment: ClientC has two $300 payments on 6/5 against a single $300 invoice (INV-103). Dollar impact: $300. Action: Verify with ClientC whether this was an accidental double payment or a separate unlisted invoice; refund or apply as credit. SUMMARY: 3 of 3 invoices matched. 1 duplicate payment flagged requiring follow-up.
FAQ
What is this skill for?
How do I install it?
Does it connect to QuickBooks or other accounting software?
How does it rank issues?
How is this different from just eyeballing two spreadsheets?
Is this a replacement for a bookkeeper or accountant?
Related Skills
Monthly Expense Report Builder
Turns a raw list of expenses into a categorized, summarized monthly expense report with totals and flagged anomalies.
Creator Income and Expense Record Organizer
Organize creator income and expenses with categories, evidence, platform payouts, sponsorships, affiliate revenue, fees, subscriptions, and review routines.
Subscription Invoice Reconciliation Analyst
Reconcile subscription invoices against contracts, users, usage, renewals, discounts, taxes, credits, and accounting records while flagging unsupported charges.
Related Prompts
Expense Categorizer & Admin Summary
Turn a messy list of business expenses into a clean category table, totals, anomalies, missing-receipt list, and admin action summary.
Monthly Bookkeeping Close Checklist
Create a month-end bookkeeping checklist with owners, evidence, dependencies, exceptions, and sign-off gates tailored to your records and tools.
Invoice Draft & Payment Terms Builder
Create a complete invoice draft from supplied business details, line items, dates, taxes, discounts, and payment terms without inventing missing data.
Related Articles
How to Use a Budget Tracker Skill in Claude Without Sharing Bank Data
Learn how to use a budget tracker skill in Claude with redacted expense notes instead of sensitive bank data.