We do not support Consolidated Summaries for this provider. This is because it includes multiple different account numbers in the Market Value Reconciliation. The consolidated summary documents can be moved to “Not Supported” or “Other Documents”
Please see below under “Statement Formats (Pictures)” to see the difference between what a regular summary looks likes, and what a consolidated summary looks like.
You can also see in the upper right-hand corner of the statements, in the plan name, it will either say “Plan Name” or “Plan Name CNSLDTD”
Page #1 of Wilmington Trust statement will be a blank page, and is usually split off from the statement.
Since the first page is blank, it is okay if these statements start on page #2, which starts with the heading, “Balance Sheet”.
Extractions:
Beginning Balance
Employee Distributions
Other: Redeposits
TX: Fees
Other In
Other Out
TX: Income
Currency Gains
Realized Gains
Unrealized Gains
Ending Balance
Employee Contributions
Employer Contributions
Employer Distributions
TX: Transfers
Equations:
TX: Deposits
= {employee contributions} + {employer contributions}TX: Withdrawals
= {employee distributions} + {employer distributions}
TX: Other
= {other in} + {other out} + {other: redeposits}
Gain/Loss
= {realized gains} + {unrealized gains} + {currency gains}
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 Money Market Funds in the Transaction Detail.
We will include all activity under the following section headings:
Cost of Investments Purchased, Schedule of Income Received, Contributions & Benefit Payments, Other Cash Receipts, Disbursements and Expenses