Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In with Facebook Sign In with Google Sign In with OpenID Sign In with Twitter

Date issue while importing bank statements

edited July 2014 in Accounting
I imported a fresh bank statement in an excel sheet from Karnataka Bank and saved it as Excel 1997-2003 format.

I tried to import, but the dates are not correct.

Comments

  • There is some issue with the date format in the file. It seems that you have saved the original file again and the format of some of the dates have changed to US format.

    To resolve this, you need to do the following:

    1. In Windows, click on Control Panel
    2. Select Region
    3. Select, Format ‘English (United Kingdom) and short date ‘dd/MM/yyyy’
    4. Click Apply and save this
    5. Restart your computer

    image

    6. Then download the bank file again and import it
Sign In or Register to comment.