The Grouping Criteria and Report Presentation Section of the Expense,
Deferred Tax, EPS Dilution, and A240 Disclosures pages provides the ability for you
to select grouping and report formatting options.
The average expected time for report completion is between 5 and 10 minutes.
However, very large plans could take longer. Continue to check back with the
Reports Manager.
Reports can be generated in either CSV and/or Excel format.
CSV formats provide the following:
a A header identifying the report contents
b Column headers identifying each column
c The absence of grouping (sub total or total lines) to enable easier
upload to external applications such as Microsoft Access
Excel formats are the preferred method for producing ‘report’ like output and
provide the following:
a A header worksheet (tab) identifying the report contents as well as
grouping selections
b Column headers identifying each column as well as appended Grouping
Criteria columns displaying the grouping value selected (making it
easier to identify a particular detail line)
c Automatic separate worksheet (tab) split based on group and 65,000
line limitations
d Sub total and Total lines for each group selected
e Grand total line on last worksheet (tab) for the report
There are three levels of grouping. Once an option from a higher level group is
selected, the lower level grouping option is enabled. This means you are not able
to select Sub Group 2 without first selecting Sub Group 1.
The grouping drop down lists are populated with ‘fixed’ criterion as well as data
provided via the User Defined Lists File.
The default grouping option is ‘None’.
Fixed grouping criterion that is provided is: 'Plan', 'Award Type', 'Optionee ID',
'Granted Awards vs. Assumed Awards', 'Acquisition Date', 'Acquired Company
Name', 'Modified Awards vs. Non-Modified Awards', 'Options vs. Restricted vs.
SAR', 'Vesting Modification Type', '83b Election', 'Award Subtype', 'Vest Name' and
‘Grant Date’, 'MPA Condition', 'MPA vs. Non-MPA'.
Generate a report by selecting the Generate Report button. A request to
generate the report is sent. The status of the report(s) can be viewed through the Reports Manager.
A240 Disclosure Reporting There are a couple of variances as it applies to reporting for these reports.
a The fixed field grouping option of 'Options vs. Restricted vs. SAR' is
not applicable to any A240 report. The reason for this is: The A240
Option Activity Summary reports ‘Options’ and the A240 Non-Vested
Summary reports ‘Restricted’. Instead the option Options vs. SAR is
available only when A240 Option Activity report is chosen singly. The
A240 Assumptions Disclosure Summary is a summary and therefore
grouping is not applicable for this report.
b The A240 Assumptions Disclosure Summary report is generated in CSV
only. If Excel is selected, the report is still only generated as a CSV
output.