# Spot duplicate payments and your biggest suppliers in one upload

> It flags two payments of the same amount to the same supplier a few days apart, the kind a busy owner misses.

Upload a year of supplier payments from your bank or accounting software. You get your top suppliers by spend, possible duplicate payments to check and suppliers whose prices crept up.

- Page: https://thesolocreators.com/prompts/find-duplicate-payments-and-top-suppliers/
- Category: Make smarter decisions
- Made for: Small business owners
- Works in: ChatGPT, Claude, Gemini
- Time: About 10 minutes
- Effort: A few steps
- Note: Remove account numbers before you upload. Treat flagged duplicates as things to check, not proof.

## The prompt

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

```text
Attached is a list of payments to suppliers from [EXPORT SOURCE, e.g. my bank, last 12 months] for [YOUR BUSINESS, e.g. my restaurant].

Please:
1. Clean up supplier names so the same supplier is grouped together, for example "ACME FOODS 123" and "Acme Foods Inc"
2. Rank my top 15 suppliers by total spend, with each one's share of the total
3. Flag possible duplicate payments: the same or a similar amount to the same supplier within [DUPLICATE WINDOW, e.g. 10 days]
4. Show suppliers whose typical payment has gone up over the year, and by how much
5. List anything odd, like a new supplier with large payments

Put each part in a simple table. Mark possible duplicates as "check", not as errors, since some may be real repeat orders.
```

## Step by step

1. Export a year of payments from your bank or accounting software.
2. Remove account numbers, then attach the file and paste the prompt.
3. Check each possible duplicate against the supplier's invoices.
4. Ask suppliers about any price creep it found.

## What you'll get

Your top suppliers by spend, a list of possible duplicate payments to check and suppliers whose prices crept up.

## Good to know

**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. Remove account numbers before you upload. Treat flagged duplicates as things to check, not proof.

**How long does it take?** About 10 minutes. 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: export source, your business and duplicate window. You can skip any, and your AI will ask for them.

**What will I get back?** Your top suppliers by spend, a list of possible duplicate payments to check and suppliers whose prices crept up.

Idea spotted on the official docs, shared by OpenAI Academy: https://academy.openai.com/public/clubs/work-users-ynjqu/resources/use-cases-finance. 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: Board of Advisors (Convene seven AI advisors who debate your decision, vote, and hand back a stress-tested verdict); Fact Checker (Every quote, number, date, and link in your draft checked against its real source, with the fixes handed back as tracked changes you accept or reject).

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.