What is Selective Data?
There are currently two Selective Data upload scopes, (Ledgers to Extract) and (Years to Extract).
The Selective Data extraction scope is scaled down with its main purpose to only take the necessary data required from the client. This means that the user performing the upload will be providing a reduced amount of accounting information during the upload of their data.
Selective Data (Ledgers to Extract)
The Selective Data (Ledgers to Extract) product allows the client to limit the data extracted from the accounting package to the Accounts Receivables and Payables Ledger data as well as company metadata.
The extract and upload do not contain any data or information from the General Ledger, Trial Balance, Profit and Loss, or Chart of Accounts.
Selective Data (Years to Extract)
The Selective Data (Years to Extract) product allows you to choose how many financial years of data you want to extract from a client's database. This default value will affect all clients who use connectors that are currently compatible with selective data. The portal default can be overwritten to extract fewer or more years but not more than the maximum set.
If the product is enabled only clients using the specific connectors will be affected.
If the product is not enabled clients will not be affected.
The number of years can be changed per engagement as often as needed. Setting the number of years to extract should be done before a client has attempted their upload, this ensures Validis extracts the required years correctly. Should the client use data refresh, Validis will automatically update any new input on the extracted years.
Configuring Selective Data (Years to Extract)
To enable Selective Data, please have your portal administrator reach out to our account management team. We will require a value for the two below fields before an upload is attempted:
Years to Extract
This is the number of years extracted per portal and cannot go beyond the maximum. The range for this field is 0-5. The value 0 will only extract the current financial year.
Maximum Years to Extract
This number will limit the total years extracted and will not allow anyone to overwrite it. The maximum value for this field is 5 years.
The portal default for Selective Data can be overwritten on the engagement level, please see the below.
On the Engagements Dashboard click the ellipsis then select Edit Engagement.
Then under the Additional Settings, you can select either Choose the number of years or the Current financial year only.
When choosing the number of financial years please note that the year(s) selected will be extracted in addition to the current financial year.