Import from Pershing

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

STEP 1: DOWNLOAD FILES FROM PERSHING

Download files from Pershing to import. If you do not know how to download these files, please see the Exporting Data from Pershing InfoDirect topic.

Pershing File Types

File Type

Description

POTL

Cost basis file

*ACCF

Customer complete name and address file

*CUST or GCUS

Customer position file

ISCA

Pershing security detail file

ACCT

Name and address changes file

*FUND

Money Market position file

*ACTV

Money Market activity file

*GMON

Cash Balance File

*GACT or BACT

Bookkeeping activity file

*Required Files

 

Save all the files you download/export from Pershing to the same folder on your computer. The further back you can go and export data from Pershing the better as this will bring in more of your clients’ transaction history. To ensure you capture all transactions taking place, export every day’s available files from Pershing to your folder.

 

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.

  1. Open Morningstar Office. On the top menu bar, click Import. The Import area opens in separate window.

  2. If the Pershing 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.

  3. In the Interface Name column, check the box to the left of Pershing. On the Action Shortcuts tool bar, click Initialize Positions. The Pershing Initialize dialog box opens.

  4. 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.

  5. Select the date you want to use as your initial date.

    Note: The Initialize Date needs to be a Friday's date due to the fact that Pershing only creates full position files on Fridays.

  6. Click Initialize. The Import blotters open.

  7. 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.

  8. 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 Pershing imports.

STEP 3: IMPORT

Here are the steps for the regular Pershing import.

  1. Open Morningstar Office. On the top menu bar, click Import. The Import area opens in separate window.

  2. In the Interface Name column, double-click Pershing or put a checkmark next to Pershing and click Import at the top of the screen. The Pershing dialog box opens.

  3. 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.

  4. 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.

  5. In the End Date box, enter the date that matches the date range you want to import.

    Note: If you are importing more than a week's worth of data, we recommend setting the end date to a Friday's date so that you will have a position file to reconcile with.

  6. Once you enter the End Date, the import dialog will display which files are available for import within the specified date range.

  7. Click Import. This action will launch the Import Blotter.

  8. Click on Reconcile.

    Note: You should only reconcile if your end date was set to a Friday so that you can use a full position file. If not, you will only have partial position files and reconciliation will produce false warnings and errors. If you do not have the full position file during the import, skip the reconcile step. Review the Troubleshooting Guide for common import and reconciliation issues.

  9. Click Post.

See Also

 Exporting Data from Pershing InfoDirect

Handling Warnings in the Import Blotter

Troubleshooting Guide for Common Import and Reconciliation Issues