Skip to the converter
StatementZap

Guides

How to convert a Bank of America CSV to QBO

Read a Bank of America checking or card CSV and download a QuickBooks Web Connect file.

  1. 1

    Download the CSV that matches the account

    Checking exports are Date, Description, Amount, and Running Bal. Card exports are Posted Date, Reference Number, Payee, Address, and Amount. Purchases and withdrawals are negative.

  2. 2

    Upload it

    The checking header selects the BofA preset. The card header selects the BofA card preset and uses the posted date and the payee. The running balance on a checking file is checked against the rows.

  3. 3

    Confirm the side of each amount

    Money out is negative. A card payment that paid the balance down is positive. If a charge is positive, flip the signs before you download.

  4. 4

    Download QBO or the Online CSV

    Desktop takes the QBO file through Web Connect. QuickBooks Online takes the 3-column CSV from the same read.

Questions

Which date does the card file use?

The posted date. That is the date on the statement, not a pending authorization date.