LedgerMatch

Bank of America CSV Export: Column Layout & Reconciliation Guide

Bank of America's CSV starts with 3–4 lines of account metadata before the actual column headers, so most import tools misread the first real transaction as a header row and silently drop it. Descriptions are also prefixed with "DEBIT " or "CREDIT " text that makes ledger matching unreliable. This tool skips the metadata block automatically and strips the prefix so you get clean merchant names ready for QuickBooks.

CSV format at a glance

  • Date format: MM/DD/YYYY
  • Amount layout: one signed amount column
  • Negative values are debits (withdrawals). Positive values are credits (deposits).

Where to export the CSV

Sign in → Accounts → select account → Download → Comma-Separated Values (for spreadsheet)

Common import issues

  • The downloaded CSV contains 3–4 header lines of account metadata before the column headers row. Most spreadsheet apps strip these automatically, but LedgerMatch's column-mapping step handles them by letting you set the header row number.
  • BofA often prepends "DEBIT " or "CREDIT " to descriptions (e.g. "DEBIT AMAZON.COM"). Strip this prefix in the Description field to get clean merchant names.
  • International transactions include the foreign currency amount in the description — the Amount column always reflects the USD equivalent already converted.
  • ACH transfers to/from other BofA accounts show as "ONLINE TRANSFER" with no payee detail. Add a note in LedgerMatch's exception queue if these need manual matching.
  • BofA savings accounts export an identical column structure to checking accounts. If you are reconciling both, download each account separately — the files look the same but the transaction sets are different.

Useful setup tips

  • When prompted for download format, choose "Comma-Separated Values (for spreadsheet)" — not the Microsoft Money or Quicken formats.
  • Map Date → Date, Description → Description, Amount → Amount. Skip Running Bal.
  • If the import shows extra blank rows at the top, use the "Skip rows" option in LedgerMatch's column mapper to jump past the metadata header.

Explore related resources

Install LedgerMatch

Choose the browser or spreadsheet workflow that fits your team.

Add to Chrome — it’s free · Included with all plans Install Google Sheets™ add-on Install for Microsoft Edge