Verifying Worksheet Input for Export

A worksheet should be validated before exporting it to ONESOURCE Tax Provision to ensure the data has been mapped in the proper format. You have the option to validate and correct any errors prior to selecting Send Active Workbook to ONESOURCE Tax Provision.

Note: A worksheet will be validated once more when you select Send Active Workbook to ONESOURCE.

To validate the worksheet:

1.Open the a mapped worksheet.
2.In the Data Import ribbon, select Validate Data.

validate data 9.0

 

The Validating dialog box appears with a progress bar.

validating progress 9.0

 

3.If the worksheet is okay to export to ONESOURCE Tax Provision, a confirmation message appears.

Excel add in validatation no error

4.Click OK.
5.If there are errors on the worksheet, an Errors list appears, correct the errors and click Validate again.

validation error 9.0