TradeAccountant®
Simply Track your Gains™

Frequently Asked Questions (FAQ)

Learn More! Increase your productivity

Please use the browser search function to search within this FAQ.

Return to the Main Support Page - Click Here

Reconciliation

Data Import/Export/Reports

General Info

Product Info

System Requirements

How do I reach Technical Support for TradeAccountant?
For technical support, please email us at support@tradeaccountant.com. Our technical support staff will respond to your inquiry within 24 hours. If you send a message outside of normal business hours, you will receive a response on the next business day. Our customer technical support hours are Monday through Friday, 7 a.m. to 5 p.m. PST.

back to top

How can I receive free upgrades between releases?
When you purchase TradeAccountant upgrades are free for the tax season. Periodically check the Product News page on the web site and follow the instructions on the download page.

back to top 

What do I do when I see the error "You need a newer version of HHCTRL.OCX to be able to read this file"?
When using help in TradeAccountant or during the installation and you see this error, please download the latest help system (Hhupd.exe) from Microsoft.

back to top

How do I read your Quick Start PDF file?
To view the Quick Start guide you will need Adobe Acrobat Reader.

back to top

What does TradeAccountant software do?
TradeAccountant enables active investors to manage their trade data and prepare their tax filings. It can capture and import trade data for multiple brokerage accounts, match and group trades automatically using FIFO or by lot matching, adjust for wash sale events, and report capital gains/losses in printed Schedule D format or export to tax software (TaxCut, TurboTax and other standard formats).

For more information visit the Product Detail page or the Product Datasheet**.  For a basic overview review the original product demo Demo*.  Note the screen views in the latest product are different from this original demo.

*You will need to have Flash 5 in order to view the demo.
**You will need to have Adobe Acrobat Reader to view the datasheet.

back to top

What makes TradeAccountant different?
TradeAccountant software was developed by active investors, for active investors to meet their specific needs. TradeAccountant requires minimal setup and includes "wash sale" adjustment, which many leading desktop tools do provide.

back to top

How does TradeAccountant enhance the use of Quicken and/or MS Money?
TradeAccountant is a special purpose companion for products like Quicken and MS Money. With TradeAccountant, you are able to import and automatically group thousands of trades in seconds, keep larger volumes of transactions for analysis and finish your tax P&L reporting in less time.

TradeAccountant requires minimal setup and can automatically download online brokerage data with no limit to the number of transactions. Wash Sale adjustment feature is included. You can also print in IRS Schedule D format report for attachment to tax return, export to your tax software or if your CPA does your taxes, it's compatible with select professional tax software like ProSeries and TaxWise.

back to top 

Does TradeAccountant download trade data directly from brokers?
Yes. TradeAccountant supports direct download* from selected on-line broker via TradeAccountant's one-click sync feature. Refer to the broker list for a listing of supported brokers.

*Downloaded data may require some editing (i.e. commission column, stock symbol vs. name, etc. We are working independently with brokers to improve the results).

back to top

How can I control the Sync Date Range?
You can control the date range of data requested by selecting "Sync/Change Sync Date Range" from the main menu bar.  This is helpful when you only want last years data and not several years of data. 

 

 

 

Select an appropriate Sync Range:

 

Manual Sync Date Range:

During tax season when servers are busy or if you have more than "1,000" trades you might consider selecting a narrow range (for example the prior year).  If you select sync twice for the same date range TA will save duplicate trades (trades that have already been imported) to a file for your review.

 

Automatic Sync Date Range: 

After the bulk of data has been imported then change the setting to Automatic so that TA can manage the date range.  Each time you select "Sync" TA will request trades from the last sync request until the current date.  This is why you may want to avoid starting with Automatic for your first sync.  If you start with Automatic mode then TA will request several years of data during the first request.  This could be too much data and cause the server to time out.

 

If sync is not successful TA will display a message indicating why sync was not successful. 

 

If you encounter a timeout then reduce the date range using the steps above.

 

If you receive a Username/Password error then return to the Accounts screen and select the Modify button.  Review your settings. 

 

If you still are not successful, please send email to support@tradeaccountant.com and indicate the content of the error message.

back to top

Which brokers can I download from?
Refer to the broker list. We periodically update this list with new information.

*Compatibility claims are based on testing by Sync Essentials, Inc. and are not necessarily endorsed by listed online brokers.

back to top

Can I use TradeAccountant to produce a Schedule D or 4797 attachment?
Yes. TradeAccountant allows you to print directly in IRS format, export to a leading tax software (including TaxCut and TurboTax), or save in a standard file format for your CPA.

