Morningstar Office has two Fidelity Interfaces. Fidelity Advisor Channel is the old interface and Fidelity Wealth Central/Fidelity Streetscape Hybrid is the new interface. Both interfaces read the same Fidelity format of files (Standard Format B), however, the Fidelity Advisor Channel interface is no longer updated and could lead to false reconciliation errors if used. If you are currently using the Fidelity Advisor Channel interface and would like to switch to the Fidelity Wealth Central/Fidelity Streetscape Hybrid interface, refer to the client/account mapping topic.
If you have already downloaded your Fidelity files and initialized positions, go to Step 3.
STEP 1: DOWNLOAD FILES FROM FIDELITY
If you do not know how to download these files, refer to the Exporting Data from Fidelity Wealth Central topic.
Morningstar recommends having an automatic download of Standard Format B files set up with Fidelity rather than manually downloading files. This is due to transactions missing from the manual downloads if the entry date is later than the trade date. Contact Fidelity at 800 523-5518 with assistance in getting the automatic download set up.
Fidelity file types:
|
File Types |
Description |
|
fimmddyy.ACC * |
Account File |
|
fimmddyy.BAL * |
Balance File |
|
fimmddyy.POS * |
Holding Position File |
|
fimmddyy.NAM * |
Name/Address File |
|
fimmddyy.PRI |
Price File |
|
fimmddyy.SEC * |
Security File |
|
fimmddyy.TRN |
Transaction File |
|
fimmddyy.UGL |
Open Tax Lot File |
|
* Files Required for Initialization |
|
STEP 2: INITIALIZE POSITIONS
Since you cannot export your client's entire transaction history, which could span several years, you need a starting point. When you initialize, we look at the earliest available position file, find out the balances for all holdings, and create a Deliver-in transaction for that balance on the date of the position file.
There are two ways to initialize the data in Fidelity, depending on whether you chose to manually download the data or use the automatic download.
With the first option, you must manually download the necessary files encompassing the covered 120 day time period.
This requires downloading historical Account, Name, Security, and Transaction files, and then also doing a separate download for historical prices. Historical balances are not available.
This process can be time consuming for downloading files.
The second option uses the automatic download method to capture the entire 120 day's worth of transaction data in the first file. This is the Morningstar preferred method as it leaves the least room for error.
This requires (a) retrieving a file via the automatic download and (b) obtaining historical prices for the 120 day period.
This process will assume that the first 120 day period is correct as is. Any discrepancies in that period would be forced into balance.
Method 1 - Initializing Using Manually Downloaded Files
Note: No matter what date range you select in your Fidelity export, the .bal, .pos, and .pri files will be as of the most recent business day, which is why you will also need to do the historical export of prices. Instructions for completing the historical download are below.
Follow the export instructions in the Exporting Data from Fidelity Wealth Central guide to manually download the necessary files.
Export 120 days’ worth of data.
Set the date range as far back as Fidelity will allow (120 days) to current.
At the top of the Fidelity Wealth Central page, click on the Imports & Exports menu.
Select Export, Historical Prices & Positions.
Enter the date at the top. Choose Standard Format B as the export type. Select Prices Only at the bottom. Click Submit. The first date that should be selected is the date that matches the oldest date you were able to export for transactions.
Repeat for all price dates needed. The dates needed are either every business day (preferred), or each month end date. Note: If you use imported prices within Morningstar, and do not get daily prices from this export, it can alter return numbers depending on how much the price fluctuated during the time gap.
From the Wealth Central page, select Imports & Exports, Import/Export Status. The Import/Export Status window opens.
Under the Action column, click the Download File link for each price file that was created. You now have all the files needed for the initialization.
Open Morningstar Office. On the top menu bar, click Import. The Import area opens in a separate window.
If the Fidelity Wealth Central/Fidelity Streetscape Hybrid 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, double-click Fidelity Wealth Central/Fidelity Streetscape Hybrid or put a checkmark next to Fidelity Wealth Central/Fidelity Streetscape Hybrid and click Import at the top of the screen. The Fidelity Wealth Central/Fidelity Streetscape Hybrid 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.
In the Start Date box, enter the date for the earliest date within your 120 day period. Note: It’s better to use a date that is not month-end if you are doing manual downloads. This is because month-end files are sometimes missing information such as dividends.
In the End Date box, enter the last day of your 120-day period.
Click the Import button at the bottom of the screen.
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 CTRL 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.
Select all positions. Click Action, Generate Initial Transactions.
Select the date of the oldest price file.
Click on Transactions from the left hand panel. Select any that have a Price Missing warning.
Click Price Lookup at the top of the page.
Select all. Click OK.
Click Post.
From this point forward, follow the normal import procedures.
Method 2 - Initializing Using Automatic Download
With the automatic download, the first transaction file that is created holds 120 days’ worth of transactions. However, the .bal, .pos, and .pri files will be as of the most current day, which is why you will also need to do the historical export of prices. Instructions for completing the historical download are below.
At the top of the Fidelity Wealth Central page, click on the Imports & Exports menu.
Select Export, Historical Prices & Positions.
Enter the date at the top. Choose Standard Format B as the export type. Select Prices only at the bottom. Click Submit. The first date that should be selected is the date that is 120 days before the date of your first automatic download file.
Repeat for all price dates needed. The dates needed are either every business day (preferred), or each month end date. Note: If you use imported prices within Morningstar, and do not get daily prices from this export, it can alter return numbers depending on how much the price fluctuated during the time gap.
From the Wealth Central page, select Imports & Exports, Import/Export Status. The Import/Export Status window opens.
Under the Action column, click the Download File link for each price file that was created. You now have all files needed for the initialization.
Open Morningstar Office. On the top menu bar, click Import. The Import area opens in a separate window.
If the Fidelity Wealth Central/Fidelity Streetscape Hybrid 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, double-click Fidelity Wealth Central/Fidelity Streetscape Hybrid or put a checkmark next to Fidelity Wealth Central/Fidelity Streetscape Hybrid and click Import at the top of the screen. The Fidelity Wealth Central/Fidelity Streetscape Hybrid dialog box opens.
In the File Name box, click on the magnifying glass icon to locate and select the folder on your computer where you have saved all the exported files.
In the Start Date box, enter the date for the earliest day of price files.
In the End Date box, enter the date of the first automatic download file.
Click the Import button at the bottom of the screen.
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 CTRL 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 for assistance.
Select all positions. Click Action, Generate Initial Transactions.
Select the date of the oldest price file.
Click on Transactions from the left-hand panel. Select any that have a Price Missing warning.
Click Price Lookup at the top of the page.
Select all. Click OK.
Click Post.
From this point forward, follow the normal import procedures.
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 Fidelity Wealth Central/Fidelity Streetscape Hybrid or put a checkmark next to Fidelity Wealth Central/Fidelity Streetscape Hybrid and click Import at the top of the screen. The Fidelity Wealth Central/Fidelity Streetscape Hybrid dialog box opens.
In the File Name box, click on the magnifying glass icon to locate and select the folder on your computer where you have saved all exported files.
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 CTRL 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 for assistance.
Click on Reconcile.
Handle any unreconciled items. Review the Troubleshooting Guide for common import and reconciliation issues.
Note: For CASH or Money Market out of balances, you'll want to show core brokerage transactions on Fidelity to research these issues. To do so, click on the small gear in the upper-right of the Fidelity transaction screen. In the box that pops up, there is a check box at the bottom to Exclude Core Brokerage Transactions. This can be unchecked.
Click Post.
Exporting Data from Fidelity Wealth Central
Handling Warnings in the Import Blotter
Troubleshooting Guide for Common Import and Reconciliation Issues
See Also