Reports - Deferred Tax
Previous Top Next
 
The Deferred Tax Report allows you to calculate your deferred tax assets and liabilities for each reporting period, and also the associated adjustments to the APIC pool balances.

     Reporting Period Start Date and End Date.  This is usually the current reporting period, that being a monthly reporting period, a quarter-to-date reporting, or a year-to-date reporting period.  The dates can also be used to calculate deferred tax for a future period or calculate the deferred tax for a historical period.  Reporting Dates default to your last entry.

Note: Reporting period must start on or after ASC 718 adoption date, i.e., Reporting Period Start date should be greater than or equal to ASC 718 adoption date.

1. Select Report Period Type: This selection has been added to the Deferred Tax page. The report period type helps navigate between running reports for periods under Close-the-Books and running ad-hoc reporting periods. The report period types are:
i. Custom: Ad-hoc reporting periods that are not tied to Close-the-Books. Can be any valid date range.
ii. Predefined: Reporting periods that are specific to Close-the-Books functionality. The period will default to the earliest, unclosed period as established under the Configure - Reporting Periods page.  
iii. Historical: Saved results from closed, pre-defined reporting periods specific to Close-the-Books functionality.
 

2. Custom Reporting Period Start Date and End Date.  This is usually the current reporting period, that being a monthly reporting period, a quarter-to-date reporting, or a year-to-date reporting period.  The dates can also be used to project deferred tax for a future period or calculate the cumulative deferred tax outputs for a historical period.  Reporting Dates default to your last entry.

Note: Reporting period must start on or after ASC 718 adoption date, i.e., Reporting Period Start date should be greater than or equal to ASC 718 adoption date.    

General Deferred Tax Setting
       
3.  Mobility Reporting

The selection determines if Deferred Tax calculations will be based on mobility reporting data on file for mobile optionees and their grants.

If Mobility Reporting is Yes, mobility data will be considered for the calculations, and the tranche-level detail report is presented in a format that accommodates mobility data, mobility transactions, and combines MPA and Non-MPA grants on the same report.

The grant summary report also will provide mobility reporting. If Mobility Reporting is No, the Universal format can be selected for the tranche-level detail report where MPA and Non-MPA grants are combined but mobility data will not be considered.


4.  Liability and Non-Employee Reporting
The selection determines if Liability and Non-Employee Awards will be part of the report.  The choices are Yes and No.

If Liability and Non-Employee Reporting is Yes, all Liability and Non-Employee Awards in the client data will be processed and output in the report. The Universal report format will be automatically selected as the unique columns pertaining to these types of awards are captured only in that format. 


5.  Exclude Grants with zero (0) Outstanding Shares.

This drop-down indicates whether or not to exclude grants with zero   outstanding shares from the report.  The underlying purpose for this is to reduce the size of the report being generated.  The default is YES, exclude grants with zero outstanding shares.  This setting will be carried over to subsequent selections of this report (ie. if set to NO, the next entry to this page will show NO for this setting).

 
6.  Exclude Grants not impacting Deferred Tax.
This drop-down indicates whether or not to exclude grants that do not impact deferred tax. The underlying purpose for this is to reduce the size of the report being generated.  The default is YES, exclude grants that do not impact deferred tax.  This setting will be carried over to subsequent selections of this report (ie. if set to NO, the next entry to this page will show NO for this setting).

7.  Grant Selection
The Grant selection filter allows grants to be selected based on whether they are considered mobile or non-mobile. The dropdown is enabled when Mobility Reporting is “yes”. The default is “Mobile and Non-Mobile Grants”.

8.  Advanced Filtering
Allows to specify a subset of data that should appear on the report before calculation process has been initiated. By default, up to three levels of filtering criteria can be specified. Following fixed filtering criteria is available: Grant ID, Optionee ID, Plan Name, Award Type, Award Sub Type, Grant Date, Expiration Date, Acquisition Date, Retirement-Eligibility Date, MPA Condition, Grant Settlement Type, Accounting Classification, Employee Accounting Status, Mobility ATB, 83b Election, and Vest Name.
Additional Filtering Criteria is available by uploading User Defined filtering criteria through the Uploaded Data page.

Up to three filtering values can be specified for each filtering criteria. A filtering value can be added by clicking 'Add' to the right of the filtering criteria value input box or drop-down list.

The 'Filter to Exclude' check box permits to exclude the information specified in the Advanced Filtering Criteria.


9.  Report Selection

Generates deferred tax reports at a group level, a grant level or a tranche level

Reports are generated for Non-MPA and MPA grant types as well as mobile and/or non-mobile grants. Mobility reporting results in Non-MPA and MPA grants being presented together on the tranche-level detail report along with specific mobility data.

The universal format selection for non-mobility reporting also allows Non-MPA and MPA grants to be presented together on the tranche-level detail report. Otherwise Non-MPA and MPA grants are presented on separate tranche-level detail reports with the legacy format.

     Reports
 a.  Deferred Tax Group Summary
 b.  Deferred Tax Grant Summary
 c.  Deferred Tax Tranche -  Level Detail

Settings
 d.  Grant Total only for Mobile Grants (available when Mobility Reporting is set to Yes)
e.  Universal Format (includes all available columns across all report types)



10.  Grouping Criteria and Report Presentation (for Legacy Reports)
 a.  The user selects the type of report format they would like.  Either CSV or EXCEL can be selected.      
 b. The user selects any grouping criteria by which they would like to have their report grouped.  The user has the ability to select up to three levels of grouping.
          


11.  Deferred Tax Reports for MPA and non-MPA grants
          If MPA Awards are present in the dataset, the Tranche-Level Summary and Tranche-Level Detail reports will be generated for MPA and non-MPA Awards. The Group Summary and the Grant Summary will have both MPA and non-MPA awards in the same report.

   12.  Advanced Report Selection
            Advanced Report Settings area has been added to the Deferred Tax Reports pages of the application.  In addition to providing users advanced  controls over the format and layout of the financial reports, the Advanced Report Settings serves as the staging area for generating, viewing, and closing results for clients utilizing Close-the-Books reporting.  With the exception of Out-of-Period Transactions report and new columns added specifically for Close-the-Books functionality, all Advanced Reports are based on the legacy reports.               

             The following reports are available for selection.

        Reports

      a. Deferred Tax Group Summary
      b. Deferred Tax Grant Summary without Mobility
      c. Deferred Tax Grant Summary with Mobility
      d. Deferred Tax Tranche Detail
      e. Deferred Tax Out-of-Period Transactions
      f.  Deferred Tax Group Summary (PDF)
      g. Deferred Tax Grant Summary (PDF)
      h. Deferred Tax Tranche Detail (PDF)
      i.  Deferred Tax Dataset (with an optional Dataset Name input box)
      j.  Deferred Tax Out-of-Period Transactions Dataset (with an optional Dataset Name input box)

          Note: The ordering of the reports is defined in the Admin page.

   13.  Report Format (for Advanced Reports)
       a.  The user is able to select Report Formats of PDF, CSV, XLS and XLSX across the various reports. Certain selections are not available for certain reports. These have been disabled.  

   14.  Grouping Criteria and Report Presentation

       a. The user selects any grouping criteria by which they would like to have their report grouped.  The user has the ability to select up to five levels of grouping.