Exec Summary reconciliation

[elliots]

Mark,

I'm having trouble reconciling the Contributions/Withdrawals on the Exec Summary with External Transactions Report. Shouldn't Contributions on Exec = Buys + TxIn on External transactions, and Withdrawals = Sells + TxOut? (There are no Withdrawn Distributions; there were account fees paid but that doesn't appear to be the difference).

Elliot Lipson

PS This is the same account with the External Transactions report issue so if you've still got my backup you've got the data.

[Mark]

Hi Elliot,

Yes, this is correct. I took a look at your data for the dates 10/1/13 - 12/31/13, and it matched correctly with the external transaction summary for the same account and same date range. There were only 2 TxIn transactions for external transactions in that account for that date range. Are you sure you're looking at the same date range in the Investment Transactions report?

[elliots]

Mark,

Yes, it checks for the VBO subportfolio. But when I do the client's household (all accounts) it seems to break down.

Elliot

[Mark]

Hi Elliot,

I went up 2 levels in the hierarchy to the "Household" level, and the "Contributions" value in the Exec. Summary report matches the "Buy + TxIn" total of the Investment Transaction report when only showing external transactions. The "Withdrawals" equals the "Sell + TxOut + Acct Fees Paid". Make sure you turn on totals display in the Investment Transaction report, so it sums these for you. If you're still seeing problems, maybe you can send me some screen shots.