Multi-Account Bank Statement Extraction: Methods Compared

Power Query is Excel's built-in data import feature. It can read PDFs directly and detect tables within them. This method is free if you already have a recent version of Excel.

Step-by-step: Import a PDF bank statement with Power Query

1. Open a blank Excel workbook.
2. Click the Data tab on the ribbon.
3. Click Get Data → From File → From PDF.
4. Browse to your bank statement PDF, select it, and click Import.
5. The Navigator window opens, showing a list of detected tables and pages from the PDF. Each table will be named something like Table001 (Page 1), Table002 (Page 2), etc.
6. Click each table name to preview its contents on the right side.
7. For multi-account statements, identify which tables contain transaction data (you will likely see multiple separate tables, one per page or one per account section).
8. Check the box Select multiple items at the top, then check each transaction table you want to import.
9. Click Transform Data to open Power Query Editor for cleanup, or Load to import directly without cleanup.

What goes wrong with multi-account statements specifically

Here is where multi-account statements break Power Query:

Account boundaries are not preserved. Power Query detects tables by structure, so a multi-account statement will produce 4-12 separate tables (one per page section, often) without any indication of which account each one belongs to. You'll see Table001, Table002, Table003 with no labels telling you which is checking and which is savings.

Header and footer rows pollute the data. Each detected table will likely include rows like "Account Summary," "Beginning Balance," and "Ending Balance" mixed in with actual transactions. You'll need to filter these out manually in Power Query Editor.

Multi-page tables split mid-transaction. If a single account's transaction list spans pages, Power Query may split it across multiple table imports, sometimes mid-transaction. You'll need to use Append Queries to combine them back together.

Balance verification is impossible without manual work. Power Query has no built-in balance reconciliation. After cleaning up the data, you'll need to manually verify that each account's beginning balance + transactions = ending balance.

Cleanup steps required after import

1. In Power Query Editor, identify which imported tables belong to each account by manually inspecting the data and cross-referencing with the original PDF.
2. Rename each query with the account name (e.g., Checking_Page1, Checking_Page2).
3. Use Use First Row as Headers on each query.
4. For each account, append its multi-page tables together using Append Queries.
5. Filter out rows that contain "Beginning Balance," "Ending Balance," "Total," etc.
6. Use Detect Data Type on date and amount columns (Press Ctrl+A, then Transform → Detect Data Type).
7. For each account separately, calculate sum of transactions and compare against the ending balance to verify reconciliation.
8. Click Close & Load to bring the cleaned data into worksheets.

When to use Power Query for multi-account

• You already use Power Query daily and the steps above are familiar
• The statements you process consistently have clean digital-native PDFs
• You're processing 1-3 multi-account statements per month
• You're comfortable with the per-statement cleanup time

When to skip Power Query and try another method

