In Administration > Manage Datasets > Datasets, you can create Empty datasets, or Copy, Rollover, and Combine datasets. Datasets represent a set of tax information for a specific period of time.

 

•Administrators have the option to roll over a provision dataset to an interim dataset as long as the interim rate basis is set to unit by unit.

•Administrators can change a dataset from a read only dataset to a read-write dataset if the case number is deleted or if a new case number is added.

•You can review data in Read-Only datasets; you cannot edit the data.

 

1.An empty dataset creates a new dataset to enter new information, not already in the application.

2.A copied dataset creates a new dataset with information already in the application.

3.A rolled over dataset creates a new dataset and includes the beginning deferred balances.

4.Multiple datasets are combined using the Reporting Dataset or Combined Dataset feature. These functionality combine two or more datasets, and associated components. The combined dataset will not reflect which dataset that a component originated.

 

Use the following options when creating a dataset.

Name

•The Dataset Name is user-defined and can be any combination of alpha-numeric characters, including spaces, up to 60 characters.

•You can edit the Dataset Name.

•The dataset name appears in the My Datasets, Review & Edit and report headers.

 

Type

The dataset types include:

•PROV - Provision Dataset

oYou create Provision datasets to calculate the tax provision.

•EST PYMT - Estimated Payment Dataset

oYou create Estimated Payment datasets to calculate the current liability.

 

Fiscal Year

Assign a Fiscal Year to the dataset. By default, the current year appears in the Fiscal Year field. You can type a year or select a year from the drop-down list.

 

Fiscal Period

Assign a Fiscal Period to the dataset. The Fiscal Period defines whether the data in a dataset represents a month, several months, a quarter, or a year. You can type a year or select a year from the drop-down list.

 

Group Rate %

Type the Group Rate. The Effective Tax Rate report uses the group rate as the statutory rate to which the provision reconciles.

 

Case Number

An optional field primarily for exporting data to compliance software.

 

ID

The system assigns a unique identification number to the dataset.

 

Transaction

Select a Transaction option so the system can determine which data entry fields to populate. For example, the system can copy or rollover data to populate data entry fields. You  also have the option to create an empty dataset which will have no data in the data entry fields.

1.Create an Empty dataset which contains no data.

2.Copy an existing dataset and all information in the copied dataset resides in the new dataset.

3.Rollover a dataset and the system creates a dataset for the sequential period. The ending balances and rates in the dataset are the beginning balances and rates in the rolled over dataset.

4.Combine datasets and the group of datasets generate a single combined dataset. Some limitations apply to the combine functionality. Please review the combined dataset to ensure accurate calculations appear in the reports. The combine function assumes the rates entered for the calculations. Certain entries and balances sometimes differ from a reporting dataset using the same datasets.

 

Apply Data Options

Select Tags or Class/Subclasses when creating a new dataset.

•Using tags or classes/sub-classes, in data entry pages, lets you indicate the source of your data for review purposes.

•Using tags or classes/sub-classes lets you keep track of your data entry amounts by tag or class/sub-class.

 

Source Dataset

•Select the dataset that you want to copy or rollover.

•Depending on the Data Option you select, datasets appear with classes or tags, not both.

 

Prior Period Dataset

The default dataset used for unit comparison for reporting. The selected value will be the default value for the comparison dataset in the Unit Comparison Report within Reporting.

 

Date

The system applies a date and time stamp when you create a dataset.

 

Read-Only

•Upon completion of data entry, you can secure your data by selecting the Read Only (R/O) option for the dataset.

•You can review data in Read Only datasets. You cannot edit datasets assigned the Read Only status.

•A warning No Edit Allowed appears in data entry pages for datasets with Read Only permissions.

 

Archived

Archived datasets are similar to Read-only datasets. If you archive a dataset, it will not appear in All Datasets or My Review list within My Datasets.

 

Dataset Relations

With Dataset Relations, you assign (1) tax return data (RTP Return) to the (2) final provision (RTP Provision) and (3) current provision data (RTP Target). Then, the system can automatically update the current tax provision dataset (RTP Target) through the calculation and posting of RTP true-ups.

 

RTP Return

A PROV type dataset with the filed tax return data.

 

RTP Provision

A PROV type dataset with the final tax provision data.

 

RTP Target

A PROV type dataset with the current year tax provision data.

 

For RTP adjustments to be posted, a Tax Return dataset (RTP Return) that has the filed tax return data must be related to:

1.The same or previous period dataset with Provision data (RTP Provision) (final provision).

2.The same or future period Target dataset (current year tax provision).

 

Locked/Unlock Subcons

You can Lock and Unlock Subcons within a dataset. You cannot edit or import data into a locked dataset.

 

Search Datasets

To filter the dataset list,

1.In the Name column select the filter.

2.In the Search field, type the alpha-numeric information and click Apply. The new list appears.

•For example, type 2016 in Search Datasets and the application lists all datasets with 2016 in the name column.

3.Click Clear in the filter, to clear the information in the Search field.

 

Import Datasets

To import a new dataset, complete the appropriate fields on the #CD# Datasets sheet in the import categories template.