Reconcile Canadian Accounts

[gmow]

Hi Mark, looking for a workaround to reconcile.

My investments(Cdn) in FM have a symbol ie. CAE.TO This works well for Yahoo prices

My brokerage via .qfx file lists the symbol as CAE

Reconcile reflects all investments as unbalanced.

Any suggestions?

[Mark]

Hi gmow,

When reconciling against a .OFX or .QFX file, the CUSIP is used, and not the symbol. Make sure you have the CUSIP recorded on your investment's properties. If you don't know the CUSIP, there are a few ways you can find it:

1) Search online

2) In the Reconciliation Wizard there will be a line item showing a statement share balance, and a 0 balance in FM. Click on this line, and choose "Edit...". You'll be asked if you want to create a new investment. Say "Yes". In the "New Investment" dialog that comes up, you'll see the CUSIP value. Copy this to the clipboard, cancel this dialog, and go enter this into the properties of your existing investment.

3) You can find the CUSIP in the .QFX file. The .QFX file is a text file that you can edit in something like Notepad. You will see a section like this for each security:

<SECINFO>
<SECID><UNIQUEID>922906300<UNIQUEIDTYPE>CUSIP</SECID>
<SECNAME>VANGUARD FEDERAL MONEY MARKET INVESTOR CL
<TICKER>VMFXX

In the above example, the CUSIP to use would be: 922906300

[gmow]

Thanks Mark, I'm able to work with CUSIP in the .QFX file.

Is the only way to enter the CUSIP via properties? Any way to copy and paste into editor screen or an import of CUSIP info?

[Mark]

You can enter the CUSIP in the Investment Properties... dialog or in the "Edit / Symbol List..." dialog (Advisor version). You can't directly edit it in the Portfolio Editor.

[gmow]

Hi Mark, I completed the entries of CUSIP for my Canadian Account and it worked perfectly.

I've attempted to complete the same process for my US account and does not work.

Every holding shows Fund Manager qty but the statement is all zero.

How do I troubleshoot as I noticed the advanced options?

[Mark]

Hi gmow,

Are you reconciling with a .QFX file here as well? Does your .QFX file have position information? If you edit the .QFX file in a text editor, you should see a:

<INVPOSLIST>

and then followed by multiple:

<INVPOS>

for each position you have in the account. Within this section you should see the CUSIP value and the shares (shown under <UNITS>).

[gmow]

Yes to .QFX file.

Yes to <INVPOSLIST>

Yes to <INVPOS>

I'm using the same process etc. as the successful Cdn account reconciles. The only difference is the .qfx file.

[Mark]

You might check the account number then, to make sure yours in FM is the same as in the QFX file. Also, try doing a "File / Import / Positions / .QFX... and see if the positions show in the "Preview" dialog okay. Cancel this to not import them.

[gmow]

You might check the account number then, to make sure yours in FM is the same as in the QFX file. Also, try doing a "File / Import / Positions / .QFX... and see if the positions show in the "Preview" dialog okay. Cancel this to not import them.

It was the account number...thanks Mark