Excel2TXF - Specific Broker Instructions

Here you'll find instructions for using Excel2TXF with specific brokers. If you don't see your broker listed, you can get a free copy of the Excel2TXF program if you provide a sample file along with instructions for generating the file from your broker's website. Just send us an email

National Financial Services
NetExchange
NYLife
Oberweis Securities (NFS)
Oppenheimer & Co
OptionsFirst (by Scottrade)
OptionsHouse
OptionsXpress
Penson Financial Services
Pershing
ProFunds
Prudential
Questrade
Rydex
Schwab
Scottrade
ShareBuilder (ING Direct)
Smith Barney
SogoTrade/SogoElite
Southwest Securities (SWS Group)
SpeedTrader
SureTrader
TDAmeritrade
Terra Nova
ThinkOrSwim
TradeKing
TradeMonster
TradeStation
UBS
Vanguard
Wachovia
Weatherstone
Wells Fargo
Zecco
Zions Direct



Ameriprise

While Ameriprise clients typically receive only a hard copy of trade data, the Advisors do receive an Excel file which can be easily converted to a TXF file. Just contact your advisor and request the Excel file of your trades. Then you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

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 Quick Start Guide). Also, the short- and long-term trades are in separate sections, so you'll either need to run the program on each section separately, or delete any totals and column header rows inbetween the two sections.

Bank of America

Excel2TXF has been validated with a sample Bank of America download, but I don't yet have the details for generating the download (If you figure out the steps, please send us an email so that we can update these instructions). Since they have now merged with Merrill Lynch, you may be able to use the download instructions for Merrill.

Once you get your download you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

Bernstein (AllianceBernstein)

Excel2TXF has been validated with a sample Bernstein download, but I don't yet have the details for generating the download (If you figure out the steps, please send us an email so that we can update these instructions).

Once you get your download you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

BNY Mellon

BNY does not currently offer any usable trade or activity downloads from their website, but an Excel file can be obtained from a portfolio manager. Just contact your portfolio manager and request your 1099-B in Excel format. With that you'll be ready to run the Excel2TXF software to create the .TXF file for your tax software.

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

First, login to your account and follow the steps below:
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".

Note: BrokersXpress only offers a download of individual buy and sell transactions, so Excel2TXF will first try to match up the individual buy & sell trades. To ensure proper matching, make sure that any positions which carried over from previous years are included in your file (you may need to manually add them by looking at your prior year-end account statement).

That's it! Now you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

Chase

Excel2TXF has been validated with a sample Chase download, but I don't yet have the details for generating the download. You'll want to find the "Realized Gain/Loss Export" option (If you figure out the steps, please send us an email so that we can update these instructions).

Once you get your download you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

Cobra Trading

Getting your data out of Cobra is fairly simple. Login to your account and follow the steps below:
1. From the Account menu, select "Activity".
2. On Account Activity screen, choose the desired date range and click "GO".
3. Click on the "Export Data" link at the bottom of the trade listing.
4. Save the file to your computer.

Note: Cobra Trading only offers a download of individual buy and sell transactions, so Excel2TXF will first try to match up the individual buy & sell trades. To ensure proper matching, make sure that any positions which carried over from previous years are included in your file (you may need to manually add them by looking at your prior year-end account statement).

That's it! Now you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

Comerica

Getting your data out of the Comerica website is very straightforward:
1. Login to your account and click on the "Account" tab.
2. Click on the "Holdings" tab.
3. Click on the "Realized Gains/Losses" tab.
4. Click the "Download" link.

That's it! Now you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

Curian Capital

To get your gain/loss report from the Curian website, just follow the steps:
1. Login to your account and go to the "Tax Center".
2. Find the "YTD Gains & Losses Download" section at the bottom of the page.
3. Choose the "Spreadsheet File (.csv)" download option and click the "Download" button.
4. Save the file to your computer.

That's it! Now you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

Edward Jones

Getting your download from Edward Jones is pretty straightforward:
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.

That's it! Now you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

eOption

