Importing Transactions from DST FAN Mail

This dialog is available from the File / Import / Transactions / DST FAN Mail... menu command.

Transaction and distribution data can be imported from DST FAN Mail (www.dstfanmail.com). Once you have downloaded and unzipped your DST FAN Mail file(s) use this dialog to import them.

Video Tutorial: See the Tutorial on Importing Position/Transaction Files.

Getting Started Tip:

When first getting started, you may want to import positions as of a certain date, and then import transactions from that date forward. If you have all the transaction data available back to inception, you can skip importing positions, and just import all the transaction data.

File(s) to Import	Select which file(s) to import. You can either import a single file, or all the files in a single folder.
Accounts to Import from File(s)	Choose whether to import all accounts in the selected files, or only a particular account. Use the "Scan File(s)" button to fill in the list of available accounts in the importing file(s).
Date Range to Import	Choose the date range to import transactions.
Import into Fund Manager Portfolio	Specifies the portfolio where transactions will be imported into. Choose one of the two available options: Specified: If you select the "Or Sub-Portfolio With Matching Investment Account # And CUSIP" option, Fund Manager will search the specified portfolio and all its sub-portfolios for an investment that has a matching investment account number and CUSIP to the account number and CUSIP from the importing file. This search is done on a per-transaction basis. If such an investment is found, this investment will be updated with the matching transaction. If no match is found a new investment can be created based on the "Create New Investment(s) As Needed" option. If you do not select the "Or Sub-Portfolio With Matching Investment Account # And CUSIP" option, Fund Manager will only search within the specified portfolio (not including nested sub-portfolios) for an investment with a matching CUSIP. The account number is ignored in this case. With Matching Account Number as Import File Account: Fund Manager will search all sub-portfolios for an account number property that matches the account number in the importing file. If a matching sub-portfolio is found, this sub-portfolio (not including nested sub-portfolios) will be searched for an investment with a matching CUSIP. If no sub-portfolio is found with a matching account number and the "Create New Sub-Portfolios as Needed" option is turned on, a new sub-portfolio will be created with this account number property.
Import Options	Specify whether to skip transactions that are already recorded. Also specify if new investments should be created when a matching investment could not be found. Fund Manager matches investments based on the CUSIP investment property, and the CUSIP in the importing file. The account number is also used for matching, based on the "Import into Fund Manager Portfolio" settings above.

Press the "Next" button after filling in all of the above fields. The importing file(s) will be read in, and you will be taken to the Preview Importing Transactions page to see what transactions will be imported.

Notes:

When you have a new account, or investments in an account, Fund Manager can/will create these for you automatically when it finds them in your importing file(s).

When you set up your sub-portfolios you'll want to assign the account numbers to the properties of each sub-portfolio. Fund Manager matches up the account number in the importing file(s) with the account numbers of a sub-portfolio. When it finds a match, it then matches up a transaction based on the CUSIP in the importing file and the recorded CUSIP of investments in the sub-portfolio which matched up the account number.

If no sub-portfolio with a matching account number could be found, Fund Manager will create a new sub-portfolio. On the import dialog you specify under what existing sub-portfolio this new sub-portfolio should be created. See the options: "Import Into Fund Manager Portfolio: With Matching Account Number As Import File Account" and "Create New Sub-Portfolios as Needed Under:".

If no investment with a matching CUSIP is found in the previously matched sub-portfolio, then Fund Manager will create a new investment file. Make sure the "Create New Investments As Needed" option is turned on when you do the import. Also, check the "Options..." button next to it to assign a folder for the newly created investments.

Once a matching investment is found, the transaction in the importing file will be imported into that investment.

See Also