How to Merge Multiple Bank Statements into One Excel File

Combining converted statements across months and accounts, the checks to run on the merged file, and avoiding double-counting.

Once you have several converted statements, merging them is usually the next step — for a tax return, a loan application, or an annual review. There are three specific ways this goes wrong.

1. Overlapping periods

Statements sometimes overlap at the boundaries, particularly if you downloaded custom date ranges rather than calendar months. Stack them naively and the overlapping transactions appear twice.

The symptom is a merged file whose totals exceed the sum of the individual statements' totals. Check that before anything else.

2. Missing periods

The opposite problem, and the more damaging one. A month that was never downloaded leaves a gap that nothing in the merged file signals.

The continuity check finds it: sort by date, and confirm each statement's closing balance equals the next one's opening balance. A discrepancy is a missing period.

3. Mixed accounts without an account column

Merging statements from two accounts into one table without an account column produces a balance column that jumps between two unrelated chains. Nothing about it reconciles.

Always add an account column when merging across accounts, even if you only have two.

A merge that holds up

Convert and verify each statement individually Against its own printed totals.
Add account and period columns Before combining, so provenance is preserved.
Line the columns up, then stack Each export keeps its bank's own headings, so match them by meaning — Withdrawal to Paid out — before appending one under another.
Sort by account, then date Not date alone, if several accounts are present.
Check continuity within each account Closing balance to next opening balance, period by period.
Compare the merged totals Against the sum of the individual statements' printed totals.

A continuity check in one column

Once statements are merged and sorted, the continuity check is a single formula. For each statement boundary, compare that period's closing balance against the next period's opening balance.

Any non-zero difference means a period is missing between them, and the size of the difference is the net movement across the missing period — which sometimes tells you how much activity you are missing.

Merging across accounts as well as periods

If you are combining several accounts, sort by account first and date second, and run the continuity check within each account. Across accounts it is meaningless — two accounts' balances have no relationship to each other.

Frequently asked questions

How do I spot a duplicated period?

Merged totals exceeding the sum of the individual statements' printed totals. That difference is the overlap.

What does the size of a continuity gap tell me?

It is the net movement across the missing period. A small gap might be one fee row; a large one is probably a whole statement.

Can I merge statements from different banks?

Yes, once their columns are lined up. Each export keeps its bank's own headings, so match them by meaning before stacking, and keep an account column so each chain stays separable.

Convert a statement now

Bank Statement PDF to Excel, or see every format. More in the guides.