ONESOURCE Tax Provision Release Notes
Contents
1. TT T ONESOURCE 1 PROVISION 6 1 ONESOURCE Tax Provision Release Notes RELEASE NOTES NEW FEATURES KNOWN ISSUES RELEASE DATE 3 31 2010 ONESOURCE THOMSONREUTERS COM 323 THOMSON REUTERS ONESOURCE Tax Provision Release Notes Release Overview The following items were addressed in this release General ONESOURCE Integration e If you use Citrix you will notice a change once you log A new icon is available called ONESOURCE Tax Provision which can be used to access your instance s of OTP The icons which previously existed will be removed soon and the ONESOURCE Tax Provision icon will be used exclusively to access your instance s of OTP Administration Manage Datasets For Interim Datasets when you select a true up unit for example D1000 in the Unit by Unit method then D1000 can not be designated as a excluded unit If the user then opted to use the Overall method D1000 was unable to be designated as an excluded unit This has been corrected Corrected Issue e Dataset Combine now displays a popup describing this functionality s limitations e When you copy or rollover a dataset you now have the option of copying over the dataset security settings for users as well by checking Copy Security Access If a user has access to the dataset you are copying or rolling over that access will be copied to the newly copied rolled over dataset e Manage Active Datasets e type2. a paramtype of alphanumeric and a paramvalue of 4 activates the aggregated post tax VA automation e A conversion is required when switching a dataset from VA_CALCTYPE with a paramvalue of 2 to VA_CALCTYPE with a paramvalue of 4 Please refer to the User Manual for more information Bridge e The bridge can now be used in the Interim Actual section Import Export Numbers and Categories e f more than 6 decimal places are entered for a rate the rate will now be rounded to 6 decimal places rather than failing the row Corrected Issue e f the JETAX sheet has over 65 000 rows the export now properly spills over onto a 2nd sheet when using Excel 2003 Corrected Issue e Importing of State Liability items has been fixed Corrected Issue e When exporting categories and the GlobalRegion parameter is set to EUROPE the CS sheet now has column headings and the UPD sheet is no longer a duplicate of the UNOLTD sheet Corrected Issue e Analternate CSC Import added CSC2 which allows for units to go down the left and CSC names to go across the import file GlobalRegion parameter and Other Globalization Related Changes e Basis Balance Sheet renamed Adjusted Trial Balance when the GlobalRegion parameter is set to EUROPE and CANADA e When the GlobalRegion parameter is set to EUROPE the UK date format DD MM YYYY can now be used to view the Audit Trail e Various text changes were made throughout the system and on import export tem
3. driven functionality that allows you to configure your own Journal Entry reports Temporary Difference Changes e Temporary Differences can now be entered without an understanding of tag letters Data entry now involves entering amounts directly in the rollforward column in which they should appear on the Deferred Balances Report Return to Provision RTP True Up Posting e Modified the warning when the POST_STATE parameter is activated to alert users about adding the required Federal and State Tax Adjustment codes for NC_RTP_YYYY_Perm The warning will continue to display until the Federal and State adjustment codes have been added State Payable Reclass Posting e New Payable Reclass posting option added for States ONESOURCE Tax Provision Release Notes e Dataset Parameter PAYRECTYPE with a paramvalue of 2 reclasses Federal auto posted payables to the unit identified by the unit level param PAYRECUNIT and State payables to the equivalent state in the unit specified by the unit state level param PAYRECUNIT Valuation Allowance VA Automation e New Aggregated Attribute VA Calc Type added which treats everything Post Tax Basis The functionality analyzes the net of the three component types After Tax Temp Diffs NOL Temp Diffs and Temp Diffs and posts the resulting VA on an After Tax Basis to the codes VA SYS and VA_SYS ATTD_NC e Dataset Parameter VA_CALCTYPE with
4. sheet will be imported into the system Journal Entry Parameters e The following parameters are no longer valid due to the new Configurable JE Functionality AUTOCREATE_OUTPUTJES 1 5 Read Only Users e Read Only users can now view the Data Review section in the Navigator but still cannot edit this information All screens display as Read Only For more information about any of the functionality reports mentioned above refer to the ONESOURCE Tax Provision User Manual located on the Help tab ONESOURCE Tax Provision Release Notes What We Support DATABASES e Oracle 10g e Oracle 19 e Oracle XE OPERATING SYSTEMS e XP SP3 32 bit e Vista 32 bit EXCEL e 2003 Windows XP e 2007 SP1 Windows XP Vista OTHER COMPONENTS e MSXML 4 0 e MDAC 2 7 or higher e Framework 3 5 SP1 or higher Prior Patch Notes 6 0 1 General e Security Enhancements e Can only open attachments with extensions doc docx xls xlSx ppt txt zip rtf 400 xml csv pdf xlt e User defined web page tabs have been removed and disabled for Citrix users Functionality e Valuation Allowance VA Automation e When automating VA Beginning Balances can now be current C or non current NC e When the Aggregated VA Automation option is used and After Tax Temporary ONESOURCE Tax Provision Release Notes Differences are a liability the system co
5. Issue e State Provision Summary e When using the Unit by Unit method the breakout subconsolidated by state view now displays the correct forecasted rate Corrected Issue e Inthe breakout by unit states and subconsolidated by state views a total now displays for at Forecast Rate Corrected Issue Effective Tax Rate Report e Now available at the Filing Group level on the Provision tab e Use Blended Rate view option is now available at the SubConsolidated and Consolidated levels to allow you to determine whether the reconciliation should start with the PTBI at the Group Tax Rate or the Blended Rate of the underlying units in the subconsolidation consolidation e System Parameter EFFRATEBRKOUT with a paramvalue of 1 e Rounding policies are now consistent between actual entries and subtotal rows Corrected Issue e In versions prior to 6 0 Federal Equity adjustments did not honor zero deductibility for states This issue was resolved in Version 6 0 which resulted in a change of historical reports e Dataset Parameter 58 EQUITY_TREATMENT with a paramtype of alphanumeric paramvalue of Y will ignore the deductibility rate for Equity items and allow this report to function as it did prior to Version 6 0 Foreign Domestic Summary Report e New Prior Year Breakout view added This view will breakout Prior Year amounts for current and deferred tax e Dataset Parameter Prior_Year_Tag with a paramtype o
6. aset Parameter DEF_RF_SUMMATION_NAME with a paramtype of alphanumeric and a paramvalue of Text the name of the column header Temp Diffs Summary Report e At the Filing Group level in the default rollup view only temps in the filing group display Corrected Issue Sign Off Summary Comparison Report Global Access related e Now properly displays the sign off status of datasets Corrected Issue State Tax Provision Report Breakout e This report is no longer available due to a variety of issues caused by state complexities Expected Deferred Rate Report e Now correctly displays under State Summary in the Navigator Corrected Issue Plug in Reports e For Citrix users the bugs related to uploading plug in reports have been resolved Corrected Issue ONESOURCE Tax Provision Release Notes Temporary Difference Changes Temporary Differences have been renamed throughout the application e Tax Basis Temp Diffs allow you to enter amounts as purely tax balances without book or net of book e Book Tax Basis Temp Diffs allow you to enter book and Tax amounts letting the software determine the Book Tax difference This was formerly the Amortized concept All Temporary Difference screens in the Provision and Interim Actual sections now have two tabs Detail and Analysis Detail allows for temp diffs to be entered in the old while Analysis allows for the new approach e Old Approach Temp Diffs are entered needing an understand
7. basis e Deferred Analysis screen under DataSet explains how the Deferred Rollforward has been setup in an easy to understand format Tax Basis Mapping e Now available at the Dataset level to configure the Tax Basis Balance Sheet and Tax Basis Income Statement At the dataset level mappings are double entry requiring accounts for both debits and credits Manage Tags e Multiple descriptions can no longer be assigned to a single tag letter via the Import Categories Template Corrected Issue Global Attachments e System Parameter GLOBAL_XSL_SAVEAS with a paramvalue of 1 allows you to save global attachments to your hard drive e System Parameter GLOBAL_XSL_BROWSEUPDATE with a paramvalue of 1 allows you to update an attachment without having to delete and it Mass Update Rates e State Rates Country Rates and Currency Rates under Data Review gt DataSet gt Administration Added Copy From Admin button to refresh dataset level rates with rates maintained in the Admin tab Client Name e Can now change the Client Name which displays in the window header as well as in the header on reports e System Parameter ClientName with a paramvalue of the client name you d like displayed Support Email and Phone Number Updated e New Support Email provisionsupport thomsonreuters com e New Email for Requesting Upgrades provisiontechsupport thomsonreuters com e New Support Phone Number 877 829 5969 x2 Various Administration Bug Fixes
8. e Rollups Unable to delete the PRV rollup because it is required for automation Functionality e Bridge e Fixed Bridge Archive Report so units which are not mapped are properly displayed e Import Numbers e Negative FX Rates can now be imported e FX Rates of O are no longer allowed on the Fed amp State Payable tabs ONESOURCE Tax Provision Release Notes 6 0 3 Functionality e Batch Print e Reports printed using Batch Print functionality now print out correctly formatted without hyperlinks and lines across the pages e Note If you are using Office 2007 Service Pack 1is required for Batch Print to function correctly e Bridge Import Archives e Clicking Not Mapped on the Bridge Import Archive screen no longer results an error e Exporting e Commas in descriptions no longer cause an export to turn into a comma delimited file on certain tabs e Importing e When importing a spreadsheet that has dates and the dates are formatted as MM DD YY the dates now import correctly e Note Years in format will be converted to 20 e Example If you import 10 31 99 it will import into the system as 10 31 2099 e NOL Automation e Deferred Only and Balance Sheet Only amounts are now being included in State NOL Automation e Now have the option to include exclude Deferred Only and Balance Sheet Only amounts for specific tags for State NOL automation using dataset parameters e All amount types are included by default To e
9. e When attempting to delete a component for which the code is long close to 60 characters you no longer receive an error Corrected Issue e If you assign a unit to an Admin user in Administer Units access to the rest of the units is no longer removed Admins should always have access to all units Corrected Issue e f two units have the same name and of them is deleted the remaining unit s reports are no longer blank Corrected Issue e You no longer receive random error messages when Activating a Unit after deleting an unrelated Dataset Corrected Issue e Data Review no longer shows in the Navigator when a Reporting Dataset is selected from the Control Center Corrected Issue Functionality Active Workpapers AWP ONESOURCE Tax Provision Release Notes e A subset of calculated values can now be pulled into AWPs in both Local and Reporting currencies at the Unit SubConsolidated and Consolidated levels e Batch running of AWPs is now possible You no longer have to individually open and close each AWP to push and pull values The order in which AWPs can run in is fully configurable enabling you to create your own custom calculation engine e You can now pull and push amounts between multiple datasets in the same AWP Note You must have access to all the datasets from which you are attempting to push and pull values e Mappings can now be copied via the User Interface using a mechanism similar to the Excel forma
10. f alphanumeric and a paramvalue of the desired tag letter determines which NC_ and Deferred amounts are considered in the Prior Year breakout view based on their tag letters NOLs Expiration Report e New report that shows NOLs by expiration year a required field when adding NOLs and the usable tax losses Payable Rollforward and Payable Detail Reports ONESOURCE Tax Provision Release Notes e Now available at the Filing group level on the Provision tab Deferred Balances Report e New State Summary Deferred Balance report with State by State breakout subtotaled by unit by state e Clicking breakout for State level report no longer changes the report to the pre tax pre app view from the pre tax post app view Corrected Issue e Filtered Deferred Balances Report in hybrid view now honors the filter and only displays the filtered deferreds Corrected Issue e State Specific Deferred Balances Report now displays the state name in the report header Corrected Issue e Expanded FERC view of Deferred Balances report now available for regulated energy companies who need to separate Utility and Non Utility related deferreds e System Parameter SHOW_DEFBAL_FERC with a paramvalue of 1 displays this report e Adjusted Balance column can now be determined via Dataset level parameters which override the system parameter e Dataset Parameter DEF_RF_SUMMATION_COLUMN with a paramtype of alphanumeric and a paramvalue of 2 through 26 e Dat
11. ing of tag letters Data entry involves entering line items with different tags in order for them to display properly on the Deferred Balances Report e New Approach Temporary Differences are entered without an understanding of tag letters Data entry now involves entering amounts directly in the rollforward column in which they should appear on the Deferred Balances Report This is driven by the Deferred Rollforward that is setup by Admins with the results of that setup available on the Deferred Analysis screen for all users e Dataset Parameter RESTRICT_TD_TABS with a paramtype of alphanumeric and a paramvalue of O allows both Admin and Read Write users to enter data on both the Analysis and Detail tabs A paramvalue of 1 limits the ability to enter data on the Detail tab to Admins only e Dataset Parameter DEFAULT_TD_TABS with a paramtype of alphanumeric and a paramvalue of O defaults Temp Diff screens to the Detail tab for all users A paramvalue of 1 defaults Temp Diff screens to the Analysis tab for Read Write and Read Only users and to the Detail tab for Admin users A paramvalue of 2 defaults to the Analysis tab for all users For more information on the new Temporary Difference screens as well as Deferred Rollforwards per Dataset which directly impact the new Temp Diff entry refer to the ONESOURCE Tax Provision User Manual located on the Help tab AWP Calculated Values ONESOURCE Tax Provision Release Notes Calculated val
12. is now a drop down for ease of use e Single Dataset Configuration has been removed because it is no longer used Manage Tax Basis Return e Corptax Export Mappings Improvements e Period Type Override available for each mapping line Return system parameters other than those related to Corptax must be deactivated in order for this field to display e Can now enter factors for P amp L Account Balance Sheet Account and Retained Earnings Account to adjust the sign of the number coming out of OTP Manage Trial Balance e Trial Balance Sublines Can now designate which sublines should display for use with the Configurable JE Module by checking JE Posting Account Manage Licenses e The system now confirms the validity of the license key entered Administer Users e Usernames can now be case insensitive e System Parameter CASE_INSENSITIVE_LOGIN with a paramvalue of O enables an Admin to specify that all user logins are case sensitive A paramvalue of 1 specifies that user logins are not case sensitive Manage Deferred and NOL Rollforwards e Number of columns is now determined via a drop down The Save button is located beneath the column setup ONESOURCE Tax Provision Release Notes e Deferred and NOL Rollforwards are now both available at the Dataset level under Data Review gt DataSet gt Administration Configurations will default from Admin for existing datasets and newly created datasets but can then be customized ona dataset by dataset
13. nsiders their impact on the VA posting e NOL Automation e Now have the option to include exclude Deferred Only and Balance Sheet Only amounts for specific tags for NOL automation using dataset parameters e All amount types are included by default To exclude amounts set up the appropriate dataset parameter e Exclude Deferred Only NOLAUTO_DEFONLY_EXCLUSION with a ParamValue Tag Letter e Exclude Balance Sheet Only NOLAUTO_BSO_EXCLUSION with a ParamValue Tag Letter e For example To exclude Deferred Only entries tagged with P and Balance Sheet Only entries tagged with both X Z create the following dataset parameters e NOLAUTO_DEFONLY_EXCLUSION1 ParamValue e NOLAUTO_BSO_EXCLUSION1 ParamValue X e NOLAUTO EXCLUSIONZ ParamValue Z e When automating the posting State NOL Beginning Balances can now be current C or non current NC e Active Workpapers AWP e Data entered or updated via AWP now triggers those units to be recalculated when reports are displayed e FX Rates e User is now unable to manually enter or import zero FX Rates Reporting e Deferred Workpaper e Corrected display when Fed Benefit is set to both FED and STATE to include state by state breakout of balances e Regen Report Data e Error message displays when Regen Report Data fails to calculate Administration e Manage Payable e Manage Payable Buckets Unable to delete the PROV bucket because it is required for automation e Manage Payabl
14. plates to ensure consistency of terminology e Bridge Archives screen USD renamed PTBI Reporting Printing e Batch Export to Excel is now available for reports via File gt Batch Print gt Save as Excel Reports Interim Related e Interim Provision Report e When the unit has been excluded for foreign loss the Actual calculation and reports are now working properly in the Unit by Unit view of the report which now also agrees with the Overall view of the report Corrected Issue e At the Consolidated level the value zero no longer displays for Pre Tax Book ONESOURCE Tax Provision Release Notes Income and PTBI at Forecast Rate Corrected Issue e At the State level discrete items entered in excluded units no longer display on the report Corrected Issue e Forecast True Up Report e New report available at SubConsolidated and Consolidated levels This report explains the computation of the True Up required to make up the difference between applying the Unit by Unit Forecasted Rate and the Overall Forecasted Rate to the Actual PTBI e Forecast Rate Report e In Quarterly Variance View the State Forecasted Rate in the 2nd column either Q2 or Q3 depending on the view no longer incorrectly adds the Federal and State rates together The Total Forecasted Rate Variance column also correctly displays now Corrected Issue e Effective Tax Rate Report e Excluded units are no longer included in this report Corrected
15. t painter e Additional Excel functionality has been added to AWPs including freeze panes formatting sheet cell protection and charts e Modified columns Modified Date and Modified By have been added to the AWP screen e The mapping user interface is now a floating toolbar It can be moved around the screen and the orientation of the toolbar can be changed from horizontal to vertical e Amounts can no longer be SET SYN for Read Only datasets Corrected Issue e Security for AWPs e AWPs will be available for Read Only and Read Write users as read only unless a dataset parameter enables Read Write users full access to AWPs e Dataset Parameter AWP_WRITE with a paramtype of alphanumeric and a paramvalue of 1 will make AWPs fully accessible for Read Write users e Unit and dataset drop downs in AWPs are limited based on user s permissions e If an AWP is opened by a user and a subsequent user attempts to open the same AWP the second user will be notified that the AWP is already open and in use but will not provide the name of the original user However the subsequent user can still choose to enter the AWP and make changes which will conflict with the original user s work Flowthrough Module e License driven functionality that allows you to move amounts en masse across units for various reporting purposes If you are interested in this functionality please call your Account or Client Manager Configurable Journal Entry Module e License
16. tary Materials No use of these proprietary materials is permitted without the express written consent or license from 1999 2010 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 document is specifically conditioned on your execution of and compliance with the Tax License Agreement with 1999 2010 Thomson Reuters ONESOURCE All contents copyright 1999 2010 Thomson Reuters ONESOURCE
17. ts can be configured to display Several parameters need to be added to use this functionality and a valid license is required in order to view the Configurable JE reports The lines of the JE can be set up to show the results on a Summarized basis or a more detailed basis For more information on the configuration options available and setup required please review the ONESOURCE Tax Provision User Manual located on the Help tab If you are interested in this functionality please call your Account or Client Manager ONESOURCE Tax Provision Release Notes For Your Information Known Issues If you have questions about known issues in the system please contact your Client Manager Items to Note For your information Administer Users e On the Administration 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 Notes button to toggle to the Access view and vice versa Dataset Combine e This functionality has limitations which should be reviewed before use For more information refer to the ONESOURCE Tax Provision 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 Import e Import no longer stops at a blank row All data in the import
18. ues can be pulled into AWPs by selecting UNITCALC as the Component Type You then designate the hierarchy level Unit 500 Consolidated and the currency Reporting or Local Below is a list of all calculated values which can be pulled into AWP Abbreviation Value After Tax Temporary Differences DST Deductible State Tax BDTPBS Beginning Deferred Tax Balance Sheet BSOA Balance Sheet Only Adjustments CTA Currency Translation Adjustment DPO Deferred Tax Provision EA Equity Adjustment EDTPBS Ending Deferred Tax Balance Sheet ETR Effective Tax Rate FEDTI Federal Taxable Income Post NOL FINTI Financial Taxable Income Federal Tax Current FTIPN Federal Taxable Income Pre NOLs NCTA Non Cash Tax Adjustments NOL Net Operating Losses PD Permanent Differences Pre Tax Book Income RPTBI Rounded SCP State Current Provision SDP State Deferred Provision SEA State Equity Adjustment STP State Tax Provision TA Tax Adjustments Cash TCFP Total Current Fed Provision TCTP Total Current Tax Provision TD Temporary Differences ONESOURCE Tax Provision Release Notes Configurable JE Module The Journal Entry JE report can now be configured on a unit by unit basis allowing Administrators to determine how calculations and other data display in the Output Journal Entries section up to 99 custom repor
19. xclude amounts set up the appropriate dataset parameter e Exclude Deferred Only NOLAUTO_DEFONLY_EXCLUSION with a ParamValue Tag Letter e Exclude Balance Sheet Only NOLAUTO_BSO_EXCLUSION with a ParamValue Tag Letter e For example To exclude Deferred Only entries tagged with and Balance Sheet Only entries tagged with both X Z create the following dataset parameters e NOLAUTO_DEFONLY_EXCLUSION1 ParamValue e NOLAUTO_BSO_EXCLUSION1 ParamValue X e NOLAUTO 2 ParamValue Z Reporting e Effective Tax Rate Report e The Effect Rates Different than Statutory column in the expanded view of the Consolidated and SubConsolidated views of this report now reconciles to the Effect of Rates Different than Statutory row e Tax Provision Report e CTA_SYS values now properly display on the Tax Provision Report without having to run Reset Report Data ONESOURCE Tax Provision Release Notes Administration e Dataset Administration e You no longer receive an error when trying to create a new dataset or copy or rollover a dataset when the SHOW_ADVANCEDLIABILITY parameter is not present in the system OAL Technical e Installer Files e Necessary DLLs for the functioning of Enhanced Integration are now available RIRS Functionality e Enhanced Integration e Transferring state apportionment rates with many decimal places no longer results in rates being in scientific notation Proprie
Download Pdf Manuals
Related Search