How to Import Bank Statements into Wave Accounting

Wave Accounting is an excellent, free tool for small business owners and freelancers. Because it is simple, it relies heavily on automated bank connections to pull in your transactions.

When those bank connections fail—or if you are setting up Wave for the first time and need to import two years of historical data from PDF bank statements—you have to use their CSV import tool.

Wave is notoriously strict about how this CSV must be formatted. This guide will walk you through preparing the file so it imports on the first try.

Why Do My Wave Imports Keep Failing?

Wave’s importer requires absolute consistency. Unlike enterprise software, Wave does not have a highly complex “mapping” screen that allows you to bend the rules. Your spreadsheet must be pristine.

Common reasons Wave rejects a CSV file include:

• You have empty rows at the bottom of your spreadsheet.
• You have commas inside your amount figures (e.g., 1,250.00).
• Your date format unexpectedly switches halfway through the file.
• You chose the wrong Date format from the dropdown during import.

Step 1: Format the Spreadsheet

Wave will only accept CSV (Comma Separated Values) files. If you have an .xlsx file, open it in Excel and “Save As” a .csv.

If you are starting from a physical paper statement or a PDF, you must first extract the data into an Excel grid. If copy-pasting doesn’t work, SmartBankStatement can parse the PDF structure for you, returning an instantly usable Excel file.

Option A: The One-Column Amount Format (Recommended)

This is the easiest format to get right.

1. Date: e.g., 2026-05-13 (YYYY-MM-DD is the safest standard, but you can use others as long as you are consistent).
2. Description: The narrative from the bank. Avoid using commas inside this text.
3. Amount: A single column.
   • Use a minus sign (-) for money leaving the account (expenses, withdrawals, fees).
   • Use a positive number for money entering the account (income, deposits, owner injection).

Option B: The Two-Column Amount Format

Some banks export CSVs with a separate Withdrawal and Deposit column. Wave allows this format as well during the mapping phase.

1. Date
2. Description
3. Deposits / Credits: Only positive numbers here (Income).
4. Withdrawals / Debits: Only positive numbers here (Expenses).

Warning for Option B: Do not put negative numbers under a “Withdrawals” column. The entire column represents money out, so 50.00 means fifty dollars were spent.

Step 2: The Import Process

With a clean CSV saved on your desktop, follow these steps inside Wave:

1. Log into your Wave Dashboard.
2. Click Accounting on the left menu, then select Transactions.
3. In the upper right corner, click the More button and select Upload a bank statement.
4. Browse your computer and select your .csv file.
5. Select the Payment Account (the bank account or credit card you are uploading data for).
6. Date format: This is crucial. Pick the exact date format that your CSV uses. If your CSV says 13/05/2026, choose DD/MM/YYYY.
7. Click Upload.
8. Wave will ask you to confirm which columns are which. Tell it where the Date, Description, and Amount columns are.
9. Click Verify. If all the rows are valid, commit the import.

Dealing with Duplicates

Wave does attempt to prevent duplicate transactions, but its safety net is primarily focused on automated bank feeds, not manual uploads.

If you accidentally upload the month of May twice via CSV, Wave will likely create duplicate transactions in your ledger. If you realize this immediately, you can delete the entire batch upload from the Transactions screen by sorting by Date Added.

To avoid this entirely, always spot-check the first and last dates of your CSV against the existing transactions in Wave before you hit “Upload.”