Date does not match the selected format means the mapped value could not be interpreted as a valid date under the current settings. Start with the source column and Date format selection.
- Compare Date as read with the original export. Make sure the mapped field is a transaction date rather than a reference, heading or account balance.
- Choose the appropriate year-first, month-first or day-first convention.
- Inspect the row again and check the file’s overall first and last dates.
If only a few rows fail, they may contain impossible dates, text month names, spreadsheet serial numbers or a different format from the rest of the file. Confirm each affected value from the bank before preparing a consistent working copy.
Do not substitute download dates
The date you exported or uploaded the file does not replace the movement’s date. Use the source transaction evidence to repair a missing or unreadable value.
If the correct source date falls outside your intended import period, let the start-date or closed-period checks handle it. A format problem and a period restriction have different causes, and correcting one does not justify changing the other.
Was this article helpful?
Tell us whether this answered the question you came with.