01
Infer the structure
The model separates document fields, repeating rows, totals, and notes based on the file in front of it.
How does bank statement to Excel work?
Dynamite Docs extracts transaction dates, descriptions, debits, credits, and balances from digital or scanned bank statements. Review the rows and prove the opening and closing balances before exporting to Excel.
What to expect
The result is an editable transaction table, not a completed reconciliation. Wrapped descriptions, signs, repeated headers, and running balances still need source review.
The full workflow
The output stays beside the evidence.
Check the proposed fields against the source, correct a value, then export the reviewed Excel-ready bank transactions.
Dynamite Docs- 01Select the source file
- 02Review fields and rows
- 03Download Excel-ready bank transactions
02
Correct against the source
The source remains visible while you edit cells, rename columns, inspect warnings, and mark the result reviewed.
03
Send useful data onward with Dynamite Docs
Download Excel-ready bank transactions, or move a recurring workflow into Google Sheets, Drive, webhooks, or the API.
Dynamite Docs- Account holder
- Riverbend Trading Ltd
- Account number
- XXXX 4821
- Statement period
- 01-31 Aug 2026
Choose the AI route
Bring a free provider key. Keep the review workflow.
Open AI & Processing, choose Connect Provider, and pick a provider. The setup screen links to that provider's key page. Create a free key where the provider offers one, paste it into Dynamite Docs, verify it, then select a model for the run.
Your provider key is encrypted before it is stored.
Switch between hosted, own-key, privacy-restricted, and local models.
The same source-first review screen works whichever route you choose.
Choose the page for the job using Dynamite Docs
Use Bank Statement to Excel for a downloaded PDF or clean scan that needs structured transaction rows for accounting reconciliation. Before uploading, confirm the statement currency, reporting period, page count, opening balance, and closing balance.
During review, preserve the original transaction order and identify whether the bank uses positive and negative signs or separate debit and credit columns. Recalculate the running balance from opening to closing, and verify wrapped narrations, fee lines, reversals, blank check references, and repeated page headers before exporting.
For general financial schedules or balance sheets, use PDF to Excel. When table boundaries and column recovery are the primary hurdle, use the PDF Table Extractor, or select PDF to CSV when your accounting software requires a flat import file. For multi-account monthly close cycles and recurring reconciliation, set up a saved bank-statement extraction workflow.
The 28-day Free trial includes 25 page-equivalents per month shared by hosted and own-key processing, 5 hosted pages per document, and 5 documents per day. Anonymous trials have separate daily limits.
Setup, review and export questions
Where is my bank statement processed?
Hosted and own-key AI send document content through our server to the selected provider. Browser-only storage means the original is not saved in cloud file storage. Starter and above can use the signed Ollama companion for local model inference. Signed-in results and metadata may still be saved to your account.
Can it read scanned bank statements?
Yes. Scanned PDFs and statement images are supported. Clear pages with a consistent transaction layout produce results that need less correction.
Does it keep debit and credit columns separate?
Ask for separate debit and credit columns, then verify signs and CR/DR codes against the source. AI can misread the direction, so check the proposed columns before export.
How does it handle multi-line transaction descriptions?
The selected model proposes transaction rows from the statement. Check wrapped descriptions and page breaks for split or merged rows, then correct them beside the source.
What happens if the calculated balance does not match the statement?
Recalculate opening balance plus deposits minus withdrawals and compare it with the printed closing balance. Investigate missing rows, duplicate rows and reversed signs before exporting. Extraction alone does not reconcile the account.
Can I upload a password-protected statement?
Remove password protection locally before selecting the file. Review your processing route before submitting confidential statement data.
Process the whole folder in one run.
Starter and above add stored files, batch jobs and connected exports. Email intake requires Pro or Scale. File and processing limits depend on your plan.
Compare batch plans