Home

ONESOURCE TAX PROVISION

1. Custom JE Reports Configurable JE Reports Output JE Other Reports m Cash Payments ESSENT ERERESESHRRRENSNVMRURNUKNREN RERSRESERSEREKSRREKENRUSNE Balance Sheet Offset Summary E Foreign Domestic Summary State Summary Expected Deferred Rate State Summary Provision Summary 2010 Thomson Reuters ONESOURCE Parameters Contents keene becoeceeecgeceGictenctenc concen scgeeoccecceuencecvensccnectectacacssesdcauecsscaitetts cove aoaaa raiar iaaeaie aaa a aaia 47 Year to Date Reporting 47 TS Database Analyzer
2. 75 Scr lhcl 1 1 136 DERa Si cR RR e RR SS 76 Federal NOL Automation 77 Currency Translation Adjustment 78 WERE 78 Alternative IFRS 79 Return to Provision eniin etnia rnnt etin bunt pesante naa Fin dee ee eee 80 Global Access formerly iTaxStream 82 General Configurations Cr ELE 83 Regional Settings ONERE 85 Part 4 Administration 87 NIOMA naaa pet rer tre Terre errr reer errr re 87 2010 lt 3 ONESOURCE Parameters Contents Password Options 88 Read Write Usal Sceire M 89 Tax Adjustment Code Restri
3. 47 Formatting o A AA Q 48 Report Headers Footers PESEE PA OEI E EA AA A L 48 Page WIE RR 49 Report Format for Excel EAE A EEEE P E A PA E E E E EE T E E E E 49 Part 3 Functionality 50 APIC Pool T 50 Alternative Minimum 51 Temporary DIGIBIIBBS ett mai edt 51 Payable 53 Autoposting 54 Bucket Configuration 56 60 Valuation 68 Bridge nS 72 Estimated Payments M 73 Mass Update IET
4. p Defines the payable bucket to which Foreign Units State Tax pranu Code Adjustments with codes NC_RTP and NC_ATR post Administration Manage DataSet Parameters Warning Changes may impact your calculations Key ADVLIABPOSTING Alphanumeric Yu PAYABLE_CPRO V_DOM_BUCKET Alphanumeric 9001 PAYABLE DOM STATE BLICKET Alphanumeric 9003 PAYABLE FOR BLICKET Alphanumeric 9001 PAYABLE_CPROV_FOR_STATE_BUCKET Alphanumeric 9003 PAYABLE RTP DOM BLICKET Alphanumeric 9002 PAYABLE_RTP_DOM_STATE_BUCKET Alphanumeric 9004 PAYABLE RTP FOR BLICKET Alphanumeric 9002 PAYABLE RTP FOR STATE BLICKET Alphanumeric 9004 2010 Thomson Reuters Parameters Functionality Unit Dataset Parameter Function If a specific unit should post to a different bucket you can configure this with a unit dataset parameter Key Key Type Key Value Description Payable Defines the payable bucket to which a unit s Current PAYABLE CPROV BUCKET Alphanumeric Bucket Cash Provision posts This overrides any payable Code bucket configuration done at the dataset level Payable Defines the payable bucket to which a unit s Tax PAYABLE RTP BUCKET Alphanumeric Bucket Adjustment Wl Te Ne ATE Or NG code posta Code This overrides any payable bucket configuration done at the dataset level ADMINISTRATION MANAGE UNIT DATASET PARAMETERS Warning gt gt Changes may irapact your calculations lt lt W
5. Note When adding a dataset parameter manually the following message displays This change will potentially impact your calculations Are you sure you want to proceed This message alerts you to the fact that you can potentially change the way the 6 2010 Thomson Reuters ONESOURCE Parameters Introduction system displays amounts If you want to ensure the integrity of the data you can either make a copy of the dataset or export the dataset before changing the parameter 2 Reports This section of the parameters discusses parameters needed to activate specific reports and reporting features 2 1 Tax Provision Various features of the Tax Provision report are enabled by parameters Stored Procedure Report 8 Allows adjustments and defines the state detail that displays CSC Breakout 19 Activates the brkout view option Detaill 12 Displays a breakout of the Pre Tax Book Income by Trial Balance Line detail GAAP to STATI 13 Inserts rows representing GAAP and STAT adjustments 2010 Thomson Reuters ONESOURCE 2 1 4 Tax Provision Stored Procedure System Parameter Function Parameter USE SPPROVISIONREPORTS PROVISION HIDE STATES Value 0 or 1 0 or 1 Parameters Reports Description 1 activates the Stored Procedure view of the Tax Provision report The consolidated and sub consolidated level reports display the Unit Breakout onscreen instead of requiring an export of data to Excel
6. 1 also activates the Tax Provision CSC Breakout view report For more information refer to the Tax Provision CSC Breakout 1 section The Stored Procedure view of the Tax Provision report displays the unit PTBI with adjustments if the 12 dataset parameter is also used For more information refer to the Tax Provision Detail 12 section Also shows the state by state breakout of the Total Deductible State Tax in the Detail view as well as the breakout of the State Tax Provision components State Current Tax Provision State Deferred Tax Provision and State Equity Adjustment 1 adjusts the Stored Procedure view of the Tax Provision report so that it does not display the state by state breakout of the Total Deductible State Tax in the Detail view 2010 Thomson Reuters ONESOURCE Parameters Reports Sample Report SubC onsolidated Provision Report USD summary breakout Other TaxStream Division 1 unt breakout companzon UP TER Pre Tax Book income 4578596 Pre Tae Book _ 2 371210 5322 Deductble Stale Tax 377132 PAD 7500 SCTP Sie Orreri Proven 377 132 SDP 1 445 SEA Sirte Egutty Adiisimerd Total Provision 375 27 Total Provision 208233 Effective Tax Fate 44 7335 2010 Thomson Reuters
7. SUMMATION COLUMN 24 DEF RF SUMMATION NAME 24 EFFRATEBRKOUT 16 FEDBENEFITOFSTATE 23 FILTER NAME 27 FILTER _SQL 27 FORMAT FOR EXCEL 48 GAAP to STAT 13 gstags 13 PRINTFORMAT PAGESWIDE 48 PROVISION HIDE STATES 8 REPORT FOOTER 48 REPORT HEADER 48 SHOW ACCRUAL 47 SHOW CASHPYMTS 41 SHOW DEFBALCSCBRKOUT 31 SHOW EFFRATECONSOLPTBIPCT 20 SHOW EFFRATECSCBRKOUT 20 SHOW EXPECTEDDEFERRED 44 SHOW GAAPTOSTAT 13 SHOW WORKPAPER 29 USE SPDEFBALREPORTS 24 USE SPPROVISIONREPORTS 8 10 USE SPPROVSUMMARYREPORTS 45 Reporting Currency 54 78 85 Reporting Currency approach 51 Reports 7 47 APIC Pool Summary 50 Balance Sheet Offset Summary 40 42 Cash Payments 40 41 98 Index Deferred Balances 23 24 27 31 Deferred Workpaper 29 Effective Tax Rate 16 20 40 Effective Tax Rate CSC Breakout 20 Expected Deferred Rate State Summary 44 Federal Est Pymt 73 Federal Est Pymt Summary 73 Foreign Domestic Summary 43 Foreign Domestic Summary 40 Journal Entry Support FG 36 Journal Entry Support Unit 36 Output Journal Entries 36 Payable Detail 53 Payable Rollforward 53 Provision Journal Entry 36 Provision Summary State Summary 45 State Est Pymt 73 State Est Summary 73 State Summary Expected Deferred Rate 40 Tax Provision 7 8 10 12 Tax Provision GAAP STAT 13 Temp Diffs Summary 23 YTD 47 Return to Provision 80 80 RTP Adjustments 80 RTP Parameters BSORTPTAG 80 DORTPTAG 80 POST BSO
8. Book Depreciation 0 74000 Accrued General and Admin Expense 4 000 VA SYS PTTD C VA_SYS_PTTD_C 0 SYS PTTD NC VA SYS PTTD NC 0 Subtotal Temporary Differences 3 980 NOL Temporary Differences NOL 002 Net Operating Loss 45 000 VA SYS NOLTD C VA SYS NOLTD C 0 SYS NOLTD NC VA SYS NOLTD NC 0 Subtotal NOL Temporary Differences 45 000 Subtotal FED Federal Jurisdiction BS Blended State Temporary Differences 714000 Book Depreciation 0 T4000 Accrued General and Admin Expense 4 000 Subtotal Temporary Differences 4 000 Beginning Balance Pre Tax Tax Effected Effective Rate 13 500 13 500 14 694 30 0096 30 00 0 00 0 00 10 090 6 000 16 090 Ending Balance Overrides 3 027 1 800 4 821 19 500 19 500 24 321 30 00 30 00 30 00 30 00 30 00 D 1 30 00 N 0 00 0 00 0 00 0 30 2010 Thomson Reuters ONESOURCE Parameters Reports 2 3 5 Deferred Balances CSC Breakout System Parameter Function Parameter Value Description 1 activates the csc brkout view option for the Deferred Balances report in the Subconsolidated reporting level This option allows you to see the CSC breakout in addition to the unit by unit breakout for each column in the report This report defaults to non current positions Select the all view option to see current and non SHOW_DEFBALCSCBRKOUT 0 or 1 current positione For this fun
9. Please contact your Administrator Notes e A paramvalue of 0 makes Active Workpapers read only for Read Write users e Active Workpapers is license driven functionality Refer to the Corporate Edition user manual for more information 2010 Thomson Reuters 93 ONESOURCE A Active Workpapers Parameters AWP WRITE 93 51 Additional 78 Additional Paid in Capital 50 Adjustment Column 23 Alternative 78 79 Alternative Minimum Tax 51 Alternative Minimum Tax Parameters FATTD Prefix USE OLD AMTESTIMATOR 51 USE OLD AMTESTIMATOR Default 51 AMT 51 AMT Calculation 51 AMT Parameters FATTD Prefix USE OLD AMTESTIMATOR 51 USE OLD AMTESTIMATOR Default 51 50 Pool Parameters ENABLE APICPOOL 50 Auto Posting 54 B Backup 5 Batch Print 87 Bridge Parameters BRIDGE ALLOW ALL UNITS 72 BRIDGE ALLOW SUBCON SELECT 72 BRIDGE ALLOW UNIT SELECT 72 94 Parameters Index BRIDGE DEFAULT TAG 72 SHOW BRIDGEUNITMAP 72 C Codes NC RTP 20XX PERM 80 NC RTP 20XX TEMPS 80 Configurable JE Reports 36 Core System Parameters 5 CSC 7 10 20 31 CSC Breakout 7 23 CTA 78 CTA Parameters ALT CAL 79 SHOW CTA 78 Currency Parameters ALLOWMULTICURRENCYREPORTS 85 ReportingCurrencySymbol 85 Currency Translation Adjustment 78 Custom JE Reports 36 Custom Sub Consolidation 10 20 Custome Sub Consolidation 31 Dataset Parameters 5 6 AdvLiabPosting 54 AWP WRITE 89 93
10. Provision Est Pymt Inkerirr Administration Help Custon Custom Custom Control Center dataset 2009 Current Provision wt gt sue subcom Domestic Fiscal Year Jurisdiction TxnBucket Amount EntryDate F Rate currency Reporting Currency hat Navigator 4 Data Review Administration Active Workpapers 2 1 Federal 22000 8 1 Administration Unit Dataset Journal Entries Post Ret to Prov gj Active Workpapers Unit Details APIC Pool Amounts 22 Perm Diffs 21 Amortized Perm Diffs Temp Diffs 21 Amortized Temp Diffs 22 AT Temp Diffs 21 Amortized AT Temp Diffs 2 Tax Adis NOL Temp Difts i P erCo Txn Entry 2211 Trial Balance Tax Basis 66 2010 Thomson Reuters ONESOURCE Parameters Functionality Amounts Received at the Parent Level Est Pymt interim Contral Center dataset 3008 Curent Provision s state ates subcon Domestic currency Reporing Gurency Navigator 2008 2008 12 Data Review EHE DataSet _ Recalc Payable Reclass w Administration gj Active Workpapers E Federal D1000 Perm Diffs Amortized Perm Diffs Amortized Temp Diffs AT Temp Diffs NOL Temp Diffs 21 Trial Balance Tax Basis Administration Maly Custom Custom Cu
11. FERC 23 Filtered Deferreds 23 Footers 48 Foreign Domestic Summary Report Parameters Prior Year 43 GAAP to STAT 7 95 ONESOURCE Global Attachments Parameters GLOBAL XSL 35 GLOBAL XSL BROWSEUPDATE 35 GLOBAL XSL SAVEAS 35 H Headers 48 IFRS 78 79 Import Categories Spreadsheet Template CP Parameters 5 Import Numbers Spreadsheet Template DP Dataset Params 6 UDSP UDS Params 6 USDSP USDS Params 6 Import Numbers template 87 International Financial Reporting Standards 78 ds JE 35 Journal Entry 36 Configurable 35 Custom 35 Journal Entry Parameters GLOBAL XSL 35 GLOBAL XSL BROWSEUPDATE 35 GLOBAL XSL SAVEAS 35 JE AUTOCREATE OUTPUTJES 36 JE AUTOREGEN TAXCALCS 36 JE CALCULATE ENTRIES 36 96 Parameters Index JE COMPONENT FILTER FEDERAL XXX 36 JE COMPONENT FILTER STATE XXX 36 JE COMPONENT ROLLUP SET CODE 36 JE DATASET DELETE ALL 36 JE_FILTER 36 JE FILTER 36 JE ROUNDING DECIMAL PLACES 36 JE SHOW ZERO BOOKCALCS 36 JE SHOW ZERO TAXCALCS 36 JE STATE GROUP 96 36 JE STATE GROUP NAME 36 JE Supplemental Label 1to 9 36 JE TAG GROUP NAME 36 JE TAG GROUP TAGS 36 JE TYPE LOCKED 36 JE UNIT DELETE ALL 36 SHOW JE 36 SHOW OUTPUTJE 36 USE SPOUTPUTJEREPORTS 36 L License 36 Loc Loc Log al 85 al Currency approach 51 in Parameters LockoutMinutes 88 MaxFailLogins 88 PassHistNum 88 TSPasswordExpireDays 88 TSPa
12. ONESOURCE Parameters Reports 2 1 1 4 Tax Provision CSC Breakout The USE SPPROVISIONREPORTS 8 system parameter activates the Tax Provision report CSC Breakout view The custom sub consolidation view of the Tax Provision report allows the data of a parent sub consolidation to be broken into child sub consolidations To create a Custom Sub Consolidation 1 In the Unit Sub Consolidations screen under Manage Units in the Administration tab create a parent sub consolidation by entering a name beginning with CSC _X_ in the Description field You can define multiple breakout scenarios by creating multiple parents 2 Add units to the parent sub consolidation by selecting appropriate Unit Codes and clicking the update button 3 Create child sub consolidations beginning with CSC _ and add the appropriate units All units designated in the parent sub consolidation must be included in a child sub consolidation Note Each unit within the parent sub consolidation can only belong to one child sub consolidation In the following example D1000 02000 F1000 and F2000 can only belong to one child sub consolidation either 5 1 Domestic or CSC1 Foreign CSC1 X Worldwide CSC1 Domestic CSC1 Foreign D1000 x x D2000 x X F1000 x X F2000 x X 10 2010 Thomson Reuters ONESOURCE Parameters Reports Sample Report SubConsolidated Provision Report KRW 2009 Current Provision A Development and Testing License CSC1 X Worldwide TO
13. STATE FBOS FEDBENEFITOFSTATE Alphanumeric FED or STATE view option Report View Options Standard Rollup NOL Rollup Current Non Current Classification default Standard Rollup NOL Rollup Current Non Current Classification default summary hybrid detail unit summary hybrid detail unit pre tax pre tax Federal State FBOS Federal State FBOS Federa FBOS Federal State FBOS Federal State FBOS 4 State FBOS a al7c7ne contracted expanded b s contracted expanded bis 2010 Thomson Reuters 23 ONESOURCE 2 3 2 Deferred Balances Adjustment Column System Parameter Function Parameter USE SPDEFBALREPORTS DEF RF SUMMATION COLUMN DEF SUMMATION NAME 24 Value 0 or 1 2 through 26 Text Parameters Reports Description 1 activates the Stored Procedure view of the Deferred Balances The Stored Procedure provides an alternate view and additional functionality The expanded view displays onscreen vs exporting to Excel When using this parameter use the DEF RF SUMMATION COLUMN and DEF RF SUMMATION NAME parameters to display adjusted beginning balances This parameter only works when the USE SPDEFBALREPORTS parameter is activated and the DEF RF SUMMATION NAME parameter is defined Allows you to designate the position for the sub total column in the Deferred Balance report This column adds beginning deferred balances with rate changes and prior columns in the expanded b s
14. Tax Temp Diffs State Tax Adjustments State After Apportionment Temp Diffs NOL Temporary Differences Payable Transactions Payable Transaction Buckets Payable Transaction Rollups 37 ONESOURCE Parameters Reports Number of places to which calculated journal entries JE ROUNDING DECMAT PLACES Any mom are rounded The default value in the calculation 6 to 6 procedure is 2 no rounding 1 indicates that zero dollar Book calculations display JE SHOW ZERO BOOKCALCS 0 or 1 on Output Journal Entries reports JE SHOW ZERO TAXCALCS 1 indicates that zero dollar Tax calculations display Output Journal Entries reports 1 displays the Delete all Journal Entries menu JE DATASET DELETE ALL 0 or 1 option in the Provision tab under Data Revew gt Dataset gt Administration 1 activates the Delete button on the Journal JE UNIT DELETE ALL 0 or 1 Entries screen 1 prevents the JE Type field on the Journal Entries JE TYPE LOCKED 0 or 1 screen from being editable after a journal entry configuration is saved 38 2010 Thomson Reuters ONESOURCE Parameters Reports The following parameters are used to add items by various means filters tag groups etc to the Tax Calculation drop down list on the Journal Entries screen JE FILTER JE FILTER JE TAG GROUP NAME JE TAG GROUP TAGS JE COMPONENT ROLLUP SET CODE JE STATE GROUP NAME JE STATE GROUP 96 STATE 2
15. Unit Rate Effective Rate Report USD 2008 Provision TaxStream F3000 UK 2 2010 Thomson Reuters 19 ONESOURCE Parameters Reports 2 2 1 Effective Tax Rate CSC Breakout System Parameter Function Parameter Value Description 1 activates the Effective Tax Rate ETR CSC Breakout report For this functionality SHOW EFFRATECSCBRKOUT 0 or 1 to work you must create subconsolidations using the coding convention X Every unit must be assigned to a CSC _ subconsolidation 1 adds a line to the report that shows subconsolidated tax as a percentage of SHOW EFFRATECONSOLPTBIPCT Oori consolidated This parameter works in conjunction with the SHOW EFFRATECSCBRKOUT parameter The custom sub consolidation view of the Effective Tax Rate report allows the data of a parent sub consolidation to be broken into child sub consolidations To create a Custom Sub Consolidation 1 In the Unit Sub Consolidations screen under Manage Units in the Administration tab create a parent sub consolidation by entering a name beginning with CSC _X_ in the Description field You can define multiple breakout scenarios by creating multiple parents 2 Add units to the parent sub consolidation by selecting appropriate Unit Codes and clicking the update button 3 Create child sub consolidations beginning with CSC _ and add the appropriate units All units designated in the parent sub consolidation must be included in a child sub cons
16. and Temp Diffs Summary with the extension Other AND TDA Code NOT like FILTERS SQL VA AND TDA Code NOT like NOL The SQL query filters the data for TDA codes that do not start with either or NOL and displays them in reports with the extension above 28 2010 Thomson Reuters ONESOURCE Parameters Reports Sample Reports in the Navigator The Navigator has the following options for the filtered items based on the parameters entered Home Data Review Data Import Reports Unit 01000 Tax Provision Effective Tax Rate Deferred Balances Deferred Balances Valuation Allowances Deferred Balances NOL Deferred Balances All Other NOL Balances Temp Diffs Summary Temp Diffs Summary Valuation Allowances Temp Diffs Summary NOL Temp Diffs Summary Other 2 3 4 Deferred Balances Workpaper System Parameter Function Parameter Value Description 1 activates the Deferred Workpaper report which displays details about beginning SHOW_WORKPAPER 0 or 1 and ending deferred balances on a pre tax and post tax basis as well as the deferred tax rate for federal and state balances 2010 Thomson Reuters 29 ONESOURCE Parameters Reports Sample Report Workpaper Summary Report KRW KRW 2009 Current Provision A Development and Testing License F2000 UK Corporation Jurisdiction FED Federal Temporary Differences 713000 Bad Debt Reserve 20 714000
17. can automatically post to the payable by activating a dataset parameter Dataset Parameter Function Key Key Type Key Value Description Allows for current provision amounts to post to the payable in the dataset Y posts at the filing group level YU posts at the unit level even if the unit is in a filing group Note YU is available in versions 5 0 57 and higher AdvLiabPosting Alphanumeric N Y or YU e N turns off the posting Any prior amounts automatically generated remain but do not change as the provision calculation changes Note Enable the SHOW ADVANCEDLIABILITY 5 system parameter with a paramvalue of 1 before using the AdvLiabPosting parameter 0 uses the filing parent s Weighted Average FX rate for autoposted payable entries PAYABLE FXRATE CALC Alphanumeric 0 or 1 1 calculates the Weighted Average FX rate used for autoposted payable entries The Weighted Average FX rate calculation is the sum of all Cash National Provisions in Local Currency divided by all Cash National Provisions in Reporting Currency 54 2010 Thomson Reuters ONESOURCE Parameters Functionality Auto Posting When automatic posting is turned on amounts post in the Payable according to the following Provision Amounts that Post to the Payable Payable Txn Code Activity with Tax Adjustment Code NC_ATR_YEAR_NAME eg NC_ATR_2006_AUDIT SETTLEMENTS Posts Non Cash Tax Adjustment to NC OTHER YEAR NAME eg NC OTHER 2006 48 P
18. includible for State 713000 Bad Debt Reserve 20 714000 Book Depreciation 100 74000 Accrued General and Admin Expense 2 000 Total Temp Diffs includible for State 2 120 Temporary Difference Adjustments 0 0 Allocable Income 3 007 660 State Apportionment 100 00 Apportionable Income Pre NOL 3 007 660 F2000 3 000 000 5 540 5 540 100 2 000 2 120 3 008 220 100 00 3 008 220 F2000 UK Corporation UK Corporation UK Corporation California New Jersey 3 000 000 5 540 5 540 20 100 2 000 2 120 3 007 660 100 00 3 007 660 46 2010 Thomson Reuters ONESOURCE 2 6 Features Parameters Reports This section includes parameters for report features such as Year to Date reporting and TS Database Analyzer 2 6 1 Year to Date Reporting System Parameter Function Parameter SHOW ACCRUAL 2 6 2 TS Database Analyzer System Parameter Function Parameter SHOW_DATABASEANALYZER 2010 Thomson Reuters Value Oor 1 Value 0 or 1 Description 1 activates the Year to Date YTD reporting functionality This parameter allows you to enter YTD Accrual Factors and YTD PTBI for a unit in the Misc section of the Unit Details screen These factors are used to generate reports that display under the Unit Consolidated and SubConsolidated reporting levels in the YTD Reports option Description 1 activates the TS Database Analyzer menu option in the Provision
19. posting tag of Q 81 ONESOURCE Parameters Functionality 3 13 Global Access formerly iTaxStream Parameters can activate functionality that configure the user s instance of the system for tracking reports user rights questionnaire items etc For more information about adding these parameters contact ONESOURCE Tax Provision Support 54 or your client manager 82 2010 Thomson Reuters ONESOURCE 3 14 General Configurations System Parameter Function Parameter Value 1 Show and DISABLE DEFERREDPROVONLY Disable or 2 Remove CC DISABLE STATES or 1 DISABLE RDS CONSTRAINTS 0 or 1 2010 Thomson Reuters Parameters Functionality Description Modifies the Deferred Provision Only Adj field on the PTBI section of the Unit Details screen 1 displays Deferred Provision Only box but the ability to enter amounts either manually or via Import is disabled However amounts entered before the parameter was activated display 2 removes the Deferred Provision Only box entirely from the screen 1 removes pre defined states The Control Center drop down list for states only displays user defined states that have been created in the States screen under Manage States in the Administration tab The pre established states 50 states NYC AO DC and BS do not appear in the drop down list However If a smaller selection of states that exists in the pre defined states should be viewed they should be added
20. 0 Thomson Reuters Value A number Value 0 or 1 Parameters Reports Description Enter the total number of pages for printing a report in landscape format If the parameter is not activated reports shrink to fit on one page Description 1 treats all codes as text when they display in reports The code in Excel is preserved when it has a leading zero e g 005335 resembles scientific notation e g 77E 00001 Without this parameter the leading zero is dropped For example the code 005335A would export as 5335A and the code 77E 00001 would export as 7 7 49 ONESOURCE Parameters Reports 3 Functionality The Functionality sections discusses parameters that activate and affect various functions in the system such as Payable Mass Update Rates and Alternative Minimum Tax 3 1 APIC Pool System Parameter Function Parameter Value Description ENABLE_APICPOOL 1 activates both the Pool Amounts screen under Data Review gt Federal the APIC Pool Summary report Note The APIC Pool tracks the Additional Paid In Capital related to the recognition of the difference in deductions taken for stock options for book vs tax You can track the accumulation of excess benefits windfalls to measure future excess detriments shortfalls to ensure the proper treatment 50 2010 Thomson Reuters ONESOURCE 3 2 Alternative Minimum Tax System Parameter Function Parameter Value USE OLD AMTES
21. 00055 811 924 5 5247 TADJ Tax Adjustments 0 0 0000 0 0 0000 0 0 0000 0 0 0000 0 0 0000 ATTO Temporary Differences 0 0 0000 0 000096 5 0000096 0 00000 0 0 000096 Deferred Provision Only Adj 0 0 000096 0 0 000096 0 0 0000 0 00000 0 0 0000 Totat 457 068 44 066836 254 706 43 688896 108 854 41 076866 54 726 48 9740 586782 49 6703 2010 Thomson Reuters 21 ONESOURCE Parameters Reports ETR Report with both the SHOW_EFFRATECSCBRKOUT and the SHOW_EFFRATECONSOLPTBIPCT parameters SubConsolidated Effective Rate Report USD summary detai contracted expanded 2006 Full Year TaxStream CSC1 X Domestic TOTAL CSC1 East CSC4 Worth CSC1 South CSC1 West Component TaxEffect Rate Effect TaxEffect Rate Effect Rate Effect Rate Effect PTEI TaxEffect Rate Effect Pre Tax Book Income 51037216 363 026 35 0000 5557550 205 748 35 0001 265 000 92 750 35 0000 59 650 53 378 35 0052 174 716 61 150 349997 st State and Local come Taxes 558 511 5 6412 539 810 6 7721 16 104 6 0770 3560 5 80315 2 037 1 1659 Effect of Rates Difterent than Statutory 9 221 0 8890 50 0 0000 50 0 0000 50 0 0000 59 221 5 2777 PD Permanent Differences ex Equity Adis 14 386 1 3870 11 148 1 896456 59 0 0000 3788 81658 2 450 1 4023 TD Temporary Differences 50 0 0000 50 0 0000 50 0 0000 0 0 0000 50 0 0000
22. 010 Thomson Reuters Temporary Difference Code Name of the filter group such as Depreciation Tag group name A group of tags separated by commas Example F M Q Component rollup set code of the rollup group Example R99 State group name State code can be any number from 1 9 Filters add items to the Tax Calculation drop down list on the Journal Entries screen The Base filter group contains the amount left over after all filters have been applied can be any number from 1 9 Filters add items to the Tax Calculation drop down list on the Journal Entries screen can be any number from 1 9 Tag groups add items to the Tax Calculation drop down list on the Journal Entries screen can be any number from 1 9 Tag groups add items to the Tax Calculation drop down list on the Journal Entries screen Rollup groups add items to the Tax Calculation drop down list on the Journal Entries screen Use the Manage Rollups screen to create rollup sets and groups can be any number from 1 9 State groups add items to the Tax Calculation drop down list on the Journal Entries screen 9e can be any number from 1 9 and can be any number form 00 99 State groups add items to the Tax Calculation drop down list on the Journal Entries Screen 39 Reports ONESOURCE Parameters Unit Dataset Parameter Function Key Key Type Key Value Description JE CALCULATE ENTRIES Oori 1 i
23. 1 adds more information fields about a user email phone number etc in the SORS Administer Users screen under System in the Administration tab 1 restricts the use of Batch printing and the Import Numbers template to correspond to assignments made for a user in the in the Administer Users screen under System ExtendedUserRestriction 0 or 1 in the Administration tab The user is restricted to batch printing reports and importing data on the Import Numbers template for datasets units and subconsolidations that are assigned to them 0 specifies that all user logins are case sensitive CASE INSENSITIVE LOGIN 0 or 1 ul 1 specifies that all user logins are not case sensitive 2010 Thomson Reuters 87 ONESOURCE 4 2 88 Password Options System Parameter Function Parameter TSPasswordExpireDays TSPasswordM inDigits TSPasswordM inLength Lockout Minutes MaxFailLogins PassHistNum Value Number Number Number Number Number Number Parameters Administration Description Number of days until the user must reset the password to log in to the system The value must be greater then zero Minimum number of numbers in a user s password The default is 1 Minimum number of all characters letters and numbers in a user s password The default is 6 Number of minutes a user is locked out of the system after they have reached the maximum number of failed login attempts Maximum numbe
24. 17 000 453290 15 340 000 17 00 0 30 628 150 000 0 NOLTD NOLs 0 0 00 0 000 0 0 00 0 0 00 0 TADJ Tax Adjustments ex Equity 0 0 00 0 0 00 0 0 00 0 0 00 0 ATTD After Tax Temporary Differences 210 000 3 11 85 000 4 25 0 125 000 NIA 0 DPOA Deferred Provision Only Adj 0 0 0096 0 0 0096 0 0 NA 0 Total 27 569 174 201 408015 7396 2 060 752 103 04 15 000 NIA 27 565 483500 1 500 18 2010 Thomson Reuters ONESOURCE Parameters Reports Unit ETR Report Reconciling to Group Rate Effective Rate Report USD 2008 Provision TaxSneam F3000 UK 2 Component Rate Etfect Component Income 400 090 140 000 35 0000195 Pre Tax Book income 400 000 State and Local income Taxes 0 9 0o00 St Stele and Local Income Taxes ards Effect of Rates than Statutory 8 000 2 000096 Effect of Rates Ditferent than Statutory PD Permanent Differences ex Ads 0 0000 Ditterences Equity Temporary DiTferences 10 500 2 5500 707 Temporary Differences NOLTD NOL amp D 0 0000 NOLTD TADJ Tox Adjustments n 0 00006 TADJ Tax ATIC Atter Tax Temporary 0 0 0000 Attar Tax Temporary Differences DPOA Deterred Provision Only Adi 0 0000096 DPOA Deferred Provision Only Adi 34 3500 Total Tota 137 400 Unit ETR Report Reconciling to
25. 80 POST DO 80 POST STATE 80 RTPTAG 80 SHOW POSTRTP 80 2010 Thomson Reuters ONESOURCE NS Screens Administer Users 87 APIC Pool Amounts 50 Bridge Import 72 Deferred Analysis 51 Global Attachments 35 Journal Entries 36 Manage Countries and Currencies 75 Manage Deferred Rollforwards 24 51 Manage Rollups 36 Manage States 75 Manage Tags 13 Payable Entry 53 Post Ret to Prov 80 States 83 Unit Details 68 83 Unit Mapping 72 Unit Sub Consolidations 10 20 31 Scrunch Functionality 76 Scrunch Parameters SCRUNCH_TAG 76 SQL queries 27 47 Stored Procedure 7 System Parameters 5 ALLOWMULTICURRENCYREPORTS 85 BRIDGE ALLOW ALL UNITS 72 BRIDGE ALLOW SUBCON SELECT 72 BRIDGE ALLOW UNIT SELECT 72 BRIDGE DEFAULT TAG 72 BSOS XXX 42 CASE INSENSITIVE LOGIN 87 2010 Thomson Reuters Index CC DISABLE STATES 83 85 CLIENTDISPLAYNAME 48 DEF RF SUMMATION COLUMN 24 DEF RF SUMMATION NAME 24 DefEndBalDefault 51 DISABLE DEFERREDPROVONLY 83 DISABLE RDS CONSTRAINTS 83 EFFRATEBRKOUT 16 ENABLE APICPOOL 50 ExtendedUserRestriction 87 NAME 27 SQL 27 FISCAL MONTHS OFFSET 53 FORMAT FOR EXCEL 48 49 GAAPTOSTAT 13 GLOBAL XSL 35 GLOBAL XSL BROWSEUPDATE 35 GLOBAL XSL SAVEAS 35 GlobalRegion 85 gstags 13 JE COMPONENT FILTER FEDERAL XXX 36 JE COMPONENT FILTER STATE XXX 36 JE COMPONENT ROLLUP SET CODE 36 JE DATASET DELETE ALL 36 JE FILTER4 36 JE FILTER 36 JE ROUNDING DECIM
26. AL PLACES 36 JE SHOW ZERO BOOKCALCS 36 JE SHOW ZERO TAXCALCS 36 JE STATE GROUP 36 JE STATE GROUP NAME 36 JE Supplemental Label 36 JE TAG GROUP NAME 36 JE TAG GROUP TAGS 36 JE TYPE LOCKED 36 99 ONESOURCE System Parameters 5 JE UNIT DELETE ALL 36 LIMIT PAYABLE DATES 53 LockoutMinutes 88 MaxFailLogins 88 PassHistNum 88 POST BSO 80 POST DO 80 POST STATE 80 PRINTFORMAT PAGESWIDE 48 49 PROVISION HIDE STATES 8 REPORT FOOTER 48 REPORT HEADER 48 ReportingCurrencySymbol 85 SHOW ACCRUAL 47 SHOW ADVANCEDLIABILITY 53 SHOW BRIDGEUNITMAP 72 SHOW CASHPYMTS 41 SHOW CTA 78 SHOW DATABASEANALYZER 47 SHOW DEFBALCSCBRKOUT 31 SHOW EFFRATECONSOLPTBIPCT 20 SHOW EFFRATECSCBRKOUT 20 SHOW EXPECTEDDEFERRED 44 SHOW GAAPTOSTAT 13 SHOW JE 36 SHOW OUTPUTJE 36 SHOW PAYABLERECLASS 60 SHOW 80 SHOW WORKPAPER 29 TSPasswordExpireDays 88 TSPasswordMinDigits 88 TSPasswordMinLength 88 USE OLD AMTESTIMATOR Default 51 USE SPDEFBALREPORTS 24 100 Parameters Index USE SPOUTPUTJEREPORTS 36 USE SPPROVISIONREPORTS 8 10 USE SPPROVSUMMARYREPORTS 45 UsersExtended 87 T Temporary Difference Parameters DEFAULT TD TAB 92 DefEndBalDefault 51 RESTRICT TD TABS 92 Temporary Differences 78 True ups Deferred Only 80 TS Database Analyzer 47 U Unit Dataset Parameters 6 JE CALCULATE ENTRIES 36 PAYABLE CPROV BUCKET 56 PAYABLE RTP BUCKET 56 PAYRECUNIT 60 Unit Parameters 5 Un
27. BSORTPTAG 80 CountryRates 75 CTA ALT CALC 79 CurrencyRates 75 DEF RF SUMMATION COLUMN 24 2010 Thomson Reuters ONESOURCE Dataset Parameters 5 6 DEF RF SUMMATION 24 DEFAULT TD TAB 89 92 DefEndBalDefault 51 DORTPTAG 80 EstPymtFranchiseType 73 EstPymtPctCushion 73 EstPymtRoundFactor 73 EstPymtType 73 Prefix 51 FEDBENEFITOFSTATE 23 NOLAUTO BSO EXCLUSIONYYY 77 NOLAUTO DEFONLY EXCLUSIONXXX 77 PAYABLE CPROV DOM BUCKET 56 PAYABLE CPROV DOM STATE BUCKET 56 PAYABLE CPROV FOR BUCKET 56 PAYABLE CPROV FOR STATE BUCKET 56 PAYABLE FXRATE CALC 54 56 PAYABLE RTP DOM BUCKET 56 PAYABLE RTP DOM STATE BUCKET 56 PAYABLE RTP FOR BUCKET 56 PAYRECTYPE 60 Prior Year 43 PULL PAY FROM DATASET 73 RESTRICT TD TABS 89 92 RestrictTA 89 90 RestrictTag X 89 91 80 SCRUNCH TAG 76 StateRates 75 USE OLD AMTESTIMATOR 51 USETBPTBI 12 VA CALCTYPE 68 Dataset Relations 80 2010 Thomson Reuters Parameters Index Deferred Workpaper 23 E Effective Tax Rate 16 20 Ending Balances 51 Estimated Payments 73 Estimated Payments Parameters EstPymtFranchiseType 73 EstPymtPctCushion 73 EstPymtRoundFactor 73 EstPymtType 73 PULL PAY FROM DATASET 73 16 20 49 n Federal Benefit of State 23 Federal Energy Regulatory Commission 23 Federal NOL 77 Federal NOL Automation 77 Federal NOL Automation Parameters NOLAUTO BSO EXCLUSIONYYY 77 NOLAUTO DEFONLY EXCLUSIONXXX 77
28. C SYS NOLTD 0 0 0 0 0 0 0 0 0 0 0 SYS PiiID C VA SYS PTID C 0 0 0 0 0 0 0 0 0 0 0 VA SYS PTTD VA 5 5 PTTD NC 0 0 0 0 0 0 0 0 0 0 0 Total 48 980 0 20020 69 000 0 0 10 090 2 000 0 20 81 070 2010 Thomson Reuters 25 ONESOURCE Dataset Parameter Function Key DEF SUMMATION COLUMN DEF SUMMATION NAME 26 Parameters KeyType Key Value Alphanumeric 2 through 26 Alphanumeric Text Reports Description This parameter only works when the USE SPDEFBALREPORTS 23 system parameter is activated and the DEF RF SUMMATION NAME parameter is defined Allows you to designate the position for the sub total column in the Deferred Balance report for a specific dataset This column adds beginning deferred balances with rate changes and prior columns It uses the columns as defined in the Manage Deferred Rollforwards screen Note This parameter overrides the DEF RF SUMMATION COLUMN 29 system parameter This parameter only works when the USE SPDEFBALREPORTS 2 system parameter is activated and the DEF RF SUMMATION COLUMN parameter is defined The text entered in the Value field displays as the column header for the sub total column in the Deferred Balance report for a specific dataset Typically this sub total represents adjusted beginning balances However it could be used for any sub total Note This parameter overrides the DEF _ SUMMATION 23 system parameter 2010 T
29. Key Type Key Value Description Enables similarly coded and similarly designated Scrunch_Tag Alphanumeric Any letter from A Current Non Current temporary differences with the through 2 same or different tag letters to be aggregated when rolling over datasets using the Scrunch functionality Scrunch functionality is applied to all temporary differences Unit Temporary Differences Tax Basis Temporary Differences Book Tax Basis After Tax Temporary Differences Tax Basis After Tax Temporary Differences Book Tax Basis NOL Temporary Differences Tax Basis State Temporary Differences Tax Basis State After Apportionment Temporary Differences Tax Basis and State After Tax Temporary Differences Tax Basis Before rolling over a dataset make sure the original dataset includes the SCRUNCH parameter to designate the tag letter that will be associated with the new aggregated balance Note Scrunch functionality is available in Corporate Edition 6 0 and higher 76 2010 Thomson Reuters ONESOURCE Parameters Functionality 3 10 Federal NOL Automation Dataset Parameter Function Key Key Type Key Value Description Used to exclude Deferred Only amounts from the NOLAUTO DEFONLY EXCLUSIONXXX Alphanumeric Letter Federal NOL Automation balance XXX are numbers and Tag Letter is the tag that should be excluded Used to exclude Balance Sheet Only amounts from the NOLAUTO_BSO_EXCLUSIONYYY Alphanumeric Letter Feder
30. NESOURCE 70 Sample Aggregated Basis Valuation Allowance Calculation Parameters Functionality This calculation complies with the Provision rule as the Provision rule only considers assets for the allocation of current non current VA To use this method on a unit by unit basis unless filing group in addition to the dataset parameter CALCTYPEwith a paramvalue of 2 you need to select the Valuation Allowance Automation in the Automation section of the Unit Details screen Pre Tax After Tax Temporary Diff 1 Non Current 4 000 1 400 Temporary Diff 2 Current 15 000 5 250 NOLs Non Current 20 000 7 000 After Tax Temporary Diff 1 Current 10 000 After Tax Temporary Diff 2 Non Current 3 000 Totals 31 000 3 850 Valuation Allowance on Temporary Diffs 11 000 Valuation Allowance on NOLs 20 000 3 850 Valuation Allowance on After Tax Temp Diffs Total Valuation Allowance if 100 VA chosen 31 000 3 850 Current Non Assets Current Split Current Assets 34 4396 5 250 Non Current Assets 65 5796 10 000 Total Assets 100 0096 15 250 Valuation Allowance on Temporary Diffs Current 3 787 Valuation Allowance on Temporary Diffs Non Current 7 213 Valuation Allowance on NOLs Current 6 885 1 325 Valuation Allowance on NOLs Non Current 13 115 2 525 Valuation Allowance on After Tax Temporary Diffs Current Va
31. NOLTD NOLS 511 924 1 1495 50 0 0000 30 0 0000 30 0 0000 11 924 5 8248 TADJ Tax Adjustments 50 0 0000 so 0 0000 50 0 0000 50 0 0000 30 0 0000 ATTD Temporary Differences 50 0 0000 50 0 0000 50 0 0000 so 0 0000 so 0 0000 DPOA Deferred Provision Only Adj 50 0 0000 50 0 0000 50 0 0000 50 0 0000 50 0 0000 ee amme Total 457 068 44 066896 256 706 43 6636 5108854 41 0770 4726 489741 536 782 49 670356 22 2010 Thomson Reuters ONESOU Parameters Reports 2 3 Deferred Balances Various features of the Deferred Balances report are enabled by parameters Federal Benefit of State 25 Represents the benefit on either the Federal or State side Adjustment Column 2 Inserts a column in the report Filtered Deferreds 27 Isolates selected deferred amounts Deferred 29 Breaks out balances to show pre and post deferred information CSC Breakout 31 Activates the csc brkout view option 2 31 Deferred Balances Federal Benefit of State FBOS Dataset Parameter Function Key Key Type Key Value Description Determines where the benefit of state deduction occurs on the Deferred Balances and Temp Diff Summary reports The FED option has the deduction display on federal amounts and rates and the STATE option has the deduction display on state amounts and rates The report displays the Federal FBOS or
32. National The CANADA paramvalue uses the term Local The US paramvalue uses the term Net Operating Loss The EUROPE paramvalue uses the term Tax Loss The CANADA paramvalue uses the term Tax Loss The US paramvalue uses the term Est Pymt The EUROPE paramvalue uses the term Adv Pymt The CANADA paramvalue uses the term Install Pymt 85 ONESOURCE 86 ReportingCurrencySymbol ALLOWMULTICURRENCYREPORT Parameters Three letter currency symbol Yes Functionality Changes the currency that displays in the header of reports viewed in Reporting Currency Allows consolidated and subconsolidated reports with multiple currencies to display in local currency You can view Local Currency reports when units do not have the same currency After adding this parameter and selecting a sub consolidated or consolidated report in local currency a The report you are about to display contains multiple currencies The report data will not be consistent warning displays Click OK to the report For example if the report had a unit in Euros one column and another unit next to it in dollars the total would be a sum of the two which would not be a meaningful number 2010 Thomson Reuters ONESOURCE Parameters Functionality 4 Administration Administration parameters specify user access to the system as well as password requirements 4 1 User Information System Parameter Function Parameter Value Description
33. ONESOURCE TAX PROVISION Parameters User Manual 6 1 0 2 ONESOURCE THOMSONREUTERS COM i THOMSON REUTERS ONESOURCE Parameters Contents Table of Contents Part 1 Introduction Working with Parameter Types System Parameters rre Dataset Parameters Unit State Dataset Parameters EEE Part 2 Reports Tax eee exo eite cor Tax Provision Stored Procedure OPI Tax Provision metes iasa Tax Provision PTBI Provision GAAP to STAT Effective Tax 2 1 Effective Tax Rate CSC Breakout Deferred Deferred Balances Federal Benefit of State FBOS Deferred Balances Adjustment Column r Deferred Balances Filtered Deferred Balances Workpaper ia RA KS KENNEN r OEIL RRUGEQIKKE REGE ENUIINURU REI I ER Deferred Balances CSC Breakout r M NT Unrilzuu
34. Rates Different than Statutory 1 076 645 Permanent Differences ex Equity 1 391 600 Temporary Differences 30 628 317 000 NOLs 0 Tax Adjustments ex Equity 0 Temporary Differences 210 000 Deferred Provision Only Adj 0 Total 27 569 174 201 Rate Effect 35 00 0 00 45317 1996 15 93 20 60 453290 15 0 00 0 0096 3 11 0 00 408015 73 contracted expanded State breakdown breakout all 2010 Thomson Reuters 17 ONESOURCE Parameters Reports Consolidated Subconsolidated Level Breakout All Consolidated Effective Rate Report Local AL summary detail contracted expanded 2009 Current Provision Developement and Testing License State breakdown non breakout TOTAL D1000 D2000 D3000 04000 TOTAL ABC CORP DEF CORP GHI Corporation JKL Corpor Component PTBI Tax Effect Rate Effect PTBI Tax Rate Tax Rate PTBI Tax Effect Rate Effect Effect Effect Effect Effect Effect ptbi Pre Tax Book Income 6 756 890 2 364 912 35 00 2 000 000 700 000 35 00 0 0 NAO 0 NAO 0 fxadj FX Adjustment 0 0 00 0 0 00 0 0 NA 0 st State and Local Income Taxes 3 062 032 666 45317 19 391 952 19 6096 15000 3 062 791 500 1 500 erds Effect of Rates Different than Statutory 1 076 645 15 93 207 300 10 37 87 500 21 000 10 500 PD Permanent Differences ex Equity 1 391 600 20 6096 751 100 37 5696 87 500 N A 21 0000 N A 10 500 TD Temporary Differences 30 628 3
35. TAL 4 TOTAL CSC1 Domestic CSC1 Foreign Pre Tax Book Income UPTBI Unit level Pre Tax Book Income 1 609 000 000 800 000 000 809 000 000 Total Pre Tax Book Income 1 609 000 000 800 000 000 809 000 000 FX Adjustment 0 0 0 Rounded PTBI 1 609 000 000 800 000 000 809 000 000 Deductible State Tax CA California 902 466 0 902 466 NJ New Jersey 902 298 0 902 298 Total Deductible State Tax 1 804 764 0 1 804 764 Permanent Differences P10000 Meals and Entertainment 5 540 0 5 540 Total Permanent Differences 5 540 0 5 540 Financial Taxable Income 1 607 200 776 800 000 000 807 200 776 Temporary Differences 713000 Bad Debt Reserve 20 0 20 T14000 Book Depreciation 100 0 100 74000 Accrued General and Admin Expense 2 000 0 2 000 Total Temporary Differences 2 120 0 2 120 2010 Thomson Reuters 11 ONESOURCE Parameters Reports 2 1 1 2 Tax Provision PTBI Detail The detailed view of the Tax Provision report displays a breakout of Pre Tax Book Income by Trial Balance Line Dataset Parameter Function Key Key Type Key Value Description e 1 pulls amounts populated in the Trial Balance Sub Lines that are affiliated with Trial Balance Lines that roll up to Income Statement Accounts No special code is necessary e 2 pulls only amounts populated in the Trial Balance Sub Lines with codes beginning with PTBI_ Using this coding structure allows you to populate a Book Income Statement and exclude the tax expense accounts to generate USETBP
36. TBI Alphanumeric 0 1 or 2 2 Income Use to code your income statement Notes e The total PTBI on the Tax Provision is the sum of the PTBI and the Trial Balance Sub Lines designated by the USETBPTBI parameter e The third PTBI policy Enter Local USD Calculation FX does not work with this parameter 12 2010 Thomson Reuters ONESOURCE Sample Report Expanded detail for the Pre Tax Book Income SubConsolidated Provision Report USD Other TaxSteam Division 1 OGD Revenue S000 Salaries S300 Officers Compensation 940000 Rert LPT Urd level Pre Tare hone Bool income 2 1 2 Tax Provision GAAP to STAT Parameters Reports mew summary umt breakout breakout conipanson 4578 GAAP to STAT parameters allow you to isolate permanent and temporary differences tagged with a specified letter in the GAAP to STAT section of the Tax Provision to arrive at PBTI at local STAT All other permanent and temporary differences display in the STAT to TAX section System Parameter Function Designated Tag Parameter Value SHOW_GAAPTOSTAT 0 or 1 gslags and Letter GAAPTOSTAT 2010 Thomson Reuters Description 1 displays the TaxProvision GAAP to STAT report In the Manage Tags screen under System in the Administration tab set up a tag for items entered as GAAP to STAT Then in Manage Restricted Features add the gstags and GAAPTOSTAT parameters with
37. TIMATOR Default 1 Local Dataset Parameter Function Parameter Value USE OLD AMTESTIMATOR 1 Local After Tax FATTD Prefix Temporary 0 Reporting o 0 Reporting o Parameters Functionality Description Allows you to designate the approach to Alternative Minimum Tax AMT when a new dataset is created 0 defaults new datasets to the Reporting Currency approach and 1 the Local Currency approach The Reporting Currency approach expands the Alternative Minimum Tax AMT calculation Refer to the Corporate Edition user manual for more information on the two approaches The approach can be overridden on a specific dataset with the dataset parameter USE OLD AMTESTIMATOR Description Allows you to designate the approach to AMT for a specific dataset 0 uses the Reporting Currency approach and 1 the Local Currency approach The Reporting Currency approach expands the Alternative Minimum Tax AMT calculation Refer to the Corporate Edition user manual for more information on the two approaches Identifies the After Tax Temporary Differences ATTD that should be considered as foreign tax credits in the Regular Tax Calculation in the Reporting Currency AMT approach For example if XYZ is entered for the parameter value all ATTD with a code beginning with XYZ are included in the calculation The following codes would Difference Code be included XYZ123 XYZ001 and XYZ myforeigntaxcredit 33 Temporary Differences S
38. adding a dataset parameter manually This change will potentially impact your calculations Are you sure you want to proceed message displays This message alerts you to the fact that you can potentially change the way the system displays amounts If you want to ensure the integrity of the data you can either make a copy of the dataset or export the dataset before changing the parameter 1 2 3 Unit State Dataset Parameters Unit Dataset parameters can be activated on a unit by unit basis within a dataset There are two types of Unit Dataset parameters Unit Dataset parameters only impact the unit within the dataset to which they are added They will carry over to a new dataset if the dataset is rolled over Unit State Dataset parameters only impact the state within the unit within the dataset to which they are added They will carry over to a new dataset if the dataset is rolled over An Administrator can enter Unit Dataset Parameters manually on the Provision or Estimated Payments tab under Data Review gt Federal gt Administration gt Unit Dataset or import them via the Import Numbers spreadsheet template on the UDSP UnitDataset Params worksheet Unit State Dataset Parameters manually on the Provision or Estimated Payments tab under Data Review gt State gt Administration gt Unit State Dataset Parameters or import them via the Import Numbers spreadsheet template on the ZUSDSP UnitStateDataset Params worksheet
39. ailable by default Description 1 activates the Output Journal Entries reports Note Configurable JE reports is license driven functionality Refer to the Corporate Edition user manual for more information There are nine Supplemental Information fields on the Journal Entries screen Their labels default to 1 9 This parameter attaches a name such as Account Code or JE Description to these fields to help the user understand what is expected when completing them The following parameters affect the entering of Journal Entries in the system which determines the content of Output Journal Entries reports For more information about Configurable JE refer to the Journal Entries section in Chapter 4 of the Corporate Edition user manual JE COMPONENT FILTER FEDERAL XXX JE COMPONENT FILTER STATE XXX Component ID Component ID Filters the Federal Component list for detail JE configurations Filters the State Component list for detail JE configurations The values for XXX are BSO EDB DP DP OTA SDB DP ACTIVITY DP ROUNDING EB ROUNDING 36 2010 Thomson Reuters ONESOURCE Parameters Reports Example JE COMPONENT FILTER FEDERAL BSO with a paramvalue of 3 4 6 Here is a paramvalues chart COMPONENTTYPEID 2010 Thomson Reuters NAME Permanent Differences Temporary Differences After Tax Temporary Differences Perm Differences Amortized Temp Differences Book Tax Basis Tax Adjustments State After
40. al NOL Automation balance YYY are numbers and Tag Letter is the tag that should be excluded Notes e XXX and YYY are numbers and Tag Letter is the tag that should be excluded For example e NOLAUTO_DEFONLY_EXCLUSION1 with a paramvalue of A NOLAUTO DEFONLY EXCLUSION with a paramvalue of B Multiple tags can be excluded by setting up multiple parameters e Deferred Only and Balance Sheet Only amounts are included by default 2010 Thomson Reuters 7 ONESOURCE Parameters Functionality 3 11 Currency Translation Adjustment CT A The system automatically calculates Currency Translation Adjustment CTA for all temporary differences Two additional options for representing and entering CTA require the use of parameters Alternative 7 International Financial Reporting Standards IFRS and Additional 7 Note Alternative CTA and Additional are available in Corporate Edition 6 0 and higher 3 11 1 Additional CTA 78 System Parameter Function Parameter Value Description SHOW CTA 1 enables you to manually enter Currency Translation Adjustment calculations for all temporary differences via the Additional CTA option Additional CTA allows you to adjust the Ending Deferred Balances Reporting currency by entering an additional CTA amount The entry is treated as Reporting Currency and displays as an After Tax Rate amount Depending on which fields are populated the amounts could im
41. allocation of the valuation allowance It considers liabilities in the computation of the current non current allocation According to the Provision rule it should only consider assets To use this method on a unit by unit basis unless filing group select the Valuation Allowance automation in the Automation section of the Unit Details screen and enter the appropriate percentages Pre Tax After Tax Temporary Diff 1 Non Current 4 000 1 400 Temporary Diff 2 Current 15 000 5 250 Total Temporary Diffs 11 000 3 850 Valuation Allowance on Temporary Diffs if 100 VA chosen 11 000 3 850 NOLs Non Current 20 000 7 000 Valuation Allowance on NOLs if 10096 VA chosen 20 000 7 000 After Tax Temporary Diff 1 Current 10 000 After Tax Temporary Diff 2 Non Current 3 000 Total After Tax Temporary Diff 7 000 Valuation Allowance on After Tax Temp Diffs if 100 VA chosen Total Valuation Allowance 31 000 10 850 Valuation Allowance on Temporary Diffs Current 11 000 3 850 Valuation Allowance on Temporary Diffs Non Current 0 0 Valuation Allowance on NOLs Current 0 0 Valuation Allowance on NOLs Non Current 20 000 7 000 Valuation Allowance on After Tax Temporary Diffs Current 0 Valuation Allowance on After Tax Temporary Diffs Non Current 0 Total Valuation Allowance 31 000 10 850 2010 Thomson Reuters 69 O
42. arning PAYABLE CPROV BLICKET Alphanumeric PAY ABLE_RTP_BUCKET Alphanumeric AOTH 58 2010 Thomson Reuters ONESOURCE Parameters Functionality Unit State Dataset Parameter Function If a specific state within a unit should post to a different bucket you can configure this with a unit state dataset parameter Key Key Type Key Value Description Payable PAYABLE_CPROV_BUCKET Alphanumeric Bucket Delve the KO BUCHA tO Cash Provision for a specific state within unit posts Payable Defines the payable bucket to which the State Tax PAYABLE RTP BUCKET Alphanumeric Bucket Adjustment for a specific state within a unit with the Code NC_RTP or NC_ATR code posts Administration Manage State Unit DataSet Parameters Warning Changes may impact your calculations Key Type Key Value PAYABLE_CPROV_BUCKET Alphanumeric OTH PAYABLE_RTP_BUCKET Alphanumeric OTH 2010 Thomson Reuters 59 ONESOURCE Parameters Functionality 3 4 3 Reclass System Parameter Function Posted provision amounts can be automatically reclassed between entities in the Payable Entry section of the system The reclass allows for multiple companies to transfer to a single parent unit or paying unit The system transfers the entire tax from the unit where it was originally posted to the parent unit IMPORTANT This functionality is only available for ONESOURCE Tax Provision Corporate Edition 6 0 and high
43. ax Temporary Differences Current 1 326 Valuation Allowance on After Tax Temporary Differences Non Current 2 524 Total Valuation Allowance 3 850 2010 Thomson Reuters 71 ONESOURCE 3 6 Bridge System Parameter Function Parameter Value BRIDGE ALLOW UNIT SELECT 0 or 1 BRIDGE ALLOW SUBCON SELECT 0 1 BRIDGE ALLOW ALL UNITS 0 or 1 BRIDGE DEFAULT TAG A Z SHOW BRIDGEUNITMAP 0 or 1 72 Parameters Functionality Description 1 activates the Unit radio button when designating to which unit to bridge data on the Bridge Import screen By default if there is no parameter the Unit radio button displays 0 removes the option to bridge data into a single unit e 1 activates the Subconsolidation radio button when designating the subconsolidation to which to bridge data on the Bridge Import screen By default if there is no parameter the Subconsolidation radio button displays 0 removes the option to bridge data at the subconsolidated level e 1 activates the Consolidated radio button when designating on the Bridge Import screen that data be bridged to all units By default if there is no parameter the Consolidated radio button displays 0 removes the option to bridge data at the consolidated level Changes the default tag letter that appears on the Bridge Import screen The default letter for this setting is Import However any letter can be used 1 activates the Unit Ma
44. b consolisation either CSC1_Domestic or CSC1_ Foreign Sample Reports 32 2010 Thomson Reuters ONESOURCE Parameters Reports SubConsolidated Deferred Balances Report Pre Tax KRW 2005 Provision Development and Testing License 8 1 X Worldwide Standard Rollup NOL Rollup Current Non Current Classification default Summary hybrid detail unit pre tax Federal State FBOS Federal State FBOS State FBOS all c nc contracted expanded b s Code Name Beginning Balance Ending Balance brkout brkout NOL_001 NOL per Sec 382 Analysis 5 598 605 5 598 605 002 Net Operating Loss 0 11 086 979 NOL SYS NOL SYS 333 575 398 351 336 964 T1000 BAD DEBT RESERVE TEST 1 000 6 000 01 Restructuring Expenses 1 217 401 1 217 401 02 Accrued Bonus 1 159 500 1 159 500 Accrued Expenses 942 832 942 832 04 Accrued Expense Advertising 1 141 785 6 130 182 05 Accrued Professional Fees 45 658 250 45 668 250 06 Accrued Rent Income 1 297 184 1 297 184 07 Vacation 26 139 344 26 465 871 08 Credit Allewance 9 188 374 9 188 374 TACOS C Damaged Goods Allowance 0 400 000 10 C Deferred Revenue 10 173 580 10 212 432 TAC11 Other Receivables Allowance 20 507 556 20 507 556 TAC12 NC Partnership Income Loss 230 549 230 549 TAC13 C Prepaid Property Tax Lien Date 993 338 993 338 2010 Thomson Reuter
45. be re imported to restore the instance to the prior parameter settings 1 2 Parameter Types There are three types of parameters system 5 dataset 6 and unit state dataset 1 21 System Parameters System Parameters are maintained in the Administration tab and apply to all datasets System parameters impact the entire system Most require the system to be restarted after being added for the parameter to be activated Important Some system parameters affect core system functionality They should never be deleted or modified Import system parameters via the Import Categories Spreadsheet template on the tab named Parameters Once the worksheet is populated an administrative user can select import categories on the Administration tab and point to the file Note The maximum number of characters for a system parameter value is 250 2010 Thomson Reuters ONESOURCE Parameters Introduction 1 2 2 Dataset Parameters Dataset Parameters are activated on a dataset by dataset basis They only impact the dataset to which they are added Dataset parameters will carry over to a new dataset if the dataset is rolled over An Administrator can e Enter dataset parameters manually on the Provision and Estimated Payments tabs under Data Review gt DataSet gt Administration gt Dataset Parameters Import dataset parameters via the Import Numbers Spreadsheet template the DP Dataset Params worksheet Note When
46. ctionality to work you must create subconsolidations using a coding convention starting with CSC Use CSC _X_ for the parent suboncolidation and CSC _ for the child subconsolidations Every unit in CSC _X_ must be assigned to a CSC _ subconsolidation The custom sub consolidation view of the Deferred Balances report allows the data of a parent sub consolidation to be broken into child sub consolidations To create a Custom Sub Consolidation 1 In the Unit Sub Consolidations screen under Manage Units in the Administration tab create a parent sub consolidation by entering a name beginning with CSC _X_ in the Description field You can define multiple breakout scenarios by creating multiple parents 2 Add units to the parent sub consolidation by selecting appropriate Unit Codes and clicking the update button 3 Create child sub consolidations beginning with CSC _ and add the appropriate units All units designated in the parent sub consolidation must be included in a child sub consolidation Note Each unit within the parent sub consolidation can only belong to one child sub consolidation In the following example D1000 D2000 F1000 and F2000 can only belong to one child sub consolidation either CSC1_Domestic or CSC1_Foreign CSC1 X Worldwide CSC1 Domestic CSC1 Foreign D1000 x x D2000 x X F1000 x x F2000 x X 2010 Thomson Reuters 31 ONESOURCE Parameters Reports D1000 D2000 F1000 and F2000 can only belong to one child su
47. ctjon 90 Tag 91 Differences 92 Active Workpapers E AE 93 4 2010 Thomson Reuters ONESOURCE Parameters Introduction 1 Introduction Parameters allow you to configure an instance of ONESOURCE Tax Provision Corporate Edition formerly Enterprise to make certain functionality calculations report views and other items available 11 Working with Parameters Key Parameter Concepts Use care when modifying parameters Only modify the parameters specifically listed in this document or if specifically instructed by a ONESOURCE Tax Provision employee Core system parameters should never be modified or deleted Doing so causes major errors in the software or renders it completely useless e A parameter can change the way the system carries out computations Be sure to fully understand the impact and methodology of a parameter before using it Some parameters require the latest version of the software Parameters are typically case sensitive Make sure you enter the correct case and spelling to activate a parameter Backup and Restore e Consider exporting categories and datasets before adding or modify any parameters to create a backup e The backed up files could later
48. d as Tag Restricted Read Write users cannot edit the entry nor can they create a new entry with an M tag 2010 Thomson Reuters 91 ONESOURCE Parameters Administration 4 33 Temporary Differences Dataset Parameter Function Key Key Type Key Value Description 0 allows Administrators and Read Write users to enter data either on both the Analysis and Detail sections of Temporary Difference screens RESTRICT_TD_TABS Alphanumeric 0 or 1 1 limits the ability to enter data in the Details section of Temporary Difference screens to Administrators only All users however can view data in the Details section 0 displays the Detail section of Temporary Difference screens for all users 1 displays the Analysis section of Temporary DEFAULT_TD_TAB Alphanumeric 0 1 or 2 Difference screens for Read Write and Read Only users and the Detail section for Administrators 2 displays the Analysis section of Temporary Difference screens for all users 92 2010 Thomson Reuters ONESOURCE Parameters Administration 4 3 4 Active Workpapers Dataset Parameter Function Key Key Type Key Value Description 1 makes Active Workpapers read write for Read Write users However if a Read Write user does not have permission to access all the datasets in an AWP that AWP_WRITE Alphanumeric Oor 1 AWP opens as read only and the following warning message displays Workpaper contains 1 or more Datasets or Units to which you do not have access
49. e appropriate column based on the tag Sample Report Unit Offset Summary KRW Current Prov 2007 Development and Testing License F2000 UK Corporation Unit Code Unit Name Deferred Goodwill Liability Good will F2000 UK Corporation 500 000 0 total 500 000 0 42 2010 Thomson Reuters ONESOURCE Parameters 2 5 3 Foreign Domestic Summary Dataset Parameter Function Key KeyType Key Value Prior Year Alphanumeric Tag Letter 2010 Thomson Reuters Reports Description Determines which and Deferred amounts are considered in the Prior Year Breakout view of the Foreign Domestic Summary report based on their tag letters For example To include and Deferred amounts tagged with R and X add the dataset parameters Prior Year Tag Alphanumeric Prior Year Tag2 Alphanumeric X 43 ONESOURCE Parameters Reports 2 5 4 State Summary Expected Deferred Rate System Parameter Function Parameter SHOW EXPECTEDDEFERRED Sample Report Consolidated Expected Deferred Rate 2009 Current Provision A Development and Testing License Unit Code State F2000 BS CA NJ Unit Rate Total Value 0 or 1 End Appt Rate 100 0096 100 0096 100 00 Description 1 activates the Expected Deferred Rate report under State Summary on a consolidated and sub consolidated basis This report displays the state ending deferred rate and ending apportionment rate for each unit b
50. ed information is shown in the payable with the tag letter C The transaction type has REC added to it Note This parameter is only valid when the PAYRECTYPE dataset parameter is activated with a paramvalue of 2 Note This parameter must be created for every child unit for which the payable is to be reclassed 2010 Thomson Reuters 63 Parameters Functionality Payable Reclass Between Units To set up the payable reclass 1 To enable the Recalc Payable Reclasses activate the system parameter SHOW PAYABLERECLASS vwith the key value of 1 by selecting the Administration tab and clicking Administration System Manage Restricted Features Note The system must be restarted after a system parameter is entered for the parameter to take effect 2 Go to the Provision tab and click Data Review Dataset Administration Dataset Parameters 3 Click Create New and enter PAYRECTYPE To post the payable reclass After the setup is complete the provision is posted on the child unit level Review the provision amounts originally posted at the child level for accuracy Then click the Recalc Payable Reclasses button located under Data Review DataSet The reclass uses similar but different transaction types to move amounts between entities Provision Reclass CPROV CPROV REC RTP RTP REC ATR ATR REC OTHER OTHER REC The system transfers the provision posting from the child to the parent keeping the year
51. er Parameter Value Description 1 activates the Reclass functionality This parameter works with the configurations SHOW_PAYABLERECLASS 0 or 1 in the Unit Dataset parameter PAYRECUNIT to reclass a unit level generated payable to another unit 60 2010 Thomson Reuters ONESOURCE Parameters Functionality Dataset Parameter Function Key Key Type Key Value Description Determines how the Unit Dataset parameter PAYRECUNIT functions 0 indicates there is no payable reclass 1 indicates that the Payable Reclass on the Federal and State levels is based on the unit determined for PAYRECUNIT at the Unit Dataset parameter level PAYRECTYPE Alphanumeric 0 2 indicates that the Payable Reclass on the Federal level is based the unit determined for PAYRECUNIT at the Unit Dataset parameter level In addition the Payable Reclass on the State level is based on the unit determined for PAYRECUNIT at the Unit State Dataset parameter level 2010 Thomson Reuters 61 Parameters Functionality Unit Dataset Function Key Key Type Key Value Description Available in versions 6 0 0 and higher Reclasses a unit s auto generated payable transactions to a parent unit Enter the code for the unit in which the payable information should be included as the key value This function is not automatic the reclass must be activated by selecting the Recalc Payable Reclasses option The reclassed info
52. eshed in the Estimated Payments tab To refresh the data select the Reset Report Data option under Reports gt Administration or select the parameter and then click the Save Changes button Dictates the tag letter used in the Federal State Est EstPymtType Tag Leier Payment Summary reports for income payments EstPymtFranchiseType Alphanumeric Tag Letter Dictates the tag letter used in the Federal State Est Payment Summary reports for franchise payments 74 2010 Thomson Reuters ONESOURCE 3 8 Mass Update Rates Dataset Parameter Function Key Key Type CountryRates Alphanumeric CurrencyRates Alphanumeric StateRates Alphanumeric Key Value Y Y Y Parameters Functionality Description Y automatically populates country rates for a dataset Y automatically populates currency rates for a dataset Y automatically populates state rates for a dataset The Mass Update Rates feature provides the ability to apply Tax and Foreign Currency Rates on a mass basis to a dataset Mass Update rates are populated in the Manage States screen for both pre defined and custom states under Administration gt Manage States and the Manage Countries and Currencies screen under Administration gt System Note Mass Update Rates is available in the Provision Estimated Payments and Interim Actual tabs 2010 Thomson Reuters 75 ONESOURCE Parameters Functionality 3 9 Scrunch Dataset Parameter Function Key
53. homson Reuters ONESOURCE Parameters Reports 2 3 3 Deferred Balances Filtered The Deferred Balances report can be filtered to view a subset of deferred items The filters are user defined and can be based on SQL queries such as querying the name or code System Parameter Function Parameter Value Description Enter a user defined name for a customized Deferred Balance and Temp Diff FILTER _NAME Text Summary reports that filters temporary differences by code or tag The in the parameter name can be an integer from 1 4 This parameter works hand in hand with the previous parameter FILTER NAME PIL TERE SGL SIS Quy The value is a database query 2010 Thomson Reuters 27 ONESOURCE Parameters Reports Sample Names and SQL Queries Parameter Value Action FILTER NAME Valuation Allowances Creates me new reports Deferred Balance and Temp Diffs Summary with the extension Valuation Allowances The SQL query filters the data for Temporary Difference Adjustment TDA codes SGL AND TDA Code like starting with displays them in reports with the extension above FILTER2 NAME NOL Creates two new reports Deferred Balance and Temp Diffs Summary with the extension NOL FILTER2 SQL AND TDA Code like 1 The SQL query filters the data for TDA codes starting with NOL and displays them in reports with the extension above FILTER3 NAME All Other Creates two new reports Deferred Balance
54. ifferences System parameters extend the RTP comparison to amounts entered as Deferred Only and or Balance Sheet Only Parameter Value Description POST_DO 0 or 1 1 enables the calculation of Deferred Only RTP true ups POST BSO 0 or 1 1 enables the calculation of Balance Sheet Only RTP true ups POST STATE 1 enables the calculation of State RTP true ups This calculation is similar to the one at the unit level 1 displays the Post Ret to Prov screen in the Navigator This screen allows you to define two datasets to compare the Federal current provision expense It then SHOW POSTRTP 0 or 1 posts the difference of the two datasets to a third dataset as a tax adjustment with the code NC RTP Although the Federal amount considers the deductible state amount to arrive at taxable income no equivalent state tax adjustment is posted 80 2010 Thomson Reuters ONESOURCE Dataset Parameter Function Key Key Type RTPTAG Alphanumeric DORTPTAG Alphanumeric BSORTPTAG Alphanumeric 2010 Thomson Reuters Key Value Tag letter Tag letter Tag letter Parameters Functionality Description Configures the tag that designates RTP Deferred Only adjustments Overrides the default RTP posting tag of R Configures the tag that designates RTP Deferred Only adjustments Overrides the default Deferred Only posting tag of Q Configures the tag that designates RTP Deferred Only adjustments Overrides the default Balance Sheet Only
55. it State Dataset Parameters 6 PAYABLE CPROV BUCKET 56 PAYABLE RTP BUCKET 56 PAYRECUNIT 60 User Access 87 User Parameters AWP WRITE 89 CASE INSENSITIVE LOGIN 87 DEFAULT TD TAB 89 ExtendedUserRestriction 87 2010 Thomson Reuters ONESOURCE Parameters Index User Parameters RESTRICT TD TABS 89 RestrictTA 89 90 RestrictTag X 89 91 UsersExtended 87 Users Administrative 89 92 Read Write 89 90 91 92 93 Read Only 92 Valuation Allowance Aggregated Basis 68 Aggregated Post Tax Basis 68 Separate Basis 68 Valuation Allowance Automation 68 Valuation Allowance Parameters VA CALCTYPE 68 Year to Date Reporting 47 YTD 47 YTD Accrual Factors 47 YTD 47 YTD Reports 47 2010 Thomson Reuters 101 Proprietary Materials No use of these proprietary materials is permitted without the express written consent or license from 1999 2010 Thomson Reuters ONES OURCE Altering copying distributing or reproducing any of these proprietary materials in any manner is expressly prohibited Software License Agreement The right to use the software product described in this document is specifically conditioned on your execution of and compliance with the Tax License Agreement with 1999 2010 Thomson Reuters ONES OURCE All contents copyright 1999 2010 Thomson Reuters ONESOURCE
56. level and character from the original posting In addition payable transactions CPROV REC ATR REC RTP REC and OTHER REC tagged with a C are removed e The system looks to the units that have the PAYRECUNIT unit and or state level parameters configured and creates new payable transactions that cancel out the CPROV ATR RTP and OTHER payable transactions posted by the Payable Auto posting These are type CPROV REC ATR REC RTP REC and OTHER REC tagged with a C e Additional payable transactions in the target units are created These are type CPROV REC ATR REC RTP REC and OTHER REC tagged with a C 64 2010 Thomson Reuters ONESOURCE Parameters Functionality Child Before Recalc Payable Reclass Administration Custom Custom Custom 2009 Current Provision 52000 DEF sae gt sce PxRae Descrator currency Reporting Currency Navigator APIC Pool Amounts f Perm Diffs 11 Amortized Perm Diffs 2211 Temp Diffs j Amortized Temp Diffs AT Temp Diffs 2121 Amortized AT Temp Diffs olg Tax Adis o Txn Trial Balance Tax State AK Data 5 Reports I 180 Unit 02000 iD Neam 2010 Thomson Reuters 65 ONESOURCE Parameters Functionality Child After Recalc Payable Reclass Home
57. lowing parameters apply to both Custom and Configurable JE reports Parameter Value Description 1 activates the Global Attachments screen in the Administration tab under System This screen allow the JE style sheet to be uploaded for use in generating the JE GLOBAL XSL Cord report Also enables a GLOBAL_VBSCRIPT file to be attached for creating custom reports Note Style sheets are designed by ONESOURCE Tax Provision 1 displays the Browse and Update Attachment button GLOBAL_XSL_BROWSEUPDATE 0 or 1 on the Global Attachments screen This allows users to update attachments saved to the system GLOBAL XSL SAVEAS or 1 displays the Attachment Save As button on the Global Attachments screen Notes e Use care when entering the Code on the Global Attachments screen because it identifies the style sheet in the system e The Global Attachments screen is used mainly for Journal Entry reports However it can be used for other reports 2010 Thomson Reuters 35 ONESOURCE 2 4 1 Custom JE Reports System Parameter Function Parameter Value SHOW JE 0 or 1 2 4 0 Configurable JE Reports Output JE System Parameter Function Parameter Value SHOW OUTPUTJE 0 or 1 Text JE Supplemental Label Parameters Reports Description 1 activates custom Journal Entry 3 reports It generates the Journal Entry Support FG for filing group and Journal Entry Support Unit reports The Provision Journal Entry old report is av
58. luation Allowance on After Tax Temporary Diffs Non Current Total Valuation Allowance 31 000 3 850 2010 Thomson Reuters ONESOURCE Parameters Functionality Sample Aggregated Post Tax Basis Valuation Allowance Calculation This calculation complies with the Provision rule as the Provision rule only considers assets for the allocation of current non current Valuation Allowance In addition it posts on After Tax basis to the codes 6 5 and VA SYS ATTD NC To use this method on a unit by unit basis unless filing group in addition to the dataset parameter CALCTYPE with a paramvalue of 4 you need to select the Valuation Allowance Automation in the Automation section of the Unit Details screen Pre Tax After Tax Temporary Difference 1 Non Current 4 000 1 400 Temporary Difference 2 Current 15 000 5 250 NOLs Non Current 20 000 7 000 After Tax Temporary Difference 1 Current 10 000 After Tax Temporary Difference 2 Non Current 3 000 Totals 31 000 3 850 Valuation Allowance on Temporary Differences 11 000 0 Valuation Allowance on NOLs 20 000 3 850 Valuation Allowance on After Tax Temporary Differences 0 Total Valuation Allowance if 100 VA chosen 81 000 3 850 Current Non Assets Current Split Current Assets 34 43 5 250 Non Current Assets 65 57 10 000 Total Assets 100 00 15 250 Valuation Allowance on After T
59. lue Description Tax Adjustment Determines which tax adjustment codes can be Code that modified and limits the entries that can be created by RestrictTA Alphanumeric becomes Read Write users restricted for Read Write users Sample of a Restriction on any Tax Adjustment Code that begins with D After the RestrictTA parameter is created Read Write users viewing entries with the restricted code see the following uo Ce GEES Manage Attachments Because the RestrictTA parameter was set to D the entry for D1000 is marked as Restricted Read Write users cannot edit the entry nor can they create a new entry with a tax adjustment code beginning with D D will not be available in the Code Description drop down list 90 2010 Thomson Reuters ONESOURCE Parameters Administration 4 3 2 Tag Restriction Dataset Parameter Function Key Key Type Key Value Description The Tag that Determines which tags can be modified and limits the becomes entries that can be created by Read Write users RestrictTag_X Alphanumeric restricted for Read Write users Note The restricting character must be the paramvalue as well as part of the Param Key Sample of a Restriction on any Tag that begins with M After the RestrictTag M parameter is created Read Write users viewing entries with the restricted tag see the following Data Entry Code Description Because the RestrictTag M was created the entry with the tag M is marke
60. ndicates that journal entries are calculated for a specific unit within a dataset 2 5 Other Reports Here are parameters for the following reports Effective Tax Rate 16 Cash Payments 4 Balance Sheet Offset Summary 42 Foreign Domestic Summary 4 e State Summary Expected Deferred Ratel 4 40 2010 Thomson Reuters ONESOURCE Parameters Reports 2 5 1 Cash Payments System Parameter Function Parameter Value Description 1 activates the Cash Payments report which displays the Return Basis Provision SHOW CASHPYMTS 0 or 1 formerly known as the Cash Provision and subtracts the payments This report is available on the Unit Consolidated and Subconsolidated levels Sample Report Cash Payments KRW 2009 Current Provision A Development and Testing License F2000 UK Corporation Fed and State Fed Only Fed and State State Only UK Corporation Estimated Current Return Basis Provision 2 168 033 Payments against Current Year Provision 0 Difference 2 168 033 2010 Thomson Reuters 41 ONESOURCE Parameters Reports 2 5 2 Balance Sheet Offset Summary System Parameter Function Parameter Value Description BSOS XXXX Tag Letter Tag Letter Activates the Balance Sheet Offset Summary report Balance Sheet Only amounts entered with the tags established in the system parameter are Example BSOS Goodwill Example G G included These amounts are rate effected and display in th
61. olidation Note Each unit within the parent sub consolidation can only belong to one child sub consolidation In the following example D1000 D2000 F1000 and F2000 can only belong to one child sub consolidation either CSC1 Domestic or CSC1 Foreign CSC1 X Worldwide CSC1 Domestic CSC1 Foreign D1000 x x D2000 x X F1000 x 2000 x X 20 2010 Thomson Reuters ONESOURCE Parameters Reports Sample Reports ETR Report with only the SHOW EFFRATECSCBRKOUT parameter A SubConsolidated Effective Rate Report USD m contracted expanded 2006 Full Year TaxStream CSC1 X Domestic TOTAL CSC1 Fast CSC1 North 5 1 South CSC1 West Component Tax Rate PIB Rate Tax Rate PIB Rate PIB Tax Effect Effect Effect Effect Effect Effect Effect Effect Effect Effect Pre Tax Book Income 51 037 216 363 026 35 0000 3587 850 205 748 35 0000 265 000 592750 35 000056 99 650 3 378 35005136 3174716 561 150 34 9996 st State and Local Taxes 558 511 56411 39 810 6 772196 516 104 6 0769 560 5 8031 52037 1 1658 erds Effect of Rates Different than Statutory 9221 0 8890 0 0000 0 0 000046 0 00000 9221 5 2777 PO Permanent Differences ex Equity Adjs 514 308 1385996 811 143 1 896496 5 0 000046 8788 8165895 5245 1 4022 TD Temporary Differences 0 0 000096 50 0 0000 0 0 00006 0 00000 0 0 000096 NOLTD NOLs 511 924 1 149636 0 0 0000 50 0 0000 50 0 0
62. osts Non Cash Tax Adjustment to OTHER NC RTP YEAR NAME eg NC RTP 2006 PERMS Posts Non Cash Tax Adjustment to All Other Current Activi Current Tax Provision excluding activity for Tax Adjustments listed above Posts Current Cash Provision to are some samples of automatic postings Note that they are posted with the Tag Src code of A init Code Fiscal Vear Jursditon Ton Bucket Amount Entry Date FX Rate Description Sre 02000 UAB 200 000 12 31 2007 1 000000 Audit Settlement 02000 353 063 12 31 2007 1 000000 Calculated Provision D2000 OTHER LIAB 32 000 12 31 2007 1 000000 Audit Settlement D2000 RTP UAB 125750 12 31 2007 1 000000 Calculated TrueUp Jurisdiction TxnType Txn Bucket Amount Entry Date FX Rate Description Sre 02000 2007 48 554 12 31 2007 1000000 Celculated Provision 02000 2007 OTHER UAB 2500 12 31 2007 1000000 Audit Settlement 2000 2007 62000 12 31 2007 1 000000 Calcileted TrueUp A 2010 Thomson Reuters 55 ONESOURCE 3 4 2 56 Bucket Configuration Parameters Functionality The default posting payable bucket is the LIAB Liability bucket Eight dataset parameters allow you to configure the bucket to which the automatic posting goes for all units in the dataset Additional parameters allow payable bucket configuration at the unit or unit sta
63. pact both Current and Deferred Tax Expense Deferred Only Tax Expense or Equity Amounts are tracked and shown on reports with a system defined After Tax Temporary Difference code of SYS 2010 Thomson Reuters ONESOURCE Parameters Functionality 3 11 2 Alternative CTA IFRS Dataset Parameter Function Key Key Type Key Value Description 1 activates automatic calculation of Currency CTA_ALT_CALC Alphanumeric 1 Translation Adjustment CTA for all temporary differences via the Alternate calculation through P L Alternative CTA IFRS represents the Current CTA as Tax Expense which is offset Taxes Payable account The Deferred Tax Expense is offset in the Ending Deferred Tax Asset Liability accounts 2010 Thomson Reuters 79 ONESOURCE Parameters Functionality 3 12 Return to Provision RTP Posting Dataset Relations allows three datasets to be associated to enable you to trigger the posting to the RTP true up adjustment A dataset containing return data is related to a dataset with provision data RTP Provision for the same year It is also related to a dataset that contains the current period s provision data RTP Target Dataset relations are assigned in the Administration tab under Manage Datasets gt Datasets gt Dataset Relations Note RTP is available for Corporate Edition 6 0 and higher System Parameter Function The RTP posting by default compares only the activity amounts for temporary d
64. pping screen in the Manage Bridge section of the Administration tab 2010 Thomson Reuters ONESOURCE 3 Estimated Payments Dataset Parameter Function Key Key Type EstPymtPctCushion Decimal Number EstPymtRoundFactor Whole Number 2010 Thomson Reuters Parameters Key Value Number Functionality Description Changes the value of the cushion in the Estimated Payments calculation The system defaults the paramvalue multiple to 1 If the calculated amount should have a 5 cushion the paramvalue should be adjusted to 1 05 If the amount should have a 1096 cushion the paramvalue should be 1 1 The results of the parameter appear on the Estimated Payments reports Determines the rounding factor used in Estimated Payments calculations If the calculated amount should be rounded to the hundreds the paramvalue should be 100 If the rounding should be to the thousands the paramvalue should be 1 000 7 ONESOURCE Parameters Functionality PULL_PAY_FROM_DATASET Alphanumeric Dataset Name Designates the Provision dataset when the Interim dataset should gather data from payments made in prior periods The payments entered in the payable section for the same time period as the Interim dataset with codes ADJ ADJ F 1ES 1ES F 2ES 2ES F 3ES 3ES F 4ES and 4ES F display on the Federal Est Pymt and State Est Pymt reports If the data changes in the Provision dataset for the payments the data needs to be refr
65. r of times a user can enter the wrong password before being locked out of the system Number of unique passwords that must be used before a password can be repeated 2010 Thomson Reuters ONESOURCE Parameters Administration 4 3 Read Write Users These parameters restrict the data entry and modification that Read Write users can perform However they do not affect Administrative users who always have full privileges Read write users can view all data However they are limited in what they can create or modify depending on how parameters are set Here are parameters for read write users e RestrictTA Determines which tax adjustment codes cannot be used for editing existing entries or creating new ones RestrictTag X Determines which tags cannot be used for editing existing entries or creating new ones AWP WRITE Determines whether or not Active Workpapers is read only RESTRICT TD TABS Determines where users can enter data on Temporary Difference screens DEFAULT TD TAB Determines which section of Temporary Difference screens displays Note Parameters can be created before or after entries are created If a user is working in the system while parameters are being created the user needs to refresh the system in order for the parameters to take effect 2010 Thomson Reuters 89 ONESOURCE Parameters Administration 4 3 1 Tax Adjustment Code Restriction Dataset Parameter Function Key Key Type Key Va
66. rmation is shown in the payable with the tag letter C The transaction type has REC added to it PAYRECUNIT Alphanumenc arent Unit Code e When the PAYRECTYPE dataset parameter is activated with a paramvalue of 1 the system reclasses both Federal and State auto posted payables to the unit identified by the unit level parameter PAYRECUNIT When the PAYRECTYPE dataset parameter is activated with a paramvalue of 2 the system reclasses Federal auto posted payables to the unit identified by the unit level parameter PAYRECUNIT Note The paramvalue of 2 is available in versions 6 1 0 and higher Notes This parameter must be created for every child unit for which the payable is to be reclassed Once the SHOW PAYABLERECLASS and PAYRECUNIT parameters are activated the Recalc Payable Reclasses menu option 15 accessed by selecting the Provision tab and clicking Data Review Dataset Recalc Payable Reclasses 62 2010 Thomson Reuters ONESOURCE Parameters Functionality Unit State Dataset Function Key Key Type Key Value PAYRECUNIT Alphanumeric Parent Unit Code Description Available in versions 6 1 0 and higher Reclasses a unit s auto generated payable transactions to a parent unit on the state level Enter the code for the unit in which the payable information should be included as the key value This function is not automatic the reclass must be activated by selecting the Recalc Payable Reclasses option The reclass
67. s 33 ONESOURCE Parameters Reports When you click csc brkout on the Deferred Balances report the following displays SubConsolidated Deferred Balances Report Pre Tax KRW 2005 Provision Development and Testing License CSC1 X Worldwide NOL 001 002 NOL SYS T1000 01 02 03 04 05 06 07 08 09 10 11 12 13 14 TAC16 Name NOL per Sec 382 Analysis Net Operating Loss NOL SYS BAD DEBT RESERVE TEST C Accrued Restructuring Expenses C Accrued Bonus C Accrued Expenses Accrued Expense Advertising Accrued Professional Fees Accrued Rent Income C Accrued Vacation C Credit Allowance C Damaged Goods Allowance Deferred Revenue Other Receivables Allowance NC Partnership Income Loss Prepaid Property Tax Lien Date Section 481 C State Tax CSC1 Domestic CSC1 Foreign Beginning Balance 5 598 605 0 27 259 780 0 1 217 401 1 159 500 942 832 1 141 785 45 668 250 124 668 26 139 344 9 188 374 0 10 173 580 20 507 556 230 549 993 338 28 236 975 4 523 041 Beginning Balance 0 0 306 315 618 1 000 1 421 852 non breakout 34 2010 Thomson Reuters ONESOURCE Parameters Reports 2 4 Journal Entry System Parameter Function There are two types of Journal Entry JE reports Custom 3 and Configurable The fol
68. sswordMinDigits 88 TSPasswordMinLength 88 2010 Thomson Reuters ONESOURCE Manage Restricted Features 5 Mass Update Rate Parameters CountryRates 75 CurrencyRates 75 StateRates 75 Password Parameters PassHistNum 88 TSPasswordExpireDays 88 TSPasswordMinDigits 88 TSPasswordMinLength 88 Password Requirements 87 Payable Parameters AdvLiabPosting 54 FISCAL MONTHS OFFSET 53 LIMIT PAYABLE DATES 53 PAYABLE CPROV BUCKET 56 PAYABLE CPROV DOM STATE BUCKET 56 PAYABLE CPROV FOR BUCKET 56 PAYABLE CPROV FOR STATE BUCKET 56 PAYABLE FXRATE CALC 54 56 PAYABLE RTP BUCKET 56 PAYABLE RTP DOM BUCKET 56 PAYABLE RTP DOM STATE BUCKET 56 PAYABLE RTP FOR BUCKET 56 SHOW ADVANCEDLIABILITY 53 Payable Reclass 60 PTBI 13 2010 Thomson Reuters Parameters PTBI Detail 7 Q Queries 27 47 Rate Parameters CountryRates 75 CurrencyRates 75 StateRates 75 Rates Beginning Deferred FX 78 Ending Apportionment Percentage Ending Deferred 44 Ending Deferred FX 78 Foreign Currency 75 Tax 75 Weighted Average FX 78 Reclass 60 Reclass Parameters 60 PAYRECUNIT 60 SHOW PAYABLERECLASS 60 Regional Settings CANADA 85 EUROPE 85 US 85 Report Format Parameters CLIENTDISPLAYNAME 48 FORMAT FOR EXCEL 49 PRINTFORMAT PAGESWIDE 49 REPORT FOOTER 48 Index 44 97 ONESOURCE Report Format Parameters REPORT HEADER 48 Report Parameters 44 BSOS 42 CLIENTDISPLAYNAME 48 DEF
69. stom TED 1 mu FED RTP REC UAB 400 000 3 31 2009 1 000000 Reclass to par FED ATR REC UAB 200 000 3131 2008 1 000000 Reclass to par FED OTHER REC UAB 200 000 3 31 2009 1 000000 Reclass to par 2010 Thomson Reuters 67 ONESOURCE Parameters Functionality 3 5 Valuation Allowances Dataset Parameter Function Key Key Type Key Value Description 1 activates the Separate Valuation Allowance method This method considers Temporary Differences NOL Temporary Differences and After Tax Temporary Differences separately to determine whether the unit or filing group has an asset that requires a valuation allowance 2 activates the Aggregated Valuation Allowance method This method considers the sum of Temporary Differences NOL Temporary VA_CALCTYPE Alphanumeric 1 2 or 4 Differences and After Tax Temporary Differences to determine whether the unit or filing group has an asset that requires a valuation allowance 4 activates the Aggregated Post Tax Valuation Allowance method This method considers the sum of Temporary Differences NOL Temporary Differences and After Tax Temporary Differences to determine whether the unit or filing group has an asset that requires a valuation allowance It posts on a post tax basis 68 2010 Thomson Reuters ONESOURCE Parameters Functionality Sample Separate Basis Valuation Allowance Calculation This calculation does not follow the Provision rule for the current non current
70. tab under Reports Administration The TS Database Analyzer allows administrative users to run SQL queries on database data Note In versions prior to ONESOURCE Provision Corporate Edition 6 0 this functionality was available by default In version 6 0 and higher the Navigator does not display the TS Database Analyzer option if the parameter has not been added or the paramvalue is 0 47 ONESOURCE 2 7 Formatting Parameters Reports Several parameters are used to format reports e REPORT HEADER 4 e REPORT 1 Formats headers Formats footers CLIENTDISPLA YNA ME Displays the client name in headers PRINTFORMAT PAGESWIDE 9 Determines the number of pages wide FORMAT FOR EXCEL 4 Displays codes as text 2 7 1 Report Headers Footers System Parameter Function Parameter REPORT HEADER REPORT FOOTER CLIENTDISPLA 48 Value Description Up to 200 Enter the text for the page header when a report is printed characters Up to 200 Enter the text for the page footer when a report is printed characters Text Enter the name of the client that will display on report screens in the system as well as in the header of printed reports 2010 Thomson Reuters ONESOURCE 2 7 2 Width System Parameter Function Parameter PRINTFORMAT_PAGESWIDE 2 7 3 Report Format for Excel System Parameter Function Parameter FORMAT_FOR_EXCEL 201
71. te level in two cases if dataset level parameters have not been configured or to create an exception to dataset parameters Dataset Parameter Function Key Key Type PAYABLE CPROV DOM BUCKET Alphanumeric PAYABLE CPROV FOR BUCKET Alphanumeric PAYABLE CPROV DOM STATE BUCKET Alphanumeric PAYABLE CPROV FOR STATE BUCKET Alphanumeric PAYABLE DOM BUCKET Alphanumeric PAYABLE RTP FOR BUCKET Alphanumeric Key Value Payable Bucket Code Payable Bucket Code Payable Bucket Code Payable Bucket Code Payable Bucket Code Payable Bucket Code Description Defines the payable bucket to which Domestic Units Federal Current Cash Provision posts Defines the payable bucket to which Foreign Units Current Federal Cash Provision posts Defines the payable bucket to which Domestic Units State Current Cash Provision posts Defines the payable bucket to which Foreign Units Current State Cash Provision posts Defines the payable bucket to which Domestic Units Federal Tax Adjustments with codes NC RTP and NC ATR post Defines the payable bucket to which Foreign Units Federal Tax Adjustments with codes NC RTP and NC ATR post 2010 Thomson Reuters ONESOURCE Parameters Functionality Payable Defines the payable bucket to which Domestic Units State FAVARCE AU DOM_STATE BUCKET Alphanumenc a Tax Adjustments with codes NC_RTP and post PAYABLE RTP FOR STATE BUCKET
72. the same tag All permanent and temporary difference activity with the designated tag letter displays in the GAAP to STAT adjustments section This activity is added to PTBI to arrive at PTBI in Local STAT All other permanent and temporary differences that did not have the designated tag letter display in the section that shows STAT to Tax adjustments Note The same letter should be used for each set of gstags and GAAPTOSTAT parameters 13 ONESOURCE Parameters Reports Multiple tag letters can be assigned for GAAP to STAT entries In the following example entries made with both Q and L tags display in the GAAP to STAT section of the Tax Provision Parameter SHOW GAAPTOSTAT GAAPTOSTAT gstags TAG GAAP to STAT GAAPTOSTAT 1 gstags 1 TAG G to S 1 oppe 14 2010 Thomson Reuters ONESOURCE Parameters Reports Sample Report Provision Report GAAP to STAT KRW 2009 Current Provision A Development and Testing License F2000 UK view detail unit comparison Corporation Profit Before Taxes 3 000 000 Permanent Differences GAAP to STAT 5 000 Temporary Differences GAAP to STAT 0 PBT Local STAT 3 005 000 Deductible Sub National Tax 1 804 764 Permanent Differences STAT to Tax 540 Temporary Differences STAT to Tax 2 120 National Taxable Income Loss 1 202 896 Tax Loss Reclass 20 000 National Taxable Income Post Tax Loss 1 222 896 Unit Ta
73. to the user defined states Note States need to be added in lowercase For example to add California you could add a user defined state with the code ca 1 removes the consistency constraints when creating a sequential reporting dataset You can then create sequential datasets in which the ending balances and rates in the first dataset do not agree with those of the next dataset Note A warning displays each time you add a dataset saying that your endings and beginnings might not be lined up correctly 83 Parameters Functionality 84 2010 Thomson Reuters ONESOURCE 3 15 Regional Settings System Parameter Function Parameter Value GlobalRegion US or EUROPE or CANADA 2010 Thomson Reuters Parameters Functionality Description This parameter determines the regional settings of the system The US and CANADA paramvalues format amounts using comma to separate thousands and a period to separate decimals The EUROPE paramvalue formats amounts using period to separate thousands and a comma to separate decimals The US paramvalue uses the term Pre Tax Book Income The EUROPE paramvalue uses the term Profit Before Taxes The CANADA paramvalue uses the term Earnings Before Income Tax The US and CANADA paramvalues use the term Federal The EUROPE paramvalue uses the term National The US paramvalue uses the term State The EUROPE paramvalue uses the term Sub
74. tomatic posting of the provision SHOW ADVANCEDLIABILITY amount you must also enable the dataset parameter AdvLiabPosting 54 Important The SHOW LIABILITY system parameter must be set to 0 Y is the default setting It restricts you from entering a date in the Payable Entry screen that does not fall within the dataset period For example if the dataset is a LIMIT PAYABLE DATES YorN full year 2009 dataset you can only enter payable activity with dates from 1 1 2009 through 12 31 2009 Entering N removes the restriction and you can enter any date The system posts the provision amount based on a calendar year A full year provision amount would post a date of 12 31 xx When you have a fiscal year end enter a number from 1 to 11 to adjust the auto posting date to reflect a fiscal year Ending balances roll over to create beginning balances with the code BBAL and a date of fiscal year end plus 1 day For example If the paramvalue is 3 CPROV posts with a date of 9 30 CY and BBAL posts with a date of 10 1 CY FISCAL MONTHS OFFSET 1 to 11 Note If you were previously using the Liability tab the data needs to be migrated before using the Payable module For more information contact your client manager or ONESOURCE Tax Provision Support Call 877 829 5969 option 2 or email provisionsupport thomsonreuters com 2010 Thomson Reuters 53 ONESOURCE Parameters Functionality 3 4 1 Autoposting Current provision amounts
75. view It uses the columns as defined in the Manage Deferred Rollforwards screen This parameter only works when the USE SPDEFBALREPORTS parameter is activated and the DEF RF SUMMATION COLUMN parameter is defined The text entered in the Value field displays as the column header for the sub total column Typically this sub total represents adjusted beginning balances However it could be used for any sub total 2010 Thomson Reuters ONESOURCE Parameters Reports Sample Report When the DEF RF SUMMATION COLUMN is 3 and the DEF RF SUMMATION is Adj Beg Balance and you select the expanded b s view the Deferred Balances report displays as follows Deferred Balances Report Pre Tax KRW Standard Rollup NOL Rollup Current Non Current Classification default summary hybrid detail unit pre tax 2009 Current Provision A Development and Testing License Federal State FBOS Federal State FBOS State FBOS 000 i all c nc F2 UK Corporation contracted expanded b s c Beginning Rate AUDIT Current OTHER OTHER Ending Balance Change Balance Activity RTE ADJ ACT B50 Balance NOL_002 Net Operating Loss 45 000 0 20 000 65 000 0 0 0 0 0 0 65 000 713000 Bad Debt Reserve 20 0 20 0 0 0 0 0 0 20 20 T14000 Book Depreciation 0 0 0 0 0 0 10 090 0 0 0 10 090 Accrued General and T4000 Admin E 4 000 0 0 4 000 0 0 0 2 000 0 0 6 000 SYS NOLTD C SYS NOLTD C 0 0 0 0 0 0 0 0 0 0 0 VA SYS NOLTD N
76. x Rate 30 0056 National Tax Current 365 359 After Tax Temp Differences 0 Cash Tax Adjustments 0 2010 Thomson Reuters 15 Parameters Reports 2 2 Effective Tax Rate System Parameter Function Parameter Value Description 1 activates additional views of the Effective Tax Rate ETR report On Unit and Filing Group level ETR reports the Use Unit Tax Rate Use Group Tax Rate views toggle between displaying the rate reconciling to the Group Rate selected for the dataset or the Unit s current tax rate This view option only displays in versions 6 0 and higher EFFRATEBRKOUT 0 or 1 On Sub Consolidated and Consolidated level ETR reports the Use Blended Rate Use Group Tax Rate views toggle between displaying the rate reconciling to the Group Rate selected for the dataset or the Unit s current tax rate The reconciliation starts either with PTBI at the Group Tax rate or at the Blended rate of the underlying units in the sub consolidation consolidation This option only displays in versions 6 1 and higher 16 2010 Thomson Reuters ONESOURCE Parameters Reports Sample Reports Consolidated Subconsolidated Level No Breakout Consolidated Effective Rate Report Local summary detail 2009 Current Provision Developement and Testing License Component PTBI Tax Effect Pre Tax Book Income 6 756 890 2 364 912 FX Adjustment 0 State and Local Income Taxes 3 062 032 666 Effect of
77. y state End Statutory Rate 0 00 30 00 30 00 Expected Rate 0 00 30 00 30 00 60 00 60 00 44 2010 Thomson Reuters ONESOURCE 2 5 5 State Summary Provision Summary System Parameter Function Parameter Value USE SPPROVSUMMARYREPORTS 0 or 1 2010 Thomson Reuters Parameters Reports Description 1 activates the Stored Procedure view of the Provision Summary report under State Summary The Stored Procedure view provides an alternate view and additional functionality On the Unit level the default view excel breakout states changes to breakout States e On the Consolidated and Sub Consolidated levels the default view excel breakout states changes to breakout by Unit States The breakout subconsolidated by State view displays the detail by consolidated state This parameter allows the state breakout to display onscreen vs exporting to Excel 45 ONESOURCE Parameters Reports Sample Report Available views breakout by Unit States breakout subconsolidated by State Unit State Provision Report KRW 2009 Current Provision A Development and Testing License F2000 UK Corporation F2000 TOTAL BS Blended State Book Income 3 000 000 Perm Diffs includible for State 10000 Meals and Entertainment 5 540 Total Perm Diffs includible for State 5 540 Modifications P1000 Club Dues 560 0 Total Modifications 560 0 Temp Diffs
78. ystem Parameter Function 2010 Thomson Reuters If no value is entered no ATTD are included in the calculation 51 Parameters Functionality Parameter Value Description Designates where the difference is posted on the Deferred Analysis screen when Ending Balances are entered vs Activity for Book Tax Basis Temporary Differences on the Manage Deferred Rollforwards screen DefEndBalDefault Source Tag A D B Examples e O A uses tag O and posts as Activity e X D uses tag X and posts as Deferred Only e C B uses tag C and posts as Balance Sheet Only Dataset Parameter Function Key Key Type Key Value Description Designates at the dataset level where the difference is posted on the Deferred Analysis screen when Ending Balances are entered vs DefEndBalDefault Alphanumeric Source Tag A D B Activity for Book Tax Basis Temporary Differences on the Manage Deferred Rollforwards screen Note The dataset DefEndBalDefault parameter overrides the DefEndBalDefault system parameter For more information refer to the Corporate Edition User manual 52 2010 Thomson Reuters ONESOURCE Parameters Functionality 3 4 Payable Payable allows you to capture payable information on a dataset basis broken out by federal and state Ending balances roll over to become beginning balances when the dataset rolls over System Parameter Function Parameter Value Description 1 activates the Payable functionality To activate au

ONESOURCE TAX PROVISION

Contents

Download Pdf Manuals

Related Search

Related Contents