After downloading the TAPro installation file, hover over the TAPro filename and select Right-Mouse, Properties. Then select the Compatibility Tab. Then select "Run in compatibility mode"..

After launching, accept the "publisher not recognized warning".

If the message "unable to initialize the database" occurs when TAPro is launched, then follow these steps:

1) Right-Mouse click on the TAPro desktop icon
2) Select Properties
3) Select the Compatibility tab
4) Check the box for Privilege Level ... Run this program as Administrator)

back to top

Do I need Internet Explorer to run TradeAccountant?
Our product requires that you have Microsoft Internet Explorer 5.0 or higher. If you do not have it or need a later version, click here to install Microsoft Internet Explorer:

back to top 

Is TradeAccountant compatible with other tax software?
Yes. TradeAccountant is currently compatible with leading consumer tax software's including TaxCut, TurboTax and other standard formats. If your CPA does your taxes, TradeAccountant is compatible with TaxWise.

back to top

How many transactions can I store in TradeAccountant?
There is no limit.  However reporting is limited to the current tax season plus 1/1 — 8/31 of the subsequent year. 

back to top

How do I setup an account in TradeAccountant?
Select the Accounts Screen then select Add.  For more information select the hyperlink labeled "Click here".

Account Properties Dialog Box

back to top

How do I download broker data into TradeAccountant?
In general, the process for downloading your broker data is as follows:

1. Launch the TradeAccountant application.
2. Create an account in TradeAccountant for each brokerage account.
3. Use the "sync" toolbar button to download data from your broker. (If TradeAccountant supports one-click sync download for your broker).
4. If Sync download is not supported or if addition data is needed then download a data file from your broker.  See the supported brokers page for details.  Brokers Supported - Click Here
5. Use TradeAccountant's "File/Import" menu to import data. 

back to top

How do I match trades to determine gains/losses?
TradeAccountant enables you to automatically match thousands of trades in seconds using FIFO or by matching specific lots manually. For detailed information about how to match trades, please refer to the Page Description help link on the Groups Screen.

back to top

How do I import .QIF data?

Review the Import instructions for a basic overview - Click Here.  During import TA will analyze the data and offer to recalculate fields if the (Quantity x Price) + Commission <> Total Amount.  In case the file contains a Commission but it is not in the Amount then this can cause confusion.  In this case, during import, exclude the Total Amount and allow TA to recalculate a Total.  For an example — Click Here.

back to top

How do I prevent automatic QIF capturing by MS Money?
If you can download a .QIF, .QFX or .OFX file then TAPro can import it.  First setup TAPro so it is ready to receive the file.  Otherwise you will need to save the file and then load it from within TAPro.  If the file is captured by Quicken or Money this setup setup will enable you to save the file.

• Within TAPro, select "View/Properties"

• Within TAPro, select "Associated File Types"

• Select the check boxes for "Import .QIF, QFX and OFX", this enables TAPro to directly receive the file during the download process.

• Select "OK"

• Leave TAPro open so it can receive the file download.

• If the file is still captured by Quicken or Money then - Click Here

back to top

How do I Manually Associate File Types with TAPro?
The Associate File Types feature seeks to modify settings in windows to create an association between files with the Extensions that appear in the list and TAPro.  However if a security setting prevents this it may be necessary to manually create this association using tools of the operating system.  Below is an example of how to do this in Windows XP.  Other OS versions are similar so check the help system of your OS for more details.

Select Folder Options from within any folder:

Select a file type of interest from the list of file types:

In the example above, ".QIF" is selected.  Follow the instructions within the dialog to apply a change.  In this case "Change" was selected to associated .QIF with TAPro.  After this association is complete then when you click on a .QIF file type then TAPro will attempt to load the file.  Also when you are downloading a .QIF file TAPro will attempt to import it.

back to top

How do I enable Windows Security to access a web site?
When accessing web sites (for example to download from a broker) it may become necessary to add a new broker website to your list of allowed sites.  If you have security software that controls site access then follow those instructions. 

Also follow these steps to allow Internet Explorer to access desired sites.

These instructions are written for Internet Explorer:
1. Open your Web Browser (Internet Explorer).
2. Select Tools (if you have version 7 you may need to select the ALT key for the menu to appear).
3. Select Internet Options.
4. The following dialog appears, select Trusted Sites, click the Sites button and follow the details.

back to top

My trades on the same day have the same time, what should I do?
This is a data error. Time is used to sequence the order that TAPro will FIFO match the trades starting with the first trades. TAPro uses the time provided with the data.

