Working with Direct Interfaces or Data Aggregators

Data can be entered into PortfolioCenter manually, or it can be downloaded from a brokerage firm, custodian, or mutual fund company. In this section, you can learn how to work with various custodial interfaces to download and post data into PortfolioCenter.

Day-to-Day Interface Operations

Regardless of the direct interface or data aggregator you use, the processing of the files on a day-to-day basis is the same. In this section, learn how to convert and post data from the downloaded files, and then learn how to reconcile the data.

Converting and Posting Interface Files

Posting data from the interface files is the quickest and easiest way to get data into your database. Each data provider gives you data in their own format, and then you convert the data into a format that PortfolioCenter can read. From there, you post the data into the PortfolioCenter database and then you can reconcile your data.

Reconcile Your Data

Reconciliation is one of the most important steps in your day-to-day interface operation. The reconciliation process verifies that the data you have just posted into the database is correct and complete. Reconciliation compares cash and share quantities in PortfolioCenter with the quantities on record at the custodian.

Share Reconciliation

Cost Basis Reconciliation

Downloading and Maintaining Interface Files

Each data provider has its own set of file names and download procedures. Click on the appropriate links below to learn more about downloading and managing files from the data providers you use.

Morningstar ByAllAccounts Interface Files

DST FAN Mail Interface Files

Fidelity Interface Files

Pershing Interface Files

Interface Files

TD Ameritrade (Former TD Waterhouse accounts) Interface Files

Interface Settings

The interface settings control many aspects of your interface, including file location and how data is converted. Proper interface settings can affect the function of your interface. Use the documents below for custodian interface settings best practices.