Janney Montgomery 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:
TX: Income
Beginning Balance
Ending Balance
TX: Deposits
TX: Withdrawals
TX: Purchases
TX: Sales
Income & Expense
TX: Other
The normal Transaction Detail guidelines will be followed and used for these statements
Table Name: Transaction Detail
Column Names: Date, Description, & Amount