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.
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
Comments
Be the first to comment.