In version 3.6, select Tools/Smart Time to fix this.

In older versions of TAPro, the work around is to import the data without time and allow TAPro to create a time based on the order the data appears in the file. After selecting File/Save As Backup, try the following.

1. Export the data from TAPro. Use File/Export/Transaction History.
2. Make sure to select a range large enough to include all data.
3. Open the file in Excel.
4. You may need to change the Import Dialog to File Types: All Files (*.*) to see the .csv file created by TAPro.
5. Within Excel you will see Date information similar to: Date Transacted: 2/15/2008 9:00:00 AM
6. Assuming Date Transacted is the first column, click on the column heading for A.
7. Select Format/Cell.
8. From the dialog choose Category: Date
9 Select Type: *3/14/2001, which means a format of MM/DD/YYYY without time and it is the default *.
10. After selecting OK you will notice the time has been removed. Repeat these steps for column B (Date Settled).
11. You may want to look at the date and make any sort order changes required.
12. When finished select File/Save As.
13. Because this is a TAPro format file select Save as Type: CSV (Comma delimited) (*.csv).
14. In TAPro create a new account.
15. Import the data using File/Import/File.

To clean up you may want to delete the old account to avoid the two accounts causing wash sales with each other.

back to top

I have ungrouped trades, what does this mean?
Also see Baseline Data and see Corporate Actions. When trades are imported into TAPro, Buys are grouped with Sales if the Buy date and time are before the Sales date and time. Short Sales are grouped with Buys to Cover. Day and time are used to determine the order that TAPro creates Tax Lot groups.

TAPro accepts the time provided in the data file. But there are some work abounds (see same time). In general ungrouped trades are caused by missing baseline information. Add the missing trades and TAPro will recalculate the groups. Look in the Groups Screen, Display View: Not Grouped All.

In some cases the missing opening trade is caused by a missing Corporate Action, like a split. You can manually add this as a trade by selecting Edit/Transaction(s) — Add Modify. Another helpful view is Screen: Transactions, Mode: By Symbol, Display View: Positions & Corporate Events.

In a few rare cases the time the Sale is before the time of the Buy. Sometimes this is cause by differences in time on clearing firm servers. Most often this is caused by undeclared short sales. After making sure no trades are missing then use Tools/Short Long Discovery. See the support page for a video.

Example:

Let’s assume the following data (we will leave out some of the detail like price and amount):

Ref. #, Date Time, Action, Quantity
1, 12/15/2006 3:00, Buy, 200
2, 01/15/2007 3:00, Buy, 100
3, 02/15/2007 3:00, Sale, 300
4, 03/15/2007 3:00, Buy, 100
5, 03/15/2007 2:59, Sale, 100

Let’s assume you imported data for 01/01/2007 — 12/31/2007. This means TAPro will have the following data because the first trade is missing.

2, 01/15/2007 3:00, Buy, 100
3, 02/15/2007 3:00, Sale, 300
4, 03/15/2007 3:00, Buy, 100
5, 03/15/2007 2:59, Sale, 100

When TAPro applies FIFO the following are the results:

This appears in Tax Report as one line containing the follow trades:
2, 01/15/2007 3:00, Buy, 100
3, 02/15/2007 3:00, Sale, 100 of 300

This appears in the Groups Screen, Display View: Note Group All:

3, 02/15/2007 3:00, Sale, 200 of 300
4, 03/15/2007 3:00, Buy, 100
5, 03/15/2007 2:59, Sale, 100

Notice that by missing trade 1 that the trade 3 was only able to group quantity 100. We refer to trade 1 as missing baseline information. Then TAPro calculates short long discover it assume all the necessary trades have been added. This is why is raises the Reconciliation question (this account has not been reconciled). If you proceed then the suggestions will not be correct.

Please note, during if a trade goes short to long or long to short in one trade then the Sequence Error Discovery tool will suggest splitting one trade into two different trades equaling the same original quantity and price.

Also notice that trades 4 and 5 will not group until the time of one is adjusted so the Sale is after the Buy or the Buy is changed into a Buy to Cover and the Sale is changed to Short Sale. Select Edit/Transaction(s) — Add Modify.

back to top

I changed brokers, how do I reconcile my accounts?
When an account is closed at broker A and opened at broker B you will receive a 1099 from each broker and will need to reconcile both accounts.

Reconcile broker A.
1. Create two accounts within TAPro.
2. Import your data for broker A into account 1. If you had open positions when the account was transferred then you will see Journal out trades.
3. Reconcile the trades in account 1 so they agree with your 1099.
4. The ungrouped Buys at broker A were likely moved to broker B.

