How to merge multiple bank statements in Excel

Convert first, merge second

Convert each statement individually and verify each one against its own closing balance before combining anything. Merging first means a single error is buried in a thousand rows with no way to isolate it.

Add the columns that make merging safe

Before stacking, add two columns to every file:

• Account — the bank and account name, so rows stay attributable
• Source file — the statement the row came from, so anything odd can be traced back

Check the balance chain

For each account, the closing balance of one statement must equal the opening balance of the next. Walk that chain across the whole period. Every missing or duplicated month shows up as a break, and nothing else finds them as reliably.

Handle internal transfers

A transfer between two of your own accounts appears twice, once as a debit and once as a credit. Tag both sides and exclude them from income and expense totals, or the combined sheet will overstate both.