Format 1
Extractions:
Beginning Balance
TX: Transfers
Change in Value
Ending Balance
TX: Purchases
TX: Reinvestments
TX: Sales
TX: Income
Deposits: Check
Deposits: XFR
Withdrawals: XFR
Other Out
Deposits: Cash
Withdrawals: Cash
Withdrawals: Check
Other In
Equations:
TX: Deposits
={deposits: check} + {deposits: cash} + {deposits: xfr}
TX: Withdrawals
={withdrawals: cash} + {withdrawals: check} + {withdrawals: xfr}
TX: Other
={other in} + {other out}
Gain/Loss
={change in value} - {tx: income} - {tx: reinvestments}
The normal Transaction Detail guidelines will be followed and used for these statements
Table Name: Transaction Detail
Column Names: Date, Description, & Amount
We will not include Money Market Fund And Bank Deposits or Unsettled Purchases Activity in the Transaction Detail.
Format 2
Format 2 of Morgan Stanley does not have an account number present on the statement. Therefore the only time these statements will make it through the workflow is when it is manually added by the Client in “Account not in PE”.
Extractions:
Beginning Balance
Employee Contributions
Employer Contributions
TX: Withdrawals
TX: Fees
TX: Transfers
TX: Other
Gain/Loss
Ending Balance
Equations:
TX: Deposits
={employee contributions} + {employer contributions}
There will be no transaction details for this format of Morgan Stanley. If you come across an example of this format with transaction details, please let @Kaylee Picthall (Unlicensed) or @Hannah Johnston know.
The only form of activity will be formatted like an account summary, not itemized transactions.