Import from TD Ameritrade Institutional

If you have already downloaded your TD Ameritrade Institutional files and initialized positions, go to Step 3.

STEP 1: DOWNLOAD FILES FROM TD AMERITRADE INSTITUTIONAL

If you do not know how to download these files, refer to the Exporting Data from TD Ameritrade topic.

TDA file types:

File Type	Description
POS	Position file
PRI	Price file
TRD or TRF	Client name and address file
SEC	Security information file
TRN	Transactions file
CBL	Open Tax Lot file

Make sure you have all of the above file types. If you are missing one or more file types, the import will not be complete. If you do not have a full TRD or TRF file, contact TD Ameritrade Institutional.

STEP 2: INITIALIZE POSITIONS

Since you cannot export your client’s entire transaction history which can span several years, you need a starting point. When you initialize, we look at the earliest available position file, find out the balances in all the holdings and enter a Deliver-in transaction of that balance on the date of the position file.

Open Morningstar Office. On the top menu bar, click Import. The Import area opens in separate window.
If the TD Ameritrade institutional interface does not appear as an active import source, refer to the Edit Import Interfaces topic for instructions on adding the interface to the selection area.
In the Interface Name column, check the box to the left of TD Ameritrade Institutional. On the Action Shortcuts tool bar, click Initialize Positions. The TD Ameritrade Institutional Initialize dialog box opens.
In the File Name box, click the magnifying glass icon to locate and select the folder on your computer where you have saved all the exported files.
Check the box to Include Subfolders if you have multiple rep code folders.
Select the dat you want to use as your Initialize Date or click Get earliest date.
Click Initialize. The Import blotters open.
When the Import Blotter opens, examine the accounts, transactions, and securities pages to make sure that your data is correct. If you encounter any items in warning status, hold down the CRTL key on your keyboard and double-click the warning icon for more information on that warning. You can also refer to the Handling Warnings in the Import Blotter topic or call Morningstar Office Support at 1-866-215-2503.
Click Post. The information posts and clients and transactions are created. You have now initialized your positions and you will not have to repeat this step with TD Ameritrade Institutional imports.

STEP 3: IMPORT

Here are the steps for the regular TD Ameritrade Institutional import.

Open Morningstar Office. On the top menu bar, click Import. The Import area opens in a separate window.
In the Interface Name column, double-click TD Ameritrade Institutional or put a checkmark next to TD Ameritrade Institutional and click Import at the top of the screen. The TD Ameritrade Institutional dialog box opens.
In the File Name box, click the magnifying glass icon to locate and select the folder on your computer where you have saved all the exported files.
Check the box to Include Subfolders if you have multiple rep code folders.
In the Start Date box, enter the date after the last custodian file posted date (this date should appear as the default option). For example, if you initialized on 3/31/2016, enter 4/1/2016.
In the End Date box, enter the date that matches the date range you want to import. For example, if you want to bring in a week’s worth of data at a time, enter a date a week after the start date.

Note: If you import daily or if you want to import all of your available files, the end date does not need to be changed.
Once you enter the End Date, the import dialog will display which files are available for import within the specified date range.
Click Import. This action will launch the Import Blotter.
When the Import Blotter opens, examine the accounts, transactions, and securities pages to make sure that your data is correct. If you encounter any items in warning status, hold down the CRTL key on your keyboard and double-click the warning icon for more information on that warning. You can also refer to the Handling Warnings in the Import Blotter topic or call Morningstar Office Support at 1-866-215-2503.
Click on Reconcile. Handle any unreconciled items. Review the Troubleshooting Guide for common import and reconciliation issues.
Click Post.