Quick Links

Our main product - get your trades from your broker into your tax software!
• Excel2TXF  

A quick tutorial on using Excel2TXF -
• Quick Start Guide  

Instructions for specific brokers:
• Broker Instructions  

Frequently asked questions:
• FAQ  

Some other products to consider before you check out:
• Other Products  

Contact us about your custom macro needs!
• Custom Macros  

Excel2TXF - Frequently Asked Questions   

Below you'll find some answers to frequently asked questions. If you don't see an answer to your particular question or problem, just shoot us an email and we'll get back to you as soon as possible. 

General

1. How do I import my TXF file into TurboTax and H&R Block At Home?
2. I don't have a Paypal account. Can I still purchase the software?
3. My broker combines the quantity and symbol/description into the same column. Which columns should I select?
4. I paid via Paypal, but I didn't get redirected to the download site. How do I get my download?
5. I use OpenOffice instead of Excel. Which version do I need to purchase?
6. I purchased the software, but am having trouble with my broker's file and would prefer to change to the Full-Service option. How do I upgrade?
7. Does Excel2TXF support the new Form 8949 and 2011 Schedule D changes?

Excel Version

8. I get an error that states "compile error in hidden module".
9. I get an error that states "type mismatch".
10. I have Excel 2007 (or 2010), follwed the instructions for enabling macros in the Quick Start Guide, but I am still unable to get the macros to run.

Java Version

11. I get an error that states "Could not find the main class: ...".
12. I get an error that states "The program caught the following exception: For input string...".

---

NOTE: These instructions are for the desktop versions of TurboTax and H&R Block At Home. Currently, the online versions do not support importing TXF files. Fortunately, you can transfer your information from the online versions to the desktop versions, and you can get a discounted download of the desktop versions on Amazon that include the state return and end up paying less than the online version anyway.

TurboTax

1. Start a new return or open your existing return in TurboTax.
   
2. From the File menu, select Import and then select From Accounting Software.
3. Select Other Financial Software (TXF file) and click Continue.
4. Select the TXF file you want to import (if you don't see the file in the list, click Browse), then click Open.
5. Click Import Now (Windows) or Continue (Mac).
6. Select the information you want to import into TurboTax, and then click Import Now.
7. To check the import, from the main menu select View -> Forms, and select Schedule D from the left-side menu.

H&R Block At Home (formerly TaxCut)

1. Start a new tax return or open your existing return in H&R Block.
2. From the File menu, select Import Financial Information...
3. Select Other program (exports a .TXF file) and click Next.
4. Click Next again and then Browse to find your TXF file. Then click Import Selected File.
5. In the import summary window, leave all of the "Keep" boxes checked and click Import
6. To check the import, from the main menu select Forms -> Open Forms..., then scroll down and double-click on Schedule D.

You don't need to have a Paypal account in order to use Paypal. When you get to the Paypal checkout screen, you'll see the option to make a one-time credit card purchase. They'll of course try to get you to sign up, but it's not required.

If the quantity and symbol are combined in the same column, just leave the "Quantity Column" box empty.

After you make the payment, you should click on the orange "Complete Purchase" button on the Paypal page. This will take you to your download page. If you missed the button, no worries - you'll also get an email with the download link (If you don't get it, check your spam folder).

For the Excel version, you need to have at least Excel 2000 running on a PC. If you don't have at least Excel 2000 running on a PC, you'll need to purchase the java version, which will run on any platform. If you've already paid for the program, send us an email and we'll send you a copy of the java version, or, if you're in a hurry, just purchase the java verision and then send a request for a refund for the Excel version.

You can purchase an upgrade to the Full-Service option here. The upgrade price reflects a $5 discount for having already purchased the software.

Yes, the latest version includes a feature to deal with the three Form 8949 versions and the new 'Disallowed Loss' column (when applicable). You can purchase the latest version of Excel2TXF from the homepage.

You need to have at least Excel 2000 running on a PC. It sounds like you're either using an older version of Excel, or a Mac version. If you don't have at least Excel 2000 running on a PC, try instead our java version, which will run on any platform. If you've already paid for the program, send us an email and we'll send you a copy of the java version, or, if you're in a hurry, just purchase the java verision and then send a request for a refund for the Excel version.

If you are running Excel 2000 or newer on a PC, then there may be a problem with your Excel installation. You can run the diagnostic utility to try to fix it up:

Excel 2000, XP, 2003:

From the Help menu, select Detect and Repair. Then just follow the prompts.

Excel 2007, 2010:

Click the Office button (upper left corner) and select Excel Options. Then select Resources and click the Diagnose button. Then just follow the prompts.

Make sure that you select the row of the first trade as the Starting Row, and NOT the row of column titles. Similarly, select the row of the last trade as the Ending Row, and NOT the Total row.

If that's not the problem, then the error may mean that there is a problem with the format of one or more of your dates. Try this: select both date columns (just hold down the ctrl key and click the two column headers). Then from the main menu select "Format" -> "Cells...". In the "Number" tab, select "Custom" from the "Category" box, then type "mm/dd/yyyy" in the "Type" box and click "OK". If you still get a type mismatch error, email us your Excel file (be sure to delete any sensitive information first- account number, etc) and we'll run it through the debugger.

There are a couple of other wierd issues with Excel 2007 & 2010. Try these steps:

1. Try running the macro from the "Developer" tab rather than the "View" tab. If you don't see the developer tab, you need to click the Office button (upper left corner), select "Excel Options", click Popular, and then select the "Show Developer tab in the Ribbon" check box.
2. Excel 2007 & 2010 also have a Trusted Locations "feature" that may be the problem for you. Try copying the files into C:\Program Files\Microsoft Office\Templates and running them from there.

You are likely trying to run the JAR file from inside the zip archive. You must extract the files from the zip archive before trying to run the program. Just follow step #5 in the Quick Start Guide.

Make sure that you select the row of the first trade as the Starting Row, and NOT the row of column titles. Similarly, select the row of the last trade as the Ending Row, and NOT the Total row. If you still get an error, email us your CSV file (be sure to delete any sensitive information first- account number, etc) and we'll run it through the debugger.

Purchase Excel2TXF now for only$5.00

If you have any questions or comments, send us an email.

© Copyright 2006 Investotek.com. All rights reserved.
Copying any part of this website without author's permission is prohibited.