I match prepaid orders against deposits one at a time

Built!

Add your order list and deposits to see them split into paid, unpaid, amount mismatch and cannot confirm.

Current workflow

If you take orders by bank transfer in advance, the most labor-intensive part is matching the order list against your deposit records one by one, by eye. When a payment arrives under a slightly different name (for example, the buyer is Minsu Kim but the payer is "Minsu Kim's mom"), or only part of the amount was paid, each case breaks your flow while you check it manually. Marking things as matched automatically risks shipping an unpaid order, so most sellers fall back to checking every single entry themselves.

Solution

Match Prepaid Orders

How to use

1. Paste your prepayment order list, or load it from a file. 2. Paste your deposit records, or load them from a file. 3. Review the matching result, grouped by name and amount: paid / unpaid / amount mismatch / cannot confirm. 4. Check the amount-mismatch and cannot-confirm entries by eye, then download the result table.

Example

- Input: 6 orders (Minsu Kim 35,000 KRW, Seoyeon Lee 28,000 KRW, Jihoon Park 45,000 KRW, Sua Choi 52,000 KRW, Haneul Jeong 19,000 KRW, Minjun Kim 35,000 KRW) and 6 deposits - Result: 3 confirmed paid (Minsu Kim, Seoyeon Lee, Sua Choi — name and amount both match), 1 amount mismatch (Jihoon Park — ordered 45,000 KRW vs deposited 40,000 KRW, 5,000 KRW short), 2 cannot confirm (Haneul Jeong — the payer name "Haneul Jeong's mom" is not an exact match / Jiwoo Han — a 15,000 KRW deposit with no matching order), 1 unpaid (Minjun Kim)

Open tool
View details
Limits
- Entries whose names don't match exactly are grouped separately as "cannot confirm." They are never treated as matched automatically. - Partial payments are classified as amount mismatches. Check them by eye.
Cost type
Free

The matching result is a working aid, not a final record. A deposit made under a family member's name instead of the buyer's, or a deposit with no order behind it, cannot be tied to an order by name and amount alone — this tool does not resolve those automatically either. A step where you personally review the unpaid and mismatched entries before shipping has to remain in place. Skipping it and trusting the result as-is is how an unpaid order ends up shipped.

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