Skip to main content

Command menu

Jump to a page or search the catalog

AI Tools & Scripts

Bank Reconciliation Pack: Matched, Unmatched and an Accountant Handoff from Your CSVs

For freelancers and small businesses: a script matches your bank or processor CSV to your invoice and expense CSVs by fixed rules, and your agent drafts the summary, questions and an accountant handoff, for you to review. مطابقة كشف البنك مع سجلاتك.

$9.00

What you get: 1 file · 81.8 KB · ZIP

See purchase options

Product description

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.csv and unmatched-records.csv: what is left on each side.
  • reconciliation-summary.md and .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 والأرقام الهندية. جُرّبت على ملفات تجريبية فقط وليس على تصدير بنك حقيقي.

Questions / أسئلة

Which files does it need? / أي ملفات يحتاج؟

A CSV export from your bank or payment processor, and the CSVs you keep: invoices, sales or expenses. PDF statements must be exported as CSV first. ملف CSV من البنك وملفات سجلاتك.

My bank's export is messy. / ملف البنك غير مرتب.

The script handles several encodings and separators, heading lines, day-first and month-first dates, decimal commas, debit and credit columns and Arabic-Indic digits. If a date cannot be settled from the file, it asks you. يتعامل مع صيغ كثيرة ويسألك عند الالتباس.

Does it decide doubtful matches for me? / هل يقرر عني؟

No. Ties and near matches go to possible-matches.csv with a short question each, and stay open until you answer. لا، تبقى معلّقة حتى تجيب.

Is this accounting advice? / هل هذه استشارة محاسبية؟

No. It matches rows and prepares a handoff; it gives no tax, accounting or legal judgment and does not categorise expenses. لا، هي مطابقة وتجهيز فقط.

Does my data leave my computer? / هل تخرج بياناتي من جهازي؟

The scripts run locally and make no network connection. Your agent reads the files as it does any file in your project. السكربتات تعمل محليًا بلا اتصال.

Does it work in Arabic? / هل تعمل بالعربي؟

Yes. It reads Windows-1256 files and Arabic month names, and can write the summary, questions and handoff in Arabic. It was tried on one test case. نعم، تقرأ الملفات العربية وتكتب بالعربية.

What you get

1 file · 81.8 KB

  • bank-reconciliation-pack-1.0.0.zipZIP · 81.8 KB
LicenseCommercial use allowed
Package checkPassed

Getly opened the uploaded files and found nothing that would stop them opening. It is not a virus scan or a quality rating.

PublishedNov 14, 2026
File size81.8 KB
File formatZIP
Versionv1.0

Tags

bank reconciliationbookkeepingaccountingcsvinvoicessmall businessfreelancerarabicai agent skill
R
RR HH

Frequently asked questions

Do I get access instantly?

Yes. This is a digital product - you can download it right after checkout, straight from your library.

Can I use it for commercial projects?

Yes. Commercial use is allowed: use it in your own business and in things you sell. You may not resell or redistribute the file itself.

What's your refund policy?

You can request a refund within 30 days. If something isn't right, request it from your order and the Getly team reviews it.

What file formats and sizes will I get?

You'll download 1 file - ZIP - 81.8 KB in total.

Do I get free updates?

Yes - when the seller ships a new version, you can re-download the latest files from your library at no extra cost. Check the changelog for recent updates.

Price

$9.00