Home » Bank of America statements » To Quicken
Get the Chrome extension See sample output
Bank of America consumer statements often bundle checking, savings, and credit lines into one PDF with separate per-account sections. Bank2XL splits each section into its own sheet and reconciles each one against its own opening and closing balance.
Quicken on the import side: Quicken (versions 2020 and later) requires a registered Financial Institution ID for Web Connect files. Bank2XL ships with FID 10000 and an Intuit-compatible BID, which Quicken treats as a generic OFX-compatible source. If your version refuses, update Quicken; older versions had stricter FID validation.
| Bank of America statement input | Bank2XL QFX output |
|---|---|
| BofA Advantage Plus ****3308, monthly statement, $12,401.78 closing balance, 30 to 80 transactions a month, scanned or digital PDF. | One QFX document Quicken accepts directly, with each transaction's date, amount, description, and account type. Balance reconciliation status sits on the validation sheet of the matching Excel output if you want to double-check before importing. |
This happens when no existing Quicken account is set up to receive Web Connect imports. In Quicken, open the account, go to its settings, and change Online Services to allow Web Connect. Then retry the import.
Yes. Bank2XL detects the statement type and writes the CREDITCARDMSGSRSV1 section instead of BANKMSGSRSV1, which is what Quicken expects for credit cards. Same .qfx workflow.
Yes. Every conversion produces all formats at once: XLSX, CSV, QBO, OFX, QFX. Download whichever you need. Most users grab the QFX file for Quicken and keep the XLSX as a human-readable backup.