Format 1
Extractions:
Beginning Balance
Ending with Accrued
TX: Accrued
Change in Value
LT Gains
ST Gains
TX: Fees
TX: Deposits
TX: Income
Equations:
Ending Balance
={ending with accrued} - {tx: accrued}
Gain/Loss
={change in value} + {lt gains} + {st gains}
The normal Transaction Detail guidelines will be followed and used for these statements
Table Name: Transaction Detail
Column Names: Date, Description, & Amount
Format 2
The “Market Value Summary” will be on the 8th-ish page
Extractions:
Beginning Balance
Interest
Dividends
Other Taxes
TX: Fees
TX: Deposits
TX: Withdrawals
LT Gains
ST Gains
Other Amortization
Change in Value
TX: Accrued
Ending with Accrued
Equations:
Ending Balance
={ending with accrued} - {tx: accrued}
Gain/Loss
={change in value} + {lt gains} + {st gains}
TX: Other
= {other taxes} + {other amortization}
TX: Income
= {interest} + {dividends}
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