Home

UTP Application User Manual

1. 23 DUI Trallesisscescccesccoccesccetestccevespescsccecccecsevaveseotsoescseseeesdeccsesecvesetcteceesssevecedecdcnesseecseoeseones ceases 24 Settings 25 Dataset UnlESelecbso room EA rri PIRE nO R REN SUI KEEP NI ES EAT WEEIRN SITE NIE RU UN di evauuneiene 25 2009 TaxStream ONESOURCE UTP App User Manual Contents 3 My TaxStream 26 NEWS sciesccdessocccstercsssccestccocpscctasswcsevcstecesensaccceseedsesstesevecsececesesdeSesedstsaestedeeesstenseseecsceresesesessens 26 Quick Linke coe ive yeduv Y EPA YR EENTEEMA NIS US Fux Var ao XV en S SAC WIU ATE oievebensanskesennsy FEE VPE AS FU NER ENS GREASE DEN i 26 Dataset Merge Approach eer ececcpee LL cbe eo ove e cope eL On Ve Opa voy ee so opea Doy e ee UNE e Op se DO er RUNE ERN 28 tel I A PEE AE E AE A EEN E E E E E A E E E E A E T 29 e Id MECTOCITELUTPIEIIDITETITEEEIMI M 29 ar ASSU CS E E E E E DTE E E T T 29 Uncertain Positions 30 Add a New Posi oso oo se ne neon enean eaae SUPCR ERE eno ge ER EENV ne NENTE SEE PEDRO EEEE EE EEA 30 NonsCash and Equity 2 veis eset o reso e obed tet eee de edle Oodd so queo eee ee Te UNE Ue nU ee Neg ee ee Pe qaos e edis ase das 34 EIulid dali ric 36 Federal and International Federal PoSition 0 ccc cccccccccssscccsssccccesesesecessssccesssscsesssscseesssccesseceecessssecesssseceesssecessseeees
2. eee e ee eene eee ee eere ene nennen eese e esee tena nane n eese eese sean 67 s Manual Approath e sedacia siia 67 2c olol got Tol n aO E ET T A S 68 Frequently Asked Questions 69 71 Index 2009 TaxStream ONESOURCE UTP App User Manual UTP App Overview 5 UTP App Overview ONESOURCE TAXSTREAM PROVISION UNCERTAIN TAX POSITIONS THomson reuTers My TaxStream Uncertain Positions Reporting Admin Center Settings Navigation Bar Welcome Home Contact Help Sian Out x App Menu Client Test 1 Unit D1000 Domestic Corporation Dataset Dataset 2009 The App Menu and Navigation Bar will be referred to throughout the User Manual Web Address amp Browsers To access TaxStream Online and the Uncertain Tax Positions Application UTP App enter the following URL address in your browser https www2 taxstreampro com corp The recommended browsers for the UTP App are Microsoft Internet Explorer 7 or Firefox 3 e We highly recommend using Mozilla Firefox If you are unable to install this browser you should download the Desktop App from the My TaxStream page of the UTP App To download the Desktop App open up the last news item on the My TaxStream page Internet Explorer 6 0 Notice and follow the instructions provided e In Internet Explorer popups may come up regarding a script on the page You should disable script debugging in Internet Explo
3. User Assignment After your Users have been created you may need to adjust their assignments to the Units and SubConsolidations they should have access to When a new user is created it is assigned to all of your units but none of your subconsolidations Units After clicking on Users make sure you have selected User gt Unit Assignment from the Manage drop down e Click on the magnifying glass for a User to open up the Unit Assignment box e Select the User s you wish to assign to the Units e To select multiple Users hold down Ctrl while selecting Users e To select all Users hold down Shift while clicking on the first and then the last User in the table e Select the units which the Users should have access to in the UTP App by holding down Ctrl while selecting the Units e o select all units hold down Shift while clicking on the first and then the last unit in the box e After you have made your selections click Save Assignments e A success message will appear User successfully assigned in a yellow box at the top of the page Subconsolidations After clicking on Users make sure you have selected User gt SubConsolidation Assignment from the Manage drop down e Click on the magnifying glass for a User to open up the SubConsolidation Assignment box e Select the User s you wish to assign to the Subconsolidations e o select multiple Users hold down Ctrl while selecting Users e o select all Users hold down Shift while clicking on the f
4. Terminology Tax Position e Income or expense item where the book treatment differs from the treatment by the taxing authorities Recognition FIN 48 Step 1 e Identification of potential tax positions that are not expected to be provided for on the return provision Once identified the tax position is subjected to the more likely than not threshold standard Positions with a greater than 50 likelihood of being sustained under audit should then move to FIN 48 s second step Measurement Measurement FIN 48 Step 2 e Once a tax position is determined to be Recognized from Step 1 then the appropriate amount is determined using a probability analysis Probability Analysis e Analysis on all non highly certain issues e g permanent or tax adjustments to quantify the amount that is expected not to be sustained if the position was lost on audit Highly Certain Tax Positions e Tax positions where the law is clear and unambiguous as to the deduction that would be sustained but where the timing of the item might have some room for interpretation Highly certain positions are considered to be 100 probable for recognition purposes Uncertain Tax Position UTP e The difference between the position taken or expected to be taken on a tax return and the potential amount that is expected to be sustained after audit or through litigation As Filed Basis e The position as it was or as it is expected to be on a tax return FIN
5. e JE Breakout e Breaks out UTP Payable and Expense into its components Tax Interest and Penalties on a Current Non Current basis Uncertain Expense View e Defaults to contracted view showing only Current and Deferred Columns adding up to the Total column The data can show additional breakout e Expanded view shows the detail behind the Current and Deferred sections e Current Year PY Increases amp Decreases and Statute adding up to Current and Deferred Totals 2009 TaxStream ONESOURCE UTP App User Manual This report will not tie back to the Uncertain Deferred Rollforward and Uncertain Payable Rollforward reports if you have Equity and or Non Cash positions This report will tie to the P L lines on the Journal Entry report e For positions tagged as Equity e Only the Interest and Penalties amounts for these positions will be seen on the Expense report e For positions tagged as Non Cash e None of the amounts for these positions will be seen on the Expense report Item Inventory Gross Benefit Option e Changing the Gross Benefit Option will not change any of the amounts on this report View e Defaults to contracted view showing only the position year jurisdiction and associated amounts for the position e Expanded view provides additional information about the position including resolution and expiration dates and MLTN response e Audit view provides additional information including Current amp Deferred Tax Benefit and
6. change cta both e Once you have made your selections click Print Import e Click on the Main Contingency Menu dropdown e Click Import e Browse for the file you wish to import click Open and then Import e f the import is successful you will see a yellow Import Status box e Click Done to return to the UTP App e f the import is not successful you will see a red Import Status and will be told where errors occurred in the file e Click View Errors to view more detail about the errors in your import file e Correct your import template and then click Re Import to import the corrected file Note Component Unit assignment is now being enforced on import Make sure you have assigned your components categories to your units in order to avoid errors on import Import Template The UTP App Import Template spreadsheet allows the user to use an Excel spreadsheet template to populate or update multiple entries in the UTP App Note A new Import Template is being used in UTP App version 4 0 Go to the My TaxStream page in the UTP App to download the new Import Template Import Spreadsheet Overview e he import will begin reading the sheets in the workbook starting on row 3 and proceeding downward and will stop once it reaches a blank cell in column A e Rows 1 amp 2 are reserved for headings and descriptions e For each row entered be sure all the corresponding columns with a header are completed to ensure the spreadsheet is imported correct
7. e Click Next when you are done Add a New Uncertain Tax Position Issue Details As Filed Current Period Resolved In Q1 v 2007 v Enter the year and period at which time the issue is expected to be res Statute of Limitations Q1 2007 Y Enter the period and year of the statute under local law Amount In Question 100 000 Enter a decrease to taxable income as a negative number Current Tax Rate Enter up to 4 decimal S Cancel Back e Step 4a For Permanent Differences and Tax Adjustments you have to make the More Likely than Not determination e Make a selection and click Next e f you choose No The Amount Expected to be Sustained AETBS will be set to zero and the probability table will not display e f you choose Yes The Probability Table screen will display Add a New Uncertain Tax Position Upon ultimate audit resolution is it more likely than not greater than 50 chance that the position will be sustained Yes 9 No O Cancel Back e Step 4b After selecting Yes the following screen will display e Clicking recalculate will populate the Amount Sustained Current column with 1 8th increments of the total Amount in Question e he incremental amounts in buckets 2 8 can be edited as needed as long as they are in descending order e Assign a percentage not to exceed 10096 cumulatively for each threshold le
8. w Year 2008 Y Year in which issue arose Jurisdiction 2 Fed Federal v Classification STAT to TAX v GAAP to STAT or STAT to TAX Equity Non cash None v Cancel e Step 3 You will be inputting the As Filed information pertaining to the Amount in Question AIQ e Choose the Resolved In Quarter amp Year from the drop down menus e he Resolved in Quarter amp Year will be used to determine whether the related Taxes Payable should be classified as Current or Non Current UTP App compares the dataset year with the resolved in year and if that is 12 months or less the Taxes Payable will be Current e You now have the option of choosing N A for the Resolved in Year Positions with a Resolved in Year of N A will display as Non Current on the Payable Report and in the Payable sections of the Journal Entry Report e Choose the Statute of Limitations Quarter amp Year from the drop down menus e You now have the option of choosing N A for the Statute of Limitations Year e Enter in the AIQ as a negative number if it was a decrease to taxable income when it was 2009 TaxStream ONESOURCE UTP App User Manual originally taken on the return provision e Depending on the Type of Issue and the Jurisdiction you have selected different Tax Rate fields will display Enter in the requested rates e The rates you enter here on the Issue Details As Filed screen will default to the Issue Details Unrecognized Position screen
9. Differences or Tax Final Adjustment Temporary Probability Reversal Analysis Scheme LL As Filed FAS 109 Data The As Filed Basis datasets should be populated with the provision information that is expected to be ultimately reported on a tax return Pre tax book income Current amp deferred tax rates Permanent differences Temporary differences After tax temporary differences Tax adjustments State information Issue Open FIN 48 Data The FIN 48 datasets should be populated with the effect of the uncertain tax positions populated in the UTP App The FIN 48 amounts are entered on an after tax basis for both Federal and State UTP amounts 2009 TaxStream ONESOURCE UTP App User Manual FIN 48 in the Provision 67 TaxStream Enterprise Provision Typically a summary approach is used when viewing your FIN 48 information in TaxStream Enterprise There are 2 different options you can use to migrate your FIN 48 information from the UTP App to TaxStream Enterprise Manual Approach In the UTP App go to the Uncertain Journal Entry report and record the following amounts from the Change column Be sure to choose the correct show option based on your treatment of interest and penalties e Federal e Payable e P L Provision for Current Income Taxes e B S Non Cash Offset e EQ Equity Offset e Deferred e P L Provision for Deferred Income Taxes e B S Non Cash Offset e EQ Equity Offset e States e Pay
10. UTP App User Manual Reporting 61 UTP Open Years amp Jurisdictions Group by e Defaults to jurisdiction also allows you to format the data to group on a year basis a unit jurisdiction basis or a unit year basis View e Defaults to contracted view showing only the jurisdiction and the year for open positions e Open positions positions which have a status of anything other than SET F NLU or EXP e Expanded view provides additional information about the position including what the position is and its ending payable A subtotal of the number of UTPs and ending payable are also given based on the group by selection FIN 48 Disclosure Statements Classification of Interest amp Penalties 4 20 e Annual Disclosure e Disclose the policy on classification of interest amp penalties relying on in FIN 48 paragraph 19 e Above or Below the Line e TaxStream Solution e Report views to view effect of classification e Below the Line All or Interest Penalties e Above the Line Above the Line or Above the Line Interest Only Tabular Payable Rollforward 21 a e Annual Disclosure e Tabular Rollforward of unrecognized tax benefits UTBs at beginning and end of period e TaxStream Solution e Tabular Payable Rollforward Report using the Gross Benefit Option Gross view e Can view Above or Below the line Effect of Issues on the Effective Tax Rate q 21 b e Annual Disclosure e Total amount of UTBs that if recognized wo
11. Users amp User Assignments T a a a a E E E E cteceeeseecncnses 12 mU ae a E 12 SEA EIT h e AAA E AE AE EASA OSEN A EEAS TAE E A E 13 aser Assignment PEE ERR ETP 14 Components and Unit Component Assignments SsacauesebesuenaseCevsevandeevestauecesaseesseeveecessveseucusencne 15 mea ueuc 15 Unit Component Assignments cccccsceccccscscccccccscscceccccsscccccccscscceccssececcececscceccccsseccesecscsccsssecs 17 Import Export Categories ccccsccccsscsceccccccscceccccssscceccccsscccccecscecceccscececcosccscescescssescesccecescsscecs 18 Datasets and Reporting Datasets eere eee eene een ne eee eterne eee esee nones essen e eese aeneo 19 Morc 19 Ibi cascade rmm 20 Documentation Manager oooee eti erasure eaux ENS EE eH ER EN NN EBENE NU a PEREEKENV AM RERSE EET PRESE E ERREREMKM ERE 20 Interest and Peralties cccccccccscssccccccccceccsceccecssccccsccscsccscesceccscsecsccsessceccscesceccecsccscsscsccsccscece 21 dL ciccaiec cscddeccesscconccccscscccticcecetcucsecsocesesuteetesceccescescusteccadsecestecuecscceusccdcscnsseesevedssrsscvesescsss 22 LEDS sivcvssescecssssoscetescessessescecessseienevesceecessusssesseseseoss ster E A E eee 23 Lapet AO cou accom da eR dla ad mela n aenea con tT eM eT E 23 ses DOL GOUS
12. all the rights of Read Only Users e Allows a user to enter modify or delete data in the system e Administration Read Write e Allows a user all the rights of a Non Administration Read Write user e Allows a user access to the Admin Center e Allows a user to assign users to units and subconsolidations e Allows a user to add change or delete categories Assign User Rights e For one user e Double click in the User Type column for the User and select the level of user rights the User should have from the drop down menu e Click Save when you are done making changes e For multiple users e Hold down Ctrl while selecting the Users you would like to assign user rights to e Double click in the User Type column for one of the Users you have selected and select the level of user rights the Users should have from the drop down menu e Click Save when you are done making changes Note To select all the Users in the table hold down Shift while clicking on the first and then the last User in the table Edit User Rights e Double click on the User Type column for the User you wish to edit and select the new level of user rights the User should have from the drop down menu e Click Save when you are done making changes Cancel Changes e After editing a User s rights you may wish to cancel the changes you have made This option is available before clicking Save e Click Cancel gt Click OK 2009 TaxStream ONESOURCE UTP App User Manual
13. are more than 13 positions in the table reloading the table sorting or reordering the columns will cause the scroll bars to appear 2009 TaxStream ONESOURCE UTP App User Manual FX Rates Beginning spot 1 200000 Ending spot 1 300000 Weighted Avg 1 250000 5 e The FX Rates for the Unit Dataset you are in are displayed to the right of your screen above the Main Contingency Menu e To edit the FX Rates mouse over the rate you wish to modify and type the new rate in e Once you have finished making your changes click the Save icon the blue disk to the right of the FX Rates e f you accidentally changed your rates and would like to revert them back to before you made changes click the green Revert Changes arrow to the right of the Save icon e his option is available before clicking the Save icon Action Menu The Action Menu allows you to manage edit multiple positions at the same time e o view information about each of the Action Menu options e Choose an option from the Select an Action dropdown e Click the arrow to the right of Go to select the Action Detail option e o perform an action e Select the positions you wish to work with in the Contingencies Table by checking the boxes next to the position Code e Choose the action from the Select an Action drop down menu e Click Go or click the arrow to the right of Go to select the Execute Action option Select an Action vg Go v Remove Mark as NLU gj Execut
14. be highlighted blue e Return to the UTP App to continue the Dataset Merge process 2009 TaxStream ONESOURCE UTP App User Manual Dataset Merge Approach Dataset Merge allows you to take data from multiple single period datasets to create a year to date dataset for disclosure purposes e The beginning and ending balances of the single period dataset must flow from period to period Datasets created using the rollover functionality i e Q1 into Q2 into Q3 etc will ensure that the ending balances from the first period will agree to the beginning balances in the next sequential period e ASequential Reporting Dataset is created and the single periods are associated with one another by sequentially adding each dataset to the reporting dataset o Setone ofthe to be merged datasets as your current dataset in order for the Dataset Merge to be successful The Dataset Merge creates the year to date dataset when it is selected in the UTP App e Click on My TaxStream on the Navigation Bar Click the Dataset Merge option under Quick Links e Adialog box will ask you to choose the reporting dataset and the period of the merged dataset You will also be able to enter the Weighted Average Rate and a name for your Merged Dataset Click Merge e Once the datasets have merged successfully set the Merged Dataset as your current dataset Merged Dataset Results e All positions entered in these single period datasets will be seen in the reports
15. build your 2009 TaxStream ONESOURCE UTP App User Manual own rate table for the position and choose the type of compounding Daily Monthly or Simple which should be used to compute interest e Put a check in the checkbox to the left of the area s you would like to calculate e After you have entered in the required information click Calculate to calculate the areas you have completed e You will be brought back to the previous data entry screen and your interest and or penalties amounts will be filled in Add a New Uncertain Tax Position Interest amp Penalties Calculator Designation Domestic International Interest Interest Calc on 30000 Compounding SIMPLE yj Start Date End Date Rate 03 15 2006 3 03 15 2007 3 8 50 03 16 2007 03 15 2000 3 1575 03 16 2008 12 31 2008 3 25 50 x01 01 72009 03 31 2009 3 3400 Add Another Rate Penalties L Penalty Rate D i oe Build a Custom Rate Table e Enter in start and end dates and enter in the applicable rate for the period you have entered Only valid rates will be accepted e Rates are available in 25 increments from 1 up to 25 e Rates are available in 50 increments from 25 up to 10096 e Click Add Another Rate to continue building the rate table over time e The start date will be one day after the end date from the previous line and can not be modified e You can enter
16. contact the TaxStream Support Group You will be asked to provide a written request that states that the user should have the right to access your data Included in the request please provide the User s Name Email Address and what level of access they should have Admin Read Write Read Only Edit a User e Double click on the field you wish to edit and make your changes e All fields are editable except the User Login field e Click Save when you are done making changes Deactivate a User e Double click in the Active column for the User you would like to deactivate e Select No from the drop down menu and click Save Note Users can not be deleted only deactivated Cancel Changes e After editing a user you may wish to cancel the changes you have made This option is available before clicking Save e Click Cancel Click OK 2009 TaxStream ONESOURCE UTP App User Manual Admin Center LE User Rights After your Users have been created you may need to change their level of access to your client in the UTP App After clicking on Users make sure you have selected User User Type Assignment from the Manage drop down User Rights e Each User can have different rights in the application depending on what activities they will be required to perform e Non Administration Read Only e Allows a user to see the data and reports for assigned units and sub consolidations e Non Administration Read Write e Allows a user
17. correct status displays for all of your positions Recalculate Interest Recalculate Interest pm SSE LISA SES a If you have imported interest start and end dates for your uncertain tax positions use this option to calculate interest for those positions This option should be used each time you import new interest dates or update interest end dates using the Action Menu Failure to do so will cause your interest amounts for these positions to be incorrect Note Since the status for positions which have been rolled over will change to CII after you recalculate interest we recommend recalculating interest before making any other modifications to your positions to ensure the correct status displays for all of your positions 2009 TaxStream ONESOURCE UTP App User Manual Uncertain Positions 47 Batch Print Schedules Batch Print Schedules x Use this option to print the Calculation Support Item Detail and Interest amp Penalties schedules for individual items You will be able to choose which of these schedules you wish to batch print for the positions you have selected The Batch Print Schedules box will come up if you choose this option Make your selections similar to the Batch Print Reports box and click Submit when done Batch Print Options x Print Options Output Type pdf EB O xls Compressed Whats This Schedule Selection Select Al Calculation Support 4 Options de
18. e Beginning balances will come from the first dataset e Beginning spot FX Rates come from the first dataset e The NCS EQ determination prior will come from the first dataset e Ending balances will come from the last dataset in which a position was active e Ending spot FX Rates come from the last dataset e The NCS EQ determination current will come from the last dataset in which a position was active e No distinction is being made as to when a position was finalized the reports will not display that a position was settled in Q2 as opposed to Q3 e All notes amp attachments added throughout the position s life will be viewable in the merged dataset e abel assignments and the positions status come from the last dataset in which a position was active e Footnotes on reports come from the last dataset Note regarding FX Rates The Weighted Average rate which is entered when the merge is done is initially applied to all units in your merged dataset After you have your merged dataset you will be able to make adjustments to your FX Rates across all your units Please refer to Admin Center FX Rates for more information on updating your FX rates across all your units Note regarding NCS EQ Determination If a position is NCS in the first dataset and EQ in the last dataset or vice versa the position s current designation will switch to the prior during the 2009 TaxStream ONESOURCE UTP App User Manual My TaxStream 29 merge
19. ew x x A E ritos taxstreampro comicorp D M ONESOURCE TAXSTREAM PROVISION Online Edition LOGIN com Password 1 THOMSON REUTERS Text Size The font on the screen can be adjusted to make the text larger or smaller To adjust the text size choose the View menu option in your web browser choose Text Size and select the size of the font that you would like to display Internet Explorer Mozilla Firefox File Edit GDE Favorites Tools Help Toolbars dr di Toolbars gt Status Bar v Status Bar bel Sidebar Quick Tabs Ctrl Q Explorer Bar gt AUP Reload Ctrl R Go To gt Stop Esc ECIENENN 0 Refresh F5 Page Style Decrease Ctri Character Encoding gt E o Normal cuo Encoding gt Larger Page Source Ctrl U Source Medium Eull Screen Fl f 7 Smaller a Smallest Vebsite Addre L Web Page Privacy Policy Full Screen Fil Category Setup Provision Side An Administrative user is able to define the codes and naming conventions for the Units Permanent amp Temporary Differences Tax Adjustments and User Defined States Jurisdictions needed for the 2009 TaxStream ONESOURCE UTP App User Manual UTP App Overview 7 UTP App Categories are also referred to as components Important Note about Categories f a category is deleted in the Provision side Perm Diff Temp Diff or Tax Adj that is in use by the UTP App i e a position with that code
20. f you are assigning components to more than one unit hold down Ctrl while selecting the Units e Select the components you wish to assign to the unit s by holding down Ctrl while selecting the components e Click Save Assignments after you have made your selections e A success message will appear Components successfully assigned in a yellow box at the top of the page e While in Assignment Mode you can switch between Permanent Differences Temporary Differences or Tax Adjustments to assign them all to your units e You can also switch to SubConsolidations in order to assign units to your Subconsolidations e Click on Assignment Mode again in order to leave assignment mode e While in Assignment Mode you can not Add Edit or Delete components View Assignments e To see what components are assigned to a unit click the Unit you are interested in e The assigned components will be highlighted in blue Unassign Components from Units e Hold down Ctrl while deselecting the components and then click Save Assignments Cancel Changes e f you accidentally added a component to a unit or accidentally removed components from a unit you can click the blue Refresh Assignment Selections icon to revert back to the original assignments This option is only available after changes have been made but before clicking Save Assignments Import Export Categories You can also use an import spreadsheet template to populate your UTP categories If you do not have an
21. to PDF or XLS option on the report Note This functionality is not available in Internet Explorer 6 0 In order to use this functionality you will need to upgrade your browser to Internet Explorer 7 0 or Mozilla Firefox 2 0 If you are unable to install one of these browsers simply use the Batch Print Reports option in the Uncertain Positions section to print out the reports to PDF or XLS or download the executable desktop application from the My TaxStream section of the UTP App Interim Reporting and FIN 48 Best practices for Interim Reporting and FIN 48 Best Practice Dataset Structure e Quarterly datasets are the recommended dataset structure for your Interim Reporting requirements This will allow for each quarter of discrete activity to be isolated e To view your entire year or year to date of FIN 48 activity use the Dataset Merge functionality Interest as part of Effective Tax Rate e f you view interest as being part of your Effective Tax Rate rather than as a Discrete Item you can use the Above the Line Interest Only show option on reports to arrive at the total Discrete impact of your FIN 48 items Enterprise Interim Tab e f you view all FIN 48 activity as Discrete you can use the Export Numbers to Enterprise feature to extract your FIN 48 data from the UTP App e Import this file into the Actual section of the Interim tab for the appropriate time period 2009 TaxStream ONESOURCE UTP App User Manual
22. up to five rows of rates e f you would like to remove a row from the rate table click the X to the right of the line you have entered e Only the last line in the rate table can be removed Above Below the Line Interest and Penalties on UTP balances can be treated as either Above the Line or Below the Line depending on the determined accounting method 2009 TaxStream ONESOURCE UTP App User Manual Uncertain Positions 41 Above the Line e he interest and penalties calculated on the UTP balances are treated as accrued interest and accrued penalties Below the Line e he interest and penalties calculated on the UTP balances are treated as an additional tax expense e f you expect to deduct the interest when it is paid you can provide for the interest net of federal or state benefit by entering the tax rates in the Fed and State Tax Rate Interest fields Underpayment amp Overpayment Rates Interest can be calculated using either the underpayment rates or the overpayment rates for Federal and Domestic States Underpayment rates are typically higher than overpayment rates Underpayment Rates Default e To calculate interest using the underpayment rates e Enter in the Interest Start and End Dates and click Calculate Overpayment Rates e Tocalculate interest using the overpayment rates e Enter in the Interest Start and End Dates put a check in the Use Overpayment box and click Calculate Interest and Penalties Calcu
23. what you are trying to achieve Filter The positions in the Contingencies Table can be filtered to view only the positions you wish to work with The filter is located at the bottom right of the Contingencies table Y y Start typing your filter here then click Create Filter Q Create Filter Create a Filter e Begin typing your filter in the box e he filter should begin with the name of the column header you wish to filter by e Available options Code Name Jurisdiction Year Classification Status Resolution Year Expiration Year and Label e As you type filter options will appear for you to choose e Equal to Not equal to Less than Greater than e Click on the filter option you want and possible values to filter on will now appear for you to choose e Click on the completed filter you want e Click Create Filter To view all available filter options without possible values e n Firefox Click in the filter box and press the down arrow or the Backspace key e In Internet Explorer Click on the dropdown menu arrow in the filter box You can then click the filter option you want from the dropdown which appears and choose the 2009 TaxStream ONESOURCE UTP App User Manual Uncertain Positions 51 value for the filter Current Filters e After you add a filter it will be added to the Current Filters dropdown e Anumber displays next to Current Filters to show how many filters are currently active Remove aFilter e Click
24. 48 Basis e The additional exposure on potentially auditable issues or the UTP that would exceed the amount provided on an As Filed Basis Financial Basis e The combination of the As Filed Basis positions and the FIN 48 positions ensuring that all issues are fully accrued for in the payable account Interest amp Penalties e Accrual for the potential exposure of interest and penalties for an Uncertain Tax Position e An accounting policy election determines whether the expense for the interest amp penalties should be treated as an interest expense or penalties expense above the line or both should be treated as income tax expense below the line 2009 TaxStream ONESOURCE UTP App User Manual Terminology 65 Hot Interest e Underpayments of over 100 000 are subjected to a hot interest rate that is 2 higher than the normal underpayment rate Overpayment e C Corporations which have refunds in excess of 10 000 are subjected to GATT refund rates The GATT refund rate applies to the portion of the refund in excess of 10 000 Change in Judgment Return to Provision Adjustment e Previously provided FIN 48 item can change in future periods Items often need to be adjusted if there is an announcement of a change in statutory rate if there is a legislation release or once the return to provision adjustments are finalized for a year Expiration of Statute e Once the Statute of Limitations on the issue expires and the positi
25. 6 2008 admin This is a reply to the previous note ES J Cancel New Post Edit Delete Documentation e Documentation added to a position can not be edited or deleted e Any changes which need to be made should be appended as a reply to a previous post View Documentation e Click the yellow note icon or choose Documentation from an item s menu to view the notes amp or attachments on a position e Posts are listed by Post Date with the most recent posts or replies at the top of the list 2009 TaxStream ONESOURCE UTP App User Manual Labels For single position assignments click the gray or blue symbol next to the Item s name The symbol next to the Item s name will be gray if no labels have been assigned to it A blue symbol indicates that the Item has labels assigned to it Mouse over the blue symbol to view the labels which have been assigned to the position Create New Label e Enter new label name next to Create New Label gt click Create e Note The preferred format for Label Names is Label_Name e Use the underscore rather than create a label which contains a space Assign Labels e Select the labels you wish to assign to the position while holding down CTRL and click Submit Label Assignment Unassign Labels e Hold down CTRL while clicking on the labels you wish to unassign and click Submit Label Assignment View Options Positions in the Contingencies Table can be viewed in multiple ways depending on
26. Excel file e he spreadsheet template will have multiple sheets each representing a category e he sheets that should be populated for the UTP App are e CU Units e CPD Permanent Differences e CTD Temporary Differences e CTA Tax Adjustments e CS States e When you are finished populating the file be sure to save it 2009 TaxStream ONESOURCE UTP App User Manual e Once you have finished populating your Import Categories spreadsheet you can import it into TaxStream Online e On the home screen Click on Provision gt Import Export Categories gt Import Categories e Import the file into the UTP App e Click on Browse e Select the converted exported file you created e Click Open amp then Submit e Check for errors in the generated error log 2009 TaxStream ONESOURCE UTP App User Manual App Menu Ti App Menu The App Menu is in the upper left corner of your screen Home Click Home You will be returned to the home screen Contact Click Contact A blue popup box will appear with the contact information for the TaxStream Support Group and the UTP Committee e f you are having trouble with the software and aren t sure how to proceed call or email the TaxStream Support Group for guidance e f you have suggestions comments constructive criticism or new feature functionality requests please feel free to email the UTP Committee We will take your feedback into account when determining the future developm
27. Gross Interest amounts for positions e Audit Detail view provides the interest start and end dates if entered for the position as well as the AIQ current amp deferred tax and apportionment rates for the issue e Offset view only displays positions which have been marked NCS or EQ and shows the related information for these positions Subtotal e Defaults to show the subtotals for each of the columns on the report Hide will remove the calculated subtotals for each of the amount columns Item Documentation The Item Documentation report only displays positions which have notes amp or attachments Show e Defaults to notes attachments showing the positions along with all of their notes and attachments e When Posted By is indented it indicates the note is a reply to a previous note e Attachments only shows the position along with a list of the position s attachments e You can click on a filename to open the attachment in the appropriate program e You can also batch print all or some of the attachments to a zip file e To batch print all of the attachments e Put a check in the select all attachments box and click Print Selected e o batch print some of the attachments e Put a check next to the attachments you wish to print and click the Print Selected e f there are duplicate attachments only 1 copy will print to the zip file e Notes only shows the position along with all of the position s notes 2009 TaxStream ONESOURCE
28. Import Categories spreadsheet template you can export one from the software e n the Admin Center click the Components tab and then Export Categories e Click OK to export your categories with assignments CUC and CUNC tabs populated e Click Cancel to export your categories without assignments e Open the generated Excel file e he spreadsheet template will have multiple sheets each representing a category e All the sheets which are exported apply to the UTP App e When you are finished populating the file be sure to save it e Once you have finished populating your Import Categories spreadsheet you can import it into the UTP App e n the Admin Center click the Components tab and then Import Categories e Browse for the file you wish to import click Open and then Import e f the import is successful you will see a yellow Import Status box e Click Done to return to the UTP App e f the import is not successful you will see a red Import Status and will be told where errors 2009 TaxStream ONESOURCE UTP App User Manual Admin Center 19 occurred in the file e Click View Errors to view more detail about the errors in your import file e Correct your import template and then click Re Import to import the corrected file e For detailed information about the columns in the spreadsheet go to the My TaxStream section in the UTP App There is a UTP App Import Categories Guide Note Users are not exported from the UTP App since users cannot be
29. Issue Details As Settled screen will appear e f you click Save without filling in any of the fields all the amounts will be marked as NLU and will display in the appropriate Change column on the reports A warning will popup if this is the case click OK to continue or Cancel to return to the workflow to make changes e Amounts which are entered in the Settlement Outlook column will display in the Settlement column row on reports when the appropriate Gross Benefit Option is chosen Mark as no longer uncertain NLU e ssue existed in a prior period however in the current period it is determined that the UTP is no longer necessary The entire amount provided in the prior period will be reversed in the Change column to bring the taxes payable to zero Write off as expired due to statute EXP e ssue existed in a prior period however in the current period it is determined that the UTP is no longer necessary since the statute of limitations has expired The entire amount provided in the prior period will be reversed in the Statute column to bring the taxes payable to zero Note After a position is marked as SET F NLU or EXP you will no longer be able to modify the position Reload Contingencies e Click on the Main Contingency Menu dropdown e Click Reload Contingencies e The contingencies table containing a list of all your uncertain positions will refresh Note f the contingencies table is displaying without scroll bars if there
30. NESOURCE UTP App User Manual EXpOrt ee ee ee 54 Reporting 56 Main REPO rts eceseovawececesvovasersecveyueteerveveyadeneiveceanetavavagvensaseavunpansaseiiauen IN MUNERE EVI SENE VM EAR CNNE RUM MU UE 56 soa MPRA AU me 57 View O potion Sisvnehcccsasntecvcsseswsencoeespuixcnccasepaawancessicpucnanchisastnannesisencpaneeissenenanvaih O GERM KNEE NR NEF REMANERE 57 spo Report SpeciNC VIEWS A 58 lt Report View Differences MC 59 Tabular Payable Rolltorwalkd ctr EEEE E A E de utra 59 UncentainJournal EO sakininin tera ed de e e este be Ed A aS 59 UricertallEXpernse xinenseeocepemepeadeanenatia ae Dodd tacit e RED DD 59 temliventont apiianga E 60 tem DocumentatigN OO a E aAA T DIEI EE 60 UTP Open Years amp JurisdicHOoLis rriari ta reed a e ege d aao ien d in ie n i cases e d dot 61 FIN 48 Disclosure Statements ee ee eee eee eee ee eee e e ete eee e tees e ote e obse ps esses aes ses eese epe esee sepes pee e see ae 0 61 Mee olol mid FOOUNOUES m 62 Printing Cee ee ee 62 Interim Reporting and FIN 48 ssssssssssscsssscesssssscessssessssssccsssssesssssccsssnsscssssssssssssessssssssonses 63 BeSt Practice Mec e 63 Terminology 64 FIN 48 in the Provision 66 TaxStream Enterprise Provision
31. ONE SOURCE UTP App User Manual THOMSON REUTERS ONESOURCE UTP App User Manual Table of Contents UTP App Overview 5 Web Address amp BFOWSOLES 5 asas ro eo aa ra es cescsci ce csces onore bens ss sichee cos ci URe Rene EEEE Secnesonssvsvesetessoves 5 I 6 IESCMIHINICELONIELCIEZLILLUIIC m 6 Category Setup Provision Side eese e eee eee eee eene e nennen eene e enne nennen enne nnns nnn 6 TaxStream Enterprise Clients ccccccccccsscssssscssssssssssssssscssssscssscssnsssssssscceccescceccescssesossessscesscens 7 axStream Onlne Clients 4 eee cie sce ece eec s oss eoeses este ee UP os dos soseese dis orae se rods so esL ia TN are do sisisi issis 7 Non TaxStream Enterprise Clients ssssssssssssssesssssssssssenssssscnsscssssssecssccsccceccesesssessessescssesses 8 Manual Emt MN Rc bstuses Enara EnaA NEE NSE EE 8 LCS MB 9 IrmportSpreadslieet aegacsatacduonm mienne V o e Hd E e e ER ro D a n e RE OT eae dg dh 9 App Menu 1 Home lt ocecessecceecdccuccescesouccsucdcocessecscssevsesocevecessesecscsceetecdoscessseseeceesosecesceces coseseeososesSeessesevesoveovesss 11 Containeren ENEN OEN EOE ENE ONEA 11 aE o e E E E A E E T 11 Sign Out sssssssessssseeesececcssseessssseccccsesseececccoeeceeeeeccesccessseeocosssssesssceeeseeeeeesesescsssseeeeesssssssessosoooe 11 Admin Center 12
32. Statute Hm 48 Individual Item Schedules esesssesssesesssosssesosososesososososesosssososososssosssosssssossosossssssssosssese 48 sec CALCULATION Support iocos e de consed odas eet ise eco ides esa ee cose eu uda e ee do eec ua des dace a a Oe dPsacolsieoe sono 48 Eug e 48 Interest and Penalties e teoee espere t uvae coe o nado eros esu ce noU noa Panne nad ink n Ungua sos oeus e esie e Essen RAN UERO 48 Doc umentatlol 3 xoc ide oa Tor saevae eseuse ut esu sue Uus aures CU Ve Ue avevo en epar uasa oou sus NoD eau vsu Veg aaRS 48 Wa GIS TREDIUM 50 View Option ssscsssosssccccccccccsssssnsnsscccccssessccsssnsssansnnnsccccccccssssssnsssssnsaasosssssssesssssnnnnnccccaeseess 50 lal ge E HA 50 M H 51 Mxicilin4 NUR HIDE 51 Reorder COLUM m 51 Batch Print Reports sssssssssssssssccssccceeccceccsoessccscccessccsssessscsssssssessssessesssssssssssseesssessssssssesssees 51 i 53 sslIMpOrt Tem plate Me 53 ES Ue 54 2009 TaxStream O
33. Stream ONESOURCE UTP App User Manual Reporting ONESOURCE TAXSTREAM PROVISION UNCERTAIN TAX POSITIONS My TaxStream Uncertain Positions Admin Center Settings Main Reports Uncertain Deferred Rollforward e Displays the Deferred Tax Asset Liability balances on an item by Item basis at the beginning and ending of the period for all the FIN 48 temporary difference items entered It can be expanded to show the various components that increased or decreased the balances during the period Deferred with Future Benefit e Displays the Deferred Tax Asset Liability balances for temporary differences along with the Benefit amounts accrued on Current Tax and Interest at the beginning and ending of the period for all the FIN 48 items entered It can be expanded to show the various components that increased or decreased the balances during the period Uncertain Payable Rollforward e Displays the Taxes Payable balances on an item by item basis at the beginning and ending of the period for all the FIN 48 items entered It can be expanded to show the various components that increased or decreased the balances during the period Tabular Payable Rollforward e Displays the 4 21 a Disclosure report required that summarizes the Uncertain Tax Benefit beginning balance additions based on tax positions related to the current year additions for tax positions of prior years reductions for tax positions of prior years settlements and the ending
34. Text to Columns to isolate the Interest amount e Select the rows the interest information is in and remove the Merge and Center option 2009 TaxStream ONESOURCE UTP App User Manual e Select the interest information e Data gt Text to Columns gt choose Delimited gt click Next gt put a check in Space gt click Finish 7 What do do if made a final modification EXP NLU or SET F on a position by mistake What do do if partially settled SET NF a position incorrectly by mistake Answer A new dataset will need to be created to fix the position s If you have already made several changes in the current dataset you can e Export out the current dataset Export UTP Items and save the file e Re roll the previous dataset to a new dataset e Make necessary modifications to the exported file change the incorrectly modified position s e Import the file into the new dataset you created 8 Which states provinces do not have their own rate tables Answer States Provinces without their own rate table are defaulted to Federal Canada Fora complete list please refer to State and International Positions Import 1 If make a change to one of the first 7 columns of data columns A through C and import it into the UTP App a new position is added Why Answer Making a change to one of the first 7 columns creates a new position because you are changing one of the defining characteristics of the position If you wish to cr
35. Washington and Wyoming e Provinces British Columbia Manitoba New Brunswick Newfoundland and Labrador Northwest Territories Nova Scotia Nunavut Prince Edward Island Saskatchewan Yukon e Put a check in the checkbox to the left of the area s you would like to calculate e Use the calendar feature to select dates to ensure dates are entered in the correct format MM DD YYYY e After you have entered in the required information click Calculate to calculate the areas you have completed e You will be brought back to the previous data entry screen and your interest and or penalties amounts will be filled in Add a New Uncertain Tax Position Interest amp Penalties Calculator Designation Domestic 9 International Interest Interest Calc on 45000 Interest Start Date 03 15 2007 4 Interest End Date 09 30 2008 3 Jurisdiction NY Use Overpayment O Hot Interest Hot Interest Date 3 Penalties Penalty Rate o Back Calculate See Custom Rate Tables for information on the International designation Custom Rate Tables Select the radio button to the right of International if you are calculating Interest and or Penalties for an International Federal jurisdiction or a Custom Jurisdiction a custom state or an international jurisdiction other than Canada The International entry fields are shown below Since these custom jurisdictions do not have a rate table in TimeValue s TaxInterest you are able to
36. able e P L Provision for Current Income Taxes e B S Non Cash Offset e EQ Equity Offset e Deferred e P L Provision for Deferred Income Taxes e B S Non Cash Offset e EQ Equity Offset In Enterprise or Online in your Provision dataset or a copy of your Provision dataset create line items for these amounts to determine the impact of your UTPs on your provision and your effective tax rate e Provision for Current Tax Amounts e Non Cash Federal Tax Adjustment NC e Non Cash State Tax Adjustment NC e Provision for Deferred Tax Amounts e Federal After Tax Temporary Difference Deferred Only Adjustment e State After Tax Temporary Difference Deferred Only Adjustment e Non Cash Offset amp Equity Offset Amounts e Federal After Tax Temporary Difference Balance Sheet Only Adjustments e State After Tax Temporary Difference Balance Sheet Only Adjustments 2009 TaxStream ONESOURCE UTP App User Manual Export Approach In the UTP App e Export Summary Categories and Numbers for the dataset you are working with The Numbers export will tie directly back to the Uncertain Journal Entry report e Import the Summary Categories into Enterprise e Import the Summary Numbers into Enterprise e The dataset you import this into depends upon your process for FIN 48 You may be using your Provision Dataset a copy of your Provision Dataset or a dataset designated specifically for your FIN 48 items e f you are using a dataset designate
37. added or edited through the import spreadsheet at this time Datasets and Reporting Datasets Click the Datasets amp Reporting Datasets tab Datasets Datasets are the way scenarios are defined in the system They can represent any period in time month quarters year to date annual etc Datasets can be copied to run multiple scenarios and rolled over from period to period Add a New Dataset e Click Add New e Enter a dataset name e Click the radio button next to No for Read Only You will be unable to add to this dataset if you select Yes e Select a fiscal year for the dataset e Select a fiscal period FY for full year Q1 for the first quarter M1 for January etc e Choose Empty as the Transaction e Click Save Edit a Dataset e Double click on the field you wish to edit and make your changes e Click Save when you are done making changes Editing of datasets which are a part of Sequential Reporting Datasets is not allowed These datasets have a lock to the left of their Dataset Name Editing of datasets which are marked as Read Only is not allowed Datasets which are marked as Read Only have a lock to the left of their Dataset Name and their Read Only RO column will say Yes Delete a Dataset e Select the dataset you would like to delete e Click Delete e Click OK if you are sure you want to permanently delete the selected dataset Cancel Changes 2009 TaxStream ONESOURCE UTP App User Manual e Aft
38. ation adjustment effected each of the events e both will display the change and cta details The selections you are viewing on each report will turn green so you can easily identify the choices which you have made Report View Differences Certain reports have view options seen only on that report These are explained below Tabular Payable Rollforward Show e When mousing over the above the line and above the line interest only blue hyperlinks e Without Interest and Penalties and Without Interest will display to offer further clarification regarding what these views do to the report View e Defaults to contract showing only one column of amounts e Expand breaks out Tax Other Tax Interest Penalties and CTA all adding up to the Total column which is the only column shown in the contract view e The CTA column will only have values if Reporting Currency is selected from the Currency drop down menu e Additional rows have been added to further break out CTA on the Tabular Payable Rollforward Uncertain Journal Entry Show e Above the Line and Above the Line Interest Only e When mousing over these blue hyperlinks e Without Interest and Penalties and Without Interest will display to offer further clarification regarding what these views do to the report e Accrued Interest and Penalties section shows interest and penalties for positions e NCS EQ Detail e Breaks out Non Cash and Equity on a Current Non Current basis
39. ault Tax Adjustments 8 Deferred Category 34 Delete Categories 15 Components 15 Dataset 19 Label 23 Label Group 23 Report Footnote 62 Desktop App 5 26 Disclosure Statements Effective Tax Rate Impact 61 Interest and Penalties Classification 61 Interest and Penalties Total 61 Issues Expected to Change 61 Open Years by Jurisdiction 61 Tabular Payable Rollforward 61 Documentation 45 Add 48 Delete 48 Edit 48 View 48 Documentation Manager 20 Domestic Positions Hot Interest 38 Interest 38 Penalties 38 Edit Categories 15 Components 15 Dataset 19 FX Rates 22 Label 23 Label Group 23 Position as New 41 Report Footnote 62 User Rights 13 Users 12 Ending Spot Rate 44 Enterprise Clients 7 Equity 34 Expiration of Statute 43 Expired due to Statute 48 Export Categories 54 FAS 109 Categories 7 FX Rates 22 Numbers 54 63 UTP App Categories 18 UTP Categories 26 UTP Items 26 54 UTP Numbers 26 m m FAQ 69 Filter Join By 50 Final Settlement 43 Footnote 62 Future Release Audit Trail 24 Documentation Manager 20 Partial Settlement 42 FX Rates 22 Beginning Spot Rate 44 Ending Spot Rate 44 Weighted Average Rate 44 2009 TaxStream ONESOURCE UTP App User Manual eI Guides Calc Functionality 29 Import Spreadsheets 29 Quick Start 29 H Help 11 Home 11 Hot Interest 37 38 amp P Calculator 36 Identify the Issue 30 Import 26 Categories Template 9 18 FX Rates 22 Process 53 Spreadshee
40. balance Uncertain Journal Entry e Displays a summary of the journal entries required to be booked for activity during the period The report is broken out by Federal and State entries Uncertain Expense Report e Displays the Current amp Deferred Tax Expense generated on an item by item basis during the period for all the FIN 48 items entered It can be expanded to show the various components that increased or decreased the balances during the period Item Inventory Report e Displays the summary of key data for the issues at the end of the period It will list the pre tax amount in question the amount expected to be sustained and all the other tax components to arrive at the ending Uncertain Tax Benefit as well as the other tax adjustments interest amp penalties 2009 TaxStream ONESOURCE UTP App User Manual Reporting 57 Item Documentation Report e Displays items along with their notes amp or attachments UTP Open Years amp Jurisdictions e Displays the 4 21 e Disclosure report required that summarizes the open positions by year by major jurisdiction When Expanded it shows the issues for the given year and jurisdiction with a count and the ending payable balance Will be available in the next release Version 4 1 Explanations Current Non Current Designation e Uncertain Payable Rollforward amp Payable Sections of Uncertain Journal Entry e Current Non Current designation is determined by comparing the Dataset Pe
41. bels 23 Users 12 Admin User 13 Amount Expected to be Sustained AETBS 30 Amount in Question AIQ 30 App Menu 5 1 As Filed 30 Assign Components to Unit 17 Labels 45 50 Labels to Label Group 23 Perm Diffs 17 Sub Consolidations 14 Tax Adjs 17 Temp Diffs 17 Units 14 User Rights 13 Assignment Mode 15 Attachments 45 File Names 48 45 48 Audit Trail 24 Batch Print 26 Reports 51 Schedules 47 Batch Print Attachments 60 Beginning Spot Rate 44 Below the Line 36 40 Browsers Internet Explorer 7 0 5 Mozilla Firefox 5 Build Custom Rate Table 38 C Calc Functionality Guide 29 Calculation Support 48 Calculations CTA 29 Currency Translation Adjustment 29 Item Inventory 29 Categories Perm Diffs 8 15 States 15 Sub Consolidations 8 15 Tax Adjs 8 15 Temp Diffs 8 15 Units 8 15 Category Setup 6 15 Enterprise Clients 7 Import 9 18 Manual Entry 8 Non Enterprise Clients 8 TaxStream Online Clients 7 Changein Interest 42 Changein Judgment 42 Clear Selected Positions 44 Component Assignment Provision 9 Components 15 Compounding Options Daily 38 Monthly 38 Simple 38 Contact 11 Index 71 2009 TaxStream ONESOURCE UTP App User Manual Copy a Dataset 20 CTA 29 57 59 Currency Translation Adjustment 29 57 59 Current 57 Current Year 57 D Dataset Merge 26 63 Datasets 19 Add 19 Copy 20 Delete 19 Edit 19 Maintenance 20 Read Only 20 Rollover 20 Set Current Dataset 25 Def
42. ce O Tax Adjustment e Step 2 You will be identifying the position you are adding 2009 TaxStream ONESOURCE UTP App User Manual Uncertain Positions 31 e Select the Code Name of the UTP you are adding from the first drop down menu e Select the Year in which the issue arose e Select the Jurisdiction the position falls into The selection you make here will also determine the information required during the work flow e f the Jurisdiction menu is not loading when you click on the dropdown click the green refresh icon to the left of the menu e Note The country of the unit you are in will determine the Federal National jurisdiction option available e i e United States Federal Canada Canada Other including Undetermined National e Select the Classification STAT to TAX or GAAP to TAX This selection will have no impact on any calculations or reports e We recommend using this as a way to create a duplicate position e Select whether the position should be marked as Non Cash Equity or None For more information on this please see the Non Cash and Equity section e f you have selected Temporary Difference as the Type of Issue you will also choose the Deferred Category C or NC the position should be in on this screen e Click Next when you have finished making your selections on this screen Add a New Uncertain Tax Position Identify The Issue Uncertain Tax Position P1000 Meals amp Entertainment
43. current Unit you are in The dataset is the first part of the position description given e Position Description Format Dataset Name Position Code Name Jurisdiction Year Interest and Penalties Click the Interest amp Penalties tab Interest e Select Interest from the Manage dropdown e he interest information for all the positions in the current Unit Dataset you are looking at will be in the Interest table e Positions with Custom Rate Tables e Positions with custom rate tables have a Calculator icon to the left of the Unit Code The start date in the table is the start date from the first row of the custom table and the end date in the table is the end date from the last row of the custom table e oview the full custom rate table for a position click the Calculator icon e A popup will appear with the full custom rate table including Compounding Option for the position Penalties e Select Penalties from the Manage dropdown e he penalty information for all the positions in the current Unit Dataset you are looking at will be in the Penalties table Export Interest amp Penalties e You can export all of the information in the Interest amp Penalties tables to Excel e Click Export Interest amp Penalties e Click OK when prompted e Your Interest and Penalties information will be on separate tabs in the same Excel workbook 2009 TaxStream ONESOURCE UTP App User Manual e Positions which have custom rate tables will have
44. d Dataset Enter in a name for your Merged Dataset Click Merge to merge datasets Remember to set the newly merged dataset as your Current Dataset JA Print 3 Close e Steps for In the Provision Administration e On the Home Page click Provision e In the Navigator click Administration gt General gt Reporting Datasets e Click Add New e Enter in a name for your Reporting Dataset and choose Sequential as the Type Id from the dropdown menu e Click Save e Click on the name of the new Reporting Dataset you just created e A list of all your datasets will appear under Assign Datasets e Put a check in the box next to the datasets you wish to add to the Reporting Dataset and click Save Assignment e Sequential reporting datasets are used to combine datasets from continuous periods e For Sequential Reporting Datasets the ending balances from the first dataset must tie exactly to the beginning balances from the subsequent dataset e Note he datasets must be added to the Sequential Reporting Dataset in the correct order or not all of the datasets will be properly added e Ex Assign Q1 Dataset Save Assignment Assign Q2 Dataset Save Assignment etc e f your datasets appear in the Assign Datasets list in the correct order Q1 Q2 Q3 Q4 you can check them all off at once and click Save Assignment e he datasets which are assigned to your Sequential Reporting Dataset will appear at the top of the Assign Datasets list and will
45. d specifically for your FIN 48 items create a Reporting Dataset containing your Provision Dataset and your FIN 48 Dataset e View your Federal amp State Tax Provision Reports the Effective Tax Report and Deferred Balances Report to see the affect of FIN 48 on your provision 2009 TaxStream ONESOURCE UTP App User Manual Frequently Asked Questions 69 Frequently Asked Questions Frequently Asked Questions about the UTP App General Usage 1 What do do if I m trying to add a new position and the Uncertain Tax Position dropdown just keeps displaying Loading Answer You have probably not assigned your categories to the unit you are in See Unit Component Assignments 2 use Internet Explorer 6 0 and tried to export a report to PDF XLS and it s not working What can do Answer This functionality is not available in Internet Explorer 6 0 We highly recommend that you use Mozilla Firefox 3 when using the UTP App Downloading the Desktop App or Internet Explorer 7 O are other viable options 3 When click Dataset Merge get the message The current dataset is not a member of any reporting datasets eligible for merging Answer There are two different reasons you may receive this error message e You may not have created a sequential reporting dataset which is required for the dataset merge This is done on the Provision side Please refer to the instructions on the bottom of the Quick Links page for more info
46. e 4 default tax adjustments e UTP I UTP Interest e UTP P UTP Penalties e UTP OT UTP Other 1 e UTP O2 UTP Other 2 If you delete any of these tax adjustments and then attempt to add a position in the UTP App manually or by import you will receive an error saying that a duplicate position already exists Assignment After you have created your components you will need to assign them to the units you have created On the home page click Provision Administration Assignment Component Unit e Select the Units you want to assign the components to by putting a check in the checkbox to the right of the unit Code e To assign all components in the system to the Unit put a check in the checkbox to the left of the Components header at the top of the list e To assign select components in the system to the Unit put a check in the checkbox to the left of the components e Click the to the left of a component section to expand and see all the categories e he components relevant for the UTP App will say FIN 48 and then the type of component e After you have made your selections scroll to the bottom of the page and click Assign Import Spreadsheet You can also use an import spreadsheet template to populate your UTP categories If you do not have an Import Categories spreadsheet template you can export one from the software e On the home page click Provision gt Import Export Categories gt Export Categories e Open the generated
47. e Action Add Notes Attachments Action Detail Assign Labels Update Interest End Dates Recalculate Interest Batch Print Schedules Expired due to Statute e You can select all the positions in the Contingencies table by clicking the Select All button at the bottom left of the table e You can deselect all the selected positions in the Contingencies table by clicking the Clear Selected button at the bottom left of the table 2009 TaxStream ONESOURCE UTP App User Manual Uncertain Positions 45 Remove Mark as NLU Remove Mark as NLU x Removing an item will permanently remove it from the system THIS OPERATION CANNOT BE UNDONE If the status of the item is not New the item will be marked as No Longer Uncertain This is a final modification Add Notes Attachments Add Notes amp Attachments x Notes and or Attachments can be added to multiple positions at the same time in this manner The Documentation box will come up if you select this option Enter in your note and add your attachments for the positions you have selected and click Save e Create Copy e f this option is not selected a single post will be created and attached to each position A reply to this post on one item will be visible on all other items e f this option is selected a new post will be created for each item Replying to a post on one item will not be added to the post on any other item e his is equivalent to adding docume
48. eate a duplicate position same code jurisdiction year please refer to Import Tips 2 Can custom interest tables be imported into the UTP App Answer The ability to import custom interest tables is now available For more information please refer to the Import Template Guide slides 14 15 which is located on the My TaxStream page of the UTP App under UTP Guides 3 Can settlements Full or Partial be imported into the UTP App Answer No The workflow must be used to enter Full and Partial Settlements Technical 1 What is the preferred browser for using the UTP App Answer We highly recommend that you use Mozilla Firefox 3 or download the Desktop App Internet Explorer 7 0 is also a viable option 2 What do need to do to get the latest version of the UTP App Answer If you use wwwe taxstreampro com corp to access the UTP App you have the latest version of the UTP App If this is not how you access the UTP App please contact your Administrator for more information on your update schedule 2009 TaxStream ONESOURCE UTP App User Manual Index A Above the Line 40 Accrued Interest 59 Penalties 59 Action Menu Info 44 Add Attachments Dataset 19 Label 23 50 Label Group 23 Notes 45 48 Position 30 Report Footnote 62 Users 12 Admin Center 12 Audit Trail 24 Component amp Unit Component Assignments 15 Datasets amp Reporting Datasets 19 Documentation Manager 20 FX Rates 22 Interest and Penalties 21 La
49. ent of the UTP App Contact Us x For technical or product related issues please call 877 829 5969 x2 or email the Support Group For general comments suggestions or feature and functionality requests please ernail us Help Click Help gt The UTP App User Manual will display for your convenience Sign Out Click Sign Out You will be signed out of the UTP App and TaxStream Online f you are idle for more than 30 minutes you will be logged out of the UTP App When you attempt to perform an action after you have been logged out a warning message will appear letting you know that you have been logged out You will be redirected to the Log In screen after clicking OK 2009 TaxStream ONESOURCE UTP App User Manual Admin Center ONESOURCE TAXSTREAM PROVISION UNCERTAIN TAX POSITIONS Admin Center The Admin Center section is where Administrator users can manage Users Datasets Components amp Assignments Documentation Interest amp Penalties FX Rates and Labels My TaxStream Uncertain Positions Reporting Settings Some areas of the Admin Center are not yet available You will see the following in these areas Re This feature is currently in development Please check back soon Users amp User Assignments Click the Users tab User Admin After clicking on Users make sure you have selected Users from the Manage drop down Add a New User e To create new users you must
50. er editing a dataset you may wish to cancel the changes you have made This option is available before clicking Save e Click Cancel gt Click OK Dataset Maintenance Datasets can be marked as read only to ensure changes aren t made they can be copied to create different scenarios and they can be rolled over to the next period Read Only Dataset Lock any datasets that are final to ensure that the data is preserved and not accidentally adjusted The data and related reports in a read only dataset can be viewed but not modified To modify the dataset remove the read only designation e Double click in the Read Only column of the dataset you wish to mark as Read Only e Put a check in the Read Only checkbox and click Save e A lock will display to the left of the Dataset Name to indicate the Dataset is Read Only Copy a Dataset e Click Add Dataset e Fill out the information for the dataset you are creating refer to Add a New Dataset for help e Select Copy as the Transaction and choose the dataset you wish to copy from the drop down menu below e Only datasets which have the same fiscal year as your new dataset will be available from the drop down menu e Click Save Rollover a Dataset e Click Add Dataset e Fill out the information for the dataset you are creating refer to Add a New Dataset for help e Select Rollover as the Transaction and choose the dataset you wish to rollover from the drop down menu below e Only datasets which are f
51. ertain 43 45 Non Cash 34 Non Current 57 Non Enterprise Clients 8 Notes 45 48 O Other Tax Adjustments 30 Overpayment Rate 41 P Paragraph 20 61 21 61 Partial Settlement 42 Penalties 21 30 36 Penalty 6651A1 37 Penalty 6661 37 Penalty Rate 38 Perm Diffs 8 15 Printing PDF 62 XLS 62 Prior Year 57 Provision Component Assignment 9 Quick Links Batch Print 26 Dataset Merge 26 Export 26 Import 26 Quick Start Guide 29 R Read Only Dataset 20 22 User 13 Read Write User 13 Recalculate Interest 46 Reload Contingencies Table 43 Remove a Position 41 45 Reoder Columns 51 Report Footnote Add 62 Delete 62 Edit 62 Report View Options Deferred Benefit 57 Detail 58 Group By 58 Label Groups 57 Show 58 View 58 Reporting 56 Reporting Datasets 19 Sequential 26 Reports Item Documentation 56 Item Inventory 56 Tabular Payable Rollforward 56 Uncertain Deferred Rollforward 56 Uncertain Expense 56 Uncertain Journal Entry 56 Uncertain Payable Rollforward 56 UTP Open Years amp Jurisdictions 56 Return to Provision 42 Rollovera Dataset 20 aC Schedules 48 Calculation Support 47 48 Interest amp Penalties 41 47 48 Item Detail 47 48 2009 TaxStream ONESOURCE UTP App User Manual Script Debugging 5 Select All Positions 44 Sequential Reporting Dataset 26 Settings 25 Dataset 25 Unit 25 Sign Out TN Sort 51 States 15 Sub Consolidations 8 15 Summary Approach 67 T Tabular Payable Roll
52. ether Equity or Non Cash is chosen e Positions marked as Non Cash will display as Non Current on the Payable and Journal Entry reports e Positions marked as None or Equity will display as Current or Non Current depending on the Resolved Quarter Year and Dataset Period Year 2009 TaxStream ONESOURCE UTP App User Manual Add a New Uncertain Tax Position Identify The Issue Uncertain Tax Position T1000 Bad Debt Reserve Year 2007 v Year in which issue arose Jurisdiction NJ New Jersey vii Classification STATto TAX v GAAP to STAT or STAT to TAX Equity Non cash Option Current Cancel Next Non Current Deferred Category Once a position has been rolled over you have the option to change the Equity Non Cash option if necessary e Positions cannot be changed from EQ to NCS or NCS to EQ e The Calculation Support Schedule and the Uncertain Journal Entry amp Uncertain Expense Reports show the reclassification of amounts Interest amp Penalties Interest and Penalties can be calculated using TimeValue s Taxlnterest software which is embedded into the UTP App Interest can now be calculated for both payments and refunds Interest and Penalties can also be calculated offline and entered into the final data entry screen shown below If you calculate interest and penalties offline the Report button on this screen will not work and you will not be able to vie
53. exists in one or more of your datasets those associated positions will be deleted from your dataset With no category to reference the data in the system has nowhere to go Please be cautious when deleting categories in the Provision side We highly recommend using the Admin Center Components in the UTP App to manage your categories TaxStream Enterprise Clients If codes established in TaxStream Enterprise for FAS 109 can be used for your UTPs they can be exported converted and imported into the UTP App Export Categories from FAS 109 To export data into a file from TaxStream Enterprise e ADMINISTRATION tab gt Export Categories e Enter a file name e Click Save Convert the exported file The export of categories from TaxStream Enterprise will include information that is not necessary for the UTP App The sheets that are used are e CU Units e CPD Permanent Differences e CTD Temporary Differences e CTA Tax Adjustments e CS States Import converted categories into the UTP App e On the home screen Click on Provision gt Import Export Categories gt Import Categories e Import the file into the UTP App e Click on Browse e Select the converted exported file you created e Click Open amp then Submit e Check for errors in the generated error log TaxStream Online Clients If you are a TaxStream Online Client for FAS 109 the permanent differences temporary differences and tax adjustments you have set up f
54. forward 57 CTA 59 Show 59 Tax Adjs 8 15 TaxStream Support Group 11 Temp Diffs 8 15 Terminology 64 Text Size 6 TimeValue TaxInterest 36 41 48 Typeoflssue 30 U Unassign Components to Unit 17 Perm Diffs 17 Tax Adjs 17 Temp Diffs 17 Uncertain Deferred Rollforward 57 Uncertain Expense 57 Equity 59 Non Cash 59 View 59 Uncertain Journal Entry 57 Accrued Interest 59 Accrued Penalties 59 JE Breakout 59 NCS EQ Detail 59 Show 59 Uncertain Payable Rollforward 57 Uncertain Positions 30 Underpayment Rate 41 Unit Component Assignments 15 17 Units 8 15 Set Current Unit 25 Update Interest End Dates 46 User Assignment Sub Consolidations 14 Units 14 User Manual 11 User Rights Admin 13 Read Only 13 Read Write 13 Users 12 Add New 12 Deactivate 12 Edit 12 UTP Committee 11 UTP Open Years amp Jurisdictions Group By 61 View 6l V View Documentation 48 Import Errors 53 View Options 50 Filter 50 Reorder Columns 51 Sort 51 W Web Address 5 Weighted Average Rate 44 Index 75 2009 TaxStream ONESOURCE UTP App User Manual 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 TaxStream All names and trademarks mentioned herein are property of their respective owners 2009 TaxStream
55. i e If the position is NCS prior and EQ current the position will come into the merged dataset as NCS prior and NCS current The UTP App does not support the movement from NCS to EQ or EQ to NCS Note If there is a subsequent change to any of the underlying datasets in the original reporting dataset then the Dataset Merge needs to be redone in order to view the effect of the change in a new Merged Dataset Guides Documentation regarding the functionality of the UTP App can be found in this area e Quick Start Guide e Initial set up of and navigation through the UTP App e Calc Functionality Guide e Examples of entering positions into the UTP App e Perm Diff Example e Temp Diff Example e State Nexus Example e Import Template Guide e Detail about the Import Template columns and how to import into the UTP App e Import Categories Guide e Detail about the Import Categories columns and how to import into the UTP App e Settlement Guide e Detail about the Full amp Partial Settlement workflows and examples Calcs Explanations of the calculations in the UTP App can be found in this area We will be adding more to this section as it becomes necessary e Item Inventory Calculations e All of the calculations on the item inventory report are listed here for the various views e Currency Translation Adjustment CTA Explanation e An explanation of the CTA calculations used in the UTP App Known Issues A list of known issues
56. ick Assignment Mode e Select the Labels you wish to add to the Label Group by holding down Ctrl while selecting the labels e Click Save Assignments after you have made your selections e A success message will appear Label Group successfully updated in a yellow box at the top of the page e Click on Assignment Mode again in order to leave assignment mode View Assignments e o see what labels are assigned to a label group click the Label Group you are interested in and click Assignment Mode e he assigned labels will be highlighted in blue Unassign Labels from Label Groups e Click on the label group that you would like to unassign labels from and click Assignment Mode e Hold down Ctrl while deselecting the labels and then click Save Assignments Cancel Changes e f you accidentally added a label to a label group or accidentally removed labels from a label group you can click the blue Refresh Assignment Selections icon to revert back to the original assignments This option is only available after changes have been made but before clicking Save Assignments Audit Trail Click Audit Trail cm This feature is currently in development Please check back soon 2009 TaxStream ONESOURCE UTP App User Manual Settings 25 Settings ONESOURCE TAXSTREAM PROVISION UNCERTAIN TAX POSITIONS My TaxStream Uncertain Positions Reporting Admin Center Dataset Unit Select Once a dataset is created for the UTP App you will need t
57. in the UTP App along with suggested alternative solutions if available and expected resolution dates if available 2009 TaxStream ONESOURCE UTP App User Manual Uncertain Positions ONESOURCE TAXSTREAM PROVISION UNCERTAIN TAX POSITIONS Uncertain Positions The Uncertain Positions section is a unit level summary of all the positions entered for that unit in the current dataset From the Contingencies Table a user can view and manage all the positions for aunit This section allows a user to enter or modify positions and add or view supporting documentation for a position My TaxStream Reporting Admin Center Settings Note The number of rows in the Contingencies Table is displayed in the lower left of the table The dropdown menu to the right of your screen in the Uncertain Positions section constitutes the Main Contingency Menu in this area Main Contingency Menu di Add Contingency 4 Preferences Reload Contingencies im Batch Print 4 Import 4 Export Add a New Position e Click on the Main Contingency Menu dropdown e Click Add New Position e he work flow to add a new position will begin e Step 1 Select the Type of Issue you are entering The selection you make here will determine the information required during the work flow Click Next after you have made your selection Add a New Uncertain Tax Position Type of Issue O Permanent Difference Temporary Differen
58. in the UTP App to calculate your interest amp or penalties Documentation Documentation Notes amp or Attachments can be added to positions in the UTP App Add Documentation e Click the gray yellow note icon or choose Documentation from an item s menu to add notes amp or 2009 TaxStream ONESOURCE UTP App User Manual Uncertain Positions 49 attachments to a position e Type your note in the note area and browse to add attachments to the position e Click Save when you are done e Adding Attachments e f you add an attachment to a position and do not enter a note a default note will be added to the position Added Attachment e Attachment file names should be unique e he UTP App does not distinguish between different files with the same name e his only applies for different files of the same type i e multiple excel files containing different information called Support for FIN 48 xls will cause the Export Attachment functionality available in the UTP App to not function properly since this functionality is based on the name of the file Reply to Posts e Click the yellow note icon or choose Documentation from an item s menu to Reply to previously created posts or create a New Post for the item Item Documentation mx 09 26 2008 admin Post 2 09 26 2008 amp admin This is a note on the 2006 Fed Position Non Cash Position E Support For FIN 48 xls Support for FIN 48 doc 09 2
59. irst and then the last User in the table e Select the subconsolidations which the Users should have access to in the UTP App by holding down Ctrl while selecting the SubConsolidations e o select all subconsolidations hold down Shift while clicking on the first and then the last unit in the box e After you have made your selections click Save Assignments e A success message will appear User successfully assigned in a yellow box at the top of the page View Assignments e o see what units subconsolidations are assigned to a User click the magnifying glass for the User you are interested in e he assigned units subconsolidations will be highlighted in blue Unassign Components from Users e Hold down Ctrl while deselecting the units subconsolidations and then click Save Assignments Cancel Changes 2009 TaxStream ONESOURCE UTP App User Manual Admin Center 15 e f you accidentally added units subconsolidations to a user or accidentally removed units subconsolidations from a user you can click the blue Refresh Assignment Selections icon to revert back to the original assignments This option is only available after changes have been made but before clicking Save Assignments Import e User assignments can be edited through an import spreadsheet Please see Import Export Categories for more information Components and Unit Component Assignments Click the Components tab Components Components are also referred to as Categories i
60. it from the final dropdown box above the corresponding symbol will display when viewing reports in the UTP App in Local Currency Sub Consolidations e Administration gt General gt Sub Consolidations gt Add New e Enter a name for the subconsolidation and click Save e Click on the subconsolidation you just added e Select the Units you wish to add to the subconsolidation by putting a check in the checkbox to the left of the Unit code e Click Save Assignment after you have made your selections To add all of the component categories click Administration gt Unit Attributes Permanent Differences e Permanent Differences Add New e Click on Permanent Differences e Enter a unique code and the name of the perm diff e Check the box if you want the permanent difference to be included in the state calculation This designation cannot be updated once the unit is populated e Click Save Temporary Differences e Temporary Differences Add New e Enter a unique code and the name of the temp diff e Check the box if you want the temporary difference to be included in the state calculation 2009 TaxStream ONESOURCE UTP App User Manual UTP App Overview 9 This designation cannot be updated once the unit is populated e Click Save Tax Adjustments e ax Adjustments Add New e Enter a unique code and the name of the tax adj e Click Save Note If you are managing your categories from the Provision side make sure you do not delete th
61. k Next when you are done 2009 TaxStream ONESOURCE UTP App User Manual Add a New Uncertain Tax Position Issue Details Unrecognized Position Current Period Amount Expected to be Sustained 62 500 Enter amount expected to pay as a positive number Current Tax Rate 35 Enter up to 4 decimal places Cancel Back EM e Step 6 You will be inputting additional information about the position e Interest amp Penalties e Interest and Penalties can be calculated offline or can be calculated using TimeValue Taxlnterest For more information please see the Interest amp Penalties section e Enter in the Fed and State Tax Rates for the interest amount to ensure that the benefit is calculated correctly if you follow a Below the Line treatment of interest and penalties e Other Tax Adjustments e ax Adjustments can be added to issues to increase or decrease the total amount to be provided For instance if the issue was providing for recognition of income and there would be an offsetting tax credit associated with recognizing that income then the credit would be entered here Add a New Uncertain Tax Position Current Period Interest 10 000 Enter amount expected to pay as a positive number Fed Tax Rate Interest 435 Enter up to 4 decimal places State Tax Rate Interest 06 Enter up to 4 decimal places Penalties D amount e pected to pay as a
62. k to the original assignments This option is only available after changes have been made but before clicking Save Assignments e Click on Assignment Mode again in order to leave assignment mode Permanent Differences e Choose Permanent Differences from the Manage drop down menu e Click Add New e Enter a unique code and the name of the perm diff e Click Save e A success message will appear Permanent Difference successfully created in a yellow box at the top of the page Temporary Differences e Choose Temporary Differences from the Manage drop down menu e Click Add New e Enter a unique code and the name of the temp diff e Click Save 2009 TaxStream ONESOURCE UTP App User Manual Admin Center 17 e A success message will appear Temporary Difference successfully created in a yellow box at the top of the page Tax Adjustments e Choose Tax Adjustments from the Manage drop down menu e Click Add New e Enter a unique code and the name of the tax adj e Click Save e A success message will appear Tax Adjustment successfully created in a yellow box at the top of the page Edit a Component e Choose the component you wish to edit from the Manage drop down menu e Double click in the field you would like to edit and make your changes e All fields are editable except the Code field for Units Permanent Differences Temporary Differences and Tax Adjustments e Units which are associated with a dataset can not have changes made to the Unit Ty
63. k to the previous data entry screen and your interest and or penalties amounts will be filled in Federal Penalties Penalty 6662 Substantial Understatement of Income Tax Penalty 6651 Failure to File Return when Due See Custom Rate Tables for information on the International designation State and International Positions State Positions Domestic or Canada and Custom Jurisdictions Domestic amp International State Positions and Custom Jurisdictions will show the following screen when you click I amp P Calculator on the final data entry screen 2009 TaxStream ONESOURCE UTP App User Manual Uncertain Positions 39 Note After you select Domestic or International and click Calculate the designation you did not pick will be grayed out Please be sure to choose the type of interest you would like to calculate for the life of the position Select the radio button to the right of Domestic if you are calculating Interest and or Penalties for a Domestic State or Canadian Province that is pre defined in the system The Domestic entry fields are shown below e f you use this screen to calculate Interest for a custom jurisdiction the rate table will default to Federal and your interest amount may not be what you expected We recommend building a custom rate table for custom jurisdictions Please see below e States Provinces without their own rate tables are defaulted to Federal Canada e States Maine Montana Nevada South Dakota
64. lation Support Schedule e his schedule will show the wrong signs for the calculated interest amount if e You choose to use the Underpayment rate and your Interest Calc On amount is negative e You choose to use the Overpayment rate and your Interest Calc On amount is positive e his occurs because in these 2 scenarios the interest amount TimeValue Taxlnterest generates is the opposite sign of what the interest amount needs to be in the UTP App Removing Interest Dates If you have entered in Interest dates for a position but would now like to remove them e Edit the position to open the position s workflow e On the amp P Calculator tab delete the Start amp End Dates and uncheck the Interest box e On the Interest and Penalties tab click Save Modify a Position New positions can be modified by choosing Edit as New or you can Remove the position if it was added incorrectly Once a position is added or rolled over from a prior period you will be able to Modify that item in one of seven ways The type of modification you choose will determine if the issue is final and should not be rolled over to the subsequent period Note Only current period amounts and dates can be modified in the work flow 2009 TaxStream ONESOURCE UTP App User Manual To Modify a position e Click on the position s Code blue hyperlink gt click Modify gt choose desired Modification option Modify p t Adjust For a change in judgement View Calc
65. lete your entire disclosure in one place Report Footnotes are dataset unit specific and do not rollover at this time If you print out a report that contains a footnote to PDF the footnote will print on the page after the report Add a Report Footnote e Click in the Report Footnote box and type your message e When you are done click Save Footnote Edit a Report Footnote e Click in the Report Footnote box and make your changes e When you are done click Save Footnote Delete a Report Footnote e Select all the text in the Report Footnote box and delete it e t should say Using O of 4 000 characters under the Report Footnote box e Click Save Footnote e Click OK when asked Are you sure you want to delete this footnote Printing On each of the Main Reports there is the ability to export the report to a PDF or XLS file To choose where to print your report to right click by the report heading e Click Export to PDF to export the current report to Adobe Click Open or OK when prompted e Click Export to XLS to export the current report to Excel Click Open or OK when prompted We highly recommend not printing any of the reports from your browser s Print menu All of the reports have been formatted to print to PDF and XLS and this formatting may not always carry over when the report is printed directly from the browser If you wish to print a report out choose the 2009 TaxStream ONESOURCE UTP App User Manual Reporting 63 Export
66. low the dotted line in the Unit Subconsolidation dropdown menu Deferred with Future Benefit report will be available in the next release Version 4 1 Report Specific Views Show Payable Expense Journal Entry partial e Defaults to all but if you want to isolate a specific component tax other tax adjustment interest penalties above the line above the line interest only interest penalties you can choose to display a single component e On the Payable and Expense reports the show options are in a dropdown menu Detail Payable Expense e Defaults to hide the detail for each line item but by clicking show it will display the breakout of tax other tax adjustments interest and penalties and deferred where applicable Group By Deferred Payable Expense Item Inventory e Defaults to none allows you to format the data to group in numerous ways Select your choice from the dropdown menu e Item Inventory defaults to a unit basis View Deferred Payable e Defaults to contracted view showing only Beginning and Ending balances The data can show additional breakout e Expand will show the activity during the period summarized by event change settlement statute expiration CTA e change will display additional details about the increases and decrease of the change column 2009 TaxStream ONESOURCE UTP App User Manual Reporting 59 e cta will display additional details about how the currency transl
67. ly e f a duplicate row is found all matching rows will fail on the import View Errors will provide you with more information regarding which position was duplicated so you can easily fix the issue e Keep in mind that the codes and other entries are case sensitive e Enter all tax rates as decimals up to 4 decimal places e Enter probability percentages as whole numbers without the 96 sign e Make sure all cells in Excel are formatted as Text e The Import Template is an Excel file with four sheets that populate the following areas of the software FIN48 Core Data about the issue FIN48 OTHER Other Data about the issue 2009 TaxStream ONESOURCE UTP App User Manual FIN48_LIKELIHOOD Probability Table for issues FIN48 CUSTOM Custom Rate Table for issues e Once your information is entered into the Spreadsheet you are ready to import the Template into the UTP App e For detailed information about the columns in the spreadsheet go to the My TaxStream page in the UTP App There is a UTP App Import Template Guide The guide includes a macro which can convert your existing spreadsheets to the new spreadsheet needed for use in Version 4 0 of the UTP App Import Tips Creating a Duplicate Position The first seven columns of each sheet of the Import Template represent the defining characteristics of a position e Dataset Year e his column does not impact any calculations or determinations of Current Non Current
68. n importing please see the Import section Export Export UTP items UTP Categories or UTP Numbers from the application For more information on exporting please see the Export section Batch Print Batch Print the main reports from the application into PDF or XLS files For more information on batch printing please see the Batch Print Reports section Dataset Merge Merge multiple datasets to create a Full Year or other time period dataset In order to create a merged dataset you will need to create a sequential reporting dataset which includes the datasets you would like to include in the merged dataset For further instructions regarding the dataset merge please click Help in the Dataset Merge window See Dataset Merge Approach for more information regarding your merged dataset 2009 TaxStream ONESOURCE UTP App User Manual My TaxStream 27 Steps for Merging Datasets x To create a merged dataset from several smaller datasets you should In the Provision Administration Create a new sequential reporting dataset Add the datasets you wish to merge to the new reporting dataset In UTP App Set one of the to be merged datasets as your Current Dataset Select Dataset Merge from the Quick Links menu in the My TaxStream section Select the reporting dataset that you created in Step 1 Select the type of dataset this will be e g Full Year 6 month etc Enter in the Weighted Average Rate for your Merge
69. n the UTP and Provision Applications Important Note about Categories If a category is deleted in the Provision side Perm Diff Temp Diff or Tax Adj that is in use by the UTP App i e a position with that code exists in one or more of your datasets those associated positions will be deleted from your dataset With no category to reference the data in the system has nowhere to go Please be cautious when deleting categories in the Provision side We highly recommend using the Admin Center Components in the UTP App to manage your categories Units e Choose Units from the Manage drop down menu e Click Add New e Enter in the Unit Code amp Name and select the Type Country amp Currency from the drop down menus e he Country and Currency drop down menus are sorted by Code e You can type in the country or currency you are looking for in the drop down box to easily find your selection e Click Save e A success message will appear Unit successfully created in a yellow box at the top of the page e f you select USD CAD EUR GBP or JPY as the currency for the unit from the final drop down box the corresponding symbol will display when viewing reports in the UTP App in Local Currency States e Choose States from the Manage drop down menu e Click Add New e Enter a unique code and the name of the custom jurisdiction e Click Save e A success message will appear State successfully created in a yellow box at the top 2009 TaxSt
70. next to the Start amp End dates Note This information can not be imported back into the UTP App in this format This export is for your records only Reload e f you add a new position or change any interest and or penalties information click Reload to refresh the table you are viewing FX Rates Click the FX Rates tab Import FX Rates e Click the Import Rates button e Browse for the file you wish to import click Open and then Submit e f the import is successful you will see a green flag e Click Done to return to the UTP App e f the import is not successful you will see a red flag and will be told where errors occurred in the file e Click View Errors to view more detail about the errors in your import file e Correct your import template and then click Submit again to import the corrected file f you attempt to import FX Rates for a dataset which is marked as Read Only you will see the red flag and the option to View Errors The error for this says Dataset is Read Only Dataset Name If this is the only error in your import click Done to return to the UTP App where you will see the other rates you imported in the FX Rates table Export FX Rates e Click the Export Rates button e his will export all the units in all datasets that have been created along with their associated FX Rates You will easily be able to make changes in the exported Excel file and re import the file to bring those changes into the UTP App e Note Do
71. nges Click Save Delete Label e Select desired label Click Delete Click OK Cancel Changes e After adding or editing a label you may wish to cancel the changes you have made This option is available before clicking Save e Click Cancel gt Click OK View Label Position Assignments e Select desired label gt Click View Assigned e he Label Position Assignment box opens to the right of the Label Manager box The box displays the selected label name and all positions which have been assigned the selected label in the current Unit Dataset you are in Label Groups After clicking on Labels make sure you have selected Label Groups from the Manage drop down Add New Label Group e Click Add Label Group gt Type in New Label Group Name gt Click Save 2009 TaxStream ONESOURCE UTP App User Manual e Note The preferred format for Label Group Names is Label_Group_Name e Use the underscore rather than create a label group which contains a space Edit Label Group e Double click on desired label group name Make changes Click Save Delete Label Group e Select desired label group gt Click Delete Label Group gt Click OK Cancel Changes e After adding or editing a label group you may wish to cancel the changes you have made This option is available before clicking Save e Click Cancel gt Click OK Assign Labels to Label Groups e Click on the label group that you would like to assign labels to and cl
72. not make any changes to the Unit Code or Dataset Name fields in each row of the Excel sheet Changes here will not update the Units and Datasets in the UTP App and will cause the import to fail for that row Edit FX Rates e Double click in the field you would like to edit and make your changes e A red comment marker will appear in the upper left corner of the field if a change has been made e Click Save when you are finished making all of your changes e All rates successfully updated message will appear at the top of the screen Read Only Datasets can not have their FX Rates edited Datasets which are marked as Read Only will have a lock to the left of the Unit column and edits will not be allowed on those rows in the FX 2009 TaxStream ONESOURCE UTP App User Manual Admin Center 23 Rates table Reload FX Rates Table e Click Reload e The FX Rates table will refresh Cancel Changes e After editing rates you may wish to erase the changes you have made This option is available before clicking Save e Click Cancel gt Click OK Labels Click the Labels tab Label Admin After clicking on Labels make sure you have selected Labels from the Manage drop down Add New Label e Click Add gt Type in New Label Name gt Click Save e Note The preferred format for Label Names is Label_Name e Use the underscore rather than create a label which contains a space Edit Label e Double click on desired label name Make cha
73. ntation to positions on an individual basis from the item s menu Assign Labels Assign Labels x Existing labels can be assigned to multiple positions at the same time in this manner To create a new label go to Admin Center Labels or click on the gray blue label icon next to a position s Name 2009 TaxStream ONESOURCE UTP App User Manual Update Interest End Dates Update Interest End Dates X Enter in the new interest calculation end date for the selected positions After you have updated the interest end date you will need to Recalculate Interest for those positions Positions with a status New will maintain their status Positions which have been rolled over will have a status CII Change in Interest The Updating Interest End Dates box will come up if you choose this option Select the new interest end date from the calendar for the positions you have selected and click Submit Updating Interest End Dates x Please enter the date you would like to use as the end date for the 2 selected positions New End Date 04 30 2008 4 Cancel Submit Note After you have updated your Interest End Dates you will need to Recalculate Interest for those positions Note Since the status for positions which have been rolled over will change to Cll after you update interest end dates we recommend updating interest end dates before making any other modifications to your positions to ensure the
74. o set it as the current dataset for it to be available to be populated with data e After clicking on Settings the box shown below will pop up in the middle of your screen Dataset Unit Select x Dataset FIN48 v Unit D1000 Domestic Corp V X Cancel Save e Select the Dataset and Unit from the drop down menus that you wish to work with e After you have made your selections click Save e he Dataset and Unit you have selected will display in the upper right hand corner underneath the Navigation Bar The Dataset Year will also display in parentheses next to the name of the Dataset Settings Client Test 1 Unit D1000 Domestic Corporation Dataset New Dataset 2009 2009 TaxStream ONESOURCE UTP App User Manual My TaxStream ONESOURCE TAXSTREAM PROVISION UNCERTAIN TAX POSITIONS MyTaxStream Uncertain Positions Reporting Admin Center Settings News This section provides you with important news and updates from TaxStream New release notes as well as any scheduled downtime for software updates will be seen here The new Import Template will also be available in this area as well as the desktop version of the UTP App for Internet Explorer 6 0 users The News section defaults to show the top 3 stories but each news item can be hidden or shown by clicking the title or the green arrow to the left of the title Quick Links Import Import your UTPs into the application For more information o
75. on is determined unavailable for audit the position no longer needs to be provided for under FIN 48 No Longer Uncertain e When it is determined that you no longer need to provide for a tax position on a FIN 48 basis since it is no longer uncertain Full Settlement e When an issue has gone through the auditing process and a settlement is reached the amount of the settlement is recorded and any remaining balances are considered no longer necessary Partial Settlement e When an issue has gone through the auditing process and a settlement is reached on a portion of a position the amount of the settlement is recorded and the remaining balance continues to be uncertain Deferred Benefit e ax and Interest benefit is viewed as being a component of Deferred Expense and Deferred Tax Assets rather than Current Expense and Current Payable CTA Currency Translation Adjustment e he interplay of the Weighted Average and Spot rates may require that a currency translation adjustment be posted to account for the difference in the rates 2009 TaxStream ONESOURCE UTP App User Manual FIN 48 in the Provision The following is an overview of how the FIN 48 Uncertain Tax Positions and the FAS 109 Tax Provision interact FIN 48 in FAS 109 Amount Expectedto As Filed be taken on Basis Retum Dataset Amount Subjected to Recognition e ecd d and Measurement Longer Reversed Dataset Uncertain Financial Basis Permanent rica
76. on the arrow to the right of Current Filters e Click on the filter you wish to remove e o remove all filters click Clear ALL Note The number of rows in the table Lower left corner updates based on your filter s Sort Any of the columns in the Contingencies Table can be sorted ascending or descending by clicking on the Column heading The column will sort ascending if the heading is clicked once and descending if the heading is clicked twice Preferences e Click on the Main Contingency Menu dropdown e Click Preferences You can highlight positions in the Contingencies Table which are expiring within the dataset year e Check the box to highlight the positions choose a color to highlight the positions in and click Save Your preferences are stored in a cookie so if you clear your browser s cookies your settings will revert to the default No highlighting Reorder Columns The order of the columns in the Contingencies Table can be changed depending on your preferences Click on the column heading for the column you wish to move and drag and drop the column to a new location along the heading bar The column you have selected will be moved to your newly selected destination Batch Print Reports e Click on the Main Contingency Menu dropdown e Click Batch Print The Batch Print Reports popup box will appear in the center of the screen 2009 TaxStream ONESOURCE UTP App User Manual Batch Print Options x Print Opti
77. ons Output Type A pdf xls Compressed Whats This Report Options Jurisdiction Federal All States VA Benefit Net of Benefit Y Currency Local v Units D2000 DEF Corp Inc v Label Y Report Selection B Select All Uncertain Deferred Rollforward Uncertain Payable Rollforward Tabular Payable Rollforward 3j Uncertain Journal Entry 3j Uncertain Expense E Item Inventory item Documentation L om e wv 3 Cancel Jet Print e Select e Print Options e The desired output PDF or XLS e f the files should be compressed e Selecting this option will generate a separate file for each report selected and return them in a compressed zip file e f not selected a single report file will be returned with each report on a separate page or pages e Report Options e Filters for the reports you will be printing same filters as when you choose to view a report in the Reporting section e Report Selection e Select the report s you wish to print e After selecting the report s you want to print click the to the left of the report name to see the available options for each report e Make your selections about each of the reports you want to print ex Payable Report options below 2009 TaxStream ONESOURCE UTP App User Manual Uncertain Positions 53 3i v uncertain Payable Rollforward show all v detail hide show group by Jurisdiction v view contracted expanded
78. or your Provision can also be used in the UTP App These categories will need to be assigned to the UTP App in order for them to appear there You can also set up new categories specific to your FIN 48 positions See the next section for the options you have for setting up your categories 2009 TaxStream ONESOURCE UTP App User Manual Non TaxStream Enterprise Clients If you are not using TaxStream Enterprise or TaxStream Online to complete your FAS 109 provision you will need to establish the codes and names for the Units Permanent and Temporary Differences Tax Adjustments and user defined States Jurisdictions This can be accomplished by manually entering the data or via a populated import spreadsheet Manual Entry Categories can now be created and assigned in the Admin Center of the UTP App Please refer to the Components and Unit Component Assignments section for further information Alternately categories can still be created and assigned in the Provision application of TaxStream Online To access the screens to manually input the categories information click on Provision on the home page Units e Administration gt General gt Units gt Add New e Enter in the required information see below and click Save D1000 Domestic Co D Domestic v US UNITED STATES USD United State of America Dollars v save Cancel Add New Delete Selected e f you select USD EUR or JPY as the currency for the un
79. pe Country or Currency e A lock will appear to the left of the Code for these units e Click Save when you are done making changes Delete a Component e Choose the component you wish to delete from the Manage drop down menu e Click on the Unit SubConsolidation Permanent Difference Temporary Difference or Tax Adjustment you would like to delete and click Delete e Permanent Differences Temporary Differences and Tax Adjustments which are in use in the UTP App can not be deleted e When you try to delete such a category an error message will appear Could not delete Component Type is associated with UTPs e Click OK if you are sure you want to permanently delete the selected component Cancel Changes e After editing a component you may wish to cancel the changes you have made This option is available before clicking Save e Click Cancel gt Click OK Unit Component Assignments After you have created your components you may need to make changes to the component unit assignments Permanent Differences Temporary Differences and Tax Adjustments which are created are automatically assigned to all of your units Assign Components to Units e Choose the component type you wish to assign to units from the Manage drop down menu e Permanent Differences Temporary Differences or Tax Adjustments e Click on Assignment Mode 2009 TaxStream ONESOURCE UTP App User Manual e Click on the unit s you wish to assign components to e
80. pected to be Sustained amount with the Amount in Question amounts and shows the change in the position for the period The Calculation Support report can be accessed from the Contingencies Table or by drilling down from the Uncertain Deferred Rollforward report the Uncertain Payable Rollforward report or the Uncertain Expense Report when those reports are displayed in Local Currency When selected the report displays in a popup box in the center of the screen Note f the popup box comes up but the report is not displaying please refresh the UTP App by clicking the Refresh or Reload icon in your browser Item Detail Item Detail shows all the entries made for each item entered in the system The report details the entry for amounts interest apportionment amp tax rates more likely than not response and other adjustments on a Prior and Current period basis The Deferred Category for temporary differences as well as whether the position is Non Cash or Equity also displays Interest and Penalties Interest amp Penalties Calculation Support displays the TaxInterest report supporting the computation of interest amp penalties that was generated using the TimeValue software in the UTP App The report can also be viewed by clicking the Report button on the final screen of the item entry manual entry process after you calculate your interest amp or penalties Note This report will only be available if you have used TimeValue Taxlnterest
81. positive number Other Tax Adjustment 1 D Other Tax Adjustment 2 0 Non Cash and Equity For Permanent Differences and Tax Adjustments the first data entry screen in the work flow will look like the following e You will have the option of marking the position as Equity Non Cash or None if neither applies from the drop down 2009 TaxStream ONESOURCE UTP App User Manual Uncertain Positions 35 e Positions marked as Non Cash will always display as Non Current on the Payable and Journal Entry reports e Positions marked as None or Equity will display as Current or Non Current depending on the Resolved Quarter Year and Dataset Period Year Add a New Uncertain Tax Position l a Identify The Issue Uncertain Tax Position P10000 Meals and Entertainment Year 2006 v Year in which issue arose Jurisdiction Fed Federal v Classification STAT to TAX v GAAP to STAT or STAT to TAX Equity Non cash Option i Cancel Next Equity Non Cash For Temporary Differences the first data entry screen in the work flow will look like the following e You will have the option of marking the position as Equity Non Cash or None if neither applies from the drop down e You also must select for all temporary differences the Deferred Category the position falls into gt Current or Non Current e This category will display on the Deferred Report regardless of wh
82. ream ONESOURCE UTP App User Manual of the page Note Many jurisdictions are in the system by default You do not need to create these jurisdictions e United States The 50 states AO All Other BS Blended State and Federal e Canada 13 Provinces AB Alberta BC British Columbia MB Manitoba NB New Brunswick NL Newfoundland and Labrador NT Northwest Territories NS Nova Scotia NU Nunavut ON Ontario PE Prince Edward Island QC Quebec SK Saskatchewan YT Yukon and Canada e Other National Sub Consolidations e Choose SubConsolidations from the Manage drop down menu e Click Add New e Enter a name for the subconsolidation and click Save e A success message will appear Subconsolidation successfully created in a yellow box at the top of the page e Click on the subconsolidation you just added and click Assignment Mode e Select the Units you wish to add to the subconsolidation by holding down Ctrl while selecting the units e Click Save Assignments after you have made your selections e A success message will appear Subconsolidation successfully updated in a yellow box at the top of the page e Unassign Units from Subconsolidation e Hold down Ctrl while deselecting the units and then click Save Assignments e Cancel Changes e f you accidentally added a unit to a subconsolidation or accidentally removed units from a subconsolidation you can click the blue Refresh Assignment Selections icon to revert bac
83. rer by going to the Tools menu and selecting Internet Options Make sure a check is in the box next to Disable script debugging Internet Explorer Internet Options General Security Privacy Content Connections Programs Settings L Always expand ALT text For images C Move system caret with Focus selection changes C Reset text size to medium For new windows and tabs v Reset text size to medium while zooming v Reset Zoom level to 100 for new windows and tabs E Browsing C Automatically check For Internet Explorer updates C Close unused Folders in History and Favorites v Disable script debugging Internet Explorer v Disable script debugging Other C Display a notification about every script error v Enable FTP Folder view outside of Internet Explorer v Enable page transitions lt Takes effect after you restart Internet Explorer Restore advanced settings Reset Internet Explorer settings Deletes all temporary files disables browser add ons and resets all the changed settings You should only use this if your browser is in an unusable state e f popups continue to appear refresh the UTP App 2009 TaxStream ONESOURCE UTP App User Manual Log In In the LOGIN dialog box enter your username and password e The username amp password are case sensitive e Click LOGIN and you will be directed to the home page of TaxStream Online
84. riod Year with the Resolved Quarter Year of the position e f the difference of these time periods is within 12 months Current e f the difference of these time periods is greater than 12 months Non Current e Non Cash Positions are always Non Current regardless of the Resolved Quarter Year e Uncertain Deferred Rollforward amp Deferred Sections of Uncertain Journal Entry e Current Non Current designation is determined by the Deferred Category selected when creating the position Current Year amp Prior Year Columns Rows e Deferred change Payable change Tabular Payable Expense expanded e Compare the Dataset Year with the Position s Year to determine if it will fall into the Current Year or one of the Prior Year columns CTA Calculations e For information regarding how CTA Currency Translation Adjustment is calculated in the UTP App please refer to the UTP App CTA Explanation Guide which is located on the My TaxStream page of the UTP App under UTP Calculations Deferred Benefit e Payable Tabular Payable UTP Open Years amp Jurisdictions e Choose Gross Benefit Option Gross View Options The filters in the Reporting section allow the user to choose how they would like to view each of the main reports If your screen resolution is making it difficult to see the entire filter menu click the second icon next to Reporting to view the filters vertically instead of horizontally After making your selections all filte
85. rmation e f you have already created a sequential reporting dataset you are receiving this message because the dataset you are in is not a member of the reporting dataset Click Settings choose a dataset which is a part of the reporting dataset and click Save 4 Some of the positions on my reports are displaying without an Item Description and can t delete them What happened Answer A user deleted one or more categories perm temp tax adj which were associated with a UTP Please contact Support to have this issue resolved Deleting categories which are in use will not be possible when using the Admin Center Components to manage your categories instead of the Provision side 5 How dol enter a Partial Settlement Answer Built in functionality for Partial Settlements is now available For how the new Settlement workflow works please refer to the UTP App Settlement Guide which is located on the My TaxStream page of the UTP App under UTP Guides The guide should be reviewed before attempting to settle positions using the workflow If a mistake is made see question 7 below 6 Where can get a breakdown of the interest calculation by year Only applicable when using TimeValue TaxlInterest to calculate interest Answer The Interest amp Penalties schedule breaks down the interest calculation by quarter You can export this schedule to Excel and modify it to achieve the breakdown you are looking for You will need to Convert
86. rom the previous fiscal period will be available from the drop down menu e Example New Dataset Fiscal Year amp Period Datasets available from drop down menu Full Year 2007 Full Year 2006 e Datasets with a fiscal period of Year to Date YTD can not be rolled over e Click Save Documentation Manager Click the Documentation Manager tab The Documentation Manager shows you the attachments you have on your positions in the UTP App for the current unit you are in across datasets This is a way to see how many items the 2009 TaxStream ONESOURCE UTP App User Manual Admin Center 21 attachment is attached to as well as how many times the same file appears in the database The Items Attached To and Actual File Count may not always be the same number because of the Create Copy option available when mass adding notes amp attachments Reload e f you ve added a new attachment and it is not displaying in the Documentation Manager click Reload to refresh the table Export Selected e You can export the attachments you have in the UTP App into a zip file by clicking Export Selected after selecting which attachments you would like to export View Document Position Assignments e Select desired attachment Click View Assigned e The Document Position Assignment box opens to the right of the Documentation Manager box The box displays the selected attachment name and all positions which have the selected attachment in the
87. rs except Label must have a selection in them click Get Report to the left of the filters or below the filters if viewing them vertically to view the report 2009 TaxStream ONESOURCE UTP App User Manual Reporting 5 Report Jurisdiction Gross Benefit Option Currency Unit Subconsolidation Label j Label Group Uncertain Payable Rollforward iv Federal All States i Net of Benefit mi Local M D2000 DEF Corporation Select one 4 Y Uncertain Deferred Rollforward Federal All States Net of Benefit Local D2000 DEF Corporation Deferred with Future Benefit Federal Only Benefit Reporting 00 Uncertain Payable Rollforward All States Only Gross Consolidated Tabular Payable Rollforward State Specific Domestic SubCon Uncertain Journal Entry Foreign SubCon Uncertain Expense Item Inventory Item Documentation UTP Open Years amp Jurisdictions Currency drop down If you select USD CAD EUR GBP or JPY as the currency for the unit the corresponding symbol will display when viewing reports in the UTP App in Local Currency Jurisdiction drop down If you choose State Specific the list of States will populate in the same drop down To return to the original drop down click the top choice in the drop down menu Non State Specific Label drop down e To reset the label selection click on the green Refresh icon in the drop down menu e Label groups are below the dotted line just as Subconsolidations are be
88. seeess 37 State and Iritermationab PoSIBOES x eines ete EORR DEOR rese E pee tere o QNO ER Ea EN aa EAE EEA ANETE 38 GUSEOMURGLG Tables MM MN a 39 AN TASONA A eE a Te PPP 40 Underpayment a Overpayment Rates 5 adc ete es a idt ace dn ia pa a P a a E HH S 4 Removing Interest Dates uuo pter Gic decr Eripe e e o rero rrr PE ap ee das 4 Modify a Position e eee e ee eee eee eee en n nnno t aano nno Pee ee etos ose etta aaa as PPP Pe e eee seat e eanO nasa aaa a o 41 Non Firal Modifications 555255 ssussxsuusuny DEP PE VPPASPA PNE VISRIBATEA EA snose REPRE VASE ETRAMPN ORAN P RNV onoo ooon EYES 42 Final Lenitulg mee 43 Reload Contingencles ener ene oe e enne n prata Y uM PEE PENA NEN n eS VUE NUS Ea SER Y NE NER En INNER EUR SEE UN EEUU REM E VE GEE 43 i2 4I a E E E A AE E LLL 44 Action Mao RT E 44 mU CO Ju eium E OM 45 Add Notes Attachiment c e m 45 ES CUOI men 45 Update Interest End cw e 46 Recalculate Interest iieiiscccsssacelsccessicccccusssceucsnsssdeedbsesseucccusevacosessasscceessosseucons scuncueseceuccoussseedsedesesees 46 Batch Print Schedules 4 erre tet cesi ooo oo eek ee LaT EN LESE eU eese dba weak se Ue ios oe ege deg dado Exe vo destesweseseasens 47 Expired Cue to
89. status in the UTP App You can use this column to create duplicate positions blue lines in below screenshot e Classification e his column does not impact any calculations in the UTP App You can use this column to create duplicate positions purple lines in below screenshot 2 amp 4 5 B 7 8 9 M o4 MN FIN48 FIN48_LIKELIHOOD FIN4S_OTHER FIN48_CUSTOM i ia Export xil e Click on the Main Contingency Menu dropdown e Click Export e Click Export UTP Items e This will export all the UTP items in the dataset for which the current user has access to i e Only items in units assigned to the user will export e he items will export in the Import Template format e When you need to update several different positions using this feature is a helpful and manageable way to accomplish this e Once you have made your changes you will need to re import the spreadsheet into the UTP App 2009 TaxStream ONESOURCE UTP App User Manual Uncertain Positions 55 e Click Summary under Export Categories to Enterprise e This will export the categories needed in Enterprise for the Summary Numbers export This categories export is not dataset or unit specific e Click Summary under Export Numbers to Enterprise e This will export the after tax amp after benefit amounts you will need to represent FIN 48 in your Provision Amounts are exported for all active units in the current dataset you are in 2009 Tax
90. sue screen e he Issue Details As Settled screen will appear e f you click Save without filling in any of the fields all the amounts will be marked as NLU and will display in the appropriate Change column on the reports A warning will popup if this is the case click OK to continue or Cancel to return to the workflow to make changes e Amounts which are entered in the Settlement Outlook column will display in the Settlement column row on reports when the appropriate Gross Benefit Option is chosen e Amounts which are entered in the Remaining Balance column will display in the Ending 2009 TaxStream ONESOURCE UTP App User Manual Uncertain Positions 43 Balance column row on reports when the appropriate Gross Benefit Option is chosen e Rollover of Partial SET Positions e Once the position is rolled over the workflow will be as populated as possible based on last known values and the applicable amounts from the Remaining Balance column Final Modifications Positions which are modified in a final way will not be rolled over to the subsequent period s dataset Enter a settlement Full SET F e An agreement has been reached on the issue and a settlement has been reached e Select Enter a Settlement from the Modify menu and then click Final when prompted e Awarning message will come up informing you that positions modified in this way can not be modified again e Click OK to continue e Click Next on the Identify the Issue screen e he
91. t Guide 29 Template 53 UTP App Categories 7 9 18 Interest 21 30 36 38 Hot Interest 37 Recalculate 46 Update End Dates 46 Interest and Penalties 21 Above the Line 40 Below the Line 40 Custom Jurisdiction Positions 38 Federal Domestic Positions 37 Foreign Positions 38 Remove Interest Dates 41 Report 36 41 48 State Domestic Positions 38 Interim Reporting Best Practice 63 International Build Custom Rate Table 38 Compounding Options 38 Interest 38 Penalties 38 Item Detail 48 Item Documentation Batch Print Attachments 60 Show 60 Item Inventory Calculations 29 Item Inventory Report Subtotal 60 View 60 K Known Issues 29 li Label Groups AddNew 23 Assign Labels 23 Delete 23 Edit 23 Label Groups 23 View Assignments 23 Labels 23 AddNew 23 Assign to Positions 45 50 Create New Label 50 Delete 23 Edit 23 Format 23 50 Unassign from Positions 50 View Label Position Assignments 23 Login 6 Log Out 11 M Main Menu 30 Mass Modifications Expired due to Statute 48 Mark as No Longer Uncertain 45 Remove Positions 45 Modify a Position Change in Interest 42 Change in Judgment 42 Editas New 41 Expiration of Statute 43 Final Settlement 43 No Longer Uncertain 43 Index 73 2009 TaxStream ONESOURCE UTP App User Manual Modify a Position Partial Settlement 42 Remove 41 Return to Provision 42 My TaxStream 26 N Navigation Bar 5 New Dataset 19 Position 30 Users 12 News 26 No Longer Unc
92. tail hide ex JE Breakout Item Detail Interest amp Penalties X Cancel The naming convention for the Item Schedules when batch printed using the Compressed option is as follows e Report Name UTP Code Year Issue Arose Jurisdiction Random Number e Example CalcSupport TIOOO 2001 MA 100916 e he random number is included to ensure no two item schedules are identical When the Item Schedules are batch printed to Excel and the Compressed option is not selected the report names are shortened but the rest of the naming convention from above is the same e P Interest amp Penalties Schedule e DT Item Detail Schedule e CT Calculation Support Schedule If you choose to batch print the Item Schedules for a large number of positions to Excel and the Compressed option is not selected the batch printing will automatically switch to Compressed No more than 50 tabs will be put into 1 Excel workbook 2009 TaxStream ONESOURCE UTP App User Manual Expired due to Statute Expired Due to Statute x Only items with a status not equal to New can be modified in this way This is a final modification Individual Item Schedules Schedules for individual positions can be seen by clicking on the Item s code and choosing which of the three schedules you wish to view Calculation Support The Calculation Support report displays the components of the calculation to support the UTP in Local Currency The report compares the Ex
93. ulation Support Adjust For a change in interest View Item Detail Adjust For return to provision View Interest and Penalties Enter a settlement Mark as no longer uncertain Write off as expired due to statute View Annotations Non Final Modifications Positions which are modified in a non final way will be rolled over to the subsequent period s dataset Adjust for a change in judgment CIJ e ssue existed in a prior period but in the current period the outlook for the amount or the rate differs from the prior period or there is an update to penalties Adjust for a change in interest CII e Update to an existing position for a change in accrued interest Adjust for return to provision RTP e ssue existed in a prior period but the amount differs from the prior period because of the impact of a true up item or there is an update to interest or penalties Enter a Settlement Partial SET NF e Partial settlements allow for a portion of a position to be settled while the remaining balance continues to be uncertain e Select Enter a Settlement from the Modify menu and then click Non Final when prompted e A warning message will come up informing you that positions modified in this way can not be modified again in the current dataset e This position can be rolled over to a subsequent period s dataset and you will be able to modify the position in that dataset e Click OK to continue e Click Next on the Identify the Is
94. uld affect the effective tax rate e axStream Solution e Uncertain Journal Entry Report Change column for the Current and Deferred Provision OR Uncertain Expense Report Total Impact to ETR column e Export these amounts to FAS 109 to view effect on the overall Effective Tax Rate Interest amp Penalties 4 21 c e Annual Disclosure e otal amount of interest and penalties recognized in the income statement and balance sheet e axStream Solution e Uncertain Payable Report using the Show interest penalties view Issues expected to significantly change in 12 months 4 21 d 2009 TaxStream ONESOURCE UTP App User Manual e Annual Disclosure e Positions where it is reasonably possible that the total amounts of the UTBs will significantly increase or decrease within 1 year of reporting date f 21 d e axStream Solution e Contingencies Table with additional analysis by user to determine nature of uncertainty nature of events that would cause a change and estimate of range of change e Can label items 21d and filter on them in Contingencies Table or Main Reports to view total impact Years with issues remaining open by Jurisdiction 4 21 e e Annual Disclosure e Description of tax years that remain subject to examination by major jurisdiction e axStream Solution e UTP Open Years and Jurisdiction Report Report Footnotes Seven of the main reports now contain a Report Footnote section in order to allow you to comp
95. vel of the Amount 2009 TaxStream ONESOURCE UTP App User Manual Uncertain Positions 33 Sustained Current e When the cumulative probability is 51 or greater the corresponding amount in the Amount Sustained Current column will be the AETBS e Click Next when your cumulative probability equals 100 Add a New Uncertain Tax Position Cumulative Probability must total 100 Amount f Sustained Probability Cumulative 1 Current Current Probability recalculate 1 100 000 0 095 2 50 2020 3 75 000 25 45 4 52500 10 55 5 50000 45 100 6 Q750 0 100 7 25 000 D 10096 8 12 500 0 100 9 0 10096 Cancel Back next e Step 5 You will be inputting the information for the Amount Expected to be Sustained e For Permanent Differences and Tax Adjustments the AETBS will be populated by what you entered in the Probability Table You will not be able to edit this amount on this screen If you want to make a change to the AETBS click the Back button to return to the Probability Table e For Temporary Differences the AETBS will need to be entered into this field e Depending on the Type of Issue and the Jurisdiction you have selected different Tax Rate fields will display Enter in the requested rates e These rate fields will be filled in with the rates you entered on the Issue Details As Filed screen They are editable fields e Clic
96. w the Interest amp Penalties schedule for individual items e Click amp P Calculator to use TimeValue Taxlnterest to calculate your interest and or penalties 2009 TaxStream ONESOURCE UTP App User Manual Uncertain Positions 37 Add a New Uncertain Tax Position Current Period Interest D Enter amount exp ed to y as a positive number Fed Tax Rate Interest 0 cnter I imal place State Tax Rate Interest 0 ter up to 4 imal p Penalties 0 Enter Iou exp ed t S a positive number Other Tax Adjustment 1 0 Other Tax Adjustment 2 Cancel Back I amp P Calculator Report EN e After you calculate your interest and or penalties you will be returned to this screen e Remember to enter in rates for interest to ensure the benefit is correctly calculated if you follow a Below the Line treatment of interest Notes regarding Hot Interest e Hot Interest can not be computed on refunds e f you are using the Overpayment rate Hot Interest will not be calculated if you enter in a date e When mousing over Hot Interest on the I amp P Calculator screen e For Large Corporate Underpayments will display to offer further clarification regarding what this can be used for Note regarding Penalties e Penalties can not be computed on refunds Federal and International Federal Positions Federal Positions Domestic amp International e Federal Positions will show the follo
97. wing screen when you click I amp P Calculator on the final data entry screen Note After you select Federal or International and click Calculate the designation you did not pick will be grayed out Please be sure to choose the type of interest you would like to calculate for the life of the position 2009 TaxStream ONESOURCE UTP App User Manual Add a New Uncertain Tax Position Interest amp Penalties Calculator Designation Federal 9 International O Interest V Interest Calc on 87500 Interest Start Date 03 15 2007 3 Interest End Date 03 31 2009 4 Jurisdiction Fed i i l Use Overpayment a Hot Interest Hot Interest Date 3 Penalty 6662 Amount Subject to penalty Date return Due 3 Penalty 6651 Amount Subject to penalty Date return Due 3 Date Received 3 Back Calculate Select the radio button to the right of Federal if you are calculating Interest and or Penalties for the Domestic Federal jurisdiction or Canadian jurisdiction that is pre defined in the system The Federal entry fields are shown above e Put a check in the checkbox to the left of the area s you would like to calculate e Use the calendar feature to select dates to ensure dates are entered in the correct format MM DD YYYY e After you have entered in the required information click Calculate to calculate the areas you have completed e You will be brought bac

UTP Application User Manual

Contents

Download Pdf Manuals

Related Search

Related Contents