Skip to content
SkillReady to runFinancePersonal Finance

Bank CSV Reconciliation

Written in-house · editorially graded

Every SkillsBank offering is written in-house — never scraped or crowd-sourced — and graded against a fixed editorial rubric in a separate grading step.

Dry-run test passed · Jun 15, 2026

Trigger check passed

Editorially graded · Jun 15, 2026

Ingests a bank-exported CSV and an internal expense ledger (CSV or Google Sheet export), fuzzy-matches transactions by vendor name, date, and amount, and returns a formatted three-sheet XLSX workbook with a Status column (Matched / Possible Match / Unmatched), a Summary sheet, and an Unmatched Items sheet ready for manual review. Use when you have downloaded a bank statement CSV and want to reconcile it against your internal expense records without manual row-by-row comparison.

What you get

An installable SKILL.md file for your AI assistant. Produces an Excel workbook (.xlsx).

Works in
Claude Code · Cursor
Native — drops into .claude/skills/
Copilot · Codex · Gemini CLI
Native — reads .agents/skills/
claude.ai — web & desktop
Upload the .zip in Customize → Skills
ChatGPT
Via a Project — paste into its instructions

See it in action

A real input → output sample

Sample input
User attaches two CSV files, bank.csv and ledger.csv, with a request to reconcile the bank statement against the internal ledger. bank.csv contains transactions with non-standard headers 'Trans Date' and 'Payee', while ledger.csv contains expense entries with standard headers. The user omits account name and period, trusting the tool to figure it out.
Sample output
Sample Excel output produced by the Bank CSV Reconciliation skill
Produced by an AI assistant following this skill on the sample input above.
View the full output as text
Example Output
The AI generates a Bank_Reconciliation_Report.xlsx file with three sheets: Reconciliation Detail, Summary, and Unmatched Items. The report includes matched and unmatched transactions, possible matches, and a summary of the reconciliation process, along with key statistics and warnings about period coverage.

Related