Convert US bank statements to Excel or CSV
Most US banks let you download recent activity as CSV, QFX or QBO, but older months exist only as PDF statements. BankConv turns those PDFs into Excel, CSV, Google Sheets, OFX or QFX, with one row per transaction, so you can import them into QuickBooks or Quicken or work in a spreadsheet.
Updated
United States banks
Not on the list? Upload the statement anyway: BankConv reads any statement's transaction table, not a fixed set of layouts.
- Chasechase.com
- Bank of Americabankofamerica.com
- Wells Fargowellsfargo.com
- Citiciti.com
- Capital Onecapitalone.com
- U.S. Bankusbank.com
- PNC Bankpnc.com
- Truisttruist.com
- TD Banktd.com
- American Expressamericanexpress.com
- Ally Bankally.com
- Navy Federal Credit Unionnavyfederal.org
- USAAusaa.com
- Citizenscitizensbank.com
- Fifth Third Bank53.com
- M&T Bankmtb.com
- Huntington Bankhuntington.com
- Regions Bankregions.com
- KeyBankkey.com
- Charles Schwab Bankschwab.com
- Mercurymercury.com
How US bank statements work
US banks give you two things: a short activity download and monthly PDF statements. The download usually comes as CSV, QFX (Quicken) or QBO (QuickBooks Web Connect) and covers only recent months.
- Recent activity: export it from the account’s activity page if the range you need is covered.
- Older months: the PDF under “Statements” or “Documents” is the only source. Banks usually keep about seven years online.
- Business accounts: statements often group transactions by type (deposits, checks, card and electronic withdrawals) rather than by date. The Chase page shows a typical example.
Software Americans import into
QuickBooks Online is the usual destination, followed by Xero, Wave and FreshBooks. All of them accept a CSV with date, description and amount. See importing into QuickBooks for the column mapping. If your software insists on OFX, or you use Quicken, download OFX or QFX from BankConv instead.
Tax preparers, landlords and mortgage lenders often just need a spreadsheet. Use Excel for review and totals, or CSV for importing.
What to check when converting
US statements are consistent, but a few details trip up imports.
| Check | Why |
|---|---|
| Dates are MM/DD | Software set to DD/MM reads 03/04 as 3 April |
| Year on each row | Many statements print MM/DD only; the year comes from the statement period |
| Signs | Withdrawals may appear in parentheses or a separate column |
| Checks | Check numbers may sit in their own section without a payee |
After converting, add up deposits and withdrawals and compare them with the summary box on page one. Beginning balance + deposits − withdrawals should equal the ending balance.
Bank-specific notes: Chase, Bank of America, Wells Fargo and Capital One.
Your first 5 pages convert free, so you can test one statement before choosing a plan on the pricing page.
United States bank statement questions
Why convert a PDF if my bank offers a CSV download?
US banks usually limit downloads to recent activity, often somewhere between 90 days and two years. For older months, closed accounts or statements a client emails you, the PDF is the only record.
Can I import the converted file into QuickBooks?
Yes. Download CSV or OFX from BankConv and upload it in QuickBooks Online under the bank account's file upload option. A CSV needs date, description and amount mapped; OFX needs no mapping. BankConv does not create QBO files, which QuickBooks Desktop needs.
My bank shows withdrawals in parentheses. Does that matter?
Check it after converting. Your accounting software needs withdrawals as negative numbers or in a separate column, so make sure amounts like (45.00) read as -45.00 before you import.