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

  1. Add the order list and the deposit history.
  2. Review the matching results.
  3. 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.CustomerItemAmount
S-101Kim MinsuHandmade soap set35000
S-102Lee SeoyeonHandmade candle28000
S-103Park JihunLeather card wallet45000
S-104Choi SuaKnitted bag52000
S-105Jung HaneulMug19000
S-106Kim MinjunHandmade soap set35000
DatePayerAmountMemo
2026-11-01Kim Minsu35000
2026-11-01Lee Seoyeon28000
2026-11-01Park Jihun40000
2026-11-02Choi Sua52000
2026-11-02Jung Haneul’s mom19000Jung Haneul mug
2026-11-02Han Jiwoo15000

After · results

NameOrder amountDeposit amountStatusReason
Kim Minsu3500035000MatchedExact name and amount
Lee Seoyeon2800028000MatchedExact name and amount
Choi Sua5200052000MatchedExact name and amount
Park Jihun4500040000Amount mismatchAmount differs: 5000 short (check yourself)
Jung Haneul19000—UnpaidNo exact payer name
Kim Minjun35000—UnpaidNo exact payer name
Jung Haneul’s mom—19000Cannot confirmNo exact order name
Han Jiwoo—15000Cannot confirmNo 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

  1. Paste or open your prepaid order list.
  2. Paste or open your bank deposit history.
  3. Review the results matched by name and amount.
  4. Compare amount mismatches and cannot-confirm entries with the original records yourself.
  5. 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.