Import your trades from Interactive Brokers, Etrade, TradeKing, and others into TurboTax and Tax Cut!
Does your broker leave you stranded when the tax man comes calling? While a few brokers do offer seamless integration with tax preparation software, most brokers are surprisingly lacking. This includes popular brokers such as Interactive Brokers, ETrade, TradeKing, and others.
Popular tax software TurboTax & TaxCut, on the other hand, claims to be able to connect to your broker to import your capital gains transactions. However, what's not clear until you go through the process is that the cost basis for your transactions is not imported. This is because your broker is just providing information from Form 1099, which doesn't cotain the cost basis information. This means that you have to manually enter the purchase date and purchase price for all of your transactions.
Fortunately, there is a way around this situation until the brokers get their act together. While most brokers don't offer a direct TXF download, most brokers do a offer a download of your captial gains transactions in one form or another, most often in MS Excel format. Therein lies the solution! With the help of a simple, easy to use macro, your transactions will go from Excel to your tax software in a matter of minutes!
Even if your broker doesn't offer a download in Excel format, getting your data into Excel is usually not too difficult.
A free trial version of the program can be obtained here: http://www.investotek.com/ConvertExcel2TXF_Trial.xls. The trial version is the same as the full version, but is limited to converting just 2 transactions, just so you can see how it works. The full version will convert an unlimited number of transactions. Note - If you have any problems with the trial version, send me an email and I'll help you get it sorted out.
A step-by-step tutorial for using this program can be found here: http://www.investotek.com/exceltxf_help.htm.
Instructions for specific brokers can be found here: http://www.investotek.com/exceltxf_brokers.htm.
The cost for the full version is a mere $5.00, and your satisfaction is guaranteed! To purchase this program just click the Paypal "Buy Now" button below. Paypal is the payment system owned by Ebay, and is safe, secure, and easy to use. After payment is received, you will be redirected through my download service PayLoadz to a page where you can download the macro. You'll also receive a confirmation email with a link to the download page in case you're not able to complete the download immediately after paying.
If you're a little hesitant about downloading a macro from the web, or just don't want to deal with it, once you go through the payment process you can also just send me a copy of your data be sure to remove any account numbers or sensitive information and I'll run the macro for you and send you back the resulting TXF file.
Please visit http://www.investotek.com for more details.
