Import from RBC Wealth Management

NOTE: If you have already downloaded your RBC Wealth Management files and initialized positions, go to Step 3.


STEP 1: DOWNLOAD FILES FROM RBC

For assistance on how to download files from RBC, refer to the Exporting Data from RBC Wealth Management topic.

You should receive .EXE files from RBC. Please do not extract the files manually. The Morningstar Office program will do the extracting.


RBC Wealth Management File Types:

DataWorks File Types

RBC Downloaded File Name

Morningstr Extracted File Name

File Type

Portfolio Management (Transaction) (EXE)

PMmmddyy.exe

RBCmmddA.NAM

Account

Position (EXE)

POmmddyy.exe

RBCmmddA.POS

Position

Portfolio Management (Transaction) (EXE)

PMmmddyy.exe

RBCmmddA.PRI

Price

Portfolio Management (Transaction) (EXE)

PMmmddyy.exe

RBCmmddA.SEC

Security

Trade (EXE)

TFmmddyy.exe
PMmmddyy.exe

RBCmmddA.TRN

Transaction


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 a separate window.

  2. If the RBC Wealth Management 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 RBC Wealth Management. From the top menu click the Action dropdown menu and then select Initialize Positions. The RBC Wealth Management Initialize dialog box opens.

  4. In the Source Directory field, click the magnifying glass icon to locate and select the folder on your computer where you have saved all the exported files.

  5. In the Target Directory field, click the magnifying glass icon to locate and choose your target directory.

  6. Click Extract Downloaded Files.

  7. Enter the date you want to use for the Initialize date or click Earliest Date.

  8. Click Initialize. The Import blotters open.

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

  10. 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 RBC Wealth Management.

STEP 3: IMPORT

Here are the steps for the regular RBC Wealth Management import.

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

  2. In the Interface Name column, double-click RBC Wealth Management or put a checkmark next to RBC Wealth Management and click Import at the top of the screen.

  3. In the Source Directory field, 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 Target Directory field, click the magnifying glass icon to locate and choose your target directory.

  5. Click Extract Downloaded Files.

  6. In the Start Date field, 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.

  7. In the End Date field, 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.

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

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

  10. When the Import Blotter opens, examine the account, transactions, and securities pages to make sure that your data is correct. If you encounter any warnings, you can find additional information on them by holding down the CTRL key and double-clicking the warning icon. You can also refer to the Handling Warnings in the Import Blotter topic or contact Morningstar Office Support at 866 215-2503 for assistance.

  11. Click on Reconcile. Handle any unreconciled items. Review the Troubleshooting Guide for common import and reconciliation issues.

  12. Click Post.

See Also

Handling Warnings in the Import Blotter

Troubleshooting Guide for Common Import and Reconciliation Issues