Exporting bank statements to Excel from a bank's website usually means downloading transaction activity, not the statement itself. Pick CSV when it is offered, because Excel opens it directly. Statements stay as PDFs. Expect the export to cover a limited history and to leave out the beginning balance and check images.
Export formats banks offer: CSV, QFX, OFX and Excel
Banks usually offer transaction downloads in a few formats: a spreadsheet file (CSV), files for personal finance or accounting software (QFX, QBO, QIF or OFX), and sometimes an Excel file. For Excel, CSV is the right pick. The software formats are built for importing into money programs, not for reading in a spreadsheet.
Chase's description of its desktop download is a useful reference for what the names mean. Its Spending Planner page lists spreadsheet (CSV), Quicken Web Connect (QFX), Quicken or Microsoft Money (QIF), and QuickBooks Web Connect (QBO). The post on downloading a Chase statement as CSV covers Chase's steps and limits.
CSV works in Excel without extra steps. Microsoft's article on importing or exporting text files says that when you open a .csv file, Excel opens it in a new workbook and uses the current default data format settings to read each column. The same article explains how to import with more control, such as keeping leading zeros on account or check numbers.
QFX and OFX files can be brought into Excel, but it takes more work than a CSV. The post on importing bank statements into Excel explains how to handle QFX or OFX files there. If a bank offers both CSV and a software format, take the CSV for a spreadsheet and keep the other for the money program it was made for.
A true Excel file (.xlsx) from a bank is less common. When a bank offers one, it behaves like a CSV that already has its columns set. Check that dates and amounts came through as dates and numbers, not text, before adding formulas.
The table below summarizes what three banks say on their own help pages, checked at the time of writing. Where a help page did not state something, the cell says so rather than guessing.
| Bank | Where the download lives | Formats the help pages name | History depth stated |
|---|---|---|---|
| Bank of America | Credit card: Online Banking, credit card account. Statements: Statements & Documents under the Accounts tab | Card transactions "for use with financial management software"; statements in PDF | Card: up to 12 months of detailed transactions. Statements: 18 months online, 7 years by request |
| TD Bank | Online Banking, synced to Quicken or QuickBooks | Direct download to Quicken or QuickBooks; statements online | Transactions: not stated. Statements: up to 7 years, issued on or after April 2010 |
| Capital One | Account page on capitalone.com; "view statements" for statements | Excel, Quicken and QuickBooks named on a small-business card page; consumer CSV not stated | Transactions: past two years on the website. Statements: up to 7 years for active accounts |
Exporting Bank of America statements to Excel
Bank of America's help pages describe two separate things: downloading credit card transactions for money software, and viewing or requesting statement PDFs. To convert a Bank of America statement to Excel, start with the transaction download where it is offered, and use the statement PDFs for periods the download does not cover.
For credit cards, Bank of America's credit card payments and statements FAQ says Online Banking lets you request up to 12 months of detailed transaction information and download transactions for use with financial management software. The FAQ does not name the file formats. Card statements are under the Statements & Documents tab on the account details page.
For deposit accounts, the bank's digital banking FAQ says statements are viewed online in PDF format and that you can view, print and download up to 18 months of statements at any time. Older copies can be requested through Statements & Documents under the Accounts tab, then Request statements, for up to seven years back. The FAQ says requested electronic statements are available 24 to 36 hours after the request and stay accessible for seven days.
That last point is easy to miss. A requested statement that is not downloaded within the week has to be requested again. When a firm asks a client to pull older Bank of America statements, ask them to save each PDF as soon as it appears.
The practical split for an Excel workbook: download whatever transactions the bank offers for the recent period, and treat statements older than that as PDFs that need converting.
Can you export TD Bank statements to Excel?
TD Bank's personal Online Banking page describes a direct download to Quicken or QuickBooks, not a spreadsheet export. To convert TD Bank statements to Excel, check what download options appear in your Online Banking, and plan to work from the statement PDFs when only the money-software route is offered.
TD's Online Banking page says customers can download TD Bank account information directly to Quicken or QuickBooks, with balances and transaction history for checking, savings and money market accounts. It does not say how far back that transaction history goes.
For statements, the same page says customers can review up to seven years of bank statements and notices, limited to online statements issued on or after April 2010. Statements and notices are organized by account and date. TD also lists alternate statement formats, including accessible PDFs and enlarged check images.
The limit to note is the format. A Quicken or QuickBooks download suits a client who uses that software. A firm that wants rows in a spreadsheet may find the statement PDFs are the more direct source. TD's page does not mention a CSV option for personal accounts, so this post does not claim one exists or does not; check the download menu in your own Online Banking session.
Downloading Capital One statements as Excel or CSV
Capital One's help pages describe viewing transactions and statements for bank accounts, and its small-business card pages mention downloads into Excel. To download a Capital One statement as Excel, look for a download option on the account page, and use the statement PDFs for older periods or when no download appears.
For checking and savings, Capital One's transaction history help page says the past transactions list shows the past two years of account activity on the website, and that statements include the past seven years of transaction history. The page describes viewing, not downloading, and names no file format.
Capital One's online bank statements help page gives the statement path: sign in, click the account, and click "view statements". It says up to seven years of statements can be viewed online for active accounts, and that online viewing requires paperless statement enrollment.
For cards, the Venture X Business card page says cardholders can download purchase records into formats including Quicken, QuickBooks and Excel. That line is on a small-business card page. The help pages read for this post do not describe the steps, or whether personal cards offer the same.
What do bank exports leave out compared with the statement PDF?
A bank export is a list of transactions for a date range. The statement PDF is a dated document for one period with a beginning balance, an ending balance, totals, fees and, at some banks, check images. Exports usually leave out the beginning balance, stop at a fixed history limit, and carry no check images.
The beginning balance is the most important gap. A statement opens with the figure carried over from last period, and adding the month's activity to it has to land on the closing figure. That arithmetic is how you know no rows are missing. An export starts with its first transaction, and without a starting figure, there is nothing to test the rows against.
History is the second gap. From the help pages above, Bank of America's card download reaches 12 months, and Capital One's website shows two years of bank account activity. Statements reach back further at all three banks, typically seven years. For an older period, the PDF is the only record available online.
Check images are the third. Statements at some banks include images of paid checks, which show the payee. An export row for a check usually shows the check number and amount. If the payee matters, the statement or the image is where to find it.
Other differences are smaller but real. Export ranges are calendar dates, while statement periods often run mid-month to mid-month. Pending items may appear in an export and later change. Transfers between accounts may be shown differently. A gap in a run of statements is easy to spot; a gap in an export is not. The post on finding missing bank statements in a run covers that check.
When a bank export is not enough for a client file
A bank export is not enough when the period is older than the bank's download history, when the account is closed, or when the client sends only PDFs. In each case, the statement PDF is the record, and the rows have to come out of the PDF rather than from a download.
Closed accounts. A client who closed an account during the year may lose online access to it. The help pages read for this post do not say how long a closed account stays visible online. Bank of America's FAQ notes that paper copies of statements can be ordered for up to seven years back, which is one route.
Older periods. A prior-year question or a multi-year review can reach back past what a transaction download covers. The statements are still available online at many banks for years after the download window has passed.
Clients who only send PDFs. Many clients will download the monthly statement because it is the obvious button, and send that. Asking them to log back in, find a different download and choose a format often costs more back-and-forth than it saves.
Many banks per client. A client with accounts at three banks means three download menus, three formats and three column layouts. Converting the statements to one column layout gives a single workbook.
For these cases, converting PDFs is the practical route. Schema CPA reads the bank and credit card statements clients upload, checks that each month's ending balance matches the next month's beginning balance, and exports the rows to Excel or CSV; the Free plan on the pricing section covers up to 100 pages a month for up to 3 clients. Firms that work in Google Sheets rather than Excel can follow the post on converting bank statements to Google Sheets.