Format 1
Extractions:
Beginning Balance
TX: Income
Transfer In
Other In
Other Payments
Other Expenses
Transfer Out
TX: Fees
Gain/loss
TX: Accrued
Ending with Accrued
Other Out
Employer Contributions
Employee Contributions
TX: Sales
TX: Purchases
Equations:
TX: Transfers
= {transfer in} + {transfer out}
TX: Other
={other in} + {other out} + {other payments} + {other expenses}TX: Deposits
={employer contributions} + {employee contributions}
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
Format 2
Page 6 of the Statement will normally have the Summary section where we pull our Table Tags. (Page 7 should have your Purchases and Sales value)
Extractions:
Beginning Balance
Employer Contributions
Employee Contributions
TX: Income
TX: Fees
Gain/Loss
TX: Accrued
Ending with Accrued
Other Payments
Other In
Other Out
Other Expenses
Transfer In
Transfer Out
TX: Sales
TX: Purchases
Equations:
TX: Transfers
= {transfer in} + {transfer out}
TX: Other
={other in} + {other out} + {other payments} + {other expenses}
TX: Deposits
={employer contributions} + {employee contributions}
TX: 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