Changing date format when importing QIF files

slaterish
slaterish Quicken Windows Subscription Member
I'm using Quicken for Windows delux subscription. I'm in UK and download QIF files from UK banks and credit cards to import into Quicken.
When I try to import the files I get two problems:
1. The dates all seem to be interpreted by Quicken as day/month/year format (rather than month/day/year which they actually are) 
2. All the imported entires are put at the top of the account (before the earliest dates); and they are given the *same* date in the import process.

The simple version of my question is: what is the best way to use Quicken to import QIF files with UK data - or is there any way?

thanks for any help - I rathe rlike Quicken but this is clearly a deal breaker. I currently use Moneydance, which has no problem at all with UK data]

don

Answers

  • Sherlock
    Sherlock Quicken Windows Subscription Member ✭✭✭✭
    If you haven't already, you may want to review: http://www.quicknperlwiz.com
  • slaterish
    slaterish Quicken Windows Subscription Member
    I've spent quite some time trying to make that solution work - no go. 

    Any other ideas? There must be other Brits using this programme...

    don
  • mshiggins
    mshiggins Quicken Windows 2017 SuperUser ✭✭✭✭✭
    From C. D. Bales:
    @slaterish

    "The dates all seem to be interpreted by Quicken as day/month/year format ....".


    The U.S. version of Quicken interprets QIF file dates as being in month/day/year format. 


    But when two digit years are used in the QIF file, the creator of the QIF file must take into account the change of century (whether year "19" is 2019 or 1919).


    If the source of the QIF file is not formatting the two-digit year dates correctly, the best way to correct that would be for the source of your QIF file to offer to download QIF file dates in the format mm/dd/ccyy (or to format the two digit years correctly to distinguish the 20th century from the 21st century).


    Otherwise, you may be able to use the free Excel Add-in, xl2qif (Google will find it) to import your QIF file into Excel, then export the Excel data to a new QIF file, having xl2qif change the date format to meet with Quicken's expectations, then import that new QIF file into Quicken.


    If you want to see the effect of the formatting of two-digit years in QIF files, try this:

    - Create a New (test) Quicken file

    - In that New (test) Quicken file, create a Cash account

    - Copy the data below into Notepad and save as a .QIF file

    - Import that QIF file into your New (test) Quicken file Cash account

    - Carefully note the Transaction dates in the imported Quicken transactions



    !Type:Bank

    D01/15'19

    PMemo.  QIF Date = 01/15'19

    T-110.00

    ^

    D01/23/19

    PMemo.  QIF Date = 01/23/19 

    T-225.00

    ^


    Quicken user since Q1999. Currently using QW2017.
    Questions? Check out the Quicken Windows FAQ list

This discussion has been closed.