Skip to content
stmtai

Convert Bank of America statement PDFs to Excel, QuickBooks and CSV.
QuickBooks Online, Excel, Xero files from the PDF.

No password on the PDFs. On the desktop site there is a Download link on the account activity page that lets you pick a date range and a format: CSV (labelled Microsoft Excel Format), QFX for Quicken or QBO for QuickBooks.

Drop your Bank of America statement here

PDF, scan or photo. Up to 12 files at a time.

Not ready to upload your own? See a sample result

5 pages free, no account. Amounts stay in USD.

Last updated

How to download a Bank of America statement as a PDF

  1. Log in to Online Banking and go to the Accounts tab.
  2. Open the account, then click "Statements & Documents".
  3. Choose the statement period from the list. Checking, savings and cards are listed one account at a time.
  4. Click the statement to open it, then download the PDF from the viewer and save it.
  5. In the mobile app: tap the account, then "Statements & Documents", then the statement, then the share icon to save the PDF.

Then drop the file above; several months of Bank of America statements at once come back as one workbook.

Is the Bank of America PDF password-protected?

No password on the PDFs. Bank of America relies on the login instead, so the file uploads as downloaded.

What Bank of America statements look like

PDF with "Deposits and other credits", "Withdrawals and other debits", "Checks" and "Service fees" sections, each subtotalled, followed by a daily ledger balance table.

Bank of America splits the month into "Deposits and other additions", "Withdrawals and other subtractions", "Checks" and "Service fees", each with its own total that feeds the account summary box on page one. The Checks section is the one that trips people: it is a compact grid, often two sets of Date / Check # / Amount columns side by side, and a converter reading left to right will interleave them. Amounts in the withdrawals section are printed with a leading minus, so double-negating them is the other common mistake. Dates are MM/DD/YY in full. The account number is printed in full on page one under the account title, and the "Daily ledger balances" table at the end lists a balance for every day with activity. Personal statements run four to eight pages; Business Advantage statements with a lot of checks can be twenty or more, and a single PDF may hold several accounts if you have combined statements.

Why not use Bank of America's own export?

On the desktop site there is a Download link on the account activity page that lets you pick a date range and a format: CSV (labelled Microsoft Excel Format), QFX for Quicken or QBO for QuickBooks. It works, but it is the activity feed, not the statement, and the reach is limited (usually somewhere between 12 and 24 months depending on the account). The CSV has a single signed amount column, no running balance, and check numbers appear only in the description. The PDFs go back further, since Bank of America shows around 18 months of deposit statements online and lets you order older copies back to 7 years at no charge, and they carry the daily ledger balances that make a reconciliation possible.

Where Bank of America statements trip up converters

  • Checks are listed in a separate compact table with check numbers; we keep the check number in the description.
  • Amounts in the withdrawals section are printed as negatives with a leading minus; some converters double-negate them.
  • Long descriptions wrap onto a second line; we join them into one row.

Which software Bank of America customers import into

Bank of America customers most often import into QuickBooks Online, Excel, Xero.

Bank of America questions

Do the check numbers survive the conversion?

Yes. Rows from the Checks grid come out with the check number in the description, in the same date order as everything else, and the amount as a debit. If you import into QuickBooks the check number is there to match against your register.

My Bank of America PDF has checking and savings together. Can I split it?

You do not need to. Each account section has its own summary and its own daily balance table, and the converter reads them as separate accounts: the result shows one entry per account, each checked against its own beginning and ending balance, with one sheet per account in the workbook and separate QuickBooks and Xero files. If a section is missed, splitting the PDF with Print to PDF and a page range still works as a fallback.

How do I convert a Bank of America statement PDF to Excel?

Download it from Bank of America using the steps above, drop it here, and in about 10 to 40 seconds you get the table, the balance check and the Excel, CSV, QuickBooks, Xero and Tally XML downloads. The first 5 pages are free with no account.

How many Bank of America statements can I convert at once?

Up to 12 files at a time, 60 pages each. A year of monthly statements comes back as one Excel workbook with an Overview sheet showing which months balanced, a sheet per month with a Category column, and a Categories sheet totalling the year by category.

Other banks in United States

All banks and formats · See a sample result