Reconcile broker B.
1. Use Edit/Transaction(s) — Move to Account and select the open trades from account 1. Move them into account 2.
2. Import data from broker B into account 2.
3. You should now have your baseline in account 2 plus your trade activity for the year in focus.
4. Reconcile the trades in account 2 so they agree with your 1099.

back to top

There was an error while importing your file!
.CSV and other flat files are the most challenging to import because they very so much.  We recommending searching the brokers site for a Quicken/Money file (.QIF or .QFX of .OFX). 

Some .CSV file have commas within the data like as a thousands separator.  Other files have an incorrect date format.  We have also corrected files with data errors.  Here are a few tips for importing a file.

This file will not import because the heading has quotes.
"Date","Action","Symbol","Cusip","Description","Quantity","Price","Commission","Amount"
05/14/07,"Buy to Open","NHY",656531605,"NORSK HYDRO A/S SPONSORED ADR",58,34.12,6.95,1985.91

To clean up most files we follow these steps:
1. Open the file with Excel.
2. Select File/Save As
3. In the Save As dialog look for "Save as type:"
4. Choose the type "Text (Tab delimited) (*.txt) and save the file.
5. You may see a warning "... may contain features that are not compatible with Text (Tab delimited).  Select "Yes" and save the file.
6. Use TA to import the file.  During the import, part 2 of 4, select "Tab" as the Separator.
7. If you spend more than a few minutes on this please send the file to support@tradeaccountant.com and confirm the broker you received the file from.  We will convert it and return it to you.

By the way, TAPro imports transaction data on separate rows.  This means that a summary gain/loss report with buys and sells on the same row is not designed for import into TAPro unless we have provided a custom import.

back to top

How do I import data from Excel or .CSV?
TradeAccountant includes a powerful import wizard.  Select File/Import then follow the steps on each screen.  Here is a page with more details — Click Here

(click on the image to view the sample data file)

There are many additional columns of data that you can include in the file.  During the import process you will have an opportunity to move column headings and to exclude rows of data.  You will also have an opportunity to reassign the Action names.  For example TA 3.0 uses the term Action to describe the column that contains Buy or Sale etc.

This is an example of the screen used for selecting a name to associate with a column heading.  Notice the optional column include a check box for selection or deselecting.

If you are having trouble importing your CSV files into TradeAccountant, you may contact our support at Support@TradeAccountant.com for assistance.  Send the file by email and indicate the problem.

During import TA will analyze the data and offer to recalculate fields if the (Quantity x Price) + Commission <> Total Amount.  In case the file contains a Commission but it is not in the Amount then this can cause confusion.  In this case, during import, exclude the Total Amount and allow TA to recalculate a Total.  Here is an example with a .QIF file - Click Here.

back to top

How do I import data from Open Office Calc?
Q1: "... I have been trying to import a CSV file for 5 hours and I keep getting an import error. ("There was an error importing your file. This occurs if the file does not match the settings of the import profile."). The data looks clean. I tried everything I could think of but now I have reached my limit.

There is no profile so I am just putting in a name for a new profile.

Can you please take a look? I attach the file I tried to import.

Thanks a million.
Wishing you a beautiful week"

A1: The " is causing problems.  It seems the file includes quotes in the heading and may not conform to a standard .CSV file format.  Unfortunately .CSV file have many variables and some are not obvious.

 Here is a work around.

1. Import the file in Excel.
2. Save at type tab separated.
3. Import in TAPro.

PS1: "... I have been using Open Office Calc instead of Excel, and I wonder if the " problem in the CSV was caused by Calc. Calc does not save as Tab separated so I will install Excel.

You've been most helpful, hoping life is good to you where you are."

back to top

How do I import data from a brokerage website?
For select brokerages you may capture transaction data from your brokerage website and use the TradeAccountant Conversion Gateway Utility to convert the captured data into a TradeAccountant compatible import file. You can use this file to import captured transaction data into TradeAccountant. Please note that we are phasing this solution out and will rely on better support from brokers for file import.

Please refer to the help pages in the TradeAccountant Conversion Gateway for broker specific instructions on obtaining your transaction history data.

back to top

How do I export to TaxCut?
TradeAccountant allows you to export data to TaxCut by taking the following steps:

1. From the File menu, select Export/Export to Tax Software.
2. Select TaxCut for the file type to Save As.
3. Fill in the required information.
4. Use your tax software to import the file.

The export will create a Tax Exchange Format file (TXF) used by tax preparation software. Exporting your data to a TXF file eliminates the need to re-enter data into your tax software.

