Will importing my bank statement duplicate transactions in Wave?

Wave prevents most duplicates automatically. If you import the same statement period twice, Wave usually recognizes the duplicates and skips them. Always verify transaction counts after importing.

Can I import from multiple banks into one Wave account?

Yes. You can import CSVs from as many banks as you need. Wave treats each import as a separate transaction batch, so multi-bank management is straightforward.

What's the maximum file size for Wave CSV imports?

Wave accepts most CSV files without size restrictions for typical monthly statements. If you're importing multi-year histories, consider importing in monthly batches to stay organized.

Does Wave import transaction categories automatically?

No. Wave imports transactions with dates, descriptions, and amounts only. You'll categorize them manually in Wave, which actually gives you full control over classification.

Is my bank statement data secure when I upload it to BankConv?

BankConv processes PDFs without storing them permanently. See [/security-compliance](/security-compliance) for details on data handling and security practices.

Can I import transactions in OFX or other formats directly into Wave?

Wave accepts CSV imports via its interface. For other formats like OFX, you'll need to convert first. Learn more about [OFX format](/guides/what-is-ofx-format) and when to use different bank statement formats at [PDF vs CSV vs OFX](/blog/pdf-vs-csv-vs-ofx-which-bank-statement-format-do-you-need).

What happens if my dates are in the wrong format?

Wave rejects the import or misinterprets dates, which causes transaction timing issues and reconciliation problems. Always verify date formatting before importing.

How to Import Bank Statement into Wave: PDF to CSV Guide

Introduction

Wave is free accounting software trusted by freelancers and small business owners who need lightweight financial management without subscription fees. One of Wave's practical features is its ability to import bank transactions via CSV files, which lets you keep your books synchronized with your actual account activity.

Most banks provide statements as PDF documents, which Wave cannot directly import. Converting your PDF statements to the CSV format Wave accepts is straightforward and takes just a few minutes. This guide walks you through the entire process—from converting your PDF to successfully importing transactions into Wave.

Quick Answer

To import a bank statement into Wave, you need to convert your PDF statement to CSV format with columns for Date, Description, and Amount (with negative values for debits), then use Wave's import tool at Banking → Connected Accounts → Import CSV.

Wave CSV Format Requirements

Wave has specific formatting rules for CSV imports. Deviating from these rules causes import errors or transaction misreads.

Required Columns

Wave requires three columns in this exact order:

Date - Transaction date in MM/DD/YYYY or YYYY-MM-DD format
Description - Transaction details (merchant name, reference, etc.)
Amount - Single signed column where negative values indicate debits (outgoing money) and positive values indicate credits (incoming money)

This differs from some accounting tools that use separate debit and credit columns. Wave's single-column approach simplifies reconciliation.

CSV Format Sample

Here's a properly formatted Wave CSV file:

Date,Description,Amount
01/15/2026,"Rent Payment",-1200.00
01/16/2026,"Client Invoice #1042",3500.00
01/17/2026,"Office Supplies",-84.50
01/18/2026,"Bank Transfer In",-250.00
01/19/2026,"Monthly Subscription",-49.99

Notice the format: dates use consistent MM/DD/YYYY formatting, descriptions are quoted when they contain commas, and amounts use negative signs for outgoing transactions.

Step 1: Convert Your PDF with BankConv

Most bank statements arrive as PDF files, which Wave cannot process directly. You'll need to extract the transaction data first.

BankConv is a free converter that handles PDF bank statements from 220+ banks worldwide. It automatically extracts transaction data, handles password-protected PDFs, and completes most conversions in about 30 seconds. Visit /free-tools/bank-statement-pdf-to-csv to get started.

Here's the basic process:

Upload your PDF bank statement
Select your bank from the list (or let BankConv auto-detect)
Enter your PDF password if required
Download the CSV file

BankConv outputs CSV files pre-formatted for Wave and other accounting software, so your dates and amounts should already match Wave's requirements. If you use a common bank like Chase, Bank of America, or Wells Fargo, BankConv has optimized parsers for accurate data extraction.

Step 2: Prepare Your CSV for Wave

After converting your PDF, review the CSV file before importing to catch any issues.

Open the CSV file in a spreadsheet application like Excel or Google Sheets. Check that:

Dates follow MM/DD/YYYY or YYYY-MM-DD format (no other formats)
Amount column uses negative signs for debits
Descriptions contain useful information about the transaction
No duplicate rows from overlapping statement periods
No blank rows in the middle of your data

If you see problems, make corrections in the spreadsheet and re-save as CSV. Pay special attention to date formatting—this is the most common import error.

Step 3: Import Into Wave

Once your CSV is ready, import it directly into Wave using the Banking interface.

Location: Banking → Connected Accounts → Import CSV

Follow these exact steps:

Log into your Wave account
Click Banking in the left sidebar
Select Connected Accounts
Click the Import CSV button
Choose your prepared CSV file
Review the preview to verify columns are recognized correctly
Click Import to add transactions to your account

Wave will check for duplicates automatically. If you accidentally import the same statement twice, Wave prevents duplicate entries.

Common Import Errors and Solutions

Understanding these frequent issues helps you troubleshoot quickly.

Date Format Errors

Wave only accepts MM/DD/YYYY or YYYY-MM-DD. Common formats that fail:

DD/MM/YYYY (European format)
M/D/YY (single digits without leading zeros)
Text month names like "01-Jan-2026"

Fix: Reformat your CSV's date column using your spreadsheet tool's date functions before importing.

Invalid Amount Formats

Wave expects standard decimal numbers. These formats cause errors:

$1,200.00 (currency symbols or commas)
1200 (no decimal places)
(1200) (parentheses for negatives instead of minus signs)

Fix: Strip currency symbols and ensure two decimal places. Use minus signs for debits.

Duplicate Transactions

Importing the same statement period twice creates duplicates. Wave detects some duplicates but not all.

Fix: Track which statement periods you've imported. Delete the CSV file afterward to prevent accidental re-imports.

Encoding Issues

Non-ASCII characters in descriptions sometimes cause import failures on older systems.

Fix: Use UTF-8 encoding when saving your CSV. Most modern spreadsheet tools default to this.

Tips for Regular Imports

Managing multiple imports monthly becomes routine with these practices.

Create a folder structure. Store PDFs in dated folders (2026-01, 2026-02, etc.) and archive converted CSVs. This prevents duplicate imports and helps you find previous statements quickly.

Use consistent naming. Name files "Bank-Statement-Jan-2026.pdf" rather than generic names. Clear naming reduces confusion when juggling multiple accounts.

Reconcile after importing. Compare your Wave transactions against your actual bank statement. Watch for missing transactions or amounts that don't match, which indicates conversion or import problems.

Keep passwords secure. If your bank statements are password-protected, use a password manager to store them. Never hardcode passwords in filenames or notes.

Wave vs. Other Accounting Software

Wave's CSV import approach differs from competitors. Understanding these differences helps you choose the right tool.

Feature	Wave	Others
Cost	Free	$20-100/month often
CSV Import	Yes	Yes (sometimes paid feature)
Auto-sync	Connected accounts only	Wider bank connections
CSV Format	Single amount column	Often separate debit/credit
Best for	Freelancers, small teams	Growing businesses

If you need automated bank connections beyond CSV, you might explore how to import into QuickBooks, Xero, Zoho Books, Sage, FreshBooks, or MYOB. However, for small business owners seeking simplicity without cost, Wave's manual import remains an excellent option.

(Frequently Asked Questions)