Guides
Guides for working with bank statements
Short, plain guides on the jobs around statement conversion: getting a clean file out of a PDF, getting it into QuickBooks, finding the row that breaks a balance, and knowing when a file can not be read at all. Every guide is written around the same rule we build on — a conversion is only done when the numbers add up.
How to Convert a Bank Statement PDF to CSV
A plain step-by-step guide to turning a PDF bank statement into a clean CSV file: get the right PDF, convert it, check the balance, and open the file in Excel or Google Sheets.
How to Convert a Bank Statement PDF to Excel
How to turn a PDF bank statement into a real Excel workbook — with a Summary sheet, working formulas and a balance check — and when Excel beats CSV.
How to Import Bank Statements into QuickBooks (QBO Files)
How to get PDF bank statements into QuickBooks the clean way: convert to a Web Connect (.qbo) file, upload it, and match transactions without duplicates.
OFX vs. QBO vs. QIF: Which Format Should You Download?
Three accounting file formats, three different jobs. What each one is, which programs read it, the traps in each, and a simple rule for choosing.
Why a Converted Bank Statement Does Not Balance — and How to Fix It
The six usual reasons a converted statement misses its closing balance, how the difference itself tells you which one you have, and a calm routine for fixing it.
How to Check a Converted Bank Statement Is Correct
A practical checking routine for converted statements: the balance equation, section totals, the running-balance scan, and spot checks that catch the errors totals miss.
Scanned vs. Digital Bank Statements: Why One Converts and the Other Does Not
The text layer is the whole story: what makes a PDF readable, how to tell which kind you have in ten seconds, and how to get the digital original from your bank.
How to Convert a Password-Protected Bank Statement PDF
Why banks lock statement PDFs, where the password usually comes from, how to convert a locked statement safely, and what to do when the password is lost.
How to Convert Many Bank Statements at Once (and Merge Them Cleanly)
The bookkeeper's workflow for a stack of statement PDFs: prepare the files, convert them as a batch, check each one, and merge the results into a single file.
Is It Safe to Convert Bank Statements Online? A Privacy Checklist
Bank statements are sensitive. This checklist shows what a safe converter must do — no bank logins, deletion on a timer, honest ownership — and the red flags to walk away from.
Bank-specific notes
Each bank prints its statements a little differently. Our bank pages cover where to download the PDF, what the layout looks like, and what to check after converting, for the banks our reader has been tested against.