Converting from Money to FM

[DaveA]

I have become totally confused with the handling of the Cash account with each sub portfolio in Money. Is there a "general" guideline for transfering investment activity from Money to FM.
I only use the Money program to monitor our investments and savings.
The area I am most concerned about is the Management fees related to the investment accounts we use.
I also found myself confused with the use of a "default" cash account. When I exported each sub account from Money I had 2 choices, Investments only or Regular which included Cash, Assets etc. I used Investment Only. I did get the buy, sell, divid, interest, etc, but not the Managememt Fees. If I export the Cash account from each account in Money, it contains the Mgmt fees by checking the Regular export.
I did notice that the qif file for the Cash Exports did not have an "N" line, only D,M, P and T. The file did contain only the Management Fees and small Interest accruals.

[Mark]

Hi DaveA,

We don't have a generic guideline for this, but I can try to explain how FM uses this information, and then hopefully that will help you to be able to get all your data into Fund Manager.

When you import a .QIF file (or any transaction file), on the "Preview" screen showing all your transactions, there is an option "Record Corresponding Entry in Default Cash Account". If you check this option, any buy/sell of an investment, will cause a corresponding sell/buy to be recorded in whatever you choose to be your default cash account. If your importing transactions already contain an explicit listing of the cash buy/sell, then you do not need to use this option. For example, if you see a list of a buy of $1000 of stock ABC, and a sell of $1000 cash on the same day, then do not check this option. However, if you only see the buy of $1000 worth of stock, then you would want to check this option, so your $1000 will be deducted from your cash account.

The above explains the idea of the default cash account. I'm not sure about how your management fees would be exported from Money, but hopefully you can find some export combination so that they are included. If necessary you could do multiple exports/imports.

[DaveA]

Thank you Mark for the excellent turn around time with your response.
Am I correct that I could set up a Default Cash account for each Investment Account I have? I was under the impression that a Default Cash account would be set up as a sub account under the Master Portfolio and ALL cash related activity would be placed in that account regardless of which Sub Account the activity occured in.
I also edited the original message and you may have missed it. When I review the content of the Cash related transactions from my Money export, it only contains the things related to the investment management companies fees and accrued interest on cash positions. However, it does not have a flag for "N". Can I somehow use this data by editing the qif. OR would I be better off importing all of my history from Schwab and let it place the data in the correct catagory? Please address the establishment of a "Default Cash" for each Sub Portfolio (Account) in FM if I "retrieve" all data from my Schwab account.
Thank you again for excellent service... IT IS LIKE A BREATH OF FRESH AIR.

[Mark]

Hi DaveA,

Yes, you can have a separate default cash account for each investment account. Every sub-portfolio has a property for "Default Cash Account", so you can have a different cash investment assigned to be the default cash account for each sub-portfolio (account).

If there is no "N" field in your QIF file, it will be mapped to a buy or sell. If there is no "Y" field, the transaction will go to your default cash account. If you don't have a default cash account, it will be skipped.

With Schwab, you can retrieve transactions for the last 2 years from their OFX server. If you'd like it for longer, you can import from your QIF files you're exporting out of Money.