Modifying the Tax Account Rollforward Data Form

You can modify the Tax Account Rollforward data form to add new DataCategory columns that provide for the following functionality to be enabled:

  • Flow of Ending balances from current year to the next year

  • Book balances can be pulled into the new columns using the DataCategory BookAcctNat and BookAcctReg user-defined properties.

  • You can change the sign of the book balance using the SwitchSign user-defined property.

  • FX override rates for TARF Payments and Refunds apply to the new columns and can be used for currency translation.

Metadata Changes

In the DataCategory dimension, you can add additional details for TARF accounts using their parent member. For example, if you need an additional detail category for Current Payables, add a new member under the “TARFCurrentPayableTotal” parent member.

DataCategory User-Defined Property

You can use the SwitchSign user-defined property to specify the sign (+/-) for the book data flowing into the TARF Ending Balance per Book.

PropertyValue
Property NameSwitchSign
KeywordSwitchSign
UD FieldALL
Valid EntryYes or No
DefaultNo
ExampleTARFCurrentPayable: SwitchSign:No
DescriptionIf SwitchSign is set to No, the Book amount specified by BookAcctNat or BookAcctReg flows into Tax Account Rollforward.

If SwitchSign is set to Yes, the sign is changed accordingly (from plus (+) to minus (-), or vice-versa).

If the Switch Sign property is not specified, the default value is applied. If the source account is Revenue or Liability, the SwitchSign is applied; otherwise is not applied.

After adding the additional members to the DataCategory hierarchy, you must modify the TAR data form to add the new members, and manually enter data in the new columns.

Use these steps to update the TAR data form.

Note: The following steps assume that an additional member was added as a child of TARFCurrentPayableTotal.

Column Changes:

1. Create two additional columns, one for National and one for Regional:

C27=TT#National.DC#TARFCurrentPayable1,CustomHeaderStyle:white-space:normal
C28= TT{Entity Based Regional(@POV)}.DC#TARFCurrentPayable1, CustomHeaderStyle:white-space:normal

2. Adjust the column numbers accordingly after adding the above columns.

Row Changes:

1. Increase the column count in the Override() parameter, starting with row 24 through row 36.

R24=W#YTD.I#[ICP None].JD#Jurisdictions.A{TARFDeferredCY.[Base]}.P#@Cur.RF#TARFTotal,Override(25,33,Blank,Style:;background-color:silver;border-right:silver;border-bottom:silver),CustomHeader:;;;.;;,Override(35,37,Blank,Style:;background-color:silver;border-right:silver;border-bottom:silver)

2. Allow data input for the newly created member using the Override() parameter for TARF Payments and Refunds (TARFPaymentsPY, TARFPaymentsCY, TARFRefundsCY and TARFRefundsPY). You must also make this change for base accounts of TARFAdjustmentsManual.

Make the following changes to rows 6-18:

