QIF Investment Action Codes


K

Keny K

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??????
 
A

AreJaay

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??????
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
acount
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.
MiscIncX

I think that means for a short sell, its Money's interpretation of the
order of the transactions.
 
K

Keny K

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?????
 
C

Chris Cowles

Keny K said:
Also.... do you have the action codes for a Bank Account???
If you cannot find a listing, you can create one by exporting your accounts
from Money.
 

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. After that, you can post your question and our members will help you out.

Ask a Question

Top