Combine Multiple Bank Statements Into One Excel Sheet

TL;DR Convert each statement to a file with the same columns (date, description, signed amount, plus account and statement month). Put the files in one folder and use Excel's Power Query "From Folder" to load and append them into a single table that refreshes when you add new files. Then check three things: each statement balances on its own, consecutive statements connect (one month's closing balance is the next month's opening balance), and nothing is duplicated where periods or downloads overlap.

Most real questions about money span more than one statement. What did we spend on software last year? Which months were tight? Did every rent payment arrive? To answer them, you need all the statements in one place: twelve months, or three accounts, or both, in a single table you can filter, sort and summarize.

Combining statements sounds simple and mostly is, as long as the files share a structure and you check the joins. This guide covers two ways to do it (a quick copy-paste method and a repeatable Power Query method), how to keep track of which row came from where, and the checks that catch gaps and duplicates.

Start with consistent files

Combining works best when every file has the same columns in the same order, with the same data types. Decide on a layout first:

The Account and Statement columns are what make a combined table useful. Without them, a row is just a date and an amount; with them, you can trace any row back to the PDF it came from.

Getting there from PDFs

If your statements are PDFs, convert them first. SheetStatement's bank statement to Excel converter gives every statement the same column layout, regardless of how the bank laid out the PDF, and checks each one against its opening and closing balances. That consistency is exactly what you want for combining. The free plan covers 3 pages a month; paid plans are $9, $19 or $39 a month for batches of statements.

If you're converting by hand or with Excel's PDF import, the PDF to Excel methods comparison explains the options. Whatever you use, normalize each file to the same layout before combining.

Getting there from bank downloads

If you have CSV downloads instead, check that every file uses the same columns. Banks sometimes change their export format, and a file from last year may have different headers or a different date format from this year's. Downloads from different banks will almost certainly differ. Fix the layout in each file before combining, or handle it in Power Query.

Name the files well

Use names like checking-1234_2026-03.csv. Sorting by name then sorts by account and month, and the file name itself carries the account and statement information, which Power Query can use.

Method 1: Copy and paste

For a handful of statements, copying is fine.

1. Create a new workbook with a sheet called All. Type your headers in row 1.
2. Open the first statement file. Copy the data rows (not the headers) and paste them below the headers in All.
3. Fill the Account and Statement columns for those rows.
4. Repeat for each file, pasting below the last row each time.
5. When done, select the data and press Ctrl+T to make it a table.

It's quick, and for a one-off project with three or four files it's all you need. The downsides appear at scale: it's easy to paste a month twice, skip one, or forget to fill in the Account column. Adding next month means doing it again by hand.

Method 2: Power Query from a folder

Power Query is built into desktop Excel (Data, Get Data). Its "From Folder" option loads every file in a folder and stacks them into one table. When you add a new file to the folder and refresh, the new file is included. For anything you'll repeat monthly, it's worth the extra ten minutes of setup.

Set it up

1. Put the files in one folder. Only statement files, all in the same format (all CSV or all Excel).
2. In Excel, go to Data, Get Data, From File, From Folder, and choose the folder.
3. Excel lists the files. Click Combine & Transform Data (rather than just Combine), so you can adjust before loading.
4. Pick a sample file when asked. Power Query uses it to work out the structure and applies the same steps to every file.
5. In the Power Query editor, you'll see one combined table with a Source.Name column showing which file each row came from.

Add Account and Statement from the file name

If your files are named checking-1234_2026-03.csv:

1. Select the Source.Name column.
2. Use Transform, Split Column, By Delimiter, and split on _. You get checking-1234 and 2026-03.csv.
3. Rename the first column to Account.
4. On the second, use Replace Values to remove .csv, then rename it to Statement.

Now every row knows its account and statement month, without you typing anything.

Fix data types

Click the icon at the top of each column to set its type: Date for Date, Decimal Number (or Currency) for Amount and Balance, Text for the rest. If dates come from a day-first source, use Change Type, Using Locale, and choose the right locale. Getting types right here means every future file is converted the same way.

Load

Click Close & Load. Excel creates a table on a new sheet with every row from every file. Next month, drop the new file into the folder and click Data, Refresh All. The table updates.

Our Power Query guide for bank statements goes further into cleaning steps you can add to the same query.

Combining different accounts

The same approach works for several accounts at once: put all the accounts' files in one folder, or use one folder per account and append the queries.

Two extra things to handle:

Sign conventions. Bank accounts and credit cards often disagree. Card exports frequently show purchases as positive. Before combining, decide that money out is negative everywhere, and flip the card amounts if needed. In Power Query, you can add a custom column: if [Account] = "card-5678" then -[Amount] else [Amount].

Transfers. A payment from checking to the card appears in both accounts. In a combined table, it's two rows with opposite signs. Tag both as transfers so they can be excluded from spending and income totals. Our guide to categorizing bank transactions with formulas shows how to tag them with a rules table.

Check the combined table

Combining is where gaps and duplicates sneak in. These checks catch them.

Check 1: each statement balances

For each statement, opening balance plus the sum of its amounts should equal its closing balance. If your converter already did this, you're fine. If not, a pivot table with Account and Statement in rows and Sum of Amount in values gives you each statement's net movement to compare with the PDFs. The balance checker does individual statements quickly.

Check 2: statements connect

For each account, one month's closing balance should equal the next month's opening balance. If the files include a running balance column, you can check this with the first and last balance in each statement. If there's a jump, a statement is missing, or a period is mislabelled.

A quick way to spot missing months: build a pivot with Account in rows and Statement in columns, showing Count of Amount. Any blank cell is a month with no data for that account.