First, login to your account and follow the steps below:
1. Click on the "Account" tab and select "Activity".
2. Select "All" 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"

Note: eOption only offers a download of individual buy and sell transactions, so Excel2TXF will first try to match up the individual buy & sell trades. To ensure proper matching, make sure that any positions which carried over from previous years are included in your file (you may need to manually add them by looking at your prior year-end account statement).

That's it! Now you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

E*Trade

Getting your data out of E*Trade is now pretty straightforward (in past years, the download format was messed up and required additional manipulation). Note that you will be using a download from the "Portfolios" menu and not from the "Tax Center".
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.
Note: 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. But, no worries - Excel2TXF will automatically adjust for these entries.

That's it! Now you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

Fidelity

Fidelity now offers a download in a Realized Gain/Loss format, which is an improvement over the history download that was previously the only format offered. The gain/loss format even includes wash sales. Login to your Fidelity account and follow the steps below:
1. Under "View" select "Tax Info (Year-to-Date)".
2. Specify the desired tax year.
3. Under "Total Realized Gain/Loss" click on details.
4. Click on "Download" to save your data in spreadsheet (CSV) format.

That's it! Now you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

First Allied

It's not clear whether First Allied offers a download from their website, but you can obtain an Excel file with your Realized Gains & Losses by contacting them directly. Once you have the Excel file, you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

Firstrade

Getting your data out of Firstrade is very straightforward. Here are the steps:
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.

That's it! Now you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

FOLIOfn (Folio Investments)

Excel2TXF has been validated with a sample FOLIOfn download, but I don't yet have the details for generating the download (If you figure out the steps, please send us an email so that we can update these instructions).

Once you get your download you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

FSC Securities Corporation

Getting your data out of FSC is fairly straightforward. Here are the steps:
1. Login and open the desired account.
2. Select "Holdings" and then select "Realized Gain/Loss".
3. Under "Search Criteria" select "Prior Year Realized Gain/Losses".
4. Select "Download" from the upper-right of the page to download as an Excel file.
5. Save the file to your computer.

Unfortunately, the FSC download has some problems with the disallowed loss column and requires additional manipulation. We have experience with the necessary adjustments, so just purchase the Full-Service option and we'll take care of everything.

FTJ FundChoice

To get your data out of FTJ, just follow these steps:
1. Click the "Portfolio" Tab at the top of the screen.
2. Select "Substitute Schedule D1" from the Tax submenu at the top of the screen.
3. Click "Ok" on the disclaimer.
4. Choose the desired download "Level"
5. Select one of the preset timeframes, OR enter the date directly on the screen as MM/DD/YYYY format, OR click on the Quick Date Calendar Icon.
6. Select the "Excel" output option.
7. Click "Generate Report".

Note: The short- and long-term trades are in separate sections, so you'll either need to run the program on each section separately, or delete any totals and column header rows inbetween the two sections.

That's it! Now you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

FxPro

Getting your data out of FxPro is fairly straightforward. Here are the steps:
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:
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.

That's it! Now you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

GainsKeeper

Excel2TXF has been validated with a sample GainsKeeper download, but I don't yet have the details for generating the download (If you figure out the steps, please send us an email so that we can update these instructions).

Once you get your download you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

Genworth

Genworth provides a Schedule D download for each taxable account. Login in to your account and follow the steps below:
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.

That's it! Now you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

GW Henssler

GW Henssler does not currently offer a download from their website, but they do provide clients with an Excel file with their Realized Gains & Losses. With that, you'll be ready to run the Excel2TXF software to create the .TXF file for your tax software.

HotForex

Getting your data out of HotForex is easy. Here are the steps:
1. In the Meta Trader 4 Terminal select the "Account" tab at the bottom of the screen.
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.

Note: Unfortunately, the HotForex download is not directly compatible with Excel2TXF and requires additional manipulation to backout the required total cost and proceeds columns from the available columns. We do have experience with these files and the requisite manipulation, so we recommend that you purchase the Full-Service option.

Interactive Brokers

