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 Etrade, Interactive Brokers, IZone, OptionsXpress, TradeKing, TradeStation, 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 contain 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. 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. 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.
Instructions for specific brokers can be found here.
Answers to some frequently asked questions can be found here.
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.
Mac user? OpenOffice user? Don't have at least Excel 2000? Try instead our stand-alone java executable ConvertCSV2TXF.
Before you checkout, consider adding on one of my other macros to further streamline your tax preparation. You can find a listing of my other products here.
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.
If you have any questions or comments, send me an email.
"This is a nice little utility for a nice little price. I used it to create a txf file of 72 capital gain transactions to import into TurboTax and it worked perfectly." -- S. Carruthers
"Great product you have!! Best $5 I've spent in a long time. Perhaps since I was about 9." -- J. Barrett
"Performs exactly as described and is as easy to use as can be. A real time saver. Once run, the trades are processed in a flash and the seamless import into turbotax was just as quick. Thanks!" -- D. Chen
"Thank you, that program is great, it was a lifesave, I am a cpa and it helped me out greatly." -- A. Mudryk
"This is a great tool, especially for the price and literally saved me hours of manual data entry." -- B. Rudich
"Excellent - it's done already ! Great macro...thanks!" -- G. Chernosky
"Great job and wonderful service!" -- B. Chen
"You are my hero! What took me hours to do the last several years was now done during a commercial. Thank you for the Excel to TFX macro!" -- R. Gustafson
"THANKS a lot!!!! I really love the utility. It literally saved hours and hours of data entry time! Your excel macro has the maximum utility value for the cheap $5.00 and it is worth every penny. Thanks again." -- M. Ganesan