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.
A sketch of what you'll get back.
Your prompt
Fill in your details. Skip any you like.
ChatGPT and Claude open with your prompt already typed in. Gemini can't be filled in from a link, so its button copies your prompt: paste it into the new chat.
The prompt that gets copied
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.
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.
Step by step
- Export a year of payments from your bank or accounting software.
- Remove account numbers, then attach the file and paste the prompt.
- Check each possible duplicate against the supplier's invoices.
- 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.
Remove account numbers before you upload. Treat flagged duplicates as things to check, not proof.
- Made for
- Small business owners
- Works in
- ChatGPT, Claude, Gemini
