Importing Charles Schwab Transactions from a CSV File
StockMarketEye has special support for importing historical transactions from CSV files downloaded from your Charles Schwab brokerage account.
CSV (Comma Separated Values) files are spreadsheet files that can be opened by most spreadsheet applications such as Microsoft Excel, LibreOffice or Numbers. Note that you do not need to have a spreadsheet application to import the Schwab CSV file into StockMarketEye.
This document first explains how to download the historical transaction CSV files from Charles Schwab, then goes on to show you how to import that file into StockMarketEye. At the end of this document, you'll find a list of best practices for this process.
This feature is available in StockMarketEye v5.3.3 and later.
Downloading Historical Transactions in CSV Format from Charles Schwab Brokerage
1. Log in to your Charles Schwab account on their website.
4. On the History page, select the Date Range for the transactions you want to export.
4.2. If you have already imported this account into a StockMarketEye portfolio, select the "Custom" range and choose a From date that is one day after the last time you exported your transactions. The goal is to view just the transactions which are not already in your StockMarketEye portfolio.
5. Click on the Export link near the top-right side of the page.
8. Locate the downloaded file on your computer. It will be in the folder where your downloads are usually saved - typically the Downloads folder.
Import the Schwab Transactions CSV File into StockMarketEye
1. In StockMarketEye, click on the menu: Portfolios -> Import from CSV...
2. On the "Import Investment Transactions in CSV Format" screen, click on the Browse button and select the CSV file you downloaded from Schwab.
3. On the same screen, click on the CSV Columns Format dropdown and select "Charles Schwab - History - Transactions" from the list.
4. Click on the Load File button to start the import.
5. When the file has been loaded, you'll see the Import Information section with a summary of the transactions found in the CSV file.
8. Click the Import button to perform the import into the selected portfolio. If you have a lot of transactions, be patient as it may take a few seconds to import.
Best Practices and Tips
- If you are importing a Schwab account into a new StockMarketEye portfolio, use the "All" date range option during the export. You want to import as many transactions as are available.
- If you are importing recent transactions from your Schwab account into an existing StockMarketEye portfolio, use the "Custom" range to select only the transactions that are not currently in the Transactions report of the existing StockMarketEye portfolio.
- The import does not check to see if the imported transactions are already in your StockMarketEye portfolio. Thus, you should ensure that the Date Range you select on the Schwab History page does not overlap with the dates of the most recent transactions in your portfolio's Transactions report. Conversely, you don't want to miss any transactions by selecting a custom range that would not include all of the transactions that your existing StockMarketEye portfolio is missing.
- You can manually edit the imported transactions after they have been imported into your StockMarketEye portfolio. This includes the possibility of deleting any potential duplicate transactions.
- You can open the CSV file in a spreadsheet program, if you want, but it is generally not necessary. However, in some cases it may be useful to open the file to tweak some of the data the before importing. If you do this, be sure to save the file in CSV format again.
- Schwab categorizes stock split transactions as "Shares In". You may want to consider deleting these "Shares In" transactions that are related to the split and enter an actual Split transaction.
- If the "Ignored Transactions" number in the Import Information section is more than 0, it means that StockMarketEye was not able to automatically recognize some transactions in the CSV file. Please contact our support team and send us your CSV file so we can adjust the import tool to better recognize these ignored transactions.