Importing Transactions isn't working from brokersXpress

[Chandeleur]

I've tried to download transactions via .qif files and excel from brokersXpress. I am trying to download transactions into an account that used to be with Fidelity. When I click "File, Import, Transcations, .QIF..." then get to the "Previewing Importing Transactions" page, nothing appears. I've tried various changes, but nothing is working for me.

[Mark]

Hi Chandeleur,

If you look in your QIF file with a text editor (like Notepad), do you see your transactions?

What import settings are you using? Make sure you are allowing Fund Manager to create new sub-portfolios and investments as needed for you, and you are importing all securities for all dates.

[Chandeleur]

Here's a portion of what I see of the .qif file in Notepad:
D05/29'09
NSell
Y - 0
T4.29
M0
^
D06/01'09
NXIn
YFunds Received
T299355.59
LOX Place Holder
MFunds Received
^
D06/05'09
NDiv
YDividend - CSJ
T171.05
^
D06/05'09
NDiv
YDividend - AGG
T203.47
^
D06/05'09
NDiv
YDividend - LQD
T244.15
^
D06/11'09
NBuy
YEFT - EATON VANCE FLOATING RATE INCOME TRUST
I10.58
Q3550
T37569.65
O10.65
M72073598
^
D06/11'09
NBuy
YEFT - EATON VANCE FLOATING RATE INCOME TRUST
I10.55925
Q10700
T113016.08
O32.1
M72073598
^
D06/29'09
NSell
YETJ - EATON VANCE RISK MANAGED DIVERSIFIED EQUITY INCOME FUND
I16.92
Q3000
T50743.74
O14.95
M72781951

[Chandeleur]

BTW...I went into Fundmanager and used the transaction upload button and input the account number and password and obtained the info I needed that way. But, I should be able to import the info via the Transaction import from brokersXpress method as well, and the preview transcation screen is blank that way as well. I feel like it's something so minor that's causing this.
Thanks,
Bryan

[Mark]

Hi Bryan,

To import a QIF file, you must use "File / Import / Transactions / Quicken (*.QIF)...". It sounds like you were trying to use "File / Import / Transactions / BrokersXpress...". This is a different format, available from BrokersXpress for RIAs.

[Chandeleur]

It's weird. I'm trying "File / Import / Transactions / Quicken (*.QIF)..." right now to no avail. Yet, a moment ago, on a client I downloaded info into via the "retail" method by putting her account number into and her password, that worked. Something is preventing the info from importing and being visible in the "Previewing Importing Transactions" page.

I should be able to download via the RIA method as well, but that's not working either.

[Mark]

Hi Bryan,

You can email me a .QIF file, and also a .TRN file (RIA method), and I can try importing here, and maybe provide better feedback. To send an attachment, just go fill out the regular email contact form with any simple message. Once you submit, you'll see a regular email address you can use to send attachments.

[Paul70]

I am having very similar problems with my Interactive Brokers ccount. I have downloaded and saved a Quicken file, but when I try to upload it, there is nothing there. I opened the file with a notepad and there is data there, so I have no idea what the problem is?? I don't know what else to do.

[Mark]

Hi Paul70,

Please try this:

1) Select "File / Import / Transactions / Quicken (*.QIF)...".
2) Browse to select your QIF file for import.
3) Choose "All Securities"
4) Choose "All Dates"
5) Choose "With Matching Sub-Portfolio Name as QIF Account"
6) Turn ON "Create New Sub-Portfolios as Needed" under "Master Portfolio"
7) Turn OFF "Skip Transactions Already In Fund Manager"
Turn ON "Create New Investments as Needed"
9) Press "Next"

Do you see your transactions listed in the Preview window?

Do not press "Finish", as we imported with "Skip Transactions Already in Fund Manager" turned on, just to see if FM could read your QIF file okay. You don't want to import duplicates. If you do see your transactions, go "Back", and turn off that option, and then press "Next" again. If you no longer see your transactions, then it is because they are already in your Fund Manager data files.

[Chandeleur]

Mark,
brokersXpress allows me to go into each clients account to download activity. One choice of format is Quicken. I download the file and try to import it to fund manager using the .QIF format, and nothing. I tried the suggestions you gave the previous person and I see nothing in the Preview Transactions window.

Is there something wrong with brokersXpress? I can't get info into FM going the route for RIAs or the way a client would import it either.

Bryan

[Chandeleur]

I checked "Skip Transactions..." and this time it downloaded transactions after I downloaded the file from bX for the 2nd time. I don't know why this didn't work the first time.

[Mark]

Hi Bryan,

Since you are an RIA with brokersXpress, you may prefer to use their TRN/POS files instead of downloading QIF files. With the TRN/POS files, you can do all accounts with a single download, rather than importing a single QIF file for each account. Also, with POS files you can reconcile your accounts, which you can't do with a QIF file.

[Chandeleur]

I don't know how to download *.POS files from brokersXpress. Where do I obtain those files?

[Mark]

Hi Bryan,

I think we've figured this out already, in our separate e-mail thread, but to answer you, it is under the "PortfolioCenter Download" and in the "Daily Files" choose "Download Reconciliation File".