Convert Bank CSV to Wave Format Instantly

Why Your Bank CSV Probably Won't Import Into Wave

Wave Accounting supports CSV file uploads for manual bank statement import, but there's a catch: Wave requires a very specific CSV structure that most bank exports don't match. Every bank formats its CSV exports differently — different column names, different column orders, different date formats, extra columns for balance and account numbers, and separate debit/credit columns instead of a single amount field. This means a CSV downloaded directly from your bank will almost certainly fail to import into Wave.

Our CSV to Wave converter solves this problem by auto-detecting your bank's CSV format, mapping the correct columns, and generating a new CSV file that matches Wave's exact requirements: three columns (Date, Description, Amount), proper date formatting, stripped special characters, and a single signed Amount column.

Wave's Exact CSV Import Requirements

When uploading a bank statement CSV via Banking > Connected Accounts > Upload a Statement in Wave Accounting, the file must meet these strict requirements:

• Column 1: Date — Transaction date in MM/DD/YYYY or YYYY-MM-DD format. European formats (DD/MM/YYYY, DD.MM.YYYY) are not accepted and will cause silent data corruption where day and month are swapped.
• Column 2: Description — Transaction description or payee name. Must not contain special characters like #, &, $, or * that can break Wave's CSV parser. Descriptions should be enclosed in double quotes if they contain commas.
• Column 3: Amount — Transaction amount as a decimal number. Positive values = money in (deposits/credits). Negative values = money out (withdrawals/debits). No currency symbols, no thousand separators.

That's it — three columns, no more, no less. Any extra columns (Balance, Account Number, Reference Number, Check Number, Transaction Type) must be removed before import. This converter handles all of that automatically.

Common Bank CSV Problems This Tool Fixes

Here are the most frequent issues users encounter when trying to import bank CSV files into Wave, and how this converter resolves each one:

• Separate Debit and Credit columns — Banks like Chase, Wells Fargo, and Capital One often export CSVs with separate columns for debits and credits (or withdrawals and deposits). Wave requires a single Amount column. The converter automatically merges these into one column with the correct sign convention (negative for outflows, positive for inflows).
• Wrong date format — European banks use DD/MM/YYYY, ISO banks use YYYY-MM-DD, and some banks use DD-Mon-YYYY (e.g., 15-Jan-2025). Wave only accepts MM/DD/YYYY or YYYY-MM-DD. The converter detects the source date format and normalizes all dates to your chosen format.
• Extra columns — Most bank CSVs include 5–15 columns (Date, Description, Debit, Credit, Balance, Account, Reference, Category, etc.). Wave only accepts three columns. The converter strips all extra columns and keeps only Date, Description, and Amount.
• Currency symbols and thousand separators — Many banks export amounts with $ signs, commas (1,500.00), or parentheses for negatives ((500.00)). Wave expects plain decimal numbers. The converter strips all formatting characters and normalizes amounts to plain decimals.
• Special characters in descriptions — Bank transaction descriptions often contain characters like #, &, *, and @ that Wave's CSV parser cannot handle. The converter automatically strips or replaces these characters to ensure clean imports.
• Header row mismatches — Wave expects the first row to contain column headers it can recognize. If your bank uses non-standard headers like “Trans. Date”, “Memo”, or “Withdrawal” instead of “Date”, “Description”, “Amount”, the import will fail. The converter generates the exact headers Wave expects.

Bank CSV Formats We Handle

Different banks export CSV files in wildly different formats. Our auto-detection engine handles the most common bank CSV structures, including:

• Chase — Details,Posting Date,Description,Amount,Type,Balance,Check or Slip#
• Bank of America — Date,Description,Amount,Running Bal.
• Wells Fargo — Date,Amount,*,*,Description (fixed-width 5 columns)
• Capital One — Transaction Date,Posted Date,Card No.,Description,Category,Debit,Credit
• Citi — Status,Date,Description,Debit,Credit
• US Bank — Date,Transaction,Name,Memo,Amount
• PNC — Date,Description,Withdrawals,Deposits,Balance
• TD Bank — Date,Activity,Amount,Balance

If the auto-detection engine doesn't recognize your bank's format, you can manually map columns using the interactive column selector. Simply tell the tool which columns contain the date, description, and amount, and it will handle the rest.

Tips for a Clean Wave CSV Import

1. Keep files under 500 transactions — Wave recommends a maximum of 500 transactions per CSV upload. If your bank export covers a long period, split it into monthly or quarterly files.
2. Avoid overlapping date ranges — Wave does not deduplicate CSV imports. If you upload two files with overlapping dates, you'll get duplicate transactions. Use our Duplicate Transaction Detector to check before importing.
3. Verify amounts after import — After importing into Wave, check the running balance in the bank account register. If amounts are inverted (expenses showing as deposits), re-convert with the opposite sign convention.
4. Use the correct Wave account — When uploading the CSV in Wave, make sure you select the correct bank account. Each CSV should correspond to a single bank account.

