How to use ChatGPT for bank reconciliation

Step by step: bank reconciliation with ChatGPT

1. 1Export the bank statement for the period as CSV, plus the statement's opening and closing balances.
2. 2Export the cash account's general ledger detail for the same dates, also as CSV.
3. 3Remove account numbers, card numbers, names and anything else that identifies a person.
4. 4Upload both files and paste the prompt below, filling in the bracketed details.
5. 5Check every unmatched item and suggested entry against bank activity and source documents.
6. 6Post approved adjustments in your accounting software, confirm the adjusted balances agree, and file the reconciliation for review.

Copyable prompt: bank reconciliation with ChatGPT

Upload both CSV files first, then paste this prompt and replace the bracketed details.

You are helping me reconcile a business bank account for [month and year].

I have uploaded two files:
1. bank.csv: the bank statement lines (date, description, amount).
2. ledger.csv: the cash account ledger detail from [QuickBooks Online / Xero / other] for the same dates.

Statement opening balance: [amount]. Statement closing balance: [amount].
Ledger cash balance at period end: [amount].

Please:
1. Match bank lines to ledger lines by amount and date (allow [3] days of difference). Show the matching rule you used.
2. List bank lines with no ledger match, and ledger lines with no bank match, in two separate tables.
3. Flag possible duplicates and amounts that match but have different signs.
4. Label each unmatched item as a likely timing difference (such as an uncleared check or deposit in transit) or a likely missing or wrong entry, and explain why.
5. Show a reconciliation summary: statement closing balance, plus deposits in transit, minus outstanding checks, equals adjusted bank balance; ledger balance, plus or minus corrections, equals adjusted book balance.
6. Do not guess. If something is unclear, list it as a question for me.

Return tables I can download as CSV. Do not post or change anything; this is for my review.

Worked example: one month, two reconciling items

The numbers here are illustrative. Say the statement closes at $8,420.15 and the ledger shows $9,000.15 in cash. ChatGPT comes back with two unmatched items:

1. A $500.00 deposit entered in the books on the last day of the month that the bank has not cleared yet. That is a timing difference: a deposit in transit.
2. An $80.00 monthly bank fee on the statement that was never entered in the books.

The two adjusted balances agree, so you post the $80.00 fee in your accounting software and file the reconciliation. The deposit needs no entry; it should clear on next month's statement. If the balances did not agree, the gap between them is the amount you still have to find.

What is a bank reconciliation?

Xero defines bank reconciliation as matching the transactions in your accounting records with the transactions on your bank statement, and calls any transaction that appears in one record but not the other a reconciling item^[1]. The point, as AccountingCoach puts it, is to prove the Cash account is complete and accurate^[2]. Xero notes that monthly is the standard for most small businesses^[1].

What files does ChatGPT need for a bank reconciliation?

Two exports for the same period: the bank statement and the cash account ledger detail. ChatGPT supports uploads including CSV, XLSX and PDF^[3]. CSV works best, because OpenAI says ChatGPT may not reliably extract exact values from scanned files or image-based tables^[4].

Size limits apply. OpenAI's file uploads FAQ says CSV and spreadsheet files cannot exceed approximately 50MB, depending on row size^[5]. If a file is very large, OpenAI suggests splitting it or focusing prompts on specific sections^[3], so reconcile one month at a time.

How do you check ChatGPT's reconciliation?

Start with the totals. The statement's opening balance plus deposits minus withdrawals should equal its closing balance, and the adjusted bank balance should equal the adjusted book balance. Then trace each reconciling item to the bank activity or a source document. The Journal of Accountancy, which names reconciliation issues as a task ChatGPT can help with, also warns that it can be incorrect at times^[6].

Frequently asked questions

Can ChatGPT read a PDF bank statement?

It can accept PDFs^[3], but OpenAI says it may not reliably extract exact values from scanned or image-based tables^[4]. Use a CSV export where possible, and tie out the totals if you start from a PDF.

Can ChatGPT post the adjusting entries for me?

No. ChatGPT works on the files you give it. Review its suggested entries and post the ones you approve in your accounting software yourself.

How often should I reconcile my bank account?

Xero says monthly is the standard for most small businesses^[1]. Busy accounts may need weekly reconciliations.

Is it safe to upload bank statements to ChatGPT?

Remove account numbers and personal details first, and check your plan's data settings. OpenAI does not train on ChatGPT Business or Enterprise content by default^[7]. See our guide on uploading bank statements for more.

Sources

1. 1.Xero glossary: Bank reconciliation
2. 2.AccountingCoach: Bank reconciliation explanation
3. 3.OpenAI Academy: Working with files in ChatGPT
4. 4.OpenAI Help Center: Data analysis with ChatGPT (archived copy, Oct 12, 2026)
5. 5.OpenAI Help Center: File uploads FAQ (archived copy, Sep 18, 2026)
6. 6.Journal of Accountancy: 3 ways to use ChatGPT-4o with Excel (Jul 2025)
7. 7.OpenAI Academy: Data governance and compliance

Sources were checked when this page was last updated. Archived copies are cited where the original page could not be reached from our checker. Features and settings change, so confirm details with each vendor.