Getting Schwab Data Files

Getting Schwab Data Files

BillFin only has Schwab data from the date that Schwab processed your Third Party Letters requesting they share your data with BillFin.  Since Schwab does not send historical account data, if account data such as valuations and transactions are needed for preceding dates, follow the instructions below to provide the needed data to us and we can process it so it will be available in BillFin.  Your Schwab representative can possibly help you get these files another way.  Feel free to reach out to them if you are not familiar with the Schwab Data Delivery application.

Open Schwab Data Delivery

Select [Download specific files]

Follow prompts to download the file types below for the dates you need

- Clients and Accounts = .ACC found in “Account Information File” types

- Positions = .RPS found in “Reconciliation Files” types

- Transactions = .TRN found in “Transaction Files” (4 types of TRN files > choose file names with CRS in following naming convention [“acct# .CRS date .TRN])

- Securities = .SEC found in “Security Information File” type

It's very important each master account's files stay together. DO NOT combine daily files for different master accounts.  It's probably best to create a folder for each master account and downloaded the files into the correct folders.