Importing Positions from Schwab

This dialog is available from the File / Import / Positions / Schwab... menu command.

Position data can be imported from Schwab Data Delivery files into Fund Manager. Ask Schwab to set up your account for their "B/D Core Data Files". These files will be downloaded with filenames in the format of CRSccyymmdd.RPS. Fund Manager also supports importing from Schwab's legacy "Generic" or "Advent" formatted position files (CSmmddyy.BLD and CSmmddyy.UPD). During the position import Fund Manager will look for a corresponding *.SEC or *.PRI file with the same base filename as the *.RPS/BLD/UPD file. The *.SEC and *.PRI files contains closing price data. If found, these prices will also be imported.

Video Tutorial: See the Tutorial on Importing Position/Transaction Files.

File to Import

Select which file to import.

Accounts to Import

Choose whether to import all accounts in the selected file, or only a particular account. Use the "Scan File" button to fill in the list of available accounts in the importing file.

Import Options

Choose options for creating the new investments.

Choose whether to import all positions into a new sub-portfolio:

When this option is on, type the name of the new sub-portfolio where all the positions will be placed. No existing sub-portfolios will be modified in this case. When importing positions for reconciliation purposes, you should import into a new sub-portfolio.
When this option is off, Fund Manager will look through your existing sub-portfolios to try and find a match based on account number. If no matching account number is found, the new sub-portfolio will be created at the top level of the portfolio hierarchy. If a matching sub-portfolio is found, the positions will be updated in there. When the sub-portfolio is already existing, Fund Manager will look for matching investments in that sub-portfolio based on symbol. If an existing investment match could not be found, a new investment will be created.

Press the "Next" button after filling in all of the above fields. The importing file will be read in, and you will be taken to the Preview Importing Positions page to see what transactions will be imported.

Important Note on Cost Basis:

When importing positions there is no cost basis data available. Therefore, all positions will be created with a cost basis of zero. To adjust the cost basis, use the Data Register and edit the initial purchase price and value.

Note on CASH## Positions:

SchwabLink or Schwab Data Delivery position files include many cash balances that do not reflect real holdings, such as CASH04, which reports the amount of margin available. Fund Manager combines the statement balances for CASH01, CASH03, and CASH07 (cash account, margin balance, and money market funds) into a common CASH investment. It is recommended to use a single default cash account when importing from Schwab, and leave ON the option to "Combine All Cash Transactions Into Default Cash Account" when importing transactions.

See Also