KFB 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, we will click the “Auto-calculate gain/(loss)” button below these fields to reconcile the document.
Extractions:
Beginning Balance
Ending Balance
TX: Purchases
TX: Sales
TX: Deposits
TX: Withdrawals
TX: Income
Other In
Other Out
Withholding In
Withholding Out
Equations:
TX: Other
={other in} + {other out} + {withholding in} + {withholding out}
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