Electronic Bank Reconcile – Dates won’t import properly

06/17/2016 – Today was setting up configuration for electronic bank reconcile and every time  the download of the statement was done the date imported into the system was either 1/1/1900 or 12/31/9999.  After several un successful attempts to fix the issue finally  the eureka moment…  The excel source file had a hidden column and the copy paste to text file added an invisible column which shifted all columns to the right messing the mapping!  The lesson learnt here is, check the source file in text editor …