Find duplicate payments on your bank statement
The problem
An invoice gets paid by card and again by transfer, or approved twice. Small businesses rarely have AP software to catch it, and a double payment can sit unnoticed for months.
How it's solved today
Sort the statement by amount in Excel and eyeball it. Ask the vendor for a statement. Larger companies use AP or ERP duplicate checks that most small businesses don't have.
How SandQuery helps
Upload a bank statement (PDF or CSV) and run Duplicate payment detector. It finds payments to the same vendor for the same amount made close together, and shows how much is at stake. It's a review list, not a verdict: some repeats are genuine, such as a subscription that bills often. Related reports: Reversal and refund pairing (refunds and reversals matched to the payments they undo) and Subscriptions and recurring charges.
Example result (illustrative figures)
| Vendor | Amount | Paid on | Possible duplicate |
|---|---|---|---|
| Northwind Supply | $480.00 | Aug 3, Aug 7 | $480.00 |
| Cloudhost | $99.00 | Aug 1, Aug 2 | $99.00 |
FAQ
What does it cost?
The report shows its price before you run it.
Can it check several months at once?
Yes. Group statements into a set and the report reads them as one table.
Will it flag different vendors with the same amount?
No. It groups by vendor and amount.