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 (you do not have to worry about calculating sales and purchases as these are not apart of reconciliation)!!!
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”.
Format 1
Step 1
Step 2
Extractions:
Beginning Balance
Deposits & Withdrawals
Ending Balance
TX: Income
Equations:
TX: Deposits
={deposits & withdrawals} >= 0 ? {deposits & withdrawals} : 0TX: Withdrawals
={deposits & withdrawals} < 0 ? {deposits & withdrawals} : 0
Normal Transaction Detail guidelines will be followed and used for these statements (columns will be labeled as “Date”, “Description” & “Amount”). Therefore, in the tables section this graph will be labeled as “Transaction Detail”
Format 2
DO NOT PULL FROM THIS TABLE
Step 1
Step 2
Extractions:
Beginning Balance
Deposits & Withdrawals
Ending Balance
TX: Income
Equations:
TX: Withdrawals
={deposits & withdrawals} >= 0 ? {deposits & withdrawals} : 0
TX: Deposits
={deposits & withdrawals} < 0 ? {deposits & withdrawals} : 0
The normal Transaction Detail guidelines will be followed and used for these statements
Table Name: Transaction Detail
Column Names: Date, Description, & Amount