ConvertExcel2TXF - Specific Broker Instructions
Here you'll find instructions for using ConvertExcel2TXF with specific brokers. If you don't see your broker listed, you can get a free copy of the ConvertExcel2TXF program if you provide a sample file along with instructions for generating the file from your broker's website. Just send me an email.
A.G. Edwards (now Wachovia)Ameriprise
Ameritrade
BNY Mellon
BrokersXpress
Edward Jones
eOption
E*Trade
Fidelity
Firstrade
FxPro
Genworth
ING Direct (ShareBuilder)
Interactive Brokers
IZone (by TDAmeritrade)
JMS
JP Morgan
Just2Trade
Merrill Lynch
Morgan Stanley
OptionsFirst (by Scottrade)
OptionsHouse
OptionsXpress
Prudential
Schwab
Scottrade
ShareBuilder (ING Direct)
Smith Barney
SogoTrade/SogoElite
TDAmeritrade
Terra Nova
ThinkOrSwim
TradeKing
TradeStation
UBS
Wachovia
Zecco
Ameriprise
Note: Ameriprise already combines the quantity with the description into a single column, so you'll just leave the quantity column box on the user form blank (see the tutorial).
BNY Mellon
Note: The one file that I've seen from BNY had the "Purchase Price" and "Sell Price" column labels switched. You should verify each column by comparing a few transactions with your account statements or other records and adjust the column labels as necessary.
BrokersXpress
1. Go to "Account" tab.
2. Select "Activity".
3. Select the period you want to download. (in the drop down menu you can select "last year".
4. Verify the "file type" is correct. (you can choose "all trades", "options trades", "futures trades" etc)
5. Click on the box "show commissions & regulatory fees.
6. In the drop down menu for "download this activity to" select "Excel".
7. Click "Go" to view the selected transactions, then click "Download".
8. Select "Save to disk" and "OK".
9. Unfortunately, the BrokersXpress download has a few problems that need to be fixed up. I need to update the macro to deal with this automatically, but for now just do these additional steps (it will only take a minute):
2. Select "Activity".
3. Select the period you want to download. (in the drop down menu you can select "last year".
4. Verify the "file type" is correct. (you can choose "all trades", "options trades", "futures trades" etc)
5. Click on the box "show commissions & regulatory fees.
6. In the drop down menu for "download this activity to" select "Excel".
7. Click "Go" to view the selected transactions, then click "Download".
8. Select "Save to disk" and "OK".
9. Unfortunately, the BrokersXpress download has a few problems that need to be fixed up. I need to update the macro to deal with this automatically, but for now just do these additional steps (it will only take a minute):
a. Open the in Excel the saved file from the previous steps.
b. Select "Edit->Replace..." from the Menu.
c. Enter "EXPIRED " in the "Find what" box (without the quotes but WITH the extra space after the D)
d. Make sure the "Replace with" box is empty (delete anything that's in it).
e. Click the "Replace All" button.
f. Now enter "PUT" (all caps) in the "Find what" box; enter "Put" (only the P is in caps) in the "Replace with" box and click the "Replace All" button.
g. Finally, enter "CALL" (all caps) in the "Find what" box; enter "Call" (only the C is in caps) in the "Replace with" box and click the "Replace All" button.
b. Select "Edit->Replace..." from the Menu.
c. Enter "EXPIRED " in the "Find what" box (without the quotes but WITH the extra space after the D)
d. Make sure the "Replace with" box is empty (delete anything that's in it).
e. Click the "Replace All" button.
f. Now enter "PUT" (all caps) in the "Find what" box; enter "Put" (only the P is in caps) in the "Replace with" box and click the "Replace All" button.
g. Finally, enter "CALL" (all caps) in the "Find what" box; enter "Call" (only the C is in caps) in the "Replace with" box and click the "Replace All" button.
Unfortunately, BrokersXpress only offers a download of individual buy and sell transactions, but what you need are the combined transactions, where the buy and sell orders have been matched up. But, don't worry - with the help of our easy to use MatchBuySell macro, you can get your transactions matched up in a matter of seconds. You can purchase the macro for a mere $2.50 by clicking on the previous link. That's it! Now you're ready to run the ConvertExcel2TXF macro to create the .TXF file for your tax software. If you're an active trader, consider also adding our CombineDailyTrades macro.
Edward Jones
1. Login to your account by selecting "Account Access" at the upper left of the home page.
2. Click on "on line documents"
3. Choose the "CSV" download option.
2. Click on "on line documents"
3. Choose the "CSV" download option.
That's it! Now you're ready to run the ConvertExcel2TXF macro to create the .TXF file for your tax software. If you're an active trader, consider also adding our CombineDailyTrades macro.
eOption
1. Click on the "Account" tab and select "Activity".
2. Select "Trades" from the "Activity Type" drop-down.
3. Uncheck the "Current" box, and then select the period you want to download.
4. Click the "Go" button on the left by your account number.
5. Scroll down to the "Trade Detail" table, then scroll right (using the slider bar at the bottom) to the far right side of the table.
6. Click the image of the folder with the arrow at the top right of the table.
7. In the "Export Data" window, select "Delimited Text File", choose "Comma delimted", and click the "Download now" button.
8. When saving the file (or afterwords), change the file extension from ".txt" to ".csv"
2. Select "Trades" from the "Activity Type" drop-down.
3. Uncheck the "Current" box, and then select the period you want to download.
4. Click the "Go" button on the left by your account number.
5. Scroll down to the "Trade Detail" table, then scroll right (using the slider bar at the bottom) to the far right side of the table.
6. Click the image of the folder with the arrow at the top right of the table.
7. In the "Export Data" window, select "Delimited Text File", choose "Comma delimted", and click the "Download now" button.
8. When saving the file (or afterwords), change the file extension from ".txt" to ".csv"
Unfortunately, eOption only offers a download of individual buy and sell transactions, but what you need are the combined transactions, where the buy and sell orders have been matched up. But, don't worry - with the help of our easy to use MatchBuySell macro, you can get your transactions matched up in a matter of seconds. You can purchase the macro for a mere $2.50 by clicking on the previous link. That's it! Now you're ready to run the ConvertExcel2TXF macro to create the .TXF file for your tax software. If you're an active trader, consider also adding our CombineDailyTrades macro.
E*Trade
1. Goto "Trading & Portfolios" and then "Portfolios".
2. Click on the "Gains & Losses" tab.
3. Select the appropriate year in the "Tax Year" box and then click "submit".
4. You should now see a "Download" link next to a green arrow at the upper right-hand side.
5. Save the file to your computer.
6. Unfortunately, there is one problem with Etrade's data: they list the 'Open' and 'Close' transactions, rather than the 'Buy' and 'Sell' transactions, so if you have any short-sales, the data will be in the wrong order. Short-sales will have a "BC" (Buy to Close) in the Order column. If you have any short-sales, here are the additional steps you need to take:
That's it! Now you're ready to run the ConvertExcel2TXF
macro to create the .TXF file for your tax software (see the tutorial). If you're an active trader, consider also
adding our CombineDailyTrades macro.
2. Click on the "Gains & Losses" tab.
3. Select the appropriate year in the "Tax Year" box and then click "submit".
4. You should now see a "Download" link next to a green arrow at the upper right-hand side.
5. Save the file to your computer.
6. Unfortunately, there is one problem with Etrade's data: they list the 'Open' and 'Close' transactions, rather than the 'Buy' and 'Sell' transactions, so if you have any short-sales, the data will be in the wrong order. Short-sales will have a "BC" (Buy to Close) in the Order column. If you have any short-sales, here are the additional steps you need to take:
a. Download this file. It contains a macro that will
help you fix the order of the columns.
b. First make a backup copy of your spreadsheet - just in case something goes wrong.
c. Open the Excel file that you downloaded in step a.
d. From within YOUR spreadsheet, select Tools > Macro > Macros...
e. Select the 'FixShortSellDates!Run' macro and click Run
f. Select the beginning and ending rows for your data.
g. Click Run. It will switch the opening and closing columns for all short transactions, and rename the column headers to the more standard "Buy Date", "Sell Date", etc.
b. First make a backup copy of your spreadsheet - just in case something goes wrong.
c. Open the Excel file that you downloaded in step a.
d. From within YOUR spreadsheet, select Tools > Macro > Macros...
e. Select the 'FixShortSellDates!Run' macro and click Run
f. Select the beginning and ending rows for your data.
g. Click Run. It will switch the opening and closing columns for all short transactions, and rename the column headers to the more standard "Buy Date", "Sell Date", etc.
Fidelity
1. Under "View" select "Tax Info (Year-to-Date)".
2. Specify the desired tax year.
3. Under "Total Realized Gain/Loss" click on details (Net short term or Net long term).
4. Click on "Download" to save your data in spreadsheet (CSV) format. Just download the short-term and long-term gains separately. (2010 Update: It it now just a single download of short- and long-term trades)
2. Specify the desired tax year.
3. Under "Total Realized Gain/Loss" click on details (Net short term or Net long term).
4. Click on "Download" to save your data in spreadsheet (CSV) format. Just download the short-term and long-term gains separately. (2010 Update: It it now just a single download of short- and long-term trades)
That's it! Now you're ready to run the ConvertExcel2TXF macro to create the .TXF file for your tax software. If you're an active trader, consider also adding our CombineDailyTrades macro.
Firstrade
1. From the "My Account" screen, click "Account Download" (left side of screen).
2. Under the "Spreadsheet" column, click the "Excel CSV files" button.
3. Save the resulting CSV file to your computer.
2. Under the "Spreadsheet" column, click the "Excel CSV files" button.
3. Save the resulting CSV file to your computer.
That's it! Now you're ready to run the ConvertExcel2TXF macro to create the .TXF file for your tax software. If you're an active trader, consider also adding our CombineDailyTrades macro.
FxPro
1. In the Meta Trader 4 Terminal select the "Account" tab.
2. Right click on any row in the account history and select "Custom Period".
3. Enter the dates desired for the report and click "OK".
4. Right click on any row in the account history and select "Save as Report".
5. The file will be saved as a .htm document. Open the .htm document with Excel and remove the header and footer information so that only individual trade transactions remain.
6. Unfortunately, you'll need to fix up the date columns before proceeding:
2. Right click on any row in the account history and select "Custom Period".
3. Enter the dates desired for the report and click "OK".
4. Right click on any row in the account history and select "Save as Report".
5. The file will be saved as a .htm document. Open the .htm document with Excel and remove the header and footer information so that only individual trade transactions remain.
6. Unfortunately, you'll need to fix up the date columns before proceeding:
a. Select both the opening and closing date columns by clicking the column header while holding the ctrl key.
b. Goto Edit -> Replace... and replace . with / and click "Replace All".
c. Then goto Format -> Cells... and choose Custom from the list on the left.
d. In the "Type" box enter mm/dd/yyyy and click the Ok button.
b. Goto Edit -> Replace... and replace . with / and click "Replace All".
c. Then goto Format -> Cells... and choose Custom from the list on the left.
d. In the "Type" box enter mm/dd/yyyy and click the Ok button.
That's it! Now you're ready to run the ConvertExcel2TXF macro to create the .TXF file for your tax software. If you're an active trader, consider also adding our CombineDailyTrades macro.
Genworth
1. Click on the "Document Vault" tab.
2. Click the "Download" link for each of the available files.
3. Save the .CSV file(s) to your computer.
2. Click the "Download" link for each of the available files.
3. Save the .CSV file(s) to your computer.
That's it! Now you're ready to run the ConvertExcel2TXF macro to create the .TXF file for your tax software. If you're an active trader, consider also adding our CombineDailyTrades macro.
Interactive Brokers
IB's 'Schedule D' tax report is very easy to use. They don't yet offer a direct TXF download, but do offer an MS Excel download. Here are the steps:
1. Login to Account Management.
2. Click on "Report Management" and then "Tax Forms".
3. Select the option for "Gain and Loss Report (Schedule D)".
4. Select MS Excel as the download format."
2. Click on "Report Management" and then "Tax Forms".
3. Select the option for "Gain and Loss Report (Schedule D)".
4. Select MS Excel as the download format."
That's it! Now you're ready to run the ConvertExcel2TXF macro to create the .TXF file for your tax software. If you're an active trader, consider also adding our CombineDailyTrades macro.
Note: IB already combines the quantity with the description into a single column, so you'll just leave the quantity column box on the user form blank (see the tutorial).
IZone by TDAmeritrade
JMS
1. Proceed to account information.
2. Select the appropriate range of account transaction data.
3. Select the save option to save your data in a .csv file.
2. Select the appropriate range of account transaction data.
3. Select the save option to save your data in a .csv file.
Currently, there are two small problems with the JMS download: the ticker symbol is prefixed with the security type (even though there is a separate additional column with the security type), and the date format is non standard. You can fix up your download in a matter of seconds with the help of a quick macro.
1. Download fix_jms_data.xls (free download).
2. Follow the simple directions on the splash screen when you open the file.
2. Follow the simple directions on the splash screen when you open the file.
Unfortunately, JMS only offers a download of individual buy and sell transactions, but what you need are the combined transactions, where the buy and sell orders have been matched up. But, don't worry - with the help of our easy to use MatchBuySell macro, you can get your transactions matched up in a matter of seconds. You can purchase the macro for a mere $2.50 by clicking on the previous link. That's it! Now you're ready to run the ConvertExcel2TXF macro to create the .TXF file for your tax software. If you're an active trader, consider also adding our CombineDailyTrades macro.
JP Morgan
1. Goto the Portfolio view.
2. Select "Download Manager".
3. Choose the "Realized Gain/Loss" report format.
4. Leave the "Filter by security" option blank.
5. Choose the "Date Range" (e.g., Prior Year).
6. Choose the "CSV" Export.
7. Click "Download".
2. Select "Download Manager".
3. Choose the "Realized Gain/Loss" report format.
4. Leave the "Filter by security" option blank.
5. Choose the "Date Range" (e.g., Prior Year).
6. Choose the "CSV" Export.
7. Click "Download".
That's it! Now you're ready to run the ConvertExcel2TXF macro to create the .TXF file for your tax software. If you're an active trader, consider also adding our CombineDailyTrades macro.
Just2Trade
1. Select the "Maxit" option from the "Accounts" tab on the main page.
2. Click on the "Realized G/L" tab.
3. Click on the Excel download link and save the file to your computer.
2. Click on the "Realized G/L" tab.
3. Click on the Excel download link and save the file to your computer.
[Optional] The Just2Trade download notes the wash sale adjusted entries with a "WSH" in Event column. You should consider adding this information to the ticker column so that it is reported on your schedule D. You can do this with a simple Excel formula:
1. Select and copy the following formula:
=IF(E6="WSH",A6 & " (Wash Sale Adjusted)",IF(A6="","",A6))
2.Paste the formula into the 6th row of column X (or any other emply column).
3.Copy the new cell, select the remaining rows in the column, and then paste.
4.Now when you run ConvertExcel2TXF, just use the new column as the description column.
=IF(E6="WSH",A6 & " (Wash Sale Adjusted)",IF(A6="","",A6))
2.Paste the formula into the 6th row of column X (or any other emply column).
3.Copy the new cell, select the remaining rows in the column, and then paste.
4.Now when you run ConvertExcel2TXF, just use the new column as the description column.
That's it! Now you're ready to run the ConvertExcel2TXF macro to create the .TXF file for your tax software. If you're an active trader, consider also adding our CombineDailyTrades macro.
Merrill Lynch
1. Sign into your account at www.mlol.ml.com.
2. Under the "Accounts" Tab, select "My Accounts".
3. Select "Download Center" at the bottom of the beige box on the right side of the screen.
4. Select the individual account in the drop-down box.
5. Scroll down and select the last radio button for "Plain Text (Year-end Tax Reporting Statement)".
6. Scroll down further and highlight the "Year-end Gain/Loss Detail FIFO" line.
7. Click the "Download" button. When the File Download dialogue box pops up, click the "Save" button.
8. Choose where you wish to store the file from the drop-down box titled "Save in:" at the top.
9. Click the "Save-as" drop down box at the bottom and select "All Files".
10. Change the ".dnl" in the File Name box at the bottom to ".xls".
11. Click the "Save" button.
2. Under the "Accounts" Tab, select "My Accounts".
3. Select "Download Center" at the bottom of the beige box on the right side of the screen.
4. Select the individual account in the drop-down box.
5. Scroll down and select the last radio button for "Plain Text (Year-end Tax Reporting Statement)".
6. Scroll down further and highlight the "Year-end Gain/Loss Detail FIFO" line.
7. Click the "Download" button. When the File Download dialogue box pops up, click the "Save" button.
8. Choose where you wish to store the file from the drop-down box titled "Save in:" at the top.
9. Click the "Save-as" drop down box at the bottom and select "All Files".
10. Change the ".dnl" in the File Name box at the bottom to ".xls".
11. Click the "Save" button.
That's it! Now you're ready to run the ConvertExcel2TXF macro to create the .TXF file for your tax software. If you're an active trader, consider also adding our CombineDailyTrades macro.
Morgan Stanley
1. Login to client services.
2. Select "Portfolio" -> "Gain\Loss".
3. Select the "Realized Gain\Loss" tab.
4. Select the appropriate time period from the dropdown box and then click Go.
5. This brings up the Gain\Loss report. On the upper right of the screen click the downLoad icon (Down Arrow).
6. Save the file to your computer.
2. Select "Portfolio" -> "Gain\Loss".
3. Select the "Realized Gain\Loss" tab.
4. Select the appropriate time period from the dropdown box and then click Go.
5. This brings up the Gain\Loss report. On the upper right of the screen click the downLoad icon (Down Arrow).
6. Save the file to your computer.
That's it! Now you're ready to run the ConvertExcel2TXF macro to create the .TXF file for your tax software. If you're an active trader, consider also adding our CombineDailyTrades macro.
OptionsFirst
1. Click the "MAXIT TAX CALC" tab at the bottom of the screen - this will open a new window.
2. Click the "Launch Maxit" button.
3. Click "REALIZED G/L" tab.
4. Enter the date range for tax year and then click the "Go" button.
5. Click the Excel icon at the top-right of the results.
6. Save the file to your computer.
2. Click the "Launch Maxit" button.
3. Click "REALIZED G/L" tab.
4. Enter the date range for tax year and then click the "Go" button.
5. Click the Excel icon at the top-right of the results.
6. Save the file to your computer.
That's it! Now you're ready to run the ConvertExcel2TXF macro to create the .TXF file for your tax software. If you're an active trader, consider also adding our CombineDailyTrades macro.
Note: the OptionsFirst download separates the Long and Short positions into separate sections. You can either run the macro on each section separately, or just delete the title and sub-total rows in between the two sections and then just run the macro once.
OptionsHouse
1. Click on the "Activity" tab at the bottom of the screen.
2. Select the period that you want to download.
3. Click "Export" at the upper-right of the screen.
4. Save the .csv file to your computer.
2. Select the period that you want to download.
3. Click "Export" at the upper-right of the screen.
4. Save the .csv file to your computer.
Unfortunately, OptionsHouse only offers a download of individual buy and sell transactions, but what you need are the combined transactions, where the buy and sell orders have been matched up. But, don't worry - with the help of our easy to use MatchBuySell macro, you can get your transactions matched up in a matter of seconds. You can purchase the macro for a mere $2.50 by clicking on the previous link. That's it! Now you're ready to run the ConvertExcel2TXF macro to create the .TXF file for your tax software. If you're an active trader, consider also adding our CombineDailyTrades macro.
OptionsXpress
1. Go to "Account" tab.
2. Select "Activity".
3. Select the period you want to download. (in the drop down menu you can select "last year".
4. Verify the "file type" is correct. (you can choose "all trades", "options trades", "futures trades" etc)
5. Click on the box "show commissions & regulatory fees.
6. In the drop down menu for "download this activity to" select "Excel".
7. Click "go" to view the selected transactions, then click "Download".
8. Select "Save to disk" and "OK".
9. Unfortunately, the OptionsXpress download has a few problems that need to be fixed up. I need to update the macro to deal with this automatically, but for now just do these additional steps (it will only take a minute):
2. Select "Activity".
3. Select the period you want to download. (in the drop down menu you can select "last year".
4. Verify the "file type" is correct. (you can choose "all trades", "options trades", "futures trades" etc)
5. Click on the box "show commissions & regulatory fees.
6. In the drop down menu for "download this activity to" select "Excel".
7. Click "go" to view the selected transactions, then click "Download".
8. Select "Save to disk" and "OK".
9. Unfortunately, the OptionsXpress download has a few problems that need to be fixed up. I need to update the macro to deal with this automatically, but for now just do these additional steps (it will only take a minute):
a. Open the in Excel the saved file from the previous steps.
b. Select "Edit->Replace..." from the Menu.
c. Enter "EXPIRED " in the "Find what" box (without the quotes but WITH the extra space after the D)
d. Make sure the "Replace with" box is empty (delete anything that's in it).
e. Click the "Replace All" button.
f. Now enter "PUT" (all caps) in the "Find what" box; enter "Put" (only the P is in caps) in the "Replace with" box and click the "Replace All" button.
g. Finally, enter "CALL" (all caps) in the "Find what" box; enter "Call" (only the C is in caps) in the "Replace with" box and click the "Replace All" button.
b. Select "Edit->Replace..." from the Menu.
c. Enter "EXPIRED " in the "Find what" box (without the quotes but WITH the extra space after the D)
d. Make sure the "Replace with" box is empty (delete anything that's in it).
e. Click the "Replace All" button.
f. Now enter "PUT" (all caps) in the "Find what" box; enter "Put" (only the P is in caps) in the "Replace with" box and click the "Replace All" button.
g. Finally, enter "CALL" (all caps) in the "Find what" box; enter "Call" (only the C is in caps) in the "Replace with" box and click the "Replace All" button.
Unfortunately, OptionsXpress only offers a download of individual buy and sell transactions, but what you need are the combined transactions, where the buy and sell orders have been matched up. But, don't worry - with the help of our easy to use MatchBuySell macro, you can get your transactions matched up in a matter of seconds. You can purchase the macro for a mere $2.50 by clicking on the previous link. That's it! Now you're ready to run the ConvertExcel2TXF macro to create the .TXF file for your tax software. If you're an active trader, consider also adding our CombineDailyTrades macro.
Prudential
1. Login to your account and click on “Account Download” in the Account Services menu (on the left column).
2. Select the desired account from the “Choose an Account” pull down menu.
3. Choose the “Realized Gains/Losses (Last Year) option from the "Choose Download Basis" pull down menu.
4. Ignore the “Choose your Portfolio View” pull down menu.
5. Finally, click on the “Download to Excel” button.
2. Select the desired account from the “Choose an Account” pull down menu.
3. Choose the “Realized Gains/Losses (Last Year) option from the "Choose Download Basis" pull down menu.
4. Ignore the “Choose your Portfolio View” pull down menu.
5. Finally, click on the “Download to Excel” button.
That's it! Now you're ready to run the ConvertExcel2TXF macro to create the .TXF file for your tax software. If you're an active trader, consider also adding our CombineDailyTrades macro.
Schwab
1. Click on the "Accounts" tab.
2. Click on the "History" tab.
3. Go two lines down and click on the "Realized Gain/Loss" tab.
4. Specify the date range and click "Search".
5. When results come back click on "Export" in the line above account number.
6. Click the "Export Details" button and save the CSV file to your computer.
2. Click on the "History" tab.
3. Go two lines down and click on the "Realized Gain/Loss" tab.
4. Specify the date range and click "Search".
5. When results come back click on "Export" in the line above account number.
6. Click the "Export Details" button and save the CSV file to your computer.
Now you're ready to run the ConvertExcel2TXF macro to create the .TXF file for your tax software, and all of your transactions will be imported into the appropriate short- or long-term schedules. If you're an active trader, consider also adding our CombineDailyTrades macro.
Scottrade
1. Go to "My Account" and then "Gain/Loss & Tax Center".
2. Select "Prior Year Gain Loss" at "Gain/Loss Reports".
3. Specify the time frame (e.g., 01/01/2009 to 12/31/2009) and then press "Go".
4. Just above the transactions records there is a link called "view details". Click on it to get the transaction details like dates and wash sales.
5. Then, at the right side of the "Go", press "Export to Excel".
6. Save the .CSV file to your computer.
2. Select "Prior Year Gain Loss" at "Gain/Loss Reports".
3. Specify the time frame (e.g., 01/01/2009 to 12/31/2009) and then press "Go".
4. Just above the transactions records there is a link called "view details". Click on it to get the transaction details like dates and wash sales.
5. Then, at the right side of the "Go", press "Export to Excel".
6. Save the .CSV file to your computer.
That's it! Now you're ready to run the ConvertExcel2TXF macro to create the .TXF file for your tax software. If you're an active trader, consider also adding our CombineDailyTrades macro. Getting your data out of your ShareBuilder account is pretty straightforward. Here are the steps:
1. Sign into your account. (you must be in IE or FIrefox, not Google Chrome)
2. Select "View Your Portfolio"
3. In the next window select the "Gains & Losses" tab
4. Click the "Gain & Loss Tax Management Tool" link in the first paragraph
5. On the bottom right, click "START GAIN & LOSS TOOL"
6. Select the Timeframe (should already be set at Previous Year)
7. Go to the upper right-hand corner just under Sharebuilder logo and click "DOWNLOAD"
8. Save the Excel file to your computer
2. Select "View Your Portfolio"
3. In the next window select the "Gains & Losses" tab
4. Click the "Gain & Loss Tax Management Tool" link in the first paragraph
5. On the bottom right, click "START GAIN & LOSS TOOL"
6. Select the Timeframe (should already be set at Previous Year)
7. Go to the upper right-hand corner just under Sharebuilder logo and click "DOWNLOAD"
8. Save the Excel file to your computer
That's it! Now you're ready to run the ConvertExcel2TXF macro to create the .TXF file for your tax software. If you're an active trader, consider also adding our CombineDailyTrades macro.
Smith Barney
1. Under Portfolio Menu option, click on Account Download. That will take you to Download Manager web page.
2. Using the drop-down box next to your account number, select the appropriate account view and click the "Download Data" button.
3. Save the file to your computer.
2. Using the drop-down box next to your account number, select the appropriate account view and click the "Download Data" button.
3. Save the file to your computer.
That's it! Now you're ready to run the ConvertExcel2TXF macro to create the .TXF file for your tax software. If you're an active trader, consider also adding our CombineDailyTrades macro.
SogoTrade/SogoElite
Getting your data out of your Sogotrade or SogoElite account is a little bit of a pain, but it shouldn't take too long. Just follow the steps below, and if you run into any problems, just send me an email:
1. Click on the "Statements" option under the "Account" menu button.
2. Edit the "from" and "to" month and year dropdown fields to get the range of monthly statements that you need.
3. Clicking on the link for a monthly statement will open a PDF file that you can save to your computer. Unfortunately, you'll need to save each of the twelve statements for the year.
4. You'll then need to get the "Account Activity" table from the PDF file into Excel. There are two ways to do this:
5. Using either of the above options should get you a reasonably well formatted Excel file, but you may need to do some editing in Excel before proceeding. I particular, you'll want to join the data from your twelve statements into a single Excel worksheet. Also, some of the rows may get a little messed up and will need to be fixed up (i.e. Cash Journal Entries).
2. Edit the "from" and "to" month and year dropdown fields to get the range of monthly statements that you need.
3. Clicking on the link for a monthly statement will open a PDF file that you can save to your computer. Unfortunately, you'll need to save each of the twelve statements for the year.
4. You'll then need to get the "Account Activity" table from the PDF file into Excel. There are two ways to do this:
a. If you have access to Adobe Acrobat Pro (not Acrobat Reader), you can highlight the table, right-click, and select "copy as table". Then paste into an Excel worksheet.
b. You can use the site PDFtoWord to convert your PDF files to MS Word files. Then open the Word files, select and copy the "Account Activity" table, and paste into an Excel worksheet.
b. You can use the site PDFtoWord to convert your PDF files to MS Word files. Then open the Word files, select and copy the "Account Activity" table, and paste into an Excel worksheet.
5. Using either of the above options should get you a reasonably well formatted Excel file, but you may need to do some editing in Excel before proceeding. I particular, you'll want to join the data from your twelve statements into a single Excel worksheet. Also, some of the rows may get a little messed up and will need to be fixed up (i.e. Cash Journal Entries).
Unfortunately, SogoTrade/SogoElite statements only show individual buy and sell transactions, but what you need are the combined transactions, where the buy and sell orders have been matched up. But, don't worry - with the help of our easy to use MatchBuySell macro, you can get your transactions matched up in a matter of seconds. You can purchase the macro for a mere $2.50 by clicking on the previous link. That's it! Now you're ready to run the ConvertExcel2TXF macro to create the .TXF file for your tax software. If you're an active trader, consider also adding our CombineDailyTrades macro.
TD Ameritrade
If you are an Ameritrade customer, you do not need the ConvertExcel2TXF macro. Ameritrade (for now) provides its customers with free access to Gainskeeper, which should work seamlessly with TaxCut and TurboTax. Here are the steps for generating a .TXF file:
1. Click on "Portfolio & Accounts" from the top menu.
2. Click on "Gain/Loss".
3. Select "Export Data".
4. Select "Get Report as Tax Software TXF File"
2. Click on "Gain/Loss".
3. Select "Export Data".
4. Select "Get Report as Tax Software TXF File"
However, if you are an active trader, you may consider just downloading to Excel, and then using our CombineDailyTrades macro coupled with the ConvertExcel2TXF macro to consolidate and clean up your trades.
Terra Nova
1. Click "Profit/Loss" on left hand column.
2. Select the date range (e.g., Jan 1 to Dec 31).
3. Click "Submit".
4. When the report comes up, click on the prompt to download data. Choose the CSV download format.
5. If you get a message which states "May contain features that are not compatible with CSV (comma delineated). Do you want to keep the workbook in this format?", click "Yes".
6. Save the file to your computer.
2. Select the date range (e.g., Jan 1 to Dec 31).
3. Click "Submit".
4. When the report comes up, click on the prompt to download data. Choose the CSV download format.
5. If you get a message which states "May contain features that are not compatible with CSV (comma delineated). Do you want to keep the workbook in this format?", click "Yes".
6. Save the file to your computer.
That's it! Now you're ready to run the ConvertExcel2TXF macro to create the .TXF file for your tax software. If you're an active trader, consider also adding our CombineDailyTrades macro.
ThinkOrSwim
1. Goto "My Accounts" and then "Other Info"
2. Select "Taxes" and then "Generate Tax Worksheet".
3. Pick the desired date range.
4. Download and save the CSV file.
2. Select "Taxes" and then "Generate Tax Worksheet".
3. Pick the desired date range.
4. Download and save the CSV file.
That's it! Now you're ready to run the ConvertExcel2TXF macro to create the .TXF file for your tax software. If you're an active trader, consider also adding our CombineDailyTrades macro.
TradeKing
1. Goto Accounts -> Download Data
2. Click the checkbox for "Excel" under "Choose Format".
3. Choose "Realized Gain/Loss (Prior Year)" under Choose Data pull-down menu.
4. Click the "Download" button.
2. Click the checkbox for "Excel" under "Choose Format".
3. Choose "Realized Gain/Loss (Prior Year)" under Choose Data pull-down menu.
4. Click the "Download" button.
That's it! Now you're ready to run the ConvertExcel2TXF macro to create the .TXF file for your tax software. If you're an active trader, consider also adding our CombineDailyTrades macro.
TradeStation
1. Under the "Account Services" tab, click "Balances, Positions & Activity"
2. Click "tax activity".
3. Select the date range you want. Only 3 months can be selected at a time. You will have to download 4 quarters and then combine them to a single file (via copying and pasting).
4. Under "Security type" select either "All".
5. Under "Transaction type" select "All".
6. Under file type select "Excel" from the drop down menu
7. Click "Download" and then "Save to disk" and then "OK".
2. Click "tax activity".
3. Select the date range you want. Only 3 months can be selected at a time. You will have to download 4 quarters and then combine them to a single file (via copying and pasting).
4. Under "Security type" select either "All".
5. Under "Transaction type" select "All".
6. Under file type select "Excel" from the drop down menu
7. Click "Download" and then "Save to disk" and then "OK".
Unfortunately, TradeStation only offers a download of individual buy and sell transactions, but what you need are the combined transactions, where the buy and sell orders have been matched up. But, don't worry - with the help of our easy to use MatchBuySell macro, you can get your transactions matched up in a matter of seconds. You can purchase the macro for a mere $2.50 by clicking on the previous link. That's it! Now you're ready to run the ConvertExcel2TXF macro to create the .TXF file for your tax software. If you're an active trader, consider also adding our CombineDailyTrades macro.
UBS
1. Click on any of your account numbers.
2. In the upper boxes, click "Statement and Reports"
3. Click "Download" on the far left
4. Under "Step 1" select "Account Information" and click "Realized Gain/(Loss)"
5. Under "Step 2" select "Accounts" and click any of your Accounts
6. Under "Step 3" select "Timeframe" and choose the desired tax year.
7. Under "Step 4" select "Download".
2. In the upper boxes, click "Statement and Reports"
3. Click "Download" on the far left
4. Under "Step 1" select "Account Information" and click "Realized Gain/(Loss)"
5. Under "Step 2" select "Accounts" and click any of your Accounts
6. Under "Step 3" select "Timeframe" and choose the desired tax year.
7. Under "Step 4" select "Download".
Unfortunately, UBS only offers a download of individual buy and sell transactions, but what you need are the combined transactions, where the buy and sell orders have been matched up. But, don't worry - with the help of our easy to use MatchBuySell macro, you can get your transactions matched up in a matter of seconds. You can purchase the macro for a mere $2.50 by clicking on the previous link. That's it! Now you're ready to run the ConvertExcel2TXF macro to create the .TXF file for your tax software. If you're an active trader, consider also adding our CombineDailyTrades macro.
Wachovia
1. Select "Account Downloads" from under "Account Services" on the left margin.
2. Select the "Excel" tab, then choose the following options:
2. Select the "Excel" tab, then choose the following options:
a. Select an account: Household
b. Choose download basis: Realized Gain/Lossess (Last Year)
3. Click on "Download to Excel" and save the .XLS file
b. Choose download basis: Realized Gain/Lossess (Last Year)
3. Click on "Download to Excel" and save the .XLS file
That's it! Now you're ready to run the ConvertExcel2TXF macro to create the .TXF file for your tax software. If you're an active trader, consider also adding our CombineDailyTrades macro.
Note: Wachovia separates stocks and options, so if you have both, you'll need to run ConvertExcel2TXF separately on each section. Then just import both TXF files into your tax software.
Zecco
1. Click on "Account Records".
2. Click on "Trade Activity".
3. Specify the dates of interest.
4. Once trade info appears, click the download icon.
5. Choose "Comma Delimited File" and save.
2. Click on "Trade Activity".
3. Specify the dates of interest.
4. Once trade info appears, click the download icon.
5. Choose "Comma Delimited File" and save.
Unfortunately, Zecco only offers a download of individual buy and sell transactions, but what you need are the combined transactions, where the buy and sell orders have been matched up. But, don't worry - with the help of our easy to use MatchBuySell macro, you can get your transactions matched up in a matter of seconds. You can purchase the macro for a mere $2.50 by clicking on the previous link. That's it! Now you're ready to run the ConvertExcel2TXF macro to create the .TXF file for your tax software. If you're an active trader, consider also adding our CombineDailyTrades macro.
Purchase ConvertExcel2TXF now for only$5.00
If you have any questions or comments, send me an email.