American Funds



Participant Balance DetailDESCRIPTION:This report provides a detailed list of participant balances by investment option and/or money source as of a specified date. The report can be run for up to thirty specified participants at a time by entering their SSNs in the boxes provided, or simply leave all SSN List boxes as “NONE” to run the report against the entire plan. Filtering options allow the report to pull information on specific or all investment options, and also allow you to extract specific populations of participants based on employment status.AVAILABLE FORMATS:Excel:Recommended for data sorting and formatting. Additional columns of data are available in this formatPDF:Recommended for viewing and printing formatted text and graphicsWord:Alternate option for viewing and printing formatted text and graphicsFAQ’sQ: How do I use the SSN List options?A: If you want to run the report for one specific participant, enter his/her SSN in the SSN List 1 box. There are six available SSN List boxes, and each allows you to enter a total of five SSNs, separated by commas, for a maximum of 30 SSNs. To run the report for the entire plan, leave the SSN List boxes set to their default value of NONE.Q: What is the Sarbanes Oxley Indicator option?A: If you have identified participants on our system as requiring Sarbanes Oxley reporting (Trade Monitoring), you can run this report to capture just those participants. To identify/flag participants in this category, the Sarbanes Oxley Indicator on the PSC must be set to a “Y”. You may also select the option to display participants with a Sarbanes Oxley Indicator and enter additional SSNs in the List boxes.Q: Can I run this report for multiple plans?A: If you have access to the “Multi Plan” category, you may run this report against some or all of the plan numbers to which you have been granted access. Please note that our system will automatically choose a divisional category, if applicable, for each plan as different plans may utilize varying division categories (i.e. – Department, Agency, Division, etc). DATA SPECIFICATIONS:Plan NumberAssociated Plans (Excluded/Included)SSN List 1SSN List 2SSN List 3SSN List 4SSN List 5SSN List 6Investment OptionsBalance By Money Source (Include/Exclude)Sarbanes Oxley IndicatorParticipant SelectionOptionsAll Participants with a Balance as of the Effective DateEmployed Participants with a Balance as of the Effective DateTerminated from Employment with a Balance as of the Effective DateParticipant IdentifierSort OrderFrequencyEffective DateOUTPUT COLUMNSEXCELPDF & WORDPlan NumberSSNPlan NameSSN ExtDivision BasisFirst NameDivision NumberLast NameDivision NameAgeSSNInvestment IDSSN ExtInvestment NameFirst NameLast NameIf requested by Money SourceAgeMoney SourceInvestment IDInvestment NameBalancesSharesIf requested by Money SourceInception to Date CostMoney SourcePercent of AssetsTotal BalanceBalanceSharesInception to Date CostPercent of AssetsTotal BalanceBirth DateHire DateTermination DateTicker SymbolAsset Model Description (if applicable)If requested by Money Source Money Source Description ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download