QIF Investment Action Codes

Discussion in 'Microsoft Money' started by Keny K, Mar 27, 2006.

  1. Keny K

    Keny K Guest

    Anyone know the action codes for the investment QIF import. I created
    transactions as short sell and cover short in my investment account. I then
    exported the account but the QIF listed these transactions as sells and buys.
    If I import these transactions back into the account they are listed as buys
    and sells. I tried changing to "short sell" but it did not like that. I
    looked at some other transactions and saw that there are acronyms for some of
    the actions, so I assuming there are acronyms for these actions. Anyone Know
    what they are??????
    Keny K, Mar 27, 2006
    1. Advertisements

  2. Keny K

    AreJaay Guest

    Full List from QIF documentation is

    Buy A security Buy
    BuyX A security Buy and transfer of cash from another account
    Sell A security Sell
    SellX A security Sell and transfer of proceeds from another account
    CGLong Long term capital gains
    CGLongX Long term capital gains and transfer of proceeds to another account
    CGMid Mid-term capital gains (converted to short term on import as OFX
    doesn¬Ęt support this)
    CGMidX Mid-term capital gains and transfer of proceeds to another account
    CGShort Short Term Capital Gains
    CGShortX Short-term capital gains and transfer of proceeds to another
    Div Dividend
    DivX Dividend and transfer to another account
    IntInc Interest Income
    IntIncX Interest Income and transfer to another account
    ReinvDiv Dividend reinvested
    ReinvInt Interest Income Reinvested
    ReinvLg Long term capital gains Reinvested
    ReinvMd Mid- term capital gains Reinvested
    ReinvSh Short-term capital gains Reinvested
    XIn Transfer of cash into the account
    XOut Transfer of cash out of the account
    MiscExp Misc Expense
    MiscExpX Misc Expense covered by another account
    MiscInc Misc Income, optionally associated with a security.

    I think that means for a short sell, its Money's interpretation of the
    order of the transactions.
    AreJaay, Mar 28, 2006
    1. Advertisements

  3. Keny K

    Keny K Guest

    THanks for the codes.... exactly what I was looking for..... however I am
    surprised by no Short Sell or Cover Short code. I know if you have these in
    your account and export them to QIF file and then reload the file... the
    shorts disappear. I know if you import an OFX file in a sell then buy
    sequence money will ask you to make entry to offset stock you do not have. I
    also know that if you process an OFX file with Shorts in it, it gets created
    correctly. So how does the OFX file tell Money it is a Short if it does not
    exist in the Actions?????
    Keny K, Mar 28, 2006
  4. Keny K

    Keny K Guest

    Also.... do you have the action codes for a Bank Account???
    Keny K, Mar 28, 2006
  5. Keny K

    Chris Cowles Guest

    If you cannot find a listing, you can create one by exporting your accounts
    from Money.
    Chris Cowles, Mar 29, 2006
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.