Import data from ONESOURCE Statutory Reporting

Introduction

This topic helps you use the integration between ONESOURCE Statutory Reporting (OSR) and ONESOURCE Corporate Tax (OCT). The integration lets you transfer journal data from OSR to OCT for accurate tax calculations. By using this process, you can streamline financial reporting, improve data accuracy, and enhance tax compliance.
Prerequisites
  • Ensure you have access to OSR and OCT in the same ONESOURCE cloud region (such as EMEA or APAC).
  • Mark the
    OSR Integration
    checkbox in OCT Administration.
  • Align the financial period in OSR with the dataset period in OCT before importing data.

Prepare the journal data in OSR

  1. Open OSR.
  2. Select the entity with a defined financial period.
  3. Prepare trial balance journals and any adjustments for the selected entity.

Set up OCT for data import

  1. Open OCT and create a new calculation for the same tax year and jurisdiction as used in OSR. Use the required template.
  2. Make sure the financial period in OCT overlaps with the period in OSR.
  3. Ensure the chart of accounts in OCT matches the chart of accounts in OSR.
  4. Map the account codes to the tax targets within the required sheets.

Import data from OSR to OCT

  1. Create a new import job in OCT for trial balance import type.
  2. Select OSR as the data source and select the entity from the dropdown list.
  3. Select the financial period and select the journals linked to the reporting entity you want to import.
  4. Select the OCT entity from the list.
  5. Select
    Import
    to begin the import job.
    note
    The
    Append Existing
    option remains enabled for OSR imports so you can add data on top of previously imported data.
    1. After the import finishes, OCT will show a
      Data updates available
      notification in an open calculation.
  6. Select
    refresh
    to view and verify the imported data.