Sections10
Reading time10 min
EvidenceDocument workflow

Answer in 30 seconds

Extract bank statement rows for AI bookkeeping in Dynamite Docs. Check dates, debits, credits and balances before exporting reconciliation data.

Dynamite Docs logoDynamite Docs
The handoff
BANK STATEMENT: Follow the running balanceUpload your statement. Review flagged numbers. Export for reconciliation. Illustrative example, not extracted customer data.FROM SOURCE FILE TO A RESULT YOU CAN USEBANKSTATEMENTReview workspaceFollow therunningbalance1Upload yourstatement2Review flaggednumbers3Export forreconciliation
  1. 01Upload your statement
  2. 02Review flagged numbers
  3. 03Export for reconciliation
Check opening balance Illustrative example.

Handling Indian GST documents? See Convert Indian bank statements to Excel for AI bookkeeping, or explore the India (GST) workflows.

Transaction signs, opening balances, and page breaks

  • Every financial institution lays out transaction dates, descriptions, check numbers, and balances differently.
  • Scanned paper statements have no selectable text, preventing standard copy and paste.
  • Retyping long lists of transactions often leads to small errors, like transposed digits or skipped lines, that cause balance mismatches.
  • Accountants and bookkeepers managing multiple clients have to navigate several different bank layouts every week.

How Dynamite Docs processes bank statements

01

Upload your statement

Upload a digital PDF or a scanned statement. A digital file may supply a text layer, while a scan needs visual OCR. Password-protected files must be unlocked before processing.

02

Dynamite Docs builds the transaction table

The extractor proposes dates, descriptions, deposits, withdrawals, fees, check numbers and running balances without requiring a bank-specific template.

03

Review flagged numbers

Confidence scores draw attention to unclear values or blurry scans so you can compare them with the statement before saving.

04

Export for reconciliation

Export clean data to Excel, CSV, JSON, Word, or Google Sheets to match against your general ledger entries.

Document types this workflow handles

Digital bank statement PDFse-statements downloaded from online banking
Scanned paper statementspaper records read with optical character recognition
Multi-page statementsstatements spanning multiple pages
International statementsformats from US, UK, European, Australian, and Indian banks

What gets extracted from a bank statement

Dynamite Docs logoDynamite Docs
Inside the output
BANK STATEMENT: Follow the running balanceDescription: ACH DEP PINNACLE MARKETING. Amount: $248.90. Running balance: $34,581.30. Illustrative example, not extracted customer data.RECONCILE THE SOURCE AND THE EXTRACTED REGISTERSource referencesDescriptionACH DEP PINNACLE MARKETINGAmount$248.90Running balance$34,581.30Review the registerDescriptionACH DEP PINNACLE MARKETINGAmount$248.90Running balance$34,581.30Keep transaction order
Description
ACH DEP PINNACLE MARKETING
Amount
$248.90
Running balance
$34,581.30
Check opening balance Illustrative example.

Fields are identified from each statement structure. A typical extraction provides:

Transaction date2026-07-28
DescriptionACH DEP PINNACLE MARKETING
TypeDebit
Amount$248.90
Running balance$34,581.30
ReferenceACH-48199
Opening / closing balance$14,180.20 / $40,909.01

Why accurate statement data speeds up month-end close

Dynamite Docs logoDynamite Docs
The review
BANK STATEMENT: Follow the running balanceKeep transaction order. Check opening balance. Tie to closing balance. Illustrative example, not extracted customer data.SOURCE DOCUMENTBANK STATEMENTDescriptionACH DEP PINNACLE…Amount$248.90Running balance$34,581.30Review before exportDescriptionACH DEP PINNACLEMARKETINGCompare with the source on the leftAccept after reviewCheck opening balanceOriginal stays…
Description
ACH DEP PINNACLE MARKETING
Amount
$248.90
Running balance
$34,581.30
Check opening balance Illustrative example.

A useful statement table preserves the accounting sequence alongside the visible words. Start with the statement period, account identity, opening balance and closing balance. If a page is missing, the transaction rows may look plausible while the period is incomplete. Hold the export until those document-level checks are settled.

Banks present money in several ways. Some use separate debit and credit columns. Others use one signed amount, a transaction-type marker or parentheses for withdrawals. Decide how the destination expects direction to be represented, then review reversals and refunds carefully. Turning every visible amount into a positive number destroys information that reconciliation needs.

Descriptions often wrap onto a second line, especially for card settlements, bank transfers and international payments. That continuation belongs with the transaction above unless the statement shows a new date or reference. Repeated headers, page totals and carried-forward balances are page furniture, not new activity. Remove them before counting rows.

Use the running balance as a control when the statement provides one. Take the opening balance, apply each debit and credit in order, and compare the calculated result with the printed balances. A break in the sequence can expose a dropped row, a wrong sign or an OCR digit error. It cannot prove that the matching ledger entry is correct, but it tells you whether the statement table is internally consistent.

Security and accuracy for financial statements

Bank statements contain sensitive financial information. Use the policy settings to restrict eligible providers, or run model inference on your computer with the Ollama companion on Starter, Pro and Scale. Review the selected provider's terms before processing confidential records.

A digital PDF may provide machine-readable text. Scanned statements need a vision-capable model. Both formats still require structured extraction and review because reading characters does not settle row boundaries, amount direction or page furniture.

You can review the extracted transaction records and export the accepted rows to a spreadsheet or accounting import workflow.

Questions, answered

Extraction guides

Related document workflows

From the blog

Check one statement before scaling the workflow

Upload a bank statement, review the transaction sequence and export the checked rows. Any signed-in plan can use a provider key; Pro and Scale BYOK runs do not spend PE.

Can we save optional cookies?

Essential cookies keep you signed in. With your permission, optional analytics cookies and masked session replays help us understand usage and diagnose errors. Privacy policy. Change your choice anytime in Cookie settings.