Extractions:
Beginning Balance
TX: Income
TX: Accrued
Gain/Loss
Ending with Accrued
TX: Deposits
TX: Sales
TX: Withdrawals
TX: Purchases
Other Fees
Management Fees
Annual Fee
Tip for Reconciling UBS Statements:
If you've tagged all the fields present and thoroughly reviewed the statement but it's still not reconciling, I recommend checking the “Account Activity This Month/Investment Transactions” section. Scroll to the bottom and look for “Securities Transferred In” or “Securities Transferred Out.”
Try tagging these entries as tx: transfers. If the statement reconciles after this step, you’re good to move on to your next task.
See highlighted text above
Equations:
Ending Balance
={ending with accrued} - {tx: accrued}
TX: Fees
={management fees} + {other fees} + {annual fee}
There will be TWO types of transaction details for this format.
Both Debit/Credit and Normal Transaction Detail guidelines will be followed and used for these statements.
Money Balance Activities will not be included in the Transaction Detail.
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