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