Using Tax Data Utility

Contents

Overview

Importing Data

Capturing Data

Processing data

Exporting Data

TIPS

Overview

Tax Data allows you to import and capture data from many sources.

Here are few simple activities you need to perform to get your tax for Stock Related activities can be done in record time

1. Capture/Import Data . Using our custom browser screen log on to your broker and when on proper page Capture Data
2. Process data. The program will automatically reconcile your buy and sell and after your verification you are all set
3. If you do manual reconciliation do not forget to recalculate to reflect correct picture.
4. Export in Tax Format for use in you Favorite software.

Back to top

Importing Data

Tax Data allows you to import data from popular financial programs like Microsoft Money. To do that export Tax Data from those programs in Tax Format and supply the file when prompted once you click File Import.

Data imported like this will be stored in a common account. You will be able to see the data by clicking the account and Tax option button on main screen.

Back to top

Capturing Data

DATEK ONLINE

Datek is one of the most customer friendly site. To import data from Datek. Do following:

- On main screen click Capture button.
- On Capture screen Select account type DATEK.
- Click Open.
- Logon and go to review past history screen.
- Click Capture Data Button

E*Trade Securities

E*Trade Seciurities provides some tax data. To import data from Wit Capital. Do following.

- On Main screen Click Capture Button.
- On Capture screen Select Account Type E*Tarde.
- Click Open.
- Logon and go to Account Services.
- Click Tax Records
- Click 1999 Con link
- Click Capture Data Button

02/23/2000 - We programmed to use 1999 consolidated form so no known issues are there

Wit Capital
Wit Capital provides some tax data. To import data from Wit Capital. Do following.

- On Main screen Click Capture Button.
- On Capture screen Select Account Type Wit Capital.
- Click Paste Data. This will show an text area where Wit transaction history has to copied with header. (Wit screen has mix of secured and ubsecured data mix which does not allow TaxData utility to capture data)
- Paste data in the text area
- Click Capture Data button.

To Get proper Data from Wit

- Go to Tarde History.
- Enter proper date range.
- Select the tabulated data with header and press CTRL-C together . Wit does not display all data in given range, it terminates after display certain number of transaction. So make sure you enter new range and get all data.

Once you have tax data in clipboard by selecting and pressing CTRL-C keys, go to Tax Data utility and press CTRL-V to paste data on the screen's text Area. Wit Capital data provided has following issues:
The Buy and sell price is calculated from the buy price, sell price . There is no way to know commission so currently we have assumed that you are with Wit Capital mainly for IPO, so commission is subtracted from sell price but not in Buy. Please correct manually.

FBR.COM

FBR is also quite customer friendly site. To import data from FBR do following:

- On main screen click Capture button.
- On Capture screen Select account type FBR.
- Click Open.
- Logon and go to Account History.
- Click on 18 month History Button.
- Click Capture Data Button

Other Sources- EXCEL
If you have data in excel sheet it can be easily used.

To be able to use data it need to have five columns of Data
Date, Symbol, Quantity, Amount, Type,

Other Sources provides some tax data. To import data from Other Sources. Do following.

- On Main screen Click Capture Button.
- On Capture screen Select account type Other .
- Enter file name or click browse button. Find the excel file and click open.
- Back on Capture screen click Open.
- Click Capture Data Button.

Back to top

Contact Information

ExposoftInc on Yahoo

> Exposoft@exposoftinc.com

> Web address:
> http://www.exposoftinc.com/taxdata

> Office phone
> (435) 330 8827

Back to top

Current Issues

Back to top

Last Revised:

Buy TAXDATA Utility

Main