Workbook guide

How to Combine Multiple Bank Statement PDFs into One Excel Workbook

Select multiple statement PDFs together in ExtractMint, review each file, then open “More export formats” and choose “Combined XLSX”. The download keeps each file’s extracted rows on its own sheet, alongside Summary, Issues, and Reconciliation.

Separate files, one workbook: The combined export does not detect overlapping statement periods or automatically deduplicate transactions. It does not prove that the source statements do not overlap, and it does not merge them into one deduplicated transaction list.

When a combined workbook helps

A combined workbook can keep several statement periods together for review while preserving the source-file boundaries. It is useful when you want to compare periods or hand over one workbook containing separate file results.

Confirm the account and currency for every source first. Different accounts or currencies remain separate file results; their presence in one workbook does not make their balances or totals directly comparable.

Select the PDFs and download the combined workbook

  1. Open the converter. Under “Upload a statement”, use “Drop a document or choose a file” and select the PDFs together in the file picker, or drop them together.
  2. Wait for conversion, then select each file in the results list. Compare its dates, descriptions, amounts, row count, and balance checks with the original PDF. Resolve date choices and review warnings; follow any export prompts.
  3. Confirm all intended files are in the current results list. A new file selection replaces the current results; do not rely on separate selections accumulating into one batch.
  4. Open “More export formats” and choose “Combined XLSX”. This option requires at least two converted results. The main “Download Excel” button exports the active file instead.
  5. Save the downloaded extractmint-combined-YYYY-MM-DD.xlsx file and review its sheets before using or sharing it. The date in the filename is the export date, not the statement period.

What each workbook sheet contains

  • Summary: one row per file, including filename, document kind, currency, date-range information, row count, confidence, balances, deposits, withdrawals, validation, issue count, file hash, processed timestamp, statement warnings, and source coverage.
  • Issues: validation issues across files, identified by filename, with a row number where available, severity, balance delta, expected and actual values where available, and a message.
  • Reconciliation: one row per file with date-range information, currency, row count, opening and closing balances, net change, deposits, withdrawals, transaction net, discrepancy, checked rows, issue count, validation, warnings, and source coverage.
  • One transaction sheet per converted file: named from the filename, with names adjusted for spreadsheet sheet-name rules. Columns include Date, Description, Reference, Withdrawal, Deposit, Tax, Amount, Balance, Review Status, Review Notes, Category, Confidence, Source, and Source Lines.

These shared sheets collect information about individual files. They do not perform reconciliation between files. A missing balance or unavailable check is not evidence of a matched balance.

Synthetic example: two periods remain separate

All filenames, account details, dates, descriptions, references, and amounts below are invented. Suppose fictional Fern Ledger Studio has account DEMO-4821 in MYR, with two PDFs: fern-2026-01.pdf for 1–31 January 2026 and fern-2026-02.pdf for 1–28 February 2026. These are illustrative rows, not an independently validated bank format.

Invented rows kept on separate transaction sheets; amounts are MYR
SheetDateDescription / referenceWithdrawalDepositBalance
fern-2026-012026-01-08Materials / DEMO-J180.00—920.00
fern-2026-012026-01-20Project credit / DEMO-J2—200.001,120.00
fern-2026-022026-02-06Equipment rental / DEMO-F150.00—1,070.00
fern-2026-022026-02-18Project credit / DEMO-F2—150.001,220.00

The January example has two rows: opening 1,000.00 + deposits 200.00 − withdrawals 80.00 = closing 1,120.00. The February example also has two rows: opening 1,120.00 + deposits 150.00 − withdrawals 50.00 = closing 1,220.00.

The workbook contains Summary, Issues, Reconciliation, fern-2026-01, and fern-2026-02. Summary and Reconciliation each describe the two files separately; the four transactions remain on the two file sheets. Equal adjacent closing and opening balances are useful to check, but do not prove completeness or the absence of overlap.

If a second source PDF instead repeats January transactions, those extracted rows remain in its own sheet too. The combined export does not identify or remove those repeats.

Review checklist before using the workbook

  • Account: compare the account holder and account identifier on each source PDF. A similar filename is not proof of the same account.
  • Currency: check the source currency and exported currency for each file. Keep totals in different currencies separate.
  • Statement period: compare the printed period with the exported date range and its date-range type. Check the date convention; an inferred transaction range is not necessarily the printed statement period.
  • Row counts: compare Summary with each transaction sheet and the source PDF. Check first and last transactions, page boundaries, missing rows, and descriptions split across lines.
  • Balance checks: inspect Reconciliation and Issues, compare opening + deposits − withdrawals with closing, and check available running balances. A zero discrepancy does not prove every row is correct.
  • Possible overlap: compare the source periods and boundary transactions across files. Check repeated references, dates, descriptions, and amounts against the PDFs before removing anything; similar transactions can be legitimate.

Limits and privacy when handling the workbook

Before exporting a combined workbook, make sure every filename-derived sheet name is valid and unique, including when capitalization is ignored. A source named Reconciliation.pdf can conflict with the workbook’s Reconciliation sheet; names such as summary.pdf or issues.pdf can conflict with Summary and Issues. Two filenames that differ only by capitalization can conflict, and Excel sheet names cannot begin or end with an apostrophe. Rename conflicting PDFs before exporting.

Keep this limitation in view: The combined export does not detect overlapping statement periods or automatically deduplicate transactions. It does not prove that the source statements do not overlap, and it does not merge them into one deduplicated transaction list.

Extraction can miss or split rows, misread dates or amounts, or lack usable balances, particularly with scans and unfamiliar layouts. Confidence and validation are review aids, not guarantees of accuracy or completeness. No bank-specific format has been independently validated against real statements. This workbook workflow does not establish compatibility with an accounting import.

Core statement conversion, OCR, and combined workbook generation run in your browser. The optional Ask ExtractMint assistant sends your question, filename, document details, and up to five extracted rows to the agent endpoint; a configured AI provider may receive that context. Website analytics use separate data flows. See Privacy and data flow for details.

The downloaded workbook contains financial data from every included file, plus filenames and review information. Check all sheets before sharing it, use an appropriate storage location, and review access permissions if you upload it to cloud storage or an online spreadsheet. Those services apply their own handling and retention rules. Optional OCR and PDF review caches store derived text in this browser; “Clear all local caches” clears those caches, not downloaded workbooks or copies shared elsewhere.

Open the converter