Format 1
Extraction:
Beginning Balance
Dividends
Interest
Beginning Accrued
Ending Accrued
Realized Gains
Unrealized Gains
TX: Fees
Other Distributions
Ending with Accrued
Employee Pre-Tax
Other
Other Receipts
Equations:
TX: Income
={dividends} + {interest}
Gain/Loss
={realized gains} + {unrealized gains}
TX: Deposits
={employer contributions} + {employee contributions}+ {employee pre-tax}
TX: Other
={other disbursements} + {other receipts} + {other} TX: Accrued
={ending accrued} + {beginning accrued}
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
Schedule Of Realized Gains & Losses and Schedule Of Non-cash Transactions will not be included in the Transaction Detail.
Format 2
Extractions:
Beginning Balance
Prior Accruals
Dividends
Interest
Other Receipts
Disbursements
TX: Fees
Realized Gain/Loss
Change in Value
Current Accrual
Ending with Accrued
Equations:
TX: Income
={interest} + {dividends}
TX: Other
={other receipts} + {disbursements}
Gain/Loss
={realized gain/loss} + {change in value}
TX: Accrued
={prior accruals} + {current accrual}
Ending Balance
={ending with accrued} - {tx: accrued}
There will be TWO types of transaction details for this format.
Both Debit/Credit and Normal Transaction Detail guidelines will be followed and used for these statements.
D/C
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
The Transaction Detail guidelines will be followed and used for these statements.
Table Name: Transaction Detail
Column Names: Date, Description, Cash
Format 3
Extractions:
Beginning Balance
TX: Income
Other Out
Realized Gains
Other Cash Transfer
Other Transactions
TX: Accrued
Unrealized Gains
Ending with Accrued
TX: Deposits
TX: Withdrawals
Equations:
Ending Balance
={ending with accrued} - {tx: accrued}
TX: Other
= {other out} + {other cash transfer} + {other transactions}
Gain/Loss
= {unrealized gains} + {realized gains}
The Transaction Detail guidelines will be followed and used for these statements.
Table Name: Transaction Detail
Column Names: Date, Description, Cash