Format 3 of Vanguard is the only known format to reconcile.
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”.
Format 1
Quarterly/Monthly Statements:
You ALWAYS want to check the Transaction Details to see if you are seeing transactions for one month or multiple months.
Quarterly: Transactions from a quarter (multiple months)
Monthly: Transactions from one singular month
The table tagged values for this provider are ONLY from the table under Balances and Holdings for Vanguard Funds (Make sure that you are not tagging other tables under the headings “Settlement Fund” or “Mutual Funds).
Extractions:
Ending Balance
If the Vanguard statement is made up of multiple funds…
WITHDRAWALS & INCOME
Under each fund’s name, there is a rectangle with Purchases, Withdrawals, and Income. Manually add up each type of transaction from each fund and enter those totals manually in the metadata fields.
The normal Transaction Detail guidelines will be followed and used for these statements
Table Name: Transaction Detail
Column Names: Date, Description, & Amount
Format 2
Beginning Balance: DO NOT pull Beginning Balance from the statement!!!
Please make sure to use the Ending Balance from the previous statement as the Beginning Balance for the current one you are working on.
Extractions:
Ending Balance
Dividends
Interest
Tax-Exempt Interest
Short-Term Capital Gains
Long-Term Capital Gains
Other Income
Equations:
TX: Income
={dividends} + {interest} + {tax-exempt interest} + {short-term capital gains} + {long-term capital gains} + {other income}
The normal Transaction Detail guidelines will be followed and used for these statements
Table Name: Transaction Detail
Column Names: Date, Description, & Amount
Format 3
Beginning Balance: DO NOT pull Beginning Balance from the statement!!!
Please make sure to use the Ending Balance from the previous statement as the Beginning Balance for the current one you are working on.
Extractions:
Ending Balance
Format 4
Extractions:
Beginning Balance
Deposits & Withdrawals
Gain/Loss
TX: Income
Ending Balance
Equations:
TX: Deposits
={deposits & withdrawals} < 0 ? 0 : {deposits & withdrawals}
TX: Withdrawals
={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
We will not include “Pending Distributions” in the Transaction Detail.