- Home
- Skills
- Finance & Accounting
- Bank Reconciliation Pack: Match Your Bank CSV
More screenshots
Works with the AI Agents you already use
Bank Reconciliation Pack: Match Your Bank CSV
The agent drafts a reconciliation folder, for you to review and hand to your accountant.
$9
Bank Reconciliation Pack: Match Your Bank CSV
Example session with this skill installed
Reconcile March: northgate-statement-march.csv against invoices-2026.csv and expenses-march.csv. Stripe takes 1.5% + 20p before paying out. I need something I can send my accountant.
- Read your context and instructions
- Compiled the bank reconciliation
Where every row ended up
| Bucket | Bank rows | Bank total | Record rows | Records total |
|---|---|---|---|---|
| Matched | 33 | 9,615.56 | 35 | 9,641.86 |
| Possible (needs a decision) | 5 | 1,332.00 | 6 | 1,901.80 |
| Unmatched | 22 | -1,960.64 | 4 | 898.51 |
| All rows | 60 | 8,986.92 | 45 | 12,442.17 |
Possible matches to confirm
- Bank line 26, 20 Mar 2026, 900.00 "HOLLIS & WREN LTD INV-2031": the transfer names INV-2031, but that invoice is for 1,500.00. Is this a part payment with 600.00 still to come, or something else?
Connects securely to your tools. The creator never sees your data.
About this skill
English
For freelancers, shop owners and small businesses who have to match the month's bank statement to their own records before the accountant asks.
Give your agent the CSV export from your bank or payment processor and the CSVs you keep yourself (invoices, sales, expenses). The agent drafts a reconciliation folder, for you to review and hand to your accountant.
A bundled script matches every bank line to your records by fixed, stated rules. Each line ends in exactly one place: matched with the reason, possible and waiting for your decision, or unmatched.
What matched means. A match is a rule-based pairing for you to review, not proof that a transaction is correct or that your books are reconciled.
Your data. The scripts run on your computer, and your agent reads the CSV files you give it. What your agent sends to its model provider depends on the agent you use, so check its data settings. Remove account numbers and personal details the matching does not need before you start.
What the agent writes each run
matched.csv: pairs and groups with the rule, the confidence, any fee and any difference.possible-matches.csv: candidates that need your yes or no, with the reason.unmatched-bank.csvandunmatched-records.csv: what is left on each side.reconciliation-summary.mdand.html: totals, a balance check, the largest open items and repeated rows. The HTML is one printable file.questions-for-owner.md: short questions, one per open item or group.accountant-handoff.md: what was reconciled, how the files were read, the settings, the results and what is open.
Messy exports are expected
The script reads UTF-8, UTF-16, Windows-1256 and Windows-1252 files; comma, semicolon, tab or pipe separators; heading lines above the column row; day-first and month-first dates; month names in English and Arabic; decimal comma or point; negatives in parentheses; CR/DR marks; separate debit and credit columns; and Arabic-Indic digits.
Rules, not guesses
Matching runs in a fixed order: a record's reference in the bank text, same amount and date, same amount inside a date window, a processor fee you state, one deposit covering several records, and several part payments for one record. Ties are left open for you. A check command confirms that every row is in exactly one bucket and that the totals add up. Your answers go into a decisions file and the run is repeated.
Honest about its limits
It gives no tax, accounting or legal judgment and does not categorise expenses. One currency per run. CSV only: a PDF or image statement must be exported as CSV first. Hijri dates are out of scope. A fee is applied only when you state it, so fees that vary by card type show as open differences. Sums of several records can coincide by chance when one file mixes unrelated kinds of rows, so read the grouped matches. A possible match stays possible until you answer. Only invented exports were used in testing; no real bank's export was tried. The HTML summary was checked as text, not viewed in a browser. Written and run on Python 3.12.
Arabic
On request the summary, the questions and the handoff are written in Arabic.
In the download: SKILL.md, standard-library Python scripts, references (formats and mapping, the matching method, questions and handoff, Arabic notes), templates, and a worked example you can read before you buy: one month of a design studio, 60 bank lines against 45 records, with 33 bank lines matched, 5 possible and 22 unmatched.
Tried on two cases (an English design studio with processor payouts in GBP; an Arabic grocery in IQD with a Windows-1256 bank statement). The scripts have 62 unit tests.
بالعربي
لأصحاب المحلات والمستقلين والشركات الصغيرة الذين عليهم مطابقة كشف البنك الشهري مع سجلاتهم قبل أن يطلبها المحاسب.
أعطِ وكيلك ملف CSV من البنك أو من شركة الدفع، وملفات سجلاتك (فواتير، مبيعات، مصاريف). يجهّز لك مجلد مطابقة لتراجعه وتسلّمه للمحاسب.
ماذا يكتب الوكيل
- ملف
matched.csv: ما تمت مطابقته مع القاعدة ودرجة الثقة. - ملف
possible-matches.csv: مطابقات محتملة تنتظر قرارك. - ملفا
unmatched-bank.csvوunmatched-records.csv: ما بقي بلا مطابقة في كل جهة. - ملف
reconciliation-summary: المجاميع وفحص الرصيد. - ملف
questions-for-owner.mdوملفaccountant-handoff.md: أسئلة قصيرة لك ومذكرة للمحاسب.
حدودها
المطابقة اقتراح مبني على قواعد يحتاج مراجعتك، وليست إثباتًا لصحة الحركة. احذف من الملفات أرقام الحسابات والبيانات الشخصية غير اللازمة قبل البدء. لا تعطي رأيًا محاسبيًا أو ضريبيًا ولا تصنّف المصاريف. عملة واحدة في كل تشغيل، وملفات CSV فقط، والتواريخ الهجرية خارج النطاق. تقرأ الملفات العربية بترميز Windows-1256 والأرقام الهندية. جُرّبت على ملفات تجريبية فقط وليس على تصدير بنك حقيقي.
It gives no tax, accounting or legal judgment and does not categorise expenses. One currency per run. CSV only: PDF or image statements must be exported as CSV first. Hijri dates are out of scope. A fee is applied only when you state it, so fees that vary by card type show as open differences. Sums of several records can coincide by chance when one file mixes unrelated kinds of rows. A possible match stays possible until you answer. Only invented exports were used in testing; no real bank's export was tried. The HTML summary was checked as text, not viewed in a browser. Written and run on Python 3.12. Tried on two cases. لا تعطي رأيًا محاسبيًا أو ضريبيًا.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before any payment.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Money-back guarantee
Doesn't do what its page promises? You get your money back.
Trust & safety
Security scan
Security scan passed 2 days ago
Requires
Permissions
Reads the CSV files you name (bank or processor export, invoices, sales, expenses); your source files are only read. Writes matched.csv, possible-matches.csv, the two unmatched files, normalized copies, the summary (Markdown and HTML), questions-for-owner.md and accountant-handoff.md into the output folder you name (reconciliation by default). Runs its bundled Python scripts locally; standard library only, no network calls. يقرأ ملفاتك ويكتب النتائج داخل مجلد تحدده أنت فقط.