Enterprise Release Notes
Contents
1. CLT alae TT T _ ONESOURCE TAXSTREAM PROVISION 6 0 Enterprise Release Notes RELEASE NOTES NEW FEATURES KNOWN ISSUES RELEASE DATE 9 21 2009 ONESOURCE THOMSONREUTERS COM i THOMSON REUTERS ges Enterprise Release Notes Release Overview The following items were addressed in this release General e User Manual Interactive Enterprise User Manual is now embedded in Help tab e ONESOURCE ntegration e For users in our Citrix Environment Single Sign On with the ONESOURCE platform is being rolled out during late Q3 Q4 of 2009 Functionality e Active Workpapers e User defined dynamic spreadsheets which are embedded and linked inside of a dataset Please refer to Active Workpapers for more information e Return to Provision RTP True Up Posting e Ability to post RTP adjustments for datasets that have been related via the Dataset Relations functionality Please refer to Dataset Relations for more information e Dataset Relations Ability to establish the datasets that should be associated to allow for RTP True Up Posting e Payable Reclass Posting e Ability to migrate auto generated payable transactions for a specific unit to another parent unit To enable the payable reclass functionality the system parameter SHOW_PAYABLERECLASS with a paramvalue of 1 must be setup To reclass the auto generated payable transactions to another parent unit the unit level parameter PAYRECUNIT must be created2. Rates screen that will allow the user to activate the states necessary for the dataset The rates can be overridden Unit by Unit basis at the State level if needed e Bridge e Changed Book Balance to Book Trial Balances e Users are restricted to only bridge data to units where the user has been given access Corrected Issue e Dataset Rollover Scrunch Balances Option e Temporary Differences can now be scrunched together on Dataset Rollover e Ending temporary difference balances in a dataset for a unit that has the same code amp C NC status but has multiple lines with different tags will rollover to create a single beginning balance with a tag designated by the dataset parameter SCRUNCH_TAG with a paramvalue of the tag letter e Any balances with overridden deferred tax rates will be excluded from the scrunch process and will retain their original tag e This functionality was formerly available as an external macro e Autolink e Autolink will only allow data to be posted to a dataset that is not marked as read only Corrected Issue e Unknown Weighted Average FX e When the PTBI policy is Enter Local USD Calc and the Local or the Reporting is zero the system returns Unknown as the Weighted Average FX The PTBI and other local amounts perms temps etc will display as zeroes in reports in Reporting Currency and the user will be warned of the condition with the following error message Unit s includ
3. for every unit where the payable is to be re classed with a paramvalue of the parent unit code The balances can be created for as many units as it is appropriate for The system parameter will add a Recalc Payable Reclasses button under the Data Review DataSet area in the Navigator Activate the transfer by clicking this button which will create the reversing entry and reclass posting entry with the Transaction Type of xxx REC and a Tag of e Restrict Read Write Users e Read Write users can be restricted on Data Entry Modification of Tax Adjustments or specified tags e Dataset parameter for Tax Adjustments RestrictTA with paramvalue of the beginning of the code which should not be modifiable e Dataset parameter for Tags Restrictlag_ where represents the specified tag with a paramvalue of the specified tag For example Restrictlag_B with paramvalue of B would make any data entry with the B tag a read only field for a Read Write user e mport Export Numbers amp Categories e Optimized the functionality to significantly speed up the time required to import and export data e Temporary Diffs and State After Apportionment Temp Diffs No longer need to override all rates in order to import successfully Can now import U for rates Corrected Issue The import for STD FSAATD and 5 no longer require every amount column to be filled out to import properly Corrected Issue Enterprise Release Notes e A
4. 0 CY and BBAL would post with a data of 10 1 PY Corrected Issue e NOL Automation for Specific Codes e When NOL Automation is activated and the unit has taxable income the system no longer incorrectly considers Deferred Only amounts entered for NOL Temp Diffs or State After Apportionment Temp Diffs with the codes beginning NOL_ or S_NOL_ as having impact on Current Tax Expense Corrected Issue e Trial Balance TBBS e All trial balance data for a unit is deleted when a unit is deactivated Corrected Issue e GlobalRegion parameter e When the GlobalRegion system parameter is enabled and set to EUROPE the valuation automation now properly works and the Questionnaire Summary report displays Corrected Issue e State Temp Diffs State After App Temp Diffs amp State After Tax Temp Diffs e Now able to change the C NC designation for these types of Temps Corrected Issue Reporting e Currency Translation Adjustment CTA e Added the ability to enter a CTA adjustment as well as the option to treat the CTA as either having an impact on Equity or P amp L e Please refer to New CTA Functionality for more information e Plug In Reports e Plug In Report functionality allows users to design custom reports that can be uploaded into their current instance without requiring a new build of the software each time a new report is added Additionally as users upgrade to new versions they will be able to reload their reports to restore them in the n
5. change beginning balances and only enter amounts as Activity Deferred Only or Balance Sheet Only instead e State Provision Summary breakout in Excel When Export to Excel is triggered via the right mouse click and there are more than 256 units states combinations the report does not spill over to additional sheets e Alternative Solution Use File gt Export to Excel instead of right mouse clicking and the report will spill over for the additional units states e State Provision Summary Report In the subconsolidated by state breakout the consolidated rates are being incorrectly summed up e State Tax Prov Rpt Breakout The Total ETR does not tie to the ETR report and a mix of federal deductibility causes this report to not tie to other reports e Temp Diff Summary Filing Group report In the default rollup all temp diffs established in the categories will display on the report with zeros even if they are not in the current dataset e Alternative Solution Avoid the default rollup and only view data in a rollups which are configured to display categories that are in use Enterprise Release Notes e Valuation Allowance Automation Not working properly if there is no After Tax Temporary Difference in the unit filing group e Alternative Solution Add an After Tax Temporary Difference to the unit filing group Enterprise Release Notes Items to Note For your information Administer Users e On the Administ
6. dded the ability to export multiple datasets a single step Creates a separate file with the dataset name as the filename e Ability to filter the export to only include a single unit or select subconsolidations e Mass Update Country Currency Rates e Current and Deferred Tax Rates can now be populated for units in a dataset using rates established for the unit s assigned Country Administration gt System gt Manage Countries Currencies The dataset parameter CountryRates with paramvalue of Y will display a Manage Country Rates screen that will allow the user to activates the countries necessary for the dataset The rates can be overridden on a Unit by Unit basis if needed e The Beginning and Ending Spot and Weighted Average FX Rates can now be populated for units dataset using rates established for the unit s assigned Currency Administration gt System gt Manage Countries Currencies The dataset parameter CurrencyRates with paramvalue of Y will display a Manage Currency Rates screen that will allow the user to activate the currencies necessary for the dataset The rates can be overridden on a Unit by Unit basis if needed e Mass Update State Rates e State Tax Rates for user defined and pre defined States can now be populated for units a dataset using rates established for the States assigned Administration gt Manage States gt States The dataset parameter StateRates with paramvalue of Y will display a Manage State
7. e rate effected If it should not be rate effected either exclude the PTBI or enter a 0 tax rate If there is a 0 tax rate be sure to enter any discrete items for that unit as Tax Adjustments e Interim State Provision Summary Report e Requires system parameter USE_SPPROVSUMMARYREPORTS in order for this report to display properly e Inthe breakout by unit states and subconsolidated by state views a total is not displayed for at Forecast Rate e State Summary Provision Summary Reports When using Unit by Unit method the breakout subconsolidated by state view of these reports displays an incorrect forecasted rate not properly including the impact of the true up in the forecast rate e Interim Effective Tax Rate report includes amounts from units which are designated to be treated as excluded e Interim State Provision Report Discrete items entered for states in excluded units display on the State Provision report e The Consolidated Interim Provision summary report displays zero values for PTBI at the Forecast Rate e Alternative Solution The correct values will display once the unit breakout view is clicked Enterprise Release Notes e Interim Provision Report Excluded units with entered Actual PTBI are rate effected with the forecast rate e Forecast Rate Report In Quarterly Variance View State Forecasted Rate for 2nd column either Q2 Q3 depending on view is incorrectly adding the Federal am
8. ed in the report have an Unknown Weighted Average FX Amounts in those units will be excluded in reporting currency Corrected Issue e Filing Group FX Automation for Payable Enterprise Release Notes e By setting the dataset parameter PAYABLE_FXRATE_CALC with a paramvalue of 1 the payable items will be posted with a calculated filing group FX Rate instead of the filing group s filing unit s Weighted Average FX Rate The calculated FX is computed by Summing all Cash Fed Provisions in Local Currency and dividing by all Cash Fed Provisions in Reporting Currency Corrected Issue e Writedown of Automated Valuation Allowance e When the automated Valuation Allowance functionality is activated and the valuation allowances beginning balance is no longer required the draw down no longer presents as a change in rate but correctly displays as Deferred Only activity on the Deferred Balances and Effective Tax Rate reports Corrected Issue e Amortized Amounts e Added the ability to enter ending balance and calculate activity e Balance Sheet Only field added for Amortized Temporary Differences Corrected Issue e Payable Automation for Fiscal Year clients e Fiscal Year clients using FISCAL_MONTHS_OFFSET parameter to determine the fiscal month end will now roll over ending balances to create beginning balances with the code BBAL with the date of fiscal year end plus 1 day For example If paramvalue is 3 CPROV would post with a date of 9 3
9. ew builds e The Plug In report design can be created in house by those clients who are familiar working with SQL query statements and XSL style sheets or these reports can be designed for the client by the Technology Consulting Group for a fee Enterprise Release Notes e The report is configured in the Administration gt System gt Report Writer screen e Universal Report Settings e Ability to set the default view of the Tax Provision Effective Tax Rate and Deferred Balances Reports for the instance e The Report Settings screen can be found under Administration gt Manage Restricted Features e Net Deferred Assets Liabilities Report e AMT Functionality no longer creates AMT_SYS record for every unit with active parent record now every unit country combination does not display with zeros on this report Corrected Issue e State Provision Summary e In the breakout view of the report it is no longer incorrectly summing the state rates in the Total column Corrected Issue e Tax Provision Report e Changed reporting line name from Cash Provision to Return Basis Provision e Changed reporting line name from Rounding to Adjustment when PTBI Policy Enter Local USD FX Calc Rounding is used e Export to Excel of Tax Provision Unit Breakout report now sorts the unit codes columns alphanumerically Corrected Issue e Export to Excel of Tax Provision Unit Breakout Comparison Report Removed view detail hyperl
10. h the paramvalue of the tag letter The Deferred Only and Balance Sheet Only posting tag can be overridden with DORTPTAG and BSORTPTAG Enterprise Release Notes For Your Information Known Issues The following listing of known issues are being documented to notify the users of issues and to suggested alternative solutions Many of these issues are currently being addressed and will be included in future releases of the software e Categories When the symbols gt and lt are used when creating components in the Admin tab it will display amp lt and amp gt respectively reports e Alternative Solution Avoid using symbols lt gt amp when creating component sub consolidations and rollup names in the Admin tab e CTA Functionality lf SHOW_CTA is deactivated and there was data entered in the Additional CTA field the values will still show up on the Tax Provision Deferred Balances expanded b s and expanded i s Reports e Alternative Solution The value entered in the Additional CTA field needs to be deleted before the parameter is deactivated in order for the amounts to not show up on the reports Deferred Balance Report In the CIR expanded b s view the rate change is being incorrectly calculated with the Weighted FX Rate instead of the Ending FX Rate Deferred Workpaper Report This report is not fully functional Effective Tax Rate Report The Effect Rates Different than Statutory colu
11. hapter 4 of the Enterprise User Manual under the Interim Reporting section for more information e When the Forecasted Rate and the Interim Provision Report are Exported to Excel and there are more than 256 units the report does not spill over to additional sheets e Alternative Solution Create subconsolidations of max 250 units and Export to SubConsolidated reports to Excel e In Admin tab under Manage Datasets for the Interim Dataset when the user chooses a true up unit e g D1000 in the Unit by Unit basis D1000 will no longer have the option to be an excluded unit If the basis is switched to the Overall basis DIOOO continue remains unable to be designated as an excluded unit e Alternative Solution Choose Unit by Unit and pick another unit e g D2000 this will then allow D1000 to be excluded when the Overall basis is chosen In Interim when the unit has been excluded for foreign loss and there is a PTB amount entered for that unit in the Actual section the system will rate effect that Actual with the Forecasted Tax Rate On the Unit by Unit basis the Tax Provision report is displaying the and a 0 rate but the PTBI is being rate effected and even though the tax is displaying as O it is being included in the total On the Overall basis the Tax Provision report is displaying the PTBI and a overall forecast rate and tax is included in the total e Alternative Solution Only enter the Actual PTBI if it should b
12. id Payable e Payable amounts can not be entered with tag letter Read Only Users e Are now able to see the Data Review section in the Navigator but still cannot edit this information All the screens are displayed as Read Only Enterprise Release Notes For more information about any of the functionality reports mentioned above please refer to the Enterprise User Manual located on the Help tab Enterprise Release Notes Proprietary Materials No use of these Proprietary materials 15 permitted without the express written consent of or license from 1999 2009 Thomson Reuters ONESOURCE Altering copying distributing or reproducing any of these proprietary materials in any manner is expressly prohibited Software License Agreement The right to use the software product described in this workbook is specifically conditioned upon your execution of and compliance with the Tax License Agreement with 1999 2009 Thomson Reuters ONESOURCE All contents copyright 1999 2009 Thomson Reuters ONESOURCE
13. ink from exported file Corrected Issue e The State Deductible Tax state by state breakout is now suppressed when the USE_SPPROVISIONREPORTS system parameter is activated with the PROVISION_HIDE_STATES system parameter Corrected Issue e Effective Tax Rate Report e When the PTBI policy is Enter Local USD FX Calc Rounding the rounding amount is now broken out on a separate line from the tax effected PTB amount Corrected Issue e The State PTBI Federal Rate Effect percentage now correctly displays in the State Breakdown gt Detail view Corrected Issue e Federal Deducibility when it is less than 100 is now properly calculated in the State Breakdown view Corrected Issue e Deferred Balances Report e Consolidated level view will now display the breakout of all the columns configured in the Manage Deferred Rollforwards in the expanded b s view Corrected Issue e Equity Offset Report e New report that details the Equity Offset other side of the Journal Entry for equity items entered as Balance Sheet Only for Temporary NOL Temporary and After Tax Temporary Differences e Cash Payments Report e New report that details the expected cash payment that will be due on the tax returns when filed e State Deferred Balances Report e Added an additional view for Pre Tax amp Post Apportionment balances at the state specific level Administration Enterprise Release Notes e nterim Datasets e In Manage Datasets fo
14. low for data to be reclassed from one unit to another for reporting purposes or to simulate branch relationships e Excel workbook populated with data and mappings can be attached to a Dataset Unit State or Component depending on the level of detail the user is working with The Active Workpapers functionality requires an additional license to use If you are interested in this functionality and have not yet seen a demo please call your Account or Client Manager to set up a demo Enterprise Release Notes New CTA Functionality Additional CTA e Allows the ability to add an additional amount of CTA to be entered e The entry is made on the Misc tab of the Unit details data entry screen and is only displayed as a Reporting Currency After Tax Rate amount e The entry field is activated via the systemparameter SHOW_CTA with a paramvalue of 1 e The amounts will be tracked and shown on reports with a system defined after tax temporary difference code and name CTA_ADJ CTA Entered Adjustment CTA through P L or Equity e There is now the option to choose CTA treatment on a Dataset level e The P L CTA treatment option is activated via a dataset parameter CTA_Alt_Calc with a paramvalue of 1 e Option 1 Equity existing functionality e Computed CTA impacts e Ending Payable accounts and is Offset in an Equity account e Ending Deferred Tax Asset Liability accounts and is Offset in an Equity account e Option 2 P L e Computed CTA im
15. mn in the expanded view of the Consolidated amp SubConsolidated views of this report doesn t reconcile to the Effect of Rates Different than Statutory row Export Categories Datasets etc When exporting and using Office 2007 the file type shows as xls when you save the file from Enterprise but when you open the file in Excel and Save As the file name displays as filename xls with quotes around it and file type is actually xlsx e Alternative Solution When Saving As remove quotes from file name and change file type to the desired file type Filing Group FX Automation The posting of the impact of NOLs and Valuation Allowances utilized created on the child unit may not correctly translated to the parent unit if there are multiple foreign exchange rates FX being used in the filing group The sum of the underlying units amounts in their local currency is posted to the filing unit assuming they all have the same FX e Interim e When multiple states have been activated for a unit in Interim if the total Current Apportionment Percentage for those states in the Actual section does not total 100 then a warning will display since more less than 100 of the PTBI will be allocated in computing the current tax e Alternative Solution Activate an additional state to enter the percentage that the unit Enterprise Release Notes is over or under allocated for state purposes A query is available to quantify that percentage See C
16. p State Forecasted Rates together The Total Forecasted Rate Variance column then displays NaN e NOL Automation If you manually enter Activity in the NOL Temporary Differences when NOL Automation is used NOL Allowance Rate set lower than 100 and Base NOL Allowance set to O the Tax Provision Report displays incorrect NOL Reclass and Federal Taxable Income Post NOL amounts The NOL Reclass calculation adds the manually entered Activity amounts before multiplying by the NOL Allowance Rate This results in an incorrect NOL Reclass amount and Federal Taxable Income Post NOL e Payable Report e f there is a significant amount of line item information in the payable the report in a Consolidated or large Sub Consolidated view can take a long time to display or may fail e Alternative Solution The TS Database Query Analyzer functionality will allow the data to quickly display a report e This report doesn t tie in local currency for a filing group parent when the children units are of different currencies e Provision Tab Reports Differing rounding policies can cause amounts on the Tax Provision Effective Tax Rate and Foreign Domestic reports to be out of sync by a minimal amount e Sequential Reporting Dataset Beginning balances in the last dataset in the reporting dataset can be modified but there is no impact on the ending balances of the reporting dataset e Alternative Solution To impact the reporting dataset correctly only never
17. pacts e Current Tax Expense and is Offset in a Taxes Payable account e Deferred Tax Expense and is Offset in the Ending Deferred Tax Asset Liability accounts Enterprise Release Notes Dataset Relations RTP True Up Posting with Dataset Relations Datasets can now be associated to one another to create logical relationships for computing and posting the Return to Provision True Up adjustments e Under the Administration gt Manage Datasets screen once a dataset is selected an additional tab named Dataset Relations is displayed This will allow a dataset that contains Return data for the Prior Year to be related with the Provision dataset for the Prior Year as well as the Provision Dataset for the Current Year where the True Up adjustment should be booked e When the RTP Posting is triggered for the unit the system will know which two datasets to compare to compute the true up amount and which dataset should receive the posting of the true up adjustment e The RTP Posting screen is displayed by adding the system parameter SHOW_RTPPOST with the paramvalue of 1 e f the state amounts should be considered the system parameter POST_STATE should be added with the paramvalue of 1 e f the Deferred Only or Balance Sheet Only entries should be considered the system parameter POST_DO amp POST_BSO should be added with the paramvalue of 1 e The default posting tag will be To override that tag enter the dataset parameter RTPTAG wit
18. r the Interim Dataset when the user chooses the Unit by Unit method for applying the forecast rate the True Up unit is designated If that True Up unit does not have a parent record the true up adjustment now correctly posts for either federal or state Corrected Issue e Tax Adjustments e Tax Adjustments now have Type Equity or P L and Source Tag fields associated with them e All existing Tax Adjustments were defaulted to Type P L and Source Tag M e Report Name Change e Changed report name from Wizard Analysis to Remote Data Collection Analysis Enterprise Release Notes Active Workpapers Active Workpapers allows for Excel based workpapers to be embedded with a dataset The Excel cells can be directly related to data fields in TaxStream Enterprise e Allow users to use Excel to design worksheets which can pull raw data found in one or many units such as PTBI Perms Temps etc The using the Excel functionality of formulas mathematical logic can be built using additional information to create either ad hoc reports or to populate the results back to one or many unit s data entry fields in the dataset e Users that have externally maintained Excel spreadsheets which track or calculate historic items such as Capital Loss Carryovers 382 or SRLY NOL Limitation and State Margin Tax can upload those spreadsheets Each period the cell reference can be adjusted to choose that year s allowable portion e The functionality will also al
19. ration Tab gt System gt Administer Users after selecting a user from the list you can toggle between Access Rights and Notes for the user Click the Access button twice to get to the Notes view initially Dataset Combine e This functionality has limitations which should be reviewed before use For more information please refer to the Enterprise User Manual located on the Help tab Enable Quarterly PTBI e The division has changed Instead of adding rounding excess to the fourth quarter each quarter now shows its own rounding Check the rounding when the annual amount is not evenly divisible by 4 Estimated Payments Tab e The Data Entry section under Unit Details displays for foreign countries Filing Group Reports e Effective Tax Rate report for Filing Groups is not yet available in Enterprise but the report is available in iTaxStream Import e The import log has been redesigned and no longer has the coloring for errors e Datasets Updates are now permitted for Type and Fiscal Period through import e UTDAM Unit Temp Diff Amort and UATTDAM Unit Afterlax Temp Diff Amort tabs are not backwards compatible with Version 5 0 58 These tabs been to be converted to the Version 6 0 format in order to properly import New Functionality not available for Interim tab e Active Workpapers e CTA functionality e Dataset Relations e Export multiple datasets e Payable reclass Parameter e SHOW_POSTRTP parameter is no longer val
Download Pdf Manuals
Related Search