Guides

Guides to statement conversion and import

How to import a CSV bank statement into QuickBooks Online (2026)

Step-by-step: format your CSV the way QuickBooks Online expects (3-column or 4-column), upload it, map the columns, and fix the most common import errors.

How to import a bank statement into Xero from a PDF

Convert a PDF bank statement into a Xero-ready CSV or OFX file and import it: column mapping, date formats, and the errors Xero shows when a file is rejected.

Convert a bank statement to QBO for QuickBooks Desktop (Web Connect)

How QBO files work, why QuickBooks Desktop rejects some of them (INTU.BID / "financial institution not supported"), and how to create a QBO file from a PDF or CSV statement.

Bank statement to Excel: the clean way (dates, numbers and balances that actually work)

Why copy-pasting a PDF statement into Excel breaks, and how to get a spreadsheet with real date cells, numeric amounts and a running balance you can pivot on.

Converting scanned or photographed bank statements (OCR) without uploading them

How OCR works on bank statements, how to get accurate results from scans and phone photos, and how Rowledger verifies OCR output against the printed balances — entirely in your browser.

Is it safe to upload bank statements to an online converter?

What actually happens to a statement you upload to a cloud converter, what the privacy policies say, what your obligations are as a bookkeeper or lender, and how to convert statements without uploading them at all.

Why a bank statement converter must reconcile (and how to check yours)

Extraction errors are silent unless something checks them. How running-balance and opening/closing reconciliation catches missing rows, wrong signs and OCR mistakes before they reach your books.

A bank statement converter built for bookkeepers: batch, QBO/OFX, and client confidentiality

How bookkeeping and accounting firms use Rowledger for catch-up work, clients without bank feeds, and closed accounts — without sending client statements to a cloud service.

Bank statement analysis for lenders and brokers: from PDF to a verified spreadsheet

How mortgage brokers, non-QM lenders and MCA underwriters turn 12–24 months of borrower statements into analysable spreadsheets — with balances verified and documents kept on-premises.

Credit card statement to Excel or CSV: charges, payments and the sign convention

Card statements have no running balance and flip the sign convention. How to convert Amex, Chase, Capital One and other card statements correctly and verify them against previous and new balance.

Import a bank statement into Wave Accounting from a PDF

Wave accepts OFX, QBO, QFX and CSV uploads for bank and credit card accounts. How to convert a PDF statement and import it into Wave without duplicates.

Fixing QuickBooks bank CSV import errors: dates, signs, duplicates and "file not readable"

A troubleshooting list for every common error when uploading bank transactions to QuickBooks Online from a CSV, with the fix for each.

Year-end catch-up bookkeeping from bank statements: a practical method

A repeatable process for rebuilding a year of books from PDF bank and card statements: collect, convert, verify, categorize, reconcile.