Issues After Importing Banktivity or Moneydance Data into Quicken for Mac
This topic explains some actions you may need to take after you follow the steps in this article to import data from Banktivity or Moneydance into Quicken for Mac.
Banktivity (formerly iBank) import issues
- Review your stock split transactions. Banktivity exports these transactions without flagging them as positive splits (for example, 2 for 1) or reverse splits (for example, 1 for 2). As such, if your data contains reverse stock splits, you need to manually update them after import. For easy identification, Quicken flags stock splits with a blue icon in the status column. The import log file will also indicate the names of investing accounts that contain Stock Split transactions (See Help > Show Logs in Finder to view your import log file).
- Interest income transactions without a security are not exported into the .QIF file. To resolve this issue, we recommend that you associate your interest income with a security in Banktivity, prior to exporting the data into the .QIF file. Or, in Banktivity, you can change these transactions to deposits and categorize the transaction as interest income. (Alternatively, you can manually enter these transactions in Quicken after import.)
- Some bond transactions may not be imported accurately. If you notice that there is a discrepancy in your balances or holdings even after resolving the above two issues, check your bond transactions for accuracy.
- Price history data is not exported. For this, you need to manually import this data into Quicken through a CSV file.
- Securities without a ticker symbol are shown with a zero value in your portfolio. You need to manually add a ticker and import the price history for these securities.
- Balances reported in the Log file. Banktivity exports the expected "Ending Balance" for each account in the .QIF file. After import Quicken will indicate if the ending balance in Quicken does not match reported Ending Balance in the import Log file (See Help > Show Logs in Finder to view your import log file). Discrepancies in Ending Balance could be caused by missing transactions if you choose to export a range that excludes transactions you have entered in Banktivity. For example, future-dated transactions or very old transactions.
Moneydance import issues
- Opening balance transactions are sometimes not exported from Moneydance into the .QIF file, leading to incorrect account balances. You need to manually enter the opening balance transactions in Quicken after the data is imported.
- If the opening balance is exported in the .QIF file, it shows incorrect date as 12/31/1969.
- ShortSell and CoverShort are exported as Short-Term Capital Gain and Long-Term Capital Gain respectively. This results in incorrect share and cash balances. You need to manually change the transaction type (and enter the shares if they are not displayed) after they are imported in Quicken. For easy identification, Quicken flags these transactions with a blue icon.
- Stock splits are not exported into the .QIF file. You need to manually enter all the stock splits after import in Quicken Mac.
- Asset and Liability accounts are exported as 'Bank'. Quicken will import all "Bank" accounts as "Checking". For Liability accounts imported in this way, you can go to Account Settings and change the Account Type to Liability. For the Asset accounts, create a new Asset Account in Quicken for Mac and then select all the transactions from the imported account ("Command + a" in register) and then drag-and-drop the transactions to the newly created Asset Account.