User Guide


Charles Schwab

Charles Schwab Import Instructions:
There are two different methods of importing transaction history from Charles Schwabinto TradeLog (for instructions select a method below):
  • BrokerConnect is the reccomended method of importing
    The csv file is limited to 1500 records. Unfortunately, there is no way to know ahead of time if the date range you have requested will exceed this limit.  If the limit is exceeded, the file will contain no records and you will have to shorten the date range and try again.
NOTE: Possible Challenges with Charles Schwab Importing
Occasionally, the Charles Schwab trade history data may be out of order for a specific date. This usually occurs when one has challenged a fill or has had an other manual edit from customer service.  Since the Charles Schwab transaction history does not include time of day for the trades, there is no automated way for any software program to determine the proper order of trades. And since TradeLog matches trades in a first-in first-out methodology, it is inevitable that trades may be mismatched when this happens. This is especially noted for very active intra day traders. In addition, the trade history data usually does not report when a buy is a "buy to cover" a short sale so this can make matching difficult also.
Charles Schwab does use timestamps for the purpose of their reporting cost basis to the IRS on 1099-B. You can view the order of transactions on their UGL and/or RGL tabs on schwab.com and compare that to TradeLog to reconcile any discrepancies.
To fix this, first run the Fix Trades Out of Order function if you receive negative share errors.
If trades are not properly matching the run the Edit, Force Match Trades function.