The structured import date parser expects numeric date layouts. If a source uses written month names, prepare a working copy with confirmed dates in YYYY-MM-DD before reading the rows.
Use the original bank statement or export as the authority for the month, day and year. A conversion should change the representation while preserving the date itself.
Review the converted file
- Confirm the source language and month abbreviation, especially if more than one abbreviation could be misunderstood.
- Export the date column as full calendar dates rather than spreadsheet display text or serial numbers.
- Inspect the first and last dates, month boundaries and any rows with unusual source wording.
If the source omits a year, establish it from the statement period before completing the working file. Do not assign the current year to every row without evidence.
Keep a copy of the original text dates so a later reviewer can trace the conversion. After import preview, compare known transactions with their statement dates. A successful parse shows the format is readable; it does not independently confirm that an ambiguous source date was interpreted correctly.
Was this article helpful?
Tell us whether this answered the question you came with.