back to top

Is there a web demo for the TradeAccountant Product?
Yes. The demo and videos are on the Support page, however, they are of an older version of TradeAccountant. Some of the new features in the current version are not presented in the demo. We recommend downloading the latest version from the web site and using it in trial mode to learn about the features.back to top

What is Baseline Data?
A new account starts with no trade history. When you first start using a tax lot accounting solution like TAPro, it is necessary to establish a starting point for trade data.   We refer to this as a baseline.  Keep in mind this is necessary for any similar solution.

After your first import TAPro will look for the first Buy or Short Sale and match the Buy with the first Sale or the Short Sale with the first Buy to Cover. Ungrouped Sales indicate that trades are missing.  Sales always have opening trades (Buys) and Buys to Cover always have opening trades (Short Sales).

The basic idea is to import all of your trades for the tax year and then look at the Groups Screen with Display View: Not Grouped All. You will notice that as you enter the missing trades the Not Grouped quantity decreases.

You can manually add trades by selecting Edit/Transaction(s) — Add Modify.

back to top

How do I manually enter or edit trades?
Select Edit/Transaction(s) — Add Modify dialog.

There is also a calculator built into this dialog. Notice the (*) symbol. This indicates the field that is recalculated by using the other data to calculate the value of the field distinguished by (*). You can select the recalculated field by clicking on the icon for () until it changes into (*). We can use this to adjust a trade for Corporate Action or Corporate Events. Let’s assume a position was split 2 into 3 on 02/01/2008. Here is the process:

Date, Action, Quantity, Symbol, Price, Total
01/01/2008, Buy, 1000, XYZ, 5, 5000

If the quantity is 1000 on the date of the 2 into 3 corporate action, then do the following.

1. The Total Amount will remain the same but the Quantity is user edited and Price is recalculated.
2. New Quantity = Old Quantity * Corporate Action = 1000 * (3/2) = 1500
3. Enter 1500 as the quantity.
4. Select (*) above the price field.
5. Select Recalculate.

back to top

The tax report does not match my 1099.
Tax reports show what TA was able to automatically match into groups using FIFO.  Trades that it can't group are referred to as Not Grouped and appear in the Groups screen with one of the Display View: Not Grouped filters selected.

Select Tools/Reconcile Gain/Loss.  Take a look at the summary to see where problem remain. 

After importing data you may discover that all of the trades don't appear in the tax report. This is because the data was not in the file or in the Sync download or there are some errors in the data. This is why there are so many tools in TAPro, to fix these issues.

Here is what is needed. If there is an opening (buy) and closing (sale) trade in the same account for the same symbol and the opening is before the closing then TAPro will group them and they will appear in a Tax Report. Maybe prior year opening trades are missing.  In this case use Edit/Transactions Add Modify to add the missing trades.

To see the Not Grouped trades, look at the Groups screen.

Display Mode: All Symbols
Display View: Not Grouped

Take a look at one of the Not Grouped trades in the "Transactions" screen with the filters set to:

Display Mode: By Symbol
Display View: Positions

This view will show history for one symbol. This view provides insight regarding the underlying issues. You can enter trades in any order and you can apply views and sorts without changing the data. You can edit any trade from the Transaction Screen. You can also save a copy of the data, experiment then restore the saved version. TAPro is very flexible. To resolve not grouped trades try one of the following:

1. If there is a missing opening trade, find the missing trade by looking at your statement or on-line account and manually added it to the Transaction Screen by clicking Add.
2. If there is a Sale before a Buy there may be an undiscovered Short Sale. Use Tools/Long/Short Sale Discovery to fix this.
3. If you trade options you may find that closing trades are missing. This is because the file didn’t contain an Exercise, Assign or Expire trade to close the options. Visit Tools/Options for a list of tools to help with this either one at a time or in bulk.

back to top

Corporate Actions — Where are the new positions?
With TAPro 3.5 corporate action results are calculated and appear correct in the Tax Report view and the Transaction Screen View = Position and Corporate Events.  This solution is flexible but it does not actually create new positions.

The affect is the Reconciliation utility and manual groups utility sees the actual positions and not the calculated positions.  This becomes an issue if there is a need for a secondary action like manual group, exercise/assign/expire.  This also creates an issue with the Reconcile Gain/Loss calculations for "Reconcile Account."  In this case it is better to have real positions.

This is a work around to apply a Corporate Events:

