Bank of America Statement to QuickBooks: Convert a BofA PDF Statement to QBO

Convert a Bank of America PDF statement to QuickBooks. Upload your BofA statement, get a .QBO file that imports into QuickBooks Online or Desktop, totals matched.

Totals reconcile to the original QuickBooks Online and Desktop
csv / xls / xlsx → .qbo
No file handy?

No account needed for your first conversions. We never store your bank login.

QuickBooks will not import a Bank of America PDF statement as-is, whether you run QuickBooks Online or Desktop. The banking import wants a structured .qbo file, and a downloaded BofA statement is a PDF: a layout of text, not a table QuickBooks can read. The converter at the top of this page turns that PDF into a QuickBooks-ready Web Connect file so the transactions import like a normal bank feed.

Drop a Bank of America statement into the converter and you get back a .qbo file plus Excel and CSV copies, with every transaction's date, description, and amount preserved and the totals checked against the statement. Below: how BofA's statements and downloads work, when to convert instead of connecting the feed, and the exact import steps.

A real .qbo file QuickBooks accepts

Built for the CSV and Excel exports US banks and cards actually send, checked before it exports.

Reconciliation

Every total checked against your file

The converter adds up the transactions it parsed and matches that to your file total before you export, so nothing is silently dropped.

Web Connect

A genuine .qbo, not a renamed CSV

Valid OFX 1.02 with QuickBooks Web Connect headers. Online and Desktop import it as a standard bank feed.

Column mapping

Your columns mapped automatically

Date, description, and amount are detected for you, so you skip QuickBooks' strict 3-column and 4-column CSV layout.

Volume

A year of CSV files in one batch

Bulk upload for catch-up and cleanup work. Each file gets its own reconciliation check and its own exports.

Dates and amounts

Dates and amounts fixed for you

Mixed date formats, currency symbols, and stray commas that break a raw CSV import are cleaned up before the .qbo is built.

Exports

Excel and CSV in the same download

One conversion, three files: the .qbo for QuickBooks, an XLSX to review, and a CSV for everything else.

How to convert your CSV to QuickBooks

Three steps. No column-mapping wizard.

1

Upload your CSV or Excel file

Drag in a CSV, XLS, or XLSX export from your bank, credit card, or accounting tool. Any column order is fine.

2

Review the reconciled rows

Every transaction is parsed and checked against your file total. You see the rows before exporting.

3

Import into QuickBooks

Download the .qbo and import it as a Web Connect bank feed. Excel and CSV are in the same download.

Questions worth answering

The specifics that decide whether the import is clean. If your case is not here, message us in chat.

How do I download a Bank of America statement as a PDF?

Sign in at bankofamerica.com, choose the account, and open the Statements and Documents tab. Bank of America lists monthly statements as PDFs, and if you use paperless eStatements they are all stored there to download. BofA keeps statements available online for a number of years, and you can request older archived statements if you need history beyond that. Download the months you need as PDFs, then convert them.

Can I connect Bank of America to QuickBooks?

Yes, Bank of America connects to QuickBooks Online through bank feeds, and that is the right tool for ongoing activity. What the feed will not do is backfill history: a new connection typically imports only about the last 90 days, so older months, closed accounts, and the gap before you connected stay out of QuickBooks. Converting the BofA PDF statement covers exactly that history the live feed cannot reach.

Does Bank of America export to QuickBooks?

Bank of America offers a few export paths: a live QuickBooks bank-feed connection, and downloadable transaction files for a recent date range in formats like CSV. Both are limited to recent activity, and the CSV needs reformatting before QuickBooks Desktop will touch it. Converting the monthly PDF statement to a .qbo file is the path that works for any period BofA has issued, and it produces a file QuickBooks imports natively without extra cleanup.

How do I import a Bank of America statement into QuickBooks?

Convert the BofA PDF to a .qbo file in the converter above, then import it. In QuickBooks Online, go to Transactions, then Bank transactions, then Upload from file, and choose the .qbo. In QuickBooks Desktop, use File, Utilities, Import, Web Connect Files. QuickBooks asks which account the transactions belong to, then sends them to the banking review queue so you can match, categorize, and add them just like a downloaded feed.

What a Bank of America statement looks like to the converter

Bank of America statements group activity into clear sections: deposits and additions, withdrawals and subtractions, checks, and fees, each as a dated list with a description and amount, followed by a daily balance summary. The converter reads each of those activity sections and leaves out the summary tables, balance-by-day grids, and disclosure pages BofA includes, so your .qbo file holds the actual transactions and nothing else. Business and Advantage account statements both convert the same way.

How far back can I get Bank of America statements?

Bank of America keeps several years of statements available online as PDFs, far beyond the roughly 90 days a fresh QuickBooks bank feed pulls in. That gap is the reason to convert: you can open a statement from a year or more ago, convert it to QBO, and import those transactions even though the feed would never include them. For periods older than BofA's online window, request the archived statement and convert that PDF the same way.

When to convert versus connect the feed

Use the Bank of America bank feed to keep QuickBooks current with new transactions automatically. Convert the PDF statement when you need history: setting up a new QuickBooks file with prior-year activity, a catch-up period before you connected, a closed BofA account, or a stretch where the feed dropped or duplicated lines. In practice a clean BofA setup uses both, the feed for going forward and converted statements to fill in everything behind it.

Personal, business, and BofA credit card statements

The converter reads Bank of America personal checking, Business Advantage checking, and savings statements the same way, since they share the deposits, withdrawals, and daily-balance structure. Business statements tend to carry more transaction categories and ACH detail, but each line still resolves to a date, description, and amount. When a BofA statement spans linked accounts, convert it and confirm which account each section belongs to before importing, so QuickBooks posts the activity to the correct register.

What about Bank of America credit card statements?

Bank of America credit card statements convert just like bank statements. Consumer and business cards issue monthly PDF statements listing charges, payments, and credits with dates, and the converter turns that into a .qbo file you import into the matching credit card account in QuickBooks. This is the dependable way to bring in card activity for months the live card feed never connected, or to capture a closed card's final statements.

How accurate is the converted BofA file?

Accuracy decides whether a converter saves time or wastes it. Bank of America groups activity into deposits, withdrawals, checks, and fees, and a weak converter can miss a section or merge a description into the wrong column, which only surfaces when reconciliation refuses to balance. This converter sums the transactions it read and compares that total to the statement total before export, so the .qbo carries every line from the original BofA statement. You confirm the parsed deposits and withdrawals in the preview, then export knowing the figures tie out.

Convert your first file free.

Upload a CSV or Excel export, get a QuickBooks-ready .qbo back in seconds. No card to try it.

Related guides

Upload a Bank of America statement in the converter above to get a QuickBooks-ready .qbo file. You can also read how the PDF to QBO converter works, see the full steps to import bank statements into QuickBooks Online, handle Desktop with our QuickBooks Desktop conversion guide, or convert any bank statement to QuickBooks from the home page.