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.
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
- Export both lists from your accounting software and online banking (CSV or Excel).
- Replace names with codes and delete columns that are not needed.
- Copy the prompt below and paste List A and List B where shown.
- Read the unmatched items table first. Every item should make sense.
- 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.
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
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
- The statement must end exactly at the bank statement balance. Recalculate it in Excel: 245,600 + 28,500 − 15,000 + 4,000 − 750 = 262,350.
- Tick every unmatched item back to List A or List B. Delete anything the AI invented.
- Unpresented cheques and deposits in transit should clear in next month’s statement. Check that they do.
- Items only on the bank statement (direct credits, charges) must be entered in the cash book. Exam answers usually show an adjusted cash book first, then the BRS.
Common mistakes
- Matching on amount only: two different Tk 10,000 entries can be paired wrongly. Ask it to use dates and references as well.
- Signs reversed: check whether each item should be added or deducted given the starting balance.
Learn more
More recipes
IFRS 16 lease liability schedule
আইএফআরএস ১৬ লিজ দায়ের সূচি
Calculate the initial lease liability and right-of-use asset, build the amortisation table and journal entries, then prove the numbers with Excel’s PV function.
ClaudeChatGPTCopilot in Excel
Salary income tax computation (Bangladesh)
বেতনভোগীর আয়কর হিসাব
Lay out a salaried person’s Bangladesh income tax computation step by step, using the rates and limits you paste from the current Finance Act, never the AI’s memory.
ChatGPTClaudeGoogle Gemini
Budget vs actual variance commentary
বাজেট বনাম প্রকৃত: ভ্যারিয়েন্স মন্তব্য
Turn a budget-versus-actual table into clear management commentary that flags material variances and uses only the reasons you supply, never invented ones.
ChatGPTClaudeCopilot in Excel
Sample figures are for learning only. Check every AI answer before you rely on it.