Stepthrough
Start free

Bank Reconciliation with ChatGPT in 5 Steps

Step-by-step guide7 slidesChatGPT

By Robert Breen · Published · From the free lesson Month-End Bank Reconciliation with ChatGPT: 20 Minutes, Not 3 Hours

A step-ladder guide: upload a bank CSV and a ledger CSV to ChatGPT, list the exceptions, and check the math yourself, in 5 steps.

  1. Reconcile the month with ChatGPT. Two CSV files in, four exceptions out. Harbor Lane Studio is a made-up studio. Step 1: Upload both files. Step 2: Give it the balances. Step 3: Read the exceptions. Step 4: Build the summary. Step 5: Check the math yourself. By Robert Breen. Stepthrough, free at learn.ynteractive.com.
    Slide 1 of 7
  2. Reconcile the month with ChatGPT. Step 1: Upload both files. The bank statement and the ledger export, 40 rows each. Click the plus button, choose Add photos & files, select both. By Robert Breen. Stepthrough, free at learn.ynteractive.com.
    Slide 2 of 7
  3. Reconcile the month with ChatGPT. Step 2: Give it the balances. Opening and ending balances let it prove its own list. Match by amount and date within five days. Do not guess: say Needs review. By Robert Breen. Stepthrough, free at learn.ynteractive.com.
    Slide 3 of 7
  4. Reconcile the month with ChatGPT. Step 3: Read the exceptions. It matched 38 of 40 rows on each side and listed four. The fourth is check 1027 for $850.00, a timing difference. By Robert Breen. Stepthrough, free at learn.ynteractive.com.
    Slide 4 of 7
  5. Reconcile the month with ChatGPT. Step 4: Build the summary. One table in the usual order, with a note on each exception. Copy it into the month-end file with the copy icon. By Robert Breen. Stepthrough, free at learn.ynteractive.com.
    Slide 5 of 7
  6. Reconcile the month with ChatGPT. Step 5: Check the math yourself. AI can add wrong. Both sides should land on $54,355.65. Remove account numbers before you upload, and follow your firm's AI policy. By Robert Breen. Stepthrough, free at learn.ynteractive.com.
    Slide 6 of 7
  7. Practice it free in a copy of ChatGPT. Month-End Bank Reconciliation with ChatGPT. 19 steps, about 12 minutes. By Robert Breen. Stepthrough, free at learn.ynteractive.com.
    Slide 7 of 7

Swipe or scroll sideways for all 7 slides. The whole guide is written out below.

The guide in text

Two CSV files in, four exceptions out. Harbor Lane Studio is a made-up studio.

Step by step

  1. Upload both files

    The bank statement and the ledger export, 40 rows each. Click the plus button, choose Add photos & files, select both.

  2. Give it the balances

    Opening and ending balances let it prove its own list. Match by amount and date within five days. Do not guess: say Needs review.

  3. Read the exceptions

    It matched 38 of 40 rows on each side and listed four. The fourth is check 1027 for $850.00, a timing difference.

  4. Build the summary

    One table in the usual order, with a note on each exception. Copy it into the month-end file with the copy icon.

  5. Check the math yourself

    AI can add wrong. Both sides should land on $54,355.65. Remove account numbers before you upload, and follow your firm's AI policy.

Businesses and people in the examples are made up (Harbor Lane Studio is a made-up business). The steps, screens and wording come from the free lesson and the Stepthrough glossary and prompt library.

Do it yourself, free

Month-End Bank Reconciliation with ChatGPT: 20 Minutes, Not 3 Hours. Upload the bank statement and the books, let ChatGPT match every row and list the exceptions, then check the answer and paste a reconciliation summary into the month-end file. You do every step yourself in a practice copy of ChatGPT, it checks your work as you go, and “Do it for me” finishes any step you get stuck on. Free, and nothing touches your real accounts.

Start the free lesson

Or read the full step-by-step guide

Plain-English definitions, each with an example from a free lesson.

Bank reconciliation

The full AI glossary

From the blog

Team AI Policy: What Staff Can Paste Into ChatGPT

A one-page team AI policy for a small firm: which account to use, which settings to switch off, and what staff must never paste into ChatGPT.

Oct 12, 2026 5 min read

AI Agent vs Automation vs Chatbot: One Job, Three Ways

A visual guide to the difference between a chatbot, an automation and an AI agent, shown by chasing six unpaid invoices three ways in one free lesson.

Step-by-step guide 7 slides

Build a web form with an AI backend, no code

Most website forms just land in an inbox and wait. This one does the work. You describe the form in Lovable, and it builds it.

Step-by-step guide 7 slides

ChatGPT vs Claude vs Gemini vs Copilot: One Task, Compared

A visual guide to the same office task in ChatGPT, Claude, Gemini and Copilot: what each one added, what to check, and how to pick the one for work.

Step-by-step guide 8 slides

All visual guides · All free tutorials