1. Use File/Save As to create a backup copy.

2. Select the Transaction Screen and set the Display View: By Symbol

3. Select the desired symbol from the left column. This will now display the selected symbol

4. Select a position in the list and select Modify. For example choose a position that is held before the Corporate Event data.

5. Click on the () next to the word Unit Price(): so it changes into Unit Price(*).

6. Adjust the Quantity for the desired event.  For example if it is a 1 into 2 split then change the quantity by x2.

7. Select Modify. Notice that by choosing to recalculate the Unit Price(*), TA used the other date to calculate a new price by keeping the Amount unchanged.

9. Repeat this for each position.

If a position is partially sold before the corporate action then change the quantity of the existing trade to match the quantity sold and add a new trade with the adjusted quantity and price. 

Here is an example before the corporate action is applied, there is an ungrouped quantity of 500.

Date, Action, Quantity, Symbol, Price, Total
01/01/2008, Buy, 1000, XYZ, 5, 5000
01/15/2008, Sell, 500, XYZ, 7, 3500
02/15/2008, Sell, 1000, XYZ, 6, 6000

Here is an example after a corporate action is applied (02/01/2008 split 1 into 2).  Notice the opening trade was split into two trades.  Also notice the second part of the trade reflects the new quantity and price.

Date, Action, Quantity, Symbol, Price, Total
01/01/2008, Buy, 500, XYZ, 5, 2500
01/01/2008, Buy, 500, XYZ, 5, 2500
01/15/2008, Sell, 500, XYZ, 7, 3500
(02/01/2008 split 1 into 2)
02/01/2008, Buy, 1000, XYZ, 2.5, 2500
02/15/2008, Sell, 1000, XYZ, 6, 6000

back to top

Reconcile Gain/Loss — Can't get all lights green?
Reconcile Gain/Loss includes tools to assist with finding data errors.  Select Tools/Reconcile Gain/Loss.  Select Continue. 

However there is a side affect in 3.5 associated with Corporate Actions.  Please keep in mind that the dialog does not account for Corporate Actions.  For more details see the explanation above.  This means that the color for Reconcile Account could remain Red.

In the Reconcile Gain/Loss tool on the Reconciled Tab — Accounts, the calculation is based on what TA has tabulated and what the user has provided in the column labeled "Current."  Use the features in this dialog to either set default values, import values from your broker or manually enter "Current" values by clicking on that field.

back to top

Reconcile Gain/Loss — Short Sales & 1099 Total?
Reconcile Gain/Loss includes tools to assist with analysis of your tax report total.  Select Tools/Reconcile Gain/Loss, Continue.  Select Tab 7 "Gain/Loss Rpt."

This summary indicates if there are Short Sales affecting your tax report total.  Keep in mind that TA will show a total for all sales closed in the period selected.

back to top

Reconcile — Balances one day at a time?
TAPro recalculates report totals based on filter settings.  For example if you change the Date Range Type into "From & To Date" then you can narrow the focus of what is presented.  Notice that if you click on the day within the To Date field "01/01/2008" you can use the up/down keyboard arrows to scroll through a date range and watch the totals change.

When changing months make sure the click the drop down to ensure that refresh has been applied.

back to top

What's the minimum system requirement for TradeAccountant?
In order to use TradeAccountant, you will need to meet the following system requirements:

  • Windows 98/98se/NT4/ME/2000
  • Microsoft Internet Explorer 5.0 or higher
  • Pentium 300 MHz (recommended)
  • 64MB RAM
  • Hard disk with a minimum of 300mb free space
  • SVGA video card supporting 800 x 600, 256 colors or greater
  • Windows compatible mouse
  • Windows compatible printer
  • Internet access

back to top

Is TradeAccountant Mac compatible?
No. Currently, TradeAccountant is only available for PC users.

back to top

Will TradeAccountant work with Windows XP?
Yes, TradeAccountant works with Windows XP.

back to top

Will TradeAccountant work with Windows Vista and Windows 7?
Yes, TradeAccountant works with Windows Vista and Windows 7. Install it as a legacy application.

With the introduction of Vista, Microsoft® changed the permission level required for installing and launching software. The following steps are a side affect of this change. If you have Vista or Windows 7, follow these steps to adjust your computer's settings.

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:

Note: When installing Internet Explorer 5, please choose to perform a "typical" install.

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.

Note: This export will use version 39 of the TXF (Tax Exchange Format). With wash-sale adjustments turned on, import of the TXF file into ProSeries will activate the wash-sale flag.

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