tag:infinitekind.tenderapp.com,2009-01-14:/discussions/switching-from-another-personal-finance-program/13273-uploading-an-entire-entity-file-of-linked-accountsInfinite Kind: Discussion 2020-06-12T21:41:32Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/471600682019-04-09T07:38:53Z2019-04-09T07:38:53ZUploading an entire entity file of linked accounts<div><p>I am not support staff, just a user.</p>
<p>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.</p>
<p>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.</p>
<p>Hope this helps</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/471600682019-04-09T07:48:50Z2019-04-09T07:48:50ZUploading an entire entity file of linked accounts<div><p>Thank you Derek.</p>
<p>I uploaded the file by accident. Could you please delete it and could anyone else who sees this please do the same.</p>
<p>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?</p>
<p>Thanks again for your helpful response.</p>
<p>Cheers,</p>
<p>Bob</p></div>Bob Allentag:infinitekind.tenderapp.com,2009-01-14:Comment/471600682019-04-09T08:32:52Z2019-04-09T08:32:52ZUploading an entire entity file of linked accounts<div><p>I am not support staff, just a user.</p>
<p>Sorry only support staff can delete attachments.</p>
<p>Exporting one account at a time is OK.</p>
<p>Try things out for yourself.</p>
<p>Download from <a href="https://infinitekind.com/preview">https://infinitekind.com/preview</a></p>
<p>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 <a href="https://infinitekind.com/refunds">https://infinitekind.com/refunds</a><br>
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.<br>
For further info see <a href="http://help.infinitekind.com/kb">http://help.infinitekind.com/kb</a></p>
<p>To import your data first select the account which you think has the most transfers.<br>
Then under ACCOUNT – NEW ACCOUNT set this account up. Its important to use the account name exactly as used in your old software.<br>
Then Drag and Drop this QIF file into the side bar, the list on the left.<br>
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.<br>
If you make an error simply start again by setting up a new data set FILE – (MONEYDANCE on Mac) – NEW.</p>
<p>Let us know how you get on.</p>
<p>Hope this helps</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/471600682019-04-09T09:02:37Z2019-04-09T09:02:37ZUploading an entire entity file of linked accounts<div><p>I'm a fellow user.</p>
<p>Importing one account at a time does not cause loss of transfers. If you take no action however it does result in duplicate transactions.</p>
<p>There are approaches you can take to reduce or eliminate this problem however.</p>
<p>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</p>
<p>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.</p>
<p>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.</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/471600682019-04-09T22:02:16Z2019-04-09T22:02:17ZUploading an entire entity file of linked accounts<div><p>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.</p>
<p>Cheers,</p>
<p>Bob</p></div>Bob Allentag:infinitekind.tenderapp.com,2009-01-14:Comment/471600682019-04-09T22:03:46Z2019-04-09T22:03:47ZUploading an entire entity file of linked accounts<div><p>Many thanks dwg. I’ll let you know how I get on.</p>
<p>Cheers,</p>
<p>Bob</p></div>Bob Allentag:infinitekind.tenderapp.com,2009-01-14:Comment/471600682019-04-09T22:23:04Z2019-04-09T22:23:04ZUploading an entire entity file of linked accounts<div><p>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.</p>
<p>I am seeing a problem around Investment accounts however..</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/471600682019-04-09T22:31:00Z2019-04-09T22:31:00ZUploading an entire entity file of linked accounts<div><p>Thanks.</p>
<p>Bob</p></div>Bob Allentag:infinitekind.tenderapp.com,2009-01-14:Comment/471600682019-04-10T06:11:29Z2019-04-10T06:11:30ZUploading an entire entity file of linked accounts<div><p>Hi again Derek.</p>
<p>Not much progress I’m afraid.</p>
<p>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.</p>
<p>There has to be an easy solution to this but for the time being it escapes me. Can you help?</p>
<p>Cheers,</p>
<p>Bob</p></div>Bob Allentag:infinitekind.tenderapp.com,2009-01-14:Comment/471600682019-04-10T07:00:52Z2019-04-10T07:00:53ZUploading an entire entity file of linked accounts<div><p>I finally found the base currency selector in ’Tools’.</p></div>Bob Allentag:infinitekind.tenderapp.com,2009-01-14:Comment/471600682019-04-10T07:01:22Z2019-04-10T07:01:22ZUploading an entire entity file of linked accounts<div><p>I'm a fellow user.</p>
<p>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.</p>
<p>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.</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/471600682019-04-10T07:13:32Z2019-04-10T07:13:32ZUploading an entire entity file of linked accounts<div><p>I am not support staff, just a user.<br>
Hi Bod</p>
<p>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.</p>
<p>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.</p>
<p>Sorry but you need to start again FILE – (MONEYDANCE on Mac) – NEW.</p>
<p>Hope this helps</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/471600682019-04-10T07:16:14Z2019-04-10T07:16:14ZUploading an entire entity file of linked accounts<div><p>I am not support staff, just a user.<br>
Hi Bod</p>
<p>Currency set up new data set.</p>
<p>Hope this helps</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/471600682020-06-11T11:36:07Z2020-06-11T11:36:08ZUploading an entire entity file of linked accounts<div><p>Hi Derek.</p>
<p>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.</p>
<p>I imagine you are still not Moneydance support staff, but I hope you are still a very helpful user.</p>
<p>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.</p>
<p>I look forward to hearing back from you.</p>
<p>Cheers,</p>
<p>Bob</p></div>Bob Allentag:infinitekind.tenderapp.com,2009-01-14:Comment/471600682020-06-11T12:45:42Z2020-06-11T12:45:42ZUploading an entire entity file of linked accounts<div><p>I am not support staff, just a user.<br>
Hi Bob</p>
<p>I am still here in these strange times and well, thank you.</p>
<p>I am not an Apple user, so forgive me, but is an iPad Pro a Mac or iOS device?</p>
<p>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.</p>
<p>If iPad Pro runs on Mac I can help.</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/471600682020-06-11T21:39:24Z2020-06-11T21:39:24ZUploading an entire entity file of linked accounts<div><p>I'm a fellow user.</p>
<p>As far as I am aware this system runs iPadOS which is an ipad specific version of IOS.</p>
<p>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..</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/471600682020-06-12T04:12:17Z2020-06-12T04:12:18ZUploading an entire entity file of linked accounts<div><p>Thanks Derek.</p>
<p>iPad Pro runs IOS so it appears I’m stuck with my MacBook for the time<br>
being.</p>
<p>Keep well.</p>
<p>Bob</p></div>Bob Allentag:infinitekind.tenderapp.com,2009-01-14:Comment/471600682020-06-12T06:43:33Z2020-06-12T06:43:33ZUploading an entire entity file of linked accounts<div><p>I am not support staff, just a user.<br>
Hi Bob</p>
<p>Sorry yes,</p>
<p>Have Fun, Stay Safe.</p></div>derekkent23