The User Provided Excel, also known as 'User File', was created to address missing providers or exports of data from another system or internal spreadsheet. Users can now mass create clients and holdings with no manual data entry. Repeat the process and mass update client asset values/holdings at quarter or month end. Detailed instructions/examples are outlined below:
Step #1: Download the User File
Download the User Provided Excel template by navigating to the Application Management area in the Fiduciary Focus Toolkit (navigate here by clicking on the gear icon on the top-right corner of your screen) and then selecting Integration Providers on the left. Click the +Add New Provider button and select User Provided Excel from the dropdown menu. Download the User File and move on to Step #2.
Step #2: Fill out the User File - COMPLETED SAMPLE
1st Tab: Header - Enter the holdings as of date for all of the data in the file along with the Workspace ID from your Fiduciary Focus Toolkit account. You can see the Workspace ID within Application Management in the top right corner of your screen.
2nd Tab: Clients - Enter one row per account or retirement plan that you would like to import. All fields are required. The client accounts added to the file will be available for creation or syncing to an existing account when you choose to do so.
3rd Tab: Holdings - Enter the holding(s) for each of your clients. The ID in the first column should relate back to the ID in the Clients tab of this EXCEL file (RK Number/Client ID).
For the holdings identifiers, not all are required but the more you have the better. The Morningstar SECID is ideal as that can map to any applicable mutual fund/etf/group annuity. If not available, CUSIP is the next best option which would map to any applicable mutual fund/etf/cit. Finally, you could use TICKER but that would only map to mutual fund/etfs.
Do NOT use the dollar sign "$" when entering market value.
Regardless of the identifiers provided, it's best practice to also include the fund name in case we cannot match to the identifier you provided. In those cases, we will create a custom investment using the name you provide.
4th Tab: System Account Types - You will need to input one of the available account types into the Account Type section on the Clients tab.
Please note, if you have already completed a User Provided Excel file for a prior data period, are re-uploading a client with the same RK Number/Client ID, which has already been synced to a client account within the Toolkit interface, the new file will automatically update the holdings to the new ones provided within the file.
Step #3: Email User File
Please email the User Provided Excel to Fi360productops@broadridge.com and allow up to one week for your file to be processed.
If you have any questions, please contact our Client Engagement Team at Fi360support@broadridge.com or toll free, 844-394-9960.