ATTENTION: Moving forward, for this provider, you will:
Extract all the fields visible in the screenshots.
Calculate any other relevant details from the statement, particularly in the transaction section, to capture all the reporting activities during that period.
CAREFUL: Select the “Auto-Calculate Gain/Loss” option, but only after performing the steps mentioned above.
Leave a note stating “Please review and verify the statements below. The activity has been manually calculated by referencing the transaction details, and the gain/loss has been determined based on that information.”
Mark the account as “Reviewed” in the Investments Dashboard (if you are working in there).
**You may approve the statement, even with an “Other Transaction” value as long as you are leaving the appropriate note and marking the account as “Reviewed”.
DO NOT pull “beginning balance” and “ending balance” from the “Value of Direct Investments” section. It should only be pulled from “Total Asset Value.”
Extractions:
Beginning Balance
Ending Balance
TX: Accrued
TX: Other
Deposits & Withdrawals
Purchases & Sales
TX: Income
Equations:
TX: Sales
TX: Puchases
TX: Deposits
TX: Withdrawals
The normal Transaction Detail guidelines will be followed and used for these statements
Table Name: Transaction Detail
Column Names: Date, Description, & Amount