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
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.
Keeping converted financial records defensible
A converted spreadsheet is a derivative of the statement, and its accuracy is fair game. Three practices make it defensible, and one of them requires being honest about what the balance check cannot see.
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.
QuickBooks Desktop says your QBO file is not in the right format
Web Connect import errors on .qbo files come from a short list of causes. Work through bank identifiers, repeated transaction ids, dates, OFX flavour and account mapping in order.
QuickBooks Online rejected your bank statement upload
QuickBooks Online's bank transactions upload will not read a statement document. Work out which import path you are on, then build the CSV, QBO, OFX or QFX file it will accept.
Reconciling a 1099 total against the deposits in your account
The form says one number, your account says another. Timing across the year boundary, fees netted at source and platform holdbacks account for most of the gap. Here is how to bridge it.
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.
Building a Schedule C from bank statements with no bookkeeping
Self employed with no books and a filing deadline. Here is what bank statements can carry on a Schedule C, what they structurally cannot see, and how to build the file in order.
Separating business from personal on a mixed account
Conversion is step one of a mixed-account split, not the job. The tagging pass is real work, and a control total is what tells you it was done without dropping or duplicating a row.
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.
How to trace transfers between accounts across several statements
Matching transfers across accounts is an amount and date problem rather than a text search problem. The method, a worked pair where the two figures legitimately differ, and the cases that break it.