# Match your bank statement to your books and see every gap

> Copilot finds the $48 bank fee you never recorded and the client payment you logged twice, in one pass.

Put your bank export and your bookkeeping export in one Excel workbook and ask Copilot to reconcile them. It lists what matches, what's missing and what's off, ready for you to fix.

- Page: https://thesolocreators.com/prompts/excel-copilot-match-bank-to-books/
- Category: Put your business on autopilot
- Made for: Small business owners, Consultants, Coaches
- Works in: Copilot, ChatGPT, Claude
- Time: About 10 minutes a month
- Effort: A few steps
- Note: Copilot in Excel's new accounting skills are in Frontier preview. The prompt also works in ChatGPT or Claude with both files attached.
- Published: 2026-10-30

## Can AI reconcile my bank statement with my bookkeeping records?

Yes. Export both lists, put them in one workbook and ask AI to match them and list every gap. As of October 2026, Copilot in Excel has new accounting skills for reconciling accounts, available in Frontier preview. If you don't have those, ChatGPT or Claude can do the same match when you attach both files. Either way, you still review each flagged item and make the fix in your own bookkeeping app.

## The prompt

Fill in the parts in [square brackets], or leave them and the AI will ask you for them.

```text
This workbook has two sheets: Bank (my bank transactions for [STATEMENT MONTH, e.g. October 2026]) and Books (what I recorded in [BOOKKEEPING APP, e.g. my bookkeeping app]). Reconcile them. Match each bank line to a book entry by amount and date, allowing [DATE WINDOW, e.g. 3 days] of difference. Then make a new sheet called Gaps with four sections: in the bank but not in my books, in my books but not in the bank, amounts that don't match, and possible duplicates. For each item, show the date, description, amount and a one-line suggested fix in plain words. At the top, show the starting and ending balance on each side and the difference. Don't change the Bank or Books sheets.
```

## Step by step

1. Export last month's transactions from your bank and your bookkeeping app as spreadsheets
2. Paste both into one Excel workbook on separate sheets named Bank and Books
3. Open Copilot in Excel and paste the prompt below
4. Review each flagged item and fix it in your bookkeeping app

## What you'll get

A new Gaps sheet listing every missing, mismatched or duplicate transaction with a suggested fix and the balance difference at the top.

## Good to know

**Can AI reconcile my bank statement with my bookkeeping records?** Yes. Export both lists, put them in one workbook and ask AI to match them and list every gap. As of October 2026, Copilot in Excel has new accounting skills for reconciling accounts, available in Frontier preview. If you don't have those, ChatGPT or Claude can do the same match when you attach both files. Either way, you still review each flagged item and make the fix in your own bookkeeping app.

**Which AI tools does this work in?** It works in Copilot, ChatGPT and Claude. On this page, ChatGPT and Claude open with your prompt already typed in. Copilot in Excel's new accounting skills are in Frontier preview. The prompt also works in ChatGPT or Claude with both files attached.

**How long does it take?** About 10 minutes a month. It's rated "A few steps". There are 4 steps, listed above.

**What do I need before I start?** Just your details for 3 blanks: statement month, bookkeeping app and date window. You can skip any, and your AI will ask for them.

**What will I get back?** A new Gaps sheet listing every missing, mismatched or duplicate transaction with a suggested fix and the balance difference at the top.

Idea spotted on the official docs, shared by Microsoft Copilot Blog: https://www.microsoft.com/en-us/copilot/blog/2026/10/29/microsoft-copilot-for-finance-purpose-built-for-the-way-finance-teams-work/. The prompt is The Solo Creators' own version.

## Go further

Ready-made skills in the Solo Creators AI Studio (https://thesolocreators.com/studio/) that fit this: Second Brain (Give your AI a memory it reads across every project, so it finally knows your business); Watch It For Me (Drop any video link and get the step-by-step playbook, the full timestamped transcript, and the best quotes. Without watching it).

From AI Use Cases and Prompts by The Solo Creators: https://thesolocreators.com/prompts/. Free to use; please link back to the page when you share it.