Related Free Accounting Tools

The CSV to Wave converter is part of PrimeConnect's complete suite of free financial file conversion and accounting utility tools:

• CSV to IIF Converter — Convert bank CSV files to QuickBooks Desktop IIF format.
• CSV to QBO Converter — Convert bank CSV files to QBO Web Connect format.
• QBO to IIF Converter — Convert QBO/OFX files to QuickBooks Desktop IIF format.
• IIF to QBO Converter — Upgrade legacy IIF files to QBO/OFX format.
• PDF to QBO Converter — Convert PDF bank statements to QBO, CSV, or IIF.
• OFX to QBO Converter — Convert OFX bank statements to QuickBooks QBO format.
• QFX to QBO Converter — Convert Quicken QFX files to QuickBooks QBO format.
• QBO to CSV Converter — Export QBO transaction files to CSV spreadsheets.
• OFX to CSV Converter — Convert OFX bank files to CSV for Excel and Google Sheets.
• OFX to IIF Converter — Convert OFX files to QuickBooks Desktop IIF format.
• CSV to OFX Converter — Transform bank CSV exports into standard OFX format.
• QIF to QBO Converter — Upgrade legacy Quicken QIF files to QBO format.
• QBO to PDF Converter — Generate professional PDF statements from QBO files.
• MT940 to QBO Converter — Convert SWIFT MT940 bank statements to QBO format.
• QIF to CSV Converter — Convert Quicken QIF files to CSV spreadsheets.
• QIF to IIF Converter — Convert QIF files to QuickBooks Desktop IIF format.
• IIF to CSV Converter — Export IIF files to CSV for spreadsheet editing.
• QBO to OFX Converter — Convert QBO files to standard OFX format.
• MT940 to CSV Converter — Convert SWIFT MT940 statements to CSV spreadsheets.
• XLSX to QBO Converter — Convert Excel spreadsheets to QBO Web Connect format.
• CAMT.053 to QBO Converter — Convert ISO 20022 XML bank statements to QBO format.
• Stripe to QuickBooks Converter — Convert Stripe payment exports to QuickBooks format.
• PayPal to QuickBooks Converter — Convert PayPal activity exports to QuickBooks format.
• Square to QuickBooks Converter — Convert Square POS exports to QuickBooks format.
• Amazon to QuickBooks Converter — Convert Amazon Seller reports to QuickBooks format.
• Shopify to QuickBooks Converter — Convert Shopify payout exports to QuickBooks format.
• Etsy to QuickBooks Converter — Convert Etsy seller statements to QuickBooks format.
• IIF Viewer & Validator — Preview and validate IIF files before QuickBooks import.
• Chart of Accounts Generator — Generate industry-specific chart of accounts.
• Bank CSV Cleaner — Clean messy bank CSV exports for QuickBooks import.
• Import Troubleshooter — Diagnose and fix QuickBooks import errors.
• QBO File Viewer & Validator — Preview and inspect QBO files before importing.
• OFX File Viewer & Validator — Preview and inspect OFX bank statement files.
• Duplicate Transaction Detector — Find and remove duplicate transactions in your files.
• Financial File Format Detector — Identify unknown financial file formats automatically.
• QBO to Xero Converter — Convert QBO files to Xero-compatible CSV.
• OFX to Xero Converter — Convert OFX bank files to Xero-compatible CSV.
• IIF to Xero Converter — Convert IIF files to Xero-compatible CSV.
• CSV to Xero Converter — Reformat bank CSV for Xero import.
• QBO to Wave Converter — Convert QBO files to Wave CSV format.
• OFX to Wave Converter — Convert OFX bank files to Wave CSV format.
• IIF to Wave Converter — Convert IIF files to Wave CSV format.
• QBO to FreshBooks Converter — Convert QBO files to FreshBooks-compatible CSV.
• OFX to FreshBooks Converter — Convert OFX bank files to FreshBooks CSV.
• IIF to FreshBooks Converter — Convert IIF files to FreshBooks CSV.
• CSV to FreshBooks Converter — Reformat bank CSV for FreshBooks import.
• QBO to Sage Converter — Convert QBO files to Sage-compatible CSV.
• OFX to Sage Converter — Convert OFX bank files to Sage CSV.
• IIF to Sage Converter — Convert IIF files to Sage CSV.
• CSV to Sage Converter — Reformat bank CSV for Sage import.