TradeAccountant®
Simply Track your Gains™

TAPro Setup and Data Import

Training Videos (Support) - Click Here
Search Knowledge Base - Click Here

Brokerage Import >> Analyze (Reconcile) >> Report >> Export to Tax Software

I. Legacy Data Import Notes

TAPro supports several import methods, including Sync Import. If you encounter any problems with data import, please pause and send us the file. We can quickly identify and fix common data issues.

Broker Setup Import Reconcile, Report and Export
TD Ameritrade Setup Import Click Here
Charles Schwab Setup Import Click Here
ChoiceTrade Setup Import Click Here
CyberTrader Setup Import Click Here
E*Trade Setup Import Click Here
Fidelity Setup Import Click Here
Interactive Brokers Setup Import Click Here
optionsXpress Setup Import Click Here
Penson Setup Import Click Here
Scottrade Setup Import Click Here
TD Waterhouse Setup Import Click Here
thinkorswim Setup Import Click Here
tradeMONSTER Setup Import Click Here
TradePortal Setup Import Click Here
TradeStation Setup Import Click Here
Other/Generic Setup Import Click Here
II. Where is my Brokerage/Accounting System

If your brokerage or accounting system is not on this list you can still import transaction history data by obtaining a file. Then use File/Import/Transaction to import the file. There are several types of files, .OFX (Quicken/Money) is an easy file to import so look for that first.

If your brokerage or accounting system offers Excel then download the file and save it as .CSV or .TXT. TAPro includes a file import wizard to help import files. Review the data and exclude items like Journal or Cash etc.. Consider changing the column headings to these names to make import easier:

date, action, quantity, symbol, price, fee, commission.

You can let TA calculate the Amount. It can also keep the Amount unchanged and recalculate Price by using other fields like Amount. It can also help to remove columns of none trade data from the file.

See the examples on this page.

III. File Import Details
Import Type Format Import Demo Comments
Basic File Import .CSV/.XLS demo See details below
Good File Import .QIF Import demo See details below
Better File Import .QFX/.OFX demo See details below
Best File Import Sync See Brokers above

TAPro includes a file import utility.  During file import TAPro remembers your decisions and creates an Import Template and file type.  During the next import of the same file type, for the same broker, you can reuse a template and apply prior decisions.  TAPro maps import field names to standard field names.  Fields that are not mapped are assigned the name "extra" and not imported. 

During import TAPro confirms symbol types (stocks, Calls, Puts etc.).  If the data includes Exercise/Assign/Expire events then also define the option's underlying details after the import (using File/Add Modify Symbols).

Here is a video with more details - click here.

Here is a list of field names that TAPro can import:

Date Transacted, Date Settled, Action, Quantity, Symbol, Description, Price, Commission, Sec. Fee, Misc. Fee, Fed. Tax, Ex./Assign Basis Adj, Basis Adj, Amount, Account, ID, Note

Below are suggestions of how to import various file types.

A. QFX/OFX Import:
Downloads to Quicken(tm)/Money(tm) often use .QFX/.OFX.  Remember to save the file with an extension of .QFX or .OFX so TAPro can identify it correctly.  Within TAPro select File/Import/File.

Here is a video with more details - click here.

B. QIF Import:
Downloads to Quicken(tm)/Money(tm) also use .QIF format.  Remember to save the file with an extension of .QIF so TAPro can identify it correctly.  Within TAPro select File/Import/File.

C. TAB Delimited Import:
Download the file in an Excel format offered.  Open the file and save the file as TAB Delimited (using Excel, File/Save As/...).  Within TAPro select File/Import/File.

If you edit the file with Excel or Notepad, consider the following simplified format:

Date Transacted, Action, Quantity, Symbol, Price, Commission
03/20/2006  Buy  100.00  CSCO  22  9.95

D. CSV Delimited Import:  
Download the file in an Excel format offered.  Open the file and save the file as Comma Delimited (using Excel, File/Save As/...). 

Here is a video of .CSV import with more details - click here.

If you edit the file with Excel or Notepad, consider the following simplified format:

Date Transacted, Action, Quantity, Symbol, Price, Commission
03/20/2006, Buy, 100.00, CSCO, 22, 9.95

Data is sometimes provided as one long quoted row that looks like the example below. 

"03/20/2006, Buy, 100.00, CSCO, 22, 9.95"

This will cause an error because the quotes at the end of the string define it as one field instead of comma separated fields.  The file does not follow the .CSV standard.  This is easily corrected with Notepad, search for " and replace it with nothing.

03/20/2006, Buy, 100.00, CSCO, 22, 9.95

Watch for commas hidden in number fields.  The example below will cause and error because the thousands separator is a comma. 

09/20/2006, Buy, 1,000.00, CSCO, 22, 9.95

In Excel, select all columns with numbers, select "Format Cells", select "Number" and remove the check mark from the "Use 1000 Separator" box, see below.


 

IV. Request Import Help

If you need help defining an import template, contact us by E-Mail: Support Site - Click Here include the data file (first remove personal info. like account number):

Disclaimer: Conversions are provided as a convenience. The TradeAccountant team accepts no responsibility for errors associated with data downloads and conversions. Please review your data with a qualified tax preparer. We welcome enhancement suggestions.