Data Dimensions

There are two Data Dimensions within the system that can provide you with the true source of data for all entries

Data Source

The Data Source column shows every data item available in the application. The Data Source column is populated with icons that display and represent the data entry. Data Source/Data Dimensions will enable you to understand the source of particular data.

The application has unique icons for all Data Sources that allow you to review the detail of the data, and the various events that occurred such as when, why, and how data changed.  When an amount is changed it is tracked.

Notes

Notes pre-populate with the data source name. You can add information to the note or change the note.

Tag

Tag is used for identifying which items flow to different columns on the Deferred Balance report. The configuration identifying which items are displayed on a column is derived by the tags set up.

Class

Class is used for identifying which items flow to different columns on the Deferred Balance report. The configuration identifying which items are displayed on a column is derived by the classes set up.

Subclass

Subclass is used for identifying which items flow to different columns on the Deferred Balance report. The configuration identifying which items are displayed on a column is derived by the subclasses set up.

Unit Details - Data Source Icon

Select Data Input, Units and then select data source to review how an item has been entered into the application.

Adjustments - Data Source Icons

Rolled Over Datasets

For a Rolled Over dataset, the Data Source History will rollover and information may be viewed in the Notes column such as the name of the dataset that was rolled over. The Note will pre-populate with information from the dataset that is rolled over.

Data Source History: Data Input

The Data Source History displays the Data Source, Change Type, User, Date, Tag, Adj. Type, Expense Amount, Classes, Sub-Classes, and Notes. Within the Data Source History page, you can filter and export data.

In the following example, the Data Source is an Active Workpaper, the Change Type is Add, and the User is admin.

Data Source History: Administration | System

In Manage Configurations, you have the option to set up Data Source History. The history is available for all levels of data entry. Examples include PTBI, Payable, Permanent, and Temporary differences that are bridged in, active workpapers, and imported data. Icons are available to to assist you in understanding how the data is entered.

View Audit Trail

View Data Source History

The Data Source History displays the Data Source, Change Type, User, Date, Tag, Adj. Type, Expense Amount, Class, Sub Class and Notes. With Data Source History, you can filter and export data.

Export to Excel

To export your data source history to an Excel spreadsheet:

The data is saved in the same format as the filter. Upon opening the Excel file, you will see the data in a format similar to the ONESOURCE Tax Provision screen.

In the following example, the data is displayed by Date, and Change Type, with column headers. If you do not filter the data in ONESOURCE Tax Provision, you may need to sort the list in Excel.

Reset all saved settings

You have the ability to reset Data Source History by clicking your right mouse button and selecting the options in the menu.

Notes

For certain types of notes, Data Dimensions will populate the Note. You can add data to a note and/or change a note. The note will pre-populate with the data source name that has a secondary source.