If you are looking for the Reportance Desktop help, please click here.

New Datasets & The Information Tab

Datasets - An Overview

The accounting industry is able to work with a myriad of different accounting systems because of the common system of double-entry bookkeeping. Reportance leverages this concept and uses the trial balance as the common language with which to communicate between all different systems.


A Dataset in Reportance is simply a trial balance from a particular accounting file or source, for a particular date range. For this reason, when setting up a dataset, we need to know two things:


1) The date range of the trial balance

2) The source of data for the trial balance


Reportance will also ask you to name this trial balance, so you can easily reference this in other areas such as Reporting or Workpapers. We suggest using a naming convention that gives you enough information to uniquely identify the trial balance within a given entity. For example, an entity where you have one accounting file and say a budget, you might name the trial balances something like:


2018 Actual

2019 Budget

2019 Actual

2020 Budget


Another entity might run multiple business divisions or stores through different accounting files, so you might use the following descriptions:


2019 Actual - Melbourne Store

2019 Actual - Sydney Store

2019 Actual - Consolidated (for the consolidation of the two stores)

2020 Budget - Melbourne Store

etc


To create a dataset, click on Add Dataset from the Client Info screen. This will take you to the Dataset screen where you can input the required details.


Create a New DataSet

To create a new dataset, first, open the relevant entity and click on New Dataset from the client information screen as shown below: 


To learn more about consolidation datasets see the knowledge article on Consolidations


The following fields are required to be entered when creating a new dataset. 

FieldDetailValidation
Name
A field which makes identifying the dataset easy. We recommend using a naming convention (e.g. 2019 Actual, 2020 Budget)
Required
Start DateThe beginning date for the dataset (i.e. trial balance)Required
End DateThe end date for the dataset (i.e. trial balance)
Required
Source*The source is where the information is coming from. I.e. MYOB, Xero. 

To add a new source select the source from the drop-down menu. 
If no source exists yet following knowledge article 
managing sources.

Required
Reporting Frequency (Only shown after selecting a Source)This identifies the interval that data is imported into the system. This enables journals and reporting to be done at different intervals.Required (Annual, Quarterly, Monthly)
Roll over opening balance (tickbox)This will automatically post opening balance journal entries into a dataset, this is useful when starting a new compliance year. I.e. 2019 you would roll over opening balances from 2019. 
Opening Balance Dataset (Only shown after selecting a Source)This is the dataset which opening balance journal entries will be imported from.
Required - if Roll over opening balance field is ticked

        * a source cannot be changed after it has been added to a dataset

After completing the form it is necessary to select the Load Data button.
This will "fetch' the data from the source. Using the dates and import frequency specified.  


Finally, select Save Dataset

Once a Dataset has been saved more sections will become available (Journals & Balances). For information on Journals and Balances see the knowledge article here. 


The information tab contains the same fields which are available under the Information tab after creating a dataset. 


Edit a Dataset

Navigate to the datasets tab of the entity file and select the dataset to be edited. This will open the dataset at the information tab. 



Delete a Dataset

Navigate to the datasets tab of the entity file and select the dataset to be deleted. This will open the dataset at the information tab. Select Delete from the bottom right-hand corner


WARNING: 

Deleting a dataset cannot be undone. 

Be extremely careful when deleting datasets. 


Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.