[moneydance] Downloaded BUYs from Schwab
Michael Casteel
mac at casteel.org
Mon Nov 12 23:00:58 EST 2007
I just verified that the latest version of MD (and for some versions
back) mangles downloaded BUY transactions from a Schwab brokerage
account, and the resulting transactions will not balance to the
brokerage statement. I only have Schwab accounts, so don't know if
this applies to other brokerages.
What appears to be happening is, the share price on the downloaded
transaction includes the commissions (fees); this price is multiplied
by the number of shares, then the commissions are added in. The total
amount of this transaction is thus overstated by the amount of the
fees.
The simplest recovery when balancing to the statement is to get the
correct share price from the statement and edit the downloaded
transaction in MD to reflect the correct price. Barring rounding
issues, this makes the transaction total correct and it should match
the statement. A little hard to see, since Schwab statements show the
total transaction amount, while the 'total' amount MD shows on the
transaction is only the price times share count, although the
commissions/fees do impact the account balance. Mental arithmetic will
confirm if the correction has taken place. That or finding that the
statement reconciles.
I just entered a bug report on this issue. I think that SELLs had an
analogous problem some months ago, but they are working OK now.
--
Mike Casteel Seattle, WA
More information about the moneydance-info
mailing list