Practical how-tos and plain-English format comparisons for getting bank statements into your spreadsheets and accounting software.
How-to guide
A step-by-step guide to turning bank statement PDFs into a QuickBooks-ready import — QBO, CSV, or manual entry — without copy-pasting transactions.
Read guideComparison
OFX, QFX, and QBO look almost identical but import into different software. Here's what each format is, how they differ, and which one you need.
Read guideComparison
Should you export your bank statement as CSV or Excel? A practical comparison covering compatibility, formatting, formulas, and accounting imports.
Read guideHow-to guide
Three ways to turn a bank statement PDF into a clean Excel spreadsheet — and why copy-paste fails. Step-by-step, with tips for scanned statements.
Read guideHow-to guide
Get transactions into a Xero bank account using CSV or OFX — what Xero accepts, how to format the file, and how to reconcile after import.
Read guideExplainer
A QBO file is QuickBooks' Web Connect bank-import format. Learn what it contains, how to import one, the INTU.BID bank ID, and how to create a QBO.
Read guideHow-to guide
Scanned and photographed statements are images, so they need OCR. Here's how to tell if your PDF is scanned, and how to turn it into clean spreadsheet rows.
Read guideHow-to guide
Turn a bank statement PDF into a clean CSV that imports into QuickBooks, Xero, Wave, or any spreadsheet — plus the common CSV pitfalls to avoid.
Read guide