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.
2. Once logged in, click on Accounts in the top bar and then on History.
3. On the left-hand side of the History page, there is a blue dropdown where you can select the account that you will be interacting with. If you have multiple accounts, click the dropdown to select the one whose historical transactions you want to view and export.
4. On the History page, select the Date Range for the transactions you want to export.
4.1. If you are importing this Schwab account for the first time, choose the "All" option.
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.
4.3. If you trade options, be sure to check the Include Options box. Do not enter any symbols in the Symbol field as we want to export every transaction that occurred in your portfolio.
5. Click on the Export link near the top-right side of the page.
6. A confirmation window about Export Transactions Data will appear. Please read the information on this page (at least the first time you export), then click on the OK button to download the file.
7. The CSV file will be downloaded to your computer. Some browser may ask if you want to open or save the file. In this case, save the file.
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.
6. In the Import Options section, click on the Select Portfolio for Import dropdown and choose your Schwab portfolio from the list. If you are importing into a new StockMarketEye portfolio, click on the New Portfolio... button to create a new portfolio.
7. Leave the 2 options for creating entries and updating the cash set to ON.
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.
9. When the import is complete, click the Done button to view your portfolio.
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.