How do you import a PDF bank statement into Wave?

By Kayabyte · Last updated 11 November 2026

Short answer: Wave does not take PDF files for transaction uploads, so turn the statement into a CSV (or an OFX, QBO or QFX file) first, then use Upload transactions on the account in Wave. Wave’s CSV needs a date, an amount and a description, and nothing else that confuses it. The traps are extra columns, a date format Wave cannot read, and card statements with the sign the wrong way round. Check the totals before you upload.

1. Try a download from the bank first

Look in your bank’s online banking for a transaction download. Wave’s page “Upload bank and credit card statements” (checked 11 November 2026) lists the file types it accepts as OFX, QBO, QFX and ASO, and says that if none of those is available you can upload a CSV, which it calls the more complex option. So a bank file in one of those formats is the best route. If your bank only offers PDFs, or the PDFs go back further than the downloads, continue.

2. What Wave wants in a CSV

Wave’s page “What to do if Wave can’t read your statement in CSV format” (checked 11 November 2026) says the CSV must have three or four columns:

the date
the amount, either all in one column, or one column each for deposits and withdrawals
the description

It adds the following, which are the usual reasons an upload fails:

Extra columns. More than four columns with inconsistent information gives “Wave is having difficulty reading the file”. Delete everything except date, amount and description.
Two date columns, such as a transaction date and an approval date. Delete one.
The date format. Wave says the date cannot be in the future and must be written YYYY/MM/DD or YYYY-MM-DD. It also accepts month names, such as 2025/Jan/01.
Column titles at the bottom or blank and total rows. Put the titles at the top and delete balance-total rows.
A long file name. Wave says to rename the file to something like month-year-account.csv.
Several currencies in one file. Make one file per currency. Wave says the currency symbol in your file does not decide the currency: it follows the payment account you pick at upload, and the statement must be in that account’s currency.
A description with only numbers. The description column may be empty, but if it has content it must contain words.
An XLS file. Re-save it as CSV (comma delimited).

3. Card statements: check the sign

Wave’s page says that for credit card transactions, purchases must be a positive amount and payments must be negative. Many card statements already print them that way, but check the first rows after you convert. A purchase that shows as money in, or the other way round, is the commonest sign problem. See why converted statements don’t add up.

4. Check the totals before you upload

Use the statement’s own numbers: the opening balance plus the transactions should equal the closing balance. If your converted rows do not give the closing balance, a row was dropped, doubled or flipped. A difference of exactly twice one amount usually means one flipped sign.

5. Upload to Wave

Wave’s steps (checked 11 November 2026):

On the left menu, choose Accounting, then Transactions.
At the top right, click More, then Upload transactions.
Click Choose File and select the file.
In the Payment account field, select the right account.
Click Upload, then confirm the dates with Confirm date and the amounts with Confirm amounts.
Click Select description to confirm the description column, then click Upload my statement.

Wave says the transactions may take a few moments to appear on the Transactions page. Compare the number of transactions and the balance with your statement. Wave’s page “Switch to Wave from a spreadsheet” (checked 11 November 2026) says connecting a bank account for imports is part of Wave’s Pro plan, so for an account without that connection the upload is the route.

6. Where Balanced helps

Balanced is a Mac app we make. It reads the statement PDF on your Mac (a text PDF, or a scanned PDF or photo, read with Apple’s on-device text recognition), shows the table it found and checks that the opening balance plus the transactions equals the closing balance. In the preview you can fix what each column means, the date order and the sign handling, and for card statements it decides the sign from the balances and asks when it cannot. When the check passes, export a CSV and choose the delimiter and the date format in the export window, so you can pick one Wave reads, such as YYYY-MM-DD.

Balanced has no export made for Wave and no connection to it, and we have not tested an upload into Wave. Open the CSV before you upload it, delete any column other than date, amount and description, and use Wave’s confirm steps as the last check. Balanced also writes OFX, QFX and QBO files, which are among the formats Wave lists as accepted, if you would rather try one of those.

Limits: results depend on the statement’s layout, so check the preview. A password-protected PDF must be unlocked first. No AI, no account, and the statement never leaves your Mac. The free version reads and checks everything and exports the first 5 transactions per file; Pro is USD 59 per year or USD 7.99 per month, for up to 3 Macs. macOS 15 or later. Download Balanced

Steps with Balanced

Open the statement PDF in Balanced with Add Files or by dragging it in.
Check the preview: column roles, date order and signs. Answer the question in the box if the status says Needs your answer.
Read the totals check and fix any difference before exporting.
Export CSV with a date format Wave reads, such as YYYY-MM-DD.
Open the file, remove any column that is not date, amount or description, and give it a short name such as 2026-10-account.csv.
In Wave, choose Accounting, Transactions, More, Upload transactions, pick the account and follow the confirm steps.

Questions

Can Wave import a PDF bank statement? No. Wave’s page says it does not support PDF files for transaction uploads. Convert the PDF to CSV, OFX, QBO or QFX first.

Why does Wave say it cannot read my dates? Wave’s page lists three causes: two date columns, rows with commas or blank spaces, and a date format it does not recognise. It must be YYYY/MM/DD or YYYY-MM-DD, or use month names, and not be in the future.

Why did my upload fail with several currencies? Wave takes one currency per file. Split the file by currency and upload each to the account in that currency.

Does Balanced connect to Wave? No. It writes the import file.

Wave is a trademark of its owner. Balanced is made by Kayabyte and is not affiliated with or endorsed by Wave.