A date such as 04/05/2026 can mean April 5 or May 4. When the importer says day and month order cannot be told apart, confirm Date format from the bank export rather than accepting a guess.
- Find the export’s date-format description or compare a transaction with a statement that spells out the month.
- Choose Month, day, year or Day, month, year accordingly.
- Check the interpreted Date beside Date as read for several rows, including the earliest and latest activity.
Dates in which both numbers are twelve or less may all be valid under two conventions. Passing validation therefore does not prove the selected interpretation is the one the bank intended.
Protect the reporting period
Review the preview’s first and last dates after selecting the format. An incorrect convention can move transactions into another month and affect start-date or closed-period checks.
If you cannot establish the convention, obtain a clearer export or prepare dates in YYYY-MM-DD from confirmed source information. Preserve the original file and avoid changing dates merely to make an import pass. Resolve the ambiguity before checking and committing the rows.
Was this article helpful?
Tell us whether this answered the question you came with.