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