---
title: "Bank Statement Extraction: How It Works and How to Automate"
description: "Bank statement extraction turns PDFs and scans into structured data. How it works, the fields you get, the checks to run and how to automate it."
url: https://www.docsumo.com/blog/bank-statement-extraction
updated: 2026-09-29
---

# Bank statement extraction: how it works, what to check and how to automate it

For lenders, underwriters, accountants and operations teams who still key bank statements by hand. It covers how extraction works, which fields and checks matter, and how to roll it out.

[Pankaj Tripathi](https://www.docsumo.com/blog-authors/pankaj-tripathi) · Updated Sep 29, 2026 · 6 min read

![Illustration of a PDF bank statement uploaded to Docsumo with the bank balance field extracted](https://www.docsumo.com/blog/images/bank-statement-extraction-hero.webp)

## Key takeaways

- **Bank statement extraction** turns PDF, scanned and photographed bank statements into structured data, covering account details, balances and every transaction line.
- **Five stages** take a statement from page to checked data. The system reads it, finds the account fields, rebuilds the transaction table, checks the math and sends unsure fields to a person.
- The hard part is the **transaction table**. Rows wrap onto two lines, tables break across pages, and every bank uses a different layout.
- Extraction isn't verification. **Balances should reconcile**, months should run on without gaps and large deposits may need a documented source before the data is used.
- With automation, people **review flagged fields instead of typing**; Docsumo reports under 5 minutes per document, down from 2+ hours.

**Bank statement extraction** turns a bank statement, whether a bank PDF, a scan or a phone photo, into structured data. That means the account details, the opening and closing balances and every transaction line. Done well, it also checks that the numbers add up and sends anything it's unsure about to a person.

## What is bank statement extraction?

A bank statement records an account over a period, usually a month. It has the account details at the top, a summary of balances and totals, and a table of every transaction. Lenders read it to confirm income and assets, accountants to reconcile the books and auditors to test transactions. Extraction turns it into rows and fields in a spreadsheet, CSV or JSON file. That file is sometimes called a bank extract. Extraction can also send the data straight to another system. The transaction table is most of the work, and most of the errors.

**Account**

| Field | Extracted value |
| --- | --- |
| Account holder | Harbor Street Bakery LLC |
| Address | 118 Harbor St, Portland, ME |
| Bank name | First Midwest Bank |
| Account number | •••• 4821 |
| Account type | Business checking |
| Statement period | 2026-07-01 → 2026-07-31 |

**Balances**

| Field | Extracted value |
| --- | --- |
| Opening balance | 42,180.55 |
| Total deposits | 88,412.10 |
| Total withdrawals | 91,686.44 |
| Closing balance | 38,906.21 |
| Transaction count | 142 |

**Transactions**

| Field | Extracted value |
| --- | --- |
| Date | 2026-07-14 |
| Description | ACH DEPOSIT STRIPE PAYOUT |
| Amount | +3,284.10 |
| Debit / credit | Credit |
| Running balance | 51,902.44 |
| Category | Card processor payout |

*A business bank statement being read: account details, balances and every transaction row land in structured fields.*

## How bank statement extraction works

Extraction runs in five stages. Each one has to work for the numbers at the end to be reliable.

Bank PDFs, Scans, Phone photos, Emailed statements → Extraction: 01 Read the page, 02 Find account fields, 03 Rebuild transactions, 04 Check the math, 05 Review unsure fields → **Excel, API or loan system**

*How a bank statement becomes structured data*

Scans and photos are straightened and cleaned first, and OCR turns the page into text. From there, the system finds the account holder, bank, account number and period from context and layout rather than a fixed template. So a statement from a bank the system has never seen doesn't need a new template built for it.

The transaction table is where most tools struggle. Descriptions that wrap onto a second line and tables that split across pages have to become one table, with one row per transaction. Until then, nothing that uses the data later can be trusted. Once that table exists, the opening balance plus deposits minus withdrawals should equal the closing balance. Each running balance should also follow from the one before. Anything that doesn't add up goes to a person with the source line shown, rather than being guessed. So does any field the system isn't confident about.

## Bank statement fields: the data you get

Fannie Mae's Selling Guide sets a useful minimum for mortgage files. That minimum covers the bank, the borrower named as account holder and at least the last four digits of the account number. It also covers the period, every deposit and withdrawal, and the ending balance. Most teams extract a little more.

| Field | Example | Used for |
| --- | --- | --- |
| Bank, account holder and address | First Midwest Bank; Harbor Street Bakery LLC; 118 Harbor St, Portland, ME | Matching the statement to the applicant or client |
| Account number and type | •••• 4821, business checking | Matching statements across months and to the application |
| Statement period | Jul 1 to Jul 31, 2026 | Checking the months are consecutive and recent |
| Balances and totals | Opening $42,180.55; deposits $88,412.10; withdrawals $91,686.44; closing $38,906.21 | Reconciling the statement and verifying assets |
| Transactions | Date, description, debit or credit, amount, running balance | Income, cash flow, reconciliation and audit sampling |
| References | Check numbers, transaction IDs, memo text | Matching payments to the books and tracing items |

Average daily balance, NSF and overdraft counts and true revenue are lender calculations, not fields to extract: they're worked out from the bank transaction data. [Bank statement analysis](https://www.docsumo.com/blog/bank-statement-analysis) shows how.

> **Docsumo for bank statements & lending**: [Bank statement extraction](https://www.docsumo.com/solutions/documents/bank-statements)
>
> Every transaction, balance and account holder field, read from PDFs and scans, with running balances checked.

## Manual vs automated bank statement extraction

Keying statements by hand is slow, and the errors hide. One wrong digit in a running balance throws off every total after it.

**Manual extraction**

- Someone retypes every transaction line into a spreadsheet
- Each bank's layout has to be learned by the person reading it
- Math errors surface late, if at all
- Volume grows only by adding staff

**Automated extraction**

- Transactions arrive as rows in minutes, whatever the bank
- New layouts are read without building a template first
- Running balances are checked on every statement
- People review only the fields that were flagged

Docsumo reports these results.

- **<5 min** per document, down from 2+ hours
- **99%** field-level accuracy on 250+ document types
- **<1 min** per complex statement at Grid Finance

## Common problems when extracting data from bank statements

Most extraction errors come from four causes. Test any tool against each one with your own statements.

### Password-protected PDFs

Some statements arrive locked with a password. Remove it, or ask for an unprotected copy, first.

### Tables that break across pages

Repeated headers, subtotals and wrapped descriptions make basic converters split or duplicate rows.

### Layouts and scan quality

Every bank has its own layout, and photos add skew and blur. A good tool flags low-confidence reads instead of guessing.

### OCR without structure

Plain OCR returns text in reading order, not a table, so a debit can land in the credit column.

**Our take.** Test on your ugliest statements before the clean ones. Try a long statement whose transaction table splits across page breaks, or a blurry phone photo taken at an angle. A scan with a stray mark across the account number works too. Any of these will tell you more about a tool than a crisp PDF from a national bank ever will. A vendor that only demos on clean samples hasn't shown you the part of the job that actually breaks.

## Checks to run on every bank statement

Extraction gives you numbers; these checks tell you whether to trust them. Most run automatically, and a person looks only at the statements that fail.

- **The statement reconciles**: Opening balance plus deposits minus withdrawals equals the closing balance, and each running balance follows from the line before.
- **Months are consecutive**: No gaps, and each closing balance is the next month's opening balance.
- **Names and account numbers match**: The same on every page and month, and on the application.
- **Statements are recent**: A Fannie Mae purchase loan needs the most recent full two months of account activity.
- **Large deposits are sourced**: Fannie Mae counts a single deposit over 50% of total monthly qualifying income as large. On a purchase, the lender documents the deposit's source if the funds go toward the down payment, closing costs or reserves.
- **A reviewer looks for edits**: Fonts, spacing or PDF properties that don't fit the bank are a reviewer's call, not something extraction proves. See [how to spot fake bank statements](https://www.docsumo.com/blog/how-to-spot-fake-bank-statements).

## Where bank statement extraction is used

**Which team are you?**

- **Mortgage lenders**: Deposits, balances and large deposits for income and asset checks, compared with pay stubs and the application. See [income verification](https://www.docsumo.com/solutions/use-cases/income-verification).
- **Small business lenders**: Monthly deposits, cash flow swings and existing loan payments for ability to repay, often spread next to the borrower's financials. See [financial spreading](https://www.docsumo.com/solutions/use-cases/financial-spreading).
- **Consumer lenders**: Income deposits and overdrafts, for creditworthiness and loan limits.
- **Accountants and bookkeepers**: Every dated transaction, to reconcile the books to the bank.
- **Auditors**: Every transaction and a reconciled balance, for completeness checks and sampling.

## How to extract data from bank statements with Docsumo

Docsumo is an intelligent document processing (IDP) platform. Its [bank statement extraction](https://www.docsumo.com/solutions/documents/bank-statements) reads any layout, so there's no template to build for each bank. For lenders, it's often one part of a wider [lending workflow](https://www.docsumo.com/solutions/intelligent-document-processing-for-lending). A rollout takes five steps.

1. **Pick one process and measure it**: Start where statements slow you down most, and record today's time per statement and error rate.
2. **Upload real statements**: PDFs and scans from your own mix of banks, or through the [API](https://www.docsumo.com/integrations). Remove passwords from protected PDFs first.
3. **Extract and check**: Docsumo reads the account details, balances and every transaction, joins tables that run across pages and checks running balances. On the Enterprise plan, cross-document validation compares the statement with the rest of the file, such as pay stubs and the application.
4. **Review what's flagged**: Fields below their confidence threshold go to your reviewers with the source line highlighted; their corrections improve the model.
5. **Send it on and keep measuring**: Download to Excel or send the data through the API and webhooks, then compare a monthly sample with manual review.

**Video**: [Bank statement extraction using Docsumo AI](https://www.youtube.com/watch?v=9tTcNZGCcrE)

What Docsumo doesn't do matters too. It doesn't make the credit decision or replace your loan origination or accounting system, and it runs in the cloud only. Comparing vendors? See our [comparison of bank statement extraction software](https://www.docsumo.com/blog/best-bank-statement-extraction-software).

## Start with the statement that breaks other tools

Bank statement extraction is easy to demo and hard to get right on real files. The test is whether transaction tables come out complete, balances reconcile and uncertain fields reach a person before the data is used. Start with one process, pilot on your messiest statements rather than your cleanest, and measure against manual review.

[Book a demo](https://www.docsumo.com/book-a-demo) with a few of your own bank statements, or [start a free trial](https://www.docsumo.com/free-trial): 14 days, up to 1,000 pages.

## Frequently asked questions

### What is bank statement extraction?

It's the process of reading a bank statement and turning it into structured data. The statement can be a bank-generated PDF, a scan or a phone photo. The data covers the account holder, account number, statement period, balances and every transaction. The output goes to a spreadsheet, a loan system or an accounting tool.

### What is a bank extract?

A bank extract is the data taken from a bank statement (the account details, balances and transaction rows) in a spreadsheet, CSV or JSON file. It's what bank statement extraction produces, and what lenders and accountants work from instead of the PDF. You get one by keying the statement into a spreadsheet or running it through extraction software. For your own accounts, many banks offer the transactions as a CSV download.

### What file formats can bank statement extraction read?

Bank-generated PDFs, scanned PDFs, image files such as JPG, PNG and TIFF, and phone photos of paper statements. Password-protected PDFs need the password removed first.

### Is bank statement OCR the same as bank statement extraction?

No. OCR turns the page image into text, and extraction goes further. It finds each field, rebuilds the transaction table row by row, and checks that the balances add up. OCR alone gives you text; extraction gives you data you can use.

### Can the same tools read credit card statements?

Yes, because a credit card statement has the same parts as a bank statement. It has account details, a billing period, a balance summary and a transaction table. Docsumo handles any document type. To check for duplicate transactions, you set up a workflow step, either an AI step or your own Python code. To get statements into a spreadsheet, see [how to convert them to Excel](https://www.docsumo.com/blog/convert-bank-statement-pdf-to-excel).

### How does extracted data get into a loan origination or accounting system?

Most tools send it through an API or webhooks, or export a spreadsheet file. Docsumo sends it through its [API and webhooks](https://www.docsumo.com/integrations), or you download it to Excel.

**Sources**

1. [Fannie Mae Selling Guide B3-4.2-01, Verification of Deposits and Assets](https://selling-guide.fanniemae.com/sel/b3-4.2-01/verification-deposits-and-assets)
2. [Fannie Mae Selling Guide B3-4.2-02, Depository Accounts](https://selling-guide.fanniemae.com/sel/b3-4.2-02/depository-accounts)

First published Jul 14, 2023. Last updated Sep 29, 2026.

**Written by** [Pankaj Tripathi](https://www.docsumo.com/blog-authors/pankaj-tripathi) · Content Marketing Manager, Docsumo

Helping enterprises capture data for analytics and decisioning

[LinkedIn](https://www.linkedin.com/in/pankaj-tripathi/) · [All posts by Pankaj](https://www.docsumo.com/blog-authors/pankaj-tripathi)

- [ACORD 126 form: the general liability section, fields and checks](https://www.docsumo.com/blog/acord-126-processing)
- [ACORD 26 policy certification log: what it is and how to automate it](https://www.docsumo.com/blog/acord-26-processing)
- [Financial statement spreading: what it is, how it works and how to automate it](https://www.docsumo.com/blog/spreading-financial-statements)

## Keep reading

- [The 9 best bank statement extraction software, compared (2026)](https://www.docsumo.com/blog/best-bank-statement-extraction-software): These nine tools turn bank statements into structured data. We compare them on what breaks in production: layout variety, validation, low-confidence fields and where the data goes next.
- [Bank statement processing: how it works, and whether to outsource or automate it](https://www.docsumo.com/blog/bank-statement-processing): For lending, accounting and operations teams deciding how to handle bank statements: how in-house, outsourced and software processing compare, how software does the work, and the checks every processed statement should pass.
- [Debt settlement letter data extraction: fields, checks and automation](https://www.docsumo.com/blog/debt-settlement-letter-data-extraction): For debt relief and settlement operations teams: the fields to pull from every creditor's letter, the checks to run before a client accepts and a fee is earned, and how to automate the work.

[More on bank statements & lending](https://www.docsumo.com/blog#posts-lending)

## Next steps

- [Book a demo](https://www.docsumo.com/book-a-demo)
- [Get a free trial (1,000 pages)](https://www.docsumo.com/free-trial)
- [Contact sales or support](https://www.docsumo.com/contact)
- [agents.md](https://www.docsumo.com/agents.md): connect Docsumo to your AI agent with Docsumo MCP
- [llms.txt](https://www.docsumo.com/llms.txt) lists the key pages; add .md to any page's URL for its Markdown copy
