Orders came in, but I can't tell who has paid

Built!

Deposit Match shows candidate matches between orders and bank deposits, and adds the payment status you decide to your order sheet in Excel.

Current workflow

To check bank-transfer orders, many sellers print out their bank statement and highlight entries one by one against the order list. Spreadsheet lookups like VLOOKUP help only when names match exactly — a single different character, such as a family member paying under their own name, sends you back to checking by eye. Paid auto-matching services exist, but their monthly fees are hard to justify if you only reconcile occasionally. When a person matches, say, 50 orders against 48 bank entries, the mismatches follow repeating patterns: a different payer name, several orders paid in one lump sum, one order split into multiple payments, fees deducted, or a payment that landed the next day.

Solution

Match Deposits to Orders

How to use

1. Paste your order list (buyer name and amount). 2. Paste your bank deposit records (payer name and amount). 3. Results come out in three groups — paid / unpaid / needs review. Review each order's deposit candidates and amounts, set a status for each, then download the final Excel file with the payment status added to your original order sheet.

Example

- Input: an order list of 50 orders + 48 bank deposit entries - Result: a matching table split into the three groups. Entries that were hard to find by eye — for example an order from one buyer (35,000 KRW) paid under a different name — are suggested as candidates using amount, name similarity, and lump-sum combinations. If two payers share the same name, check the order of the order time versus the deposit time as well.

Open tool
View details
Limits
- If the payer name is completely different and the amount doesn't match on its own, the match can't be confirmed automatically. It stays in "needs review." - Same name + same amount + same day may not be distinguishable even with timestamps.
Cost type
Free

Lump-sum payments can't always be resolved. When several orders from one payer arrive as a single deposit, the tool can suggest combinations that add up to the total — but if more than one combination fits, it can't determine which set of orders the payment covers. The same goes for two people with the same name paying the same amount (for example, a single 10,000 KRW item) on the same day: automatic matching can pair them incorrectly. In these cases the tool presents candidates and the final call stays with a person. One rule matters here: never confirm a deposit that arrived before the order was placed as that order's payment.

Support

I have this problem too · 0 people

Sign in to support or ask a question

Comments

Be the first to comment.

Additional information

Delete a post made without signing in