Format 1
Extractions:
Beginning Balance
Deposits & Withdrawals
TX: Income
TX: Transfers
Change in Value
TX: Accrued
Ending with Accrued
Equations:
TX: Deposits
={deposits & withdrawals} < 0 ? 0 : {deposits & withdrawals}
TX: Withdrawals
={deposits & withdrawals} < 0 ? {deposits & withdrawals} : 0
Gain/Loss
={change in value} - {tx: income}
Ending Balance
={ending with accrued} - {tx: accrued}
Format 2
Extractions:
Other In
Other Out
Other Disbursements
Realized Gain/Loss
Unrealized Gain/Loss
TX: Income
Beginning Balance
Ending Balance
Equations:
TX: Other
={other in} + {other out} + {other disbursements}
Gain/Loss
={realized gain/loss} + {unrealized gain/loss}
The normal Transaction Detail guidelines will be followed and used for these statements
Table Name: Transaction Detail
Column Names: Date, Description, & Amount