Combine bank statements into one Excel
Merge multiple PDF bank statements — even from different banks — into one clean spreadsheet automatically. Smart Merge extracts every statement, standardizes the columns, converts debit and credit into a single signed amount, validates the balances and tags every row with its source file.
Free to try · up to 100 statements per merge on Pro & Business
A real sample: six statements merged into one — to a single merged workbook
A fictional sample document converted by the same engine you get — flip through the source PDF and every export format, or download the files themselves.
One master spreadsheet from many statements
Managing dozens of bank statements by hand is one of the most frustrating jobs in finance. A business banks across more than one account, switches providers part-way through the year, holds a multi-currency balance, and runs a card on top — and at month-end or year-end all of it has to come together in a single spreadsheet. None of the statements are in the same format, so the only manual option is to open each PDF and retype the numbers, one transaction at a time.
FlowParse Smart Merge removes that work. You drop in up to 100 PDF statements at once, the engine extracts every transaction, and it assembles a single structured Excel workbook you can actually use — sort it, filter it, pivot it and import it into your accounting software. What used to take an afternoon now takes a couple of minutes, and the result is more accurate because nothing is retyped.
What Smart Merge does
Merge, combine or consolidate bank statements — one job, three names
People search for this in different words. An accountant says consolidate bank statements, a bookkeeper says merge bank statements, a business owner says combine my statements into one spreadsheet. They all mean the same result: every transaction from every statement, in one table, in date order, with nothing missing and nothing counted twice. This page covers all three, whichever word you use.
There is one request that sounds the same but is not: merging the PDF files themselves into one longer PDF. Any PDF tool can staple twelve statements into a single document, and that is fine when a lender only wants one attachment. But the result is still a document — you cannot sort it, total it or import it, and the twelve different layouts are still twelve different layouts. If you need to work with the numbers, you need the data combined, not the pages.
| What you need | What does it |
|---|---|
| One PDF to attach to an email or a portal | Any PDF merger — the pages are joined, the data stays locked in the PDF |
| One spreadsheet with every transaction | Smart Merge → Excel or CSV, one Transactions sheet |
| One file to import into accounting software | Smart Merge → QuickBooks, Xero, Sage, DATEV or a .QBO / .OFX bank feed |
| One statement converted, not combined | Bank statement to Excel converter |
| Several credit card statements | Combine credit card statements |
| Invoices and other PDFs, not statements | Merge PDFs into one Excel |
Why businesses need one consolidated spreadsheet
A consolidated transaction spreadsheet sits at the centre of almost every finance task. For month-end reporting and bookkeeping, you need every transaction in one place before anything can be categorised and posted. For reconciliation, you match a single combined ledger against your accounting records rather than checking each statement separately.
At year-end and during audits, a year of statements has to be assembled into a searchable, traceable record. For cash-flow analysis and annual reporting, you pivot and chart the whole dataset — which only works if it lives in one sheet with consistent columns.
The need is sharpest for multi-account businesses. The more accounts and banks you use, the more incompatible formats you have to reconcile, and the more time manual consolidation eats. Smart Merge turns that growing burden into a single, repeatable upload.
Problems with manually combining bank statements
Doing it by hand isn't just slow — it's exactly where the errors come from.
Manual consolidation fails in predictable ways. Copy-paste errors creep in when you transpose a digit or paste into the wrong row. Duplicate transactions slip through when two exports overlap. PDFs have no real table structure, so copying them produces broken tables with merged cells.
Then there's the format problem: inconsistent columns, different date formats and different bank layouts mean you are constantly re-aligning data by hand. And once everything is flattened into one sheet, you have lost traceability— there's no easy way to tell which statement a given transaction came from when a figure is later questioned.
Smart Merge eliminates every one of these failure modes at once: extraction is structured, columns are matched by meaning, duplicates are detected, and a Source File column keeps every row traceable.
| Manual process | Smart Merge | |
|---|---|---|
| Method | Copy & paste | Automatic |
| Volume | A few files before fatigue | Up to 100 PDFs |
| Different formats | Re-aligned by hand | Standardized |
| Accuracy | Error-prone | Validated |
| Traceability | Lost once flattened | Source File on every row |
| Time | Slow — hours | Minutes |
How Smart Merge works
Four steps from a folder of mismatched PDFs to one reconciled Excel.
STEP 1
Upload your statements
Drop up to 100 PDF statements onto the batch page. Pages are counted and queued for extraction.
STEP 2
Automatic extraction
Each statement is parsed with AI — dates, descriptions, amounts and balances — running as you upload.
STEP 3
Smart Merge
Click Merge into one Excel. Columns are matched across banks and rows are stacked into one sheet.
STEP 4
Download one Excel
Get a single workbook: a Summary and a unified Transactions sheet, with totals and source files.
Merge statements from different banks
Smart Merge is built for the messy reality of how businesses actually bank. It combines personal accounts and business accounts, statements in multiple currencies, and both monthly statements and yearly statements — including international banks that label their columns in another language entirely.
Because extraction is based on meaning rather than a fixed template, two completely different statement layouts resolve into the same clean structure. Consider two banks with nothing in common but the data they hold:
Bank A
Date · Description · Money Out · Money In
Bank B
Datum · Transaction · Debit · Credit
Smart Merge output
Date · Description · Amount · Balance · Source File
Canonical column matching
The hardest part of consolidating statements is that no two banks agree on what to call a column. Smart Merge reads every column from every statement and maps it to a canonical financial meaning, so the combined sheet is perfectly aligned no matter where each row came from:
Two details make this reliable. First, signed amounts: separate debit and credit columns are reconciled into one Amount column — debits negative, credits positive — which is exactly what reconciliation tools and accounting imports expect. Second, balance normalization: the running balance is captured consistently so the sequence can be verified after merging. Columns unique to one bank — a category, a reference, an exchange rate — are kept as their own columns, so nothing is ever lost.
Built-in validation
A consolidated spreadsheet is only useful if you can trust it. Smart Merge validates as it combines. Transaction counts are tracked per statement and in total. Balance verification checks that opening plus transactions equals closing on every statement. Duplicate detection catches overlapping exports, and the balance chain flags a missing month between two statements of one account.
On top of that, source tracking tags every row, and per-field confidence checks surface anything the AI was unsure about — so problems show up before they reach your books, not after.
| Validation | Supported |
|---|---|
| Balance validation | Yes |
| Balance chain across statements | Yes |
| Duplicate detection | Yes |
| Source file tracking | Yes |
| Transaction validation | Yes |
Year-end consolidation in minutes
Year-end is where consolidation hurts most. Twelve months of statements — often across several accounts and banks — have to become one workable record before accounts can be finalised, a tax or VAT return prepared, or a loan application submitted. Done by hand, that's the better part of a day spent copy-pasting and re-aligning columns, with every manual entry a chance to introduce an error that's painful to find later.
With yearly bank statement consolidation in Smart Merge, you upload all twelve PDFs at once and get back a single, chronologically ordered Transactions sheet covering the whole year, with a Source File column on every row. Each statement is balance-validated first, so the consolidated total is trustworthy rather than hopeful.
Because the process is template-free, it's identical every period regardless of which banks a client uses — which is exactly what makes it scalable for a practice handling many clients. The same few-minute workflow clears year-end consolidation for each one, instead of every client's different bank mix becoming a bespoke manual job.
The balance chain: how Smart Merge finds a missing month
Twelve statements from one account form a chain. January's closing balance is February's opening balance, February's closing balance is March's opening balance, and so on to December. When a statement is missing from the folder, the chain breaks at exactly that point: the statement before the gap closes at one figure and the statement after it opens at another.
Smart Merge checks that chain for you. Statements are grouped by account — the IBAN or account number printed on them, and the currency — and put in date order, whatever order you uploaded them in. Then each closing balance is compared with the next opening balance. A break is reported in the merge review with both file names, so you know which month to download before anyone builds a tax return on eleven months of data.
| Statement | Opening | Closing | Chain |
|---|---|---|---|
| January | 4,120.00 | 3,860.50 | — |
| February | 3,860.50 | 5,214.75 | ✓ opens where January closed |
| April | 4,402.10 | 4,990.00 | ✗ February closed at 5,214.75 — March is missing |
| May | 4,990.00 | 6,031.20 | ✓ opens where April closed |
Figures are an illustration. Statements without a printed account number are not chained to each other, so two different accounts are never compared by mistake. More on why this happens in the missing month problem.
Three ways to combine bank statements into one Excel file
There are really only three ways to get a pile of PDF statements into one spreadsheet. You can copy and paste each statement by hand. You can use Excel's Power Query, which in Microsoft 365 can pull tables out of a PDF (Get Data › From File › From PDF) — but every bank lays its table out differently, so each statement still needs its columns renamed, split and re-aligned before the tables can be appended. Or you can let a converter read the statements and merge them for you.
The difference is not only time. Copy-paste and Power Query both trust the table as it came out of the PDF: a row that did not come across, a debit read as a credit or a month that is not in the folder all go unnoticed until the totals refuse to agree. Smart Merge checks each statement against its own printed balances before it joins the merge, and checks the chain between statements afterwards.
| Copy & paste | Power Query (From PDF) | Smart Merge | |
|---|---|---|---|
| Different banks' columns | Re-arranged by hand | Renamed per bank in each query | Matched by meaning automatically |
| Scanned statements | Retyped | Not readable as tables | Read with OCR |
| Statement balances checked | No | No | Opening + transactions = closing, per statement |
| Missing month | Found later, if at all | Found later, if at all | Flagged: closing ≠ next opening |
| Same statement uploaded twice | Double-counted | Double-counted | Flagged in the merge review |
| Where each row came from | Lost | Kept if you add it | Source File column on every row |
| A year of 12 statements | Hours | An afternoon of set-up | One upload |
How to combine a year of bank statements, step by step
- 1. Collect the PDFs. Download every monthly statement for the period from online banking — the official statement PDFs, not a filtered transaction export, because only the statement carries the opening and closing balances that prove nothing is missing. Older paper statements can be scanned flat, one statement per file. Our bank-by-bank guides show where each bank keeps them.
- 2. Upload them together. Drop the whole folder into Smart Merge. Order does not matter: statements are put in date order for you, and statements from different banks and accounts can go in the same batch.
- 3. Let each statement be read and checked. Every PDF is converted on its own first and checked against its printed balances — opening balance plus every transaction must equal the closing balance. A statement that does not close is marked, so you know before you rely on the merge.
- 4. Read the merge review. The review lists anything worth a second look: a break in the balance chain, transactions that appear identically in more than one file, rows that could not be carried across. Fix the cause — download the missing month, remove the duplicate upload — and merge again.
- 5. Download one file. Excel with one Transactions sheet and a Source File column, a CSV, or a file for your accounting software — the formats are listed below.
Merge Review: check the combined set before you download it
Clicking merge does not send you straight to a download. It opens Merge Review: the combined data in an editable grid, one tab per sheet, with a quality score at the top. The score is the share of rows with nothing to check — 100 means every row is clean, and anything lower tells you how much of the set needs a look before it goes anywhere.
Cells that need attention are highlighted, and a side panel lists them one by one: click an issue and the grid jumps to that cell. Where the fix is obvious, the panel offers it — accept it with one click, or type the right value straight into the cell. Above the grid, Merge Review also lists what concerns the set as a whole: a break in the balance chain between two statements of one account, and transactions that appear identically in more than one file.
Only when you are satisfied do you export, and the export uses the corrected data. A machine does the volume; you check the exceptions, which on a clean batch takes a minute.
| What Merge Review flags | What it usually means |
|---|---|
| Missing date | A row whose date did not come through — often a continuation line read as its own row |
| Unreadable date | A fragment instead of a full date, e.g. a day without a month |
| Missing amount | A transaction row with no figure — check it against the PDF |
| Non-numeric amount | Text where a number should be, e.g. a currency sign or note caught in the cell |
| Balance chain break | One statement closes at a figure the next one does not open at — usually a missing month |
| Same transactions in two files | The same statement uploaded twice, or two exports with overlapping dates |
Different banks, different column names — one set of columns
A German statement prints Buchungstag and Betrag, a Spanish one Fecha and Importe, an American one Date, Withdrawals and Deposits. Smart Merge maps columns by what they mean, so the same kind of information lands in the same column of the merged sheet. A column that only one bank prints — a value date, a reference number, a category — is kept under its own name rather than dropped, so nothing the bank printed is lost in the merge.
| Printed on the statement | Merged column |
|---|---|
| Date · Datum · Buchungstag · Fecha · Data | Date |
| Description · Verwendungszweck · Libellé | Description |
| Debit / Credit · Soll / Haben · Withdrawals / Deposits | Debit and Credit |
| Amount · Betrag · Importe | Amount |
| Balance · Saldo · Solde | Balance |
| A column only one bank prints | Kept under its own name |
Duplicate statements and overlapping periods
The two most common merge mistakes are uploading the same statement twice — once as statement.pdf, once as statement (1).pdf — and combining two exports whose date ranges overlap. Either way, every shared transaction would be counted twice and every total afterwards would be wrong.
Smart Merge compares rows across files on date, description and amount, and on the running balance when one is printed. Transactions that appear identically in more than one file are flagged in the merge review. They are flagged rather than deleted on purpose: inside one statement, two identical rows are often genuine — the same subscription charged twice, two equal transfers on one day — and silently removing them would remove real money. You see the files involved and decide.
How many statements can you combine?
Each merge can take up to 100 files on the Pro plan and above. Every page of every statement counts towards your monthly page allowance, and every export format is included on every plan, the free one too.
| Plan | Files per merge | Pages per month |
|---|---|---|
| Free | 5 | 10 |
| Starter | 20 | 300 |
| Pro | 100 | 1,000 |
| Business | 100 | 3,000 |
| Scale | 100 | 10,000 |
| Enterprise | 100 | 25,000 |
Current prices are on the pricing page.
What you can download after the merge
The merged result downloads as an Excel workbook with one Transactions sheet, or as a CSV for any spreadsheet or import tool. For accounting software, the same merge exports as an import file for QuickBooks, Xero, DATEV, 1C, Sage, Zoho Books, NetSuite, MYOB, Wave, FreshBooks or FreeAgent, or as a bank-feed file — .QBO for QuickBooks, .QFX for Quicken, .OFX for everything else.
Need one account at a time instead? Convert a single statement with the bank statement to Excel converter or the bank statement to CSV tool.
When one combined statement file saves the most time
Handing a year to your accountant
An accountant asked for "all your bank statements for the year" usually receives twelve PDFs per account and retypes them. One workbook with a Source File column, checked statement by statement and chained month to month, is what they would build first anyway — and it arrives without the question "where is March?", because a missing month has already been flagged.
Loan, mortgage and rental applications
Lenders and landlords ask for three to twelve months of statements. Send the original PDFs as the evidence; combine them to answer the questions that follow — average monthly income, regular commitments, the largest outgoings — from one sorted sheet instead of a stack of documents.
A business with several accounts and banks
An operating account at one bank, savings at another and a card on top: transfers between them appear on both sides. Combined in one workbook with the source of every row, those internal transfers are easy to filter out, leaving the money that really came in and went out.
Catching up on months of bookkeeping
When the books are six months behind, the statements are the record of what happened. Combining them into one file and importing it into Xero or QuickBooks in one go replaces six separate imports — and the balance chain confirms that no month was skipped along the way.
Common problems when combining statements — and what to do
A statement does not balance
If opening balance plus transactions does not equal the closing balance, a row was missed, a sign was read the wrong way or a page did not come through. The review shows which statement it is; open it, correct the row in the editable preview, and the totals close again.
The chain breaks between two months
Usually a statement is simply missing from the folder. Download it and merge again. If both statements are there, check whether one of them is an interim statement covering part of a month, or a different account with a similar number.
Accounts in different currencies
Statements in different currencies can be combined into one workbook, but amounts are not converted. Each row keeps its source file, so filter by account before you total, and convert at the rate your accountant uses.
Bank and credit card statements together
You can merge both in one batch. A card payment then appears twice — as money out of the bank account and as a payment on the card — which is correct for each account but should not be counted as two expenses. Filter by source file, or see the credit card statement converter for card-only merges.
Scanned or photographed statements
Scans are read with OCR and go through the same balance check, so a misread digit shows up as a statement that does not close. Scan flat, one statement per file, at a readable resolution.
A statement is password protected
Many banks send statements as password-protected PDFs. You do not need to unlock them elsewhere first: when a file in the batch asks for a password, a password field appears on its row. Enter the password the bank gave you, click Unlock, and the statement is read and merged like the others.
The total is short after a manual merge
When statements were combined by copy-paste or a converter that loses rows at page breaks, the merged total is quietly short and nothing says so. Re-run the same statements through Smart Merge: each statement must close against its own printed balances, so the statement that lost rows is the one that does not balance.
Combining statements over the API
If statements arrive in your own system — a lending platform, a client portal, a practice tool — the same merge runs without the website. Extract each statement with the extraction endpoint, then send the extracted documents, between 2 and 100 of them, to POST /api/v1/merge. The response is the same consolidated Excel workbook: one Transactions sheet with columns matched across banks, every source row kept.
A preview mode returns the summary and the first rows of each sheet without building the file, and it is free, so you can check a batch before you pay for the workbook. The file itself is billed by pages, like every other conversion. The bank statement API guide walks through the requests, and keys are created in the dashboard — see the bank statement API page.
Who uses Smart Merge
Anyone who has to turn many statements into one spreadsheet.
Accountants
Merge a client's twelve monthly statements into one reconciliation-ready ledger in under a minute — no more retyping figures from a folder of PDFs at month-end or year-end.
Bookkeepers
Prepare one clean reconciliation file per client. Statements from every account and bank land in a single standardized transactions sheet, ready to match against the ledger.
Small businesses
Track cash flow across a current account, a savings account and a card, even when each bank formats its statement differently. One spreadsheet, one view of the money.
E-commerce businesses
Combine bank payouts and expense statements from multiple providers into one transactions sheet — perfect for bookkeeping, VAT returns and marketplace reconciliation.
Finance teams
Consolidate statements across subsidiaries, cards and accounts into one master transaction spreadsheet with totals — ready for reporting, budgeting and audit.
Auditors & lenders
Pull a year of transactions out of dozens of PDF statements into one searchable Excel, with every row traceable back to its source document for sampling and evidence.