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
- Log in to Online Banking and go to the Accounts tab.
- Open the account, then click "Statements & Documents".
- Choose the statement period from the list. Checking, savings and cards are listed one account at a time.
- Click the statement to open it, then download the PDF from the viewer and save it.
- 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.
- Tally XML. TallyPrime XML export: Receipt and Payment vouchers for Alt+O import, alongside Excel, CSV, QuickBooks and Xero.
- Non-expiring pack. $19 buys 100 pages that never expire, and no statement is charged more than 15 pages.
- API and email-in. REST API and email-in on every plan, including the free one.
- Your file. Deletion of your file starts when processing ends; results are kept 7 days with an account, 1 day without.
- Balance check. There is no per-bank template: every row is added up against the opening and closing balances printed on the statement, and a misread is flagged, not hidden. How the balance check works
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.