How to Import the Tax Provision Blueprint app in a Dev Environment (Step 1)
We strongly suggest that you first install the MarketPlace Tax Provision Blueprint in a Test environment / Test App as a stand alone app. From there, you can export the objects that you need into a recent copy of your Production app that is in your Dev environment. Why do we say this?The Tax Provision Blueprint installation includes test entities, related metadata, and workflows, all which will need to be removed. It is strongly recommended that this removal and the related addition of customer entities, metadata and workflows be performed in a development environment, and that the production migration be planned from this updated development environment. Here are the high level steps required to import & setup the Tax Provision Blueprint app into your Dev environment. This "Step 1" KB article will walk you through: Installing the MarketPlace app into a Test environment / Test app. This app will be your reference app with test entities and test workflow profiles. Export only the required objects from yourTest environment / Test app. Import the required objects into your Dev environment / Dev app. Configure the Tax Provision app in yourDev environment / Dev app. so that you have a working Tax Provision application. Note: Additional metadata updates and system configurations will still be required. Please see KB article "How to Setup the Tax Provision Blueprint app in a Dev Environment (Step 2)". (1) Download and Install the MarketPlace app in a TestEnvironment/App The app in this environment will be a complete install including test entities and test workflows. This will be your Tax Provision app to reference. Download the MarketPlace Tax Provision Blueprint app Create a test app Create the required FX Rate Types or load in the FX Rate Type file Load in the downloaded "xml" file Load in the SaveDataEventHandler BR (2) Export the Tax Objects from the Test Environment/App Only specific objects need to be exported then import into your Dev. app. Export Metadata - AllBusiness Rules, all Dimensions (except XFW_TXP_Entities, FIN_Entities_TXP), exclude Time Dimension Profiles & Cubes Export Cube Views - AllBusiness Rules, Groups & Profiles Export Form Templates - AllGroups & Profiles Export Data Management - All Groups Export Confirmation Rules - All Groups and Profiles Export Extensibility Rules - only the SaveDataEventHandler Export the Dashboards - All Business Rules, Workspaces, Profiles Export the new FX Rate Types - seven in total (3) Import The Tax Objects into your DevEnvironment/App This Dev app. should be a recent copy of your Production app. The following steps must be done in this order: Create the Tax Cube (XFW_TXP) -(to be configured later on) Load/Create the necessary FX Rate Types Import the Metadata file Import the Cube View file Import the Form Templates file Import the Data Management file Import the Confirmation Rule file (need the cube to be created) Import the Dashboard file If you already have a "SaveDataEventHandler" BR, copy in the Tax BR section. If there is no "SaveDataEventHandler" BR, then you can load in the file. (4) Configure Tax Provision in the DevEnvironment/App The Tax Provision Blueprint app comes with a very comprehensive "Instruction Guide" that we strongly encourage you to read. Create an Entity hierarchy for Tax or use an existing hierarchy (ie: Finance...). Configure the Entities. Add the "TXP_GLTaxAdmin" entity as a sibling of the Tax entity hierarchy. Make sure you update the proper properties. XFW_TXP Cube - Update the Cube Properties, the Cube Dimensions, the Cube References and Integration settings.See your Test environment / Test app for examples. Update the Application Properties, if necessary. Update the Global Setup Dashboard for the Entity dimension, the Tax Entity hierarchy and the security group access. Update the other settings if necessary. Update UD7 (Group Filing) XFW_TXP_UD7: Remove Blueprint entities. Remove countries you are not using. Add new countries and entities that are using Group Filing. Must be exactly as they appear in the Entity dimension. If you are not using Group Filing at all, remove all the Blueprint entities and countries. Remember to keep the minimum required members. Set a "Cube POV" for the XFW_TXP tax cube. There should be no "?" for any dimension member. Create "test" Workflow Profilesto validate the Schedules. See your Test environment / Test app for examples.Is Tax Provision Compatible with Version 8 (v8)?
The most currently release of Tax Provision Blueprint (PV7.3.0 SV100) is compatible with version 8 (v8). Tax Provision releases prior to PV7.3.0 SV100 (PV6.2.0 SV300): Release PV6.2.2 SV300 is not compatible with version 8 (v8). Based on our testing, prior releases would only need a minor tweak in your business rules (BR's) where you reference a "Literal Parameter". You would first need to upgrade your OneStream platform to version 8. From there, you will need to compile all your business rules (BR's). A list of error messages will be generated. For Tax Provision, you should get the following "Warning" message: CASE 1: As long as when you upgraded your OneStream platform to version 8, you let the Tax Provision Dashboard default to the following location: Workspace / Default / Maintenance Units / XFW Tax Provision (TXP) The fix is to replace all the "old" references to get a literal parameter as follows: The default workspace is just an empty Guid, so if you aren't using a custom workspace, Guid.Empty should work as the 3rd parameter while keeping everything else the same. CASE 2: If you are using a non-default workspace, the DashboardExtenderArgs has a property to get the workspace, for example using it like this: BRApi.Dashboards.Parameters.GetLiteralParameterValue(si, false, args.PrimaryDashboard.WorkspaceID, "[YOUR DASHBOARD PARAMETER NAME GOES HERE]") Example: I want to get the literal parameter that is stored in a "non" Default Workspace. Note: The BR syntax that we are using below is only available starting in version 7.4.0 The syntax would be as follows: And if I write the "TestWorkspace" to the error log, I get the correct literal parameter: There will be several of these cases throughout all the business rule (BR) files. Note: If you have made additional customized enhancements to a prior release of Tax Provision, there may be other changes that are required to be v8 compatible.Summary of the Tax Provision Functionality by Version
Below are the versions of Tax Provision with it's associated functionality. There is an attached zip file that has all the Release Notes for each version. Note: Tax Provision Blueprint is not an upgradeable solution. PV430 SV100 - release date: Nov 30, 2018 (referred to as Dev01) Initial launch of Tax Provision. Feature Functionality National jurisdiction tax provision. PV511 SV100 - release date: Sep. 23, 2020 (referred to as Dev02) Feature Functionality The Tax Provision solution now supports the ability to compute Local Tax Provisions. UD1 now includes Local Jurisdictions. Business Rules now calculate both National and Local Jurisdictions. All Schedules have the ability to display either the National Jurisdiction or any one of the Local Jurisdictions. Added the ability for an entity to receive a National Tax Benefit from Local Jurisdiction(s). Where applicable, Schedules will suppress specific rows or columns that are not related to the selected Jurisdiction, allowing the same Schedule to be used for different purposes. See KB article: "Release Video - PV5.1.0 SV100" Additional Enhancements The Tax Provision Setup Instructions contain detailed information for all implementers and Administrators regarding the use of Schedules in both the Seed Year and the years after the Seed Year. There is now a Tax Provision Dashboard which includes a Home page. There is now a Settings page that is accessible from the Tax Provision Dashboard. The top line in each Schedule now shows the Calc Status. Schedule row and column descriptions now include data origination and destination.Also, specific data cells will display a colored box around them to indicate where data is expected. Analysis Cube Views were created and can be attached to a Workflow. The SaveDataEventHandler Business Rule now validates the years that a user enters into Schedules 2, 3, and 4. Error messages will pop up when trying to save or calculate incorrectly entered years. These messages contain corrective instructions. An Admin Cube View (available in OnePlace) is provided to help the Administrator pre-populate the Origin Year for Schedule 3. The Start Year is now referred to as the Seed Year. Form Templates are now created using Dashboards rather than Cube Views. The main Finance Business Rule (TXP_BusinessRules) has been re-organized and is better structured for understanding and maintenance. RTP - Return Year must be set and no longer defaults to the prior year. In Schedule 3, the data for UD2 member “CY > -19” no longer rolls off the schedule, but rather is added to the last year’s balance. PV620 SV100 - release date: Sep 24, 2021 (referred to as Dev03) Feature Functionality The Tax Provision solution now supports the ability to calculate a tax provision with or without Group Filings (GF): National and/or Local jurisdictions. Workflows are used extensively to facilitate the different tax provision setups for group filing or no group filing. The Entity dimension has 2 new Text 7 properties required for group filing: “NatFiler=Yes” and “LocalFiler=Yes”. The UD1 National JD has a Text 2 requirement for National GF: “NatGF=Yes”. The UD7 dimension is now being used to hold the group filing entities. New schedules have been created to allow the users to enter in Group Filing Definitions. The Finance BR “TXP_BusinessRules” has been updated for the UD7 dimension. See KB article: "Release Video - PV6.2.0 SV100" Additional Enhancements Additional UD8 members have been added for dynamic reporting. There are now ten Form Template Profiles to assist with the different types of workflows. The tenth one being the Admin profile. All schedules now have an attached PPT file.These files can be customizable to each application. Schedules no longer have an Instructions section below the POV / above the cube view. Instead, we now have a PPT help file with the instructions in it. This saves on the schedule’s real estate space. All schedules now include a vertical and horizontal moveable splitter bar. Five new copy schedules have been added – DM 10a, DM 10b1, DM 10b2, DM 30a and DM 30b. DM 10a is used to copy the National provision data to the National filer entity. Several new Data Management jobs have been created to assist with copying data and annotations. There are now Scenario formulas on both Actual scenarios that impact the first period of the following year when a calculate is done in period 12. These can be removed or changed based on your specific app. Four Forecast scenarios have been created for reference only. FX rates and Excel data files are included with sample data that can be loaded into the Tax Provision app. Schedules that start with a “DM” represents a Data Management job that copies data or cell text. Schedules that start with a “LP” represents Local Processing for local jurisdictions. PV620 SV200 - release date: Feb 28, 2022 (referred to as Dev04) Feature Functionality The Tax Provision solution now supports the ability to execute a bulk data copy: Allows National group filers to copy the national preparation data to the filer member. Allows copy from National to Local jurisdictions. The GLTaxAdmin workflow allows you to process all the different country bulk data copies from one workflow. A new Finance business rule was created called “TXP_CustomCalcs” which is used to calculate the new Time Stamp for the bulk data copy dashboards. Additional Enhancements Several reports now have a combo box selection to select the number of decimal places to display for percentages. The Tax Provision dashboard home page for reports is now divided into two panes – Report Groups and Reports. Several reports now have a check box to allow you to sort the entities in the combo box. Reports now let you select the time period (month) for the report and assumes the workflow year you are in. This means that the user does not have to be in a specific workflow period to run a report. PV620 SV300 - release date: Jul 10, 2023 (referred to as Dev05_Dscr) Feature Functionality The Tax Provision solution now supports Interim Reporting computations for the current year. Option to calculate a full year forecast for the current period. Ability to calculate the Interim Reporting Run Rate in the forecast scenario. Added classification of discrete items to facilitate Interim Reporting. Includes Losses Not Benefited computation. Consolidated Interim Reporting Run Rate is used to calculate and report the Applied Interim Reporting Effective Tax Rate. We have assumed that the workflow profiles are the same for Actual as well as for Forecast scenarios. Single year Forecast scenarios are set up to use the Scenario Type of “ScenarioType8”. Six new FX rate types have been added that are used on forecast scenarios. New sets of schedules have been created for Forecast scenarios. New Forecast Tax Reviewer reports have been created. We added the ability to do a bulk copy of last year’s CY tax rates & last year’s Deferred tax rates into the current year.This is only done in period 1. See KB article: "Tax Provisioning Blueprint Overview - PV6.2.0 SV300" See KB article: "Release Video - PV6.2.0 SV300" Additional Enhancements Added parent account TXP_TIBeforeLosswNatBen to allow the National Benefit Deduction to be included when creating a tax loss. We added a new Global Setting page option for a security group. All schedules and Reports now have a “Refresh Data” button in the toolbar. We added the “Sticky POV” concept on the schedules.This will hold your POV as you go from schedule to schedule. Reports will now automatically hold your POV (same as the Sticky POV concept). Schedule column headers now indicate if there are linked CV’s in that column. Additional Actual Tax Reviewer reports have been created. Multi-year Forecast scenarios are set up to use the Scenario Type of “ScenarioType7”, but we have not explored that avenue in this release. PV730 SV100 - release date: Jan 15, 2024 (referred to as Dev06) Feature Functionality Lots of new reports were created and updated. See KB article: "Tax Provisioning Blueprint Overview - PV7.3.0 SV100" Additional Enhancements Added the UD1 "Total Local" member to the toolbar combo boxes. Added monthly, quarterly & yearly confirmation rules for forecast scenarios. BR's - changed the reference for "RemoveZero" to "RemoveNoData" - specifically for forecast scenarios. FX calculations were updated to include local FX due to multiple translations. Documented which dimension members can be "renamed", "deleted" or not touched. The Waterfall graph (80a) no longer uses BR’s for the graph. There is now a new Advance Chart called “Waterfall” that has the same functionality as the BR.How to Setup the Tax Provision Blueprint app in a Dev Environment (Step 2)
After you have completed Step 1: KB article "How to Import the Tax Provision Blueprint app in a Dev Environment (Step 1), you are now ready to update metadata and adjust some configurations to meet your specific application requirements. The following is a summary of the topics to be considered. Please see the attached Word doc. for more detail (the doc. is still being put together). (1) Update Metadata Update the imported scenarios XFW_TXP_Scenarios. Delete what is not required. Update the imported Flows XFW_TXP_Flows. Update UD1 (Jurisdictions) XFW_TXP_UD1: Remove countries & jurisdictions you are not using. Add countries & jurisdictions that are missing. Update UD2 (Data Type) XFW_TXP_UD2. Update the importedAccounts XFW_TXP_Accounts. Please see the KB article "Dimension Member Names - Renaming and Deleting". This will show you which dimension members can be renamed or deleted. (2) Update Cube Views Update Cube Views for the new accounts - specifically for Sch 02, 05, 06 and all the associated row templates. Update Cube Views for the any new UD2 members - specifically for Sch 07. (3) Update Parameters Review and update the following parameters: Tax_BaseLevelTimePeriods_TXP WFYearBasePeriods_ML_TXP TimeZone_Footer_TXP SourceFCSTScenarios_TXP FCSTScenarios_Sch1f_TXP Select_Report_Scenario_TXP Select_Report_FCSTScenario_TXP Tax_Countries_NoBase_TXP Tax_Entities_NatGF_TXP Tax_Entities_noNatGF_TXP UD7_Sch05c_NatGF_TXP (4) FX Rates Enter in all the appropriate FX rates. (5) Update the Schedule / Report PPT Help Files Each schedule and report has an associated PPT help file (click on the ? icon) that should be reviewed and updated to be client/application specific. (6) Confirmation Rules Review the Confirmation rules. Delete, update, rename and/or create new ones as necessary. (7) Security Createsecurity groups and attach them to the appropriate dimension members.Create New FX Rate Types
The following has been taken from the Tax Provision Blueprint "Instruction Guide" starting at page 25. See KB article: "Tax Provision Blueprint Instruction Guide - PV7.3.0 SV100" See KB article: "FX Rates" Create New FX Rate Types When the Development application is refreshed from the Production application, the Administrator must manually create the seven new FX Rate Types in the target OneStream application before beginning the installation and file import processes. The FX Rate Type contains a unique GUID identity code for each application at the time it is created, alleviating potential conflicts caused by importing the FX Rate Type with a conflicting GUID from another application. To create a new FX Rate Type: From the application tab, click Cube > FX Rates. On the FX Rates tab, click Create or Edit FX Rate Type and type the following information: Name: TXP_YTDAverageRate Description: YTD Average Rate Click OK. Repeat the process for the other FX rates as follows: After you have successfully added all these FX Rate Types, import the Tax Provision Blueprint “zip” file. Important! These seven FX rate types must exist in the app before you can successfully load in the application zip file. Attached is a file that contains the additional FX Rate Types that are used in the Tax Provision Blueprint application. This file allows you to load in the FX Rate Types rather than manually creating them. This must be done prior to loading in the XML file. This file contains the 7 additional FX Rate Types.FX Rates
The following has been taken from the Tax Provision Blueprint "Instruction Guide" starting at page 48. See KB article: "Tax Provision Blueprint Instruction Guide - PV7.3.0 SV100" See KB article: "Create New FX Rate Types" FX Rates TXP_YTDAverageRate – YTD Average Rate is the FX Rate Type that is used with the Tax Provision Blueprint application for revenue and expense (activity) currency translation for theTXP_ActualandTXP_ActualRTPscenarios. In addition, Tax Provision Blueprint leverages monthlyClosing Rates for asset and liability translation. Tax Provision Blueprint uses the Rule Type of Periodic for translation of revenues and expenses, and the Rule Type of Direct for translation of assets and liabilities. There are three forecast FX average rates and three forecast FX closing rates that are used with these forecast scenarios: TXP_FCST_M5 TXP_FCST_Q2 TXP_FCST_Q3 Cube Setup: Actual Scenario Setup:Is Tax Provision Upgradeable?
Simply put - No. TheOneStreamTax ProvisionBlueprintprovides a framework to streamline the tax provision computing national and local for both current and deferred taxes under US GAAP as well as providing related workflows and reporting, all within the OneStream Platform.Itis afull application that providesan accelerated path to building out what will be a customized OneStreamFinancial Model. It allows companies to leverage the OneStream platform capabilities and existing OneStream data to automate tax provision related flows of data and reporting. As the Blueprint provides the framework for the Tax Provision calculations, it is intended to provide a starting point in the creation of a custom implementation. Tax Provision is therefore NOT UPGRADEABLE. However, objects from a new release/version can be exported and then imported into your application (in a Dev environmentof course) and then adjusted/configured for your specific application. Note: You should NEVER import a newer release of Tax Provision into your application.Global Options Dashboard
The following has been taken from the Tax Provision Blueprint "Instruction Guide" starting at page 37. See KB article: "Tax Provision Blueprint Instruction Guide - PV7.3.0 SV100" Global Options The Global Options page contains eight properties that must be set before the start of any unit testing. After defining the Entity Dimension, set the Tax Entity hierarchy and the other Global Options. These settings cannot be saved until all options are set. It is recommended you not change these settings after loading data. Note: All Global Options settings are saved to literal parameters. Access the Setting dashboard from here: Access to the “Global Setup” page is limited to both the OneStream security group “Administrators” and to the security group that is selected on the Global Setup page. There is an XFBR rule in TXP_ParamHelper where the security group is evaluated. Note: The “Administrators” security group “bypasses” all other security groups. This XFBR rule is referenced on the dashboard component “btn_ShowSettings_TXP”. If a user is in this security group, then they will see the “Settings” icon in the upper right-hand corner… and have access to this page: Note: The "Security Role (Manage Tax Setup)" is only used to limit user access to the Global Setup page. It is not used anywhere else in the Tax Provision Blueprint application. However, it doesn't limit you from using it elsewhere in the application as you setup security groups. Select the Entity Dimension and Entity The Entity (Hierarchy) is referenced in rules and parameters. In the drop-down list box, select the Entity Dimension and then highlight the top-level tax provision legal entity parent. Security Role (Manage Tax Setup): You now have the ability to use a specific security group to control access to this Global Setup page. You do not have to use the OneStream security group “Administrators”. Seed Year A 4-digit Dashboard Parameter used in the initial configuration of Tax Provision Blueprint to store the seed year of the application. This parameter is used in Business Rules to calculate tax provision data. For Bulk Copy (Return Data) - RTP Range of Years Select how many years prior to the workflow that you want available when copying the national to local return data (bulk or single POV copy). The default is “3”. Valid values are 1 to 5. This value is used in Schedules DM 20b / DM20bAdmin, DM 20b2 / DM20b2Admin, DM 30b / DM30bAdmin, and DM 30b1 / DM30b1Admin. Sch 03 Expiration Year (lower limit) A 4-digit Dashboard Parameter is used to limit what the user can input as the lower limit expiration year for Schedule 3, but only in the Seed Year. Sch 03 Expiration Year (upper limit) A 2-digit Dashboard Parameter is used to limit what the user can input as the maximum expiration year for Schedule 3. This 2-digit value is added to the current WF (Workflow Year). Sch 04 Tax Year (lower limit) A 4-digit Dashboard Parameter is used to limit what the user can input as the lower limit tax year for Schedule 4. Important! All fields in Global Options must contain a valid response in order to save.Bug - Schedule "03 FC Tax Attributes" - Linked CV
This relates to release PV7.3.0 SV100. On Schedule "03 FC Tax Attributes", the linked Cube Views do not appear when you right click in the column. Reason: The linked CV was renamed and we forgot to update the reference to it in Sch 03 FC. Fix: Open the CV "Sch_03FC_TaxAttributes_TXP" Go to the following columns on the Data tab and add the "_TXP" to the end of the Linked Cube Views TXP_OpenBalAdj TXP_TLCOtherOpenAdj_Dscr_Base TXP_Created TXP_Expiration TXP_DeferredOther_Base TXP_TotalBSO_Base TXP_Utilization Before the Fix: After the Fix:SaveDataEventHandler BR
Attached is the SaveDataEventHandler business rule that is used in the Tax Provision Blueprint application. You can only have one SaveDataEventHandler BR per application. You will overwrite the existing Business Rule if loaded directly into the system. For this reason, it is not included in the “zip” Package and must be uploaded manually for the solution to work properly. The BR can be obtained in the Tax Provision Blueprint app in one of two ways. 1) On the Application Dashboards tab, click Dashboard Maintenance Units > XFW Tax Provision (TXP) > Files > 01 SaveDataEventHandler_BR_for_TXP.zip.In the General (File) pane, click the Download File icon in the Content File row and select a location to save the file locally. 2) The file can also be located on the Settings dashboard under Detailed Implementation Files: