Convert US bank statements to Excel and CSV
US banks keep statements online as PDFs for anywhere from 18 months to seven years, while their own downloads usually cover a shorter stretch. For last year's activity, a full period with its balances, or files a client emailed you, the statement is the record to work from. Find your bank below, or upload a statement now.
- Currency
- US dollars (USD)
- Date order
- Month first, MM/DD/YYYY
- Money columns
- Deposits and withdrawals
- Common imports
- QuickBooks Online, Xero
Private workspace. HTTPS upload. No credit card needed.
Banks
US banks and what their statements do
National banks 9
-
JPMorgan Chase
Up to seven years online; checking, savings and linked CDs can share one statement.
-
Bank of America
Deposits and withdrawals print in separate sections, and ordered older copies stay online for just seven days.
-
Wells Fargo
The activity download covers 90 days by default, and statements leave pending items out.
-
Citibank
Periods run 28 to 31 days, and several accounts can be grouped on one statement.
-
U.S. Bank
Enrolling in e-statements opens up to seven years, with a separate statement for each account.
-
PNC Bank
A daily balance table follows the activity; it looks like transactions but stays out of the rows.
-
Truist
Older statements carry BB&T or SunTrust layouts, and one consolidated statement can cover several accounts.
-
Capital One
Dates print without the year, and Direct accounts are combined on one statement.
-
TD Bank (US)
Debits can print with the minus at the end, as in $87.34-, which Excel reads as text.
Regional banks 6
-
Citizens Bank
Eighteen months sit in the Document Center; older statements are ordered through Contact Us.
-
Fifth Third Bank
Two years of eStatements online, with check numbers kept inside the description.
-
Huntington
The Service Center holds two years of statements and emails you as each one arrives.
-
KeyBank
Seven years in Doc Hub, each statement ending with a fees and interest section.
-
M&T Bank
Some amounts carry a trailing minus, and check images can fill whole pages.
-
Regions Bank
Check images are added at the end of online statements; bill pay memos stay with their payment.
Online banks and credit unions 5
-
Ally Bank
One monthly statement covers every Ally account, with dates printed as month and day only.
-
Chime
No paper at all: PDFs live under Documents, split into Checking, Savings and Credit Builder sections.
-
Goldman Sachs
Marcus savings statements are monthly PDFs with a short list of transfers and an Interest Paid line.
-
Navy Federal
Up to 36 months online, with checking and savings combined on one statement.
-
USAA
My Documents opens on 18 months, but its filter reaches further back.
Brokerage and business accounts 3
-
Charles Schwab
Investor Checking comes with a Schwab One brokerage statement; only cash activity belongs in a bank import.
-
Fidelity
A household statement can put a Cash Management Account, brokerage and IRA in one PDF.
-
Silicon Valley Bank
Wire details run over several lines, and account analysis statements list charges rather than transactions.
Statement layout
How US bank statements are laid out
Month first, often without the year
Dates are printed month first, and banks such as Ally and Capital One show only the month and day, leaving the year to the statement period. The converter takes the year from that period, so a December-to-January statement keeps every row in the right year.
Deposits and withdrawals, sometimes in sections
Few US statements use one amount column. Bank of America lists deposits and withdrawals in separate sections, many banks add a checks-paid list, and PNC prints a daily balance table that isn't activity at all. The rows you get have one signed amount: deposits positive, withdrawals negative.
Cycles that ignore the calendar
Chase says a period usually runs 28 to 32 days and Citi uses 28 to 31, so a March statement can start in late February. Several banks also put checking, savings and CDs on one statement; give each account its own register.
Output and review
What you get back, and what gets checked
Each statement becomes rows of date, description, amount and balance, as Excel, CSV or JSON, or as a CSV laid out for QuickBooks or Xero. Before you export, the beginning balance plus deposits minus withdrawals is compared with the ending balance. In your account, statements for the same account are lined up by date, so a missing month, an overlap or a repeat upload is flagged.
Importing into QuickBooks or Xero
-
QuickBooks Online
Upload the QuickBooks CSV to the matching bank account and confirm the date, description and amount columns. If Web Connect or Direct Connect already feeds recent months, import converted statements only for earlier dates.
-
Xero
Xero can't read a PDF statement, but its bank statement import takes CSV. Map the columns on the first file and Xero reuses that mapping for the months after it.
FAQ