Home

User Manual - Administrator

1. 43 Coporate Contacts 43 Mer Contiguratdol m EI 44 Parameters NCC 44 Rermotebata Gollectiom GOnfigilatiODi 21 44 Entry Elelds Configuration E eec ee e cate plate iie 45 eI Ee ELI 46 Income Tax Rates 47 PermanentDifieremCeS 47 Temporary Differences Perte cue s ace cei bab E dei ieu has ta a ua 48 NOL 49 After Tax Temps 49 Return to Provision 49 Reference Items 51 Where to Enter Items in TaxStream ona aa nana na oo nnmnnn nennen nnmnnn nnnm 51 Access Component Types 52 Permission Component Types eeennne nennen nenne nennen nnnm enne tenete nnne sene nnnm nnns snnt nnne meten tn nn tnnt tenete 52 Index 53 2009 Thomson ONESOURCE Provision Remote Data Collection iTaxStream Overview of Remote Data Collection 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 Corporate and consolidated to compute the provision This requires manual consolidation which consumes
2. 15 Activating Payable Posting iore recen run rnnt tnnt cantes n tr nu Ca nen nm ip 15 Support 16 Logging into iTaxStream 17 Introduction PERSE 17 UnitList 18 Change Password 19 Data Entry 20 Federal National E DORT 20 Permanent Differences 20 Temporary Differences STATTA A 2555 22 Administration 24 Remote Data Collection Configuration Enterprise 24 2009 Thomson ONESOURCE Provision Remote Data Collection iTaxStream Contents 3 BEIM 24 Remote Data Collection User Setup 26 Publishing Datasets 27 Administer Permissions 29 User Status Report 31 Remote Data Collection AAMinistration s secececsesneeeeeececcnenseeneeceenaeaseenenceananasnenencecnaenssesenceenaenaseseneees 33 Sign Off Sequence 34 E mail Notification 35 Return to Provision 36 Manage Questionnaires oiccssciscisessciectesedeseccsdcceadvescteescucuasuedecs venrvesstencssellwavaucodvonerctonceassoscdavesganesadbedsucusuevondeccereddensessureeaedevaresee 37 Manage Instructions D 38 Ingo ior 40 Manage Global M CDD RREEEEEEMEMM 41 Entries RN
3. e Inthe data entry page for Temporary NOL After Tax and After Apportionment Temporary 2009 Thomson ONESOURCE Provision Remote Data Collection iTaxStream Differences there is a drop down list to select C for Current or NC for Non Current e Deferred Balances and NOL Balances reports can be filtered to view current and non current balances separately e The Temporary Difference Summary report displays current and non current balances by asset and liability Deferred Rollforward The expanded view of the Deferred Balances and NOL Balances reports has user defined columns to which data can be mapped e Each of three types of deferred activity can be mapped by tag letter to a column used to configure the Deferred Balance and NOL Balances reports e There can be up to 26 user defined columns You can use as many as you need e Administrative users are responsible for creating and maintaining the Manage Deferred Rollforward and Manage NOL Rollforwards screens in ONESOURCE TaxStream Provision Enterprise 2009 Thomson ONESOURCE Provision Remote Data Collection iTaxStream TaxStream Concepts 15 Rollup Codes Certain Provision Activity can be mapped to user defined grouping lines on the Deferred Balance and Effective Tax Rate reports e The Deferred Rollup maps Temporary NOL Temporary After Tax Temporary State After Tax Temporary and State After Apportionment differences e
4. Amount per financials statement and the computed amount must agree to the Freecon Comparison Report 6 6 Instructions tswHome txt p This Tax Package is required in order to properly account for your company s income taxes under US Generally Accepted Accounting Principles GAAP FAS 109 Accounting for Income Taxes establishes financial and reporting standards for the effects of income taxes that result from an entity s activities during the current and preceding years lt gt lt p gt The Corporate Tax Department will use this information in calculating and supporting the amounts included in the company s income tax accounts which are reported in the annual financial statements and audited by our auditors lt p gt lt p gt Selected entities will be reviewed by our auditors If you are selected you will be contacted If our auditors determine that they are going to audit a legal entity that you are responsible for this system will provide the necessary reports for the FAS 109 calculation lt p gt lt p gt lf you have any questions as you prepare this tax package please 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 lt li gt lt li gt The entities for which you 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 p
5. PTBI Policies There are five Pre Tax Book Income policies that can be assigned to units Each policy asks for different input and generates results based on the information entered for the unit Select the best policy for the data you wish to populate and the calculations that the system should perform Local Currency Reporting Policy PTBI Currency PTBI Rounding Enter Local USD FX ard Gale Round 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 are converted at the entered Weighted Average or Spot Rate If the unit is using the Enter USD FX and Calc Local FX policy you cannot save the amount you entered It will always revert back to the amount calculated To modify the amount the unit must have another policy Depending on the PTBI policy in use certain fields default to read only Any component that is selected to be calculated by TaxStream automatically becomes read only in Remote Data Collection formally iTaxStream 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 Remote Data Collection Enter Local FX and Calc USD 2009 Thomson ONESOURCE Provision Remote Data C
6. 066 000 Enter a separate line item for each Permanent Difference Payable Selected Accounts Questionnaire 1 Select the appropriate code description from drop down menu in first column 2 Select the type of the permanent difference item It will usually be a P amp L adjustment However if you are entering an item that does not have any impact on the current tax expense i e stock option expense select E Equity adjustment Note Refer to the Where to Enter Items in TaxStream section for more information on the different types of permanent difference items 3 Enter the amount of the permanent difference in local currency 4 Click Add New to create the permanent difference Note If a new permanent difference item is required contact the Corporate Tax Department After a permanent difference item is created you can edit or delete the item by clicking the appropriate icon If you click the pencil icon you must select Save Changes after making changes The impact of individual permanent differences on your tax provision can be viewed on the Tax Provision Report and the Effective Rate Report Once a permanent difference item is created you can edit or delete it by clicking the appropriate icon Click the pencil icon to edit the entry Select Save Changes after making any changes You can attach files to individual permanent difference item on this page If you have supporting documents click the paper clip icon
7. D3000 GHI Corporation tuser1 TestUser1 416 555 1235 tuser1 userco com Prepared F1000 German Corporation tuser1 TestUser1 416 555 1235 tuser1 userco com Prepared F2000 UK Corporation tuser1 TestUser1 416 555 1235 tuser1 userco com 1st Level Reviewed 01000 ABC Corporation au ee 1st Level Reviewed 23000 Japan Corporation se TestUser2 416 55 1237 tuser2 userco com Remote Data Collection Administration Administrators can use ONESOURCE TaxStream Provision Enterprise to manage users and configure Remote Data Collection formally iTaxStream to meet their needs Although most administrative functions in ONESOURCE TaxStream Provision Enterprise are related to the initial setup of the Remote Data Collection implementation the Remote Data Collection administration page provides administrators with the flexibility to modify instructions and questionnaires 2009 Thomson ONESOURCE Provision Remote Data Collection iTaxStream TaxStream Planning Software Introduction Sign Off Sequence E Mail Notification Return To Provision Manage Questionnaires Manage Instructions Manage Global Attachments v 3 Corp Tax Dept Contacts TaxStream Administration out Setup The purpose of this application is to administer the iTaxStream Application The following pages will allow an administrator to control various aspects of the iTaxStream Wizard These pages are meant for TaxStream Administrative Users an
8. List CTADJ Temporary Differences Amortized TD A Temporary Differences List CTD 2009 Thomson Reuters ONESOURCE Provision Remote Data Collection iTaxStream Index 53 n dex Data Entry 20 Filing Group 6 Attributes 6 Automation 6 A Child 6 E Parent 6 Reporting 6 Filing Unit 6 Foreign Currency Issues Change in Rate 7 Currency Translation Adjustments 7 Currency Types 7 Activating Payable Posting 15 Activity 15 Administration 5 6 20 27 36 44 49 B Deferred Balances 7 Foreign Exchange Rates 7 Balance Sheet Only 15 FXRates 7 Treatment 7 Functional Currency 7 Categories 5 G Change Password 19 Code 5 GAAP to Stat 44 Components 15 Country Codes 6 10 E H E Currency Codes 6 Currency Translation Adjustment 7 Currency Types 7 Hybrid 15 Hyperinflationary Environment 7 Current 13 L E D Local Currency 7 Dataset 18 Datasets zs Management 5 Deactivate Units 6 Missing Page 5 Deferred Only 15 Deferred Rollforward 14 National Data Entry 20 Entering Items in TaxStream 51 NOL Rollforward 14 Equity 13 Non Current 13 FAS 52 7 Overview 4 Federal 2009 Thomson Reuters ONESOURCE Provision Remote Data Collection iTaxStream TaxStream Concepts 5 5 Terminology 5 Thousands Separators Currency 7 P amp L 13 P amp L vs Equity 13 U Password 19 Payable unable to change PTBI 8 Activating Payable Posting 15 Unit 18 Pre Pop
9. Log out 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 export categories 10 04 2007 10 51 am xls test Corp Contacts No Download Delete je mercki xsl Journal Entry 1 No Download Delete Attach New File File Browse Description Code B Show on Intro Page No M Files that display on the Introduction page display for all Remote Data Collection users upon login They are available to all Remote Data Collection users regardless of their user level 2009 Thomson ONESOURCE Provision Remote Data Collection iTaxStream Administration TaxStream Corp Tax Dept Contacts TaxStream FAS 109 Online Tax Package Tax Provision and Planning Software Log out Introduction Unit List Be n Change Password This Tax Package is required in order to properly account for your company s income taxes under U S 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
10. NOL page the following parameters can be used to open close and lock down fields Paramvalue Summary Default itsswitch yeprov attddefo H Allows users to Hide H make Read Only R Editable nly or Editable W the deferred only field itsswitch yeprov attdbals Allows users to Hide H make Read Only R Editable h or Editable W the balancesheet only field Return to Provision On the Return to Provision page you can use parameters to turn fields on and off Allows user to show the Post RTP button at the bottom of the Return to Provision screen This parameter works in addition to the Return to provision confiquration in admin 2009 Thomson ONESOURCE Provision Remote Data Collection iTaxStream of Total After Tax Temp Differences 115 019 115 019 0 Cash Tax Adjustments TA1000 Tax Reserves 186 815 186 815 0 NC 2006 2006 Return to Provision Perm v o S E Total Cash Tax Adjustments 186 815 186 815 0 Cash Provision 45 192 134 44 952 794 239 340 Post RTP 2009 Thomson Reuters ONESOURCE Provision Remote Data Collection iTaxStream Reference Items 51 Reference Items Where to Enter Items in TaxStream Is the item Pre Tax Gross or Tax Effected Net Item impacts Ending Deferred Balances Item impacts Ending Deferred Balances Yes No Item impacts the Item impacts the Item impacts the Taxes Payable Effective Tax Ra
11. T 5 0006 TEST Text Edit Delete 7 Q007 TEST Yes No Edit Delete T T 8 Q008 TEST Number Edit Delete S 0009 TEST Decimal Edit Delete 10 Q010 TEST Header Edit Delete T T Tet M Copy questions from 0001 Administrators can use the Copy questions from function to assign the same questionnaire to more than one dataset Manage Instructions Administrators can update instructions for each Remote Data Collection formally iTaxStream page using the administration section of Remote Data Collection Instructions should be saved as text files and be written in well formed HTML 2009 Thomson ONESOURCE Provision Remote Data Collection iTaxStream Adminisiration 39 TaxStream T Corp Tax Dept Contacts d TaxStream Administration Sior d Loq out Planning Software Introduction Instructions Setup Sign Off Sequence E Mail Notification Instructions Return To Provision Use this page to upload your instructions Your instructions must be written in well formed HTML ti i nun que EE To change the instructions for a particular page i e tswHome jsp change the extension of the Manage Instructions file to txt i e tswHome txt Manage Global Attachments Please choose the file to upload Browse Instructions Sample b Instructions b ul li The input below should reflect items that impact the tax payable account eg
12. a tax payment to the government or a tax refund from the government lt li gt lt li gt Debits should be lt b gt positive lt b gt Credits should be font color red gt lt b gt negative lt b gt lt font gt lt li gt lt li gt Fill in payments refunds and adjustments using your lt b gt local currency 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 your ending balance lt li gt lt li gt Amount per financials statement and the computed amount must agree to the Journal Entry Comparison report lt li gt lt ul gt The sample shows the instructions written in well formed HTML We have written a specific text file for every page Users can change the text and upload modified files Please refer to the attached file called Instructions for Remote Data Collection The screen shot below shows the instructions as they display on the page 2009 Thomson Reuters ONESOURCE Provision Remote Data Collection iTaxStream 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
13. can publish datasets as a Provision dataset or a Return to Provision dataset Depending on the dataset type the data entry menu bar in Remote Data Collection formally iTaxStream changes When an administrator publishes a dataset as a provision dataset using yeprov as the column type in ONESOURCE TaxStream Provision Enterprise each page available from the menu bar in Remote Data Collection is discussed in this section of the manual Introduction Unit List Change Password F1000 German Corporation Data Entry Unit Data Income Tax Rates Permanent Diffs LE Temporary Diffs Net Operating Losses After Tax Temp Diffs Tax Adjustments Liabilities Selected Accounts Questionnaire Sign Off Permanent Differences STAT TAX The Permanent Diffs STAT Local TAX page allows you to enter differences between book income computed under Statutory Law and Local Tax Law that are permanent in nature i e these differences will not reverse in the future 2009 Thomson Reuters ONESOURCE Provision Remote Data Collection iTaxStream Data Entry 21 Corp Tax Dept Contacts ONESOURCE TAXSTREAM PROVISION reuters Log out Permanent Diffs STAT Local TAX Previous Next Unit List Unit German Corporation F1000 Dataset 2009 Provision GAAP STAT CRange password password Instructions A permanent tax difference is created from income items which are never subject to inc
14. itsswitch yeprov endbalin Allows users to enter the ending balance or the Hidden put activity for all temporary differences including NOL After Tax Temps Local Temps After App and State After Tax Temps The default hen this parameter is used is to enter ending balance When a user enters this parameter the Activity column become calculated values Note his functionality has not been added to the emporary Differences U S GAAP STAT and emporary Differences STAT Local TAX itsswitch yeprov cnc Allows users to Hide H make Read Only R Editable or Editable W the current non current field hen this parameter is used any new temps will be set up as C or Current Allo M Manual Adds the paramvalue as one of the tags in the Blank ags drop down menu For example if M Manual is used then the user sees Manual in the Tags 2009 Thomson ONESOURCE Provision Remote Data Collection iTaxStream Administration NOL In the NOL page the following parameters can be used to open close and lock down fields Paramvalue Summary Default itsswitch yeprov nols H Allows users to Hide H make Read Only R or Editable defonly Editable W the deferred only field itsswitch yeprov nols Allows users to Hide H make Read Only R or Editable balsh Editable W the balancesheet only field users to Hide H or make Read Only R the Tax drate Effecting Rate field After Tax Temps In the
15. letter G to the drop down menu for the Tags in the ONESOURCE TaxStream Provision Enterprise Adds the word Manual to the drop down menu for the SCC yeperge4 Tags in the Remote Data Collection for perms Adds the word Manual to the drop down menu for the Tags the Remote Data Collection for temps 2009 Thomson ONESOURCE Provision Remote Data Collection iTaxStream Administration 45 Activates the Payable Module Shows the payable data SHOW_ADVANCEDLIABILITY entry page and reports SHOW SIMPLELIABILITY 0 Hides simple liability report Adds the ability to assign non interim datasets to a ITS_ASSIGN_DATASETS Entry Fields Configuration Note The following parameters apply to more than one page throughout the system Paramvalue Summary Default SHOW DSCOMP 1 Allows others to view entries for datasets in the system Hidden his is only available for Permanent Temporary NOL emps and After Tax Temporary Differences Note Users can view all datasets not just those published to Remote Data Collection itstagperms yeprov 1 M Manual Adds the paramvalue as one of the tags in the tags drop down menu For example if M Manual is used he user sees Manual in the Tags drop down menu drop down menu Adds the paramvalue as one of the tags in the Tags Prov drop down menu Adds the paramvalue as one of the tags in the Tags drop down menu Adds the paramva
16. login and are then redirected to the Introduction page ONESOURCE TAXSTREAM PROVISION Data Collection Username Password 2009 Thomson Reuters ONESOURCE All Rights Reserved e THOMSON REUTERS Introduction When users log in to Remote Data Collection formally iTaxStream the Introduction page displays This page contains an introduction prepared by Corporate as well as a general explanation of the software The Global Attachments section displays documents uploaded by Corporate Please review the instructions and documents If you need assistance click the Corp Tax Dept Contacts link for contact information When you are ready to proceed click Next in the upper right hand corner of the page You can also proceed by clicking Unit List from the left navigation 2009 Thomson ONESOURCE Provision Remote Data Collection iTaxStream i Next noes Introduction Unit List Change Password This Tax Package is required in order to properly account for your company s income taxes under U S 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 The Corporate Tax Department will utilize this information in calculating and supporting the amounts included in the company s income tax accounts which a
17. lots of time and makes immediate feedback to foreign users almost impossible With Remote Data Collection formally iTaxStream foreign and domestic subsidiaries compile tax provision information and enter it directly into the Remote Data Collection website This results in subsidiaries having access to reports that immediately compute their provision and effective rate Data is entered directly into the Corporate TaxStream database reducing the potential for errors and saving time Consolidation of all information occurs automatically within ONESOURCE TaxStream Provision Enterprise In addition to stream lining the process of entering and consolidating provision information the system provides users with a set of controls In Remote Data Collection up to 8 levels of sign off can be created for users Access to units can be limited by sign off level Also adjustments such as permanent and temporary differences can be assigned on a unit by unit basis The status of sign off level displays on the first page unit list of Remote Data Collection as well as in the Sign off Summary report in ONESOURCE TaxStream Provision Enterprise In the remainder of this manual we discuss all parts of Remote Data Collection and how to best use this application to improve your provision process Data entry pages and reports as well as Remote Data Collection administration are discussed 2009 Thomson Reuters ONESOURCE Provision Remote Data Collection iT
18. next to the item The impact of individual permanent differences on your tax provision can be viewed on the Tax Provision Report and the Effective Rate Report 2009 Thomson ONESOURCE Provision Remote Data Collection iTaxStream Temporary Differences STAT TAX The Temporary Differences STAT TAX page allows you to enter differences between book income computed under Statutory Law and Local Tax Law in your country that are temporary in nature These differences will reverse in the future Corp Tax Dept Contacts ONESOURCE TAXSTREAM PROVISION reuters Logout Temporary Diffs STAT Local TAX previous Next 9 ntroduction Unit List Unit German Corporation F1000 Dataset 2009 Provision GAAP STAT Change Instructions Atemporary tex 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 Add eachtemporary difference as follove Data Entry Selectthe appropriate temporary difference from the drop dovm Unit Data Enterthe Current Activity Amountin your functional currency in whole units Clickon the Add New button Income Tax Rates Proceedtothe next step when finished Permanent Diffs U S 5 Permanent Diffs STAT Local T
19. the Current Activity Amount in your lt b gt local currency lt b gt in lt b gt whole units lt b gt lt li gt lt li gt lf appropriate enter a Deferred Only amount lt b gt or lt b gt a Balance Sheet Only amount Note that you cannot enter non zero values for both lt li gt lt li gt Click on the button lt li gt lt ul gt lt li gt lt li gt If applicable please enter applicable valuation allowances lt li gt lt ul gt Manage Global Attachments Once you log in to the Remote Data Collection formally iTaxStream Administration area you notice the Global Attachment section at the bottom of the page This section can be used to attach any file that you would like to share with other Remote Data Collection users such as a manual or a contact list Users can attach any type of file i e Word document Excel spreadsheet pdf file text file etc as a Global Attachments page To add a new file click Browse and select the file Enter a description and code Select Yes from the drop down list if you would like to display the file on the Introduction page 2009 Thomson Reuters ONESOURCE Provision Remote Data Collection iTaxStream TaxStream Tax Provision and Planning Software Introduction Sign Off Sequence E Mail Notification Return To Provision Manage Questionnaires Manage Instructions Manage Global Attachments Corp Tax Dept Contacts TaxStream Administration
20. to create the temporary difference Note If a new temporary difference item is required contact the Corporate Tax Department Once a temporary difference item is created you can edit or delete it by clicking the appropriate icon Click the pencil icon to edit the entry Select Save Changes after making any changes You can attach files to individual 2009 Thomson ONESOURCE Provision Remote Data Collection iTaxStream Data Entry 23 temporary difference item on this page If you have supporting documents click the paper clip icon next to the item The impact of individual temporary differences on your tax provision can be viewed on the Tax Provision Report and the Effective Rate Report 2009 Thomson ONESOURCE Provision Remote Data Collection iTaxStream Administration Remote Data Collection Configuration Enterprise User Administration ONESOURCE TaxStream Provision Enterprise 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 subconsoli
21. write Read Write L1 C Read Write Sign Off Oo Sign Off L1 Sign Off L1 L1 o Sign Off 3 Rollback C rollback Rollback Read Write C Read write Read Write Sign Off Read Write Sign Off o Sign Off Sign Off C Rollback v Rollback Rollback E mail Notification Administrators can now set up Remote Data Collection to send out an email messages after each user signs off or rolls back a dataset Emails messages can be sent out to the read write users sign off users roll back users or all users You can also enter email addresses of other people who would like to receive these messages 2009 Thomson Reuters ONESOURCE Provision Remote Data Collection iTaxStream TaxStream T Corp Tax Dept Contacts DERE KR MEUSE TaxStream Administration Planning Software I a E Mail Setup Sign Off Sequence E Mail Notification Instructions Return To Provision Use this page to set up the e mails that are triggered upon Sign Off Rollback Manage Questionnaires Manage Instructions Would you like to send e mails to your users upon sign off Manage Global Attachments O ves No Who would you like to send an e mail to ClRead Write users Sign Off users Cl rollback users Who would you like to send every e mail to separate addresses with commas nataly taxstream net Some system configuration may need to take place to take advantage of the Email Notification feat
22. you select an appropriate dataset In addition to publishing a return to provision dataset there are additional configurations that need to be completed Please refer to the Return to Provision topic in the Remote Data Collection Administration section of this manual Administer Permissions It is important to note that Remote Data Collection formally iTaxStream honors restriction of components such as perms temps tax adjustments jurisdictions etc However ONESOURCE TaxSiream Provision Enterprise does not honor these restrictions The page shown below is used only for Remote Data Collection Note Citrix hosted users must ensure that the Days value for expired passwords is not set too high 2009 Thomson Reuters ONESOURCE Provision Remote Data Collection iTaxStream Administration Manage Permissions Unit List Component Types Description Provision PermDiff List D1000 Corporation Member D2000 DEF Corporation D3000 GHI Corporstion Component 04000 JKL Corporation F1000 German Corporation P2000 Goodwill F2000 UK Corporation P3000 Officer s Life Insurance com Japan Corporation P4000 Subpart F Income German 05000 Foreign Tax Credit Gross up P6000 Stock Options O P7000 Disallowed Expenses CO 1000 Depreciation O 2000 State Tax Provision O 5 3000 Disallowed Expenses C 5 4000 Adjustment to Municipal Tax Inte
23. 01 Local Country Tax Filing Position Edit Delete Manage Questions 2008 Q2 Provision 0002 Audits Corporate Income Taxes Edit Delete Manage Questions 2007 Year End Provision 2009 Thomson ONESOURCE Provision Remote Data Collection iTaxStream Questions are assigned a unique code and are put in order according to this coding scheme For each question an administrator assigns a response type Text Yes No Number Decimal or Header Selecting Header allows users to create titles for different sections of the questionnaire Questionnaires can be set up and imported into ONESOURCE TaxStream Provision Enterprise through ZUQUESTZ Questionnaires and the UQSTNS Questions tabs e TaxStream Administration Manage Questions Q003 Local Country Tax Filing Position Introduction ae Instructions E Mail Notification Create edit and delete your questions here REI MS Or copy questions from existing questionnaires into an empty one existing questions will be deleted Manage Questionnaires Manage Instructions Order Code Question Response Type Manage Global 4 Attachments 1 Q001 TEST Text Edit Delete Manage Params T T 2 Q002 TEST Yes No Edit Delete 3 Q003 TEST Number Edit Delete T T 4 0004 TEST Decimal Edit Delete 5 0005 TEST Header Edit Delete T
24. AX Temporary Diffs U S GAAP STAT Temporary Diffs STAT Local TAX Current SONS Current 12 E s Beginning tivi Deferred Balance Ending Code Description Non Balance Only Sheet Only Balance Current Amount 0053354 Temp with Leading Zero 0 0 Current Current Balance Ending Balance amp Non MU Activity cn red Sheet Tax effecting Rate Current Amount Only Net Operating Losses After Tax Temp Diffs Adjustments Payable BadDebt 7 Selected Accounts 2 71000 0 is Default Tax Rate Accrued 0 SS 2 d 0000 Vacation R 9 9 9 Default Tax Rate Sign Off Accrued A T11000 Workers 0 ml aes 400 000 fauli Reports Default Tax Rate Compensation M Enter a separate line item for each Temporary Difference 1 Select the appropriate code description from the drop down menu in the first column 2 Indicate whether the item is classified as current or non current 3 The carryover balance if any is automatically pre populated 4 Enter the current activity amount in local currency 5 There are also fields for entering deferred adjustments and balance sheet only adjustments Note Refer to the Where to Enter Items in TaxStream section for more information on the different types of adjustments i e current activity deferred only and balance sheet only 6 Click Add New
25. D1000 CTD TD124 G 13 01000 50 G 14 15 16 17 18 19 20 21 22 23 4 gt CUC User Components CUNC Unit Components User Status reports are available after the administrator has configured Remote Data Collection and created users with permissions User Status Report There are three parts to the Remote Data Collection formally iTaxStream User Status report the Overview Detail by Unit and Detail by Status The Overview report shows the overall status of the provision calculation how many units are inactive how many have been prepared 1st level reviewed and 2nd level reviewed Note In order to view this report with review levels 1st and 2nd review the UserAdminComponentTypes parameter must be activated with a value of 61 62 63 2009 Thomson ONESOURCE Provision Remote Data Collection iTaxStream Sign off Summary Report detail by unit detail by status 2007 FY Provision Merck amp Co Inc Status Units Inactive 0 Unprepared 2 Prepared 4 1st Level Reviewed 2 2nd Level Reviewed 0 The Detail by Unit report shows the status of the provision on a unit by unit basis It also shows the current users for each unit who have committed their work Note In order to view the User Name User Phone and User E mail columns the UsersExtended parameter must be activated with a value of 1 Sign off Summary Report overview detail by status 2007 F
26. Effective Rollup maps all the items in Deferred Rollups plus Permanent Difference Tax Adjustments and Deferred Provision Only Adjustments e There can be multiple user defined rollup mappings They display the upper right corner of the Deferred Balance or the Effective Tax Rate Rollups can display on a summary or hybrid basis e Administrative users are responsible for creating and maintaining Rollup mappings Payable Activity can be mapped and rolled up to user defined grouping lines on the Payable Rollforward and Payable Detail reports e Payable Rollup maps Payable Transaction Types e Administrative users are responsible for creating and maintaining Payable Rollup mappings Components A component is a general term for a list of items in TaxStream Typically a component is a drop down menu with a list of possible options Component examples are e Book to Tax Adjustments Permanent Difference Temporary Difference Tax Adjustments etc e Payable Items Transaction Codes Buckets etc e Unit Attributes State Jurisdiction Attachments Rollup Codes etc e System Items User Rights Audit Trail Transactions etc Activity Deferred Only Balance Sheet Only Entries that impact deferred tax accounts need to be designated as activity deferred only or balance sheet only In the data entry page for Temporary NOL After Tax and Local NOLs there are options for Activity Deferred Only and Balance Sheet only e Def
27. ONESOURCE Provision Remote iTaxStream THOMSON REUTERS ONESOURCE Provision Remote Data Collection iTaxStream Table of Contents Overview of Remote Data Collection 4 TaxStream Concepts 5 Codes 5 System Codes 5 Naming Conventions Mmm 5 Datasets eee ceu cee 5 Unts _ _ 6 SUB lt CORSONGATONS __ eee ees savccdocsscachisacceccsuabsaccecceusssecasscdecscacssazeccacansscsacteedecssassaaceausceudecaeasdecetosssaucceussuaacene 6 Filing Group 6 Tag 2 6 Records Unit State aaa aa i a aa rre cl ai ai 6 Foreign Currency E E a E T T E m 7 Currency Options cc 7 Foreign cce 7 Pretax POlGtes 8 10 P amp L Equity 5 13 TTC 13 Deferred RollforWwatrd ER NRRR 445 82413 E QU CERE ERR aariaa CERE 14 Rollup Codes e 15 Components e 15 Activity Deferred Only Balance Sheet
28. Provision Remote Data Collection iTaxStream 01000 G CU 01000 G CU 01000 G CU 51000 lc CU 02000 G CU 02000 G CU 02000 G CU D2000 G CU 03000 G CU 03000 G CU 03000 G CU D3000 G CU 04000 G CU 04000 G CU 04000 G CU 04000 G CU F1000 G CU F1000 G CU F1000 G CU F1000 G CU F2000 G 24 duser iG M 4 CUSR Users amp CUC amp User Components CUNC I Remote Data Collection User Setup When user is set up for Remote Data Collection formally iTaxStream the administrator needs to grant them access to a set of units and a user level Preparer 1st reviewer 2nd reviewer etc in ONESOURCE TaxStream Provision Enterprise There are up to 8 levels of sign off available in Remote Data Collection e Unit List Allows you to see units on the Remote Data Collection Unit List page Preparer Grants you the ability to change values in a unit as long as the unit is in the incomplete state Also allows the user to sign off from Incomplete to Prepared 1st Reviewer Allows you to sign off from Prepared to 1st Level Reviewed roll back from Prepared to Incomplete 2nd Reviewer Allows you 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 ZCUCZ tab using the following component type codes CU Unit access CSC Subconsolidations SO1 Preparer Sign Off access 502 Rev
29. Provision Remote Data Collection iTaxStream Administration 41 lt li gt Amount per financials statement and the computed USD amount must Agree See Income Tax Acct Report lt li gt lt ul gt tswUnitATTempDiffs txt lt b gt Instructions lt b gt lt ul gt lt li gt An after tax temporary difference is a modification to the current and future tax provision which is reported on an after tax basis lt li gt lt li gt Add each after tax temporary difference as follows lt ul gt lt li gt Select the appropriate after tax temporary difference from the drop down lt li gt lt li gt Enter the amount using your lt b gt local currency lt b gt in b whole units lt b gt lt li gt lt li gt Click on the New button lt li gt lt ul gt lt li gt lt li gt The deferred only input should be used for activity that impacts the deferred provision but not the current provision lt li gt lt li gt lf additional new After Tax Temporary differences are required please contact the Next Tax Office lt li gt lt ul gt 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 lt ul gt lt li gt Select the appropriate net operating loss from the drop down lt li gt lt li gt Select the current or non current designation lt li gt lt li gt Enter
30. Y Provision Merck amp Co Inc Unit Code Unit Status Current User User Name UserPhone User E mail 01000 ABC Corporation 1st Level Reviewed Tener AUSSER 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 TestUser1 416 555 1235 tuser1 userco com F2000 UK Corporation Prepared tuser1 TestUser1 416 555 1235 tuser1 userco com F3000 Japan Corporation 1st Level Reviewed 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 2009 Thomson ONESOURCE Provision Remote Data Collection iTaxStream Administration 33 Sign off Summary Report overview detail by unit 2007 FY Provision Merck amp Co Inc Status Unit Code Unit Name Current User User Name UserPhone User E mail Unprepared D4000 JKL Corporation Unprepared F4000 German Holdco tuser Test User 416 555 1234 tuser userco com Prepared 02000 DEF Corporation tuser1 TestUser 1 416 555 1235 tuser1 userco com Prepared
31. ages lt li gt lt li gt There is also a status indicator in each row This indicator shows one of four status descriptions lt ul gt lt li gt Incomplete indicates that the Preparer has not completed data entry lt li gt lt li gt Prepared indicates that the Preparer has finished data entry lt li gt lt li gt 1st Level Reviewed indicates that the Reviewer has finished their review lt li gt lt li gt 2nd Level Reviewed indicates that the Financial Officer responsible for this entity has signed off on this income tax calculation Once the unit has been 2nd Level Reviewed you cannot make any further changes to that unit without contacting the Corporate Tax Department lt li gt lt ul gt tswLiabilitiesAdv Fed txt b Instructions b lt ul gt lt li gt The input below should reflect items that impact the tax payable account eg a tax payment to the government or a tax refund from the government lt li gt li Payments should be positive Refunds should be negative lt li gt lt li gt Fill in payments refunds and adjustments using your b Functional currency lt b gt in lt b gt whole units lt b gt lt li gt lt li gt lnput the Ending Income Tax Payable Balance using the lt b gt Functional currency lt b gt in lt b gt whole units lt b Beginning balance plus minus payments refunds and adjustments must equal your ending balance lt li gt 2009 Thomson ONESOURCE
32. axStream TaxStream Concepts TaxStream Concepts The following sections define terminology used in TaxStream for various concepts Codes Category items created and maintained in TaxStream require unique codes assigned to them e Most codes are user defined and can be any combination of alpha and numeric characters including spaces as long as each code is unique e Codes can have a maximum of 60 characters e f codes have been established in other systems consider reusing them in TaxStream to create a one to one relationship with data in other systems System codes are used in automatic postings e Other code conventions present data differently e Administrative users are responsible for creating and maintaining codes System Codes Some codes are required by the system and some behave differently from the norm Descriptions for system codes can be modified in the Administration section of ONESOURCE TaxStream Provision Enterprise but the codes themselves should not be modified e Alternative Minimum Tax system code After Tax Temporary Difference Code AMT SYS e Valuation Allowance Automation system codes Temporary Difference codes VA SYS PTTD C and VA SYS PTTD NC NOL Temporary Difference codes VA SYS NOLTD C and VA SYS NOLTD NC After Tax Temporary Difference codes VA SYS ATTD C and VA SYS ATTD NC e NOL Temporary Difference code NOL SYS The code can be extended e g NOL SYS 2007 e Non Cash Tax Adjustment
33. ces page STAT TAX Permanent Differences pages etc 2009 Thomson ONESOURCE Provision Remote Data Collection iTaxStream 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 02 actual and Q3 actual Publishes the Actual datasets Administration Manage Reporting Datasets Visible to Web Single Dataset Confiquration Fiscal Visible Year Period Type Name 2007 Dataset 2007 Provision O 2007 FY Dataset test Multiple Dataset Confi ti Col No Dataset Col Type Col Header Equiv Next 2007 FY Provision yeprovgs GAAP STAT 2006 Prov 2007 FY Provision yeprov 2006 Provision YTD gt test 2007 FY Y test Move Selected Line UP Down Add Update i Note that the order of datasets can be adjusted by using the Up and Down buttons which shuffle the selected dataset up or down the list The top dataset appears as the leftmost dataset on the Unit List page of Remote Data Collection 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 anda yeprovgs use separate data entries for GAAP STAT and STAT Tax permanents and temporaries Col Header displays the name of the dataset that will display in Remote Data Coll
34. d TaxStream Administrative Users only If you are accessing these pages and believe you should not have access please notify your TaxStream Administrator If you are unsure of a feature in this section please contact your TaxStream Administrative Group or the TaxStream Support Team Note Only administrators have access to this Remote Data Collection administration section The URL for this administration section is http your Remote Data Collection link here admin Sign Off Sequence On the Sign Off Sequence page administrators can set up users sign off roles using the matrix shown below In the past reviewers were not able to modify data once the preparer signed off However the administrator can now configure each sign off level and grant specific access levels i e read only and read write access 2009 Thomson ONESOURCE Provision Remote Data Collection iTaxStream Administration 35 TaxStream ET E Corp Tax Dept Contacts TaxStream Administration ax Provision and Log out Planning Software Introduction 000000 Sign Setup Sign Off Sequence E Mail Notification Instructions Return To Provision Use this page to set up your Sign Off Sequence Manage Questionnaires Read Write Read Write C Read Write Sign Off oO Sign Off Sign Off Rollback C Rollback Rollback Manage Instructions Manage Global Attachments Read Write Sign Off C Read write C Read
35. dations They have the same access as Read Write but for all datasets units and subconsolidations Unlike Read Only or Read Write users they can also modify categories 4 Inactive users have no rights to view or edit any data Note A user cannot be deleted A user can only become inactive The audit trail for each user s existence must be maintained 2009 Thomson Reuters ONESOURCE Provision Remote Data Collection iTaxStream Administration 25 Administrator _ Change F Read Write Read Only Inactive BC Corporation Administrator Administrator Read Write Read Only Read Only German Corporation DEF Corporation GHI Corporation JKL Corporation Read Only UK Corporation Japan Corporation German Holdco Users can be created manually in the system under the Administer Users tab in the administration tab in ONESOURCE TaxStream Provision Enterprise When creating users manually through the ONESOURCE TaxStream Provision Enterprise an option is presented to force users to change their password at next login Users can also be imported through the CUC tab in the import_categories spreadsheet The Imported Fields are the following Username Component Type Code Component Code e g unit code etc and Action G Grant D Deny For Component Type Code there are multiple selections such as the following CU Unit access CDS Datasets and CSC Subconsolidations 2009 Thomson Reuters ONESOURCE
36. dministrative 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 should be in local currency The Payable Entry page allows for the weighted average FX rate to be entered ona 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 display on the Payable Detail Report The Payable Detail Report can be viewed in both Local Currency and Reporting Currency Support General Customer Support e Phone 877 829 5969 extension2 e Email support taxstream net Support Site e http onesource thomsonreuters com provision e Please call support for the password 2009 Thomson ONESOURCE Provision Remote Data Collection iTaxStream Logging into iTaxStream 17 Logging into iTaxStream Because Remote Data Collection formally iTaxStream is a web based tool users are given a web address with a username and password to log in Administrators can set up a forced password change in ONESOURCE TaxStream Provision Enterprise for Remote Data Collection users on their first login In this case Remote Data Collection users view the Change Password page on their first
37. e Weighted Average FX Impact and the Ending Spot FX Rate Detail of CTA Calculation Components 14 141 3673 909 55 0 15 778 Information for the Calculation Beginning Temporary Difference Balance 100 000 Temporary Difference Activity 10 000 Beginning FX Spot Rate 0 45 Current Tax Rate 37 Ending FX Spot Rate 0 55 Beginning Deferred Tax 35 Rate Weighted Average FX Rate 0 50 Ending Deferred Tax Rate 40 0 14 141 100 000 35 0 55 100 000 35 0 45 673 10 000 37 0 55 10 000 37 0 50 9 909 100 000 40 35 0 55 100 000 40 3590 0 5 55 10 000 40 37 0 55 10 000 40 37 0 5 CTA Amount Displays on the Tax Provision Report x P amp L Equity Each permanent difference entry needs to be designated as a P amp L or Equity entry e Inthe data entry page for Permanent Differences there is a drop down menu to select P for P amp L and E for Equity e P entry results in a current tax provision expense offset in the payable account The result impacts the overall effective tax rate Equity E entry results in a current tax provision expense offset in the payable account as well as an equity contra expense that is offset in an equity account This does not impact the overall effective tax rate Current Non Current Entries that impact deferred tax accounts need to be designated as either current or non current
38. e sum of the columns and is effectively the ending balances converted using Ending Spot Rate and the Ending Tax Rate Example of Change in the Deferred Rate from 35 to 40 Beginning Temp Diff Bal in Local Currency 100 000 Tax Effected Temp Bal in Local Currency FX Rate Tax Effected Temp Bal in USD Rate Change Unit Deferred Balances Fed Only USD Test TaxStream Test Code Name Beginning Balance Rate Change Feurrent Activ T1000 Debt Reserve 70 000 5 000 total 70 000 5 000 Adjusted Beginning 100 000 10 000 88 000 88 000 2009 Thomson Reuters ONESOURCE Provision Remote Data Collection iTaxStream TaxStream Concepts 11 Example of Change in the FX Rate from 5000 to 4500 2009 Thomson ONESOURCE Provision Remote Data Collection iTaxStream Example of Change in the Deferred Rate from 35 to 40 and FX Rate from 4500 to 5500 a Deferred Balance Report in the Income Statement View e Currency Translation Adjustment e Deferred Balances in USD are translated from the Local Currency Balances using Beginning and Ending Spot FX Rates e USD Change in Deferred Balances Deferred Expense in USD is translated from Local Currency Activity using Weighted FX Rates e USD Deferred Expense 2009 Thomson Reuters ONESOURCE Provision Remote Data Collection iTaxStream TaxStream Concepts 13 Currency Translation Adjustment Computation Adjusts th
39. ection The name can be any text e g Full Year Provision Leave the Equiv and Next fields blank Click Add to publish the dataset In the screen shot they have N A To publish a reporting dataset select the reporting dataset and enter reporting as the Col Type Col Header displays the name of the dataset that will display in Remote Data Collection The name can be any text e g YTD Provision Leave the Equiv and Next fields blank Click Add to publish the reporting dataset 2009 Thomson Reuters ONESOURCE Provision Remote Data Collection iTaxStream Administration 29 To publish a return dataset select the dataset and enter retprov as a Col Type Enter any text for Col Header Because you have the option to activate the Return to Provision module on Remote Data Collection it is important that you complete the next steps e Equiv Select the equivalent provision dataset After the return dataset is populated to reflect the locally filed tax return TaxStream uses this equivalent provision dataset and computes the difference between the return and provision As a result of this process TaxStream generates return to provision true up adjustments e Next Select a dataset to which you would like to post return to provision true up adjustments Because you now have the option to have these adjustments posted automatically to a current year provision dataset Please refer to Chapter 2 for more details it is important that
40. epresenting income lines PTBI 1015 Allows users to designate the trial balance Hidden ubline that displays the Expense section of he Income Statement Detail The param alue must be the code to a trial balance ubline itsswitch yeprov showi nctotal PTBI 1020 Allows users to designate the trial balance Hidden ubline that displays the Expense section of he Income Statement Detail The param alue must be the code to a trial balance ubline PTBI 1025 Allows users to designate the trial balance Hidden ubline that displays the Expense section of he Income Statement Detail The param alue must be the code to a trial balance ubline 1 Allows users to show the Total Expenses Hidden calculated line A sum of the trial balance lines representing expense lines itsswitch yeprov show 1 Allows users to show the Corporate GAAP Hidden ptbitotal Pre Tax Income calculated Line A sum of he Income and Expense subtotals itsswitch yeprov show exptotal itsswitch yeprov usern Allows users to Hide H make Read Only Hidden um5 R or Editable W the Answer field for the ITSQuestionDec5 question ITSQuestionDec5 What was the US Allows users to enter any question pertaining Hidden GAAP Pre Tax o the any unit data information Note The income for year Janswer to this question will not go to any 2009 Thomson ONESOURCE Provision Remote Data Collection iTaxStream Administration Rate field Ending FX Ra
41. erred Balances and NOL Balances reports can be configured to view activity deferred only and balance sheet only adjustments separately e Goto Where to Enter Items in TaxStream to find out more about entering amounts as Activity vs Deferred Only vs Balance Sheet Only Activating Payable Posting e Payable functionality can track payments refunds and other adjustments in the taxes payable account Automatic posting of current tax expense can be activated on a dataset by dataset basis The payable report can be configured with setup items in the payable section of the Administration section e An Administrative User can add a Dataset Parameter which allows the provision to post automatically to the Payable section Current Provision Posting Fiscal Year Payable Txn Payable Code Description Cash Activity Current Tax Provision excluding Dataset Year CPROV Calculated Provision 2009 Thomson Reuters ONESOURCE Provision Remote Data Collection iTaxStream Tax Adjs with NC_ code Non Cash Activity NC_RTP Dataset Year minus 1 RTP Calculated True Up NC_RTP_YEAR_NAME Year entered after NC_RTP_ RTP Calculated True Up NC_ATR Dataset Year minus 1 ATR Audit Settlement NC_ATR_YEAR_NAME Year entered after NC_ATR_ ATR Audit Settlement All other NC_ codes Dataset Year OTHER Audit Settlement e The Federal amount is posted in the Federal Payable Entry Each State is posted in that State s Payable Entry e To return to manual entry an A
42. ging into iTaxStream 19 Change Password If an administrator has set up a forced password change in ONESOURCE TaxStream Provision Enterprise for Remote Data Collection formally iTaxStream for users on their first login Remote Data Collection users are automatically directed to the Change Password page Users can access this page anytime they would like to change their password Note Password restrictions in Remote Data Collection mandate that each password include a minimum of 6 characters and a number Corp Tax Dept Contacts ONESOURCE TAXSTREAM PROVISION Log out REUTERS 1 Change Password Unit List Change Password Password Details Old Password Change Password 2009 Thomson ONESOURCE Provision Remote Data Collection iTaxStream Data Entry The system uses a wizard like approach for the input of data Information is entered in a step by step manner to guide users through the process Next and Previous links help you navigate the system In addition a blue and white navigator displays at the left side of each page with the current work area highlighted in gray On the top of each data entry page there is Unit Dataset combination information Be sure to review this information before entering any data You can access other units by selecting a unit from the drop down menu on the left side of each page Federal National Users
43. iewer 1 Sign Off access SOS Reviewer 2 Sign Off access etc Note You must have access to a unit as a preparer to edit the data in the unit Thus a preparer is associated with a set of units in the Unit List and also the Preparer roles 2009 Thomson ONESOURCE Provision Remote Data Collection iTaxStream Administration 27 admin Administrator duser Domestic User Administrator duser userco com 416 555 1236 tuser Test User Read Write tuser userco com 416 555 1234 tuserl Test User 1 Read Only tuserl userco com 416 555 1235 luser2 Test User 2 Read Only tuser2 userco com 416 55 1237 tuser3 Read Only fuser D1 ABC Corporation DEF Capen GHI Corporation JKL Corporation German Corporation UK Corporation Japan Corporation German Holdco tuser userco com Check All Uncheck All Toggle All 100001 Publishing Datasets On the Manage Active Datasets screen of ONESOURCE TaxStream Provision Enterprise the administrator can publish one dataset or multiple datasets The Single Dataset Configuration is currently not being used Be sure to use the Multiple Dataset Configuration section to publish a dataset There are three ways to publish a dataset e yeprov Publishes a dataset or reporting dataset using standard perm temporary data entry pages e yeprovgs Publishes a dataset or reporting dataset using the separated GAAP STAT perm temporary pages i e GAAP STAT Permanent Differen
44. ion for the letter A e The Administrator can assign a name to any letter so that it appears in the drop down menu of the data entry page Atag letter can also identify imported bridged and manually entered data e The Deferred Balance report can be configured so that the activity displays in different user defined columns Records Unit State Unit records are required to enter data in a dataset e Each unit has a Unit Record when it is activated in a dataset An activated unit can also have a State Record for each state that is activated under the unit 2009 Thomson ONESOURCE Provision Remote Data Collection iTaxStream TaxStream Concepts e If there is no record the does not display in the beginning page e When a unit has a record then data can be entered and the unit displays in reports e Records roll over or copy when datasets are rolled over or copied Foreign Currency Issues Each unit is designated a currency type and exchange rate that are used to convert the unit s functional currency information to reporting currency Enter 1 for the exchange rates when the functional and reporting currency are the same currency In converting currency there are several potential issues that can occur The Pre Tax Book Income PTBI provided may be converted at different exchange rates On a unit basis the PTBI policy can be selected so that the correct exchange rate is used to convert the provision number
45. lue as one of the tags in the Tags s 1 drop down menu Adds the paramvalue as one of the tags in the Tags 1 drop down menu for ATTDs and NOLs DSTATUS SHOW WIZARD 1 hows the Manage Active Datasets page where a user Hidden publishes datasets to Remote Data Collection 2009 Thomson ONESOURCE Provision Remote Data Collection iTaxStream UserAdminCompone 61 62 63 Makes Preparer 1st Reviewer and 2nd Reviewer Hidden ntTypes iewable on the Administer Users Administration page UsersExtended hows multiple entry fields for user contact information Unit Data On the Unit Data page the following parameters can be used to open close and lock down fields Parameters highlighted in the same color must be used together Paramvalue Summary Default PTBI 1000 Allows users to designate the trial balance ubline that displays the Income section of he Income Statement Detail The param alue must be the code to a trial balance ubline PTBI 1005 Allows users to designate the trial balance Hidden ubline that displays the Income section of he Income Statement Detail The param alue must be the code to a trial balance ubline PTBI 1010 Allows users to designate the trial balance Hidden ubline that displays the Income section of he Income Statement Detail The param alue must be the code to a trial balance ubline 1 Allows users to show the Total Income Hidden calculated line A sum of the trial balance lines r
46. ns of data Sub Consolidations Sub consolidations allow units to be combined for additional views of the data e Units can be in multiple sub consolidations without impacting the integrity of the consolidated view Some uses of sub consolidations are management reporting US Domestic Tax Return Filing view State groupings and Regional reporting etc Filing Group A filing group allows the attributes of a child unit to roll up to a parent unit e In Unit Details and State Details the unit can remain a parent unit or it can be designated as a child of another parent unit As the child of a parent the child s automation selections and resulting attributes transfer to the parent e There are filing group specific reports that show the results of the relationship with other units These reports can also be viewed in Remote Data Collection formally iTaxStream by enabling a system parameter Please go to Remote Data Collection Configuration Enterprise for more details Tag Letters Tag letters allow you to designate data as originating from a specific source e Tags are often also referred to as Source Tags or Source Codes e Remote Data Collection formally iTaxStream only allows you to add or modify an adjustment with tag letters designated in ONESOURCE TaxStream Provision Enterprise by the administrator The letter A is used by the system for automation It is recommended that you not change this designat
47. ollection iTaxStream TaxStream Concepts ummy E e Corporate US GAAP Pre Tax Book Income Local Currency FX Rate 1 USD Weighted Average Save Changes Enter USD FX and Calc Local Entity Name German Corporation Entity Code 1000 Weighted Average 0 656510 Save Changes Enter Local USD and Calc FX Entity Name German Corporation Entity Code 1000 Corporate US GAAP Pre Tax Book Income Reporting Currency Corporate US GAAP Pre Tax Book Income Local Currency Save Changes 2009 Thomson ONESOURCE Provision Remote Data Collection iTaxStream Enter Local USD and FX and Enter Local USD and FX Calc Entity Name Entity Code Corporate US GAAP Pre Tax Book Income Reporting Currency Corporate US GAAP Pre Tax Book Income Local Currency Rounding German Corporation 1000 u 103 322 493 67 832 250 FX Rate 1 USD Weighted Average 0 636410 0 656510 Save Changes Change in Rate and CTA Deferred Balances Tax Rate and FX Rate Change 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 th
48. ome 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 The list of permanent differences that should be reflected in this section are those permanent differences that reside within the Data Entry accounting adjustments needed to calculate Local Taxable Income when local Statutory Pre Tax Book Income is the starting point penc The enclosed list will provide references between historical descriptions and new adjustment codes If you are unable to locate the Unit Data proper adjustment please contact the Corporate Tax Department immediately nm Add each permanent difference as follows Income Tax Rates O 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 Permanent Diffs U S GAAP STAT Permanent Diffs STAT Local TAX Select the appropriate Tag letter Proceed to the next step 005335 Perm with Leading Zero P PaL Adjustment Temporary Diffs U S GAAP STAT Temporary Diffs STAT Local TAX Net Operating Losses After Tax Temp Diffs Tax Adjustments ee we Amount ri Meals amp Entertainment P P amp L Adjustment 11 237 750 13000 Officers Life Insurance P P amp L Adjustment 21
49. ppropriate code e g Corp_Contacts for Corporate Contact List when uploading the file to attach it to the Corp Tax Dept Contacts link in Remote Data Collection formally iTaxStream 2009 Thomson Reuters ONESOURCE Provision Remote Data Collection iTaxStream Menu Configuration Depending on the type of dataset published in Remote Data Collection formally iTaxStream the menu can be configured e g menu yeprov for a regular dataset menu yeprovgs for GAAP to STAT datsets and menu retprov for return to provision datasets to show different options If you would like to modify the menu bar please contact TaxStream directly Parameters Administrators can open close and lock fields for each Remote Data Collection formally iTaxStream page using the Administration section of Remote Data Collection Parameters can be used to show hide or lock down specific fields on each page Remote Data Collection Configuration Because a large part of Remote Data Collection formally iTaxStream is user configurable the initial configuration of settings is often time consuming As a Corporate user you must configure Remote Data Collection to your specifications keeping in mind the wishes of your local users Certain parameters must be activated to make Remote Data Collection more user friendly and secure SHOW GAAPTOSTAT Shows the GAAP to STAT Report gstags1 m up the letter G as the designated GAAP to STAT Adds the
50. rco Payments CISYSIR Interco Receipts oO SYSMYTD Interco itholding Tax Deduction Check All Uncheck All Toggle All Copy from Unit p1 000 Corporation Permissions can be generated manually in the system on the Manage Permissions page in the Administration tab in ONESOURCE TaxStream Provision Enterprise or they can be imported through the CUNC tab in the import_categories spreadsheet The Imported Fields are the following Unit Code Component Type Code Component Code e g permanent code and Action G Grant D Deny For Component Type Code there are multiple selections After Tax Temporary Differences NOLTD Temporary Differences SPD State Permanent Differences SATTD State After Tax Temporary Differences ATTD After Tax Temporary Differences J Jurisdictions LTXNS Liability Transactions CPD Permanent Differences CTD Temporary Differences and CTADJ Tax Adj Note That the Liability Transactions access cannot be limited in build 5 55 2009 Thomson ONESOURCE Provision Remote Data Collection iTaxStream Administration 31 1 Unit Code Component Code Component Code Action 2 3 D1000 VA SYS ATTD C G 4 01000 NOLTD VA SYS NOLTD NC G 5 101000 TD A TD163 G 6 D1000 SPD SYSIR G 7 101000 SATTD SATTD1000 G 8 01000 ATTD1000 G 9 101000 J G D1000 LTXNS UALLOC G 01000 SYSIR G 12
51. re reported in the annual financial statements and audited by our auditors Selected entities will be reviewed by our auditors If you are selected you will be contacted If our auditors determine that they are going to audit a legal entity that you are responsible for this system will provide the necessary reports for the FAS 109 calculation If you have any questions as you prepare this tax package please contact the Corporate Tax Department Unit List The Unit List page displays the entities for which each user is responsible Each unit has been given a legal entity name and an identification number The control grid shows the status of work done on each unit Columns and rows in the control grid represent datasets and units respectively This list can be sorted by clicking the headers i e Unit Unit Code etc Each dataset can also be sorted by sign off status by clicking the header Click Begin for the unit you would like to start working on Make sure that the Unit List is complete and accurate If you would like to add or delete a unit from the list contact the appropriate person on the Corporate Tax Dept Contact page Note After you sign off no further data can be entered for this unit without permission from the Corporate Tax Department Corp Tax Dept Contacts ONESOURCE TAXSTREAM PROVISION 5 Unit List Q Previous Unit List Instructions Change Password Generally a unit represent
52. rn to provision adjustments to automatically post once the preparer signs off on the entity Alternatively administrators can add the necessary parameter so that users can click the Post RTP button In addition to the setup above users must set up tax adjustment codes for the automatic posting functionality to work properly For tax adjustments to automatically flow through to the payable use the following codes NC 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 Manage Questionnaires In the past all datasets that were published in Remote Data Collection formally iTaxStream shared one questionnaire However an administrator can now create a number of questionnaires that are dataset specific To activate this feature enable the Advanced Questionnaire parameter TaxStream TaxStream Administration Manage Questionnaires Introduction Instructions E Mail Notification Create and delete your questionnaires here Return To Provision Manage Questionnaires Manage Instructions Dataset Code Name Manage Global Provisi 1 2007 Year End Provision 0003 Local Country Tax Filing Position Edit Delete Manage Questions Manage Params 2008 Q2 Provision 90
53. s The interplay of the Weighted Average and Spot rates may require that a Currency Translation Adjustment CTA be posted to account for the difference in rates The system automatically posts the CTA as an equity adjustment to the deferred tax asset liability There is only one reporting currency conversion in the system This allows the combination of units in sub consolidated or consolidated reports in the reporting currency 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 e Entries are converted to reporting currency using appropriate foreign exchange rates e Unit level reports can display in either functional or Reporting currency by changing the currency Consolidated and Sub Consolidated level reports can display in either functional or Reporting currency only when all units have the same assigned currency code A currency translation adjustment is automatically computed based on the foreign exchange rates for the unit and displays 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 sta
54. s 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 Introduction Incomplete indicates that the Preparer has not completed data entry Prepared indicates that the Preparer has finished data entry Reviewed indicates that the Reviewer has finished their review Signed 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 Unit Legal Entity unit Code 2005 Provision 2005 Return 2006 Provision 1 8 Comoran E3000 Incomplete Incomplete Incomplete Incomplete Incomplete Incomplete GHI Corporation D3000 Incomplete Incomplete Incomplete JBECOrporeon Incomplete Incomplete German Corporation F1000 Begin Begin Begin Incomplete Incomplete Incomplete Each unit has a legal entity name and an identification number The control grid shows the status of work done on each unit After all data has been entered click the Commit button on the Sign Off page 2009 Thomson ONESOURCE Provision Remote Data Collection iTaxStream Log
55. s activities during the current and preceding years The Corporate Tax Department will utilize 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 Selected entities will be reviewed by our auditors If you are selected you will be contacted If our auditors determine that they are going to audit a legal entity that you are responsible for this system will provide the necessary reports for the FAS 109 calculation If you have any questions as you prepare this tax package please contact the Corporate Tax Department Global Attachments iTaxStream Manual Final doc iTaxStream Manual Download Journal Entries Users can upload the Journal Entry report in the Manage Global Attachments area Because this file needs to be in a specific format the TaxStream IT department will provide you with the files you need Be sure to use the appropriate code e g JE1 for Journal Entry report when uploading the file Select No in the Show in the Introduction Page field to prevent the file from becoming available to all Remote Data Collection formally iTaxStream users If you would like a customized Journal Entry file please contact TaxStream directly E Corporate Contacts You can upload a document with a list of your corporate department contacts through the Manage Global Attachments area Be sure to use the a
56. s code NC The code can be extended e g FIN 48 Naming Conventions When naming a component or a dataset in the system do not use the following characters Ampersand amp Forward slash Backward slash Greater than gt Less than Grave accent Single quote Double quotes These characters can cause problems in the system with exporting viewing and modifying data Datasets Datasets define the periods of time and type of data being captured e A blank dataset can be created or an existing dataset can be copied or rolled over to a new dataset using the Dataset functionality in ONESOURCE TaxStream Provision Enterprise the client 2009 Thomson ONESOURCE Provision Remote Data Collection iTaxStream e Datasets can be either open for editing or read only You can make a dataset read only by tagging it in the Administration section or by making it part of a sequential dataset Read only datasets allow users to review data only Users cannot edit data in read only datasets e Administrative users are responsible for creating and maintaining datasets Units Units allow data to be entered and organized Aunit can be a legal entity a cost center a department a division etc and should be the lowest level of detail available to achieve all reporting requirements e Units can be combined with other units to create multiple sub consolidations to achieve various representatio
57. te Taxes Payable ax Adjustment Yes Yes After Tax Tamponi Permanent Permanent Temporary NOL Diff Diff P amp L Diff Activity Equity Adjustment Activity Column Adjustment Column Item impacts the Item impacts the Deferred Provision Deferred Provision Yes Yes No Temporary Temporary After Tax After Tax Diff NOL Diff NOL Tengan Temporary Deferred Balance Deferred Balance Only Sheet Only Only Sheet Only Colurnn Column Current Tax Deferred Tax Ending Deferred Effective Tax Entry Column Provision Provision Balance Rate 2009 Thomson Column Column ONESOURCE Provision Remote Data Collection iTaxStream Activity EX Deferred Only PK Balance Sheet Only X Access Component Types Description Code Access Rights Level Reporting Dataset List CDS Sub Consolidation List CSC Unit List CU Preparer Remote Data Collection SO1 1st Reviewer Remote Data Collection 502 2nd Reviewer Remote Data Collection 03 Permission Component Types Description Code Permission Component Types Book Trial Balance TBBB After Tax Temporary Differences ATTD Jurisdictions J Liability Transactions LTXNS NOL Temporary Differences NOLTD Permanent Differences List CPD State After App Temporary Differences SAATD State After Tax Temporary Differences SATTD State Permanent Differences SPD State Tax Adjustments STADJ Tax Adjustments
58. te field read only R Allows users to Hide H or make the Editable Note eighted average FX Rate field read only depends on the FX R Note Depends on the FX policy of the SHOW TAXPERBS Allows users to the Hide 0 or make editable 1 the Taxes per book section he federal current and ends with Income Tax Rates In the Income Tax Rates page the following parameters can be used to open close and lock down fields Paramvalue Default currtax urrent Income Tax Rate field itsswitch yeprov R or H Allows user to hide H or Read Only R the Editable enddef Ending Deferred Tax Rate field Permanent Differences On the Permanent Difference page the following parameters can be used to open close and lock down fields 2009 Thomson ONESOURCE Provision Remote Data Collection iTaxStream Paramvalue Default ipie dE bee hidecode P1000 itsswitch yeprov t H Allows users to Hide the Permanent difference type Editable ype P amp L and Equity dropdown The default type becomes P or P amp L when this parameter is used Temporary Differences On the Temporary Differences NOL Temps After Tax After App State Temps and State After Tax Temps page the following parameters can be used to open close and lock down fields The section highlighted in purple only applies to the Temporary Differences and Local Temporary Differences pages Paramvalue Default
59. tements Reporting currency symbol options in TaxStream are US Dollar USD Euro and Japanese Yen Hyperinflationary Environment When the cumulative rate of inflation exceeds 10096 over the three year period FAS 52 requires USD to be the functional currency In TaxStream the unit s local currency should be set to USD 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 Foreign Exchange Rates Entry Format When entering foreign exchange rates on the Unit Data page the format should be the amount that one unit of Reporting Currency equals in Local Currency or Reporting Currency Local Currency For example if reporting is USD and 1 USD equals 60 of another currency the rate would be 1 666667 1 6 Types 2009 Thomson ONESOURCE Provision Remote Data Collection iTaxStream e Weighted Average Rates Blended foreign exchange rate for a period of time that is applied to Income Statement Items e Spot Rates Foreign Exchange Rate on a specific date that is applied to Balance Sheet Items Currency Translation Adjustment The difference between Weighted Average Rate and Spot Rate used when Income Statement items have an impact on Balance Sheet items Pre Tax Book Income
60. ulated Codes Domestic 6 User Component Access 52 Foreign 6 Provision to Return 20 27 36 44 49 Unit List 18 User Component Access Codes 52 Rate Change 10 Records Weighted Average Rates 7 Activate 6 Deactivate 6 Rollover 6 State 6 Unit 6 Reporting Currency 7 Reports CSC Custom Sub Consolidation 6 Current Non Current View 13 Deferred Balances 14 NOL Balances 14 Rollup 15 SC Sub Consolidation 6 Return to Accrual 20 27 36 44 49 Return to Provision 20 27 36 44 49 20 27 36 44 49 Source Code 6 Spot Rates 7 Src Code 6 Status 18 Sub Consolidations 6 Summary 15 Support 16 System Code 5 Tag Letters 6 2009 Thomson CONFIDENTIAL NOT TO BE COPIED OR DISTRIBUTED This document is confidential and proprietary It is an unpublished work protected under the Federal copyright laws 2009 Thomson Reuters 2009 Thomson
61. ure Please contact your Implementation Manager or the Support Group for further assistance Return to Provision Once users enter the return data into Remote Data Collection formally iTaxStream they have the option to have true up adjustments posted to the current year s provision dataset Automatic posting of return to provision adjustments can be triggered in one of two ways the user s sign off status or clicking the Post RTP button at the bottom of the page 2009 Thomson ONESOURCE Provision Remote Data Collection iTaxStream Administration 37 TaxStream TaxStream Administration Return To Provision Introduction Sign Off Sequence Instructions E Mail Notification Use this page to configure your Return To Provision True Up posting ROLE To Provision Please choose which sign off transitions you would like to post your Return To Provision true up upon For example If you would like to post your RTP true up when a unit is signed off from Incomplete to Prepared select the Manage Questionnaires appopriate box Manage Instructions Manage Global Attachments Incomplete gt Prepared E Prepared gt ist Level Reviewed n Manage Params ist Level Reviewed gt 2nd Level Reviewed 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 retu

User Manual - Administrator

Contents

Download Pdf Manuals

Related Search

Related Contents