How to Combine Bank CSV Exports from Multiple Banks into One Spreadsheet

To combine bank CSV exports from multiple banks, normalize each file to the same four columns first, then stack them. In practice that means adding a header row where one is missing, deleting any summary block above the data, converting split debit and credit columns into one signed amount, forcing every date into a single format, and adding a bank or account column before you paste anything together. Skip a step and the combined total will be wrong in a way that is hard to spot later.

This comes up constantly. A business with an operating account at one bank, a payroll account at another and a savings buffer somewhere else ends up with three downloads that share nothing but the concept of a transaction. Below is the order that works, and why each step matters.

Step 1: Give every file a header row

Some banks label their columns and some do not. Wells Fargo's comma delimited download arrives with no header row at all, so the file opens as unlabeled columns and nothing downstream can map it. Bank of America goes the other way and puts a short balance summary block above the transaction table, which means row one is not the header either.

Fix both before touching anything else. Insert a header row into the unlabeled file and name the columns. Delete the summary rows from the file that has them so the real header sits on row one. Save each corrected file as a template, because next month's download will have exactly the same problem.

Step 2: Decide on one column layout and map to it

Pick the smallest set of columns that carries what you need. For most work that is Date, Description, Amount, Balance, plus one column identifying which account the row came from. Anything else is either duplicated elsewhere or specific to one bank.

Then map each source file onto it. The layouts genuinely differ: a Chase checking export leads with a Details column and carries Posting Date, Description, Amount, Type, Balance and a check number field, while a Citi export runs Status, Date, Description, Debit and Credit. A full side by side of what each institution writes is in our reference on bank CSV export columns, which saves guessing at a file you have not seen before.

Step 3: Get every amount into one signed column

This is where combined files quietly go wrong. Banks that split money into Debit and Credit columns write both numbers as positives, so the direction lives in which column is populated, not in the sign. Banks that use a single Amount column write withdrawals as negatives. Paste both shapes into one sheet untouched and your spend total nets itself against your deposits.

Collapse the split files with a formula like =IF(Credit="",-Debit,Credit), which produces a negative for money out and a positive for money in. Then spot check it: pick a known withdrawal and confirm it reads negative in the combined sheet. Do that once per bank, not once per file.

Step 4: Force one date format

Date columns are the second most common source of silent damage. Some downloads use MM/DD/YYYY, some use YYYY-MM-DD, and Excel will interpret an ambiguous value like 03/04 differently depending on how the column was typed when it was pasted. A March 4 transaction quietly becoming April 3 does not announce itself; it just puts revenue in the wrong month.

Convert text dates with DATEVALUE, format the whole column once after the files are stacked, and then sort by date. If the sort produces an obviously wrong order, you still have text in there somewhere.

Step 5: Add an account column before you stack

Add a column naming the bank and the last four digits of the account to each file before you paste it into the combined sheet. It takes ten seconds and it is the difference between a workable sheet and one you have to unpick.

Without it you cannot filter to one account, you cannot reconcile any single account back to its statement, and you cannot tell an internal transfer from real revenue. That last one matters a lot: a transfer between two of your own accounts appears twice in a combined file, once as a withdrawal and once as a deposit. Both are real rows. Neither is income or expense, and if you are building a spend model or handing the sheet to a lender, they have to be flagged and excluded rather than deleted.

Step 6: Deal with duplicates and pending rows

Two kinds of duplicates show up. The first is overlapping date ranges, which happens whenever somebody downloads January to June and then June to December. Sort by account, then date, then amount, and the pairs sit next to each other where they are easy to see.

The second is pending transactions. An export taken mid period can include items that have not posted, and a pending amount often changes before it settles, particularly with tips, holds and card authorizations. When the settled version arrives in next month's file you now have two rows for one transaction with different amounts. Filter pending rows out at the source rather than trying to identify them later.

Why the balance column is worth keeping

Keep the running balance while you are working, even though you will delete it before importing anywhere. It is the only built-in check you have. Filter to one account, sort by date, and confirm the last balance matches the closing balance on that account's statement. If it does, no rows were dropped from that account. If it does not, you know exactly which account to look at rather than searching the whole combined file.

Not every bank gives you one. Wells Fargo comma delimited files and Citi exports leave the balance out entirely, which is one of the better arguments for working from statement PDFs instead when the result has to be defended to an auditor or a lender.

When to stop fighting the exports

The whole process above is worth doing once, for a period that sits inside every bank's download window. It stops being worth doing when any of the following is true: the period reaches past the export window, which at Bank of America is roughly 18 months of consumer activity and at Capital One is capped near 90 days; a bank in the mix does not give you a balance; or the result has to reconcile exactly to statements for a lender, an auditor or a return.

In those cases, converting the statement PDFs is both faster and safer, because every statement comes back in the same column layout with the balance preserved and the signs already normalized. Our bank statement PDF to Excel converter handles a mixed batch of banks in one upload, and returns them as one continuous sheet in date order rather than one file per bank.

What to do with the combined sheet

Once the rows are stacked, signed and dated correctly, the useful work starts. Flagging internal transfers, splitting business from personal, and grouping vendors into categories turns a transaction list into something you can actually make decisions from, and there are dedicated tools that will read receipts and code spending automatically if you are doing it monthly rather than once a year.

From there, categorizing transactions from a bank statement covers the coding side, reconciling bank statements covers proving the sheet is complete, and building a profit and loss from bank statements is usually what the owner actually wanted when they asked for the spreadsheet.

Common questions

Can I just paste every CSV under the last one?

Only if every file has identical columns in identical order with the same sign convention, which is rare across banks and never guaranteed across a redesign. Normalize each file to a shared layout first. Pasting mismatched files produces a sheet where amounts land in the wrong columns for some rows and totals silently exclude them.

How do I handle transfers between my own accounts?

Tag them rather than delete them. Each side of a transfer is a genuine line on a genuine statement, so removing one breaks the tie back to the balance. Add a flag column, mark both sides, and exclude the flagged rows from income and expense totals while leaving them in the reconciliation.

Should I combine business and personal accounts in one sheet?

Keep them in one file only if the account column stays intact, and never merge them for anything a lender or the IRS will see. Commingled records are a well known audit irritant. A single sheet with a clean account column lets you filter to just the business accounts in one click.