Every bank's statement has a different Excel layout, so merging them is hard

Built!

Bank Statement Merge recognizes columns from each bank's file and lets you review them before downloading one merged Excel file.

Current workflow

When it's time to send bookkeeping material to an accountant, every bank's statement export looks different. Kookmin, Shinhan, Woori, Hana, IBK, and NongHyup all use different column names for the same things — "Transaction Date / Processing Date," "Amount Withdrawn / Withdrawal," "Description / Memo" — and their date formats and column orders differ too. On top of that, each file usually starts with 1–5 summary rows holding the bank logo and the query period. In the end, people cut and paste columns from each bank file by hand to force them into one table.

Solution

Merge Bank Statements

How to use

1. Upload the statement Excel files you downloaded from your banks (multiple banks are fine). 2. Each bank's format is recognized automatically; check in the preview that the columns are connected correctly. 3. Check which transactions to include and their direction, review the preview, then download the final Excel file in the standard column order (Date & Time, Deposit, Withdrawal, Balance, Memo). Files are processed in your browser and never sent to a server.

Example

- Input: statement files from two banks with different column names and orders for date, memo, and deposits/withdrawals (each with 1–5 summary rows at the top) - Result: one merged table unified into the standard order — Date & Time, Deposit, Withdrawal, Balance, Memo

Open tool
View details
Limits
- Unusual files (such as branch-specific formats) may be recognized incorrectly. Check the column connections in the preview. - If the summary rows sit in an unusual position, data rows can be removed along with them. Compare the result's row count against the original.
Cost type
Free

If files with opposite deposit/withdrawal conventions are mixed in, amounts can flip after merging and the totals won't add up — one bank records withdrawals as negative numbers, while another uses a separate column with positive numbers. Each file also carries its own balance column, so the merged table needs checking that balances continue in row order. Even after merging with the tool, comparing the deposit and withdrawal totals against the bank originals, and eyeballing the first and last few rows, remains a step you do yourself.

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