Setup >> Import >> Analyze >> Reports >> Export to 3rd Party Tax Software

I. Enter Data Using Sync:



A. Your First Sync Download.


  • Download the current year plus enough of the prior year to find opening trades for trades currently in your account.  You can import trades in any order.  TAPro will match your closing trades using FIFO (First In, First Out).  If you add an earlier trade TAPro will automatically change the matching order unless lock the group.


    To control the date range of data import select "Sync/Change Sync Date Range" from the main menu bar.  If you import the same range again this is ok.  TAPro will recognize identical trades and save them in a file for review.


    When ready select the Account screen and select the sync button.  The reason to select the account screen is because if you are on the transactions screen then TA will also update the display periodically, which delays the import.

    To change the download date range, within TAPro use: Sync/Change Date Range




  • Consider reducing your request to the beginning of the tax year of interest.

  • For Example...
    Select Sync Range: Manual
    From: 01/01/2006
    To: today. 



  • When finished return to this menu and change the setting to Automatic.  This way TAPro will manage the "To" date.



B. Sync Download Steps.


  • Select Sync (from any of the places offered). 



  • TAPro contacts the site and waits for a response.

  • The performance of the download process depends on the time of day, the number of users accessing the broker's shared server and the speed of your internet connection.  For this reason we recommend a first download early in the tax season.

  • After the response is received, it is processed by the broker's server.  The first test is for a valid Username/Password.

  • After processing, TAPro starts a search for Cancelled Trades.  The performance of the Canceled Trades clean up depends on the total number of transactions.

  • Such trade are saved to a file. 

  • Allow the process to finish.  If you are working on something else and your system seems quiet, it might have finished and there is a buried menu waiting for your reply.  Look at the task bar.  If more than one TAPro task appears, then inspect them to see if TAPro is waiting for your reply.



II. Import Data From a File:


A. Get TAPro Ready for a File Download.


You can download an .OFX file and import it.  We recommend that your 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. 


  • 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.




B. Download the File.


  • Log into your account.

  • Navigate to Penson (look for Penson, Clearing Firm or Accounting Details).

  • Respond to any security questions that appear.  The process lands on the Penson site.

  • Select "Reports / Investment Data Download".



  • For Example to download a prior year plus additional trades:
    - Select From: 01/01/2006
    - Select To: 10/02/2007
    - Select "Download to Money" and follow the instructions.



C. Import the File.


  • A dialog similar to the following appears.



  • Select TradeAccountantPro from the dialog and follow the instructions.


  • Alternatively, if TradeAccountantPro does not appear in the list then select
    "Save to Disk".  Then open TAPro and choose File/Import/File.





D. Import and Alternative File (tab or comma delimited)



The TAPro import utility is flexible.  If you are using Excel then save the data as "tab delimited."  Then during the import process select "Tab" as the delimiter of the data.


When you start an import select the file that you want to import and TAPro will determine if it needs guidance.  If guidance is needed then follow the steps in the menus that appear.  At the beginning of the process create a new profile name or select an existing profile.  TAPro will attempt to reuse this profile for each import of the same type file to the same account in TAPro.


If there is an error in your profile you may need to select the Edit check box during the import process so you can make changes.  To remove a profile select "Import Rules/Profile Manager" from the File/Import menu. 



III. Enter Data Manually:


You can manually enter trades from the Transaction Screen by selecting the "Add" button.




Training Videos (with voice): Click Here

Delete the Paperwork. Hit Send.


Copyright 2009, Sync Essentials Inc.