Check 3: no duplicates

Duplicates happen when:

• The same file was dropped into the folder twice under different names.
• A bank download overlaps with a statement period.
• Two downloads cover overlapping date ranges.

To find them, add a key column combining date, amount and description:

=TEXT([@Date],"yyyy-mm-dd") & "|" & TEXT([@Amount],"0.00") & "|" & [@Description]

Then =COUNTIFS([Key],[@Key]) shows how many rows share each key. Anything above 1 deserves a look, but don't delete automatically. Two identical coffees on the same day are perfectly possible. Compare against the PDF and remove only true duplicates.

If duplicates come from overlapping downloads, the cleaner fix is to remove the overlap at the source: trim each download to its statement period, so every transaction belongs to exactly one file.

Check 4: the total ties to the bank

For a single account over a period, the opening balance of the first statement plus the sum of every row should equal the closing balance of the last statement. If this works, the combined table is complete for that account.

Working with the combined table

Once the table passes the checks:

• Add a Category column and fill it with rules.
• Add a Month column with =TEXT([@Date],"yyyy-mm") for summaries.
• Build a pivot table for spending by category and month; see our pivot table guide for bank statements.
• Filter by Account for account-specific questions.
• Search descriptions for a payee across every month and account at once.

If you're using Power Query, add categories in a separate table and merge them in the query rather than typing into the loaded table, because a refresh will overwrite manual edits in the loaded table. Alternatively, add formula columns to the right of the loaded table; Excel keeps those when the query refreshes.

Combining in Google Sheets

If you work in Google Sheets rather than Excel, there's no Power Query, but the same idea works. Import each statement file into its own tab, named after the account and month. Then, on a master tab, stack them with an array literal:

={'Checking 2026-01'!A2:F; 'Checking 2026-02'!A2:F; 'Card 2026-01'!A2:F}

Wrap it in FILTER to drop blank rows from the end of each range. Adding a month means importing one more tab and adding it to the formula. It's less automatic than a folder query, but for a year of statements it's manageable, and the same checks (each statement balances, statements connect, no duplicates) apply. Our guide to converting bank statement PDFs to Google Sheets covers importing each file correctly.

When combined data goes into accounting software

If the combined table is a staging area for QuickBooks, Xero or Wave, import one account and one statement period at a time, even if you've combined them for review. Accounting software reconciles per account, per period, and importing a year of mixed accounts at once makes errors hard to trace. The combined table is still useful as your checking tool: once each month is imported, compare the software's totals with the table's.

Our guides to importing bank statements into QuickBooks Online and the Xero CSV import format cover the import side.

A worked example

A bookkeeper takes on a new client with two checking accounts and a credit card, and needs a year of history for a catch-up.

1. Convert. Thirty-six statements (twelve per account) are converted to CSV with the same columns and named account_yyyy-mm.csv.
2. Folder. All thirty-six files go into one folder.
3. Power Query. From Folder, Combine & Transform. Account and Statement come from the file name. Card amounts are flipped with a custom column.
4. Check missing months. A count pivot shows a blank for the second checking account in July. The client hadn't sent that statement. The bookkeeper requests it, adds it to the folder, and refreshes.
5. Check connections. Every account's closing balances now connect month to month.
6. Check duplicates. The key-count column shows nine rows with a count of 2. Seven are genuine (repeat purchases at the same café on the same day, confirmed on the PDFs). Two came from a December download the client also sent; the bookkeeper removes the download from the folder and refreshes.
7. Tag and categorize. Transfers between the accounts and the card payments are tagged. The remaining rows are categorized with a rules table.

The bookkeeper now has one table for the client's entire year, which she uses to review the categories before importing each account month by month into the client's accounting software. Our guide to catch-up bookkeeping covers the rest of that project.

Troubleshooting

Power Query combined the files but some columns are empty. One or more files have different headers. Open them and make the headers match the sample file, or rename columns in the query.

Dates are wrong in some files only. Those files use a different date format. Standardize them at the source, or add a conditional conversion step in Power Query based on the file name.

The refresh picked up a file I didn't want. Power Query loads everything in the folder. Keep only statement files there, and add a filter on the file extension or name in the query if needed.

Manual edits disappeared after refresh. Edits typed into a Power Query output table are overwritten on refresh. Use formula columns next to the table, or merge a separate lookup table in the query.

Totals are double what they should be. Either a file is in the folder twice, or transfers are being counted on both sides. Check file names first, then the Transfer tagging.

Get consistent files first

Combining is easy when every file has the same shape. Upload your statements to SheetStatement to convert them into identical layouts, confirm each one balances, then drop them in a folder and let Power Query do the stacking. You can try it on the free plan before converting a full year.

FAQ

How do I combine multiple bank statements into one Excel file?

Convert each statement to the same column layout, then either paste them one below another in a single table, or use Power Query's From Folder option to load and append every file automatically.

Can I combine statements from different banks?

Yes, as long as you normalize them to the same columns and sign convention first. Add an Account column so you can tell them apart.

How do I find duplicates after combining?

Build a key from date, amount and description and count how many rows share each key. Check any duplicates against the PDF before deleting, since identical transactions on the same day can be genuine.

How do I know if a month is missing?

Use a pivot with Account in rows and Statement month in columns, showing a count. A blank cell means no data for that month. Also check that each closing balance equals the next opening balance.

Will Power Query update when I add new statements?

Yes. Add the new file to the folder and refresh. Keep manual edits outside the query output, since a refresh overwrites them.

Should I import a combined file into QuickBooks or Xero?

It's better to import one account and one statement period at a time, and reconcile each. Use the combined table for review and cross-checking.