If you are in a situation where you have been using MoneyWiz before version 2.6 but you used tricks and hacks to insert the information regarding your investments, please read this guide on so you can properly take advantage of the new Investment account feature with minimum hassle.
Offline account guide
Assuming that you already have an existing account (for example Savings) where you track your transfers coming from and going to your other accounts, the first thing you need to do is to find out what is the opening balance of this account. Please open the account for edit (see Manage Accounts and Groups tutorial for more information) to find this number.
Create a brand new Investment account (see Investment accounts tutorial for more information). For cash balance enter the same number as the opening balance of your original account. For as of date, select any date that is before the oldest transaction that will later appear in this account. Do not add any positions for now.
Next important task is to move your transfers. Use the filter to show only transfer transactions in MoneyWiz (for information on how to access transaction filters see Working with transactions tutorial). You can edit each transfer and change the account to be your new investment account. If you are using the Mac app you can also drag the transactions from your original account to the new account. In case you have a long history of transactions, you have no access to a Mac and you do not feel like moving the transactions one by one, please contact our helpful support team – we will do the job for you.
Now you need to insert your assets. This may be a very time consuming task, especially if you have a very diverse portfolio, but unfortunately there is no way to easily automate it. Make sure you enter diligently all your buys and sells with correct amount, commission, symbol and date.
If you ever received dividends, you can also enter them. If they were previously entered in your original account, you can also bulk edit (available on Windows and Mac, see Working with transactions guide) or drag and drop (available on Mac). You can use the filter to show only income transactions this time, but be careful with that, because you may have used incomes as a workaround of other features. You can also change the account of these incomes one by one, because this way you can also attribute any income to a specific open position.
Once your account is set, your portfolio is complete, your balance is a match, etc, you can delete your original account. To properly maintain your new investment account you will need to diligently input all new transactions/trades as soon as they appear. MoneyWiz will automatically update the value of your assets based information available on Yahoo! finance website.
Online banking account guide
The best way to approach migrating your existing investments data to the new Investment account feature if you are planning to use the online banking feature to automatically download all new trades, would be to just start creating a new online banking account (see Online Accounts tutorial for more information) and select your investment banking institution. MoneyWiz supports over 3700 institutions in over 40 countries.
Once your new online banking account is created, it will download your current positions (holdings or portfolios) and you will be able to see them in the portfolio tab. It will also automatically download your trades for up to 90 days in the past.
If you already have an existing account (for example Savings) that you used before version 2.6 to track your investment assets and transfers to and from your investments account (as a workaround), you will need to do some steps to reconcile the differences between your original account and your new online banking account.
The first step would be to move your transfer transactions. Use the filter to show only transfer transactions in your original account. You can edit each transfer and change the account to be your new investment account. If you are using the Mac app you can also drag the transactions from your original account to the new account. In case you have a long history of transactions, you have no access to a Mac and you do not feel like moving the transactions one by one, please contact our helpful support team – we will do the job for you.
Some of these transfers may have already been imported through the Online Banking feature, so you will need to remove the duplicates – note you will have to keep the transfer and not the income or expense transaction that was downloaded automatically.
If you have moved transfers that are older than 90 days, even after you removed the duplicates, your cash balance will not be a match. Please, open you new investment account for edit (see Manage Accounts and Groups tutorial for more information) and change the opening cash balance and as of date. Contact our helpful support team if you need any help with these manual calculations.
If you want to have all of your history including trades from before those 90 days limit of the online banking, that would be trickiest of all. Simply inserting past trades will affect your portfolio and the number of shares will be changed to a wrong number. For that reason, before inputing any trade, you should first delete the holding and all of its trades (for more information on how to manage your Investment account see the Investment accounts guide). However, you should note that once you do that you will then have to recreate all of the trades related to this holding. At some point, especially if you have a very diverse portfolio, this process may become confusing.
There is an alternative which requires more manual work, but it is more straightforward and less confusing. Create a new investment account, which is not connected to online banking. Then manually create all trades and transactions starting from a date of your choosing till today. Transfers should be moved from your original account to your new account (see above). When everything is created, the balances and portfolios are correct, open the account for edit and connect it to online banking (see Online Accounts guide for more information). This way, the app will download only future trades and will not mess with your past history. At this point you can delete your original savings account.