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. 

OptionsFirst (by Scottrade)
OptionsHouse
OptionsXpress
Penson Financial Services
ProFunds
Prudential
Rydex
Schwab
Scottrade
ShareBuilder (ING Direct)
Smith Barney
SogoTrade/SogoElite
TDAmeritrade
Terra Nova
ThinkOrSwim
TradeKing
TradeMonster
TradeStation
UBS
Wachovia
Weatherstone
Wells Fargo
Zecco


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 Americfa

I don't yet have the details for generating the download, but it should be farily straightforward (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

I don't yet have the details for generating the download, but it should be farily straightforward. 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.

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 account 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.

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.

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.

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.

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! IB now offers a direct TXF download. However, I've received multiple reports that the TXF file is missing the wash sale entries. In that case, you can just download to Excel and then use the Excel2TXF software to generate a new TXF file which will include the wash sale entries.)

IB's 'Schedule D' tax report is very easy to use. 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.

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 Quick Start Guide).


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

IZone by TDAmeritrade

I don't yet have the details for generating the download, but it should be farily straightforward. (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 (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 "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 Excel2TXF software to create the .TXF file for your tax software.

Morgan Stanley

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.

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

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

Note: OptionsHouse 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.

OptionsXpress

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: OptionsXpress 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.

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.

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.

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.

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! A few customers have reported that they were able to get an Excel file with their trades by contacting SogoTrade directly and requesting it. That will save you the hassle of following the steps listed below. Once you obtain the Excel file, just run the Excel2TXF software to generate your TXF file.)

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 us 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:
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.
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).

Note: SogoTrade/SogoElite statements only show 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.

However, if you are an active trader, you may consider just downloading to Excel, and then using Excel2TXF to consolidate and clean up your trades.

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 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 "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.

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.

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.


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.