Merge multiple PDFs into one Excel
Drop up to 100 PDF invoices and bank statements. Smart Merge extracts every file, matches columns across different formats, and builds one clean, reconciled spreadsheet — no copy-paste, no errors.
Free: up to 5 files · Starter 20 · Pro & Business 100 files per merge
The end-of-month copy-paste marathon
Every accountant and finance team knows the routine. A client sends a folder of PDFs — twelve months of bank statements, a stack of supplier invoices, a few card statements from different banks. None of it is in the same format. The only way to get it into the books is to open each file, retype the numbers into a spreadsheet, and pray you did not transpose a digit somewhere along the way.
It is slow, soul-destroying work, and it is exactly where errors creep in. One mistyped amount, one missed transaction, one statement consolidated with the columns in the wrong order, and the whole reconciliation is off. For a single document the alternative — doing it by hand — only takes a few minutes. But for a hundred files, manual consolidation is hours of error-prone effort that nobody wants to do.
Smart Merge removes that work entirely. You drop the whole folder, and FlowParse extracts every file, understands what each column means, and assembles one structured Excel workbook you can actually use — sort it, filter it, pivot it, import it into your accounting software. What took an afternoon now takes a single click.
One click, one perfect spreadsheet
How Smart Merge works
Four steps from a messy folder of PDFs to one reconciled Excel.
STEP 1
Upload your PDFs
Drop up to 100 invoices and bank statements onto the batch page. Pages are counted and queued.
STEP 2
Automatic extraction
Every file is parsed with AI — header fields, line items and transactions — running in parallel.
STEP 3
Smart Merge
Click Merge. Columns are matched across formats and rows are combined into unified sheets.
STEP 4
Download one Excel
Get a single workbook: Summary, Invoice Register and Transactions, with totals and source files.
Three ways it consolidates — automatically
You never pick a mode. The Consolidation Engine detects the right approach for every document in your batch.
Invoice register
Invoices and receipts become one row each — supplier, number, date, currency, subtotal, VAT and total — exactly the purchase/sales register accountants build by hand at month-end.
Statement stack
Bank statements in the same format are stacked into one continuous transaction sheet, so twelve monthly PDFs become one clean yearly ledger with a Source File column.
Smart column matching
Statements from different banks with different column names are unified — same-meaning columns merge into one, bank-specific columns are preserved, nothing is dropped.
Different banks, different columns, one clean table
The hardest part of consolidating bank statements is that no two banks agree on what to call a column. One labels it Date, another Transaction Date, a German bank writes Datum. One statement has a single signed Amount; another splits it into Debit and Credit; a third calls the running total Balance and a fourth Running Balance.
Smart Merge reads every column and maps it to a canonical financial meaning. Same-meaning columns collapse into one — so all your dates line up in a single Date column, all descriptions in one Description column, and debit/credit pairs are reconciled into a single signed amount. Columns that are genuinely unique to one bank are kept as their own columns, so you never lose a reference number or a category that only one statement provides.
The result is one tidy Transactions sheet where row 1 might come from N26 and row 200 from Revolut, yet every value sits under the right heading. It is the difference between a spreadsheet you can pivot immediately and a jumble you would have to clean by hand.
Two statements →
N26
Date · Description · Amount · Balance
Revolut
Transaction Date · Details · Debit · Credit · Running Balance
One unified sheet
What you get: one professional workbook
Every merge produces the same clean, branded structure — ready for the books, reporting or import.
Summary sheet
Files merged, invoice and transaction counts, statement formats matched, and invoice totals by currency — your consolidation at a glance.
Invoice Register
One row per invoice: source file, supplier, number, dates, currency, subtotal, VAT and total, with a totals row at the bottom.
Transactions
Every statement's rows stacked and column-matched, each tagged with its source file, with summed amount totals.
Built for the people who consolidate
Accountants & bookkeepers
Stop copy-pasting figures from dozens of client PDFs. Drop a client's folder of invoices and bank statements, get one register and one transaction ledger ready for the books — in a click, not an afternoon.
Finance teams
Month-end and quarter-end consolidation across subsidiaries, cards and accounts. Combine statements from every bank into one reconciled workbook with totals, ready for reporting and audit.
E-commerce & marketplaces
Sellers juggling PayPal, Stripe, Amazon and bank payouts can merge every payout statement into a single transactions sheet — perfect for bookkeeping and VAT returns.
Auditors
Pull a year of transactions out of 30 PDF statements into one searchable Excel, with every row traceable back to its source document for evidence and sampling.
Accurate by design — and traceable
Consolidation is only useful if you can trust the result. Smart Merge is built so you can. Extraction uses the same engine that powers FlowParse's single-document parser, and before you merge you can open any file, review every field, and correct anything the AI got wrong. The numbers that go into the merge are the numbers you approved.
The merge step itself is deterministic. It does not guess or rewrite your data — it matches columns by rule and stacks rows verbatim. Every row in the output carries a Source File column, so you can trace any figure straight back to the PDF it came from — essential for audit, review and peace of mind. Totals are recomputed in the workbook, and a Quality Score and reconciliation checks run on top of the data so problems surface before they reach your books.
In short: AI does the tedious reading, deterministic logic does the combining, and you stay in control of the result.
Review before merge
Edit any field first
Source traceability
Every row tagged
Deterministic merge
No hallucinated data
Near-100% row fidelity: nothing gets left behind
The single biggest risk when you combine many statements is silent row loss — a converter that quietly drops a handful of transactions from each file, so the merged total looks plausible but is wrong. It's the worst kind of error, because nothing flags it: you only discover it when something won't reconcile weeks later. Smart Merge is engineered specifically to prevent it.
The extraction engine reads each statement at the document level rather than chopping a page into fragments at every subtotal or marker. Continuation rows that span a page break, sections without a repeated header, and tables that change shape mid-document are all streamed into one complete table per file instead of being abandoned. On our ten-document stress set — mixing accounts-payable ledgers, multi-currency statements, cross-border registers and travel-expense claims — that change took the merged output from a lossy subset to every single row present, with no fabricated grand-total row contaminating the data.
On top of completeness sits a balance checkon every statement — opening balance plus the transactions must equal the closing balance — so if a row really were missing or misread, the maths wouldn't add up and it's flagged for you. Completeness you can prove beats a converter that's merely “usually accurate”, because with money you don't need it to be probably right; you need to know it's right.
Merge Review: see and fix before you export
Merging no longer dumps a file straight to your downloads. When you combine a batch, Smart Merge opens a Merge Reviewstep first — an editable grid of the consolidated data with a quality score at the top and every questionable cell highlighted. A date that didn't parse cleanly, an amount that came through non-numeric, a blank where a value should be: each is flagged, listed in an issues panel, and one click jumps you to the exact cell to fix it.
That turns consolidation from an act of faith into a quick, targeted review. You don't scroll a thousand rows looking for trouble; you go straight to the handful the system isn't sure about, correct them in place, and watch the quality score update. For a bookkeeper closing a client's year or a finance team consolidating across subsidiaries, that's the difference between trusting the workbook and re-checking it by hand.
Crucially, you only export once you're satisfied. The numbers that leave Merge Review are the numbers you approved, with every row still carrying its Source Filetag so any figure traces back to the original PDF. It's the same editable-preview discipline FlowParse applies to single documents, now applied to the whole merged set.
Export the merged set to any accounting format
A consolidated workbook is most useful when it lands where your books live, so the merged set exports to nine formats from one place: clean Excel and CSV, accounting CSVs for QuickBooks, Xero, DATEV and 1С, and real .QBO/.QFX/.OFX bank-feed files.
The bank-feed files matter because they carry a transaction ID per line, so a re-import is duplicate-safe — your accounting software recognises rows it already has instead of double-posting them. That's the difference between a spreadsheet labelled “QuickBooks” and a genuine feed that imports cleanly. Every export option is presented in one block with the real software logos, so you pick the destination, not a cryptic file type.
The same export targets are available from the dashboard after a single-document conversion too, so whether you converted one statement or merged a hundred, the path into your ledger is identical. Convert once, review once, and send the result wherever your accounting actually happens.
Merging by hand vs Smart Merge
The job is the same either way — turn a folder of PDFs into one usable spreadsheet. The difference is how much of it you do, and how much can go wrong while you do it.
| Step | By hand | Smart Merge |
|---|---|---|
| Read each PDF | Open and retype every figure | AI extracts every file in parallel |
| Align column layouts | Re-map debit/credit, date and balance by hand | Canonical column matching, automatic |
| Separate invoices & statements | Sort and split manually | Routed into Invoice Register & Transactions |
| Catch duplicates | Easy to miss across overlapping files | Detected automatically |
| Confirm nothing is missing | Eyeball it and hope | Balance check per statement, flagged if off |
| Trace a figure to its source | Hunt through the original folder | Source File column on every row |
| Time for 100 files | Most of a day | Minutes |
The row that quietly matters most is “confirm nothing is missing.” By hand, that step is usually skipped — you assume the copy-paste was complete and move on. Smart Merge makes it automatic: each statement is balance-checked (opening plus transactions must equal closing), and anything that doesn't reconcile is flagged before it reaches your books. That single difference is why a merged workbook is something you can stand behind, not just something you produced faster. The full story is in how accuracy works.
How many files can I merge?
Every plan can merge — the limit is how many PDFs go into a single workbook, alongside your monthly page allowance. You can re-run a merge as often as you like within those limits.
| Plan | Files per merge | Best for |
|---|---|---|
| Free | Up to 5 | Trying it on a small batch within your monthly pages |
| Starter | Up to 20 | Freelancers and small teams |
| Pro | Up to 100 | Accountants and growing businesses |
| Business | Up to 100 | Finance teams and high volume |
Need a single file instead of a batch? Use bank statement to Excel, consolidate bank statements for a single account's year, or read about extraction accuracy and how we merge and review a batch end to end. For the full overview of every method, see the complete guide to merging bank statements.
Re-running a merge costs nothing, so it's normal to add the last few statements when they arrive and merge again — only files that finished processing are included, and each run reflects the current set. You stay within your monthly page allowance either way, because pages are counted at extraction, not at merge time; combining already-extracted files into one workbook is free and near-instant however many times you do it.
Smart Merge plans
Try it free on up to 5 files. Each plan raises the number of files you can merge into one workbook.
Free includes a taste: merge up to 5 files within your 10 pages. Upgrade for 20–100 files per merge.