Import

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

I. Import Data From a File:

 

A. Get TAPro Ready for a .OFX File Download.

 

Also see the Customer comments at the end of this page - Click Here.

 

If you can download an .OFX file TAPro can 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.

 

  • Here is a Videos (with voice): Show Video

  • Log into your account.

  • Look for Tax Tools, Transaction History or Data Download

  • Determine the download file types supported.

  • Select an appropriate data range.  For Example to download a prior year plus additional trades:
    - Select From: 01/01/2007
    - Select To:     02/01/2008
     

 

 

C. Import the File.

 

  • The Scottrade file includes a commission field but excludes commission from the amount.  Use the following workaround (Exclude the Total and let TAPro recalculate the Total) during import -  Show Video

  • If you download a .OFX 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)

 

 

If you select an Excel file the follow the brokers instructions for downloading the file.  The TAPro import utility is flexible.  Use Excel to open the file and save it 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. 

 

 

II. Enter Data Manually:

 

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

 

 

 

III. Customer Comments:

 

Q1: "I ... am having trouble understanding how to fix an import problem (.QIF file).

!Type:Invst
D1/22' 8
NBuy
YDE
I74.91
Q13
T973.83
MScottrade Trade History
O-7
^

I have many trades for which I've been charged ~$7 (as indicated in the above extract; the "correct" Amount in this case is 980.83). TAPro always counts both $7 as commission and $7 as Fees, when it should count only one of these. How can I configure/tweak something so that the Amount is
correct ?

The "Import - Analysis (DFD) p 2 of 3" dialog doesn't allow me to separately/independently control "Commission" vs "Fees" (I can de-select "Commission" but then "Fees" is also knocked out. The "Recalculate missing ..." dialog gives no joy in this regard - I've tried all forms of recalculation..."

 

A1: Regarding the file, it seems they have introduced -ve associated with the commission "O-7".  Also (973.83) <> (13) * (74.91) + (-7).  The Total does not equal does   (Quantity * Price) +  Commission. 

 

This is a Buy so it seems the commission would add to the cost and not reduce it.  This combination of numbers is causing confusion.  We are considering accommodating this confusion but the broker might decide to improve the file.
 

Here is a work around:


1. File/Import/File
2. Create a Profile (or select a Profile and choose the edit check box)
3. In "Import - Analysis (Data Format Discovery) part 2 of 3, remove the check mark from the Amount.

Please visit this page for an example:
http://www.tradeaccountant.com/html/help/Import_QIF_Commission_not_in_total.htm

 

 

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

 

Training Videos (with voice): Click Here


Delete the Paperwork. Hit Send.

HOME | PRODUCT | SUPPORT | ABOUT USPARTNERS | LEGAL

Copyright 2008, Sync Essentials Inc.