Home

User Manual - Administrator

1. 2010 Thomson Reuters 35 ONESOURCE Global Access iTaxStream Administration Users can view all datasets not just those published to Global Access SHOW_NEWWIZAR 1 Shows the wizard status report Hidden DSTATUS SHOW_WIZARD 1 Shows the Manage Active Datasets page where a user Hidden publishes datasets to Global Access UserAdminComponen 61 62 63 Makes Preparer 1st Reviewer and 2nd Reviewer Hidden tTypes viewable on the Administer Users Administration page UsersExtended 1 Shows multiple entry fields for user contact information Hidden Unit Data On the Unit Data page the following parameters can be used to open close and lock down fields Parameters highlighted in the same color must be used together itstbptbiinc yeprov 1 Summary Default PTBI 1000 Allows users to designate the trial balance subline that displays the Income section of the Income Statement Detail The param value must be the code to a trial balance subline Hidden itstbptbiinc yeprov 2 PTBI 1005 Allows users to designate the trial balance subline that displays the Income section of the Income Statement Detail The param value must be the code to a trial balance subline Hidden itstbptbiinc yeprov 3 PTBI 1010 Allows users to designate the trial balance subline that displays the Income section of the Income Statement Detail The param value must be
2. lt b gt Instructions lt b gt lt ul gt lt li gt The input below should reflect items that impact the tax payable account eg a tax payment to the government or a tax refund from the government lt li gt lt li gt Debits should be lt b gt positive lt b gt Credits should be lt font color red gt lt b gt negative lt b gt lt font gt lt li gt lt li gt Fill in payments refunds and adjustments using your lt b gt local currency lt b gt in lt b gt whole units lt b gt lt li gt lt li gt Beginning balance plus minus payments refunds and adjustments must equal your ending balance lt li gt lt li gt Amount per financials statement and the computed amount must agree to the Journal Entry Comparison report lt li gt lt ul gt The sample shows the instructions written in well formed HTML We have written a specific text file for every page Users can change the text and upload modified files Refer to the attached file Instructions for Global Access Module The screen shot below shows the instructions as they display on the page Cash Instructions The input below should reflect items that impact the tax payable account eg a tax payment to the government or a tax refund from the government Debits should be positive Credits should be negative Fill in payments refunds and adjustments using your local currency in whole units Beginning balance plus minus payments refunds and adjust
3. This is the number of days until the user has to reset TSPasswordExpireDays 100 their password to log into the system It can contain any value greater then zero This is the minimum number of digits that must be TSPasswordMinDigits 1 present in a user s password The numeral can be any value but the default is 1 TSPasswordMinLength 6 This is the minimum length counting all characters be it letters or numbers that must be present in a users 2010 Thomson Reuters 33 ONESOURCE Global Access iTaxStream Administration password This can be any value but the default is set to 6 Makes Preparer 1st Reviewer and 2nd Reviewer Page adminGomponently pes Els viewable on the Administer Users administration page SHOW_GAAPTOSTAT 1 Shows the GAAP to STAT report Sets up the letter G as the designated GAAP to STAT gstags1 G T ag TAG GAAP TO STAT G Adds the letter G to the drop down menu for the Tags in Corporate Edition EE M Manual Adds the word Manual to the drop down menu for the gp yeprovg Tags in Global Access for perms H RS RE ene M Manual Adds the word Manual to the drop down menu for the gtemps yeprovg Tags in Global Access for temps SHOW_ADVANCEDLIABILITY 1 Activates the Payable Module Shows the payable data entry page and reports SHOW SIMPLELIABILITY 0 Hides simple liability report SHOW WIZARD 1 Activates the Manage Active Datasets screen
4. 2010 Thomson Reuters 49 ONESOURCE Global Access iTaxStream Index A Activating Payable Posting 18 Activity 18 Administration 7 8 ATR 22 27 33 40 43 Balance Sheet Only 18 C Categories 7 Change Password 21 Code 7 Components 18 Concepts 7 Country Codes 8 CTA 12 Currency Codes 8 Currency Translation Adjustment 10 Currency Types 9 Current 16 D Dataset 20 Datasets Management 7 Deactivate Units 8 Deferred Only 18 Deferred Rollforward 17 Index Data Entry 22 Filing Group 8 Attributes 8 Automation 8 Child 8 Parent 8 Reporting 8 Filing Unit 8 Foreign Currency Issues Change in Rate 9 Currency Translation Adjustments 9 Currency Types 9 Deferred Balances 9 Foreign Exchange Rates 9 FXRates 9 PTBI Treatment 9 Functional Currency 9 G GAAP to Stat 33 H Hybrid 18 Hyperinflationary Environment 9 L Local Currency 9 Missing Page 7 N National Data Entry 22 NOL Rollforward 17 Equity 16 Non Current 16 FAS52 9 Overview 6 Federal 50 2010 Thomson Reuters ONESOURCE Global Access iTaxStream Index P Ts P amp L 16 Tag Letters 8 P amp L vs Equity 16 Terminology 7 Password 21 Thousands Separators Currency 9 Payable Activating Payable Posting 18 U Pre Populated Codes User Component Access 48 Unit 20 Provision to Return 22 27 33 40 43 Domestic 8 Foreign 8 R EN Unit List 20 User Component Access Codes 48 Rate Change 12
5. Local Currency Reporting Policy PTBI Currency PTBI FX Rate Rounding Enter Local FX and Calc USD Entered Calculated Entered NA Enter USD FX and Calc Local Calculated Entered Entered NA Enter Local USD and Calc FX Entered Entered Calculated NA Enter Local USD and FX Entered Entered Entered NA Enter Local USD FX and Calc Rounding Entered Entered Entered Calculated e When using the last two policies the Effective Tax Rates may differ in Local Currency and Reporting Currency because the PTBI is using a different Weighted Average rate than the entered Weighted Average Regardless of the policy selected amounts other than the PTBI are converted at the entered Weighted Average or Spot Rate If the unit is using the Enter USD FX and Calc Local FX policy you cannot save the PTBI amount you entered It will always revert back to the amount calculated To modify the amount the unit must have another policy Depending on the PTBI policy in use certain fields default to read only Any component that is selected to be calculated by the system automatically becomes read only in the system For example if the Enter Local USD Calc FX policy is selected the Weighted Average FX Rate automatically becomes a read only field on the Unit Data page in Global Access Enter Local FX and Calc USD 10 2010 Thomson Reuters ONESOURCE Global Access iTaxStream ONESOURCE Tax Provision Concepts fewrensy AE Corporate US GAAP Pre
6. Access iTaxStream Logging In Logging In Because Global Access is a web based tool users are given a web address with a username and password to log in Administrators can set up a forced password change in Corporate Edition for Global Access users on their first login In this case users view the Change Password page on their first login and are then redirected to the Introduction page When users log in to Global Access the Introduction page displays This page contains an introduction prepared by the Corporate Tax Department as well as a general explanation of the software The Global Attachments section displays documents uploaded by Corporate Review the instructions and documents If you need assistance click the Corp Tax Dept Contacts link for contact information When you are ready to proceed click Next You can also click Unit List from the left navigation Session Timeout A pop up message appears onscreen a minute before a session will time out This message lets you know you will be logged out of the application You have two options e Click OK to close the popup and continue the session The clock automatically resets for a new 30 minute timeout e Click Cancel to end the session and be directed to the Logout page Unit List The Unit List page displays the entities for which each user is responsible Each unit has been given a legal entity name and an identification number The control grid shows the status of wo
7. Cash Activity NC_RTP Dataset Year minus 1 RTP Calculated True Up NC_RTP_YEAR_NAME Year entered after NC_RTP_ RTP Calculated True Up NC_ATR Dataset Year minus 1 ATR Audit Settlement NC_ATR_YEAR_NAME Year entered after NC_ATR_ ATR Audit Settlement All other NC_ codes Dataset Year OTHER Audit Settlement e The Federal amount is posted in the Federal Payable Entry Each State is posted in that State s Payable Entry e To return to manual entry an Administrative User can turn off the automatic posting to the Payable module by deleting the dataset parameter or by changing the key value from Y to N Exchange Rates e All amounts entered in the Payable should be in local currency e The Payable Entry page allows for the weighted average FX rate to be entered on a transaction by transaction basis Automatic Postings are pre populated with the unit s weighted average FX rate but this can be changed e The CTA is computed on a transaction by transaction basis using the transaction s weighted average FX rate and the unit s Ending Spot Rate CTA amounts display on the Payable Detail report e The Payable Detail report can be viewed in both Local Currency and Reporting Currency Customer Support e Phone 877 829 5969 option 2 e Email provisionsupport thomsonreuters com e Support Site e http www taxstream net taxstream support e The user name is taxstream e The password is Tabha1rcain 2010 Thomson Reuters 19 ONESOURCE Global
8. Corporate Tax Dept Contacts List of Files Filename Description Code Show Download Delete export categores 10 04 2007 10 51 am xis test Corp Contacts No Do cad Je_merck1i xsl Journal Entry JE1 Attach New File File Description Code Show on Intro Page Journal Entries Administrators can upload Journal Entry reports in the Manage Global Attachments page Customized JE Reports je1 xsl 1 Click Browse to locate the je1 xsl file 2 Enter JE1 as the code 3 Add a description 4 Select No from the Show on intro page drop down list 5 Click Attach Configurable JE Reports outputjesbase xsl Note Configurable JE reports are available only in versions 6 1 or higher 1 Click Browse to locate the outputjesbase xsl file 2 Enter outputjesbase as the code 3 Add a description 4 Select No on show on intro page Drop down 2010 Thomson Reuters 31 ONESOURCE Global Access iTaxStream Administration 5 Click Attach You also need to upload a configurable menu item for each configurable report so that a link displays on the menu The format for each link is lt Menultem order a number name name of the report link tswReport jsp reportstr reportstring amp amp stylesheet the code of the appropriate stylesheet gt Example lt Menultem order 12 name Output JE Base Unit Detail link tswReport jsp reportstr r14650000008amp stylesheet outputjesbase gt Plug in Re
9. Current Income Tax Rate and the Ending Deferred Rate in the boxes below the Beginning Deferred Rate is pre populated F1000 German Corporation ze from Corporate Tax Department The Current Income Tax Rate is used to compute the current tax provision The Ending Deferred Tax Rate is the rate at which future income or expense items will be recognized Ending deferred rates should Data Entry reflect any enacted future tax rate changes HARE A e Click on the Save Changes button e Unit Data Proceed to the next step e Income Tax Rates Statutory Tax Rates used to calculate your provision Current Income Tax Rate 200 Beginning Deferred Rate Return To Provision Questionnaire Sign Off Ending Deferred Rate Reports Tax Provision Effective Rate Deferred Balances NOL Balances Temp Diff Summary Temp Diff Summary FE e Liability Summary Unit Summary P amp L Equity Each permanent difference entry needs to be designated as a P amp L or Equity entry e Inthe data entry page for Permanent Differences there is a drop down menu to select P for P amp L and E for Equity e A P amp L P entry results in a current tax provision expense offset in the payable account The result impacts the overall effective tax rate e An Equity E entry results in a current tax provision expense offset in the payable account as well as an equity contra expense that is offset in
10. H the Permanent difference type Editable type P amp L and Equity dropdown The default type becomes P for P amp L when this parameter is used Temporary Differences On the Temporary Differences NOL Temps After Tax After App State Temps and State After Tax Temps page the following parameters can be used to open close and lock down fields The section highlighted in purple only applies to the Temporary Differences and Local Temporary Differences pages 38 2010 Thomson Reuters ONESOURCE Global Access iTaxStream Administration itsswitch yeprov endbalinput Allows users to enter the ending balance or the activity for all temporary differences including NOL After Tax Temps Local Temps After App and State After Tax Temps The default when this parameter is used is to enter ending balance When a user enters this parameter the Activity column become calculated values Note This functionality has not been added to the Temporary Differences U S GAAP STAT and Temporary Differences STAT Local TAX pages Hidden itsswitch yeprov cnc Allows users to Hide H make Read Only R or Editable W the current non current field When this parameter is used any new temps will be set up as C or Current Editable itstagtemps yeprov 1 M Manual Adds the paramvalue as one of the tags in the tags drop down menu For example if M Manual is used then the user sees Man
11. Records Activate 8 W peace R Weighted Average Rates 10 Rollover 8 State 8 Unit 8 Reporting Currency 9 Reports 48 CSC Custom Sub Consolidation 8 Current Non Current View 16 Deferred Balances 17 NOL Balances 17 Rollup 18 SC Sub Consolidation 8 Return to Accrual 22 27 33 40 43 Return to Provision 22 27 33 40 43 RTP 22 27 33 40 43 S Source Code 8 Special Characters 48 Spot Rates 10 Src Code 8 Status 20 Sub Consolidations 8 Summary 18 Support 19 System Code 7 2010 Thomson Reuters 51 Proprietary Materials No use ofthese 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 ONESOURCE All contents copyright O 1999 2010 Thomson Reuters ONESOURCE
12. SO RTP 3 posts when the status of the unit changes from Prepared to 1st Level Reviewed Text entered displays as an option in the Col Type drop down list in the Manage Active Datasets screen under the Administration tab adscoltype_ Text Examples Q1_actual Q1_forecast retprov yeprovgs yeprov SHSMEROVANGENQUESTIONNAIR 0 Hide OF 1 activates the Global Access Questionnaire format E 1 Show 1 activates the Foreign Domestic classification Country O Hide or and Currency for each unit on the Questionnaire CHES TONNARE UNITDETA LS 1 Show Summary report Global Access Questions report Corporate Edition 1 activates the Questionnaire Summary report Global O Hide or Access Questions report Corporate Edition with units 18 OUES TONNAIRE LAYOUT 1 Show down the left column and full questions across the top Answers populate the grid 1 enables RTP adjustments for temporary differences O Hide or tagged with R to be posted as deferred only adjustments POST AMORTZD 1 Show on tax basis in the Temporary Differences Book Tax Basis screen Entry Fields Configuration Note The following parameters apply to more than one page throughout the system Paramvalue Summary Default SHOW_DSCOMP 1 Allows others to view entries for datasets in the system Hidden This is only available for Permanent Temporary NOL Temps and After Tax Temporary Differences Note
13. State Jurisdiction Attachments Rollup Codes etc e System Items User Rights Audit Trail Transactions etc Activity Deferred Only Balance Sheet Only Entries that impact deferred tax accounts need to be designated as activity deferred only or balance sheet only In the data entry page for Temporary NOL After Tax and Local NOLs there are options for Activity Deferred Only and Balance Sheet only e Deferred Balances and NOL Balances reports can be configured to view activity deferred only and balance sheet only adjustments separately e Go to Where to Enter Items in ONESOURCE Tax Provision to find out more about entering amounts as Activity vs Deferred Only vs Balance Sheet Only Activating Payable Posting e Payable functionality can track payments refunds and other adjustments in the taxes payable account Automatic posting of current tax expense can be activated on a dataset by dataset basis e The payable report can be configured with setup items in the payable section of the Administration section e An Administrative User can add a Dataset Parameter which allows the provision to post automatically to the Payable section Current Provision Posting Fiscal Year Payable Txn Payable Code Description Cash Activity Current Tax Provision excluding Dataset Year CPROV Calculated Provision Tax Adjs with NC_ code 18 2010 Thomson Reuters ONESOURCE Global Access iTaxStream ONESOURCE Tax Provision Concepts Non
14. a temporary difference item is created you can edit or delete it by clicking the appropriate icon Click the pencil icon to edit the entry Select Save Changes after making any changes You can attach files to individual temporary difference item on this page If you have supporting documents click the paper clip icon next to the item The impact of individual temporary differences on your tax provision can be viewed on the Tax Provision report and the Effective Rate report 24 2010 Thomson Reuters ONESOURCE Global Access iTaxStream Data Entry 2010 Thomson Reuters 25 ONESOURCE Global Access iTaxStream Administration Administration Administrators can use Corporate Edition to manage users and configure Global Access to meet their needs Although most administrative functions in Corporate Edition are related to the initial setup of Global Access the Global Access Administration page provides Administrators with the flexibility to modify instructions and questionnaires Note Only Administrators have access to the Global Access Administration section The URL for this section is http your Global Access Module link here admin Sign Off Sequence On the Sign Off Setup page Administrators set up users sign off roles using the matrix on the page They can configure each sign off level and grant specific access levels i e read only and read write access O read write read write O read Write O Sig
15. an equity account This does not impact the overall effective tax rate Current Non Current Some accounting conventions notably IFRS and US GAAP require deferred tax balances to be designated as either current or non current The system forces this distinction so that entries that impact deferred tax accounts need to be designated as either current or non current e The data entry screens for Temporary NOL Temporary and After Tax Temporary Differences have a drop down menu where you select C for Current or NC for Non Current e Deferred Balances and NOL Balances reports can be filtered to view current and non current balances separately e The Temporary Difference Summary report displays current and non current balances by asset and liability 16 2010 Thomson Reuters ONESOURCE Global Access iTaxStream ONESOURCE Tax Provision Concepts Deferred Rollforward The expanded view of the Deferred Balances and NOL Balances reports has user defined columns to which data can be mapped e Each of three types of deferred activity can be mapped by tag letter to a column used to configure the Deferred Balance and NOL Balances reports e There can be up to 26 user defined columns You can use as many as you need e Administrators are responsible for creating and maintaining the Manage Deferred Rollforward and Manage NOL Rollforwards screens in Corporate Edition e The Deferred Balances report can be configured in the Manage Deferred Rollf
16. data you have the option to have true up adjustments posted to the current year s provision dataset Automatic posting of return to provision adjustments can be triggered in one of two ways your sign off status or clicking the Post RTP button on the Return to Provision page Administrators can decide the sign off level at which the automatic return to provision adjustments are posted to the entity For example selecting the Incomplete to Prepared option causes return to provision adjustments to automatically post once the preparer signs off on the entity Alternately administrators can add the necessary parameter so that users can click the Post RTP button In addition to the setup above users must set up tax adjustment codes for the automatic posting functionality to work properly For tax adjustments to automatically flow through to the payable use the following codes NC RTP YYYY PERM This takes care of true ups for Pre Tax Book Income permanent differences and tax adjustments and NC RTP YYYY TEMP This takes care of true ups for temporary differences NOL temporary differences and after tax temporary differences Note In versions 6 1 and higher Administrators can Manage Questionnaires Administrators use the Manage Questionnaires page to create dataset specific questionnaires To activate this page enable the Advanced Questionnaire parameter Questions are assigned a unique code and are ordered according to the coding schem
17. on the type of dataset published in Global Access the menu can be configured e g menu_yeprov for a regular dataset menu_yeprovgs for GAAP to STAT datsets and menu_retprov for return to provision datasets to show different options If you would like to modify the menu bar contact Support Manage Global Attachments Instructions Use this page to upload your global attachments To allow for the downloading of your attachment on the Introduction Page select Yes for Show on Intro Page Certain codes are designated for different items in your TaxStream For instance O The code Corp Contacts will use your upload as the Corporate Tax Dept Contacts List of Files Filename Description Code Show Download Delete Attach New File File Pay MenuConfig ml Browse Description Ye Prov New Menu Code menu_yeprou Show on Intro Page No Attach Parameters Administrators can show hide and lock fields on Global Access pages using parameters Global Access Configuration Because a large part of Administrators can show hide and lock fields on Global Access pages using parameters is user configurable the initial configuration of settings is often time consuming As a Corporate user you must configure Global Access to your specifications keeping in mind the wishes of your local users Certain parameters must be activated to make the system more user friendly and secure Parameter Value Function
18. plus minus payments refunds and adjustments must equal your ending balance lt li gt lt li gt Amount per financials statement and the computed USD amount must Agree See Income Tax Acct Report lt li gt lt ul gt tsw UnitATTempDiffs txt lt b gt Instructions lt b gt lt ul gt lt li gt An after tax temporary difference is a modification to the current and future tax provision which is reported on an after tax basis lt li gt lt li gt Add each after tax temporary difference as follows lt ul gt lt li gt Select the appropriate after tax temporary difference from the drop down lt li gt lt li gt Enter the amount using your lt b gt local currency lt b gt in lt b gt whole units lt b gt lt li gt lt li gt Click on the Add New button lt li gt lt ul gt lt li gt lt li gt The deferred only input should be used for activity that impacts the deferred provision but not the current provision lt li gt lt li gt If additional new After Tax Temporary differences are required contact the Next Tax Office lt li gt lt ul gt tswUnitNOL s txt lt b gt Instructions lt b gt lt ul gt lt li gt Enter the net operating losses that will be reported on the income tax return for this legal entity lt li gt lt li gt Add each net operating loss as follows lt ul gt lt li gt Select the appropriate net operating loss from the drop down lt li gt lt li gt Select the current or non current designation lt li
19. the code to a trial balance subline Hidden itsswitch yeprov showinctotal Allows users to show the Total Income calculated line A sum of the trial balance lines representing income lines Hidden itstbptbiexp yeprov 1 PTBI 1015 Allows users to designate the trial balance subline that displays the Expense section of the Income Statement Detail The param value must be the code to a trial balance Hidden 36 2010 Thomson Reuters ONESOURCE Global Access iTaxStream Administration subline itstbptbiexp yeprov 2 PTBI 1020 Allows users to designate the trial balance subline that displays the Expense section of the Income Statement Detail The param value must be the code to a trial balance subline Hidden itstbptbiexp yeprov 3 PTBI 1025 Allows users to designate the trial balance subline that displays the Expense section of the Income Statement Detail The param value must be the code to a trial balance subline Hidden itsswitch yeprov showexptotal Allows users to show the Total Expenses calculated line A sum of the trial balance lines representing expense lines Hidden itsswitch yeprov showptbitotal Allows users to show the Corporate GAAP Pre Tax Income calculated Line A sum of Hidden the Income and Expense subtotals weighted average FX Rate field read only R Note Depend
20. Current Activity Deferred Only Balance Sheet Only Ending Balance 11000 Bd Deb Reserve 7 273 0 0 80 000 total 7 273 30 0 80 000 Deferred Balance Report in the Income Statement View e Currency Translation Adjustment e Deferred Balances in USD are translated from the Local Currency Balances using Beginning and Ending Spot FX Rates e USD Change in Deferred Balances Begin Activity Ending Local Currency Balance 100 000 10 000 110 000 Tax Rates Begin and End 35 40 Local currency tax effected 35 000 44 000 Beginning and Ending FXs 0 45 0 55 USD tax effected 77 778 80 000 Beginning DTA L Ending DTA L 2 222 e Deferred Expense in USD is translated from Local Currency Activity using Weighted FX Rates e USD Deferred Expense Begin Activity Ending Local Currency Balance 100 000 10 000 110 000 Tax Rates Begin and End 35 40 Local currency tax effected 35 000 44 000 Weighted Avg FX oan Lg USD tax effected 70 000 88 000 Deferred Provision Expense 18 000 14 2010 Thomson Reuters ONESOURCE Global Access iTaxStream ONESOURCE Tax Provision Concepts e Currency Translation Adjustment Computation e Adjusts the Weighted Average FX Impact and the Ending Spot FX Rate Beginning and Ending FX rate is consistent with Deferred Balances Report Beginning DTA L Ending DTA L 2 222 Change in DTA L balance 2 222 CTAto Adjust Spot FX to Plus CTA 1 5 778 pr EN AE Total Deferred Prov Expens
21. Enter the amount of the permanent difference in local currency 4 Click Add New to create the permanent difference Note If a new permanent difference item is required contact the Corporate Tax Department After a permanent difference item is created you can edit or delete it by clicking the appropriate icon Click the pencil icon to edit the entry Select Save Changes after making any changes You can attach files to individual permanent difference item on this page If you have supporting documents click the paper clip icon next to the item The impact of individual permanent differences on your tax provision can be viewed on the Tax Provision report and the Effective Rate report Temporary Differences STAT T AX The Temporary Differences STAT TAX page allows you to enter differences between book income computed under Statutory Law and Local Tax Law in your country that are temporary in nature These differences will reverse in the future 2010 Thomson Reuters 23 ONESOURCE Global Access iTaxStream Data Entry Temporary Diffs STAT Local TAX O previous next Unit German Corporation F1000 Dataset 2009 Provision GAAP STAT Instructions e A temporary tax difference is created from items of income and expense which are allowed for both financial and income tax purposes butrecognized in different accounting years eg depreciation certain reserves e Beginning Balance is pre populated from the Corporate Tax Departmen
22. F COM AIN ananas 22 Permanent Differences STAT TAX tennes 22 Temporary Differences STAT TAX entert torente tnrtn teretane 23 2 2010 Thomson Reuters ONESOURCE Global Access iTaxStream Contents Administration 26 Hl Le e E UTC TE 26 E Mail Noticas 26 Return 10 PFOVISION iii i 27 Manage Questionnaires seerssessvanvenseaueaveruveneavenuvanvensennenvesuvensensensenneensensensensvenvensensen 27 CMA CEG RS ue 28 Manage Instructions sesenessesseanenueaeneusenvenvaneeneanenuennennennenensenvenenneenennennennensennenvenseneenenne 28 heten a 29 Manage Global Attachments nn 31 JOURNAL Ernies A A A a ci 31 PU ed 32 Corporate COMTAC S odian te ion one tane 32 erger dee 33 FADNES unan EP Ne RON EN EP iian 33 Global Access Confiquration nn 33 Entry Fields Cp 35 Unit Data samada ei eE ro a aE daa 36 Income Tax EH 38 Permanent Dittereneesg hiere ira aara a anaa eaaa dd 38 Temporary Differences nn 38 OE RR ET 39 Atter Tax TEMPS an Re ee ea eee ee es 40 Return to Pro aiii 40 Payable iii R 40 Tax Adjustments eaan aia 41 Selected Account e a dt id 41 Configuration of Global Access in Corporate Edition 42 User Administration 42 Sign Off Levels nia 42 Publishing Datasets messeasenseaveaveasenveuvanvenvavenuenvenuenuenuensensensenveneavennennensennennensennenseneensnneen 43 Administer PermiISSiONnS
23. ONESOURCE TAX PROVISION Global Access iTaxStream Administrators 6 1 0 User Manual A ee eer THOMSON REUTERS a ONESOURCE Global Access iTaxStream Contents Table of Contents 6 1 Release Overview 4 Overview 6 ONESOURCE Tax Provision Concepts 7 Godes ale 7 System Codes nic un unnnnn nunu nenneeenenennenennnn nenna 7 Naming ConventiOnsS musenneeutenuvenueanennvenneensenuennvnnsennsenneensennsensennsenneenneensennsensennsennvenneene 7 AE re 7 UG Fr 8 e e E EN E 8 Filing Group tata 8 Tag Letters ai A A A e le 8 Records Une ii 8 Foreign Currency ISSUES nanas 9 Currency Types and OptiOnS vara 9 Foreign Exchange Rates nn 10 Pre Tax Book Income PTBI Policies 1 10 Change i Rate and ETA edad 12 RO ET SNE 16 Current Non Current nent 16 Deferred Rollforward mnensesuteauvanveauveanvensenusenuvanuenneennvensennvensennsennenneensennensennsenneensennsenn 17 Rollup CodeS mme 18 SPENN nnna nn anana eden eens tars 18 Activity Deferred Only Balance Sheet Only seessenseaseesveaveauesuvanvensenuenveeuvensensees 18 Activating Payable Posting sennneenneensenuvenuennvennvennvensennensennsennennvensennennennsenneenne 18 Customer SUD POON nica ta dida 19 Logging In 20 Session Timeout ssnnreaarransrensrensssenseensnessernseenssenssennsennsrensreneseesseenseessnesseenseenssennsennsene 20 meer aan tia 20 GEINT de unun ununnnnunnnennenenennnnnnnnnan nennen 21 Data Entry 22
24. Retum to provision confia Total After Tax Temp Differences Cash Tax Adjustments TA1000 Tax Reserves NC_RTP_2006_PERM 2006 Return to Provision Perm Total Cash Tax Adjustments Cash Provision Post RTP uration in admin elt 115 019 115 019 0 186 815 166 815 0 Y 0 186 815 166 815 0 45 192 134 44 952 794 239 340 Payable On the Payable page the following parameter is required for the Tags drop down menu Paramvalue Summary Default itstagpay able yeprov 1 M Manual Adds the paramvalue as one of the tags inthe Blank Tags drop down menu on the Payable screen For example if M Manual is entered as the Param Value then you see Manual in the Tags 40 2010 Thomson Reuters ONESOURCE Global Access iTaxStream Administration drop down menu For Interim Forecast use itstagpayable forecast 1 For Interim Actual use itstagpayable actual 1 Tax Adjustments On the Tax Adjustments page the following parameter is required for the Tags drop down menu itstagtaxadjs yeprov 1 Summary Default Sr Fe M Manual Adds the paramvalue as one of the tags in the Tags drop down menu on the Tax Adjustments screen For example if M Manual is entered as the Param Value then you see Manual in the Tags drop down menu For Interim Forecast use itstagpaytaxadjs forecast 1 For Interim Actual use itstagtaxadjs actual 1 Blank itsswitch
25. SHOW NEWWIZARDSTATUS 1 Displays the Global Access user status report UsersExtended 1 Displays multiple entry fields for user contact information SHOW FG 1 Displays filing group reports in Global Access Adds the ability to assign non interim datasets to a ITS ASSIGN DATASETS 1 Usar One or more email addresses Enables the email address to populate in the To field of EMA ORSON separated an email when a user clicks the Forgot Password link by a comma Example abc yahoo com xyz hotmail com One or more email Enables the email address to populate in the To field of EMAIL NEWACCESS addresses an email when a user clicks the Request New Access gt separated link by a comma Example abc yahoo com xyz hotmail com SHOW_PRIOR The Analysis section of Temporary Difference pages shows data from the dataset that has been determined va the Datasets Relations section of the Datasets screen in the Administration tab to be the Prior Period HIDE_RTPCOLUMNS Enables RTP adjustments to be entered directly into the Difference column on the Return to Provision page Column type retprov 34 2010 Thomson Reuters ONESOURCE Global Access iTaxStream Administration SHOW_RTP_COMMENTS Enables comments to be added on the Return to Provision page Column type retprov SO_RTP_ Triggers the RTP posting e SO_RTP_2 posts when the status of the unit changes from Incomplete to Prepared e
26. Tax Book Income Local Currency FX Rate 1 USD Weighted Average 0 656510 Save Changes Enter USD FX and Calc Local Entity Name German Corporation Entity Code F1000 Corporate GAAP Pre Tax Income USD Local Profit Before Taxes 67 832 250 FX Rate 1 USD 2 Weighted Average 0 656510 Enter Local USD and Calc FX 2010 Thomson Reuters 11 ONESOURCE Global Access iTaxStream ONESOURCE Tax Provision Concepts Entity Name German Corporation Entity Code F1000 CA A Corporate US GAAP Pre Tax Book Income Reporting Currency Corporate US GAAP Pre Tax Book Income Local Currency ese Save Changes Enter Local USD and FX and Enter Local USD and FX Calc Rounding Entity Name German Corporation Cr es Corporate US GAAP Pre Tax Book Income Reporting Currency Corporate US GAAP Pre Tax Book Income Local Currency 67 832 250 FX Rate 1 USD Weighted Average Save Changes Change in Rate and CTA Deferred Balance Report in the Balance Sheet View e Beginning Balance column balances are converted using the Beginning Spot Rate and the Beginning Tax Rate The Rate Change column creates an adjustment to restate the Beginning Balance column at the Ending Spot Rate and the Ending Tax Rate e All other Columns are converted using the Ending Spot Rate and the Ending Tax Rate e The Ending Balance is the sum of the columns and is effectively the ending balances co
27. ave a status of Prepared 3 Click Create 4 Create questions 5 Add a checklist entry to the appropriate MenuConfig file using the following line lt Menultem order 11 name Checklist tswSignOffCheckList jsp code cl_XXXX checklistCode cl_XXXX gt 6 Upload the MenuConfig file on the Manage Global Attachments page Important Do not append the unit state to the code in the MenuConfig file The system automatically appends an underscore and the current status to the checklist code resulting in cl XXXX_ 7 Log back in as a user A drop down list displays all checklists Find the appropriate list using the checklist code and current status Note An error message displays if no checklist is located with the specified unit state combination The Checklist Summary report shows all previous checklists along with the answers that the users for each status provided Note Give checklists meaningful names to distinguish them on the report It is recommended that you include the status in the report name Manage Instructions Note In versions 6 1 and higher administrators can change instructions directly on data entry pages 28 2010 Thomson Reuters ONESOURCE Global Access iTaxStream Administration Administrators can update instructions for each page using the Instructions Setup page in the Administration section Instructions should be saved as text files and be written in well formed HTML Instructions Sample
28. d below lt li gt lt li gt Click on Begin in the appropriate column for each entity to get to the data entry pages lt li gt lt li gt There is also a status indicator in each row This indicator shows one of four status descriptions lt ul gt lt li gt Incomplete indicates that the Preparer has not completed data entry lt li gt lt li gt Prepared indicates that the Preparer has finished data entry lt li gt lt li gt 1st Level Reviewed indicates that the Reviewer has finished their review lt li gt lt li gt 2nd Level Reviewed indicates that the Financial Officer responsible for this entity has signed off on this income tax calculation Once the unit has been 2nd Level Reviewed you cannot make any further changes to that unit without contacting the Corporate Tax Department lt li gt lt ul gt tswLiabilitiesAdv_Fed txt lt b gt Instructions lt b gt lt ul gt lt li gt The input below should reflect items that impact the tax payable account eg a tax payment to the government or a tax refund from the government lt li gt lt li gt Payments should be positive Refunds should be negative lt li gt lt li gt Fill in payments refunds and adjustments using your lt b gt Functional currency lt b gt in lt b gt whole units lt b gt lt li gt lt li gt Input the Ending Income Tax Payable Balance using the lt b gt Functional currency lt b gt in lt b gt whole units lt b gt Beginning balance
29. e For each question Administrators assign a response type Text Yes No Yes No or N A Number Decimal or Header 2010 Thomson Reuters 27 ONESOURCE Global Access iTaxStream Administration Selecting Header allows users to create titles for different sections of the questionnaire If the Required field is set to True the question must be answered before sign off e Questionnaires can be set up and imported into Corporate Edition through the UQUEST Questionnaires and the UQSTNS Questions tabs on the Import Numbers template Note For more information on importing refer to the Importing Templates documentation e You can assign the same questionnaire to more than one datasetuse with the Copy questions from function Creating a Checklist Checklists are similar to questionnaires However they can be configured for various statuses such as Incomplete Prepared and 1st level reviewed To create a checklist 1 Log in the Global Access Administration page 2 Go to the Manage Questionnaires page Select a dataset and add the code cl_XXXX_ with the following criteria e Checklist codes must begin with cl_ This prefix distinguishes checklists from questionnaires e XXXX can be any unique string that does not contain spaces e Achecklist can be created for each status is the current status of the unit For example e cl XXXX 1 displays for units that have a status of Incomplete e cl XXXX 2 displays for units that h
30. e _ 18 000 Currency translation at Weighted Avg FX rate Detail of CTA Calculation Components summary hybrid detal unit pre tax fed state thos ted state thas state fhos Unit Deferred Balances Fed Only USD el c nc contracted expanded bis expanded i s Test TaxStream Test Balance Aas biEttect Drg c Ettect Rate Carta fa a Activity Esta Chcasz bh Cur Dir 11000 Reserve 77 778 37 400 10 000 1500 0 10 500 18 000 CEMA 18871 sw 30 000 total 377778 7 400 310 900 1600 KA 10 600 18 000 Pi514 141 20 30 000 14 141 673 909 55 0 15 778 Information for the Calculation Beginning Temporary Difference Balance 100 000 Temporary Difference Activity 10 000 Beginning FX Spot Rate 0 45 Current Tax Rate 37 Ending FX Spot Rate 0 55 Beginning Deferred Tax 35 Rate Weighted Average FX Rate 0 50 Ending Deferred TaxRate 40 2010 Thomson Reuters 15 ONESOURCE Global Access iTaxStream ONESOURCE Tax Provision Concepts 14 141 100 000 35 0 55 100 000 35 0 45 673 10 000 37 0 55 10 000 37 0 50 909 100 000 40 35 0 55 100 000 40 35 0 5 55 10 000 40 37 0 55 10 000 40 37 0 5 CTA Amount Displays on the Tax Provision Report Income Tax Rates O Previous Next O Introduction Unit List Unit German Corporation F1000 Dataset 2005 Return to Provision Change Password Instructions e Fill in the
31. gt lt li gt Enter the Current Activity Amount in your lt b gt local currency lt b gt in lt b gt whole units lt b gt lt li gt lt li gt If appropriate enter a Deferred Only amount lt b gt or lt b gt a Balance Sheet Only amount Note that you cannot enter non zero values for both lt li gt lt li gt Click on the Add New button lt li gt lt ul gt lt li gt lt li gt If applicable enter valuation allowances lt li gt lt ul gt 30 O 2010 Thomson Reuters ONESOURCE Global Access iTaxStream Administration Manage Global Attachments Administrators use the Global Attachments page to attach any file to be shared with other users such as a manual or a contact list You can attach any type of file i e Word document Excel spreadsheet pdf file text file etc as a Global Attachments page To add a new file click Browse and select the file Enter a description and code Select Yes from the drop down list if you would like to display the file on the Introduction page Note Files that display on the Introduction page display for all users upon login regardless of level Global Attachments Instructions e Use this page to upload your global attachments e To allow far the downloading of your attachment an the Introduction Page select Yes for Show on intra Page Certain codes are designated for different tems in your TaxStream For instance The code Corp Contacts will use your upload as the
32. he CUNC Unit Components tab in the Import Categories template Note For more information on importing categories refer to the Importing Templates documentation User Status reports are available after the administrator has configured Global Access and created users with permissions User Status Report There are three parts to the Global Access User Status report the Overview Detail by Unit and Detail by Status The Overview report shows the overall status of the provision calculation how many units are inactive how many have been prepared 1st level reviewed and 2nd level reviewed Note In order to view this report with review levels 1st and 2nd review the UserAdminComponentTypes parameter must be activated with a value of 61 62 63 Sign off Summary Report detail by unit detail by status 2007 FY Provision Merck amp Co Inc Status Units Inactive 0 Unprepared 2 Prepared 4 1st Level Reviewed 2 2nd Level Reviewed 0 The Detail by Unit report shows the status of the provision on a unit by unit basis It also shows the current users for each unit who have committed their work Note In order to view the User Name User Phone and User E mail columns the UsersExtended parameter must be activated with a value of 1 44 2010 Thomson Reuters ONE SOURCE Global Access iTaxStream Configuration of Global Access in Corporate Edition Sign off Summary Report overview detail by sta
33. ished data entry Reviewed indicates that the Reviewer has finished their review Signed Off indicates that the Financial Officer responsible for this entity has signed off on this income tax calculation Once the unit has been signed off you cannot make any further changes to that unit without contacting the Corporate Tax Department Pedit Unit Legal Entity Unit Code ABC CORP D1000 DEF CORP GHI Corporation JKL Corporation TGIF Inc Lease Inc LBT Corp D7000 Mexico Corporation D8000 RPS Inc D9000 German Corporation UK Corporation F2000 Begin Begin Begin Incomplete Incomplete Incomplete Change Password If an administrator has set up a forced password change in Corporate Edition for Global Access users on their first login users are automatically directed to the Change Password page Users can access this page anytime they would like to change their password Note Password restrictions in Global Access mandate that each password include a minimum of 6 characters and a number 2010 Thomson Reuters 21 ONESOURCE Global Access iTaxStream Data Entry Data Entry The system uses a wizard like approach for the input of data Information is entered in a step by step manner to guide users through the process Next and Previous links help you navigate the system In addition a blue and white navigator displays at the left side of each page with the c
34. ision Provision Balance Rate Activity Y Y Y x Deferred Only x Y Y Y Balance Sheet Only x x Y x 2010 Thomson Reuters 47 ONESOURCE Global Access iTaxStream Access Component Types Description Access Rights Level Reporting Dataset List Sub Consolidation List Unit List Preparer Global Access 1st Review er Global Access 2nd Review er Global Access Permission Component Types Description Permission Component Types Book Trial Balance After Tax Temporary Differences Jurisdictions Liability Transactions NOL Temporary Differences Permanent Differences List State After App Temporary Differences State After Tax Temporary Differences State Permanent Differences State Tax Adjustments Tax Adjustments List Temporary Differences Book Tax Basis Temporary Differences List Special Characters Code CDS CSC CU SOI SO2 SO3 Code TBBB ATID J LTXNS NOLTD CPD SAATD SATTD SPD STADJ CTADJ TD A CTD Reference Items Here is a list of special characters that are supported by the system They display correctly on reports 48 2010 Thomson Reuters ONESOURCE Global Access iTaxStream Umlaut U Asterisk r Description Charact funderscore De HA aS Cn L Auge i opens Bracket closesqBracket HE Toe aa o o E ET TEE i TC e gege E le ee Forward Slash Reference Items
35. l dataset Read only datasets allow users to review data only Users cannot edit data in read only datasets e Administrators are responsible for creating and maintaining datasets 2010 Thomson Reuters 7 ONESOURCE Global Access iTaxStream ONESOURCE Tax Provision Concepts Units Units allow data to be entered and organized e A unit can be a legal entity branch cost center department division etc and should be the lowest level of detail available to achieve all reporting requirements e Units can be combined with other units to create multiple sub consolidations to achieve various representations of data Sub Consolidations Sub consolidations allow units to be combined for additional views of the data e Units can be in multiple sub consolidations without impacting the integrity of the consolidated view Some uses of sub consolidations are management reporting US Domestic Tax Return Filing view State groupings and Regional reporting EMEA APAC etc Filing Group A filing group allows the attributes of a child unit to roll up to a parent unit e In Unit Details and State Details the unit can remain a parent unit or it can be designated as a child of another parent unit As the child of a parent the child s automation selections and resulting attributes transfer to the parent e Once a unit is designated as a parent unit it cannot be deactivated e There are filing group specific reports that show the res
36. ments must equal your ending balance Amount per financials statement and the computed amount must agree to the Freecon Comparison Report Instructions tswHome txt lt p gt This Tax Package is required in order to properly account for your company s income taxes under US Generally Accepted Accounting Principles GAAP FAS 109 Accounting for Income Taxes establishes financial and reporting standards for the effects of income taxes that result from an entity s activities during the current and preceding years lt p gt lt p gt The Corporate Tax Department will use this information in calculating and supporting the amounts included in the company s income tax accounts which are reported in the annual financial statements and audited by our auditors lt p gt lt p gt Selected entities will be reviewed by our auditors If you are selected you will be contacted If our auditors determine that they are going to audit a legal entity that you are responsible for this system will provide the necessary reports for the FAS 109 calculation lt p gt lt p gt If you have any questions as you prepare this tax package contact the Corporate Tax Department lt p gt tsw UnitList txt lt b gt Instructions lt b gt 2010 Thomson Reuters 29 ONESOURCE Global Access iTaxStream Administration lt ul gt lt li gt Generally a unit represents a legal entity lt li gt lt li gt The entities for which you are responsible are liste
37. mplete to Prepared e 1st Reviewer Allows you to sign off from Prepared to 1st Level Reviewed or roll back from Prepared to Incomplete e 2nd Reviewer Allows you to sign off from 1st Level Reviewed to 2nd Level Reviewed or roll back from ist Level Reviewed to Prepared Access levels can also be imported through the CUC User Components tab in the Import Categories template 42 2010 Thomson Reuters ONESOURCE Global Access iTaxStream Configuration of Global Access in Corporate Edition Notes e For more information on importing categories refer to the Importing Templates documentation e You must have access to a unit as a preparer to edit the data in the unit Thus a preparer is associated with a set of units in the Unit List and also the Preparer roles Publishing Datasets On the Manage Active Datasets screen of Corporate Edition Administrators can publish one dataset or multiple datasets The Single Dataset Configuration is currently not being used Be sure to use the Multiple Dataset Configuration section to publish a dataset There are three ways to publish a dataset e yeprov Publishes a dataset or reporting dataset using standard perm temporary data entry pages e yeprovgs Publishes a dataset or reporting dataset using the separated GAAP STAT perm temporary pages i e GAAP STAT Permanent Differences page STAT TAX Permanent Differences pages etc e retprov Publishes a dataset and activates the Return To Pr
38. n Off a Sign Off O Sign Off O Rollback C Rollback E rollback E Read Write Y Sign Off O read write Cl Read write O read write M sign off Ol sign off O sign off FM Rollback O Rollback EJ Rollback C read write o Sign Off O read write O Read write O read write C sign off E sian off C sign off oO Rollback E Rollback E Rollback o Read Write O Sign Off E Mail Notification Administrators use the E Mail Setup page to send out email messages after each user signs off or rolls back a dataset Email messages can be sent out to read write users sign off users roll back users or all users You can also enter email addresses of other people who would like to receive these messages Some system configuration may need to take place to take advantage of the email notification feature Contact your Implementation Manager or the Support Group for further assistance 26 2010 Thomson Reuters ONESOURCE Global Access iTaxStream Administration E Mail Setup Instructions Use this page to set up the e mails that are triggered Upon Sign Off Rollback Would you like to send e mails to your users upon sign off Dres Ono Who would you like to send an e mail to rn Read Write users M Sign Off users Cl gollback users Who would you like to send every e mail to separate addresses with commas inataly taxstraam net Save Changes Return to Provision Once you enter return
39. names 44 User Status FREON iii 44 Reference Items 46 Where to Enter Items in ONESOURCE Tax PONS OR M per 47 Access Component Types nearessessvanveaseauvavvensenneavesuvansensennenneensennenvensvnnvensennenneensensensene 48 Permission Component Types sersvesvenseasvavveuteaeavesuvansensenuvavvensennennesuvensensenuvaneensensenee 48 Special CharacterS sersnsasveteaveavesuvanvensenuvavvensennenvenuvenvensennenneensensensensennvensensenneensensensene 48 Index 50 2010 Thomson Reuters 3 ONESOURCE Global Access iTaxStream 6 1 Release Overview 6 1 Release Overview The following items were addressed in this release General e The User Manual is now available within the application by clicking the Help link e Headers are now locked on all data entry pages unit list temp diffs etc to make scrolling within a list easier e Users can switch datasets without having to go to the Unit List page When a dataset is changed via the drop down list the system will reset to the first page of that dataset typically the Unit Data page e Session timeout is now 30 minutes A message pops up warning you that your session is about to end You can continue or end your session Administration e New links on the login screen Forgot password and Request New Access to facilitate administration These links are user defined via parameters e EMAIL_FORGOTPWD with a paramvalue of the email address es e EMAIL_NEWACCESS with a
40. next steps e Equiv Select the equivalent provision dataset After the return dataset is populated to reflect the locally filed tax return the system uses this equivalent provision dataset and computes the difference between the return and provision As a result of this process the system generates return to provision true up adjustments e Next Select a dataset to which you would like to post return to provision true up adjustments Because you now have the option to have these adjustments posted automatically to a current year provision dataset it is important that you select an appropriate dataset In addition to publishing a return to provision dataset there are additional configurations that need to be 2010 Thomson Reuters 43 ONE SOURCE Global Access iTaxStream Configuration of Global Access in Corporate Edition completed For more information refer to the Return to Provision section Administer Permissions It is important to note that Global Access honors restriction of components such as perms temps tax adjustments jurisdictions etc However Corporate Edition does not honor these restrictions The screen shown below is used only for Global Access Note Citrix hosted users must ensure that the Days value for expired passwords is not set too high Permissions can be generated manually in the system on the Manage Permissions screen in the Administration tab in Corporate Edition or they can be imported through t
41. ntering and consolidating provision information the system provides users with a set of controls In Global Access up to eight levels of sign off can be created for users Access to units can be limited by sign off level Also adjustments such as permanent and temporary differences can be assigned on a unit by unit basis The status of sign off level displays on the first page unit list of Global Access as well as in the Sign off Summary report in Corporate Edition In the remainder of this manual we discuss all parts of Global Access and how to best use this application to improve your provision process Data entry pages and reports as well as administration are discussed 6 O 2010 Thomson Reuters ONESOURCE Global Access iTaxStream ONESOURCE Tax Provision Concepts ONESOURCE Tax Provision Concepts The following sections define terminology used in ONESOURCE Tax Provision for various concepts Codes Category items created and maintained in Corporate Edition require unique codes assigned to them e Most codes are user defined and can be any combination of alpha and numeric characters including spaces as long as each code is unique e Codes can have a maximum of 60 characters e f codes have been established in other systems consider reusing them in Corporate Edition to create a one to one relationship with data in other systems e System codes are used in automatic postings e Other code conventions present data differentl
42. nting adjustments needed to calculate Local Taxable Income when local Statutory Pre Tax Book Income is the starting point e The enclosed list will provide references between historical descriptions and new adjustment codes If you are unable to locate the proper adjustment please contact the Corporate Tax Department immediately e Add each permanent difference as follows Select the appropriate permanent difference from the drop down Enter the amount using your functional currency in whole units Click on the Add New button e Select the appropriate Tag letter e Proceed to the next step 000 005335A Perm with Leading Zero vi P PSL Adjustment o Mum we P1000 Meals amp Entertainment P P amp L Adjustment 11 237 750 P13000 Officers Life Insurance P P amp L Adjustment 21 066 000 22 2010 Thomson Reuters ONESOURCE Global Access iTaxStream Data Entry Enter a separate line item for each Permanent Difference 1 Select the appropriate code description from the drop down menu in first column 2 Select the type of the permanent difference item It will usually be a P amp L adjustment However if you are entering an item that does not have any impact on the current tax expense e g stock option expense select E Equity adjustment Note Refer to the Where to Enter Items in ONESOURCE Tax Provision section for more information on the different types of permanent difference items 3
43. nverted using Ending Spot Rate and the Ending Tax Rate Example of Change in the Deferred Rate from 35 to 40 12 2010 Thomson Reuters ONESOURCE Global Access iTaxStream ONESOURCE Tax Provision Concepts Adjusted Beginning Beginning Temp Diff Bal in Local Currency 100 000 100 000 Tax Effected Temp Bal in Local Currency FX Rate Tax Effected Temp Bal in USD Rate Change Unit Deferred Balances Fed Only USD 10 000 Test TaxStream Test Code Name T1000 Bad Debt Reserve total Example of Change in the FX Rate from 5000 to 4500 Adjusted Beginning Beginning Temp Diff Bal in Local Currency 100 000 100 000 Deferred Rate 35 00 35 00 Tax Effected Temp Bal in Local Currency 35 000 35 000 Tax Effected Temp Bal in USD Rate Change Unit Deferred Balances Fed Only USD Test TaxStream Test Code Name 71000 Bad Debt Reserve total 2010 Thomson Reuters 13 ONESOURCE Global Access iTaxStream ONESOURCE Tax Provision Concepts Example of Change in the Deferred Rate from 35 to 40 and FX Rate from 4500 to 5500 Adjusted Beginning Beginning Temp Diff Bal in Local Currency 100 000 100 000 Deferred Rate ES 35 00 40 00 Tax Effected Temp Bal in Local Currency 35 000 40 000 FX Rate a AAA 035 Tax Effected Temp Bal in USD 77 778 72 727 Rate Change Unit Deferred Balances Fed Only USD Test TaxStream Test Code Name Beginning Balance Rete Change
44. orwards screen so that the activity displays in user defined columns 2010 Thomson Reuters 17 ONESOURCE Global Access iTaxStream ONESOURCE Tax Provision Concepts Rollup Codes Certain provision activity can be mapped to user defined grouping lines on the Deferred Balance and Effective Tax Rate reports e The Deferred rollup maps Temporary NOL Temporary After Tax Temporary State After Tax Temporary and State After Apportionment differences e The Effective rollup maps all the items in Deferred rollups plus Permanent Difference Tax Adjustments and Deferred Provision Only Adjustments e There can be multiple user defined rollup mappings They display in the upper right corner of the Deferred Balance and the Effective Tax Ratereports Rollups can display on a summary or hybrid basis e Administrators are responsible for creating and maintaining Rollup mappings Payable Activity can be mapped and rolled up to user defined grouping lines on the Payable Rollforward and Payable Detail reports e The Payable rollup maps Payable Transaction Types e Administrators are responsible for creating and maintaining Payable rollup mappings Components Component is the general term for an item in the system Typically components are found in drop down lists Some examples are e Book to Tax Adjustments Permanent Difference Temporary Difference Tax Adjustments etc e Payable Items Transaction Codes Buckets etc e Unit Attributes
45. ovision feature e Q1 forecast Q2 forecast and Q3 forecast Publishes the Forecast datasets e Q1_actual Q2 actual and Q3 actual Publishes the Actual datasets Note that the order of datasets can be adjusted by using the Up and Down buttons which shuffle the selected dataset up or down the list The top dataset appears as the leftmost dataset on the Unit List page In order to publish a provision dataset select the dataset and enter either yeprov or yeprovgs as the Col Type As mentioned above a yeprov dataset uses standard permanent temporary data entry pages and a yeprovgs use separate data entries for GAAP STAT and STAT Tax permanents and temporaries Col Header displays the name of the dataset that will display in Global Access The name can be any text e g Full Year Provision Leave the Equiv and Next fields blank Click Add to publish the dataset In the screen shot they have N A To publish a reporting dataset select the reporting dataset and enter reporting as the Col Type Col Header displays the name of the dataset that will display in Global Access The name can be any text e g YTD Provision Leave the Equiv and Next fields blank Click Add to publish the reporting dataset To publish a return dataset select the dataset and enter retprov as a Col Type Enter any text for Col Header Because you have the option to activate the Return to Provision module in Global Access it is important that you complete the
46. paramvalue of the email address es e The force user to change password setting in ONESOURCE Tax Provision is now respected in Global Access Corrected Issue e Changes to instructions can now be made directly in the application by Administrators rather than only through an import e Questionnaire e Can now require questions be answered before sign off e The addition of Yes No N A response questions e Checklist e New functionality which is similar to questionnaires but which can be configured for various statuses such as Incomplete Prepared and 1st level reviewed e Can require questions on a checklist to be answered before sign off e Can have different checklists per sign off role Functionality e Single Line Temporary Difference entry must be properly set up in ONESOURCE Tax Provision e New Temp Diff Analysis page which doesn t require knowledge of tags for entering Temps e Can display Prior year information on Temp Diff Analysis page for Temps e Parameter SHOW_PRIOR with a paramvalue of 1 e Return to Provision e Ability to hide RTP columns to allow user to enter RTP directly into the Difference column e Parameter HIDE_RTPCOLUMNS with a paramvalue of 1 e Ability to add comments to RTPs e Parameter SHOW_RTP_COMMENTS with a paramvalue of 1 4 2010 Thomson Reuters ONESOURCE Global Access iTaxStream 6 1 Release Overview e Able to edit After Tax Temporary Differences in RTP units Corrected Issue e You can now re enter entrie
47. ports Plug in reports need to be configured in Corporate Edition in order to be available in Global Access Upload the menu that contains the following change in the report section lt Menultem order a number name name of the report link tswPluginReport sp name name of the report as defined in Enterprise gt Example lt Menultem order 14 name Plug in Report link tswPluginReport jsp name test gt Corporate Contacts You can upload a document with a list of your corporate department contacts through the Manage Global Attachments area Be sure to use the appropriate code e g Corp_Contacts for Corporate Contact List when uploading the file to attach it to the Corp Tax Dept Contacts link in Global Access Manage Global Attachments Instructions Use this page to upload your global attachments To allow for the downloading of your attachment on the Introduction Page select Yes for Show on Intro Page Certain codes are designated for different items in your iTaxStream For instance The code Corp Contacts will use your upload as the Corporate Tax Dept Contacts List of Files Filename Description Code Show Download Delete Attach New File File CADoeuments and S Browse Description Corporate Contacts Code Corp_Contacts Show on Intro Page Yes Mill 32 2010 Thomson Reuters ONESOURCE Global Access iTaxStream Administration Menu Configuration Depending
48. pts record Answering No does not create a record e When a unit or state has a record data can be entered and the unit state appears in reports e The unit state record can be removed from the dataset by deactivating the unit in the Unit Details screen or the state in the State Details screen Use caution when deactivating a unit because all information for that unit including states for that dataset is erased e Records roll over or copy when datasets are rolled over or copied Foreign Currency Issues Each unit is designated a currency type and exchange rate that are used to convert the unit s functional currency information to reporting currency Enter 1 for the exchange rates when the functional and reporting currency are the same In converting currency there are several potential issues that can occur The Pre Tax Book Income PTBI provided may be converted at different exchange rates On a unit basis the PTBI policy can be selected so that the correct exchange rate is used to convert the provision numbers The interplay of the Weighted Average and Spot rates may require that a Currency Translation Adjustment CTA be posted to account for the difference in rates The system automatically posts the CTA as an equity adjustment to the deferred tax asset liability There is only one reporting currency conversion in the system This allows the combination of units in sub consolidated or consolidated reports in the reporting currency vie
49. rk done on each unit Columns and rows in the control grid represent datasets and units respectively This list can be sorted by clicking the headers i e Unit Unit Code etc Each dataset can also be sorted by sign off status by clicking the header Click Begin for the unit you would like to start working on Make sure that the Unit List is complete and accurate If you would like to add or delete a unit from the list contact the appropriate person on the Corp Tax Dept Contacts page Note After you sign off no further data can be entered for this unit without permission from the Corporate Tax Department Each unit has a legal entity name and an identification number The control grid shows the status of work done on each unit After all data has been entered click the Commit button on the Sign Off page 20 2010 Thomson Reuters ONESOURCE Global Access iTaxStream Logging In ONESOURCE TAX PROVISION 9 THOMSON REUTERS Unit List O Previous Introduction Unit List Change Password Instructions Generally a unit represents a legal entity The entities for which you are responsible are listed below Click on Begin in the appropriate column for each entity to get to the data entry pages There is also a status indicator in each row This indicator shows one of four status descriptions O Incomplete indicates that the Preparer has not completed data entry O Prepared indicates that the Preparer has fin
50. rrency Codes There are pre populated currency codes that can be expanded as necessary in the Currency section e Thousands Separators The system defaults to a comma 1 000 00 for the thousands separators This can be changed to a period 1 000 00 with a system parameter 2010 Thomson Reuters 9 ONESOURCE Global Access iTaxStream ONESOURCE Tax Provision Concepts Foreign Exchange Rates Entry Format When entering foreign exchange rates on the Unit Data page the format should be the amount that one unit of Reporting Currency equals in Local Currency or Reporting Currency Local Currency For example if reporting is USD and 1 USD equals 60 of another currency the rate would be 1 666667 1 6 Types e Weighted Average Rates Blended foreign exchange rate for a period of time that is applied to Income Statement Items e Spot Rates Foreign Exchange Rate on a specific date that is applied to Balance Sheet Items Currency Translation Adjustment The difference between Weighted Average Rate and Spot Rate used when Income Statement items have an impact on Balance Sheet items Pre Tax Book Income PTBI Policies There are five Pre Tax Book Income policies that can be assigned to units Each policy asks for different input and generates results based on the information entered for the unit Select the best policy for the data you wish to populate and the calculations that the system should perform
51. s on the FX policy of the unit itsswitch yeprov begfx H Allows users to Hide H the beginning FX Read Only Rate field itsswitch yeprov endfx RorH Allows users to Hide H or make the Editable Ending FX Rate field read only R itsswitch y eprov wix RorH Allows users to Hide H or make the Editable Note depends on the FX policy 2010 Thomson Reuters 37 ONESOURCE Global Access iTaxStream Administration SHOW_TAXPERBS 0 Allows users to the Hide 0 or make Hidden editable 1 the Taxes per book section The federal current provision and ends with state liability Note This information only displays in the Old Journal Entry report Income Tax Rates On the Income Tax Rates page the following parameters can be used to open close and lock down fields iaa Paramvalue Summary Default itsswitch yeprov RorH Allows user to hide H or Read Only R the Editable currtax Current Income Tax Rate field itsswitch yeprov RorH Allows user to hide H or Read Only R the Editable enddef Ending Deferred Tax Rate field Permanent Differences On the Permanent Difference page the following parameters can be used to open close and lock down fields Paramvalu Summary e itsswitch yeprov 1 Allows users to Hide H the Permanent difference code Editable hidecode P1000 itsswitch yeprov H Allows users to Hide
52. s that were previously deleted in Return to Provision units Corrected Issue Reports e Plug in Reports can now be displayed They must be properly set up in ONESOURCE Tax Provision e Configurable Journal Entry JE Reports e Style sheets for custom and configurable JE reports and the JE menu can now be uploaded For more information please refer to the Global Access User Manual 2010 Thomson Reuters ONESOURCE Global Access iTaxStream Overview Overview The provision process for most companies requires tax package templates to be emailed to their foreign and domestic subsidiaries These subsidiaries compile the appropriate data and populate the files The files are then emailed back to the Corporate Tax Department Corporate and consolidated to compute the provision This requires manual consolidation which consumes lots of time and makes immediate feedback to foreign users almost impossible With Global Access formerly iTaxStream foreign and domestic subsidiaries compile tax provision information and enter it directly into the Global Access website This results in subsidiaries having access to reports that immediately compute their provision and effective rate Data is entered directly into the database reducing the potential for errors and saving time Consolidation of all information occurs automatically within ONESOURCE Tax Provision Corporate Edition formerly Enterprise In addition to stream lining the process of e
53. solidations Users can change data and run reports for those units to which they have been granted access 3 Administrative users have access to all datasets units and subconsolidations They have the same access as Read Write but for all datasets units and subconsolidations Unlike Read Only or Read Write users they can also modify categories 4 Inactive users have no rights to view or edit any data Note A user cannot be deleted A user can only become inactive The audit trail for each user s existence must be maintained Users can be created manually in the system under Administer Users in the Administration tab in Corporate Edition When creating users manually you can select an option to force users to change their password at next login Users can also be imported through the CUC User Components tab in the Import Categories template Note For more information on importing categories refer to the Importing Templates documentation Sign Off Levels When a user is set up for Global Access the administrator needs to grant them access to a set of units and a user level Preparer 1st reviewer 2nd reviewer etc in Corporate Edition There are up to 8 levels of sign off available in Global Access e Unit List Allows you to see units on the Global Access Unit List page e Preparer Grants you the ability to change values in a unit as long as the unit is in the incomplete state Also allows the user to sign off from Inco
54. t e Addeachtemporary difference as follows Select the appropriate temporary difference from the drop dovm Enter the Current Activity Amountin your functional currency in whole units Click on the Add New button 000 Proceed te the next step when finished Current Peres Cola Deac ptica dicks Beginning Deferred Balance Ending Balance Only Sheet Only Balance Current pa Current Current Balance Ending Balance Non rem Activity Geif Sheet Tax effecting Rate Current Amount Only Bad Debt me RSS O SERIO PEQUE ARES Vacation R Default Tax Rate Accrued Workers 400 000 400 Compensation 000 Default Tax Rate M Enter a separate line item for each Temporary Difference 1 Select the appropriate code description from the drop down menu in the first column 2 Indicate whether the item is classified as current or non current 3 The carryover balance if any is automatically pre populated 4 Enter the current activity amount in local currency 5 There are also fields for entering deferred adjustments and balance sheet only adjustments Note Refer to the Where to Enter Items in ONESOURCE Tax Provision section for more information on the different types of adjustments i e current activity deferred only and balance sheet only 6 Click Add New to create the temporary difference Note If a new temporary difference item is required contact the Corporate Tax Department After
55. tion tuser1 Test User 1 416 555 1235 tuser1 userco com Prepared F2000 UK Corporation tuser1 Test User 1 416 555 1235 tusert Muserco com 1st Level Reviewed D1000 ABC Corporation mme Test User2 416 55 1237 tuser2 userco com jst Level Reviewed F3000 Japan Corporation rs Test User 2 416 55 1237 tuser2 userco com 2010 Thomson Reuters 45 ONESOURCE Global Access iTaxStream Reference Items Reference Items This section contains resources for use with the system 46 2010 Thomson Reuters ONESOURCE Global Access iTaxStream Reference Items Where to Enter Items in ONESOURCE Tax Provision Is the item Pre Tax or Tax Effected Item impacts Ending Deferred Balances Yes No Item impacts the Item impacts the Taxes Payable Effective Tax Rate ltem impacts Ending Deferred Balances Item impacts the Taxes Payable Tax Adjustment After Tax Temporary Permanent 4 Permanent Temporary ONDE Diff P amp L SH Diff Activity i Equity d Adjustment 5 Activity Column Adjustment Care Item impacts the Deferred Provision Item impacts the Deferred Provision After Tax Temporary Diff Deferred Only Column After Tax Temporary Diff Balance Sheet Only Column Temporary Temporary Difff NOL Balance Sheet Only Column Difff NOL Deferred Only Column Current Tax Deferred Tax Ending Deferred Effective Tax Entry Column Prov
56. tus 2007 FY Provision Merck amp Co Inc Unit Code Unit Name Status Current User UserName UserPhone User E mail D1000 ABC Corporation sa PE Test User2 416 55 1237 tuser2 userco com D2000 DEF Corporation Prepared tuser1 TestUser1 416 555 1235 tusert Muserco com D3000 GHI Corporation Prepared tuser1 TestUser1 416 555 1235 tusert Muserco com D4000 JKL Corporation Unprepared F1000 German Corporation Prepared tuser1 Test User 416 555 1235 tusert Muserco com F2000 UK Corporation Prepared tuser1 Test User 1 416 555 1235 tuser1 userco com F3000 Japan Corporation 1st Level Reviewed Test User 416 55 1237 tuser2 userco com F4000 German Holdco Unprepared tuser Test User 416 555 1234 tuser userco com The Detail by Status report shows the Sorted by Status view It also shows the current users for each unit who have committed their work Note In order to vew the User Name User Phone and User E mail columns the UsersExtended parameter must be activated with a value of 1 Sign off Summary Report overview detail by unit 2007 FY Provision Merck amp Co Inc Status Unit Code Unit Name CurrentUser UserName UserPhone User E mail Unprepared D4000 JKL Corporation Unprepared F4000 German Holdco tuser Test User 416 555 1234 tuser userco com Prepared D2000 DEF Corporation tuser1 Test User 1 416 555 1235 tusert Muserco com Prepared D3000 GHI Corporation tuser1 Test User 1 416 555 1235 tusert Muserco com Prepared F1000 German Corpora
57. ual in the Tags drop down menu For Interim Forecast use itstagtemps forecast 1 For Interim Actual use itstagtemps actual 1 Blank NOL On the NOL page the following parameters can be used to open close and lock down fields O Paramvalue Summary Default itsswitch yeprov H Allows users to Hide H make Read Only R or Editable Editable nolsdefonly W the deferred only field itsswitch yeprov R Allows users to Hide H make Read Only R or Editable Editable nolsbalsh W the balancesheet only field 2010 Thomson Reuters 39 ONESOURCE Global Access iTaxStream Administration itsswitch yeprov H Allows users to Hide H or make Read Only R the Tax Hidden nolstdrate Effecting Rate field After Tax Temps On the NOL page the following parameters can be used to open close and lock down fields Summary Default Ea sel itsswitch yeprov H Allows users to Hide H make Read Only R Editable attddefonly or Editable W the deferred only field itsswitch yeprov attdbalsh R Allows users to Hide H make Read Only R Editable or Editable W the balancesheet only field Return to Provision On the Return to Provision page you can use parameters to turn fields on and off Allows user to show the Post RTP button at the bottom of the Return to Provision screen This parameter works in addition to the
58. ults of the relationship with other units These reports can also be viewed in Global Access by enabling a system parameter For more information refer to the Configuration of Global Access in Corporate Edition section Tag Letters Tag letters allow you to designate data as originating from a specific source e Tags are often also referred to as Source Tags or Source Codes e Global Access only allows you to add or modify an adjustment with tag letters designated in Corporate Edition by the administrator The letter A is used by the system for automation It is recommended that you not change this designation for the letter A e Administrators can assign a name to any letter so that it appears in the drop down menu of the data entry page e A tag letter can also identify imported bridged and manually entered data Records Unit State Unit records are required to enter data in a dataset e Each unit has a unit record when it is activated in a dataset An activated unit can have a State record for each state that is activated under the unit Note Units must be activated with the Unit Details screen before adding information in the State Details screen e If there is no record a Create Record pop up message displays stating No data exists for this Unit DataSetld Combination Do you want to create a record Answering Yes creates a 8 2010 Thomson Reuters ONESOURCE Global Access iTaxStream ONESOURCE Tax Provision Conce
59. urrent work area highlighted in gray On the top of each data entry page there is Unit Dataset combination information Be sure to review this information before entering any data You can access other units by selecting a unit from the drop down menu on the left side of each page Federal National Administrators can publish a dataset as Provision or Return to Provision Depending on the dataset type the data entry menu bar in Global Access changes When a dataset is published as provision using yeprov as the column type in Corporate Edition each page that becomes available available from the menu bar in Global Access is discussed in this section of the manual Permanent Differences ST AT T AX The Permanent Diffs STAT Local TAX page allows you to enter differences between book income computed under Statutory Law and Local Tax Law that are permanent in nature i e these differences will not reverse in the future Permanent Diffs STAT Local TAX O Previous Next Unit German Corporation F1000 Dataset 2009 Provision GAAP STAT Instructions A permanent tax difference is created from income items which are never subject to income taxation eg tax exempt interest income and expense items which are never allowed as a deduction e g government penalties or permanently disallowed expenses e The list of permanent differences that should be reflected in this section are those permanent differences that reside within the accou
60. w However the functional currency view of the report may not make sense unless all units have the same currency Currency Types and Options All entries made in the software are considered to be at a Functional currency level e Entries are converted to reporting currency using appropriate foreign exchange rates e Unit level reports can display in either Functional or Reporting currency by changing the currency Consolidated and Sub Consolidated level reports can display in either Functional or Reporting currency only when all units have the same assigned currency code e A currency translation adjustment is automatically computed based on the foreign exchange rates for the unit and displays on appropriate reports Currency Types e Functional Currency Primary Currency in which the books of record are maintained The currency in which an entity does business e Local Currency Currency of the country where the business is physically located e Reporting Currency Currency in which the entity reports financial statements The Rep ortingCurrencySymbol system parameter with a paramvalue of any three letter currency symbol changes the currency that displays in the header of reports viewed in Reporting Currency e Hyperinflationary Environment When the cumulative rate of inflation exceeds 100 over the three year period FAS 52 requires USD to be the functional currency A unit s local currency should be set to USD Currency Options e Cu
61. y e Administrators are responsible for creating and maintaining codes System Codes Some codes are required by the system and some behave differently from the norm Descriptions for system codes can be modified in the Administration section of Corporate Edition but the codes themselves should not be modified e Alternative Minimum Tax system code After Tax Temporary Difference Code AMT_SYS e Valuation Allowance Automation system codes e Temporary Difference codes VA SYS PTTD C and VA SYS PTTD NC e NOL Temporary Difference codes VA SYS NOLTD C and VA SYS NOLTD NC e After Tax Temporary Difference codes VA SYS ATTD Cand VA SYS ATTD NC e NOL Temporary Difference code NOL SYS The code can be extended e g NOL SYS 2007 e Non Cash Tax Adjustments code NC The code can be extended e g NC FIN 48 Naming Conventions It is recommended that you avoid using symbols when creating item names because they can display incorrectly on reports Refer to the list of special characters for symbols that do display correctly Datasets Datasets define the periods of time and type of data being captured e A blank dataset can be created or an existing dataset can be copied or rolled over to a new dataset using the Manage Datasets functionality in Corporate Edition e Datasets can be either open for editing or read only You can make a dataset read only by tagging it in the Administration section or by making it part of a sequentia
62. yeprov ta tag Allows you to hide H the Tax Adjustment Tags drop down menu Note The itstagtaxadjs yeprov 1 parameter must be set up before enabling this parameter Blank itsswitch yeprov ta_type Allows you to hide H the Permanent Difference Type P amp L and Equity dropdown The default type is P for P amp L when this parameter is used Blank Selected Accounts On the Selected Accounts page the following parameter is required for the Tags drop down menu itstagtbs yeprov 1 Paramvalue Summary Default M Manual Adds the paramvalue as one of the tags in the Tags drop down menu on the Selected Accounts screen For example if M Manual is entered as the Param Value then you see Manual in the Tags drop down menu For Interim Forecast use itstagtbs forecast 1 For Interim Actual use itstagtbs actual 1 Blank 2010 Thomson Reuters ONE SOURCE Global Access iTaxStream Configuration of Global Access in Corporate Edition Configuration of Global Access in Corporate Edition User Administration Corporate Edition supports four levels of access 1 Read only users have access to only the dataset units and subconsolidations to which a user has been granted access Users only have the ability to run reports for those units and datasets 2 Read Write users have access granted by the administrator to a restricted set of datasets units and subcon

User Manual - Administrator

Contents

Download Pdf Manuals

Related Search

Related Contents