Altruist statements will not reconcile on their own, and will always end up in the Trust Accounting To-do stack. Once each metadata field has been reviewed and confirmed, move this document into the “Ok” sub-stack.
Look out for Statements that only have an ending date. You will manually have to enter a period start date (which we will use the start of the same month of ending period date)
We tag the beginning and ending balances from “Holdings Total” row because the ending balance matches the “Account Value” above.
Equations:
Beginning Balance
= {beginning accounts total} + {beginning holdings total}
Ending Balance
= {ending accounts total} + {ending holdings total}
The normal Transaction Detail guidelines will be followed and used for these statements
Table Name: Transaction Detail
Column Names: Date, Description, & Amount