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
Your bank feed stopped syncing and you need to backfill by hand
A broken bank feed leaves a gap that reconnecting often will not fill. Measure the gap precisely, backfill from the statements, and handle the overlap so nothing duplicates.
Bank feeds versus statement conversion: what a feed cannot prove
Check the bank's CSV or OFX export first. Then read what a feed still cannot do: reach history before the connection, survive a closed account, or check its own amounts against the statement's balances.
Amounts import as text and SUM returns zero
A left aligned amount column that will not sum has one of four causes. Here is how to identify which one you have and the exact fix for each.
Bank statement dates import as text or in the wrong order
DD/MM or MM/DD cannot be resolved from the data alone below the 13th. Here is where the statement declares it, and how to force the correct reading in a spreadsheet.
Producing bank statements as numbered exhibits
Numbering attaches to pages or to whole documents depending on the convention in play, and never to individual transactions. How to stamp a statement bundle and carry the page reference into the converted rows.
Bank statements as proof of a deduction: payment versus purpose
Why a bank statement establishes payment but not purpose, where merchant descriptors stop being useful, and how to turn a converted statement into a checklist for the documents you are missing.
Bank statements as proof of income for a rental application
A landlord asked for three months of bank statements. Here is what to send, what is safe to redact, and the redaction that quietly destroys your own evidence.
Bank statements for a business loan: what the lender is checking
Twelve months of business statements get read for whether revenue is steady, whether the account carries a buffer, and whether another lender is already paid out of it. All three are computable before you submit.
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.