BooksReady

Wave says "Wave can't find any transactions in your file"

In short: Wave's help lists "Wave can't find any transactions in your file" as a CSV upload error and gives two reasons: the file contains no data, or the column titles are at the bottom of the table. An export for dates with no activity, or a summary report instead of a list of transactions, has no transaction rows to find. The converter says so when a file has column names but no transactions under them, and when there are transactions it writes them into an OFX file, a format Wave calls easier to import than a CSV.

Fix the file

Bank CSV to OFX

A CSV with a date column and an amount (or debit and credit) column

Your file stays on this device

It is read and converted by this page, inside your browser. Nothing from the file is uploaded, and the converter keeps working offline once the page has loaded.

No file handy? or download the sample to look at it first.

The data in the sample is invented. It is converted on this device, the same way your own file would be.

One email when it ships. The address is used for nothing else. Details.

What you see

You upload a CSV in Wave under Accounting, Transactions, More, Upload transactions, and see "Wave can't find any transactions in your file".

Why it happens

Wave's help page gives two reasons: "Your file contains no data." and "Column titles are at the bottom of the table." For the first it says to "ensure your file has at least one transaction"; for the second, to "delete any columns without transaction information and move column titles to the top of the table."

A file has no transaction rows when the export covers dates with no activity, or when it is a summary or balance report rather than a list of transactions.

Under a different message, Wave's help also says "Wave does not support PDF files for transaction uploads." and that a file saved as .XLS should be re-saved "as a .CSV (comma delimited) file instead."

Wave does not name other causes for this message. Title or account lines above the column names, a file separated by semicolons or tabs, or a PDF statement renamed to .csv might give the same message; none of these was tested in Wave.

How to fix it

  1. Open the export in a text editor and check that there are transaction rows under the column names. If there are none, export again with a date range that has activity, and choose the transaction list rather than a summary.
  2. Drop the file into the converter above. It looks for the column names in the first 40 lines, so title and account lines above them are skipped, and it reads files separated by commas, semicolons or tabs. If it finds the column names but no dated rows under them, it says so instead of writing an empty file.
  3. Choose the account type, Bank (checking), Bank (savings) or Credit card, and download the OFX file.
  4. In Wave go to Accounting, Transactions, click More, then Upload transactions. Choose the file, pick the payment account and click Upload.

What this does not fix

  • The converter does not move column names from the bottom of a file to the top. Do that first, as Wave's help says.
  • A PDF is refused, also when it is renamed to .csv, because the converter checks the start of the file rather than its name. Download the CSV export instead.
  • Lines without a date, such as totals and closing balances, are left out of the OFX file. Wave's help says balance totals in a CSV can cause a generic error.
  • If Wave shows "Wave needs you to make a small change to your file so we can read it", Wave's help says to change the ENCODING line in a text editor; files from this converter say ENCODING:USASCII, which Wave's steps change to UTF-8.
  • No import was run in Wave: the converter has not been tested by uploading into Wave, so check the first upload before you rely on it.

Before and after

Before: the bank CSV as downloaded

Account Name:,Sample Business Checking
Account Number:,XXXX0000
Statement Period:,01/03/2025 - 31/03/2025

Date,Description,Debit,Credit,Balance
03/03/2025,OPENING DEPOSIT,,"2,500.00","2,500.00"
14/03/2025,"OFFICE SUPPLIES, INV 77",125.40,,"2,374.60"
15/03/2025,CLIENT PAYMENT - ACME SAMPLE LLC,,800.00,"3,174.60"
28/03/2025,MONTHLY SERVICE FEE,5.00,,"3,169.60"

After: what Xero, Wave, GnuCash, Moneydance, MS Money and others receives

...
<STMTTRN>
<TRNTYPE>CREDIT</TRNTYPE>
<DTPOSTED>20250303120000</DTPOSTED>
<TRNAMT>2500.00</TRNAMT>
<FITID>D8E3A092ED5DD995</FITID>
<NAME>OPENING DEPOSIT</NAME>
</STMTTRN>
<STMTTRN>
<TRNTYPE>DEBIT</TRNTYPE>
<DTPOSTED>20250314120000</DTPOSTED>
<TRNAMT>-125.40</TRNAMT>
<FITID>8B3BD6B1A545D171</FITID>
<NAME>OFFICE SUPPLIES, INV 77</NAME>
</STMTTRN>
...

Synthetic sample data that follows the real export layout, not a real account. The "after" output was produced from it by the same converter this page runs.

Import the fixed file into Xero, Wave, GnuCash, Moneydance, MS Money and others

  1. In your accounting software open the bank account and choose Import statement (or File > Import > OFX).
  2. Choose this .ofx file.
  3. Review and confirm the transactions.

Questions

What does Wave mean by "no data"?
Wave's fix is to "ensure your file has at least one transaction." A CSV with only the column names, or an export for a period with no activity, has none.
My file has transactions. Why does Wave still not find them?
The only other reason Wave gives is column titles at the bottom of the table. Lines above the column names or a semicolon-separated file are not named by Wave for this message and were not tested in Wave. An OFX file has no column titles to find: each transaction is stored in fixed fields.
Can I upload a PDF bank statement to Wave?
No. Wave's help says "Wave does not support PDF files for transaction uploads." The converter does not read PDFs either; download the CSV or OFX export from your bank instead.

Converters for this file

Related import problems

Sources

The rules on this page come from these help pages, checked 2026-11-14. Software changes; if your screen says something different, the help page is the authority.