Uploading an entire entity file of linked accounts

Bob Allen's Avatar

Bob Allen

09 Apr, 2019 06:35 AM

I have a personal pension fund entity with multiple bank and investment accounts and a lot of money moving between accounts over 10 years currently running on Jumsoft's Money 4. I am interested in switching to your application. Could I upload the entire file to your application?

The file is 3.3MB

  1. 1 Posted by derekkent23 on 09 Apr, 2019 07:38 AM

    derekkent23's Avatar

    I am not support staff, just a user.

    Your post is in the public section of the Moneydance forum, you did not make it private so I hope there is nothing in the attachment that you don't want the public to see.

    You can only import QIF files into Moneydance exported from your software. If the attached file is a Jumsoft's Money 4 file no other software can read it. Can Jumsoft's Money 4 export in the QIF format? If so Moneydance can import it.

    Hope this helps

  2. 2 Posted by Bob Allen on 09 Apr, 2019 07:48 AM

    Bob Allen's Avatar

    Thank you Derek.

    I uploaded the file by accident. Could you please delete it and could anyone else who sees this please do the same.

    I think Money 4 can export in QIF format, but only one account at a time. I suspect this would mean that all transfers between accounts would be lost. Do you agree?

    Thanks again for your helpful response.

    Cheers,

    Bob

  3. 3 Posted by derekkent23 on 09 Apr, 2019 08:32 AM

    derekkent23's Avatar

    I am not support staff, just a user.

    Sorry only support staff can delete attachments.

    Exporting one account at a time is OK.

    Try things out for yourself.

    Download from https://infinitekind.com/preview

    Downloaded version of Moneydance is a full working version with the only limit being a maximum of 100 manually entered transactions, with no time limit. Imported files from other financial programs and your bank have no limit on imports. If you decided to purchase you are sent a key by email that unlocks the 100-manual transaction limit. If after testing with this free trial version you purchase and change your mind see the 90 day money back guaranty at https://infinitekind.com/refunds
    For the future Moneydance never sunsets the version it releases. So, you don’t have to upgrade. If you won’t to upgrade the next version is free (say 2017 to 2019) and from then on you get a 50% discount. All upgrades within a version are free.
    For further info see http://help.infinitekind.com/kb

    To import your data first select the account which you think has the most transfers.
    Then under ACCOUNT – NEW ACCOUNT set this account up. Its important to use the account name exactly as used in your old software.
    Then Drag and Drop this QIF file into the side bar, the list on the left.
    An import window should open. This should list your selected account plus all the account it interacts with. Look down the list and make sure the account is of the correct type. E.g. any credit card accounts change the type from bank to credit card. Then highlight the account name you imported and click IMPORT. After a processing delay your accounts should start to appear in the side bar. Some accounts may not appear in the side bar click “+” at the bottom to add them. Only the account whose QIF file you imported will have the correct balance, all the rest just the vales of transfers. Repeat the process for all your other accounts. If an account is not listed you will need to set it up. As you import each account balances will start to correct themselves. Any closed account in your old software that have transfers will need to be opened and exported and then imported to correct account balances.
    If you make an error simply start again by setting up a new data set FILE – (MONEYDANCE on Mac) – NEW.

    Let us know how you get on.

    Hope this helps

  4. 4 Posted by dwg on 09 Apr, 2019 09:02 AM

    dwg's Avatar

    I'm a fellow user.

    Importing one account at a time does not cause loss of transfers. If you take no action however it does result in duplicate transactions.

    There are approaches you can take to reduce or eliminate this problem however.

    The approach I have taken is to import my main account first and get this balanced correctly. As this has transfers in it other accounts were created (actually I had created the accounts myself before starting, but the import should create them in any case), I take a note of the balance in this account and then take a backup of my moneydance dataset

    I then moved to one of the other accounts. The account will probably have some transfers to/from the main account, I delete all of the transactions in this account so I have a blank register ( this throws the main account out but that is expected. I then import the transactions into this account, if all goes well this account is populated and the deleted transactions are restored to this and the main account and I have recorded the balance I need in the main account to check against. I then proceed to do each subsequent bank and credit card account.

    I do all the bank type accounts before starting on investment accounts. Initially with investments I take the same approach to ensure all the transfers are correct then go to work on the investment transactions themselves.

  5. 5 Posted by Bob Allen on 09 Apr, 2019 10:02 PM

    Bob Allen's Avatar

    Many thanks Derek. Our internet has been down so I haven’t been able to do anything yet. I will follow your suggestion and Let you know how I get on.

    Cheers,

    Bob

  6. 6 Posted by Bob Allen on 09 Apr, 2019 10:03 PM

    Bob Allen's Avatar

    Many thanks dwg. I’ll let you know how I get on.

    Cheers,

    Bob

  7. 7 Posted by dwg on 09 Apr, 2019 10:23 PM

    dwg's Avatar

    I've just been performing some further testing with the latest version and duplicates appear to be taken care of by the new importer thus rendering my method obsolete i.e. suitable for Moneydance 2017 and earlier.

    I am seeing a problem around Investment accounts however..

  8. 8 Posted by Bob Allen on 09 Apr, 2019 10:31 PM

    Bob Allen's Avatar

    Thanks.

    Bob

  9. 9 Posted by Bob Allen on 10 Apr, 2019 06:11 AM

    Bob Allen's Avatar

    Hi again Derek.

    Not much progress I’m afraid.

    For some reason Moneydance has chosen to set my base currency as GBP and all the account balances and transactions as GBP. The numbers all represent the actual AUD figures (not GBP conversions of the AUD numbers). I can’t find in preferences or anywhere else a place where I can change the base currency. Also, it won’t allow me to change the currency from GBP to AUD in imported accounts. I set up the denomination of the first account as AUD but when I imported the QIF file for the account it didn’t populate the AUD account I set up, but rather set up an additional GBP denominated account with the same name. As already noted, it wouldn’t allow me to change the currency of denomination.

    There has to be an easy solution to this but for the time being it escapes me. Can you help?

    Cheers,

    Bob

  10. 10 Posted by Bob Allen on 10 Apr, 2019 07:00 AM

    Bob Allen's Avatar

    I finally found the base currency selector in ’Tools’.

  11. 11 Posted by dwg on 10 Apr, 2019 07:01 AM

    dwg's Avatar

    I'm a fellow user.

    You cannot change the category of an account or category once it has data in it. To do so you are asking Moneydance to convert all amounts to a different currency because the software has to make the assumption that all transactions are in the currency of the category/account they are in. Moneydance is unlikely to have enough information to do so.

    I'm assuming Moneydance now opens to a set of accounts. A way you can now import to a set of Australian accounts is to use the menu item File --> New to create brand new account set, one of the questions that will be asked is the base currency and you can set it to AUD. You can then try importing into this account set.

  12. 12 Posted by derekkent23 on 10 Apr, 2019 07:13 AM

    derekkent23's Avatar

    I am not support staff, just a user.
    Hi Bod

    When you set up a new data set one of the questions is Primary (base) Currency. Moneydance usually make a guess at the currency based on your computer setting, but if it gets it wrong you can change it here.

    You can change the base currency under TOOLS – CURRENCY but it will not change the currency of accounts already set up. It only changes currencies in reports, summary page etc.

    Sorry but you need to start again FILE – (MONEYDANCE on Mac) – NEW.

    Hope this helps

  13. 13 Posted by derekkent23 on 10 Apr, 2019 07:16 AM

    derekkent23's Avatar

    I am not support staff, just a user.
    Hi Bod

    Currency set up new data set.

    Hope this helps

  14. System closed this discussion on 10 Jul, 2019 07:20 AM.

  15. Bob Allen re-opened this discussion on 11 Jun, 2020 11:36 AM

  16. 14 Posted by Bob Allen on 11 Jun, 2020 11:36 AM

    Bob Allen's Avatar

    Hi Derek.

    It has been a long time since we last communicated and a lot, quite an understatement, has happened in the world since then. I hope you are safe and well and managing to cope.

    I imagine you are still not Moneydance support staff, but I hope you are still a very helpful user.

    I am i the process of moving most of my computer activity from my Macbook Air to the new iPad Pro 12.9” and I would like to move my complete Moneydance file across. Would yo be able to tell me how I might go about it.

    I look forward to hearing back from you.

    Cheers,

    Bob

  17. 15 Posted by derekkent23 on 11 Jun, 2020 12:45 PM

    derekkent23's Avatar

    I am not support staff, just a user.
    Hi Bob

    I am still here in these strange times and well, thank you.

    I am not an Apple user, so forgive me, but is an iPad Pro a Mac or iOS device?

    If its iOS then you can’t run Moneydance 2019 on it. You can only install the Moneydance mobile app which needs to sync with a computer and then only give access to bank and credit accounts with limited functionality.

    If iPad Pro runs on Mac I can help.

  18. 16 Posted by dwg on 11 Jun, 2020 09:39 PM

    dwg's Avatar

    I'm a fellow user.

    As far as I am aware this system runs iPadOS which is an ipad specific version of IOS.

    As Derek has said this system cannot run Moneydance, it does not support Java and that is the language the full version of Moneydance is written in. It can run the Mobile app, but the app has a requirement that somewhere you must be running a full version of Moneydance, whether it be on MacOS, Windows or Linux, the mobile app is is a helper application designed to facilitate on the move data entry..

  19. 17 Posted by Bob Allen on 12 Jun, 2020 04:12 AM

    Bob Allen's Avatar

    Thanks Derek.

    iPad Pro runs IOS so it appears I’m stuck with my MacBook for the time
    being.

    Keep well.

    Bob

  20. 18 Posted by derekkent23 on 12 Jun, 2020 06:43 AM

    derekkent23's Avatar

    I am not support staff, just a user.
    Hi Bob

    Sorry yes,

    Have Fun, Stay Safe.

  21. Maddy closed this discussion on 12 Jun, 2020 09:41 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac