The question is now just for my understanding of the technical innards of the Quicken file's database (a topic I haven't really dived into, so maybe the answer is already out there somewhere).ī) I was asking if there was any way to use the ticker symbol as the name in the QIF's Y flag without also needing the investment's name in Quicken being the ticker symbol. will this Sale transaction that has the cash floating into the void come back to bite me some number of transactions later down the road)?įor me personally, I think this is OBE because I've found I can copy from the web to a text file and use a Python script to generate by QIFs instead of the copy/paste by hand I was using before so the workload of creating extra QIFs is close to minimal. The main question was if I don't care about tracking the fees and only care about tracking the shares, am I going to harm the database by not including the T flag in the QIF (i.e. If you have any further questions, let me know.Ī) Agreed, Quicken DOES calculate the cost (when opening up the "Edit transaction" box for the imported transaction, the expected cash/fee is listed in the Total sale box).
qif format or manually enter a transaction, Quicken should update the price for that date using the transaction information. If you have a transaction that you import in. If there is only a couple of securities, then manually entering the share price would probably be easier. If you're into showing daily price changes, you would have to import this data every weekday. However, you can't export a range of dates, so, the import is only for one date. If you go to Yahoo Finance, you can set up a portfolio there and export the prices from there and import into Quicken.
You may have to do some manual entry to get this, but you said you only have a couple of transactions a quarter.so that shouldn't be too much of a pain.Īs to part two of your question: You cannot import prices via. The category should be "Management Fee" and the amount should be equal to the cash balance. Then, with that cash balance, you should be selecting a Miscellaneous Expense investment transaction type. Quicken should actually calculate the cash balance for you based on the shares sold and share price. You should be entering the sell transactions for the management fees.shares sold, share price AND the cash balance.
I'm leaning towards making the extra transactions but any insight is appreciated!ĮDIT: Forgot to offer option 3: instead of a misc transaction, should I record the cost into the commission field? The downside being I'm not recording into a category I create specifically to track 401k fees. General question: These funds are listed on the markets and have valid symbols short of renaming the fund to the stock symbol, is there a way to import via QIF by stock symbol? Guessing not.
Question: Am I ok importing QIFs with only I and Q (decrease shares via Sell but do not increase cash balance) or will things go haywire in the database with this "lost" money? Or do I play it safe (and increase my workload and database size) by adding the T flag to the Sell QIFs (increasing cash balance upon import), and creating an extra misc expense transaction to remove the cash? Looks like the extra transaction would be NCash and L (based on how my QIF export looked)? If I manually open/edit the transaction inside Quicken, the cash total is listed in the box, but does not get added to the cash balance unless I process the edited transaction.
The transaction imported, properly decreased the share balances, but given the absence of a T (total) flag, did NOT increase the cash balance. Scenario: Created QIF transactions for the investment management fees (two per fund per quarter) using Sell with only the I and Q flags (price and quantity). Given the processing time of entering transactions in Quicken manually vs time setting up and importing a QIF, I am doing the latter. The investment manager does not break out share balances nor classifies transaction types between traditional and Roth (I have both), so using the QFX information is a no-go. I'm manually creating QIFs for my 401(k) transactions from the transaction history of the investment manager's website.