Working with a Custodian Interface
Data can be entered into PortfolioCenter manually, or it can be downloaded from a brokerage firm. In this section, you can learn how to work with various custodian interfaces to download and post data into PortfolioCenter.
- Day-to-Day Interface Operations
- Regardless of the interfaces you use to download files, when the files are on your computer, your day-to-day interface operations are the same. In this section, learn how to covert, post, and reconcile your downloaded files.
-
Daily Interface Checklist [pdf]
Time Saving Techniques for Using the Interface [SOLUTIONS webcast]
-
- 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.
-
Convert and Post Security Files [pdf]
Convert and Post Price Files [pdf]
Convert and Post Portfolio Files [pdf]
Convert and Post Transaction Files [pdf]
Using the Interface Error Report [pdf]
Interface file conversion troubleshooting [interactive tool]
- 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.
-
What Is Reconciliation, and Why Is It Important? [pdf]
Running the Reconcilation Report [pdf]
Understanding the Reconciliation Report [pdf]
Reconciliation Tips and Best Practices [pdf]
- Downloading and Maintaining Interface Files
- Procedures for downloading from various brokerage firms can sometimes be different. Click on the appropriate link below to learn how to download the files you need.
-
- ByAllAccounts Interface Files
-
Downloading ByAllAccounts Files Coming Soon!
- DST FAN Mail Interface Files
- Fidelity Interface Files
- Pershing Interface Files
-
Downloading Pershing Files [pdf]
- Schwab Interface Files
-
Downloading Schwab Files Using SchwabLink [pdf]
- TD AMERITRADE (Former TD Waterhouse accounts) Interface Files
-
Downloading TD AMERITRADE (Former TD Waterhouse accounts) Files [pdf]
TD AMERITRADE (Former TD Waterhouse accounts) File Names [pdf]
Archiving TD AMERITRADE (Former TD Waterhouse accounts) Files [pdf]
- 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.
-
ByAllAccounts Interface Settings [pdf]
DST FAN Mail Interface Settings [pdf]
Fidelity Interface Settings [pdf]
Pershing Interface Settings [pdf]
Schwab Interface Settings [pdf]
TD AMERITRADE (Former TD Waterhouse accounts) Interface Settings [pdf]