Match Prepaid Orders: order and deposit matching
Add your order list and deposits to see them split into paid, unpaid, amount mismatch and cannot confirm.
Quick start
- Add the order list and the deposit history.
- Review the matching results.
- Download the result table.
Example: before and after
An example matching 6 orders with 6 bank deposits by name and amount.
Before · order list and deposits
| Order no. | Customer | Item | Amount |
|---|---|---|---|
| S-101 | Kim Minsu | Handmade soap set | 35000 |
| S-102 | Lee Seoyeon | Handmade candle | 28000 |
| S-103 | Park Jihun | Leather card wallet | 45000 |
| S-104 | Choi Sua | Knitted bag | 52000 |
| S-105 | Jung Haneul | Mug | 19000 |
| S-106 | Kim Minjun | Handmade soap set | 35000 |
| Date | Payer | Amount | Memo |
|---|---|---|---|
| 2026-11-01 | Kim Minsu | 35000 | |
| 2026-11-01 | Lee Seoyeon | 28000 | |
| 2026-11-01 | Park Jihun | 40000 | |
| 2026-11-02 | Choi Sua | 52000 | |
| 2026-11-02 | Jung Haneul’s mom | 19000 | Jung Haneul mug |
| 2026-11-02 | Han Jiwoo | 15000 |
After · results
| Name | Order amount | Deposit amount | Status | Reason |
|---|---|---|---|---|
| Kim Minsu | 35000 | 35000 | Matched | Exact name and amount |
| Lee Seoyeon | 28000 | 28000 | Matched | Exact name and amount |
| Choi Sua | 52000 | 52000 | Matched | Exact name and amount |
| Park Jihun | 45000 | 40000 | Amount mismatch | Amount differs: 5000 short (check yourself) |
| Jung Haneul | 19000 | — | Unpaid | No exact payer name |
| Kim Minjun | 35000 | — | Unpaid | No exact payer name |
| Jung Haneul’s mom | — | 19000 | Cannot confirm | No exact order name |
| Han Jiwoo | — | 15000 | Cannot confirm | No exact order name |
Amount differences and names that are not exactly the same are not confirmed automatically; they are shown separately for checking. The order under Jung Haneul and the deposit from Jung Haneul’s mom are not assumed to be the same person.
All of this is made-up example data. The table exists only on this page and is not a download.
What this tool does
When you take prepayment for merchandise or made-to-order items, checking the order list against bank deposits one by one takes time. This reduces that work. Open the order list and the deposit history to find entries that match by name and amount, and see the results split into paid, unpaid, amount mismatch and cannot confirm. Entries with similar names or different amounts are not forced into the same order. Anything that cannot be confirmed automatically is collected separately so a person can check it.
How to use
- Paste or open your prepaid order list.
- Paste or open your bank deposit history.
- Review the results matched by name and amount.
- Compare amount mismatches and cannot-confirm entries with the original records yourself.
- Download the checked result table and use it for order management.
What it does not do
- Entries with similar names or different amounts are not forced into the same order. If the order is under Kim Minsu and the payer is “Kim Minsu’s mom”, it is set aside as cannot confirm.
- If the ordered and paid amounts differ, it is classified as an amount mismatch. Check partial payments yourself.
- The results are a reference. Check unpaid and mismatched entries yourself before shipping.
Frequently asked questions
What if the payer name differs slightly from the order name?
For example, if the order is under Kim Minsu and the payer is “Kim Minsu’s mom”, it is not confirmed as an exact match; it is set aside as cannot confirm. Check the original order and deposit yourself.
What about partial payments?
If the ordered and paid amounts differ, it is classified as an amount mismatch. Check partial payments yourself.
Is my bank history stored on a server?
No. Files and anything you enter are processed only in your browser and disappear when you close the window.
Which file formats can I use?
You can open Excel or CSV files, or paste a table directly.
Files and personal information
Files and anything you enter are not sent to a server. They are processed only in the browser you are using now, and closing the window clears what you entered.
The results are a reference. Check unpaid and mismatched entries yourself before shipping.