BooksReady

Wave says "Wave is having difficulty reading the dates of your transactions"

In short: Wave's help lists "Wave is having difficulty reading the dates of your transactions" as a CSV upload error. Its causes are two date columns, rows with commas or blank spaces, or a date format Wave does not read: dates must be YYYY/MM/DD or YYYY-MM-DD and not in the future. US bank CSVs usually write MM/DD/YYYY. Wave also says OFX, QBO and QFX files are easier to import than a CSV, so the converter builds an OFX file from your 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 is having difficulty reading the dates of your transactions".

Why it happens

Wave's help page gives three reasons: "There are two or more date columns, such as a transaction date and an approval date.", "There are rows with commas or blank spaces." and "Wave cannot recognize the date's format."

It says the date "cannot be in the future and must use this formatting: YYYY/MM/DD or YYYY-MM-DD". An export with 03/14/2025 or 14.03.2025 does not fit.

Card and payment app exports often have both a transaction date and a posting date, and some add a balance or totals row at the end.

How to fix it

  1. Drop your CSV into the converter above. If the dates could be read either way, it asks you once which order the file uses.
  2. Choose the account type, Bank (checking), Bank (savings) or Credit card, and download the OFX file.
  3. In Wave go to Accounting, Transactions, click More, then Upload transactions. Choose the file, pick the payment account and click Upload.
  4. Check the transactions on the Transactions page.

What this does not fix

  • If Wave shows "Wave needs you to make a small change to your file so we can read it", Wave's help says to open the file in a text editor and change the ENCODING line. Files from this converter say ENCODING:USASCII, which Wave's steps change to UTF-8.
  • Wave's CSV help says dates cannot be in the future. The converter keeps dates as they are in your export, so remove rows dated after today before you upload.
  • The converter has not been tested by uploading into Wave; 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

Which date format does Wave need in a CSV?
Wave's help says YYYY/MM/DD or YYYY-MM-DD, with numbers or month names, and no dates in the future.
Why an OFX file instead of a CSV?
Wave's upload page says OFX, QBO, QFX and ASO files are easier to import into Wave than a CSV. An OFX file stores each date in one fixed format, so there is no date column to map.
Can I still upload a CSV to Wave?
Yes. Under To, the QuickBooks Online (CSV) option writes three columns, Date, Description and Amount, and its Date format setting offers YYYY-MM-DD. Wave's help asks for three or four columns: a date, an amount and a description. That is for a bank account; for a credit card account Wave wants purchases positive and payments negative, so use the OFX file there.

Converters for this file

Related import problems

Sources

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