Delivery Platform Reconciliation
Reads 배달의민족·쿠팡이츠·요기요 settlement CSVs by column name, totals the fees, and matches each payout against your bank statement by amount and date, listing what never arrived.
Delivery platforms settle in cycles, each with its own fee lines, and the money that arrives in the bank is a net figure with nothing to identify which cycle it belongs to. This reads the platform’s settlement CSV, totals the fees, and matches each payout against your bank statement by amount and date.
Delivery-app settlement
Drop the settlement CSV here
Recognised by the column names
Download the per-order settlement from 배민사장님광장, 쿠팡이츠 스토어 or 요기요 사장님사이트 as CSV, or paste it. From Excel: Save as → CSV.
Bank statement
Drop the statement CSV here
Column names differ by bank; that is fine
after the expected payout date
Download the same period from your internet banking as CSV or Excel. It needs a transaction time, a credit amount and a memo column.
How to use it
Drop the platform’s settlement CSV
배달의민족, 쿠팡이츠 and 요기요 exports are read by column name rather than by position, so a layout change on their side does not silently shift the columns.
Add the bank statement
Export the account’s transactions for the same period. Matching is by amount and date, so both files need to cover the same window.
Read the fee breakdown
The fee lines are totalled by kind — commission, delivery, payment processing, promotions — which is where the effective rate on a month of sales becomes visible.
Look at what never arrived
Unmatched settlement rows are the output that matters. A cycle with no corresponding deposit is either late, offset against something, or worth a call.
Common questions
Does it compare against my POS sales?
No. This reconciles the platform’s settlement file against the bank statement — two documents that should agree. Comparing platform orders against your own till is a different reconciliation and is not done here.
A settlement did not match but the money did arrive.
Usually one deposit covering two cycles, or a deduction applied after the settlement was calculated — a chargeback, a fee adjustment, a promotion settled separately. The unmatched pair is shown so you can see the amounts rather than guess.
Is the CSV uploaded?
No. Both files are parsed in the browser. They contain your revenue and your bank transactions, so neither leaves the tab.
My file’s columns are not recognised.
Platforms rename columns between versions, and a CSV re-saved from Excel in the default encoding arrives as 뷁. Open it, check the header row reads as Korean, and re-export as UTF-8 if it does not.
Feed it from
Table Diff
Compares two tables by a chosen or inferred key column and lists added, removed and changed rows cell by cell, side by side or as a change log.
Bank Account Format Check
Identifies the likely bank from an account number’s length and prefix and normalises the formatting.
Parcel Number Checker
Identifies the courier from an invoice number’s format, validates its check digit and builds the tracking link.
Business Registration Number Validator
Checks the 10-digit check sum of a Korean business number and can bulk-validate a pasted column.
Next
These accept what this tool produces, so the result can go straight in.
Table Diff
Compares two tables by a chosen or inferred key column and lists added, removed and changed rows cell by cell, side by side or as a change log.
CSV Join
Joins two tables on a key column with inner, left, right or outer semantics and shows unmatched rows.
CSV to Excel
Writes one or many CSV files into an .xlsx workbook with typed columns, a header row and filters.
VAT Calculator
Adds or removes the 10% VAT and splits a total into supply value and tax for invoice lines.
Korean Age Calculator
Works out your 만나이, 연나이 and the old 세는나이 from a birth date, on any reference day.
Annual Leave Calculator
Works out how many paid leave days have accrued by joining date or fiscal year, including the first-year rule.