How to Convert US Bank Statements to CSV and Excel (2026 Guide)

Why Convert US Bank Statements to CSV?

American banks — Chase, Bank of America, Wells Fargo, Citi, USAA, Capital One, and thousands of regional banks and credit unions — provide statements as PDF files. Converting to CSV enables:

• Import into QuickBooks for bank reconciliation and bookkeeping
• IRS tax preparation with categorised income and expenses
• Schedule C preparation for self-employed individuals
• Expense analysis in Excel with pivot tables and formulas
• Backup when bank feeds fail — a reliable alternative to direct bank connections

Understanding US Bank Statement Formats

Date Formats

US banks use MM/DD/YYYY or abbreviated MM/DD formats (e.g., "08/12/2022" or "08/12"). Some statements only show the month and day, with the year inferred from the statement period header. StatementKit correctly handles all US date formats.

Transaction Types

US bank statements include several country-specific transaction types:

• Zelle — Person-to-person payments, appearing as "Zelle: [recipient name]"
• ACH Deposits — Direct deposit payroll, Shopify transfers, investment payouts
• ACH Withdrawals — Pre-authorized bill payments, loan payments, subscriptions
• Wire Transfers — Domestic and international wire transactions
• Check Clearances — With check numbers (e.g., "CHECK # 191")
• Debit Card Purchases — POS transactions with merchant names

Bank-by-Bank Format Guide

Chase

America's largest bank provides statements with Date, Description, Amount, and Balance columns. Chase Online Banking provides PDF downloads from the Statements section. Chase's format is clean but includes multi-line descriptions for ACH transactions.

Bank of America

BofA statements include Date, Description, Amount, and Running Balance. Online Banking provides PDF downloads. Bank of America separates deposits and withdrawals into different sections, which StatementKit correctly combines.

Wells Fargo

Wells Fargo statements show Date, Description, Withdrawals/Debits, Deposits/Credits, and Daily Balance. Online Banking provides PDF downloads. Wells Fargo's format includes check images which StatementKit ignores, extracting only transaction data.

Citi

Citi statements include Date, Description, Debit, Credit, and Balance columns. Citi Online provides PDF downloads. Citi includes a detailed summary section with categorised spending.

USAA

USAA Federal Savings Bank statements include Date, Description, Debits, Credits, and Balance with an Activity Summary section. See our USAA conversion guide for specific details on handling their multi-line descriptions and Zelle format.

Step-by-Step: Convert Any US Bank Statement

1. Download your PDF statement from your bank's online banking portal or mobile app.
2. Upload to StatementKit — sign up for free and upload the PDF file.
3. Review the extracted transactions — verify dates, amounts, and descriptions.
4. Download as CSV or Excel — choose the format for your needs.
5. Import into your accounting software — upload to QuickBooks, Xero, FreshBooks, or Wave.

Importing Into US Accounting Software

Importing into QuickBooks Online

QuickBooks is the dominant small business accounting software in the US:

1. Go to Banking > Banking
2. Select your bank account and click Link account > Upload from file
3. Upload the CSV from StatementKit
4. Map the Date, Description, and Amount columns
5. Review and accept the imported transactions

Importing into QuickBooks Desktop

1. Go to Banking > Bank Feeds > Import Web Connect File
2. Alternatively, use File > Utilities > Import > Web Connect Files
3. Select the CSV file and map to the appropriate bank account

Importing into FreshBooks

1. Go to Expenses > Import Expenses
2. Upload the CSV file
3. Map the columns and import
4. FreshBooks will categorise common merchants automatically

IRS Tax Preparation

Schedule C (Self-Employment)

Freelancers and sole proprietors report business income and expenses on Schedule C. Having bank transactions in CSV makes it straightforward to:

• Separate business transactions from personal spending
• Categorise expenses into IRS categories (advertising, office supplies, travel, etc.)
• Calculate total business income from client payments
• Track home office expenses and mileage

1099 Income Tracking

If you receive 1099 income from multiple sources, your bank statement CSV makes it easy to cross-reference deposits against 1099 forms from clients and platforms (Shopify, PayPal, Stripe, etc.).

Estimated Quarterly Taxes

Self-employed individuals must pay estimated taxes quarterly. Having Q1-Q4 bank data in structured format helps calculate quarterly income and expenses for accurate estimated payments.

Credit Card Statements

StatementKit also works with US credit card statements. Common credit card issuers supported include:

• Chase — Sapphire, Freedom, Ink Business
• American Express — Personal and Business cards
• Capital One — Venture, Quicksilver, Savor
• Citi — Double Cash, Custom Cash, Premier
• Discover — it, Miles, Chrome

Credit card statement conversion is especially useful for tracking business expenses charged to credit cards for Schedule C reporting.

Tips for US Users

• Tax year is January to December — download all 12 monthly statements for the full tax year.
• Check for Zelle details — Zelle transfers include the recipient name in the description, which is useful for categorising personal vs business payments.
• ACH references are important — ACH deposit descriptions contain the payer identifier (employer name, Shopify, PayPal, etc.) which helps categorise income.
• Credit unions work too — Navy Federal, BECU, Pentagon FCU, and all other credit unions are supported.
• Multiple accounts? — convert each account's statement separately and combine in Excel if needed for a complete financial picture.

Related Resources

• US Bank Statement Converter — our dedicated tool page for US banks
• USAA Statement Converter — specific guide for USAA
• How to Import Bank Statements into QuickBooks
• Bank Statement to CSV — general conversion guide