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
-
Capture/Import Data . Using
our custom browser screen log on to your broker and when on proper page
Capture Data
-
Process data. The program will
automatically reconcile your buy and sell and after your verification you
are all set
-
If you do manual reconciliation
do not forget to recalculate to reflect correct picture.
-
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