Challenge #1: Error During Import / Enable Third-Party Access
If you get an error during BrokerConnect import, you may need to enable Enable Third-Party Access on your Charles Schwab account:
1. Log on to your Charles Schwab trading account website
2. On the homepage, move your mouse over "Service"
3. Click on “Security Center”
4. Scroll to the bottom of the page to the “Third-Party Access to Account Information” box
5. Select “Enable Third-Party Access”
6. Select “Save”
7. Re-try the BrokerConnect import.
Challenge #2: Trades Out of Order
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 another 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 intraday 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.
Challenge #3: CSV File Opens in Web Browser
If the csv file opens in your web browser, or opens in Microsoft Excel, rather than importing, then there is likely a problem with your Windows file associations for csv files. For instructions on how to fix this click here
Please sign in to leave a comment.