When you come across a Cetera statement in a client’s Trust Accounting To-do sub stack, you will have to table tag every single value, as you would if you were creating a labeled sample.
This is to make sure the values you are tagging are referenced in the correct time period .
Please double check the Period Start & End dates in the metadata field to make sure they are tagged for correctly according to the statement’s format.
Extractions:
Beginning Balance
Other Out
Other
Gain/Loss
Ending Balance
TX: Sales
TX: Income
TX: Deposits
The normal Transaction Detail guidelines will be followed and used for these statements
Table Name: Transaction Detail
Column Names: Date, Description, & Amount
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