Skip to main content

Legal

Tax & Accounting

Trade & Supply

Risk & Fraud

News & Media

Books

Developers

My Datasets

Spreadsheet Import (Dataset)

The
Spreadsheet Import (Dataset)
 lets you transfer your data (numbers) from a spreadsheet to a Dataset. There are two formats available to import dataset information:  Tax Provision Format and Rolling Pin Format.
Both formats let users with Read/Write access transfer data from an Excel spreadsheet to ONESOURCE Tax Provision.
  • The ONESOURCE Tax Provision format uses a template where data is divided into types of data on separate worksheets.
  • The Import Rolling Pin format utilizes codes entered to identify the type of data on a row and column.
To Spreadsheet Import data into a dataset:
  1. Select
    Import
    for a selected dataset to see the Import options.
  2. Select
    Spreadsheet Import (Dataset)
    . The
    Run Spreadsheet Import
     dialog box opens.

Choose Format(s) and File(s) to Populate the Dataset:

  1. Select
    OTP format
    , or
    import_rolling_pin
    .
  2. Select
    BROWSE
    , and select the file to import.
  3. Select
    Open
     and then
    ADD
    .
  4. Select
    NEXT
    .
  5. Select
    IMPORT
    .
  6. Select
    Refresh rpt data
     (optional). When you refresh the report data, the information in the report is current.
  7. To review the progress or log files for the import, select Jobs in the Tax Provision menu.

This article applies to:

  • PRODUCT: ONESOURCE Tax Provision