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