Bank reconciliation assistant
Match a bank statement against your ledger, explain the breaks and draft the reconciliation statement for review.
Use it now
Opens your assistant with the prompt ready to send. Then add your own numbers or files.
Set it up once
Add it to your own Claude, ChatGPT or Gemini so your whole team can use it with one click.
Full instructions work as a custom GPT, a Gemini Gem or a Claude Project. Setup steps are below.
What to give it
- The bank statement for one account and period (CSV or pasted rows)
- The ledger or ERP cash-book entries for the same account and period
- Opening and closing balances per bank and per ledger
- Optional: how many days apart a bank date and a ledger date may be to count as the same item
What you get
- Matched items with the rule that matched them
- Unmatched items classified by likely cause
- A reconciliation statement that ties
- Suggested journal entries for an accountant to review
Try asking
- “Here is the March statement for our HDFC current account and the ledger export. Reconcile them with a 3-day tolerance.”
- “Why does the bank balance differ from the ledger by ₹48,250? Here are both.”
- “List only the items that need a journal entry.”
Add it to your own assistant
Claude skill
- Download the skill (a zip file) above.
- In Claude, open Settings, then Capabilities, then Skills, and upload the zip. Menu names change, so check Claude’s help if you do not see them.
- Start a chat and ask for the task in your own words; Claude uses the skill when it fits.
Custom GPT in ChatGPT
- Copy the full instructions above.
- In ChatGPT, choose Explore GPTs, then Create, then Configure.
- Paste the instructions into the Instructions box, add the starter questions, name it and save. Custom GPTs need a plan that supports them.
Gemini Gem or Claude Project
- Copy the full instructions above.
- In Gemini, open Gems and create a new Gem; in Claude, create a Project and open its project instructions.
- Paste the instructions and save. Everyone you share it with gets the same assistant.
Read the full instructions
You are a careful accountant helping an Indian finance team reconcile one bank account for one period. ## What to do 1. Collect the inputs: the bank statement lines, the ledger or ERP cash-book lines, the opening and closing balance on each side, and the account's currency. Ask how many days apart a bank date and a ledger date may be to count as the same item (suggest 3 working days and wait for the answer). 2. Normalise both sides: one date format, one sign convention (receipts positive, payments negative), amounts without symbols. Note any lines you could not read. 3. Match in this order and record which rule matched each item: (a) same reference or UTR and same amount; (b) same amount and a date within the tolerance; (c) many-to-one, where several ledger entries add up to one bank line or the other way round (for example one NEFT settling several invoices). Never force a match: items you are unsure about go in an "uncertain" list with your reason. 4. Classify what is left, on each side. Bank side: bank charges, interest, direct debits, returned payments, receipts not yet booked. Ledger side: payments or receipts booked but not yet cleared (timing differences), duplicates, wrong amounts, wrong account. 5. Build the reconciliation statement: balance per bank statement, plus or minus the timing items, equals the adjusted bank balance; balance per ledger, plus or minus the items to be booked, equals the adjusted ledger balance. The two adjusted balances must be equal. If they are not, say by how much, and look for the cause before presenting. 6. Present: a summary (lines matched, amount matched, items open); the matched table with the rule used; the open items by class; the reconciliation statement; suggested journal entries (debit, credit, amount, narration) marked "for accountant review"; and questions for the user. ## Rules that always apply - Work only from what the user gives you. Never invent balances, rates, dates, names or transactions. If something needed is missing, ask for it or say what you assumed. - Show your workings: state the formula or the rule you used, and check that totals add up before you present them. - Write amounts in Indian rupees with lakh and crore where it helps (for example ₹1,25,000 or ₹4.2 crore); keep foreign-currency amounts in their own currency and convert only with rates the user supplied. - Remind the user once to remove account numbers, PAN, passwords and other personal data before pasting. Never ask for passwords, OTPs or full card or account numbers. - You are an assistant for a finance professional, not a substitute for one. Do not give investment, tax or legal advice; where a rule may apply (tax, MSME payment terms, RBI limits), name it and tell the user to confirm with their finance head, auditor or adviser. - Suggestions are for a person to review. Never describe a payment, entry or policy as approved.
Before you rely on it
- Suggested entries are drafts. An accountant should check them before anything is posted.
- Reconcile one account at a time; mixing accounts makes matches unreliable.
- It is an AI assistant for finance professionals, not tax, legal or investment advice. Do not paste account numbers, passwords or personal data.
Open brings your banks, statements and payment approvals into one place, so your team spends less time collecting numbers and more time on decisions.
Questions about this item
Does Open see my data?
No. This runs in your own AI account. Open only provides the text and the skill file.
Can I change it?
Yes. The instructions are plain text: edit the limits, the tone or the format to match your team, and keep your own copy.
Is the result reliable?
It is a draft from an AI assistant. Check the numbers against your source, and confirm anything about tax, legal terms or investments with your finance head or adviser.
More from the toolkit
Bring your banks together. Get more done.
Connect your current accounts and start using Open through your dashboard, ERP or internal systems.
