Tutorials guides
Every Convert·Into guide filed under Tutorials, for the teams that turn statement documents into clean, reconciled data.
DR/CR suffixes, parentheses and split columns: normalizing the bank statement debit credit sign convention
Every bank encodes debits and credits differently. Here is how to convert DR/CR suffixes, parentheses and split columns into one sign convention before combining statements.
How to convert a PDF bank statement to Excel (2026 guide)
How to convert a PDF bank statement to Excel using Excel's built-in import tool and a dedicated converter, plus the balance checks that catch a misread row.
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.