(UPDATE: Make sure that you have the latest TurboTax updates in order to avoid errors associated with the adjustments)

IB changed their download format for 2011, but . Here are the steps:
1. Login to Account Management.
2. Click on "Report Management" and then "Tax Forms".
3. Select the option for "Worksheet for Form 8949".
4. Select appropriate year and choose "CSV" as the download format.

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. Also, you'll need to run the program separately on each section of the worksheet, which correspond to the various Form 8949 versions.

That's it! Now you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

IZone by TDAmeritrade

Excel2TXF has been validated with a sample Izone download, but I don't yet have the details for generating the download (If you figure out the steps, please send us an email so that we can update these instructions).

Note: IZone only offers a download of individual buy and sell transactions, so Excel2TXF will first try to match up the individual buy & sell trades. To ensure proper matching, make sure that any positions which carried over from previous years are included in your file (you may need to manually add them by looking at your prior year-end account statement).

That's it! Now you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

JMS

First, login to your JMS account and follow the steps below:
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.

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.

Note: JMS only offers a download of individual buy and sell transactions, so Excel2TXF will first try to match up the individual buy & sell trades. To ensure proper matching, make sure that any positions which carried over from previous years are included in your file (you may need to manually add them by looking at your prior year-end account statement).

That's it! Now you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

JP Morgan

First, login to your JPMorganSecurities.com account and follow the steps below:
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".

That's it! Now you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

Just2Trade

First, login to your Just2Trade.com account and follow the steps below:
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.

