Extractions:
Beginning Balance
TX: Transfers
Market Gains
Ending Balance
Deposits: Cash
Deposits: XFR
Other In
Withdrawals: XFR
Other Out
Withdrawals: Cash
Withdrawals: Check
TX: Fees
TX: Income
TX: Purchases
TX: Sales
Deposits: Check
TX: Reinvestments
Equations:
TX: Deposits
={deposits: check} + {deposits: cash} + {deposits: xfr}
TX: Withdrawals
={withdrawals: check} + {withdrawals: cash} + {withdrawals: xfr}
TX: Other
={other in} + {other out}
Gain/Loss
={market gains} - {tx: reinvestments}
There will be TWO types of transaction details for this format of Merrill Lynch. Both Debit/Credit and Normal Transaction Detail guidelines will be followed and used for these statements.
Normal
The normal Transaction Detail guidelines will be followed and used for these statements
Table Name: Transaction Detail
Column Names: Date, Description, & Amount
The Transaction Detail D/C guidelines will be followed and used for these statements.
Table Name: Transaction Detail D/C
Column Names: Date, Description, Debit, & Credit