Generating Custom Mapping

The TAR Automation and TAR Automation Book Balance UI enables you to map provision data to the new accounts added (that is, columns) that represent the company’s general ledger account structure for tax. When mapping data you must define the TARF account (that is, column) and movement (that is, row) to map the data.

The TAR Automation and TAR Automation Book Balance UI allows for more than one account to be displayed at one time during the mapping process. This enables the user to map both sides of the journal entry. For instance, you can view the current tax expense and the current tax payable detail in the same UI. This is useful when mapping data from the provision.

To select appropriate Source Accounts: National or Regional, you must select at least one. For each Account selected, scroll right to see the same set of columns.

To add detail accounts:

1. From the Home page, click Application, and then Configuration.
2. On the Configure screen, select TAR Automation.

   Note:

   To work on TAR Automation Book Balance, you must select the TAR Automation Book Balance tab from the TAR Automation screen. See Generating Default Mapping
   The UI will be empty the first time that it is displayed.
3. On the TAR Automation UI, from the POV, select the POV you require:
   • Account dimension - you can choose multiple accounts for the POV.

     Note:

     Although there is no limit on the number of accounts you can select, the more accounts you choose, the bigger the impact will be on processing time.
   • Scenario, Year, and Period dimensions - you can only choose one member for each.

   The POV selections are validated, and errors displayed if the following conditions exist:

   • If the selected member is not a child of TARF Accounts
   • If the selected member is not a base member
   • If the selected member has a function added
   
   
   
4. Click the cell for each mandatory field to open the Member Selector, and select the appropriate members for each column:

   Table 26-1 TAR Automation and TAR Automation Book Balance Fields

   Mapping	Column Name	Description	Mandatory
   No Jurisdiction	Source Account National	Select the name for each Member of the National source account. The National source account must be selected in order to perform consolidation.	Y
   	Exclude Account National	Select the member name of the detail account that is to be excluded from the National parent account on the TAR form to balance the entries during consolidation.	N
   Regional Accounts	Source Account Regional	Select the name for each Member of each Regional source account. The Regional source accounts must be selected in order to perform consolidation.	Y
   	Exclude Account Regional	Select the member name of the detail account that is to be excluded from the Regional parent account on the TAR form to balance the entries during consolidation.	N
   National/Regional	Data Source	Select the member name of the Data Source.	Y
   National/Regional	Movement	Select the member name of the Movement source.	Y
   National/Regional	Intercompany	Select the member name of the Intercompany source. Note: This is applicable only for TAR Book Balance and not for TAR Automation.	N
   National/Regional	Switch Sign	Click the Switch Sign checkbox if the sign of the data sourced from the current provision is +/positive to switch the sign to a -/negative to post the balance sheet side of the entry. Clear the Switch Sign checkbox if the sign of the data sourced from the deferred tax rollforward current provision is +/positive to switch the sign to a -/negative to post the deferred expense side of the entry.	N The default value is No.

5. Click Save. Scroll to the right to see the mandatory columns for each selected Account.

   The cells are validated and any rows with Validation errors will be highlighted, as follows:

   • For National Mapping, Data Source and Movement are required if the Source Account National is selected.
   • For Regional Mapping, Data Source and Movement are required if the Source Account Regional is selected.

   Custom Mapping for TAR Automation

   
   
   

   Custom Mapping for Tar Automation Book Balance

   

   Note:

   If you are using TAR Automation or TAR Automation Book Balance form from the library to generate Custom Mapping, it supports only member names.
6. Click Save.
7. From the Home Page, select Tax Provision National or Tax Provision Regional, then Package, and then click TAR or TAR Regional.
8. Under Actions, select Consolidate. The detail movements are displayed.