none
How to import Moneydance data file into Microsoft Money RRS feed

  • Question

  • I am using Moneydance right now and want to try MS Money (sunset version). Can I import my Moneydance data (nearly 5 years) to MS Money? 

    Thank you.

    Wednesday, March 7, 2018 4:51 PM

All replies

  • To try this, export QIF files from Moneydance. Money wants one QIF file for each account. Use a meaningful filename. Start the filename for investment accounts with a number and the associated cash account with a letter if you have both. If MoneyDance puts all of your accounts into one QIF file, you will need to take steps to have separate files.

    Take notes. If you succeed, you will want to be able to share the method.

    For investment accounts you prefer to have one QIF from the investment transactions and one for the associated cash account. I don't know if MD follows that organization. Money does not have to have an associated cash account, but it is usually better.

    Once you have the files, you import them into a new Money file all at once. If you get the files from MoneyDance, check back if there is any doubt about how to proceed.

    Wednesday, March 7, 2018 10:36 PM
    Moderator
  • Thank you.

    I just tried. I exported several saving accounts and several investment accounts into *.qif. Then imported this *.qif (tried one by one) in MS money.

    However MS money said "The QIF file contains a section of data that Money does not support. Do you want to continue iporting the rest of the file?" I clicked "Yes" and MS money asked again and again which never end (some of my account only have less than 10 entries).

    Do you encounter this problem before? How to solve. Thank you.

    Thursday, March 8, 2018 1:27 PM
  • I have never used Moneydance.

    Can you export one account to a QIF file in Moneydance? http://help.infinitekind.com/kb/importing-data-from-other-programs/importing-data-in-qif-format implies you can, although that article is written about importing into Moneydance.

    Don't try importing QIF files into Money except as an experiment to prove compatibility. Is this the thing you tried that gave the "The QIF file contains a section of data that Money does not support" message?

    But when you are trying for real, you will import all 15 (or whatever number) files all at once into a new Money file.


    Thursday, March 8, 2018 4:09 PM
    Moderator
  • Thanks Cal Learner for the prompt response.

    Sorry that maybe my message is not accurate. When I said "expert several ... accounts", actually I exported only single account (instead of several different accounts) at one time. Therefore, I exported several *.qif files and I try the "import" function under "File" in MS Money to import single *.qif to test. I imported individual *.qif one by one. However, all *.qif gave "The QIF file contains a section of data that Money does not support. Do you want to continue importing the rest of the file?"

    I am still figuring out what wrong with my procedure.

    Thursday, March 8, 2018 8:20 PM
  • If you want to post *one* of the QIFs Money rejects, I can look at what it would take for Money to like the file.

    You could create a new MoneyDance file as a test, make a few sample transactions, and post that, or you could pick one with few transactions.

    Note that each transaction ends with a line with a ^ character, so you could cut down the size if you like. If you edit a file, use a simple text editor, such as Notepad. Do not use a text editor, such as Word.

    Just paste it into the bottom of a post. It should be pretty obvious to me what is part of the QIF file.


    Thursday, March 8, 2018 9:51 PM
    Moderator
  • Thanks Cal Learner in advance for your help.

    I created the qif file but cannot post it to this forum. I drags the qif file to the message box that I was writing and not successful. I copied the file and then  Ctrl + V in the message that I was writing but not successful. How to do this?

    Thank you.

    Friday, March 9, 2018 6:06 AM
  • Open the QIF file in Notepad. (Not too big of a QIF file.)

    Press Cntl+A.

    Press Cntl+C.

    That selects the entire file, and then copies the entire file into the clipboard.

    Reply here, and click into the box. Press  Ctrl + V.

    Then Submit.



    Friday, March 9, 2018 6:10 AM
    Moderator
  • Thank you. I open the QIF file in Notepad, select all, copy and paste as follows:

    !Type:Class
    NRoot Account
    DRoot Account
    ^
    !Type:Cat
    !Option:AutoSwitch
    !Account
    NIB-GBP
    DIB-GBP
    TInvst
    ^
    !Clear:AutoSwitch
    !Type:Security
    NBLND British Land Company PLC
    SBLND
    TStock
    ^
    !Type:Security
    NESP Empiric Student Property PLC
    SESP
    TStock
    ^
    !Type:Security
    NMXF Medicx Fund Ltd.
    SMXF
    TStock
    ^
    !Type:Security
    NTHRL Target Healthcare REIT Ltd
    STHRL
    TStock
    ^
    !Option:AutoSwitch
    !Account
    NIB-GBP
    DIB-GBP
    TInvst
    ^
    !Type:Invst
    D05/03/2017
    NMiscExp
    YBLND British Land Company PLC
    T0.00
    M
    LInvestment:Broker Interest Paid and Received
    O34.20
    ^
    D04/05/2017
    NMiscExp
    YBLND British Land Company PLC
    T0.00
    M
    LInvestment:Broker Interest Paid and Received
    O12.75
    ^
    D03/02/2017
    NMiscExp
    YESP Empiric Student Property PLC
    T0.00
    M
    LInvestment:Broker Interest Paid and Received
    O1.68
    ^
    D02/03/2017
    NMiscExp
    YESP Empiric Student Property PLC
    T0.00
    M
    LInvestment:Broker Interest Paid and Received
    O1.86
    ^
    D12/02/2016
    NMiscExp
    YESP Empiric Student Property PLC
    T0.00
    M
    LInvestment:Broker Interest Paid and Received
    O1.80
    ^
    D01/05/2017
    NMiscExp
    YESP Empiric Student Property PLC
    T0.00
    M
    LInvestment:Broker Interest Paid and Received
    O1.86
    ^
    D11/10/2016
    NDiv
    YESP Empiric Student Property PLC
    U15.00
    T15.00
    O0.00
    ^
    D11/03/2016
    NMiscExp
    YESP Empiric Student Property PLC
    T0.00
    M
    LInvestment:Broker Interest Paid and Received
    O1.86
    ^
    D10/05/2016
    NMiscExp
    YESP Empiric Student Property PLC
    T0.00
    M
    LInvestment:Broker Interest Paid and Received
    O1.32
    ^
    D09/07/2016
    NBuy
    YESP Empiric Student Property PLC
    I117
    Q10
    U1181.85
    T1181.85
    O11.85
    ^
    !Type:Prices
    "BLND",5897.56097561,"04/03/2017"
    "BLND",5941.46341463,"04/04/2017"
    "BLND",6068.29268293,"04/05/2017"
    "BLND",6204.87804878,"04/06/2017"
    "BLND",6321.95121951,"04/07/2017"
    "BLND",6302.43902439,"04/10/2017"
    "BLND",6288.61003861,"04/11/2017"
    "BLND",6303.08880309,"04/12/2017"
    "BLND",6711.84738956,"05/02/2017"
    "BLND",6731.92771084,"05/03/2017"
    "BLND",6683.46774194,"05/05/2017"
    "BLND",6787.58829465,"05/08/2017"
    "BLND",6748.99193548,"05/09/2017"
    "BLND",6713.70967742,"05/10/2017"
    "BLND",6723.79032258,"05/11/2017"
    "BLND",6774.19354839,"05/12/2017"
    "BLND",6398.6013986,"06/01/2017"
    "BLND",6292.76123876,"06/02/2017"
    "BLND",6324.26988922,"06/06/2017"
    "BLND",6384.69284995,"06/07/2017"
    "BLND",6369.58710977,"06/09/2017"
    "BLND",6252.47524752,"06/12/2017"
    "BLND",6102.12335693,"07/03/2017"
    "BLND",6084.76286579,"07/05/2017"
    "BLND",6132.4570273,"07/06/2017"
    "BLND",6147.62386249,"07/07/2017"
    "BLND",6267.89366053,"08/02/2017"
    "BLND",6334.02275078,"08/04/2017"
    "BLND",6344.36401241,"08/07/2017"
    "BLND",6390.89968976,"08/09/2017"
    "BLND",6142.1319797,"08/11/2017"
    "BLND",5819.75071908,"03/12/2018"
    "BLND",6294.91119691,"04/01/2018"
    "BLND",6516.96606786,"04/07/2018"
    "BLND",6467.06586826,"04/08/2018"
    "BLND",6432.13572854,"04/09/2018"
    "BLND",6482.75347913,"04/12/2018"
    "BLND",6748.74371859,"05/03/2018"
    "BLND",6547.73869347,"05/05/2018"
    "BLND",6417.08542714,"05/06/2018"
    "BLND",6309.69547739,"05/07/2018"
    "BLND",6480.73022312,"05/10/2018"
    "BLND",6440.16227181,"05/11/2018"
    "BLND",6455.37525355,"05/12/2018"
    "BLND",6364.55186304,"06/04/2018"
    "BLND",6171.48554337,"06/10/2018"
    "BLND",6137.51263903,"07/02/2018"
    "BLND",6378.43336724,"07/07/2018"
    "BLND",6284.26395939,"07/09/2018"
    "BLND",6340.10152284,"08/04/2018"
    "BLND",6329.94923858,"08/05/2018"
    "BLND",6203.04568528,"08/06/2018"
    "BLND",6097.68378651,"08/09/2018"
    "BLND",6148.03625378,"08/10/2018"
    "BLND",5838.17829457,"03/03/2019"
    "BLND",5804.26356589,"03/04/2019"
    "BLND",5833.33333333,"03/05/2019"
    "BLND",5741.27906977,"03/06/2019"
    "BLND",5910.85271318,"03/07/2019"
    "BLND",6637.85140562,"04/03/2019"
    "BLND",6614.15436747,"04/04/2019"
    "BLND",6399.59432049,"05/01/2019"
    "BLND",6420.39579108,"05/02/2019"
    "BLND",6358.64135864,"05/06/2019"
    "BLND",6333.66633367,"05/07/2019"
    "BLND",6158.90688259,"06/04/2019"
    ^
    !Type:Prices
    "ESP",203.18076804,"09/06/2016"
    "ESP",200.93095423,"09/07/2016"
    "ESP",201.16369279,"09/08/2016"
    "ESP",12.1001032,"09/09/2016"
    "ESP",12.07430341,"09/12/2016"
    "ESP",11.80625631,"10/03/2016"
    "ESP",10.41675076,"10/04/2016"
    "ESP",11.80625631,"10/05/2016"
    "ESP",10.41675076,"10/06/2016"
    "ESP",11.1084453,"10/07/2016"
    "ESP",9.90690979,"10/10/2016"
    "ESP",11.22840691,"10/11/2016"
    "ESP",9.90690979,"10/12/2016"
    "ESP",9.80188679,"11/01/2016"
    "ESP",9.80188679,"11/02/2016"
    "ESP",10.54245283,"11/03/2016"
    "ESP",10.49528302,"11/04/2016"
    "ESP",10.51886792,"11/07/2016"
    "ESP",10.69711538,"11/08/2016"
    "ESP",10.67307692,"11/09/2016"
    "ESP",10.43269231,"11/10/2016"
    "ESP",10.48076923,"11/11/2016"
    "ESP",10.0192864,"12/01/2016"
    "ESP",10.49412916,"12/02/2016"
    "ESP",10.61643836,"12/05/2016"
    "ESP",10.16634051,"12/06/2016"
    "ESP",10.16634051,"12/07/2016"
    "ESP",10.71428571,"12/08/2016"
    "ESP",10.66536204,"12/09/2016"
    "ESP",10.14648437,"12/12/2016"
    "ESP",10.14354067,"01/02/2017"
    "ESP",10.11961722,"01/03/2017"
    "ESP",10.04784689,"01/04/2017"
    "ESP",10.04784689,"01/05/2017"
    "ESP",10.11961722,"01/06/2017"
    "ESP",9.90467112,"01/09/2017"
    "ESP",10.00953289,"01/10/2017"
    "ESP",10.08102955,"01/11/2017"
    "ESP",9.90467112,"01/12/2017"
    "ESP",10.08737864,"02/01/2017"
    "ESP",10.19627085,"02/02/2017"
    "ESP",10.19627085,"02/03/2017"
    "ESP",10.50049068,"02/06/2017"
    "ESP",10.19627085,"02/07/2017"
    "ESP",10.19627085,"02/08/2017"
    "ESP",10.54955839,"02/09/2017"
    "ESP",10.50049068,"02/10/2017"
    "ESP",10.63880884,"03/01/2017"
    "ESP",10.61479347,"03/02/2017"
    "ESP",10.54274736,"03/03/2017"
    "ESP",9.9807877,"03/06/2017"
    "ESP",9.9807877,"03/07/2017"
    "ESP",10.5907781,"03/08/2017"
    "ESP",10.46786389,"03/09/2017"
    "ESP",10.42060491,"03/10/2017"
    "ESP",10.13658537,"04/03/2017"
    "ESP",10.13658537,"04/04/2017"
    "ESP",10.13658537,"04/05/2017"
    "ESP",10.6097561,"04/06/2017"
    "ESP",10.70731707,"04/07/2017"
    "ESP",10.12292683,"04/10/2017"
    "ESP",10.64189189,"04/11/2017"
    "ESP",10.69015444,"04/12/2017"
    "ESP",1094.37751004,"05/02/2017"
    "ESP",1099.39759036,"05/03/2017"
    "ESP",1113.91129032,"05/05/2017"
    "ESP",1117.5580222,"05/08/2017"
    "ESP",1131.55241935,"05/09/2017"
    "ESP",1131.55241935,"05/10/2017"
    "ESP",1134.07258065,"05/11/2017"
    "ESP",1141.63306452,"05/12/2017"
    "ESP",1136.36363636,"06/01/2017"
    "ESP",1129.09627373,"06/02/2017"
    "ESP",1120.34239678,"06/06/2017"
    "ESP",1127.89526687,"06/07/2017"
    "ESP",1130.41289023,"06/09/2017"
    "ESP",1103.96039604,"06/12/2017"
    "ESP",1127.40141557,"07/03/2017"
    "ESP",1120.08072654,"07/05/2017"
    "ESP",1129.92922144,"07/06/2017"
    "ESP",1127.40141557,"07/07/2017"
    "ESP",1119.63190184,"08/02/2017"
    "ESP",1134.95346432,"08/04/2017"
    "ESP",1137.53877973,"08/07/2017"
    "ESP",1128.04878049,"08/10/2017"
    "ESP",1126.9035533,"08/11/2017"
    "ESP",12.08677686,"09/01/2017"
    "ESP",12.00929752,"09/02/2017"
    "ESP",12.03512397,"09/03/2017"
    "ESP",12.08677686,"09/04/2017"
    "ESP",12.11260331,"09/07/2017"
    "ESP",12.08677686,"09/08/2017"
    "ESP",11.71875,"09/09/2017"
    "ESP",11.71875,"09/10/2017"
    "ESP",11.66834677,"09/11/2017"
    "ESP",11.18042226,"10/01/2017"
    "ESP",11.13243762,"10/02/2017"
    "ESP",9.76631977,"10/05/2017"
    "ESP",9.82970672,"10/06/2017"
    "ESP",10.97445601,"10/07/2017"
    "ESP",10.95080416,"10/08/2017"
    "ESP",10.90350047,"10/09/2017"
    "ESP",10.95825427,"10/12/2017"
    "ESP",10.43269231,"11/02/2017"
    "ESP",10.40865385,"11/03/2017"
    "ESP",10.0483559,"11/04/2017"
    "ESP",10.49323017,"11/05/2017"
    "ESP",10.29980658,"11/06/2017"
    "ESP",10.39651838,"11/09/2017"
    "ESP",10.44487427,"11/10/2017"
    "ESP",10.0483559,"11/11/2017"
    "ESP",10.0192864,"11/12/2017"
    "ESP",10.57128906,"12/01/2017"
    "ESP",10.546875,"12/02/2017"
    "ESP",10.14648437,"12/03/2017"
    "ESP",10.40039062,"12/04/2017"
    "ESP",10.14648437,"12/07/2017"
    "ESP",10.22179364,"12/08/2017"
    "ESP",10.31822565,"12/09/2017"
    "ESP",10.29411765,"12/10/2017"
    "ESP",10.14946962,"12/11/2017"
    "ESP",10.29551954,"01/01/2018"
    "ESP",9.82041588,"01/04/2018"
    "ESP",10.27882798,"01/05/2018"
    "ESP",9.82041588,"01/06/2018"
    "ESP",9.82041588,"01/07/2018"
    "ESP",10.13705104,"01/08/2018"
    "ESP",9.82041588,"01/11/2018"
    "ESP",10.08737864,"01/12/2018"
    "ESP",10.06782946,"02/01/2018"
    "ESP",10.51356589,"02/02/2018"
    "ESP",10.58624031,"02/03/2018"
    "ESP",10.58624031,"02/04/2018"
    "ESP",10.58624031,"02/05/2018"
    "ESP",10.61046512,"02/08/2018"
    "ESP",10.62439497,"02/09/2018"
    "ESP",10.60019361,"02/10/2018"
    "ESP",10.50338819,"02/11/2018"
    "ESP",10.50338819,"02/12/2018"
    "ESP",10.42060491,"03/01/2018"
    "ESP",10.30245747,"03/02/2018"
    "ESP",10.30245747,"03/03/2018"
    "ESP",10.30245747,"03/04/2018"
    "ESP",10.54650048,"03/05/2018"
    "ESP",10.49856184,"03/08/2018"
    "ESP",10.42665388,"03/09/2018"
    "ESP",10.4506232,"03/10/2018"
    "ESP",10.35474593,"03/11/2018"
    "ESP",1080.98455598,"04/01/2018"
    "ESP",1127.74451098,"04/07/2018"
    "ESP",1097.80439122,"04/08/2018"
    "ESP",1090.31936128,"04/09/2018"
    "ESP",1085.96421471,"04/12/2018"
    "ESP",1153.26633166,"05/03/2018"
    "ESP",1155.77889447,"05/05/2018"
    "ESP",1130.65326633,"05/06/2018"
    "ESP",1143.87236181,"05/07/2018"
    "ESP",1158.72210953,"05/10/2018"
    "ESP",1153.65111562,"05/11/2018"
    "ESP",1158.72210953,"05/12/2018"
    "ESP",1163.14199396,"06/04/2018"
    "ESP",1134.09770688,"06/10/2018"
    "ESP",1132.4570273,"07/02/2018"
    "ESP",1139.36927772,"07/07/2018"
    "ESP",1109.13705584,"07/09/2018"
    "ESP",1129.44162437,"08/02/2018"
    "ESP",1134.5177665,"08/03/2018"
    "ESP",1139.59390863,"08/04/2018"
    "ESP",1129.44162437,"08/05/2018"
    "ESP",1129.44162437,"08/06/2018"
    "ESP",1125.3776435,"08/09/2018"
    "ESP",1127.89526687,"08/10/2018"
    "ESP",11.74395161,"09/02/2018"
    "ESP",10.40625,"09/03/2018"
    "ESP",11.69354839,"09/04/2018"
    "ESP",11.73057518,"09/05/2018"
    "ESP",10.41675076,"09/06/2018"
    "ESP",10.88709677,"10/01/2018"
    "ESP",10.86337761,"10/02/2018"
    "ESP",10.5313093,"10/03/2018"
    "ESP",10.48387097,"10/04/2018"
    "ESP",10.44811321,"10/07/2018"
    "ESP",10.0192864,"11/01/2018"
    "ESP",10.0192864,"11/04/2018"
    "ESP",10.6075217,"11/05/2018"
    "ESP",10.70395371,"11/06/2018"
    "ESP",10.0192864,"12/02/2018"
    "ESP",10.0192864,"12/03/2018"
    "ESP",10.14946962,"12/04/2018"
    "ESP",10.0192864,"12/05/2018"
    "ESP",10.22179364,"12/06/2018"
    "ESP",10.4368932,"01/01/2019"
    "ESP",10.50970874,"01/02/2019"
    "ESP",10.53398058,"01/03/2019"
    "ESP",10.08737864,"01/06/2019"
    "ESP",10.08737864,"01/07/2019"
    "ESP",10.05808325,"02/03/2019"
    "ESP",10.05808325,"02/04/2019"
    "ESP",10.5620155,"03/03/2019"
    "ESP",10.63468992,"03/04/2019"
    "ESP",10.5620155,"03/05/2019"
    "ESP",10.51356589,"03/06/2019"
    "ESP",10.06782946,"03/07/2019"
    "ESP",1104.91967871,"04/03/2019"
    "ESP",1099.39759036,"04/04/2019"
    "ESP",1153.24581136,"05/01/2019"
    "ESP",1158.72210953,"05/02/2019"
    "ESP",1133.86613387,"05/06/2019"
    "ESP",1131.36863137,"05/07/2019"
    "ESP",1126.01214575,"06/04/2019"
    ^
    !Type:Prices
    "MXF",895.18555667,"06/05/2017"
    "MXF",896.27391742,"06/07/2017"
    "MXF",901.30916415,"06/09/2017"
    "MXF",877.22772277,"06/12/2017"
    "MXF",897.3710819,"07/03/2017"
    "MXF",890.51463169,"07/05/2017"
    "MXF",884.73205258,"07/06/2017"
    "MXF",907.48230536,"07/07/2017"
    "MXF",922.80163599,"08/02/2017"
    "MXF",930.71354705,"08/04/2017"
    "MXF",941.05480869,"08/07/2017"
    "MXF",930.71354705,"08/09/2017"
    "MXF",931.47208122,"08/11/2017"
    "MXF",901.30916415,"09/01/2017"
    "MXF",925.45638945,"09/08/2017"
    "MXF",939.1124871,"09/11/2017"
    "MXF",927.99188641,"09/12/2017"
    "MXF",961.33474576,"10/03/2017"
    "MXF",934.26501035,"10/06/2017"
    "MXF",926.48539778,"06/04/2018"
    "MXF",897.30807577,"06/10/2018"
    "MXF",913.80182002,"07/02/2018"
    "MXF",913.02136317,"07/07/2018"
    "MXF",916.24365482,"07/09/2018"
    "MXF",931.47208122,"08/02/2018"
    "MXF",934.01015228,"08/03/2018"
    "MXF",923.85786802,"08/04/2018"
    "MXF",906.09137056,"08/05/2018"
    "MXF",903.55329949,"08/06/2018"
    "MXF",901.30916415,"08/09/2018"
    "MXF",906.34441088,"08/10/2018"
    "MXF",906.34441088,"08/11/2018"
    "MXF",901.30916415,"08/12/2018"
    "MXF",928.42323651,"09/01/2018"
    "MXF",936.2033195,"09/02/2018"
    "MXF",933.60995851,"09/03/2018"
    "MXF",933.60995851,"09/06/2018"
    "MXF",923.23651452,"09/07/2018"
    "MXF",938.7966805,"09/08/2018"
    "MXF",971.9279661,"09/10/2018"
    "MXF",900.8097166,"06/04/2019"
    "MXF",891.23867069,"08/01/2019"
    "MXF",955.64941922,"09/01/2019"
    "MXF",945.37815126,"09/02/2019"
    "MXF",961.33474576,"09/03/2019"
    ^
    !Type:Prices
    "THRL",1186.05817452,"06/05/2017"
    "THRL",1195.87109768,"06/07/2017"
    "THRL",1188.31822759,"06/09/2017"
    "THRL",1171.78217822,"06/12/2017"
    "THRL",1185.54095046,"07/03/2017"
    "THRL",1195.76185671,"07/05/2017"
    "THRL",1185.54095046,"07/06/2017"
    "THRL",1195.65217391,"07/07/2017"
    "THRL",1224.43762781,"08/02/2017"
    "THRL",1225.43950362,"08/04/2017"
    "THRL",1230.61013444,"08/07/2017"
    "THRL",1248.7073423,"08/09/2017"
    "THRL",1238.5786802,"08/11/2017"
    "THRL",1175.73011078,"09/01/2017"
    "THRL",1163.79310345,"09/08/2017"
    "THRL",1199.69040248,"09/11/2017"
    "THRL",1184.07707911,"09/12/2017"
    "THRL",1242.05508475,"10/03/2017"
    "THRL",1195.65217391,"10/06/2017"
    "THRL",1201.23203285,"10/09/2017"
    "THRL",1208.59213251,"10/10/2017"
    "THRL",1182.71221532,"10/11/2017"
    "THRL",1203.42396777,"06/04/2018"
    "THRL",1176.47058824,"06/10/2018"
    "THRL",1205.76339737,"07/02/2018"
    "THRL",1214.21267894,"07/06/2018"
    "THRL",1226.99386503,"07/08/2018"
    "THRL",1241.11675127,"08/04/2018"
    "THRL",1233.50253807,"08/05/2018"
    "THRL",1228.42639594,"08/06/2018"
    "THRL",1228.60020141,"08/09/2018"
    "THRL",1221.04733132,"08/10/2018"
    "THRL",1216.01208459,"08/11/2018"
    "THRL",1188.31822759,"08/12/2018"
    "THRL",1218.87966805,"09/01/2018"
    "THRL",1234.43983402,"09/03/2018"
    "THRL",1229.25311203,"09/06/2018"
    "THRL",1211.09958506,"09/07/2018"
    "THRL",1231.84647303,"09/08/2018"
    "THRL",1257.94491525,"09/10/2018"
    "THRL",1201.92307692,"06/04/2019"
    "THRL",1178.24773414,"08/01/2019"
    "THRL",1260.59322034,"09/01/2019"
    "THRL",1257.94491525,"09/03/2019"
    ^

    Friday, March 9, 2018 6:28 AM
  • Money QIF files must begin with one of these on a line by itself:
    !Type:Bank
    !Type:CCard
    !Type:Invst
    !Type:Oth A
    !Type:Oth L
    !Type:Cash

    The associated cash account for an investment account in Money
    (called "contributions " for tax deferred such as IRA) is !Type:Bank
    I don't know why, and maybe it could be !Type:Cash, but for me it is !Type:Bank

    Each record ends in a line with only ^. The line must end with a newline
    so in Notepad that shows as a blank line as the last thing in the file.
    There are no blank lines other than the one that may appear as a blank
    line last in the file.

    All leading spaces must be eliminated. What I pasted from your
    MoneyDance file had spaces. These must be removed. This would be the
    biggest effort in making the Money QIF files, I think.

    It may be that you could extract more than one Money QIF from a file.
    Each time you see a new !Type, that is not included with the transactions
    that preceded that.

    I might be able to write a program in Python to try to extract the Money QIF
    files from Moneydance QIF. It would take some work, and it would take
    work for you to install Python and learn a little about running it. Somebody
    else might do it in a different language.

    To see what Money wants, create a test file with some accounts and transactions. Export accounts as loose QIF.

    ANOTHER problem that I did not address in the QIF below. The MoneyDance QIF dates are MM/DD/YYYY, rather than day/month/year. Money QIF files are set to match the regional settings in Windows. So if your computer is set for DD/MM/YYYY, you could either change that temporarily before importing, or you would modify the QIF files. I suspect there are programs made to do that.

    Below is your file after I modified it, removing stuff Money doesn't handle and removing the leading spaces on lines:

    =========begin 1Broker.qif====================
    !Type:Invst
    D05/03/2017
    NMiscExp
    YBLND British Land Company PLC
    T0.00
    M
    LInvestment:Broker Interest Paid and Received
    O34.20
    ^
    D04/05/2017
    NMiscExp
    YBLND British Land Company PLC
    T0.00
    M
    LInvestment:Broker Interest Paid and Received
    O12.75
    ^
    D03/02/2017
    NMiscExp
    YESP Empiric Student Property PLC
    T0.00
    M
    LInvestment:Broker Interest Paid and Received
    O1.68
    ^
    D02/03/2017
    NMiscExp
    YESP Empiric Student Property PLC
    T0.00
    M
    LInvestment:Broker Interest Paid and Received
    O1.86
    ^
    D12/02/2016
    NMiscExp
    YESP Empiric Student Property PLC
    T0.00
    M
    LInvestment:Broker Interest Paid and Received
    O1.80
    ^
    D01/05/2017
    NMiscExp
    YESP Empiric Student Property PLC
    T0.00
    M
    LInvestment:Broker Interest Paid and Received
    O1.86
    ^
    D11/10/2016
    NDiv
    YESP Empiric Student Property PLC
    U15.00
    T15.00
    O0.00
    ^
    D11/03/2016
    NMiscExp
    YESP Empiric Student Property PLC
    T0.00
    M
    LInvestment:Broker Interest Paid and Received
    O1.86
    ^
    D10/05/2016
    NMiscExp
    YESP Empiric Student Property PLC
    T0.00
    M
    LInvestment:Broker Interest Paid and Received
    O1.32
    ^
    D09/07/2016
    NBuy
    YESP Empiric Student Property PLC
    I117
    Q10
    U1181.85
    T1181.85
    O11.85
    ^

    Friday, March 9, 2018 4:01 PM
    Moderator
  • Thank you Cal Learner for your helpfulness and sorry for the delay in reply because of travelling.

    The modified qif works fine and, this time, MS Money allow me to input smoothly. However, it will be an extremely tedious work ,manually (using notepad), to clean up all the non-compatible format in Moneydance in order to import into MS Money.

    Being a non-tech person with very little programming background, I may need to wait you and other experienced user to write a Python program to clean up this non-compatible format. But I know this will be at the low priority given that it is not popular for people switching from Monedyance to MS money.

    Thank you again for spending time to look into my issues.

    Monday, March 12, 2018 7:07 AM
  • Cal,

    I'd be happy to publish an article in my blog for you if you get around to writing a Python program to accomplish this.  It might be useful to other Moneydance users that never thought it would be possible to switch to Money.

    Thursday, March 15, 2018 4:15 AM
  • File was uploaded successfuly on TinyUpload.com server.
    You can download it from address: http://s000.tinyupload.com/?file_id=20500603991720443752

    zip file include the QIF file I tested with. While this is intended to work for a Moneydance file with multiple accounts, it was only tested with that qif file that is in the zip file.

    Pyleta and Ameridan... let me know how it works...

    For all I know, it could work with some other financial programs.

    There is a *.txt file in the zip file.

    This produces one file per account. All of those QIF files need to be imported into Money all*at*once to allow transfers to  be recognized.


    Saturday, March 17, 2018 11:17 PM
    Moderator