scottrade doubling cash in retrieved reconciliation

[drwehby]

Hi Mark,

For a few months now I've noticed that the share count retrieved from my Scottrade default cash account (really a margin account) is double the value that FM shows. Example, FM says -1000, Scottrade retrieval says -2000, difference 1000. Scottrade cash balance shows correctly on monthly statements, as well as on their website and trading platform, and agrees with the figure I show in FM. All other retrieved share counts are correct, as are all retrieved reconciliations from my Fidelity portfolio; seems to only affect my Scottrade portfolio default cash account.

I've ignored this anomaly for a while, but am now wondering if there's some easy fix, either on my end or on yours.

Thanks,

[Mark]

Hi drwehby,

I suspect this is due to a change in how FM parses your cash balance when retrieved from the broker. If you retrieve transactions for this account, and then go look at your xmldump.txt file, please search for AVAILCASH and MARGINBALANCE. You can find this file here:

C:\Users\<username>\AppData\Roaming\Fund Manager

In Fund Manager 12 and later we are obtaining your cash balance by looking at the sum of these two fields. It seems some brokers report this way, and others may not. Can you look at those figures, and let me know what you find? I'm guessing that you really need the figure they are showing in AVAILCASH as your cash balance.

[drwehby]

Hi Mark,

Thanks for your rapid response. I checked the xmldump.txt file (after a retrieved reconciliation from Scottrade) and the values for AVAILCASH and MARGINBALANCE are the same. If FM is summing these two values, then that would explain why I get 2x my actual cash balance when retrieving my reconciliation from Scottrade. Is there something I need to do on my end, or is this a fix you can implement? Is there something else you need me to do?

Best,

[Mark]

Hi drwehby,

Thanks for the information. This is something we have to fix on our end. It doesn't seem like all brokers report this in the same manner, so we may be best off to make this user-adjustable. We will have this corrected for the next release (12.2). If you'd like a pre-release to test with, please send us an e-mail, and we can provide that.