Bank of America CSV to QBO Converter

Convert Bank of America CSV exports to QBO for QuickBooks Online. Free, instant, 100% in your browser.

100% freeNo signup neededWorks with all BofA accounts
1
2
3
Upload file

Drop your CSV file here

or click to browse

How to export from BofA and import to QuickBooks

1

Log in to BofA

Go to bankofamerica.com and select your checking, savings, or credit card account.

2

Download CSV

Statements & Documents → Download transactions → Microsoft Excel (CSV) → set date range → Download.

3

Convert to QBO

Upload the CSV above. Map: Date → Date, Description → Description, Amount → Amount.

4

Import to QuickBooks

QuickBooks Online: Banking > Upload transactions > select QBO file > choose account > confirm.

BofA CSV column mapping

BofA Checking / Savings

BofA columnMap to
DateDate
DescriptionDescription
AmountAmount

BofA Credit Card

BofA columnMap to
Posted DateDate
PayeeDescription
AmountAmount

Frequently asked questions

What columns does Bank of America CSV use?

BofA checking and savings CSV exports contain four columns: Date, Description, Amount, Running Bal. Map Date → Date, Description → Description, Amount → Amount. Ignore the Running Bal column.

What about BofA credit card CSV?

BofA credit card exports use: Posted Date, Reference Number, Payee, Address, Amount. Map Posted Date → Date, Payee → Description, Amount → Amount.

Does BofA offer direct QBO download?

Bank of America offers OFX and QFX downloads in addition to CSV. If you prefer a direct file download without conversion, look for 'Microsoft Money' or 'Quicken' in the download format options — these are OFX/QFX files that can also be converted to QBO using our OFX to QBO converter.

How do I download from Bank of America?

Log in → select your account → Statements & Documents → Download transactions → choose Microsoft Excel (CSV) → set your date range → download.

Why does my BofA CSV have extra header rows?

BofA sometimes adds 6-8 header rows of account information above the transaction data. The converter automatically skips non-data rows and detects where the actual transactions begin.