ONESOURCE Tax Provision integration

Completing the sheets

Approach 1: Utilising the computational reconcialiation per taxonomy sheet

Insert the ONESOURCE Tax Provision integration sheets
The ONESOURCE Tax Provision integration sheets are developed by selecting
Insert
Insert sheet
ONESOURCE Tax Provision integration
.
Insert or Import OTP codes into Codes (L6)
Insert (via data entry) or import (via the Import type
ONESOURCE Tax Provision codes
) the OTP codes into the Codes (L6) sheet. Each code needs to include a
Code
and
Description
, and are entered into 5 separate blocks:
Permanent differences
Temporary differences
Tax loss temporary differences
After tax permanent differences
After tax temporary differences
Configure codes on the Code configuration (L7) sheet
Adjustments are split into separate blocks, mirroring the approach on the Computational reconciliation per taxonomy sheet.
Each adjustment on the Computational reconciliation per taxonomy sheet will display by default on the Code configuration (L7) sheet.
Select
Permanent difference code
or
Temporary difference code
for each.
This may be done by manually selecting or via import, using the Import Type
ONESOURCE Tax Provision code configuration
.
Users may view all adjustments for each section separately by selecting the
Show all?
selector for each block.
Allocate amounts in the Computational reconciliation per taxonomy sheet
Use the columns
Permanent difference
and
Temporary difference
to allocate permanent and temporary difference amounts.
The
Permanent difference code
and
Temporary difference code
columns are auto populated based on the configuration set on the Code configuration (L7) sheet.
Complete and review the remaining L sheets (L1–L5)
Enter amounts manually (Opening and Closing balances).
The relevant L sheets will populate the Movement in period based on the allocations and codes set.

Approach 2: Enter amounts directly onto the L sheets

Insert the ONESOURCE Tax Provision integration sheets
The ONESOURCE Tax Provision integration sheets are developed by selecting
Insert
Insert sheet
ONESOURCE Tax Provision integration
.
Set the switch
Display permanent and temporary difference allocation columns?
at the bottom of the Computational reconciliation per taxonomy sheet to No
Insert / Import OTP codes into Codes (L6)
Insert (via data entry) or import (using the Import Type
ONESOURCE Tax Provision codes
) the OTP codes into the Codes (L6) sheet. Each inserted code needs to include a Code and Description, and are entered into 5 separate blocks:
Permanent differences
Temporary differences
Tax loss temporary differences
After tax permanent differences
After tax temporary differences
Enter the amounts manually onto the following sheets.
L1 - Permanent differences
L2 - Temporary differences
L3 - Tax loss temporary differences
L4 - After tax permanent differences
L5 - After tax temporary differences

Reporting