StatementCSV
Import a bank statement PDF into Wave
Wave's help center says it doesn't support PDF files for transaction uploads. When your bank only gives you a PDF, StatementCSV can turn it into a CSV with the three columns Wave asks for: date, description and amount.
What Wave asks for in a CSV
From Wave's article What to do if Wave can't read your statement in CSV format:
- Three or four columns: a date, a description, and the amount, either in one column or split into deposit and withdrawal columns. If more than four columns hold other information, Wave asks you to delete them.
- Only one date column. Dates use YYYY/MM/DD or YYYY-MM-DD and can't be in the future.
- Amounts are numbers. A minus sign or brackets mark a negative amount.
- Credit card uploads need purchases as positive amounts and payments as negative amounts.
- The description column can't contain only numbers.
- No blank rows, no balance-total rows, and column titles on the first row. A file name that's too long can also cause an error, so Wave suggests something like
monthyear.csv.
The Wave layout in StatementCSV
The paid export has a Wave CSV layout with the three columns Wave asks for: Date,Description,Amount. Here are three sample rows (a Dec 30 coffee, a Jan 2 deposit and a Jan 3 rent payment on a statement that closes in 2026) exactly as the converter exports them:
Date,Description,Amount
2025-12-30,Coffee Shop,-4.50
2026-01-02,Payroll deposit,1250.00
2026-01-03,"Rent, January",-1800.00
- Date: YYYY-MM-DD, one of the two formats Wave lists. Statements often print dates without a year, so the converter uses the statement year (prefilled from the PDF, and you can edit it). When a statement without years has both December and January rows, the December rows get the year before.
- Description: the transaction text with extra spaces removed.
- Amount: one column with no $ sign or thousands commas, and a minus sign for negative amounts.
- Values are only put in double quotes when they contain a comma or a quote mark, as CSV requires (like
"Rent, January" above).
Steps
- Open the statement PDF in the StatementCSV app. It's read in your browser, not uploaded. The free preview shows how many transactions it finds and the first 5 rows.
- Check the rows and fix anything that looks off. You can edit or delete rows before you export. Delete any zero-amount rows you don't want, since they're exported as
0.00.
- Unlock for $9.99 one-time. The layout picker next to Download CSV is part of the paid export.
- Pick Wave (Date, Description, Amount) in the layout picker and check the statement year.
- Set flip signs for Wave's sign rules. For a checking or savings account, money in should end up positive and money out negative. For a credit card, Wave wants purchases positive and payments negative. The app ticks flip signs automatically when it detects a credit card statement (that suits Xero, which wants card purchases negative), so untick it for Wave if your statement prints purchases as positive numbers. If you export the Wave layout with a credit card detected and flip signs still ticked, the app shows a reminder. Then download.
- The file downloads as
<your PDF name>-wave.csv. Wave says a file name that is too long can cause an error, so rename it to something short like jan2026-checking.csv if needed. No spreadsheet editing is needed.
- In Wave, go to Accounting, then Transactions. Click More, then Upload transactions. Choose the file and the payment account, then click Upload (Wave's steps). The account has to exist first, and its currency should match the statement.
- Confirm the date, amount and description columns. Wave picks them for you when there's only one of each. Then click Upload my statement, and compare the imported total with the PDF.
What about OFX?
Wave accepts .OFX, .QBO, .QFX and .ASO files and says they're easier to import than CSV. StatementCSV's paid export can also write an OFX 1.02 file. We haven't tested that file in Wave. It uses a placeholder account ID and always says USD, so this page sticks to the CSV route, which follows Wave's written rules.
Limits
- We haven't tested an actual import in a Wave account. The steps and rules come from Wave's help center articles listed below, and Wave can change them.
- Wave's articles don't say whether quoted values are accepted. The Wave layout only quotes a description that contains a comma or a quote mark. If Wave won't read such a row, edit that description in the table before you export.
- If a row's date or amount can't be read, the converter leaves the row out of the Wave layout and tells you how many rows it skipped.
- Wave records the transactions in the currency of the payment account you pick. StatementCSV doesn't read currency codes.
- Scanned or image-only PDFs can't be read.
Sources