Skip to the converter
StatementZap

Guides

How to turn a bank statement into a QBO file

Go from a CSV, Excel, or text PDF bank statement to a QuickBooks Web Connect file.

  1. 1

    Start with a statement you can read as data

    CSV and Excel work when they have a date, a description, and an amount or a debit and credit pair. A text PDF works when those same fields are text on the page. A scanned statement does not.

  2. 2

    Confirm the rows

    Check the date order, which column is the amount, and whether a positive number is money in or a charge. Bank presets cover the common Chase, Bank of America, Wells Fargo, Capital One, Amex, and Citi exports.

  3. 3

    Check the totals

    When the statement has a running balance or printed opening and closing totals, the page reports whether the rows add up. Download after that check passes, or after you understand why it does not.

  4. 4

    Download QBO and import it

    The QBO file is for QuickBooks Desktop Web Connect. Import it with File, Utilities, Import, Web Connect Files. For QuickBooks Online, download the CSV instead.

Questions

Can I make a QBO file from a PDF?

Yes, when the PDF has a text layer. Use the PDF to QBO page. A scan is not supported.