How to Combine Multiple Bank Statements into One Spreadsheet
To combine multiple bank statements into one spreadsheet, convert each statement PDF to a CSV with the same Date, Description, Amount, and Category columns, then stack the rows into a single sheet. Because every file shares the same structure and signed amounts, the combined spreadsheet totals correctly across months and accounts.
The problem with merging by hand
Merging statements manually goes wrong because each month's copy-paste lands in slightly different columns, some amounts lose their signs, and date formats drift. By the time you've stacked twelve months, the totals don't tie out and you're auditing your own spreadsheet.
Make every file identical first
The fix is to convert each statement to a CSV with the exact same columns and consistent signs before you merge. Once every file matches, combining them is just appending rows — one sheet per account for the year, or a single master sheet with an account column. Totals and category subtotals then add up across the whole period.
Step by step
- Convert each statement. Convert every monthly PDF to a categorized CSV.
- Confirm matching columns. Check that each CSV has the same Date, Description, Amount, and Category columns.
- Stack the rows. Append the CSVs into one sheet, adding an account column if merging accounts.
- Total and review. Sum by category and month, and confirm the totals tie to each statement.
FAQ
Can I combine statements from different banks?
Yes. Because each is converted to the same column structure, statements from different banks stack together in one spreadsheet.
How do I keep accounts separate in one sheet?
Add an Account column and label each block of rows, so you can filter or pivot by account while keeping everything in one file.
Keep reading
- How to Convert a PDF Bank Statement to Excel (or CSV)
Three ways to turn a PDF bank statement into an Excel/CSV spreadsheet — copy-paste, Excel's PDF import, and an automatic converter — with the pros and cons of each.
- How to Import Bank Statements into QuickBooks
How to get transactions from a PDF bank statement into QuickBooks Online using a CSV — the format QuickBooks expects, and how to prepare it in seconds.
- How to Categorize Business Expenses for Taxes
A practical guide to categorizing business transactions from your bank statements so tax time is painless — and how to get a pre-categorized CSV to start from.
- How to Convert a Bank Statement PDF to CSV
The fastest way to turn a bank statement PDF into a clean CSV — what a CSV needs to contain, why manual methods break, and how to do it in seconds.