How to Convert a Bank of America PDF Statement to CSV or Excel
Bank of America is the one major US bank where the statements themselves expire from view. Eighteen months, then you are ordering copies.
Eighteen months, and then they are gone
Most guidance about bank statements assumes the same shape: the structured export is short, the PDF archive is long, and converting the PDFs bridges the two. For Chase and Wells Fargo that is broadly right.
Bank of America does not work that way, and it is the reason this page exists. In their own words:
"You can view, print and download up to 18 months of your statements at any time." … "We keep copies of your statements for up to 7 years." … "You can order copies of your statements beyond what is available online, up to 7 years ago."
Read that carefully, because the distinction is doing a lot of work. Seven years of statements exist. Eighteen months of them are available to you. The rest are a request, with whatever wait and whatever fee applies at the time. Check images follow the same eighteen-month rule.
So for a Bank of America customer, the deadline is real rather than theoretical. Every month, another statement drops off the end of what you can simply download. If you are going to need it, the cheapest moment to get it is now, while it is still one click away.
Quick answer: Bank of America shows 18 months of statements online, and older ones must be ordered. Download the PDFs from Statements & Documents while they are still in the window, convert them to CSV, and keep the CSV. The bank's own clock is the constraint, not the file format.
Why eighteen months is not enough
The IRS does not care what Bank of America's retention policy is. Its period of limitations runs three years as standard, six years where income is understated by more than 25%, seven years for a bad-debt or worthless-securities claim, and indefinitely where no return was filed.
The shortest of those already outruns the eighteen-month window by half. A business that receives a notice about a two-year-old return cannot download the statements for that year. It has to order them, wait, and hope the request is handled before the deadline it is working to.
The same arithmetic catches loan and SBA applications asking for two or three years of statements, catch-up bookkeeping on a period that has by definition been neglected, and any forensic or due diligence work.
The practical rule
If you bank with Bank of America and you are responsible for the books, treat the eighteen-month window as an archiving obligation rather than a feature. Pull the statements once a year, convert them, and keep both the PDF and the CSV. It costs a few minutes annually and removes an entire category of future problem.
About the transaction export
Bank of America does support downloading transaction activity for use with QuickBooks, across checking, savings, money market and credit card accounts. It requires QuickBooks 2018 or later, and QIF is treated as a legacy format.
Unusually, though, Bank of America does not publish the available export formats or any date-range limit on its public pages. Other banks state theirs plainly: Chase documents two years, Wells Fargo documents ninety days extending to eighteen months on some accounts. Bank of America documents neither.
You will find confident numbers for it elsewhere. A widely repeated "90 days" figure actually comes from Bank of America's external account aggregation feature, which is a different thing entirely and does not describe the export. We are not going to restate a limit the bank itself has never published. Sign in, try the range you need, and let the interface tell you.
Converting the statements (4 steps)
- Open Statements & Documents
Sign in, select the account, and open Statements & Documents from the account menu. Statements are listed by period. - Download the months you need
One PDF per statement period. If you are rebuilding a tax year, that is twelve files, and it is worth grabbing them in one sitting. - Upload them together
Go to reconcileiq.com/bank-statement-converter and drag the whole set into the PDF to CSV converter. They are read individually and returned as one continuous set of transactions. - Reconcile, then download
Every Bank of America statement prints a beginning and ending balance. Check the converted rows carry you from one to the other before you export. If they do, the extraction is complete.
On scanned statements: if you are working from paper, or from a client who photographed their statements on a phone, those convert too. The extraction reads the page rather than the PDF's text layer, so a scan with no embedded text is not a dead end the way it is with most converters.
What comes out
- Date — normalized to a consistent sortable format from Bank of America's MM/DD convention, which spreadsheets set to a non-US locale routinely read backwards
- Description — merchant and reference, with wrapped multi-line descriptions rejoined rather than split across rows
- Amount — correctly signed, deposits positive and withdrawals negative
- Balance — the running balance kept in its own column so it is never mistaken for a transaction
Bank of America groups transactions into labeled sections — "Deposits and other additions", "Withdrawals and other subtractions", "Checks", "Service fees" — each with its own subtotal, and a beginning and ending balance framing the whole statement. Those section subtotals are the classic thing a naive extraction picks up as transactions, which quietly inflates your totals. They are discarded, along with page numbers, repeated headers and the check-image pages at the back.
The year that is not on the row
This one is worth knowing whatever tool you use, because it fails silently and nobody notices until a tax return is wrong.
Bank of America, like most US banks, prints transaction dates on the detail rows as bare MM/DD. The year appears once, in the statement header. Extract the rows without reading the header and every transaction gets stamped with whatever year the software assumed.
For eleven statements a year that is harmless, because the assumption happens to be right. On the December-to-January statement it is not, and that is precisely the statement that straddles your fiscal year end. Transactions land in the wrong tax year, the year-end reconciliation is out by exactly those rows, and the cause is invisible in the CSV because the dates all look perfectly reasonable.
The converter takes the year from the statement header and applies it per row, rolling over correctly at the boundary. If you are checking someone else's converted file, the December and January rows are the first place to look.
Convert Your Bank of America Statement
Upload the PDF, verify the balances on screen, download clean CSV. Your first statement of up to 10 pages converts free on a new account.
Convert your PDF now for freeFrequently Asked Questions
Bank of America states that you can view, print and download up to 18 months of statements online. It keeps copies for up to seven years, but anything older than the 18-month window has to be ordered rather than downloaded. Check images are likewise available online for viewing up to 18 months.
Not the statements themselves, which are PDF. Bank of America supports downloading transaction activity for use with QuickBooks across checking, savings, money market and credit card accounts, but unlike some banks it does not publish the available formats or a date-range limit on any public page. The reliable approach is to download the PDF statements while they are inside the 18-month window and convert those.
Sign in, select the account, and open Statements & Documents. Statements are listed by period, one PDF each. This is a different screen from the account activity download where the CSV export lives, and the two have very different date ranges.
Yes. Business Advantage checking, personal checking and savings, and Bank of America credit card statements all convert. Home equity line statements are worth a mention too: they use a different layout with separate posting and transaction dates and separate debit and credit columns, which trips up simpler extraction tools.
Your first statement of up to 10 pages converts free on a new account. After that it runs on credits, with the cost shown before anything is processed. Files are uploaded and processed on our servers rather than in your browser, which is what lets scanned and photographed statements work as well as native PDFs.