How to Import Bank of America Statements into QuickBooks

To import Bank of America statements into QuickBooks, download each statement as a PDF, convert it to a .QBO (Web Connect) file on your own computer, then import that file into the QuickBooks bank feed. You don't need to link your bank - the PDF you already have is enough.

If your Bank of America direct connection keeps dropping, you're cleaning up a prior year that's no longer available to sync, or you simply don't want to hand QuickBooks your online banking credentials, the manual route is faster and more private than people expect. Below is the exact workflow, with the Bank of America specifics that trip most people up.

Why convert a PDF instead of connecting the bank?

QuickBooks' direct Bank of America connection is convenient until it isn't. Connections expire and need re-authentication, they only reach back a limited number of days, and they route your transaction history through an aggregator. Converting the statement PDF yourself sidesteps all three problems:

• You can reach any period. Bank of America keeps PDF statements going back years. If you're catching up on bookkeeping for a closed quarter, the feed can't help - the PDF can.
• Nothing leaves your machine. No online banking password, no aggregator, no third-party storing your history.
• It works during outages. When the BofA connection in QuickBooks breaks (it happens often), a .QBO import keeps your books moving.

Step 1 - Download the statement PDF from Bank of America

Sign in to Bank of America Online Banking. Select the account, open the Statements & Documents tab, choose the statement period you need, and download it as a PDF. Repeat for each month and each account (checking, savings, and any business credit card) you keep in QuickBooks. You do not need a CSV - the standard statement PDF carries every transaction line you'll convert.

Step 2 - Convert the PDF to a .QBO (Web Connect) file

QuickBooks won't read a PDF directly. It imports bank activity from .QBO (Web Connect / OFX) or .CSV files, and .QBO is the one that flows straight into the bank feed for review and matching. So the PDF has to become a .QBO first.

This is exactly what Quill does: drop in your Bank of America statement PDF and it parses every transaction locally - date, description, amount - then exports a clean .QBO (OFX Web Connect) file ready for QuickBooks. No upload, no bank login, all on your own computer.

Because Quill reads the PDF on your machine, your Bank of America history is never sent anywhere. If your accountant prefers a spreadsheet, you can export the same parsed transactions to CSV instead.

Step 3 - Import the .QBO into QuickBooks

With the converted file in hand, the import is the same flow QuickBooks uses for a live feed:

• QuickBooks Desktop: go to File > Utilities > Import > Web Connect Files, select your .QBO, and choose the matching Bank of America account when prompted.
• QuickBooks Online: go to Transactions > Bank transactions, pick the account, click Upload from file (or Link account → upload), and select the .QBO.

The transactions land in the For Review tab exactly as a bank-feed pull would, where you accept, categorize, and match them to existing entries.

Step 4 - Categorize and reconcile

Once the transactions are in the review queue, assign each to the right account and confirm matches against invoices or bills already in QuickBooks. If you're juggling personal and business spending on the same Bank of America account, it's worth splitting that out before you import - sorting transactions into Personal and Business while you convert means QuickBooks only ever sees the business side, and your books stay clean.

Avoiding duplicate transactions

The number-one frustration with manual imports is duplicates. They appear when overlapping date ranges get imported twice and each import stamps the transactions with fresh IDs - so QuickBooks treats a line it has already seen as brand new.

The fix is stable transaction IDs. In the OFX/.QBO format, every transaction carries a FITID. If that ID is deterministic - the same input always produces the same ID - QuickBooks recognizes a re-imported transaction and skips it instead of duplicating it. Quill generates stable FITIDs for every line it exports, so you can re-run an overlapping month or re-import after a correction without flooding your books with copies. If you ever do end up with a small overlap, QuickBooks' own "exclude" option in the review queue clears the stragglers.

A note on statement gaps

Because Bank of America statements are monthly, import them in order and watch the date boundaries. Statements occasionally split a transaction across two periods based on posting date; reviewing the For Review tab month by month - rather than dumping a year in at once - makes those edge cases easy to catch. For a deeper walkthrough of the export side that applies to any bank, see our guide on exporting bank transactions to QuickBooks.