How to combine multiple bank statements into one Excel file

To combine bank statements into Excel, convert each PDF to rows, check each statement, then append the rows into a single table with a source-file column. Keep different currencies separate and reconcile each account independently. A grand total across unrelated accounts is not a balance check.

NoRekey's batch converter can produce that combined CSV or Excel file directly. This walkthrough uses synthetic statements so you can try the process without uploading a customer's records.

Try two statements first

Download the July sample PDF, August sample PDF and expected combined transactions. They describe one fictional GBP current account, not a real bank or customer.

There are three transactions per month. July closes at August's opening balance. Across both months, 1,000 + 4,300 − 1,070 = 4,230. Your combined file should contain six transaction rows; opening and closing balances are checks, not extra transactions.

Convert and merge

1. Open the bank statement converter and select both PDFs. Each file has its own progress and review result.
2. Review each result against its PDF. Check dates, descriptions and signs, even if the balances match. Two offsetting mistakes can leave the total unchanged.
3. Choose Download all → Merged into one file, then CSV or Excel. The Statement column identifies the source PDF for each row.
4. Sort the combined table by date only after checking each original statement. Keep the source column when saving a working copy.
5. Compare the six rows and totals with the expected CSV. Column ordering or filenames may differ; dates, descriptions and signed amounts are the values to compare.

Password-protected files need individual conversion so you can supply the password. In batch mode they are flagged while other files continue. The batch-conversion guide explains file limits and download options.

If you already have CSV files

Use those instead of converting PDFs unnecessarily. Make the headers and amount convention consistent, then append the rows below a single header. Add the original filename in a source column before appending. Excel's Power Query can combine files in a folder when your installed version supports that connector; inspect the preview rather than assuming every export has the same layout.

Watch for dates such as 03/08/2026: that may mean 3 August or 8 March. Use the bank's locale when interpreting the source, then export an unambiguous date such as 2026-08-03. Do not fix an already misread date merely by changing its display format.

Check these before using a year's data

Missing months. Make an account-by-month inventory. A file called “annual statements” can still omit April. The balance handoff between successive statements helps identify gaps but cannot establish that all required accounts are present.

Overlapping periods. A quarterly statement and three monthly statements can contain the same transactions. Choose which source owns each date range before combining. Equal dates and amounts alone do not prove duplication: two genuine £25 purchases may happen on the same day.

Multiple accounts. Include an account identifier as well as the filename. Preserve transfers between your own accounts until you classify them; deleting one side prematurely makes reconciliation harder.

Multiple currencies. Never add GBP and USD amounts into a single unexplained total. Maintain separate currency/account totals and agree any reporting-currency conversion with your bookkeeper.

Accounting imports. A merged spreadsheet is useful for analysis. Import each account separately into accounting software and use its required layout. NoRekey's merged download is CSV or Excel; OFX and QFX downloads remain per statement. See which format to use.

Finish with an evidence trail

Keep the PDFs, the untouched merged export and a separate working spreadsheet. The reconciliation template helps check one account at a time. If you are reconstructing a longer backlog, follow the catch-up bookkeeping sequence.

Convert your statements, preserve the source column, and make the combined file something the next person can trace back to the bank.