tag:infinitekind.tenderapp.com,2009-01-14:/discussions/switching-from-another-personal-finance-program/18737-import-from-banktivity-multiple-currency-accountsInfinite Kind: Discussion 2021-07-21T03:20:19Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/491519512021-04-20T07:31:50Z2021-04-21T03:28:20ZImport From Banktivity Multiple Currency Accounts<div><p>I'm a disaffected Banktivity user trying to find alternatives and hence I am looking at Money Dance.</p>
<p>I have hit a number of problems that have made this look unachievable, but rather than throw in the towel I am asking first.</p>
<p>I have four working currencies in my Banktivity setup. QIF being a severely lacking but necessary evil doesn't handle currency, so my Banktivity export comes in four different files, one each for AUD, EUR, GBP and USD.</p>
<p>If I import each of these files sequentially I get duplication of accounts, because my money has travelled from GBP through an intermediary account which handles the FX and into the target account. If I import the (target) AUD accounts it generates the FX holding account. When I then import the (source) GBP accounts it generates the same holding account again, despite it having the same account name in the transfer records of both the GBP source account and the AUD target account.</p>
<p>How do I merge these duplicated accounts?</p>
<p>Also when I load the first QIF file it generates a phantom account that has no name but a whole bunch of transactions that relate to a variety of different accounts.</p>
<p>I have tested the QIF files with other packages and they have managed a generic import without issue.</p>
<p>Also on a fresh install of MoneyDance the import from another system presents me with the import screen which outlines the accounts, their type and their source currency. I can see no way to expand the currency list from the defaults offered, which means I am unable to start from the QIF files and have to create a MoneyDance file define the default currency and then run imports.</p>
<p>Thanks for help and pointers...</p></div>Confused Bankertag:infinitekind.tenderapp.com,2009-01-14:Comment/491519512021-04-20T08:21:43Z2021-04-20T08:21:43ZImport From Banktivity Multiple Currency Accounts<div><p>Hi,<br>
Thank you for contacting Moneydance support.</p>
<p>You would need to export your data from Banktivity to the QIF file format in order to import it into Moneydance.</p>
<p>Ideally you'll export one QIF file that contains all of your account data. Use the option to export 'all accounts' within one QIF file if this is available within the software you're using.<br>
If not, you should export one QIF file for each account in your file.</p>
<p>Make sure you export any closed or inactive accounts containing transfers to your open accounts. You may need to re-open these accounts before exporting.</p>
<p>If you're using Moneydance for the first time, when you open the program, you'll see the Welcome window. Choose “Create a new account set” and setup a new data file.<br>
If you have opened Moneydance previously, you can create a new data file by choosing File --> New --> Create a New File. Then follow the prompts to enter a name and currency for your new file.</p>
<p>When viewing your new data file, choose File --> Import. Then navigate to and select the QIF file.</p>
<p>You'll be asked which account you want to import your data into. If you have data for multiple accounts within one QIF file, you can pick any account.</p>
<p>Below this, Moneydance will automatically try to determine the date format and decimal character used within the QIF file.<br>
If you want to check this, open the QIF file with a text based program like NotePad or TextEdit. This will allow you to check which date format and decimal character are being used.</p>
<p>Choose 'Import' and wait a moment while your accounts and data are imported into Moneydance.</p>
<p>If it appears some of your accounts are missing from the left side bar, press the '+' button at the bottom of the side bar. Choose 'Advanced'. You should see the missing accounts in the panel on the left - highlight the account name and press 'Add' to move the accounts into the panel on the right. When you're done press OK and these accounts should then be available for selection from within the side bar.</p>
<p>Some QIF files don’t include an 'Initial Balance' for your accounts (sometimes referred to as a beginning balance or a starting balance). If this is the case, you'll see all transactions have imported but the account balance will show a discrepancy.<br>
To fix this, select the account and choose Account --> Edit Account. In this window, you can enter an amount into the 'Initial Balance' field.</p>
<p>For investment accounts, QIF file don’t always carry security prices other than buy/sell prices, so investment account balances may be wrong until you update with the current security prices.</p>
<p>Reminders are not included in QIF files as the QIF file format has no ability to include reminder data.</p>
<p>Finally, it may be worth referring you to <a href="https://infinitekind.tenderapp.com/kb/importing-data-from-other-programs/possible-problems-after-qif-import">this article</a> of the Knowledge Base on <strong>Possible Problems After QIF Import</strong>.</p>
<p>I hope this information is helpful. Please let us know if you have further questions or need more assistance.</p>
<p>--<br>
Maddy, Infinite Kind Support</p></div>Maddytag:infinitekind.tenderapp.com,2009-01-14:Comment/491519512021-04-21T03:15:01Z2021-04-25T01:53:57ZImport From Banktivity Multiple Currency Accounts<div><p>I do not understand your answer as it doesn’t seem to relate at all to my question.</p>
<p>There is a phantom account with no name that is generated. It contains a number of records from actual accounts that have names.<br>
<img src="https://entp-tender-production.s3.amazonaws.com/assets/17fb7fb2ad2e4cf4c3337528b7edd4e7222ac211/Screen_Shot_2021-04-21_at_13.03.59.png?AWSAccessKeyId=AKIAISVUXXOK32ATONEQ&Expires=1934891303&Signature=iNXsPAYRO5AKQ254D0CByM%2F1Crg%3D" alt="Phantom Accounts"></p>
<p>When I investigate these with the Show Transaction Details window those transactions have the same identifiers as the “duplicated” transaction in the correctly named account.</p>
<p>This is an excerpt from the first pass with file import0.qif - this contains all of the AUD transactions.</p>
<p><img src="https://entp-tender-production.s3.amazonaws.com/assets/c5d1a781cf5fa592feb4da271deef86836638931/Screen_Shot_2021-04-21_at_13.05.25.png?AWSAccessKeyId=AKIAISVUXXOK32ATONEQ&Expires=1934891306&Signature=vDSGXSABpZPoyceemvuSygjFOWE%3D" alt="AUD Accounts Import"></p>
<p>It has identified transactions within my AUD accounts that relate to my transfer accounts (in other currencies) and has created the account to manage those. I have renamed them to the correct currencies.</p>
<p>This is the second pass with import1.qif - this contains all of the GBP transactions</p>
<p><img src="https://entp-tender-production.s3.amazonaws.com/assets/f3e66aa778cebca8462b3971969ce3698b68a19d/Screen_Shot_2021-04-21_at_13.10.00.png?AWSAccessKeyId=AKIAISVUXXOK32ATONEQ&Expires=1934891301&Signature=740fhsz6z6uNoMRiX0eV0RhohL0%3D" alt="GBP Accounts Import"></p>
<p>This is ignoring the previously created transfer account and is creating a second account (I have left it with the default AUD currency for the purposes of clarity in my description, but even when it is set to the correct currencies it generates two identically named accounts).</p></div>Confused Banker