Home

User Manual - Administrator

1. Note Files that appear on the Introduction page appear for all users upon login regardless of level 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 e 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 export categones 10 04 2007 10 51 am xls ye merckt xsi 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 ouputjesbase xsl Note Configurable JE reports are available only in versions 6 1 or higher 42 2012 Thomson Reuters ONESOURCE GLOBAL ACCESS Administration 1 Click Browse to locate the ouputjesbase xsl file 2 Enter ouputjesbase as the code 3 Add a description 4 Select No on show on intro page Drop down 5 Click Attach Users also need to configure the menu item for each configurable report so that a link appears on the menu Plug in Reports Plug
2. 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 Current Non Current Some accounting conventions notably IFRS and US GAAP require deferred tax balances to be assigned as either current or non current The application forces this distinction so that entries that impact deferred tax accounts need to be assigned as either current or non current The data entry screens for Temporary NOL Temporary and After Tax Temporary Differences have a drop down menu to select C for Current or NC for Non Current Deferred Balances and NOL Balances reports can be filtered to view current and non current balances separately The Temporary Difference Summary report lists current and non current balances by asset and liability 2012 Thomson Reuters 13 ONESOURCE GLOBAL ACCESS ONESOURCE Tax Provision Concepts P amp L Equity Each permanent difference entry needs to be assigned as a P amp L or Equity entry n the data entry page for Permanent Differences there is a drop down menu to select P for P amp L and E for Equity 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 An Equity E entry results in a current tax provision exp
3. 2012 Thomson Reuters ONESOURCE GLOBAL ACCESS Configuration of Global Access in Corporate Edition Integration with ONESOURCE FileRoom For Hosted Clients who log in through the ONESOURCE platform one free drawer will be available to use once the license is activated users may choose to use ONESOURCE FileRoom to store amp access the documents Prior to version 9 0 users were required to attach documents at the component level which is the lowest level Documents were added at the component level and attached to a dataset unit To enhance the documentation functionality ONESOURCE Tax Provision has been integrated with ONESOURCE FileRoom Users have the ability to attach a document at the dataset unit or component level If users continue to attach documents at the component level then the document will be added as it has been in the past We did not remove the functionality to attach documents at the component level The benefit is that when a document is attached regardless of the level it will be indexed to allow searches and quicker access to a document Note Please contact Support if users would like to make this non revokable choice Documents can be added at the Dataset Level Unit Level Component Level 1 In the Navigator click Documents and the ONESOURCE FileRoom opens Introduction Unit List Change Password Import Numbers Export Numbers Documents Note Users can also access ONESOURCE Fi
4. 3796 0 5 2012 Thomson Reuters ONESOURCE GLOBAL ACCESS ONESOURCE Tax Provision Concepts CTA AMOUNT ON THE TAX PROVISION REPORT Income Tax Rates O Previous Next OQ Unit German Corporation F1000 Dataset 2005 Return to Provision Instructions Fill in the Current Income Tax Rate and the Ending Deferred Rate in the boxes below the Beginning Deferred Rate is pre populated 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 reflect any enacted future tax rate changes Click on the Save Changes button Proceed to the next step Statutory Tax Rates used to calculate your provision Erg Ending Deferred Rate 35 6200 Deferred Rollforward The expanded view of the Deferred Balances and NOL Balances reports has user defined columns to which data can be mapped 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 There can be up to 26 user defined columns Users can create as many as needed Administrators are responsible for creating and maintaining the Manage Deferred Rollforward and Manage NOL Rollforwards screens in ONESOURCE Tax Provision The Deferred Balances report can be configured in
5. Unit Attributes State Jurisdiction Attachments Rollup Codes System Items User Rights Audit Trail Transactions Activity Deferred Only Balance Sheet Entries that impact deferred tax accounts need to be assigned 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 Deferred Balances and NOL Balances reports can be configured to view activity deferred only and balance sheet only adjustments separately 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 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 The payable report can be configured with setup items in the payable section of the Administration section An Administrative User can add a Dataset Parameter which allows the provision to post automatically to the Payable section Current Tax Provision Dataset Year CPROV Calculated excluding Tax Adjs with Provision NC code NC RTP Dataset Year minus 1 Calculated True Up NC RTP YEAR NAME Year entered after Calculated NC RTP True Up NC ATR Dataset Year minus 1 Audit Settlement 20 2012 Thomson Reut
6. GLOBAL ACCESS ONESOURCE Tax Provision Concepts Filing Groups A filing group allows the attributes of a child unit to roll up to a parent unit n Unit Details and State Details the unit can remain a parent unit or assigned as a child unit of a parent unit As the child unit of a parent unit the child s automation selections and resulting attributes transfer to the parent Once a unit is assigned as a parent unit it cannot be deactivated There are filing group specific reports that show the results of the relationship with other units These reports are also viewed in Global Access by enabling a system parameter For more information refer to the Configuration of Global Access in ONESOURCE Tax Provision section Tag Letters Tag letters allow users to designate the source of the data for example is the data imported or entered manually Users can designate the letter I for Importing data and M for manually entering data Tags are often referred to as Source Codes A tag letter is used to identify imported bridged and manually entered data Users add or modify adjustments and assign tag letters that are created by the administrator in the ONESOURCE Tax Provision application Administrators enter a name for any letter so that name appears in the Tag drop down list on the data entry page An administrator creates the tags that appear in the drop down list by setting up parameters in the ONESOURCE Tax Provisio
7. ONESOURCE TAX PROVISION GLOBAL ACCESS v9 2 ADMINISTRATOR USER RELEASE DATE OCTOBER 22 2012 THOMSON REUTERS 2012 Thomson Reuters All rights reserved Republication or redistribution of Thomson Reuters content including by framing or similar means is prohibited w ithout the prior written consent of Thomson Reuters Thomson Reuters and the Thomson Reuters logo are registered trademarks and trademarks of Thomson Reuters and its affiliated companies For more information Send us a sales enquiry at reuters com salesenquiry Read more about our products at reuters com productinfo Find out how to contact your local office reuters com contacts ONE SOURCE O GLOBAL ACCESS Contents CONTENTS 9 2 Release Notes sms ierat rivi 6 ONESOUBCE Global Access OvervjeW ee En ati 7 ONESOURCE Tax Provision CONOS adi 7 System CodeS 7 Eo E E E E 8 Naming Conventions sss EEEE 8 O EEE EE E EE 8 UM iia E 8 ub Consolidation cessere teet tute tette rip ek b 8 A 9 A E 9 Records Unit State ri tii ii 9 Foreign Currency Issues sess 10 C rrency Types and ODEOTIS s aas etes so rere s tuv costa apex x aso ier est r eSa vi eer irrita 10 Pre Tax Book Income PTE Politeia Tl Foreign Exchange Rae 13 Mou uM AAA 13 A Ui 14 Changein Rate and CTA EE 14 Deferred Rollforward A 19
8. 4 Period col ow 7 N NE NE Forward Slash 82 2012 Thomson Reuters ONESOURCE Index A Activating Payable Posting 20 Activity 20 Administration 7 8 ATR 27 37 44 68 72 s Bs Balance Sheet Only 20 an Categories 7 8 Change Password 26 Code 8 Components 20 Concepts 7 Country Codes 8 CTA 14 Currency Codes 8 Currency Translation Adjustment 13 Currency Types 10 Current 13 x Ds Dataset 24 Datasets Management 8 Deactivate Units 9 Deferred Only 20 Deferred Rollforward 19 Equity 14 FAS52 10 Federal 2012 Thomson Reuters GLOBAL ACCESS Index DataEntry 27 Filing Group 8 Attributes 9 Automation 9 Child 9 Parent 9 Reporting 9 Filing Unit 8 9 Foreign Currency Issues Changein Rate 10 Currency Translation Adjustments 10 Currency Types 10 Deferred Balances 10 Foreign Exchange Rates 10 FX Rates 10 PTBI Treatment 10 Functional Currency 10 G GAAP to Stat 44 H Hybrid 19 Hyperinflationary Environment 10 L Local Currency 10 M Missing Page 8 National Data Entry 27 NOL Rollforward 19 Non Current 13 ae Overview 7 83 ONESOURCE p P amp L 14 P amp L vs Equity 14 Password 26 Payable Activating Payable Posting 20 Pre Populated Codes User Component Access 81 Provision to Return 27 37 44 68 72 Re Rate Change 14 Records Activate 9 Deactivate 9 Rollover 9 State 9 Unit 9 Reporting Curr
9. Import Categories Export Categories GLOBAL ACCESS Administration Administration Manage Instructions Instructions e Use this page to upload your instructions e Your instructions must be wntten in well formed HTML e To change the instructions for a particular page i e tswHome jsp change the extension of the file Filename tewUnitListQuick jsp tswHome jsp Please choose the file to upload Please choose DatasetType MET y Instructions Sample lt b gt Instructions lt b gt lt ul gt lt li gt The input below reflects 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 are lt b gt positive lt b gt Credits are font color red gt lt b gt negative lt b gt lt font gt lt li gt lt l gt Fill in payments refunds and adjustments using the lt b gt local currency b 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 the ending balance li li A mount per financials statement and the computed amount must agree to the Journal Entry Comparison report 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 sho
10. O3foecat Display Dataset Types in Dropdown 3 yeprovas y Display Dataset Types in Dropdown 4 retpror Ly Display Dataset Types in Dropdown 5 reporting Y Display Dataset Types in Dropdown 6 Q1_actual i Display Dataset Types in Dropdown 7 Oi_forecat m Display Dataset Types in Dropdown 8 ozactul _Y Display Dataset Types in Dropdown 9 O2foecat m Display Dataset Types in Dropdown 10 Q3 actual X Add Switch In the Switch tab users can activate system parameters to activate additional Global Access features To find additional information about a parameter click on the parameter name and the description will appear at the bottom of the screen The following parameters may be configured for the Switch tab Switch 54 2012 Thomson Reuters ONESOURCE GLOBAL ACCESS Administration The following parameters apply to more than one page throughout the application Select from the Switch drop down menu to Add the parameter to the application ADMINISTRATION MANAGE CONFIGURATIONS G Reporting g Advanced Functionality 73 Data Entry oO Global Access Admin Perms In the Perms tab users can activate system parameters to activate additional Global Access features To find additional information about a parameter click on the parameter name and the description will appear at the bottom of the screen The following parameters may be configured for the Perms tab Add Tag to Perm Dr
11. Questionnaires can be set up and imported into ONESOURCE Tax Provision through the UQUEST Questionnaires and the HUQSTNS Questions tabs on the Import Numbers template Questionnaires allow 3500 text characters Note For more information on importing refer to the Importing Templates documentation Users can assign the same questionnaire to more than one dataset to use with the Copy questions from function 2012 Thomson Reuters 37 ONESOURCE GLOBAL ACCESS Administration 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 XXXX can be any unique string that does not contain spaces e A checklist can be created for each status is the current status of the unit For example e c XXXX 1 appears for units that have a status of Incomplete e c XXXX 2 appears for units that have a status of Prepared 3 Click Create 4 Create questions 5 Adda checklist entry to the appropriate MenuConfig file using the following line Menultem order 11 name Checklist tswSignOffCheckList jsp code cl_XXXX checklistCode
12. 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 application automatically appends an underscore and the current status to the checklist code resulting in c XXXX 1t 7 Log back in as a user A drop down list appears all checklists Find the appropriate list using the checklist code and current status The Checklist Summary report shows all previous checklists along with the answers that the users for each status provided Notes An error message appears if no checklist is located with the specified unit state combination Give checklists meaningful names to distinguish them on the report It is recommended that users include the status in the report name Manage Instructions In versions 6 1 and higher administrators may change instructions directly on data entry pages Users can also modify and save the Forecast and Actual instructions The instructions are saved per dataset type and language Administrators can update instructions for each page using the Instructions Setup page in the Administration section Instructions are saved as text files and be written in well formed HTML 38 2012 Thomson Reuters ONESOURCE ONESOURCE TAX PROVISION Introduction Sign Off Sequence E Mail Notification Return To Provision Manage Questionnaires Manage Instructions Manage Global Attachments Manage Params
13. Click Save Example Because the document is attached at the component level lowest level the index values are automatically completed for Dataset Unit Code and Unit Name Add Document dialog box O Electronic Document Unk to a File Paper Document barcode Index Values DataSet Year Tax Type Unit Code Unit Name Unit OTP 10 Component Component Code Component OTP ID AdySub Type State Document Assignment Optional Rosmer 9 Assigned To gt az 9 Document Status Due Date Unassigned m BI J 2012 Thomson Reuters 79 ONESOURCE GLOBAL ACCESS Integration with ONESOURCE FileRoom Reference Items Where to Enter Items in ONESOURCE Tax Provision Item impacts Ending Deferred Balances No Yes Item impacts the Item impacts the Taxes Payable Effective Tax Rate Temporary Diff NOL Activity Column parant Permanent Diff Diff P amp L Adjustment Equity Adjustment Item impacts the Deferred Provision Temporary Difff NOL Deferred Only Column Temporary Difff NOL Balance Sheet Only Column Item impacts Ending Deferred Balances Item impacts the Taxes Payable Tax Adjustment After Tax Temporary Diff Activity Column Item impacts the Deferred Provision After Tax After Tax Temporary Temporary Diff Diff Deferred Balance Only Sheet Only Column Column 80
14. Editable enddef the Ending Deferred Tax Rate field 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 Paramkey Paramvalue Summary Default must be unique itsswitch yeprov 1 Allows users to enter the ending balance or the activity Hidden endbalinput 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 itsswitch yeprov cnc R Allows users to Hide H make Read Only R or Editable Editable W the current non current field When this parameter is used any new temps will be set up as C or Current isswith yeprov R Allows users to Hide H make Read Only R or Editable defonly Editable W the deferred only field itsswitch yeprov R Allows users to Hide H make Read Only R or Editable balsh Editable W the balancesheet only field itsswitch yeprov R Allows users to Hide H or make Read Only R the Hidden tdrate Tax Effecting Rate field itstagtemps
15. Filter Ge To sort the Unit List click the headers for example Unit or Unit Code Each dataset can be sorted by the sign off status 24 2012 Thomson Reuters ONESOURCE GLOBAL ACCESS Introduction Page Click Begin and start entering the data Make sure that the Unit List is complete and accurate If users want to add or delete a unit from the list contact the appropriate person on the Corp Tax Dept Contacts page After all data is entered click Commit on the Sign Off page Note After users sign off no further data can be entered for this unit without permission from the Corporate Tax Department Users must be set up in ONESOURCE Tax Provision with contact information Administrators must assign units roles and sub consolidations to each user In addition Administrators must assign components such as permanent and temporary differences to each unit For more information refer to the Administration section Corp Tax Dept Contacts ONESOURCE TAX PROVISION Y THomson REUTERS Logout ee Unit List Q Previous 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 Incomplete indicates that the Preparer has not co
16. Reporting currency only when all units have the same assigned currency code A currency translation adjustment is automatically computed based on the foreign exchange rates for the unit and appears on appropriate reports Currency Types Functional Currency Primary Currency in which the books of record are maintained The currency in which an entity does business Local Currency Currency of the country where the business is physically located Reporting Currency Currency in which the entity reports financial statements The ReportingCurrencySymbol system parameter with a paramvalue of any three letter currency symbol changes the currency that appears in the header of reports viewed in Reporting Currency Hyper inflationary 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 is set to USD 10 2012 Thomson Reuters ONESOURCE GLOBAL ACCESS ONESOURCE Tax Provision Concepts Currency Options e Currency Codes There are pre populated currency codes that can be expanded as necessary in the Currency section 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 or by switching to certain languages such as German Dutch Spanish and French Pre Tax Book Income PTBI Policies There are five Pre Tax
17. Sheet Only amount Note that you cannot enter non zero values for both Click on the Add New button Proceed to the next step when finished Data Entry Paci Current Ending Non Current ly Balance Choose Unit 010 Downing Unit Data Analysis Guiana Balance Ending Balance Code name to Coret tion eepinniet arua OMS e Gra onteco Current Balance Ameen Only Rate NOL Temp Diff Analysis Enter a separate line item for each Local Temporary Difference 1 Select the appropriate code description from the drop down menu in the first column 28 2012 Thomson Reuters ONESOURCE GLOBAL ACCESS Data Entry 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 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 Click Add New to create the temporary difference After a temporary difference item is created you can edit or delete the item 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 an individual temporary
18. Unit Deferred Balances Fed Only USD Test TaxStream Test a Adjusted Beginning 100 000 35 00 35 000 Code Name Beginning Balance JR Current Activity Deferred Only Balance Sheet Only Endin lance T1000 Bad Debt Reserve 70 000 7 778 0 85 556 total 70 000 7 778 0 85 556 2012 Thomson Reuters 15 ONESOURCE GLOBAL ACCESS 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 100 000 Temp Diff Bal in Local Currency 100 000 Tax Effected Temp Bal in Local Currency 35 000 40 000 Tax Effected Temp Bal in USD Rate Change Unit Deferred Balances Fed Only USD Test TaxStream Test Code Name T1000 Bad Deb Reserve total 2012 Thomson Reuters ONESOURCE GLOBAL ACCESS ONESOURCE Tax Provision Concepts DEFERRED BALANCE REPORT IN THE INCOME STATEMENT VIEW Currency Translation Adjustment Deferred Balances in USD are translated from the Local Currency Balances using Beginning and Ending Spot FX Rates USD Change in Deferred Balances Begin Activity Ending Local Currency Balance 100 000 10 000 110 000 Tax Rates Begin and End 3596 4096 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 Deferred Expense in USD is translated from Local Currency Activity usin
19. can activate system parameters to activate additional Global Access features To find additional information about a parameter click on the parameter name and the description will appear at the bottom of the screen The following parameters may be configured for the Payable tab Add Tag to Tax Adjs Drop down Menu O 2012 Thomson Reuters 57 ONESOURCE GLOBAL ACCESS Administration Users have the ability to add a tag to the tax adjustment drop down menu ADMINISTRATION MANAGE CONFIGURATIONS a Reporting P Advanced Functionality LA Data Entry w Global Access Admin General ADS Col Type Switch Perms Temps Payable i TBS Add Tag to Tax Adj Drop Down Menu Add TOS In the TBS tab users can activate system parameters to activate additional Global Access features To find additional information about a parameter click on the parameter name and the description will appear at the bottom of the screen The following parameters may be configured for the TBS tab Add Tag to Tax Basis Subline Drop down Menu Users have the ability to add a tag to the tax basis subline drop down menu ADMINISTRATION MANAGE CONFIGURATIONS a Reporting gt Advanced Functionality LA Data Entry E Global Access amp Admin General ADS Col Type Switch Perms Temps Payable TaxAdis Add Tag to Tax Basis Subline Drop Down Menu v Add 58 2012 Thomson Reuters ONESOURCE GLOBAL ACCESS Administrati
20. difference items on this page If you have supporting documents click the paper clip icon next to the item Also you have the ability to add and update comment to a line item You may click on the comment icon then add comments as needed The impact of individual temporary differences on your tax provision can be viewed on the Local Tax Provision report and the Local Tax Provision report 2012 Thomson Reuters 29 ONESOURCE GLOBAL ACCESS Data Entry Temporary Diffs STAT TAX The Temporary Differences STAT TAX page allows users to enter differences between book income computed under Statutory Law and Local Tax Law in the country that are temporary in nature These differences will reverse in the future Temporary Diffs STAT Local TAX O previous Next O Unit German Corporation F1000 Dataset 2003 Provision GAAP STAT Instructions e Atemporarytax difference is created from items of income and expense which are allowed for both financial and income tax purposes but recognized in different accounting years eg depreciation certain reserves Beginning Balance is pre populated from the Corporate Tax Department e Addeachtemporary difference as follows o Selectthe appropriate temporary difference from the drop down C Enterthe Current Activity Amountin your functional currency in whole units Clickonthe Add New button e Proceed to the next step when finished 005335A Temp with Leading Zer
21. in the Desktop client Click on Import Numbers and then select the dataset that will receive the imported data ONESOURCE TAX PROVISION Introduction Import Numbers Unit List el Please select a dataset None Change Password PI ESTA 2009 Provision Import Numbers 2008 Provision x E 2009 Return Export Numbers Export Numbers Users are able to export numbers for items that they have access In Administration click Export Numbers and then select the dataset to export the data 26 2012 Thomson Reuters ONESOURCE GLOBAL ACCESS Introduction Page Data Entry The application 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 users navigate through the application In addition a blue and white navigator is available at the left side of each page with the current work area highlighted in grey On the top of each data entry page there is Unit Dataset combination information Be sure to review this information before entering any data Users can access other units by selecting a unit on the left side of each page Federal 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 ONESOURCE Tax Provision each page tha
22. simo Eus 19 Components sse tte tette ttt 20 Activity Deferred Only Balance Sheet sss 20 Activating Payable Posting sss treten 20 s ici anc Fs 22 Introduction PAGS selladas 23 Select Language AA 23 O e A E eae 24 Unit ISt 24 Bax o 26 Import D CH 26 A A Eu E Dt ERU D 26 Data Enty 5 5 5 5 5 5 5 ran il 27 2012 Thomson Reuters 3 ONE SOURCE O GLOBAL ACCESS Contents CONTENTS zl 27 Permanent DISTAT EA scar ceu tute en ier dx relie a Ac 27 Temporary Di c 28 Iura ie piro carecurde enceaiecbeasiiswaiceie ia 30 NOL Temp Dit AtialysiS sss ee oca erae ra e th Erst th ipa eeN iS EEKE E NESKEAK Sa SEE Eiso 31 After Tax Temp Diffs AnallySis ccccccccccssssssscescccscceessseceusceseceecsssceussesscecaessseuscesaceeens 32 Payable AnalVSiS criada bs das re 33 TAX FNCCO Uc ERREUR ii ata 34 Administration duse cd e tapete cen RF PX 35 AE O ii 35 ESO 36 Ss A 37 Manage Questionnaires V V 37 CHEATING A GNECKUIST necesecon nEn Tn 38 Manage Instructions eese teretes 38 liue E 39 Manage Global Attachments esses 42 o AAA dense Er a aeea aE E e Eene 42 lUe LaTe LON ES EE T E E
23. statement approach Or users can input an ending balance amount and have the application calculate the current activity using the balance sheet approach Administrators can enable the balance sheet approach through a parameter However even with this parameter Global Access users still have the option to take either approach for each line item After Tax Temp Diffs Analysis The After Tax Temporary Diffs page allows users to enter after tax adjustments that are temporary in nature Note Tax Basis Temporary Difference screens allow users to enter amounts as purely tax balances with or without book or net of book After Tax Temp Diffs Analysis O Previous Next O Unit Downing 010 Dataset 2011 Provision 2011 FY 2 Change P Instructions Documents e Click on Edit to change the amounts pies P edit 2011 Provision 2011 FY 2 Code Description Choose Unit 010 Downing Ie Expand Data Entry TTT em eme nin tance Ending Balance Income Tax Rates Permanent Diffs Temporary Diffs Temp Diff Analysis Amortized Temp Diff Analysis Net Operating Losses NOL Temp Diff Analysis After Tax Temp Diffs After Tax Temp Diffs Analysis Enter a separate line item for each After Tax Temporary Difference Select the appropriate code description from the drop down menu in the first column Indicate whether the item is classified as current or non current The carryover balance
24. temps The GAAP STAT and STAT TAX adjustments will be recorded in the return dataset with the default tags of tag H and U To change the default tags create the following dataset parameters GAAPADJTAG and STATADJTAG Example paramkey GAAPADJTAG paramvalue J e The value of GAAPADJTAG must be among the tags defined by gstags parameters When RTP is posted to the target dataset the GAAP STAT true ups will be tagged with P and the STAT true ups with R Users can change the tags by using the dataset parameters in the Return Dataset GAAPRTPTAG for GAAP and RTPTAG for STAT On the Payable page the following parameter is required for the Tags drop down menu itstagpayable yeprov 1 M Manual Adds the paramvalue as one ofthe Blank tags in the Tags drop down menu on the Payable screen For example if M Manual is entered as the Param Value then users see Manual in the Tags drop down menu For Interim Forecast use itstagpayable forecast 1 For Interim Actual use itstagpayable actual 1 2012 Thomson Reuters 69 ONESOURCE GLOBAL ACCESS Administration Tax Adjustments On the Tax Adjustments page the following parameter is required for the Tags drop down menu itstagtaxadjs yeprov M Manual 1 itss witch ye prov H ta_type Allows users to hide H the Permanent Difference Type P amp L and Equity dropdown Adds the paramvalue as one of the tags Blank in the Tags drop down menu
25. 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 the ONESOURCE Tax Provision application In addition to stream lining the process of entering and consolidating provision information the application provides users with a set of controls In Global Access up to eight levels of sign off can be created for users This allows users to sign off and provides verification that an assigned user has reviewed the data Users can sign off one unit at a time as wellas at a sub consolidated level allowing them to sign off on multiple units at a time The access to units can be limited by sign off level as well Also adjustments such as permanent and temporary differences are assigned on a unit by unit basis The status of sign off level appears on the first page unit list of Global Access as well as in the Sign off Summary report in ONESOURCE Tax Provision In the remainder of this manual all parts of Global Access are discussed along with how to use this application to improve the provision process Data entry pages and reports as well as administration are discussed ONESOURCE Tax Provision Concepts The following sections define terminology used in ONESOURCE Tax Provision for various concepts System Codes Some codes are required by the application to work correctly Users modify sy
26. the bottom right of the screen To unhide click on the Description icon at the bottom left of the screen ADMINISTRATION MANAGE CONFIGURATIONS a Reporting P Advanced Functionality fa Data Entry 7 Global Access amp Admin General ADS Col Type Switch Perms Temps Payable Tax Adis TBS Assign Datasets to Users Yes C No Activate Questionnaire Yes C No Display User Status Report Yes C No Activate Manage Active Datasets Yes C No Add Review Levels Review Level 3 y Set Forgot Password Email Set Request New Access Email Enable Filing Group Reports Yes C No Assign non interim Datasets to Users Yes C No Display Prior Year Information Yes C No Hide ATP Columns C Yes No Add Comments to RTPs Yes C No Show Unit Details on Questionnaire Report Yes C No Show New Questionnaire Layout Yes C No Show Post RTP Button Yes C No Post GAAP to STAT RTP Yes C No 2012 Thomson Reuters 49 ONESOURCE GLOBAL ACCESS Administration Global Access The following reference chart for Global Access lists parameters that can be configured in the ONESOURCE Tax Provision application To view the Global Access parameters within the Tax Provision application 1 Select Administration 2 Select the System folder 3 Select the Manage Configurations folder Assign Datasets to Users Display User Status Report Activate Manage Active Datasets Set Request New Access Em
27. the Manage Deferred Rollforwards screen so that the activity appears in user defined columns Rollup Codes Certain provision activity can be mapped to user defined grouping lines on the Deferred Balance and Effective Tax Rate reports The Deferred rollup maps Temporary NOL Temporary After Tax Temporary State After Tax Temporary and State After Apportionment differences The Effective rollup maps all the items in Deferred rollups plus Permanent Difference Tax Adjustments and Deferred Provision Only Adjustments There can be multiple user defined rollup mappings They appear in the upper right corner of the Deferred Balance and the Effective Tax Rate reports Rollups can appear on a summary or hybrid basis 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 The Payable rollup maps Payable Transaction Types Administrators are responsible for creating and maintaining Payable rollup mappings 2012 Thomson Reuters 19 ONESOURCE GLOBAL ACCESS ONESOURCE Tax Provision Concepts Components Component is the general term for an item in the application Typically components are found in drop down lists Some examples are Book to Tax Adjustments Permanent Difference Temporary Difference Tax Adjustments Payable Items Transaction Codes Buckets
28. the ability to add and update comment to a line item users may click on the comment icon then add comments as needed The impact of individual temporary differences on the tax provision can be viewed on the Tax Provision report and the Effective Rate report 2012 Thomson Reuters ONESOURCE GLOBAL ACCESS Data Entry NOL Temp Diff Analysis A NOL Temp Diff occurs when users have a loss before tax book loss or the deductions are more than the income for the year An NOL can be carried forward to future years to offset income and thus reduce the tax liability Enter the NOL for the unit selected in local currency NOL_SYS automatically generates an NOL when taxable income is negative it also automatically uses NOLs when income is present Note Tax Basis Temporary Difference screens allow users to enter amounts as purely tax balances with or without book or net of book NOL Temp Diff Analysis O Previous Next O Introduction Unit Downing 010 Dataset 2011 Provision 2011 FY 2 Click on Edit to change the amounts Choose Dataset P Edi 2011 Provision 2011 FY 2 v i Code Description Choose Unit 010 Downing v m Expand Data Entry L ee Name Beginning Balance Ending Balance Amortized Temp Diff Analysis NOL Temp Diff Analysis Enter a separate line item for each Net Operating Loss Select the appropriate code description from the drop down menu in the first column
29. the status of the unit changes from Prepared to 1st Level Reviewed Text entered appears as an option in the Col Type drop down list in the Manage Active Datasets screen under Administration Examples Q1 actual Q1_ forecast retprov yeprovgs yeprov 1 activates the Global Access 60 2012 Thomson Reuters ONESOURCE9 GLOBAL ACCESS Administration activates the Foreign Domestic 0 Hide classification Country and Currency for or each unit on the Questionnaire Summary 1 Show report Global Access Questions report ONESOURCE Tax Provision QUESTIONNAIRE UNITDETA ILS 1 enables RTP adjustments for temporary 0 Hide differences tagged with R to be posted as POST AMORTIZED or deferred only adjustments on tax basis in 1 Show the Temporary Differences Book Tax Basis screen 2012 Thomson Reuters 61 GLOBAL ACCESS Administration The following parameters apply to more than one page throughout the application Parameters denoted with are now enabled by the Administrator in the ONESOURCE Tax Provision application Administration area within the System folder in the Manage Configurations Global Access tab Paramkey Paramvalue Summary Default must be unique itsswitch yeprov Activating this parameter will limit users to tags Hidden tagcheck assigned to them by the itstag switch itss witch ye prov Allows users to hide H codes P1000 in all Hidden hidecode pages itss w
30. to a RTP Provision and Target Dataset To perform this task go to Manage Datasets in the Administration area in the Desktop client Also tax adjustment codes must be set up 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 have for Return to Provision The ability to hide RTP columns to allow user to enter RTP directly into the Difference column Parameter HIDE RTPCOLUMNS with a paramvalue of 1 The ability to add comments to RTPs Parameter SHOW RTP COMMENTS with a paramvalue of 1 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 scheme For each question Administrators assign a response type Text Yes No Yes No or N A Number Decimal or Header Selecting Header allows users to create titles for different sections of the questionnaire f the Required field is set to True the question must be answered before sign off
31. yeprov M Manual Adds the paramvalue as one of the tags in the tags Blank 1 drop down menu For example if M Manual is used then the user sees Manual in the Tags drop down menu For Interim Forecast use itstagtemps forecast 1 For Interim Actual use itstagtemps actual 1 itsswitch yeprovgs R Allows users to Hide H make Read Only R or Editable cnc Editable W the current non current field When this parameter is used any new temps will be set up as C or Current itsswitch yeprovgs H Allows users to Hide H make Read Only R or Editable defonly Editable W the deferred only field itsswitch yeprovgs R Allows users to Hide H make Read Only R or Editable balsh Editable W the balancesheet only field 66 2012 Thomson Reuters ONESOURCE GLOBAL ACCESS Administration itsswitch yeprov Displays the Read Write Start of Exp Period and End Hidden showperiod of Exp Period column the Local NOLs After Tax Temps Local After Tax Temps NOL On the NOL page the following parameters are used to open close and lock down fields itss witch ye prov H Allows users to Hide H make Read Editable nolsdefonly Only R or Editable W the deferred only itss witch ye prov Allows users to Hide H or make Read Hidden nolstdrate Only R the Tax Effecting Rate field After Tax Temps On the NOL page the following parameters are used to open close and lock down fields Default soe itss witch ye prov All
32. 2012 Thomson Reuters ONESOURCE GLOBAL ACCESS Reference Items WHERE TO ENTER ITEMS IN ONESOURCE TAX PROVISION Current Tax Deferred Tax Ending Deferred Effective Tax Entry Column Provision Provision Balance Rate Deferred Only Balance Sheet Only Access Component Types Description Code Access Rights Level alan ROMS Sub Consolidation List CSC ES m Ist Revi Global Access a SO1 2nd Reviewer Global SO3 Access Permission Component Types Description Code Le as prn Book Trial Balance TBBB Jurisdictions J Siti tein ee NOL Tempor Differences NOLTD repens Da REE ee State After App Temporary Differences SAATD ree Cr ae Cees eC State Permanent Differences SPD __ Tax Adjustments List CTADJ ee an c RENTRER emer cre S Temporary Differences List CTD 2012 Thomson Reuters 81 ONESOURCE GLOBAL ACCESS Special Characters Reference Items Here is a list of special characters that are supported by the application They appear correctly on reports Character Description Copywrite Y u Open Parentheses Close Parentheses Secti P E GB Poun en Acute A Acute E Acute U Acute O Umlaut Acute At symb P Asterisk d Oo ol 4 b ow WE E Low 4 Umlaut U Lo SUE ow a Mo Character Description Underscore EE EE Dash fplus gt Equas JOpensqBracket 1 closesqBracket_ Ie Komma
33. 5 ONESOURCE GLOBAL ACCESS Administration Manage Menu Configuration Instructions e Use this page to manage menu configurations Utilize the menu configuration utility to add and remove available menu items and links e Confirm your menu choices and upload the configuration to propagate the new menu items to the Data Entry side of the Global Access Module e Access the Manage Global Attachments page to view and or delete existing skin menu configurations Menu tem yeprov Menu Item Type Data Entry O Reports O Local Data Entry O Local Reports O Plugin Reports r Menu Item Link tswUnitNumbers jsp Menu Item Name tswUnitRates jsp tswUnitPermDiffs jsp tswUnitTempDiffs jsp tswUnitPermDiffs_GS jsp tswUnitPermDiffs ST jsp tswUnitTempDiffs GS jsp tswUnitTempDiffs ST jsp does o ide tswUnitTempDiffAnalysis After Tax Temp Diffs Analysis AmorTempSL jsp Tax Adjustments tswUnitNOLs jsp Liabilities tswUnitNOLsAnalysis jsp tswUnitATTempDiffs jsp NOL Temp Diff Analysis Menu Item Type Data Entry Q Reports Q Local Data Entry Q Local Reports Q Plugin Reports Menu Item Link tswUnitPermDiffs jsp Iv Menu Item Name Permanent Differenced Click on the Name Link or Menu Header drop down arrows to sort the list Users may sort Ascending and Descending The Columns may be sorted by Name Link and Menu Header Users also have the ability to gather the information in other fo
34. 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 needed and the calculations that the application will perform Enter Local FX and Cale Entered Calculated Entered Enter Local CURRENCY and Calc FX Entered Entered Calculated N A Enter Local CURRENCY EX and Cale Rounding Entered Entered Entered Calculated 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 users cannot save the PTBI amount 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 application automatically becomes read only in the application 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 2012 Thomson Reuters 11 ONESOURCE GLOBAL ACCESS ONESOURCE Tax Provision C
35. E E 43 Corporate CONTACTS ccssccecccccecsssescceeccececcsseesccesccececsseecccesseuecusseesccessceuecaseeesceesceeeeaes 43 MENU COMMOUFARIOMcseie seu m ER 44 MEN 44 Manage Configurations a tii 48 GLO Dal Acces AP 50 Manage A A E RA 59 Global Access Configuration eese cesse esee 59 Entry Fields CONMMGUNATION s eso oo ooo o o re ood o re oo eee eue e eaae en e tera eaae aee o rera eda ege aa seruus 62 Import Categories sss tette tette 7 Export Categories e e 71 Configuration of Global Access in Corporate Edition 7i User Administration sees ttd 7l otl A 72 Publishing Datasets LLL C sss 72 acu dicc ri 73 User Status Report tette tetti 74 Integration with ONESOURCE FileRoom ss 79 2012 Thomson Reuters ONE SOURCE GLOBAL ACCESS Contents Reference Ems ainda 80 Where to Enter Items in ONESOURCE Tax Provision sss 80 Access Component Types ou essaie edad trn deed dedo ded tpe naga 81 O 81 Special Characters ais 82 83 CONTENTS 2012 Thomson Reuters 5 ONESOURCE GLOBAL ACCESS 9 2 Release Notes 9 2 Release Notes Each new enhancement is explained in the following format The purpose of the enhancement What users can do with the enhanced feature The procedures to get started with th
36. Indicate whether the NOL item is classified as current or non current The carryover balance if any is automatically pre populated Enter the current activity amount in local currency There are also fields for entering deferred adjustments and balance sheet only adjustments Click Add New to create the temporary difference Du ULP RE Notes 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 Ifa new NOL item is required contact the Corporate Tax Department After a temporary difference item is created users 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 users can attach files to individual temporary difference items on this page If users have supporting documents click the paper clip or filing cabinet next to the item Also users have the ability to add and update comment to a line item users may click on the comment icon then add comments as needed The impact of individual temporary differences on the tax provision can be viewed on the Tax Provision report and the Effective Rate report Global Access users can enter information in the current activity deferred only and balance sheet only 2012 Thomson Reuters 31 ONESOURCE GLOBAL ACCESS Data Entry fields using the income
37. Manage Active Datasets Activates the Manage Active Datasets screen Select Yes to activate a parameter and No to deactivate the parameter Add Review Levels Makes Preparer Ist Reviewer and 2nd Reviewer viewable on the Administer Users administration page Select the reviewer level from the menu drop down Add Review Levels Set Forgot Password Email Enables the email address to populate in the To field of an email when a user clicks the Forgot Password link Enter the email address to send the request Set Request New Access Email Enables the email address to populate in the To field of an email when a user clicks the Request New Access link Enter the email address to send the request Enable Filing Group Reports Displays filing group reports in Global Access Select Yes to activate a parameter and No to deactivate the parameter Assign non interim Datasets to Users Assigns the datasets to users non interim Select Yes to activate a parameter and No to deactivate the parameter Display Prior Year Information Displays the prior year information Select Yes to activate a parameter and No to deactivate the parameter Hide RTP Columns Hides the RTP Columns Select Yes to activate a parameter and No to deactivate the parameter Add Comments to RTPs Enables comments to be added on the Return to Provision page Column type retprov Select Yes to activate a parameter and No to deactivate the parameter Show Unit Details on Qu
38. Provision application within the System folder in Manage Configurations in the Global Access tab Also users may contact the Implementation Manager or the Support Group for further assistance 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 Oves Ono Who would you like to send an e mail to Dread Write users ivi Sign Off users Oo Rollback users Who would you like to send every e mail to separate addresses with commas natalyBtaxstream net MM i zi 36 2012 Thomson Reuters ONESOURCE GLOBAL ACCESS Administration Return to Provision Once return data is entered true up adjustments are posted to the current year s provision dataset Automatic posting of return to provision adjustments triggered in one of two ways the 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 the dataset configurations to relate a Return Dataset
39. WWIZARDSTATUS status report 2012 Thomson Reuters 59 Parameter SHOW FG ITS ASSIGN DATASETS EMAIL FORGOTPWD EMAIL NEWACCESS SHOW PRIOR HIDE RTPCOLUMNS SHOW RTP COMMENTS SO RTP adscoltype f GLOBAL ACCESS Administration Value 1 1 One or more email addresse S separate dbya comma One or more email addresse S separate dbya comma SHOW ADVANCEDQUESTION 0 Function contact information Displays filing group reports in Global Access xxx Adds the ability to assign datasets to a user Enables the email address to populate in the To field of an email when auser clicks the Forgot Password link Example abc yahoo com xyz hotmail com Enables the email address to populate in the To field of an email when a user clicks the Request New Access link Example abcOyahoo com xyzO hotmail com The Analysis section of Temporary Difference pages shows data from the dataset that has been determined via the Datasets Relations section of the Datasets screen in Administration to be the Prior Period Enables RTP adjustments to be entered directly into the Difference column on the Return to Provision page Column type retprov Enables comments to be added on the Return to Provision page Column type retprov Triggers the RTP posting SO RTP 2 posts when the status of the unit changes from Incomplete to Prepared e SO RTP 3 posts when
40. ail Assign non interim Datasets to Users Hide RTP Columns Show Unit Details on Questionnaire Report Show Post RTP Button ADS COL Type yeprov l AA AA AAA Payable yeprov l 50 2012 Thomson Reuters ONESOURCE GLOBAL ACCESS Administration Tax Adjs yeprov l Add Tag to Tax Adjs Drop down Menu liab Q1 Forecast Q2 Forecast AB Actua 0000 Q3_Forecast a eg retprov TBS retprovgs gaap yeprovgs yeprovgs stat General In the General tab users can activate system parameters to activate additional Global Access features To find additional information about a parameter click on the parameter name and the description will appear at the bottom of the screen The following parameters may be configured for the General tab Assign Datasets to Users Adds the ability to assign datasets to a user Select Yes to activate a parameter and No to deactivate the parameter Activate Questionnaire Activates the Global Access Questionnaire format Select Yes to activate a parameter and No to deactivate the parameter 2012 Thomson Reuters 5 ONESOURCE GLOBAL ACCESS Administration Display User Status Report Displays the Global Access user status report Select Yes to activate a parameter and No to deactivate the parameter Activate
41. ate comment to a line item users may click on the comment icon then add comments as needed The impact of individual permanent differences on the tax provision can be viewed on the Tax Provision report and the Effective Rate report Temporary Diffs The Temporary Diffs page allow users to enter amounts as purely tax balances with or without book or net of book The Temporary Differences page allows users to enter differences that will reverse in the future Examples include temporarily disallowed expenses accruals and reserves which will be deducted in later years as well as book income not subject to current taxation under the statutory laws of the country In order to view this page the dataset must be published Introduction Temporary Diffs O Previous Next O Unit Downing 010 Dataset 2011 Provision 2011 FY 2 h d edens Atemporary tax difference is created from items of income and expense which are allowed for both financial and income tax purposes but recognized in different accounting years eg depreciation contingent liabilities certain reserves Choose Dataset e Carry Over Balance is pre populated from the Corporate Tax Department 2011 Provision 2011 FY 2 Add each temporary difference as follows Select the appropriate temporary difference from the drop down Enter the Current Activity Amount in your Functional currency in whole units e If appropriate enter a Deferred Only amount or a Balance
42. ble Filing Group Reports Assign non interim Datasets to Users Display Prior Year Information Hide RTP Columns Add Comments to RTPs Show Unit Details on Questionnaire Report Show New Questionnaire Layout Show Post RTP Button ADS Col Type Yes C No C Yes No Yes C No Yes C No Review Level 3 Y Yes C No Yes C No C Yes No C Yes No C Yes No C Yes No C Yes No C Yes No In the ADS Col Type tab users select system parameters to activate additional Global Access features To find additional information about a parameter click on the parameter name and the description will appear at the bottom of the screen Administration 2012 Thomson Reuters 53 ONESOURCE GLOBAL ACCESS Administration The following parameters may be configured for the ADS Col Type tab Display Dataset Types in Dropdown Users have the ability to select the Display Dataset Types in Dropdown 1 10 from the menu drop down then select Add The selection displays as an option in the Col Type drop down list in the Manage Active Datasets screen in the Administration area Examples yeprov Q3 forecast yeprovgs retprov reporting Q1 actual Q1 forecast ADMINISTRATION MANAGE CONFIGURATIONS a Reporting Advanced Functionality LA Data Entry E Global Access amp Admin Display Dataset Types in Dropdown Display Dataset Types in Dropdown 1 yeprov X Display Dataset Types in Dropdown 2
43. dule link here admin Sign Off Setup Sequence On the Sign Off Setup page Administrators set up user s sign off roles using the matrix on the page They can configure each sign off level and grant specific access levels 1 e read only and read write access Sign Off Setup Instructions Use this page to set up your Sign Off Sequence ae er O Read write C Read write O Sign Off E Sign Off O Rollback O Rollback V Read Write v Sign Off O Read Write E Read Write v Sign Off O Sign Off v Rollback O Rollback O Read write O Sign Off O Read write LJ Read write O Sign Off e Sign Off O Rollback 7 Rollback O Read Write O Sign Off O Read write Oo Sign Off O rollback Oo Read Write O Sign Off O rollback O Read write m Sign Off v Rollback Note When a unit is Signed Off to Preparer the instructions no longer appear on each page 2012 Thomson Reuters 35 ONESOURCE GLOBAL ACCESS Administration E Mail Setup 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 Users can also enter email addresses of other people who would like to receive these messages users may set up a application configuration to take advantage of the email notification feature The parameter may be set up in the ONESOURCE Tax
44. dy exists users will be receive a Menu Configuration Notification A Menu configuration already exists for this skin Users may view the menu configuration just created by selecting Manage Global Attachments 2012 Thomson Reuters 47 ONESOURCE GLOBAL ACCESS Administration Manage Global Attachments Instructions e 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 e Certain codes are designated for different items in your iTaxStream For instance e The code Corp Contacts will use your upload as the Corporate Tax Dept Contacts List of Files Filename Description Code Show Download Delete menu yeprov xml yeprov menu configuration menu yeprov No Download Delete Manage Configurations Manage Configurations can be found in the ONESOURCE Tax Provision application Both ONESOURCE Tax Provision and Global Access have been migrating away from having to know understand a parameter outside the application In the Administration area of the ONESOURCE Tax Provision application users will find in the System folder Manage Configurations This area allows the Administrator to activate additional functionality within the application by selecting the respective parameters Parameters have been added in this area to allow easier configuration of the application Note With version 8 0 the Global Access tab has been add
45. e feature in the application GENERAL UNIT LIST FILTERS An enhancement to filter the Unit List now allows you to filter units in the list for a specific group Also an option is available to view up to 50 units per page allowing a quicker review of the unit list You can now filter the Unit List to enter data for a specific group To select the filter for the Unit List In the navigation tree select Unit List 2 Enter a Keyword for Filter 3 Click Go You can now filter the Unit List and view up to 50 units on a page To select the option to view 50 units per page 1 In the navigation tree select Unit List 2 Select the number 1 50 of units per page to view 3 Click OK 6 2012 Thomson Reuters ONESOURCE GLOBAL ACCESS 9 2 Release Notes ONESOURCE Global Access 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 a lot of time making immediate feedback to foreign users almost impossible With Global Access foreign and domestic subsidiaries compile tax provision information and enter it directly into the Global Access application This results in subsidiaries having access to reports
46. ed to assist users in setting up the parameters for the Global Access application Select the Global Access tab to configure the parameters Users will find the tabs represent specific functions of the application and the parameters are activated within each tab Below is the list of tabs available for Global Access GLOBAL ACCESS General ADS Col Type e Switch Perms Temps Payable Tax Adjs TBBS Note Users are not required to exit the software for selected System Configurations to take effect When users migrate away from Manage Configurations a dialog box will pop up letting users know that the System configuration has been reloaded into memory System configuration has been relosded into memory 48 2012 Thomson Reuters ONESOURCE GLOBAL ACCESS Administration Initially some parameters are grayed out because the parameter does not exist in the system This parameter listed in gray does not exist and may or may not have a default value displayed Add Expected Deferred Report Once a selection is made for an item the parameter is activated in the system The parameter then shows in blue font to reflect that a change has been made The next time users log in the parameter is reflected in black font Click on the Parameter name and the Description for that parameter will appear at the bottom of the screen Users have the ability to hide this screen by clicking on the thumb tack icon at
47. ed to the next step Name tyre i 8 P1000 Meals amp Entertainment P P amp L Adjustment 11 237 750 i al P13000 Officers Life Insurance P P amp L Adjustment 21 066 000 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 users are entering an item that does not have any impact on the current tax expense for example stock option expense select E Equity adjustment 2012 Thomson Reuters 27 ONESOURCE GLOBAL ACCESS Data Entry 3 Enter the amount of the permanent difference in local currency 4 Click Add New to create the permanent difference Notes Refer to the Where to Enter Items in ONESOURCE Tax Provision section for more information on the different types of permanent difference items If a new permanent difference item is required contact the Corporate Tax Department After a permanent difference item is created users can edit or delete it by clicking the appropriate icon 1 Click the pencil icon to edit the entry 2 Select Save Changes after making any changes Users can attach files to individual permanent difference item on this page If users have supporting documents click the paper clip or filing cabinet next to the item Also users have the ability to add and upd
48. ency 10 Reports 82 CSC Custom Sub Consolidation Current Non Current View 13 Deferred Balances 19 NOL Balances 19 Rollup 19 SC Sub Consolidation 8 Return to Accrual 27 37 44 68 72 Return to Provision 27 37 44 68 72 RTP 27 37 44 68 72 T Source Code 9 Special Characters 82 Spot Rates 13 Src Code 9 Status 24 Sub Consolidations 8 Summary 19 Support 22 System Code 7 8 GLOBAL ACCESS Index Te Tag Letters 9 Terminology 7 Thousands Separators Currency 10 U Unit 24 Domestic 8 Foreign 8 UnitList 24 User Component Access Codes 81 W Weighted Average Rates 13 2012 Thomson Reuters 84
49. endfx RorH itsswitch yeprov wfx SHOW_TAXPERBS 0 Administration Summary Default of the trial balance lines representing expense lines Allows users to show the Corporate GAAP Pre Tax Income calculated Line A sum of the Income and Expense subtotals Allows users to Hide H make Read Only R or Editable W the Answer field for the ITSQuestionDec5 question Allows users to enter any question pertaining to the any unit data information Note The answer to this question will not go to any report Allows users to Hide H make Read Only R or Editable W the answer field for the ITSQuestionDec6 Question Allows users to enter any question pertaining to the any unit data information Note The answer to this question will not go to any report Allows users to Hide H or Read Only R the Corporate US GAAP Pre Tax Book Income Local Currency field Allows users to enter a name of their preference for the Corporate US GAAP Pre Tax Book Income Local Currency field Allows users to Hide H or Read Only R the Corporate Profit Depends on the FX Before Taxes field Policy Allows users to enter a name for theCorporate Profit Corporate Profit Before Taxes field Before Taxes Hidden Hidden Hidden Hidden Editable Note Depends on the FX Policy Corporate US GAAP Pre Tax Book Income Local Currency Editable Note Allows users to Hide H the beginning FX Rate field Allows user
50. ense offset in the payable account as well as an equity contra expense that is offset in an equity account This does not impact the overall effective tax rate Change in Rate and CTA Deferred Balance Report in the Balance Sheet View 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 All other Columns are converted using the Ending Spot Rate and the Ending Tax Rate The Ending Balance is the sum of the columns and is effectively the ending balances converted using Ending Spot Rate and the Ending Tax Rate 14 2012 Thomson Reuters ONESOURCE GLOBAL ACCESS ONESOURCE Tax Provision Concepts EXAMPLE OF CHANGE IN THE DEFERRED RATE FROM 35 TO 40 Beginning 100 000 Temp Diff Bal in Local Currency Tax Effected Temp Bal in Local Currency FX Rate Tax Effected Temp Bal in USD Rate Change Unit Deferred Balances Fed Only USD Test TaxStream Test Code Name Beginning Balance T1000 Bad Debt Reserve 70 000 10 000 8 000 total 70 000 10 000 5 000 Adjusted Beginning 100 000 10 000 0 88 000 0 88 000 EXAMPLE OF CHANGE IN THE FX RATE FROM 5000 TO 4500 Beginning 100 000 35 00 Temp Diff Bal in Local Currency Deferred Rate Tax Effected Temp Bal in Local Currency 35 000 Rate Change
51. ers ONESOURCE GLOBAL ACCESS ONESOURCE Tax Provision Concepts NC_ATR_YEAR NAME Year entered after ATR Audit NC_ATR Settlement All other NC_ codes Dataset Year OTHER Audit Settlement The Federal amount is posted in the Federal Payable Entry Each State is posted in that State s Payable Entry 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 All amounts entered in the Payable is in local currency 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 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 are available on the Payable Detail report The Payable Detail report can be viewed in both Local Currency and Reporting Currency 2012 Thomson Reuters 21 ONESOURCE GLOBAL ACCESS ONESOURCE Tax Provision Concepts Customer Support GENERAL CUSTOMER SUPPORT Address 121 River Street PH Hoboken NJ 07030 USA Phone 877 829 5969 x2 201 356 6521 x2 Fax 201 356 6379 Web http onesource thomsonreuters com EMAIL Functionality provisionsupport thomsonreuters com Technical pr
52. estionnaire Report Activates the Foreign Domestic classification Country and Currency for each unit on the Questionnaire Summary report Global Access Questions report ONESOURCE Tax Provision Select Yes to activate a parameter and No to deactivate the parameter Show New Questionnaire Layout Activates the Questionnaire Summary report Global Access Questions report ONESOURCE Tax 52 2012 Thomson Reuters ONESOURCE Provision with units down the left column and full questions across the top Answers populate the grid GLOBAL ACCESS Select Yes to activate a parameter and No to deactivate the parameter Show Post RTP Button Shows the Post RTP Button Select Yes to activate a parameter and No to deactivate the parameter Post GAAP to STAT RTP Button The parameters are configured in the ONESOURCE Tax Provision application In the control panel select Administration then the System folder Manage Configurations folder and Global Access folder The following appears in the Global Access General tab Parameter Defaults ADMINISTRATION MANAGE CONFIGURATIONS a Reporting P Advanced Functionality A Data Enty ij Global Access Admin General ADS Col Type Switch Perms Temps Payable Tax Adis TBS Assign Datasets to Users Activate Questionnaire Display User Status Report Activate Manage Active Datasets Add Review Levels Set Forgot Password Email Set Request New Access Email Ena
53. g Weighted FX Rates USD Deferred Expense Begin Activity Ending Local Currency Balance 100 000 10 000 110 000 Tax Rates Begin and End 3596 4096 Local currency tax effected 35 000 44 000 Weighted Avg FX USD tax effected 70 000 88 000 Deferred Provision Expense 18 000 Currency Translation Adjustment Computation 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 CTA to Adjust Spot FX to i Weighted Average FX Plus CTA 15 718 Total Deferred Prov Expense 18 000 Currency translation at Weighted Avg FX rate 2012 Thomson Reuters ONESOURCE GLOBAL ACCESS ONESOURCE Tax Provision Concepts DETAIL OF CTA CALCULATION COMPONENTS fed state thos fed state tbos state thos Unit Deferred Balances Fed Only USD y al c nc a Test TaxStream Test 318 000 14 141 4873 909 355 so 15 778 18 000 14 141 873 999 355 30 15 778 Beginning Temporary Difference 100 000 Balance 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 Tax Rate 40 673 10 000 37 0 55 10 000 37 0 50 55 10 000 40 3796 0 55 10 000 40
54. gal entity that users are responsible for this application will provide the necessary reports for the FAS 109 calculation lt p gt lt p gt If users have any questions as users prepare this tax package contact the Corporate Tax Department lt p gt tswUnitList txt lt b gt Instructions lt b gt lt ul gt lt li gt Generally a unit represents a legal entity li li The entities for which users are responsible are listed 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 li 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 users cannot make any further changes to that unit without contacting the Corporate Tax Department li ub tswLiabilities Adv_Fed txt lt b gt Instructions lt b gt lt ul gt lt li gt The input below reflect the items that impact the tax payable account eg a tax payment to the government or a tax refund fr
55. if any is automatically pre populated Enter the current activity amount in local currency There are also fields for entering deferred adjustments and balance sheet only adjustments Click Add New to create the temporary difference NNnBWNR Notes 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 e f a new after tax temporary difference item is required contact the Corporate Tax Department After a temporary difference item is created users 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 Users can attach files to individual temporary difference item on this page If users have supporting documents 32 2012 Thomson Reuters ONESOURCE GLOBAL ACCESS Data Entry click the paper clip or filing cabinet next to the item Also users have the ability to add and update comment to a line item Users may click on the comment icon then add comments as needed The impact of individual temporary differences on the tax provision can be viewed on the Tax Provision report and the Deferred Balances report Payable Analysis The Payable Analysis page allows users to enter items that impact the current tax payable account Payable Analysis O Previous Next O Unit Downing 010 Dataset 2011 Pro
56. in reports need to be configured in ONESOURCE Tax Provision in order to be available in Global Access Upload the menu that contains the following change in the report section Menultem order a number name name of the report link tswP luginReport jsp name name of the report as defined in Enterprise gt Example Menultem order 14 name Plug in Report link tswPluginReport jsp name test Corporate Contacts Users can upload a document with a list of the 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 Description Corporate Contacts Code Corp Contacts Show on Intro Page Yes WM 2012 Thomson Reuters 43 ONESOURCE GLOBAL ACCESS Administration Menu Configuration Depending on the type of dataset published in Global Access the me
57. in the following languages Deutsch DE German Germany English CA English Canada English UK English United Kingdom English US English United States Espa ol LA Spanish Latin American Francais FR French France Francais CA French Canada Nederlands NL Dutch Netherlands The introduction page allows users to choose a language that appears within the application by selecting a language from the list Administration Corp Tax Dept Contacts Help cc A English UK Espa ol Am rica Latina Nederlands Note Additional languages will be added in future versions amp Tech Consulting projects are available if users need to add a new language choice that modifies the terminology 2012 Thomson Reuters 23 ONESOURCE GLOBAL ACCESS Introduction Page Session Timeout A message appears on the page a minute before a session will time out This message lets users know they will be logged out of the application Users have two options 1 Click OK to close the message and continue the session The clock automatically resets for a new 30 minute timeout 2 Click Cancel to end the session and then log out Unit List The Unit List page lists 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 work done on each unit Columns and rows in the control grid represent datasets and units respectively The Un
58. it List allows you to filter units in the list for a specific group Also an option is available to view up to 50 units per page allowing a quicker review of the unit list To select the filter for the Unit List 1 In the navigation tree select Unit List 2 Enter a Keyword for Filter 3 Click OK ONESOURCE TAX PROVISION Unit List O Previous Instructions Generally a unit represents a legal entity e 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 e Incomplete indicates that the Preparer has not completed data entry e Prepared indicates that the Preparer has finished data entry e 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 Fest Filter Mex Ge Clear Sign Off Unit Legal Entity Unit Code Page Test A A Begin Mexico Corporation D8000 Incomplete To select the option to view 50 units per page 1 In the navigation tree select Unit List 2 Select the number 1 50 of units per page to view 3 Click Go
59. itch ye prov Allows users to enter the ending balance or the Hidden endbalinput 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 values in 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 SHOW_DSCOMP 1 Allows others to view entries for datasets inthe Hidden system This is only available for Permanent Temporary NOL Temps and After Tax Temporary Differences Note Users can view all datasets not just those published to Global Access itstagperms M Manual Adds the paramvalue as one of the tags in Blank yeprov 1 the tags drop down menu For example if M Manual is used the user sees Manual in the Tags drop down menu itstagtemps M Manual Adds the paramvalue as one of the tags Blank yeprov 1 in the Tags drop down menu itstagtemps R Return to Adds the paramvalue as one of the tags in the Blank yeprov 2 Prov Tags drop down menu itstagtemps O Other Adds the paramvalue as one of the tags in the Blank yeprov 3 Tags drop down menu itstagperms M Manual Adds the paramvalue as one of the tags in the Blank yeprovgs 1 Tags drop down menu itstagtemps M Manual Adds the paramvalue as one of the tags in the Blank yeprovgs 1 Tags dro
60. k 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 appears the name of the dataset that will appears 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 users have the option to activate the Return to Provision module in Global Access it is important that users complete the next steps Equiv Select the equivalent provision dataset After the return dataset is populated to reflect the locally filed tax return the application uses this equivalent provision dataset and computes the difference between the return and provision As a result of this process the application generates return to provision true up adjustments Next Select a dataset to which users would like to post return to provision true up adjustments Because users now have the option to have these adjustments posted automatically to a current year provision dataset it is important that users select an appropriate dataset In addition to publishing a return to provision dataset there are additional configurations that need to be completed For more information refer to the Return to Provision section Administer Permissions It is impo
61. l Access in Corporate Edition existence must be maintained 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 Ist reviewer 2nd reviewer etc in ONESOURCE Tax Provision There are up to 8 levels of sign off available in Global Access Unit List Allows users to see units on the Global Access Unit List page Preparer Grants users 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 Incomplete to Prepared 1st Reviewer Allows users to sign off from Prepared to 1st Level Reviewed or roll back from Prepared to Incomplete 2nd Reviewer Allows users to sign off from 1st Level Reviewed to 2nd Level Reviewed or roll back from 1st Level Reviewed to Prepared Access levels can also be imported through the CUC User Components tab in the Import Categories template Notes For more information on importing categories refer to the Importing Templates documentation Users 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 In Manage Active Datasets of the ONESOURCE Tax Provision application Administrators can publish one datase
62. leRoom from the platform so users don t have to open the Global Access application when looking for an attached file 2 Drawer f users already license ONESOURCE FileRoom they will automatically have access to all of the other drawers in the drop down If users do not have a license for ONESOURCE FileRoom separately they will have access to 1 free drawer starting with v 9 0 3 Folder Criteria Select the Year Period and Type These are required fields 4 Workflow Criteria Select the Type This is a required field 2012 Thomson Reuters 75 ONESOURCE GLOBAL ACCESS Integration with ONESOURCE FileRoom Note Items that are not required can be entered and may be pre populated if attached at the component level such as Description and File Name 5 In the Documents dialog box set up the Documents Criteria required in order to store and access documents in the ONESOURCE FileRoom 6 Click Actions to open the Documents dialog box Documents Drag a column here to group by Type DataSet DataSet ID Year 8 2008 TRUE UP 2412 2008 8 2008 TRUE UP 2412 2008 7 8 2008 TRUE UP 2412 2008 7 8 2008 TRUE UP 2412 2008 8 2008 TRUE UP 2412 2008 4g 2008 TRUE UP 2412 2008 7 Click the ONESOURCE FileRoom icon to open the Documents dialog box 76 2012 Thomson Reuters ONESOURCE GLOBAL ACCESS 8 In Documents select the documents to attach Documents Drag a column here t
63. menu Users can create the following tags for temporary adjustments reporting retprov e retprovgs e yeprov yeprovgs gaap yeprov stat To create tags 1 Click on the Add Tag to Temp Drop Down Menu 2 Click the type of tag to create For example users can select yeprov from the drop down menu 3 Click Add 4 In the following box click the drop down list and select the tag letter for the tag 5 Click Add 56 2012 Thomson Reuters ONESOURCE GLOBAL ACCESS Administration ADMINISTRATION MANAGE CONFIGURATIONS 2 Reporting J Advanced Functionality 9 Data Enty Global Access General ADS Col Type Switch Perms iT Add Tag to Temp Drop Down Menu X Add yeprov yeprov 1 M Manual y Add Payable In the Payable tab users can activate system parameters to activate additional Global Access features To find additional information about a parameter click on the parameter name and the description will appears at the bottom of the screen The following parameters may be configured for the Payable tab Add Tag to Payable Drop Down Menu Users have the ability to add a tag to the payable drop down menu ADMINISTRATION MANAGE CONFIGURATIONS a Reporting P Advanced Functionality L3 Data Entry Global Access amp Admin General ADS Col Type Switch Perms Temps Payable Tax Adis TBS Add Tag to Payable Drop Down Menu Add Tax Adjs In the Tax Adjs tab users
64. mpleted data entry Prepared indicates that the Preparer has finished 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 cor Unit Legal Entity Unit Code forecast actual provision A ABC CORP D1000 Pins is T plats DEF CORP D2000 GHI Corporation D3000 JKL Corporation D4000 TGIF Inc D5000 Lease Inc D6000 LBT Corp D7000 Mexico Corporation D8000 RPS Inc D9000 German Corporation F1000 UK Corporation E2000 ER sis ee inu NOE ius 2012 Thomson Reuters 25 ONESOURCE GLOBAL ACCESS Introduction Page Change Password If an administrator set up a forced password change in ONESOURCE Tax Provision for Global Access users on the first login users are navigated to the Change Password page Users access this page to change a password Note Password restrictions in Global Access mandate that each password include a minimum of 6 characters and a number Import Numbers Upon import a users rights are considered and they are able to import numbers only for items they have permission to access In order to import files properly users must follow the same formatting rules used
65. n application The letter A is used by the application for automation The best practice is that administrators do not change the default setting for the letter A To set up parameters 1 Click Administration from the Control Panel 2 Click on the System folder 3 Click on the Manage Configurations folder to access the parameters 4 Click on the Global Access tab to set up the Global Access parameters Records Unit State Unit records are required to enter data in a dataset Fach 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 in the unit Note Units are activated within Unit Details before adding information for State Details f there is no record a Create Record pop up message appears stating No data exists for this Unit DataSetld Combination Do users want to create a record Answering Yes 2012 Thomson Reuters 9 ONESOURCE GLOBAL ACCESS ONESOURCE Tax Provision Concepts creates a record Answering No does not create a record When a unit or state has a record data is entered and the unit state appears in reports The unit state record are removed from the dataset by deactivating the unit in Unit Details or the state in State Details Use caution when deactivating a unit because all information for that unit including states for that dataset is erased Records roll over or copy when datasets are rolled over or co
66. nu can be configured e g yeprov for a regular dataset yeprovgs for GAAP to STAT datasets and retprov for return to provision datasets to show different options If users would like to modify the menu bar users may set that up in the Menu Configurations area 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 Description Ye Prov New Menul Code menu_yeproy Show on Intro Page Ne Manage Menu Configurations Manage Menu Configurations enables users to customize the menu bar for the home page of a dataset Users can rearrange the order of the menu bar and change field names The menu structure allows users to easily change the menu item order suppress and or add items Users have the ability to easily control the menu depending on the specific needs Depending on the type of dataset published in Global Access be sure to use the appropriate menu item e g yeprov for a regular dataset yeprovgs for GAAP to STAT datsets and retprov for return to provision datasets Notes The defaul
67. o AddNew Ending Balance amp Tax effecting Rate aT Bad Debt e 8 9 mos Reserve 1 PA De Accrued ds P B 4 1000 TES p 9 Default Tax Rate Accrued ES ricas 400 000 B 2 711000 Compensation c 0 a 9 290 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 6 Click Add New to create the temporary difference Notes 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 f a new temporary difference item is required contact the Corporate Tax Department After a temporary difference item is created users 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 users can attach files to individual temporary difference item on this page If users have supporting documents click the paper clip or filing cabinet next to the item Also users have
68. o group by Type DataSet 0 Eg px E 3 D de Gb G3 Gb ly y 2008 TRUE UP 2008 TRUE UP 2008 TRUE UP 2008 TRUE UP 2008 TRUE UP 2008 TRUE UP DataSet ID 2412 2412 2412 2412 2412 2412 Integration with ONESOURCE FileRoom Year 2008 2008 2008 2008 2008 2008 2012 Thomson Reuters ONESOURCE 9 Click Add Document GLOBAL ACCESS Integration with ONESOURCE FileRoom Actions Documents Drag a column here to group I Type DataSet 2008 TRUE UP 2008 TRUE UP 2008 TRUE UP 2008 TRUE UP 2008 TRUE UP 2008 TRUE UP Ey C9 C3 C3 C3 C3 y Gb G ly a la Email Documents Using Outlook Email Documents Using Lotus Notes Email Documents Using OWM Copy Document s Copy Hyperlink s to Clipboard Merge PDFs Append Pages to PDF Move Document Open Template Library Document Properties Delete Document s Edit Document Export Document Print Documents View Print Queue Document History Customize View 2 Note If users attach documents at the lowest level component level then the Index Values will be pre populated The index values are completed based on the level users are attaching a document 78 2012 Thomson Reuters ONESOURCE GLOBAL ACCESS Integration with ONESOURCE FileRoom 10 Click Browse to find the document to add to ONESOURCE FileRoom 11
69. om the government lt li gt lt li gt Payments are be positive Refunds are be negative lt li gt Ii Fill in payments refunds and adjustments using the 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 plus minus payments refunds and adjustments must equal the ending balance lt li gt lt li gt A mount per financials statement and the computed USD amount must Agree See Income Tax Acct Report lt li gt lt ul gt tswUnitA TTempDiffs 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 the 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 is 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
70. on Manage Params Administrators can show hide and lock fields on Global Access pages using parameters Global Access Configuration Because Administrators can show hide and lock fields on Global Access pages by setting up the appropriate parameters the initial configuration will take some planning and time As a Corporate user users must configure Global Access to the specifications keeping in mind the needs of the local users Certain parameters must be activated to make the application more user friendly and secure Parameters denoted with are now enabled by the Administrator in the ONESOURCE Tax Provision application Administration area within the System folder in the Manage Configurations Global Access tab This is the number of days until the user has to reset their password to log into the system It can contain any value greater then zero TSPass wordExpire Days This is the minimum length counting all characters be it letters or numbers that TSPass wordMinLength must be present in a user s password This can be any value but the default is set to 6 SHOW_GAAPTOSTAT Shows the GAAP to STAT report Adds the letter to the drop down menu for TAG GAAR TO STAT the Tags in ONESOURCE Tax Provision Adds the word Manual to the drop down Itstagtemps yeprovgs 1 menu for the Tags in Global Access for temps SHOW_SIMPLELIABILITY Hides simple liability report Displays the Global Access user SHOW_NE
71. on the Tax Adjustments screen For example if M Manual is entered as the Param Value then users see Manual in the Tags drop down menu For Interim Forecast use its tag paytaxadjs forecast 1 For Interim Actual use itstagtaxadjs actual 1 Blank The default type is P for P amp L when this Selected Accounts parameter is used On the Selected Accounts page the following parameter is required for the Tags drop down menu itstagtbs yeprov 1 M Manual Adds the paramvalue as one of the tags in the Blank Tags drop down menu on the Selected Accounts screen For example if M Manual is entered as the Param Value then users see Manual in the Tags drop down menu For Interim Forecast use itstagtbs forecast 1 For Interim Actual use itstagtbs actual 1 70 2012 Thomson Reuters ONESOURCE GLOBAL ACCESS Administration Import Categories Administrators have the ability to Import Categories In Administration select Import Categories then Browse for the file that users want to upload and Submit In order to import files properly users must follow the same formatting rules used in the Desktop client ONESOURCE TAX PROVISION Administration Import Categories Introduction Sign Off Sequence Select the file s which you would like to upload Cia add Manage Instructions Manage Global Attachments Manage Params Import Categories Export Categories Export Categories Administra
72. oncepts Enter Local FX and Calc USD Entity Name German Corporation Corporate Profit Before Taxes 103 322 493 Corporate US GAAP Pre Tax Book Income Local Currency FX Rate 1 USD EV Weighted Average 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 Entity Name German Corporation Entity Code F1000 CT EE Corporate US GAAP Pre Tax Book Income Reporting Currency Corporate US GAAP Pre Tax Book Income Local Currency FX Rate 1 USD Weighted Average 0 656510 Save Changes 12 2012 Thomson Reuters ONESOURCE GLOBAL ACCESS ONESOURCE Tax Provision Concepts Enter Local USD and FX and Enter Local USD and FX Calc Rounding Corporate US GAAP Pre Tax Book Income Local Currency 67 832 250 FX Rate 1 USD Weighted Average 0 656510 Foreign Exchange Rates Entry Format When entering foreign exchange rates on the Unit Data page the format is 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 Weighted Average Rates Blended foreign exchange rate for a period of time that is applied to Income Statement Items
73. op Down Menu Users can add multiple tags to the Perms drop down menu Users can create the following tags for temporary adjustments reporting retprov e retprovgs e yeprov yeprovgs gaap yeprov stat To create tags 1 Click on the Add Tag to Perm Drop Down Menu 2 Click the type of tag to create For example users can select yeprov from the drop down menu 3 Click Add 4 In the following box click the drop down list and select the tag letter for the tag 5 Click Add 2012 Thomson Reuters 55 ONESOURCE GLOBAL ACCESS Administration ADMINISTRATION MANAGE CONFIGURATIONS E Reporting gP Advanced Functionality 4 Data Enty GlobalAccess A Admin S Temps Payable Tax Adis TBS 1 Add Tag to Perm Drop Down Menu Add yeprov yeprov 1 M Manual Add Note For GAAP STAT Provision Datasets An administrator sets up the GAAP to Stat and Stat to Tax tags for the data entry screens by adding the following parameters in manage restricted features of the Tax Provision application Temps In the Temps tab users can activate system parameters to activate additional Global Access features To find additional information about a parameter click on the parameter name and the description will appear at the bottom of the screen The following parameters may be configured for the Temps tab Add Tag to Temp Drop Down Menu Users can add multiple tags to theTemps drop down
74. ovision 2011 FY 2 Change Password acia e Enter the Trial Balance amount for each General Ledger account for this Legal Entity Add each Trial Balance amount as follows Choose Dataset Select the appropriate trial balance account from the drop down menu Select the appropriate source code from the drop down menu Enter the amount into the Ending Book Balance Click on the Add New Button 2011 Provision 2011 FY 2 Choose Unit 010 Downing Data Entry Unit Data Income Tax Rates Permanent Diffs Trial Balances tag Ending Balance Temporary Diffs Temp Diff Analysis Amortized Temp Diff Analysis Net Operating Losses NOL Temp Diff Analysis After Tax Temp Diffs After Tax Temp Diffs Analysis Tax Adjustments Payable Payable Analysis Tax Accounts 34 2012 Thomson Reuters ONESOURCE GLOBAL ACCESS Administration Administration Administrators can use ONESOURCE Tax Provision to manage users and configure Global Access to meet their needs Although most administrative functions in ONESOURCE Tax Provision 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 the Global Access Mo
75. ovisiontechsupport thomsonreuters com SOFTWARE UPGRADES Email the current software version to provisiontechsupport thomsonreuters com SUPPORT SITE For current updates http www taxstream net onesource GENERAL CUSTOMER SUPPORT UNITED KINGDOM Address Monmouth House 58 64 City Road London EC1Y2AL London UK Phone 44 207 068 3530 Web http onesource thomsonreuters com Email Functionality provisionsupport thomsonreuters com Technical provisiontechsupport thomsonreuters com SOFTWARE UPGRADES Email the current software version to provisiontechsupport thomsonreuters com SUPPORT SITE For current updates http www taxstream net onesource 22 2012 Thomson Reuters ONESOURCE GLOBAL ACCESS ONESOURCE Tax Provision Concepts Introduction Page The Introduction page provides users with instructions and documents for review If assistance is needed click the Corp Tax Dept Contacts link for contact information When ready to proceed Users can click Next or click Unit List from the navigation tree Select Language When users log in to Global Access the Introduction page appears This page contains an introduction prepared by the Corporate Tax Department as well as a general explanation of the application Note The user defined descriptions and notes are not translated For example a temporary difference description is not translated The user can view the User Interface and Reports
76. ows users to Hide H make Read Only R Editable issih or Editable the deferred only field 2012 Thomson Reuters 67 ONESOURCE GLOBAL ACCESS Administration Return to Provision On the Return to Provision page users can use parameters to turn fields on and off SHOW_RTPBUT Allows user to show the Post RTP button atthe Hidden _ TON bottom of the Return to Provision screen This parameter works in addition to the Return to quration in admin i Total After Tax Temp Differences Cash Tax Adjustments TA1000 Tax Reserves NC_RTP_2006_PERM 2006 Return to Provision Perm v Total Cash Tax Adjustments Cash Provision Post RTP o 115 019 186 815 0 186 815 45 192 134 115 019 186 815 FOR GAAP STAT RTP SYSTEM SET UP retprovgs The dataset must be defined as the Return retprovgs dataset in manage active dataset in the Tax Provision application In order to enable GAAP to STAT RTP posting the following system parameter needs to be added in manage restricted features Example Param key POST_GAAP Param value 1 Define the GAAP tags through gstags1 gstags2 etc parameters in Manage Restricted features Example Param key gstags 1 Param value G Dataset Set Up 68 2012 Thomson Reuters ONESOURCE GLOBAL ACCESS Administration Payable e On the RTP page users can adjust values of the GAAP STAT and STAT TAX perms and
77. p down menu for ATTDs and NOLs SHOW NEWWIZ 1 Shows the wizard status report Hidden ARDSTATUS SHOW WIZARD 1 Shows the Manage Active Datasets page where a Hidden user publishes datasets to Global Access UserAdminCompo 61 62 63 Makes Preparer 1st Reviewer and 2nd Hidden nentTypes Reviewer viewable on the Administer Users Administration page UsersExtended Shows multiple entry fields for user contact Hidden 62 2012 Thomson Reuters GLOBAL ACCESS Administration information 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 Paramkey must be unique itstbptbiinc yeprov PTBI 1000 itstbptbiinc yeprov 2 PTBI 1005 itstbptbiinc yeprov 3 PTBI 1010 itsswitch yeprov showinctotal itstbptbiexp yeprov 1 PTBI 1015 itstbptbiexp yeprov 2 PTBI 1020 itstbptbiexp yeprov 3 PTBI 1025 itsswitch yeprov showexptotal Paramvalue Summary Default Allows users to designate Hidden the trial balance subline that appears the Income section of the Income Statement Detail The param value must be the code to a trial balance subline Allows users to designate the trial Hidden balance subline that appears the Income section of the Income Statement Detail The param value must be the code to a trial balance subline Allows users to designate the trial Hidden balance subline that appears the Income
78. pied Foreign Currency Issues Each unit is assigned 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 When converting currency several potential issues 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 application 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 view 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 Entries are converted to reporting currency using appropriate foreign exchange rates Unit level reports appear in either Functional or Reporting currency by changing the currency Consolidated and Sub Consolidated level reports appear in either Functional or
79. rmats by selecting the Group By This Field and Showin Groups 46 2012 Thomson Reuters ONESOURCE GLOBAL ACCESS Administration El Sort Ascending B Menu Header Data Entry 17 Items El Sort Descending Data Entry Data Entry Data Entry Income Tax Rates Permanent Diffs Temporary Diffs Data Entry Temp Diff Analysis Data Entry Pl Amortized Tarn Diff Anahecio AmarTamnGl ien Nata Entre Once the selections have been completed select Done The Building Menu in Progress status updates to show the Menu Uploaded Successfully Manage Menu Configuration Instructions Use this page to manage menu configurations Utilize the menu configuration utility to add and remove available menu items and links Confirm your menu choices and upload the configuration to propagate the new menu items to the Data Entry side of the Global Access Module e Access the Manage Global Attachments page to view and or delete existing skin menu configurations 7 Name Link Menu Header Menu Header Data Entry 17 Items Menu Header Local Data Entry 11 Items Menu Header Local Reports 3 Items B Menu Header Main 5 Items tswHome jsp Main tswUnitListQuick jsp Main tswChangePwd jsp Main V Export Numbers E A Menu Header Reports 20 Items Once users have created a skin for a Menu Item that skin will be used and a new one may not be created If the skin alrea
80. rtant to note that Global Access honors restriction of components such as perms temps tax adjustments jurisdictions etc However ONESOURCE Tax Provision 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 application on the Manage Permissions screen in Administration in ONESOURCE Tax Provision or they can be imported through the 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 2012 Thomson Reuters 73 ONESOURCE GLOBAL ACCESS Configuration of Global Access in Corporate Edition 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 Ist 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 unt detall by status 2007 FY Provi
81. s to Hide H or make the Ending FX Rate field read only R Allows users to Hide H or make Editable Note the weighted average FX Rate field depends on the FX read only R Note Depends on thepolicy FX policy of the unit Allows users to the Hide 0 or make editable 1 the Taxes per book section The federal current Read Only Editable Hidden 64 2012 Thomson Reuters ONESOURCE GLOBAL ACCESS Administration Permanent Differences On the Permanent Difference page the following parameters can be used to open close and lock down fields itsswitch yeprov H Allows users to Hide H the Permanent difference Tags Editable tag drop down menu Note This must be used in conjunction with the parameter below Once these parameters have been set up together the tag below becomes the default tag If the parameter below does not exist the user will not be able to enter an amount itsswitch yeprov 1 Allows users to Hide H the Permanent difference code Editable hidecode P1000 2012 Thomson Reuters 65 GLOBAL ACCESS Administration Income Tax Rates On the Income Tax Rates page the following parameters can be used to open close and lock down fields Paramkey Paramvalue Summary Default must be unique itsswitch yeprov R or H Allows user to hide H or Read Only R Editable currtax the Current Income Tax Rate field itsswitch yeprov R or H Allows user to hide H or Read Only R
82. section of the Income Statement Detail The param value must be the code to a trial balance subline Allows users to show the Total Hidden Income calculated line A sum of the trial balance lines representing income lines Allows users to designate Hidden the trial balance subline that appears the Expense section of the Income Statement Detail The param value must be the code to a trial balance subline Allows users to designate the trial Hidden balance subline that appears the Expense section of the Income Statement Detail The param value must be the code to a trial balance subline Allows users to designate the trial balance subline that appears the Expense section of the Income Statement Detail The param value must be the code to a trial balance subline Allows users to show the Total Hidden Expenses calculated line A sum 2012 Thomson Reuters 63 GLOBAL ACCESS Paramkey Paramvalue itsswitch yeprov showptbitotal itsswitch yeprov usernum5 ITSQuestionDec5 What was the US GAAP Pre Tax income for year before last 2005 itsswitch yeprov W usernum6 ITSQuestionDec6 What are the earnings projected for FY 2006 enter a loss as a negative number itsswitch yeprov Iptbi R or H Local Profit Before Taxes itsswitch yeprov Iptbilabel RorH itsswitch yeprov uptbi itsswitch yeprov uptbilabel Corporate GAAP Pre Tax Income USD itsswitch yeprov H begfx itsswitch yeprov
83. sion ABC Company Inc Status E 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 Sign off Summary Report overview detail by status 2007 FY Provision Merck amp Co Inc Unit Code Unit Name Status Current User User Name UserPhone User E mail D1000 ABC Corporation ikisaka TestUser2 416 55 1237 tuser2 userco com D2000 DEF Corporation Prepared tuser1 TestUser1 416 555 1235 tuser1 userco com D3000 GHI Corporation Prepared tuser1 TestUser1 416 555 1235 tuser1 userco com D4000 JKL Corporation Unprepared F1000 German Corporation Prepared tuser1 TestUser 1 416 555 1235 tuser1 userco com F2000 UK Corporation Prepared tuser1 TestUser1 416 555 1235 tusert Muserco com F3000 Japan C ation det cab ACA TestUser2 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 view the User Name User Phone and User E mail columns the UsersExtended parameter must be activated with a value of 1 74
84. stem code descriptions in Administration of the ONESOURCE Tax Provision application however the codes themselves cannot be modified Alternative Minimum Tax system code After Tax Temporary Difference Code AMT SYS Valuation Allowance Automation system codes Temporary Difference codes V 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 C and VA SYS ATTD NC 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 2012 Thomson Reuters 7 ONESOURCE GLOBAL ACCESS ONESOURCE Tax Provision Concepts Codes Category items created and maintained in ONESOURCE Tax Provision are assigned unique codes Most codes are user defined and can be any combination of alpha and numeric characters including spaces as long as each code is unique Codes can have a maximum of 60 characters f codes are established in other applications consider re using them in the ONESOURCE Tax Provision application to create a one to one relationship with data in other applications System codes are used in automatic postings Other code conventions present data differently Administrators are responsible for creating and maintaining codes Naming Conventions Avoid using symbols when creating item names because
85. t below shows the instructions as they appear 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 adjustments must equal your ending balance Amount per financials statement and the computed amount must agree to the Freecon Comparison Report eee Instructions tswHome txt lt p gt This Tax Package is required in order to properly account for the 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 2012 Thomson Reuters 39 ONESOURCE GLOBAL ACCESS Administration lt p gt Selected entities will be reviewed by our auditors If users are selected users will be contacted If our auditors determine that they are going to audit a le
86. t is available from the menu bar in Global Access is discussed in this section of the guide Permanent Diffs STAT TAX The Permanent Diffs STAT Local TAX page allows users to enter differences between book income computed under Statutory Law and Local Tax Law that are permanent in nature these differences will not reverse in the future Permanent Diffs STAT Local TAX O Previous Next OQ Unit German Corporation F1000 Dataset 2009 Provision GAAP STAT Instructions e A permanent tax difference is created from income items which are never subject to income taxation e g 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 accounting 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 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 oo e Select the appropriate Tag letter Proce
87. t menu structure is composed of 5 groups Main Data Entry Reports Local Data Entry and Local Reports Easy to edit menu structure can be configured by an administrator using the ONESOURCE GAM Menu Configuration Utility The menu structure is configurable on a dataset skin basis Users no longer need to understand XML to configure the menu In the GAM Menu Configurations Utility users have the ability to configure the menu bar by selecting items from the Add Menu Item from the drop down menu 44 2012 Thomson Reuters ONESOURCE GLOBAL ACCESS Administration Manage Menu Configuration Instructions e Use this page to manage menu configurations Utilize the menu configuration utility to add and remove available menu items and links e Confirm your menu choices and upload the configuration to propagate the new menu items to the Data Entry side of the Global Access Module e Access the Manage Global Attachments page to view and or delete existing skin menu configurations Building Menu In Progress yeprovgs retprov reporting Q1 actual Q1 forecast Q2 actual Q2 forecast Q3 actual Q3 forecast The Menu Item Type available include Data Entry Reports Local Data Entry Local Reports Plugin Reports To configure a Menu Item select the appropriate radio button for the Menu Item Type then from the drop down menu select the Menu Item Link 2012 Thomson Reuters 4
88. t or multiple datasets Select Multiple Dataset Configuration to add the datasets to be published Users can publish a dataset with the following yeprov Publishes a dataset or reporting dataset using standard perm temporary data entry pages 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 Provision 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 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 72 2012 Thomson Reuters ONESOURCE GLOBAL ACCESS Configuration of Global Access in Corporate Edition 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 appears the name of the dataset that will appears in Global Access The name can be any text e g Full Year Provision Leave the Equiv and Next fields blank Clic
89. they will appear incorrectly on reports Refer to the list of special characters for symbols that do appear correctly Datasets Datasets define the periods of time and type of data being captured A blank dataset is created or an existing dataset is copied or rolled over to a new dataset using the Manage Datasets functionality in the ONESOURCE Tax Provision application Datasets can be set up as read write or read only Users can make a dataset read only in Manage Datasets within the Tax Provision Administration or by making it part of a sequential dataset Read only datasets allow users to review data and data cannot be edited Administrators are responsible for creating and maintaining datasets Units Units allow data to be entered and organized A unit is a legal entity branch cost center department division and is the lowest level of detail available to achieve all reporting requirements Units are combined with other units to create multiple sub consolidations to achieve various representations of data Sub Consolidation Sub Consolidations allow units to be combined for additional views of the data Units can be set up 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 for example EMEA and APAC 8 2012 Thomson Reuters ONESOURCE
90. tors have the ability to Export Categories In Administration select Export Categories Configuration of Global Access in Corporate Edition User Administration ONESOURCE Tax Provision 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 subconsolidations 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 Users can create users manually in the application in Administer Users in the Administration section of the ONESOURCE Tax Provision When creating users manually users can select an option to force users to change their password at next login Users can also import users through the CUC User Components tab in the Import Categories template Note A user cannot be deleted A user can only become inactive The audit trail for each user s 2012 Thomson Reuters 71 ONESOURCE GLOBAL ACCESS Configuration of Globa
91. ul gt 40 2012 Thomson Reuters ONESOURCE GLOBAL ACCESS Administration tswUnitNOLs 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 ub lt lpSelect the appropriate net operating loss from the drop down lt li gt lt li gt Select the current or non current designation lt li gt lt li gt Enter the Current Activity Amount in the lt b gt local currency lt b gt in lt b gt whole units lt b gt lt li gt lt l gt If appropriate enter a Deferred Only amount lt b gt or lt b gt a Balance Sheet Only amount Note that users cannot enter non zero values for both lt li gt lt l gt Click on the Add New button lt li gt lt ul gt lt li gt lt l gt If applicable enter valuation allowances lt li gt lt ul gt 2012 Thomson Reuters 41 ONESOURCE GLOBAL ACCESS 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 Users can attach any type of file 1 e Word document Excel spreadsheet pdf file text file etc as a Global Attachments page To add a new file 1 Click Browse 2 Select the file 3 Enter a description and code 4 Select Yes from the drop down list to add the file on the Introduction page
92. vision 2011 FY 2 Ch P d Dope Enmen Instructions e Click on Edit to change the amounts P Edit Choose Dataset 2011 Provision 2011 FY 2 iv t Fiscal Year Bucket Choose Unit 010 Downing I 2012 m FINAS Posting v Add New Expand Data Entry renos NL 3NL 771777277 T7 Compare to Dataset No Dataset Relations Set Amortized Temp Diff Analysis Net Operating Losses NOL Temp Diff Analysis After Tax Temp Diffs After Tax Temp Diffs Analysis Tax Adjustments Payable Analysis Enter a separate line item for each Payable After a payable item is created users 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 Users can attach files to individual payable items on this page If users have supporting documents click the paper clip or filing cabinet next to the item Also users have the ability to add and update comment to a line item Users may click on the comment icon then add comments as needed Note This screen can be added to the menu with using the Menu Configurations screen 2012 Thomson Reuters 33 ONESOURCE GLOBAL ACCESS Data Entry Tax Accounts The Tax Accounts page allows users to enter the unit s trial balance amount for each general ledger account pea Tax Accounts O Previous Next O Introduction Unit Downing 010 Dataset 2011 Pr

User Manual - Administrator

Contents

Download Pdf Manuals

Related Search

Related Contents