Generating Custom Mapping

The TAR Automation 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 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. The UI will be empty the first time that it is displayed.
  3. On the TAR Automation UI, from the POV, click Account to display the Select Members dialog box. On the TAR Automation UI, click Account in the POV to open the Members Selector dialog box and 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

    Select Member dialog box
  4. Click the cell for each mandatory field to open the Member Selector, and select the appropriate members for each column:

    Table 25-1 TAR Automation Fields

    Mapping Column Name Description Mandatory
    National 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 Source Account Regional Select the name for each Member of the Regional source account. The Regional source account 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 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
  6. Click Save.
  7. From the Home Page, select Tax Provision National or Tax Provision Regional, then Package, and then click TAR.

  8. Under Actions, select Consolidate. The detail movements are displayed.