Home › Guides › Wave bank statement CSV format
Wave bank statement CSV format
Wave can import a bank or credit card CSV that has a date, a description, and an amount — either one signed Amount column or separate deposit and withdrawal columns, and no extra columns. Dates such as YYYY-MM-DD are accepted. Wave says OFX, QBO, QFX or ASO files are easier than CSV, and it does not accept PDF uploads. For credit cards, Wave wants purchases positive and payments negative, which is the opposite of CSVLedger’s card CSV export.
Updated November 10, 2026
Prefer a bank file when you can
Wave’s article “Upload a bank or credit card statement in .csv format” (updated October 28, 2026; checked November 10, 2026) says that if your bank can export Microsoft Money (.OFX), QuickBooks (.QBO), Quicken (.QFX) or Simply Accounting (.ASO), you should use one of those formats instead — they are easier to import than a CSV. CSVLedger can create a .qbo file from a PDF statement. This page covers the CSV path for when that is what you have.
Wave does not support PDF uploads. If you only have a statement PDF, convert it first.
Download a sample Wave CSV
These fictional files have only the columns Wave asks for: date, description, and amount(s). Dates are YYYY-MM-DD. The signs follow a checking account: withdrawals negative, deposits positive. They are not a real account.
Download the 3-column sample (Date, Description, Amount) Download the 4-column sample (Deposits and Withdrawals)
Date,Description,Amount
2026-10-15,Office supplies,-84.60
2026-10-16,Customer receipt,1200.00
If a two-column amount file will not upload, Wave’s troubleshooting article says to move the amounts into a single column.
Format rules from Wave’s help
- Only date, description and amount columns. More than four columns with inconsistent information can fail. Remove a running-balance column and any totals row.
- Headings belong at the top of the table, not the bottom. The description column may be empty, but if it has values they must be words, not only numbers.
- Amounts are numeric. Wave says you can use a minus sign or brackets for negatives. Currency is taken from the Wave payment account you choose, not from a symbol in the file.
- Keep one currency per file. Use a short file name if the upload fails (Wave gives examples such as
month-year-account.csv). - Credit cards: purchases positive, payments negative — confirm this in the upload preview.
Upload steps
- In Wave, go to Accounting → Transactions, then More → Upload transactions.
- Choose the file and the payment account. The statement currency should match that account. If the file has no currency codes, Wave records the transactions in the account’s currency.
- Confirm the date column (for a bank statement, Wave says to use the transaction date; for a credit card, the posting date), the amount column, and the description column, then confirm the import.
Menu labels can change; follow Wave’s current help if your screen differs. Wave also offers its own CSV template from that article if you want an in-product reference.
Convert your PDF statement for Wave
Drop a PDF into CSVLedger in your browser (the file is not uploaded). Check that the result is Reconciled. Then either download QBO (Web Connect) — the format Wave says is easier than CSV — or download QuickBooks CSV, which is a three-column Date, Description, Amount file like the sample above. Do not upload CSVLedger’s general CSV (it includes Balance and Check columns that Wave may reject).
For a credit card CSV, remember Wave’s sign rule is the opposite of CSVLedger’s card export. Reverse the signs, or use the .qbo download and check the Wave preview carefully. CSVLedger does not convert an existing CSV into .qbo.
Convert your PDF statement to QBO Or convert to a 3-column CSV
Create a free account See plans
Free: 10 pages per day per browser. A balance check helps spot extraction issues; it does not replace your review or Wave categorisation. We have not completed a live Wave import test of these sample files.
Related guides
- Xero bank statement CSV template
- QuickBooks Online bank statement CSV template
- Zoho Books bank statement CSV format
- US bank statement format guide · Discover · Citi
Sources and scope
Based on Wave’s public help articles updated October 28, 2026 and October 19, 2026, fetched November 10, 2026. Menu names can change. Examples are fictional. These instructions are documentation-based, not a claim of a completed live import into Wave. CSVLedger is not affiliated with Wave Financial Inc.
- Wave: Upload a bank or credit card statement in .csv format (updated October 28, 2026; checked November 10, 2026)
- Wave: What to do if Wave can’t read your statement in CSV format (updated October 19, 2026; checked November 10, 2026)
Frequently asked questions
What columns does a Wave CSV need?
Wave’s troubleshooting article (updated October 19, 2026; checked November 10, 2026) says the file must have a date, a description, and the amount — either in one column or in separate deposit and withdrawal columns. That is three or four columns in total. Delete any other columns. Put headings in the first row.
Which date format does Wave accept?
The same article says Wave must be able to recognise the date, that the date cannot be in the future, and that recognised formats include YYYY/MM/DD or YYYY-MM-DD. It also allows numerical values, full month names or 3-letter month names (for example 2025/Jan/01). Use a single date column; if the file has a transaction date and an approval date, delete one of them. The sample file uses YYYY-MM-DD.
Are credit-card signs the same as checking-account signs?
No. For credit card uploads, Wave says purchases must be a positive amount and payments must be negative. That is the opposite of CSVLedger’s card export, which follows the QuickBooks and Xero convention (purchases negative, payments positive). If you export a card statement from CSVLedger, reverse the signs before uploading the CSV to a Wave credit-card account, or upload a .qbo file and confirm the preview.
Does Wave accept a PDF statement?
No. Wave’s troubleshooting article states that Wave does not support PDF files for transaction uploads. Convert the PDF to CSV or to a .qbo file first, or use a bank-provided OFX, QBO, QFX or ASO download.
Does CSVLedger convert CSV to .qbo for Wave?
No. CSVLedger converts PDF statements only. It can export a .qbo file or a three-column CSV from a PDF. It does not turn an existing Wave or bank CSV into .qbo.