[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 Excel2TXF, just use the new column as the description column.

That's it! Now you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

MB Trading

First, login to your account and follow the steps below:
1. Click on the "Account" tab and select "Activity".
2. Select "Trade Activity" from the "Account Information" drop down options.
3. Select your account from the "Account" drop down options.
4. Enter a date range.
5. Click the "Go" button.
6. Select the "Comma Delimited" text file download option.
7. When saving the file (or afterwords), change the file extension from ".txt" to ".csv"

Note: MB only offers a download of individual buy and sell transactions, so Excel2TXF will first try to match up the individual buy & sell trades. To ensure proper matching, make sure that any positions which carried over from previous years are included in your file (you may need to manually add them by looking at your prior year-end account statement).

That's it! Now you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

MB Trading (Forex)

Getting your Forex data out of MB is fairly straightforward. Here are the steps:
1. Login to your account.
2. Choose "My Forex Account" -> "Manage" -> "Report" -> "Profit and Loss".
3. Choose the appropriate date range and select "Download".
4. Save the .xls file to your computer.

Unfortunately, the MB download format for Forex accounts is not directly compatible with the Excel2TXF software and requires additional manipulation. Just purchase the Full-Service option and we'll take care of everything.

Merrill Lynch

Getting your data out of Merrill Lynch is fairly straightforward. Here are the steps:
1. Sign into your account.
2. Under the "Portfolio & Accounts" tab, select "Download". You should see 4 steps.
3. Step 1: Choose Category or Account from the drop-down box.
4. Step 2: Choose Application: Click the "Spreadsheets and Text" radio button.
5. Step 3: Choose Settings: Click "Year-End Tax Information radio button. You will see an expanded Year-End Tax Information series of checkboxes. Uncheck all but "Gain/Loss Detail".
6. Step 4: Download: Click the "Comma-Separated Spreadsheet (.CSV) radio button
7. Click the "Download" button that appears next to "Gain/Loss Detail". When the File Download dialogue box pops up, click the "Save" button.
8. Save the file to your computer.

That's it! Now you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

Morgan Stanley

(UPDATE: the Morgan Stanley download has changed this year and includes some unfortunate 'features' like carriage returns inside cells. The Excel version has been updated to handle the new format, but it is not compatible with the Java version. If you aren't able to run the Excel version, please consider the Full-Service option instead)

Getting your data out of Morgan Stanley is fairly straightforward. Here are the steps:
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.

That's it! Now you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

Morgan Keegan

Morgan Keegan does not currently offer any usable trade or activity downloads from their website, but an Excel file can be obtained from your broker. Just request the broker to generate a Closed Lot Excel spreadsheet. With that, you'll be ready to run the Excel2TXF software to create the .TXF file for your tax software.

National Financial Services

NOTE: NFS clears for many brokers. These steps were provided by Oberweis, but should be similar for any NFS correspondent

Here are the steps to get your gain/loss report out of an NFS broker:
1. Login to your account and select "Portfolio" from the top menu.
2. Select the "Summary" tab.
3. For the desired account, click the "Select Action" dropdown.
4. Click on "Positions – Previous Sales/Realized".
5. Select the year and click "Go".
6. Click on the "Export" link at the top right-hand side of page.
7. Save the Excel file to your computer.

That's it! Now you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

NetExchange

NetExchange does not currently offer any usable trade or activity downloads from their website, but an Excel file can be obtained from a financial advisor. Just contact your advisor and request your gain/loss report in Excel format. With that, you'll be ready to run the Excel2TXF software to create the .TXF file for your tax software.

That's it! Now you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

NYLife

It's not clear whether NYLife offers a download from their website, but they do provide clients with an Excel file with their Realized Gains & Losses. Note: There are a few problems with the download that you'll need to address before running the software:
1. They tend to use a lot of "--" entries to mean zero in numerical fields, particularly in wash sale entries. You'll need to use a 'Fine & Replace' to replace all "--" with a zero.
2. There is no purchase date listed for the wash sales, but you'll need one. It should be the purchase date of the subsequent position that triggered the wash sale. You'll need to manually update any wash sale entries.

With that, you'll be ready to run the Excel2TXF software to create the .TXF file for your tax software.

If you have trouble trying to fix up the file, consider purchasing or upgrading to the full-service option. We have experience with these files and will take care of everything for you.

Oppenheimer & Co.

Here are the steps to get your gain/loss report out of Oppenheimer:
1. Go to the Oppenheimer website www.opco.com.
2. Click on "Client Login".
3. Login to your account.
4. Click on the "My Accounts" tab.
5. Select the desired account.
6. Under the "Reports" tab for the selected account, click on the "Realized G/L" report from the “Select” drop down.
7. In the upper right corner of the web page click on "Export to Excel".
8. Select the "CSV" export format and the year, and then click the "Export" button.
9. Save the file to your computer.

That's it! Now you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

OptionsFirst

Getting your data out of OptionsFirst is fairly straightforward. Here are the steps:
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.

Note: the OptionsFirst download separates the Long and Short positions into separate sections. You can either run Excel2TXF on each section separately, or just delete the title and sub-total rows in between the two sections and then just run the software once.

That's it! Now you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

OptionsHouse

OptionsHouse now offers a realized gain/loss download - these are the updated instructions. First, login to your account and follow the steps below:
1. Click "Manage Account" tab at bottom of the screen.
2. Click "Tax Information" box on left side.
3. Click "Launch Maxit" Box.
4. Click "Launch Maxit" Box again.
5. Select "Prior Year Realized Gain/Loss" from "Gain/Loss Reports" tab.
6. Click "View Details" on right side of window.
7. Click "Export to Excel" on right side of window and save the file to your computer.

That's it! Now you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

OptionsXpress

OptionsXpress now offers a realized gain/loss download - these are the updated instructions. First, login to your account and follow the steps below:
1. Click "Activity" from the "Account" tab.
2. Click "Tax Resources".
3. Click "Gainskeeper" Box.
4. Click "Tax Resources".
5. Click "Export Data".
6. Click "Realized/Unrealized Data" and select "Realized YYYY" for the applicable tax year.
7. Click "Get Report as Excel File" and save the file to your computer.

That's it! Now you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

Penson Financial Services

To get your data out of Penson, just follow these steps:
1. Login to your account at online.penson.com
2. Go to reports menu and click "Data Retrieval"
3. Select "Trade Transactions"
4. Select "Date Range"
5. Select Date Type "Process Day" or "Trade Day" And Select "Sort1" and "Sort2"
6. Enter the appropriate date range
7. Clikc "Go". This will produce a table of your trade data.
8. It's not clear whether there is a direct download option avaialable, but you can select and copy the table and paste it into Excel or Calc.

Note: Penson only offers a download of individual buy and sell transactions, so Excel2TXF will first try to match up the individual buy & sell trades. To ensure proper matching, make sure that any positions which carried over from previous years are included in your file (you may need to manually add them by looking at your prior year-end account statement).

That's it! Now you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

Pershing

Pershing acts as a clearing house for several brokers. You may need to contact the individual broker to get the applicable download instructions for the gain/loss report. If you have any questions, or additions to these instructions, please send us an email.

Once you get your download you're ready to run the Excel2TXF software to create the .TXF file for your tax software. Just choose the "Generic #1" option from the bottom of the broker list when running Excel2TXF.

ProFunds

Getting your data out of ProFunds is fairly straightforward. Here are the steps:
1. Login to your account and click choose "History".
2. Set the appropriate date range and choose "Search".
3. Select the Excel download format.
4. Save the file to your computer.

That's it! Now you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

Prudential

Getting your data out of Prudential is fairly straightforward. Here are the steps:
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.

That's it! Now you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

Questrade

Hera are the steps to get your data out of Questrade:
1. Login to your Questrade account by clicking on "myQuestrade".
2. Navigate to the "My Accounts" tab.
3. Click on the "Trade History" tab.
4. Choose the desired account.
5. Specify the appropriate date range.
6. Click on the "View Report" button. This will open a new tab in your browser.
7. Click on "Export to CSV" and Save the file to your computer.

Note: Questrade only offers a download of individual buy and sell transactions, so Excel2TXF will first try to match up the individual buy & sell trades. To ensure proper matching, make sure that any positions which carried over from previous years are included in your file (you may need to manually add them by looking at your prior year-end account statement).

Note: The dates will be in non-US format (D/M/Y), so if you're using a computer with US regional settings, you'll need to fix the dates by doing the following:
1. Select the "Trade Date" column by clicking in column header.
2. Select "Data -> Text to Columns..." from the Excel menu.
3. Select "Delimited" and click "Next".
4. Click "Next" again.
5. In the upper right "Column data format" select "Date" and change the setting to "DMY".
6. Click the "Finish" button.

That's it! Now you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

Rydex

Getting your data out of Rydex is pretty straightforward. Login to your account and follow the steps below:
1. Select the desired account.
2. Choose the "History" option.
3. Specify the appropriate date range.
4. Download and save the CSV file to your computer.

Note: Rydex only offers a download of individual buy and sell transactions, so Excel2TXF will first try to match up the individual buy & sell trades. To ensure proper matching, make sure that any positions which carried over from previous years are included in your file (you may need to manually add them by looking at your prior year-end account statement).

Note: After the matching is complete, delete all of the Money Market entries before continuing with the generation of the TXF file.

That's it! Now you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

Schwab

Login to your account and follow the steps below:
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.

Note: The new Schwab files contain a column (Q) with the disallowed wash sale losses. Be sure to select this column for the corresponding entry on the final user input form when running Excel2TXF.

That's it! Now you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

Scottrade

To get your trades out of Scottrade, just follow the steps below:
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/2010 to 12/31/2010) 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 Excel2TXF software to create the .TXF file for your tax software.

ShareBuilder (ING Direct)

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

That's it! Now you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

Smith Barney

Getting your data out of your Smith Barney account is very straightforward. Login to your account and follow the steps below:
1. Under the "Portfolio Menu" option, click on "Account Download". That will take you to the "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.

That's it! Now you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

SogoTrade/SogoElite

(UPDATE! You can now download your trade activity in Excel format. Historically SogoTrade only provided PDF files)

Getting your data out of your Sogotrade or SogoElite account is fairly straightforward. Login to your account and follow the steps below:
1. Click on "Statements and Confirmation" under the "Account" menu button.
2. Select "Trade History".
3. Provide the date range and click on "Go".
4. After the trade details are displayed, click on the "Download Data" icon within the "Trade Activity" band.
5. In the Export Data window, select the "Excel" option and click on "Download Now". 6. Save the file to your computer.

Note: SogoTrade only offers a download of individual buy and sell transactions, so Excel2TXF will first try to match up the individual buy & sell trades. To ensure proper matching, make sure that any positions which carried over from previous years are included in your file (you may need to manually add them by looking at your prior year-end account statement).

That's it! Now you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

Southwest Securities (SWS Group)

SWS does not currently offer any usable trade or activity downloads from their website, but an Excel file can be obtained from a portfolio manager. Just contact your portfolio manager and request your 1099-B in Excel format. With that you'll be ready to run the Excel2TXF software to create the .TXF file for your tax software.

Note: Since I don't yet have confirmation of the consistency of the provided download, you won't see SWS on the list of brokers when you run the software. Just choose the "Generic #1" option from the bottom of the broker list and everything will work just fine.

SpeedTrader

The SpeedTrader download is provided through Penson. Here are the steps for generating the download:
1. Log into your account at https://online.penson.com
2. Under the "Account Information" drop down menu choose "Trade Activity".
3. Make sure the appropriate account number is selected.
4. Input the tax year data range into the "From / To" input boxes, then click "Go".
5. Your data should display. Click on the little yellow folder with the purple arrow to export the data.
6. Select the "Excel" format, and then click "Download now".
7. Click the link that pops up and save the file to your computer.

Note: SpeedTrader only offers a download of individual buy and sell transactions, so Excel2TXF will first try to match up the individual buy & sell trades. To ensure proper matching, make sure that any positions which carried over from previous years are included in your file (you may need to manually add them by looking at your prior year-end account statement).

That's it! Now you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

SureTrader

There are a couple of download options from the SureTrader website, but they all have limitations. There is a proft & loss download, but it lacks the required dates. There is an activity download, and though it lacks a net amount column, it's the best you're going to get:
1. Log into your account and choose iBOSS.
2. Choose "Activity" and then "Trading History".
3. Select the date range.
4. Select "Download".

Unfortunately, the activity download, as noted above, is missing a net amount column, so you'll need to use an Excel formula to add one using the quanity, price, and commissions columns. Or, just purchase the Full-Service option. We have experience with the necessary adjustments, and we'll take care of everything.

Note: SureTrader only offers a download of individual buy and sell transactions, so Excel2TXF will first try to match up the individual buy & sell trades. To ensure proper matching, make sure that any positions which carried over from previous years are included in your file (you may need to manually add them by looking at your prior year-end account statement).

That's it! Now you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

TD Ameritrade

Getting your data out of TDAmeritrade is very straightforward. Just follow these steps:
1. Click on "Portfolio & Accounts" from the top menu.
2. Click on "Gain/Loss".
3. Select "Export Data".
4. Select the option to download to Excel and save the file to your computer.

That's it! Now you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

Terra Nova

First, sign in the Terra Nova Client Center and follow the steps below:
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.

That's it! Now you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

ThinkOrSwim

Getting your data out of ThinkOrSwim is very straightforward. Here are the steps:
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.

That's it! Now you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

TradeKing

Getting your data out of TradeKing is very straightforward. Here are the steps:
1. Goto Accounts -> Download Data
2. Click the checkbox for "Excel" under "Choose Format".
3. Choose "Realized Gain/Loss (Prior Year)" under the Choose Data pull-down menu
4. Click the "Download" button.

That's it! Now you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

TradeMonster

Getting your data out of TradeMonster is very straightforward. Here are the steps:
1. Login to your online tradeMONSTER account and launch the trading application.
2. From the Account menu, select "Performance".
3. Select the tab on the right labeled "Tax Data Report".
4. A window will pop up where you can select the date range.
5. Select the "Export" option.
6. Save the CSV file to your computer.

That's it! Now you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

TradeStation

First, login to your account and follow the steps below:
1. Under the "Account Services" tab, click "Balances, Positions & Activity"
2. Click "tax activity".
3. Select the date range you want. Only 6 months can be selected at a time. You will have to download 2 files and then combine them to a single file (via copying and pasting).
4. Under "Security type" select "All".
5. Under "Transaction type" select "All".
6. Under file type select "Excel" from the drop down menu
7. Click "Download", then "Save to disk", and then "OK".

Note: TradeStation only offers a download of individual buy and sell transactions, so Excel2TXF will first try to match up the individual buy & sell trades. To ensure proper matching, make sure that any positions which carried over from previous years are included in your file (you may need to manually add them by looking at your prior year-end account statement).

That's it! Now you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

UBS

First, login to UBS Online Services and follow the steps below:
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".

That's it! Now you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

Vanguard

Login to Vanguard account and follow the steps below:
1. Select the Accounts and Activity tab.
2. Near the top right of the window there is a "Download Transactions" option.
3. The site walks you through the remaining steps.
4. When you get to the end, select "Download Spreadsheet" at the bottom of the last window.
5. Save the file to your computer.

Note: Vanguard only offers a download of individual buy and sell transactions, so Excel2TXF will first try to match up the individual buy & sell trades. To ensure proper matching, make sure that any positions which carried over from previous years are included in your file (you may need to manually add them by looking at your prior year-end account statement).

That's it! Now you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

Wachovia

First, login to your account and follow the steps below:
1. Select "Account Downloads" from under "Account Services" on the left margin.
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

Note: Wachovia separates stocks and options, so if you have both, you'll need to run Excel2TXF separately on each section. Then just import both TXF files into your tax software.

That's it! Now you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

Weatherstone

It's not clear whether a download is directly available from Weatherstone, but one customer noted that he was able to get an Excel file of his Realized Gains and Losses by contacting his advisor. (If you have any updates to these instructions, please send us an email so that we can update this page)

Note: select the row of the first security name as the starting row.

Once you get your Excel file from Weatherstone, you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

Wells Fargo

Getting your data out of Wells Fargo is pretty straightforward, just login to your account and follow the steps below:
1. Under the "Brokerage Accounts" tab, select "Account Services".
2. From the series of tabs in Account Services select "Account Download".
3. Two download format options appear: Quicken and Excel. Select "Excel".
4. Choose which brokerage account you want to download from the drop down box.
5. Choose download basis: "Realized Gains/Losses - Last Year (or) This Year"
6. Click "Download".

That's it! Now you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

Note: The download lists stocks and mutual funds in separate sections which are separated by a few rows of subtotals. You'll either need to run the program separately on each section, or delete the subtotal rows in between the two sections. Also, some of the amount cells may have a 'w' subscript. You'll need to remove those first using a find & replace command to prevent numerical errors. We've also seen additional issues in some Wells Fargo files that are not compatible with the software and would require use of the full-service option.

Zecco

First, login to your account and follow the steps below:
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.

Note: Zecco only offers a download of individual buy and sell transactions, so Excel2TXF will first try to match up the individual buy & sell trades. To ensure proper matching, make sure that any positions which carried over from previous years are included in your file (you may need to manually add them by looking at your prior year-end account statement).

That's it! Now you're ready to run the Excel2TXF software to create the .TXF file for your tax software.

Zions Direct

Getting your data out of Zions Direct is fairly straightforward. Login to your account and follow the steps below:
1. Select "Portfolio" from the main toolbar.
2. Select the appropriate account.
3. In the dropdown box next to your account number, select "Previous Sales/Realized".
4. Select the appropriate year and click the "Go" button.
5. Select the option to export to excel from the right hand side of the screen.
6. Save the file to your computer.

That's it! Now you're ready to run the Excel2TXF software to create the .TXF file for your tax software.


Purchase Excel2TXF now for only$5.00See Excel2TXF purchasing options!

If you have any questions or comments, send us an email.




investotek.com
© Copyright 2006 Investotek.com. All rights reserved.
Copying any part of this website without author's permission is prohibited.