Turning PDF statements into clean data, explained.
Field-tested workflows, security guidance and reconciliation tips for the accounting, finance and legal teams that convert bank statements at volume.
Search the guides
Bank statements for a visa application: what the caseworker is checking
A financial requirement asks whether the money is yours and reachable, and whether it was already there rather than assembled for the application. Statements answer that only if the run is complete.
Bank statements for a mortgage application: what underwriters look for
Statements get read for large unsourced deposits, returned items and recurring payments that never reached a credit report. Converting the run lets you find them before the file is queried.
Can ChatGPT convert a bank statement to Excel
An honest account of uploading a bank statement to a general assistant: where it works, where it silently drops or invents rows, and how to check the result.
Catching OCR digit errors in converted bank statements
A 1 read as a 7 does not look wrong, it only fails arithmetic. How to catch single-digit OCR errors in a converted statement, and why eyeballing cannot.
Categorising a year of spending from your bank statements
A year of transactions is too many to categorise one at a time. Categorise the merchants instead, and remove the transfers before you total anything.
Combining checking, savings and a credit card in one workbook
Merging statements is safe when the account identifier survives as a column and the credit card's signs are normalised first. Skip either and the merged file cannot be repaired from itself.
How to convert a year of bank statements into one spreadsheet
Statement periods rarely align to calendar months. The closing-to-opening balance chain across twelve files is the strongest check that the year is complete.
Converting bank statements in Excel natively: where Power Query stops
Power Query can import a text based bank statement into Excel. It cannot read a scan, it leaves wrapped descriptions and sign conventions to you, and it never tells you whether the import is complete.
Your converted statement balance does not reconcile: how to find the row
Stop re-converting and start locating. Gap arithmetic names the likely cause, then a binary search through the period isolates the offending row.
Divorce financial disclosure: three years of bank statements
Divorce disclosure normally wants the statement documents themselves. The spreadsheet is for the schedule of income, spending and balances you have to complete alongside them.
Excel Text to Columns turned your bank statement into a mess
Text to Columns scatters statement descriptions across random columns because a description has no fixed delimiter. Here is the reason, and what to use instead.
Filing taxes when bank statements are all you have
Statements are a spine, not a set of books. They evidence every amount that moved through the account and are blind to cash, to spending on other cards, and to anything that never touched the bank.
Finding every recurring subscription in your bank statement
Scrolling a statement finds the obvious subscriptions and misses the expensive ones. A three-pass method over thirteen months of converted rows, including the annual renewals that sit in one month of the year.
Five ways to get bank statements into a spreadsheet
Start with the bank's CSV or OFX export. Then judge the five routes from statement document to spreadsheet on which of them can check the amounts against the printed closing balance.
Free versus paid statement converters: what paying buys
Check the bank's own export first. Then the questions to put to any converter at any price: what it checks after extraction, how it does on your worst scan, what the caps are, and what it says about retention.
Generic PDF to Excel tools versus statement converters
Why a general PDF to Excel converter produces a plausible but unverifiable spreadsheet from a bank statement, and what statement-aware extraction does instead.
How to verify a converted bank statement in four checks
The balance chain, the credit and debit subtotals, the row count and the date range: four checks that catch the errors most likely to reach your ledger.
Importing bank statements into a budgeting app by hand
Your budgeting app cannot link to your bank, so you import a file instead. The column shape to build, the sign convention that ruins the import, and what the post-import balance check can and cannot tell you.