• You don't have Excel 365 / Excel 2021+ (the feature isn't available)
• Your statements are scanned (Power Query can't read them)
• You're processing more than 5 multi-account statements per month (cleanup time becomes prohibitive)
• You need balance validation as part of the workflow

The simplest method, and the one most people try first. Open the PDF, select transactions, paste into Excel. For multi-account statements, this method is slow but it always works because you have full control.

Step-by-step: Manual copy-paste with table selection

1. Open the bank statement PDF.
2. Identify the first account's transaction table.
3. In Adobe Reader: switch to the Selection Tool (cursor icon). Hold Alt (Windows) or Option (Mac) while drag-selecting to make a rectangular selection of just the table area.
4. In Acrobat Pro: right-click on a table and choose Copy with Formatting for cleaner output.
5. Switch to Excel. Paste into a new sheet (Ctrl+V or Cmd+V).
6. The data will paste with whatever column structure Excel can infer. Often columns are merged or split incorrectly.
7. Use Text to Columns (Data tab) to separate columns that should be split, choosing space, tab, or fixed-width as the delimiter.
8. Repeat for each account section in the PDF, pasting into separate sheets.

What goes wrong with multi-account statements specifically

Account boundaries are easy to miss. When you're scrolling through a 12-page statement to find each account section, it's easy to skip past one or duplicate transactions. There's no automated check.

Date columns lose formatting. Excel often interprets "01/15/2025" as January 15th in some cells and 1st of an unknown month in others, depending on regional settings. Dates may need manual reformatting.

Amount columns merge with descriptions. Long merchant names ("AMAZON.COM*PG7H8 12345") followed by amounts get pasted into one cell, requiring manual splitting.

Multi-line descriptions break. When a single transaction has wrapping text in the PDF, copy-paste either merges it incorrectly or splits it into multiple Excel rows.

Running balance values get treated as transaction amounts. Easy to copy the balance column and forget which one is the actual transaction amount.

Realistic time estimates

When to use manual copy-paste

• One-off statement processing (you do this rarely)
• The statement has 1-2 accounts and under 50 transactions total
• You don't have Excel 365 or Adobe Acrobat Pro
• You need full control over what gets transcribed

When to skip manual copy-paste and try another method

• You're doing this for client work where errors have cost
• Statements have 3+ accounts or 100+ transactions
• You need to process multiple statements (each one is fresh manual work)
• You need balance verification

Purpose-built tools for converting bank statements specifically. They handle multi-account splitting automatically, validate balances, and process batches of statements at once. The category includes self-serve tools (DocuClipper, Lido, SendItSheets) and enterprise platforms (Heron Data, Klippa, Docsumo, Nanonets).

How dedicated tools differ from generic methods

Account boundary detection. Dedicated tools identify account boundaries using statement structure: account headers, balance summary blocks, statement period markers, and account number changes. Each detected account becomes its own section in the output.

Per-account balance validation. The tool calculates beginning balance + transactions and compares against the stated ending balance for each account independently. Mismatches are flagged before export.

Batch processing. Upload multiple multi-account statements at once. Each one is processed independently, and the results are organized by statement and account.

Native export formats. Most dedicated tools export Excel (with separate sheets per account), CSV (with account identifier column), QBO (for QuickBooks Online), and JSON (for developers). No manual reformatting required.

Step-by-step: SendItSheets walkthrough

SendItSheets is one option in the self-serve category. Free tier includes 10 PDF pages monthly without a credit card. Paid plans start at $20/month for 250 pages. The walkthrough below shows the full workflow.

1. Sign up at senditsheets.com/signup with email (no credit card required).
2. Click Upload Bank Statements and drop your multi-account PDF (or batch of multiple statements).

3. Wait 10-30 seconds while extraction runs. Each account boundary is detected and split automatically.
4. The review view shows each account in its own section with: account name/number, statement period, beginning balance, ending balance, full transaction list, and a balance verification badge.

5. If any account fails balance verification, the affected rows are highlighted. Click any cell to edit and re-validate.
6. Click Export and choose Excel (separate sheets per account), CSV (flat with account column), QBO, or JSON.

7. Download the file and import into QuickBooks, Xero, or your accounting software.

Other dedicated tools in the same category

SendItSheets isn't the only option. Other self-serve tools targeting bookkeepers and small accounting firms include DocuClipper (more mature feature set, $39+/month), Lido (similar workflow, slightly different pricing), and Dext (broader accounting suite with statement extraction included).

Enterprise platforms like Heron Data, Klippa, Docsumo, and Nanonets target a different audience: lending firms, fintech underwriters, and large accounting departments. These tools are demo-only with no public pricing and are oversized for individual bookkeepers or small accounting firms.

When to use a dedicated extraction tool

• You process multi-account statements regularly (more than a few per month)
• You handle client work where errors have downstream cost
• You need per-account balance validation
• You handle mixed account types (checking + savings + credit card on one PDF)
• You need batch processing for catch-up or cleanup engagements

When dedicated tools may be overkill

• You process one or two statements per year (subscription cost not justified)
• The statements are simple single-account PDFs (Power Query is fine)
• You only need a one-off conversion (free online converters may suffice)