A date containing a two-digit year needs an explicit convention and a careful century check. The parser interprets years 70 through 99 as 1970 through 1999 and 00 through 69 as 2000 through 2069.
For ordinary recent exports that rule may match the source, but you should still inspect the interpreted Date. Historical records and unusual future dates deserve a full four-digit year in a reviewed working copy.
Verify the year
- Compare the transaction’s year with the statement period printed by the bank.
- Check the interpreted dates in Preview and the earliest and latest dates in the summary.
- If the source is ambiguous, confirm its intended full year before converting it to YYYY-MM-DD.
Do not change a year merely because the resulting row falls before the book start date or inside a closed period. Those restrictions need to be resolved using the actual source chronology.
If a file combines records from different years, check the year boundary explicitly. A short date field copied from a spreadsheet can hide the year even when the displayed month and day look correct.
Was this article helpful?
Tell us whether this answered the question you came with.