A spreadsheet may store dates as numbers while displaying calendar dates. If your CSV contains a number such as a date serial instead of a supported calendar string, the importer cannot treat that value as the intended date automatically.
- Open the original spreadsheet and confirm which cells represent dates.
- Export a working copy that contains explicit calendar dates, preferably YYYY-MM-DD.
- Compare the exported text with the displayed spreadsheet dates and the bank statement before importing.
Do not map a transaction identifier or amount as a date merely because it contains a similar numeric value. Confirm the column’s meaning from the source.
Check more than one row
Verify a date near the start of the file, one near the end and any month or year boundary. Spreadsheet conversion settings can affect a whole range, so one correct-looking row is insufficient.
Retain the source workbook and original bank export. After reading the corrected file, review Date as read, interpreted Date and the preview date range. Any remaining Before start date or Closed period result should be addressed as a period condition, not by altering the confirmed date again.
Was this article helpful?
Tell us whether this answered the question you came with.