Charles Schwab Digital Services
11
Conversion Guide: TD Ameritrade to Schwab
Schwab B/D Core Data Files
Account/Master
cross-reference files (.MXR)
Security Ticker
cross-reference file
File descriptions Daily set of files that contain all account
and security related information and daily
activity
Mapping file(s) that link your current TDAI
account numbers and rep codes to the new
Schwab sub-account numbers and master
accounts
Mapping file that links the current TDAI
security identifiers (CUSIPS are not
changing) to the equivalent Schwab
security identifiers, where differences
exist. For options and a small number of
mutual funds only.
What is required in order to
get the file(s)?
By signing the Schwab Master Data
Access Agreement, your feeds on the TDAI
side will automatically migrate over to
Schwab
Files will be included along with your Core B/D
File feed upon signing the Schwab Master Data
Access Agreement
Use your Schwab Advisor Center
credentials to login and access the file
Where will I get the file(s)
from?
Included in your Schwab daily file feed,
which will be either the Schwab Data
Delivery tool, or via SFTP protocol
Included in your Schwab daily file feed, which
will be either the Schwab Data Delivery tool, or
via SFTP protocol
File and corresponding specs are located
on the Technical Support page within
Schwab Advisor Center, here
When can I expect to get the
file(s)?
Delivered daily, starting:
• Mid-July – First iteration will include
new FA master accounts and individual
subaccounts (no assets) that will be
converted from the TDAI platform
• One week later – BT/SL master
accounts and individual subaccounts
added (for money managers and
TAMPs)
• Sept 6, 2023 and after – Full iteration
of files which include asset holdings
To be updated in waves, and delivered daily:
• Initial version available mid-July for FA
master accounts
• BT/SL master accounts added one
week later (for money managers and
TAMPs)
• First refresh in early August
• Final refresh in late August just before
conversion
• Dates subject to change
Available now, but the refreshed, final
version will be available starting August
25.
At what entity level are the
files created?
Created at the master account level
(similar to the TDAI rep code level), but
bundled together for your download
package.
• Note: Retail accounts are not available
or included in the Schwab Core B/D
file feeds
Created at the master account level (similar to
the TDAI rep code level), meaning you can
expect to get one of these .MXR files for every
Schwab master account that includes
converted TDAI accounts
Created at the custodian level, meaning
there is only one version of the file for all
use cases
Working with Schwab cross-reference files