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. The plain .ofx is the same file without the Intuit tag, for GnuCash, Moneydance and anything else that reads a bank feed.
QuickBooks (.qbo)Quicken (.qfx)Plain .ofxWhat 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.
How Bank of America writes its transaction lines
Five columns on a page this width means narrow gaps everywhere, and the long reference number sits directly beside the amount. If your converted amounts look absurdly large, the reference number was merged into them, and that is the first thing to check on this issuer.
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.
Where to download your Bank of America statement PDF
Statements and Documents, filtered to the card account. The card statement is a different document from the deposit account statement even though both live behind the same login.
Several cycles to combine? Merge the converted files, then check for duplicates where they overlap. Moving the result into accounting software: the QuickBooks route.
Bank of America statement questions
Which of the two dates should I use?
Transaction Date for bookkeeping, Posting Date for reconciling against the cycle. Bank of America prints both, and mixing them across a sheet is a common source of small unexplained differences.
Can I drop the reference number column?
You can, but it is what identifies a transaction in a dispute. Hide it rather than deleting it if the sheet is going somewhere else.
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.