Task recipe · Beginner · 15 min

Bank reconciliation with AI

এআই দিয়ে ব্যাংক রিকনসিলিয়েশন

Match a cash book against a bank statement, list unmatched items with likely reasons, and draft a bank reconciliation statement you can check line by line.

Works well with ChatGPTClaude

The problem

At month-end the bank balance in your cash book does not agree with the bank statement. Matching dozens of entries by eye is slow, and it is easy to miss one.

What you need

  • Cash book (bank column) entries for the month: date, reference, amount
  • Bank statement entries for the same month
  • Both closing balances
  • Customer and supplier names replaced with codes

Steps

  1. Export both lists from your accounting software and online banking (CSV or Excel).
  2. Replace names with codes and delete columns that are not needed.
  3. Copy the prompt below and paste List A and List B where shown.
  4. Read the unmatched items table first. Every item should make sense.
  5. Rebuild the reconciliation in Excel and confirm it agrees to the bank balance.

The prompt

Copy it, then replace the example figures and [brackets] with your own.

Prompt
You are an accounts assistant helping me prepare a bank reconciliation statement (BRS).

Below are two lists for March 2026. All names are replaced with codes.
List A = our cash book (bank column). List B = the bank statement.

Tasks:
1. Match items that appear in both lists (same amount, date within 5 days, similar reference).
2. List every unmatched item in a table: Source (A or B) | Date | Reference | Amount | Likely reason (e.g. unpresented cheque, deposit in transit, bank charge, direct credit, error).
3. Prepare a BRS starting from the balance as per cash book and ending at the balance as per bank statement.
4. Show your arithmetic so I can check it. Do not invent any item that is not in the lists.

Cash book closing balance: Tk 245,600
Bank statement closing balance: Tk 262,350

List A (cash book):
[paste here]

List B (bank statement):
[paste here]

What the AI should give you

Sample AI reply
Unmatched items
Source | Date   | Reference        | Amount  | Likely reason
A      | 28 Mar | Chq 1043         | 18,500  | Unpresented cheque
A      | 30 Mar | Chq 1047         | 10,000  | Unpresented cheque
A      | 31 Mar | Deposit DS-219   | 15,000  | Deposit in transit
B      | 26 Mar | BEFTN Cust C-07  |  4,000  | Direct credit not in cash book
B      | 31 Mar | Charges + SMS    |    750  | Bank charges not in cash book

Bank reconciliation statement, 31 March 2026          Tk
Balance as per cash book                         245,600
Add: unpresented cheques (18,500 + 10,000)        28,500
Less: deposit in transit                         (15,000)
Add: direct credit not yet recorded                4,000
Less: bank charges not yet recorded                 (750)
Balance as per bank statement                    262,350

How to check it

Common mistakes

Learn more

More recipes

All recipes

Sample figures are for learning only. Check every AI answer before you rely on it.