Bank of America credit card statement to Excel
Drop a Bank of America card statement and get a spreadsheet with the columns split the way the statement prints them. The file stays in your browser.
Drop your Bank of America statement here
or click to choose a file · nothing is uploaded
Import straight into accounting software
A CSV leaves you at the door of QuickBooks or Quicken; these formats walk in, with each transaction carrying an id so a re-import can't duplicate it.
QuickBooks (.qbo)Quicken (.qfx)What a Bank of America statement looks like
| Columns | Transaction Date · Posting Date · Description · Reference Number · Amount |
|---|---|
| Dates | Two — transaction date and posting date |
| Sections | Payments and Other Credits · Purchases and Adjustments · Interest Charged |
Bank of America card statements carry five columns — two dates, description, a long reference number and the amount. Five columns on a page this width means narrow gaps everywhere, so this is the layout most sensitive to column detection.
What to check afterwards
The reference number is a long digit string that sits right beside the amount. If your amounts look absurdly large, the reference number was merged into them.
Card statements carry no running balance, so the arithmetic check that verifies a bank statement cannot run here —why that matters. On scans and how nothing is uploaded: read the details.