Charles Schwab

Type here for Search

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.

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.

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.

Interface Trouble?

Our troubleshooting tools can help you determine and resolve problems with:

Need additional support?

Our Technical Support Team is available to answer your questions. Call us at 800-528-9595 or send an .