Tutorials guides
Every Convert·Into guide filed under Tutorials, for the teams that turn statement documents into clean, reconciled data.
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.
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 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.
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.
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.
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.
Your bank statement is password protected and the converter cannot open it
Why banks password protect emailed statements, how user and owner passwords differ, and how to open and convert a statement document you hold the password for.
How to tell a scanned bank statement from a text one in five seconds
A five second test that tells you whether your bank statement is a scan or a text document, and why OCR misreads statement figures in four specific ways.
How to split shared costs from a joint account at year end
A practical method for splitting shared costs from a joint account: convert the year to a spreadsheet, tag every row, apply one split rule, and produce a settlement figure that balances.