# Match every bank deposit to your sales in 10 minutes a month

> A restaurant owner cut a three-hour monthly cash check to 5 to 10 minutes this way.

Upload your sales export and your bank statement for the month. You get a table that matches each day's takings to its deposit and flags every gap worth a look.

- Page: https://thesolocreators.com/prompts/match-bank-deposits-to-your-sales/
- Category: Put your business on autopilot
- Made for: Small business owners
- Works in: ChatGPT, Claude, Gemini
- Time: About 10 minutes a month
- Effort: A few steps
- Note: The source used ChatGPT Work. A regular chat with file uploads works too; free plans have upload limits.
- Published: 2026-10-24

## How do I match my bank deposits to my sales with AI?

Upload your sales report and your bank statement for the same month, then ask the AI to match each day's takings to its deposit and flag the gaps. ChatGPT, Claude and Gemini can all read the two spreadsheets in one chat. If your deposits arrive a few days late or get combined, say so in the prompt so the matching allows for it. Delete account numbers before you upload, and check every flagged row against your receipts.

## The prompt

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

```text
I run [YOUR BUSINESS, e.g. a two-location bakery]. I've attached two files: my sales report for [REPORT MONTH, e.g. September] and my bank statement for the same month.

Please reconcile them:
1. Work out what should have reached the bank each day (cash and card takings, minus card fees of about [CARD FEE, e.g. 2.6%]).
2. Match each day to its deposit. Allow for deposits that land [DEPOSIT DELAY, e.g. 1 to 3 days] later, and for days that get combined into one deposit.
3. Give me a table: date, expected, deposited, difference, status (matched, short, over, missing).
4. Under the table, list every unmatched item with the most likely reason, such as a refund, a late deposit or a fee.
5. End with the month's totals and the three things I should check first.

Don't guess silently. If a number is unclear, say so and ask me.
```

## Step by step

1. Export last month's sales or cash report from your till or booking app as a spreadsheet
2. Download the same month's bank statement as a CSV and delete your account number
3. Attach both files to a new ChatGPT chat
4. Paste the prompt and fill in your details
5. Check each flagged row against your receipts before you change anything

## What you'll get

A day-by-day reconciliation table with every short, over or missing deposit flagged, plus a short list of what to check first.

## Good to know

**How do I match my bank deposits to my sales with AI?** Upload your sales report and your bank statement for the same month, then ask the AI to match each day's takings to its deposit and flag the gaps. ChatGPT, Claude and Gemini can all read the two spreadsheets in one chat. If your deposits arrive a few days late or get combined, say so in the prompt so the matching allows for it. Delete account numbers before you upload, and check every flagged row against your receipts.

**Which AI tools does this work in?** It works in ChatGPT, Claude and Gemini. On this page, ChatGPT and Claude open with your prompt already typed in. The source used ChatGPT Work. A regular chat with file uploads works too; free plans have upload limits.

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

**What do I need before I start?** Just your details for 4 blanks: your business, report month, card fee and deposit delay. You can skip any, and your AI will ask for them.

**What will I get back?** A day-by-day reconciliation table with every short, over or missing deposit flagged, plus a short list of what to check first.

Idea spotted on the official docs, shared by OpenAI: https://openai.com/index/ted-taylor-restaurant/. 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.