R6=W#Periodic.I#[ICP None].JD{Entity Based Domicile (@POV)}.A#TARFPaymentsCY.P{Periods to Current Period (@POV)}.RF#TARFTotal,Override(1,7,Blank,Style:;background-color:silver;border-right:silver;border-bottom:silver),CustomHeader:;;;.;.;,Override(9,23,Blank,Style:;background-color:silver;border-right:silver;border-bottom:silver),Override(25,25,RF#TARF_Input),Override(26,26,JD#AllRegional),Override(27,27,RF#TARF_Input),Override(28,28,JD#AllRegional),Override(35,37,Blank,Style:;background-color:silver;border-right:silver;border-bottom:silver)
R7=W#YTD.I#[ICP None].JD#Jurisdictions.A#TARFPaymentsCY.P#@Cur.RF#TARFTotal,Override(1,7,Blank,Style:;background-color:silver;border-right:silver;border-bottom:silver),CustomHeader:;;;.;.;.,Cell_Link1,Override(9,23,Blank,Style:;background-color:silver;border-right:silver;border-bottom:silver),Override(35,37,Blank,Style:;background-color:silver;border-right:silver;border-bottom:silver)
R8=W#Periodic.I#[ICP None].JD{Entity Based Domicile (@POV)}.A#TARFPaymentsPY.P{Periods to Current Period (@POV)}.RF#TARFTotal,Override(1,7,Blank,Style:;background-color:silver;border-right:silver;border-bottom:silver),CustomHeader:;;;.;.;,Override(9,23,Blank,Style:;background-color:silver;border-right:silver;border-bottom:silver),Override(25,25,RF#TARF_Input),Override(26,26,JD#AllRegional),Override(27,27,RF#TARF_Input),Override(28,28,JD#AllRegional),Override(35,37,Blank,Style:;background-color:silver;border-right:silver;border-bottom:silver)
R9=W#YTD.I#[ICP None].JD#Jurisdictions.A#TARFPaymentsPY.P#@Cur.RF#TARFTotal,Override(1,7,Blank,Style:;background-color:silver;border-right:silver;border-bottom:silver),CustomHeader:;;;.;.;.,Cell_Link1,Override(9,23,Blank,Style:;background-color:silver;border-right:silver;border-bottom:silver),Override(35,37,Blank,Style:;background-color:silver;border-right:silver;border-bottom:silver)
R10=W#YTD.I#[ICP None].JD#Jurisdictions.A#TARFPayments.P#@Cur.RF#TARFTotal,Override(1,7,Blank,Style:;background-color:silver;border-right:silver;border-bottom:silver),CustomHeaderStyle:font-weight:bold,CustomHeader:;;;.;;.,Override(9,23,Blank,Style:;background-color:silver;border-right:silver;border-bottom:silver),Override(35,37,Blank,Style:;background-color:silver;border-right:silver;border-bottom:silver)
R11=W#Periodic.I#[ICP None].JD{Entity Based Domicile (@POV)}.A#TARFRefundsCY.P{Periods to Current Period (@POV)}.RF#TARFTotal,Override(1,7,Blank,Style:;background-color:silver;border-right:silver;border-bottom:silver),CustomHeader:;;;.;.;,Override(9,23,Blank,Style:;background-color:silver;border-right:silver;border-bottom:silver),Override(25,25,RF#TARF_Input),Override(26,26,JD#AllRegional),Override(27,27,RF#TARF_Input),Override(28,28,JD#AllRegional),Override(35,37,Blank,Style:;background-color:silver;border-right:silver;border-bottom:silver)
R12=W#YTD.I#[ICP None].JD#Jurisdictions.A#TARFRefundsCY.P#@Cur.RF#TARFTotal,Override(1,7,Blank,Style:;background-color:silver;border-right:silver;border-bottom:silver),CustomHeader:;;;.;.;.,Cell_Link1,Override(9,23,Blank,Style:;background-color:silver;border-right:silver;border-bottom:silver),Override(35,37,Blank,Style:;background-color:silver;border-right:silver;border-bottom:silver)
R13=W#Periodic.I#[ICP None].JD{Entity Based Domicile (@POV)}.A#TARFRefundsPY.P{Periods to Current Period (@POV)}.RF#TARFTotal,Override(1,7,Blank,Style:;background-color:silver;border-right:silver;border-bottom:silver),CustomHeader:;;;.;.;,Override(9,23,Blank,Style:;background-color:silver;border-right:silver;border-bottom:silver),Override(25,25,RF#TARF_Input),Override(26,26,JD#AllRegional),Override(27,27,RF#TARF_Input),Override(28,28,JD#AllRegional),Override(35,37,Blank,Style:;background-color:silver;border-right:silver;border-bottom:silver)
R14=W#YTD.I#[ICP None].JD#Jurisdictions.A#TARFRefundsPY.P#@Cur.RF#TARFTotal,Override(1,7,Blank,Style:;background-color:silver;border-right:silver;border-bottom:silver),CustomHeader:;;;.;.;.,Cell_Link1,Override(9,23,Blank,Style:;background-color:silver;border-right:silver;border-bottom:silver),Override(35,37,Blank,Style:;background-color:silver;border-right:silver;border-bottom:silver)
R15=W#YTD.I#[ICP None].JD#Jurisdictions.A#TARFRefunds.P#@Cur.RF#TARFTotal,Override(1,7,Blank,Style:;background-color:silver;border-right:silver;border-bottom:silver),CustomHeaderStyle:font-weight:bold,CustomHeader:;;;.;;.,Override(9,23,Blank,Style:;background-color:silver;border-right:silver;border-bottom:silver),Override(35,37,Blank,Style:;background-color:silver;border-right:silver;border-bottom:silver)
R16=W#YTD.I#[ICP None].JD#Jurisdictions.A#TARFPaymentsRefunds.P#@Cur.RF#TARFTotal,Override(1,7,Blank,Style:;background-color:silver;border-right:silver;border-bottom:silver),CustomHeaderStyle:font-weight:bold,CustomHeader:;;;.;;.,Override(9,23,Blank,Style:;background-color:silver;border-right:silver;border-bottom:silver),Override(35,37,Blank,Style:;background-color:silver;border-right:silver;border-bottom:silver)
R17=Blank,CustomHeaderStyle:background-color:transparent;border-right:Transparent,Style:;Background-color:Transparent;Border-right:Transparent
R18=W#YTD.I#[ICP None].JD#Jurisdictions.A{TARFCurrentProvisionNational.[Base]}.P#@Cur.RF#TARFTotal,Override(1,7,Style:;background-color:#B2CBB6),CustomHeader:;;;.;;,Override(9,23,Blank,Style:;background-color:silver;border-right:silver;border-bottom:silver),Override(25,33,Style:;background-color:#B2CBB6),Override(35,37,Blank,Style:;background-color:silver;border-right:silver;border-bottom:silver)

3. Increase the override count so that TARFTotal is applied on the last column for total manual adjustments.

Make the following change to row 77:

R77=W#YTD.I#[ICP None].JD{Entity Based Domicile (@POV)}.A{TARFAdjustmentsManual.[Base]}.P#@Cur.RF#TARF_Input,Override(4,7,RF#TARFTotal.JD#Jurisdictions),Override(16,23,RF#TARFTotal.JD#Jurisdictions),Override(26,26,RF#TARFTotal.JD#Jurisdictions),Override(28,28,RF#TARFTotal.JD#Jurisdictions),Override(30,30,RF#TARFTotal.JD#Jurisdictions),Override(32,33,RF#TARFTotal.JD#Jurisdictions),Override(36,37,RF#TARFTotal.JD#Jurisdictions),Override(39,39,RF#TARFTotal.JD#Jurisdictions)

4. Adjust the override account for the remaining rows. Note that if you have added two additional columns, the override count is increased by 2 only when the new columns are in the override range specified on the rows.

5. Modify the following linked forms, which allow input into additional detail columns.

  • TAR - Reclass - Regional

    Insert a new column with the new DataCategory member.

    C9=DC#TARFCurrentPayable1,CustomHeaderStyle:white-space:normal
  • TAR - Payments & Refunds - Regional

    This step is only required if your Detailed column contains Payments and Refunds; otherwise, this step is optional.

    Copy the first two columns and change the column number accordingly, and change the DataCategory member in the newly pasted columns.

    C3=DC#TARFCurrentPayable1.P{Periods to Current Period (@POV)},CustomHeaderStyle:white-space:normal
    C4=DC#TARFCurrentPayable1.P#@Cur,Override(1,4,W#YTD),CustomHeaderStyle:white-space:normal,CustomHeader:.;YTD