back to top

Why does TurboTax Fail the Final Audit?
[Customer]: I can create and successfully create a TXF for Sched D and successfully import into TurboTax. However the final audit on TurboTax fails because the wash adj entry has cost amount that is less than zero. The audit says that cost can not be less than zero. Are others running into the same problem? Is this a bug? Any workaround?

[Support]: Yes. In most cases this is resolved by reviewing the export selection found under File/Export/To Tax Software. We offer .txf files in every flavor needed. Confirm that you selected TurboTax as the export. Tax software may have a variety of different needs. The other exports offer different approaches to wash sales like adjusting the Sale.

How can I import 4797 Data into TurboTax?
[Customer]: I have two accounts. Both are set up as Trader (4797) accounts. I exported my TradeAccountant information with the following settings:

1. File Name: Trader
2. Save As Type: Turbo Tax (TXF)
3. User Account: All Accounts (also tried individually)
4. Report: Form 4797
5. Range Type: Year & Tax Period
6. Year: 2005 Period: All

TurboTax reports that "No information exists for Other Financial Software (TXF file) Trader"  I changed both accounts to Investor (Schedule D) and exported the files individually. TurboTax accepted both files. The trader versions are smaller, but they clearly are not empty:

Broker 1, Broker 2, All
Investor 25KB 233KB 353KB
Trader 20KB 213KB 233KB

I am filing as a Trader, not an Investor! How do I transfer TA information to TurboTax as Form 4797?

[Support]: We have only used the .txf tags for Schedule D with success; we don't have an example of correct usage with form 4797. The Intuit site discusses import of Schedule D but reference to 4797 points to their spec. We are not aware of the process for getting 4797 data into TurboTax.

back to top

How do I export to TurboTax?
TradeAccountant allows you to export data to TurboTax by taking the following steps:

1. From the File menu, select Export/Export to Tax Software
2. Select TurboTax for the file type to Save As.
3. Fill in the required information.
4. Use your tax software to import the file.

The export will create a Tax Exchange Format file (TXF) that can be used by TurboTax. Exporting your data to a TXF file eliminates the need to re-enter data into TurboTax.

back to top

How do I export to TaxWise?
TradeAccountant allows you to export data to your TaxWise application by taking the following steps:

1. From the File menu, select Export/Export to Tax Software
2. Select "TaxWise" file type.
3. Select an user account in your TradeAccountant.
4. Select a date range type.
5. Select a tax year.
6. Click on Save to save the file.
7. Browse for a folder in the TaxWise home directory identified with your tax year; e.g. UTS03\Proforma for TaxWise 2003 version. Copy your new file into the selected folder.
8. Rename the file using the social security number (SSN) of the taxpayer. For example, if a SSN is 123-45-6789, then the file name is JE123456.789.
   Note: All file names must begin with JE and there is a period before the last three digits of the SSN; i.e. JExxxxxx.xxx

9. Open your TaxWise program and select File, Start a New Tax Return.
10. After entering the SSN, the file name will auto-fill and you will be presented a Confirm screen.
11. When you are asked "Carry forward data exists. Load it?", click Yes and OK on the first screen. The data will import into the Schedule D worksheet.

back to top

How do I export to ProSeries?
TradeAccountant allows you to export data to ProSeries by taking the following steps:

1. From the File menu, select Export/Export to Tax Software
2. Select "TurboTax (TXF Format)" file type.
3. Select an user account in your TradeAccountant.
4. Select a date range type.
5. Select a tax year.
6. Click on Save to proceed.

The export will create a Tax Exchange Format file (TXF) that can be used by ProSeries.

back to top

How do I export to Excel?
TradeAccountant allows you to export data into CSV format (readable by Excel) by taking the following steps:

1. From the File menu, select Export/Transaction History
2. Select "Excel File" file type.
3. Select an user account in your TradeAccountant.
4. Select a date range type.
5. Select a tax year.
6. Click on Save to save the file.

back to top

Does it support the IRS e-file process?
Yes. TradeAccountant helps make the front-end process easier by importing, organizing, matching and exporting data electronically. TradeAccountant Office is a recognized partner with the IRS e-file to make the e-filing process easier for investors.

back to top

How can I generate a .PDF of my schedule D?
To generate a .PDF from your tax report install CutePDF Writer (tm) then you can print a .PDF from your standard print menu.

Click Here

back to top

What types of IRS formats does it support?
TradeAccountant Office can print out IRS Schedule D format for attachment with paper filing.

back to top