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
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
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
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
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.
- A checking file without a Running Bal. column is still readable. Map Date, Description, and Amount if the preset does not light up.
Questions
Which date does the card file use?
The posted date. That is the date on the statement, not a pending authorization date.