We extract:
Beginning Balance
Interest
Dividends
TX: Deposits
TX: Withdrawals
TX: Fees
Realized Gains
TX: Accrued
Unrealized Gains
TX: Other
Ending with Accrued
Field Equations:
Tx: Income
= {dividends} + {interest}gain/Loss
= {realized gains} + {unrealized gains}= {dividends} + {interest}Ending Balance
= {ending with accrued} - {tx: accrued}The normal Transaction Detail guidelines will be followed and used for these statements
Table Name: Transaction Detail
Column Names: Date, Description, & Amount