Administering Tax Reporting

Introduction to Tax Reporting

• Course Objectives
• Course Agenda
• Lesson Objectives
• Oracle Cloud Enterprise Performance Management: Overview
• Platform Components: Overview
• Tax Reporting: Tax Provision
• Tax Reporting: Country-by-Country Reporting
• Country-by-Country Reporting Cube Data
• Tax Reporting: Pillar Two
• Tax Reporting: Benefits and Features
• Tax Provisioning with Tax Reporting
• Tax Provisioning Process
• Tax Provisioning Process: Detailed Steps
• Tax Provisioning Process: Calculations
• Tax Provisioning Process: Manual Adjustments
• Clients and Tools: EPM Automate
• Clients and Tools: Smart View
• Modern Tax Reporting Best Practices
• Design and Implementation Best Practices
• Modern Tax Reporting Considerations
• Accessing the Tax Reporting Environment
• Summary

Creating a Tax Reporting Application and Enabling Features

• Objectives
• Tax Reporting Implementation Process: Overview
• Creating a New Application
• Creating a New Application (Continued)
• Creating a Tax Reporting Application (continued)
• Enabling Tax Reporting Features
• Configuring Tax Settings
• Viewing Tax Reporting Application Properties
• Viewing Application Recommendations
• Summary

Navigating Tax Reporting

• Objectives
• Home Page: Overview
• Exploring Tax Reporting
• Navigating from the Home Page
• Exploring the Navigator Menu
• Navigating to Tasks
• Forms
• Member Selector
• Dashboards
• Reviewing Total Tax
• Navigating to Approvals
• Exploring the Library
• Navigation Flows
• Tax Reporting Clusters: Overview
• Application Cluster
• Tools Cluster
• Summary

Setting Up Tax Reporting Dimensions

• Objectives
• Dimensions: Overview
• Tax Reporting Cubes and Dimensions
• Managing Dimensions
• Modifying Dimension Properties
• Editing Member Properties
• Managing Dimensions with Smart View
• Setting Up the Currency Dimension
• Setting Up Jurisdictions
• Setting Up the Entity Dimension
• Adding Entities
• Creating an Alternate Hierarchy
• Setting Up the Account Dimension
• Permanent Differences
• Adding Regional Permanent Differences Accounts
• Temporary Differences
• Adding National Temporary Differences Accounts
• Setting Up Scenarios
• Multi-GAAP Dimension: Overview
• Refreshing the Database
• Summary

Setting Up Pillar Two

• Objectives
• About Pillar Two
• About Pillar Two – Best Practices
• Assigning Entities in Scope for Pillar Two
• Assigning Entity Classification Types
• Working with the Pillar Two Entity Classification Form
• Setting Up Pillar Two Transitional Safe Harbor
• Configuring Pillar Two Automation Rules for TSH
• Setting Up Global Minimum Top-Up Tax Calculation
• Configuring Pillar Two Automation Rules for Global Minimum Top-Up
• Adding Pillar Two Accounts
• Configuring Covered Tax Automation
• Configuring Other Accounts Automation
• Configuring Safe Harbors Automation
• Managing Pillar Two Data Flow
• Summary

Managing Metadata

• Objectives
• Metadata Import and Export Overview
• Metadata Import File Structure
• Importing Metadata from a Local File
• Importing Metadata with Jobs
• Exporting Metadata to Local Files
• Creating Jobs to Export Metadata
• Managing Metadata with Smart View
• Data Integration Overview
• Data Integration Workflow
• Enterprise Data Management Overview
• Summary

Setting Up Automations

• Objectives
• About Automations
• Tax Automation Process
• Tax Automation Rules
• Data Source Dimension Rules
• Types of Tax Automation
• About Tax Automation Trace
• Setting Up National Tax Automation
• Adding National Tax Automation Rules
• Viewing National Tax Automation Rules
• Configuring National Tax Automation Rules
• Consolidating Tax Calculations
• Automating Net Operating Loss
• About CbCR Automation and Pillar Two Automation
• About Safe Harbors Automation
• Setting Up Return to Accrual Rules
• Configuring Return to Accrual Rules
• Verifying Calculation Status
• Running Consolidations
• Setting Up Tax Account Rollforward (TAR)
• Creating Metadata for General Ledger Columns
• Generating the Default Mapping
• Generating a Custom Mapping
• Mapping Book Accounts
• Running Consolidations
• Reviewing the TAR Form
• Configuring Current Tax Payable Automation
• Reviewing the TAR Use Case for Scenario
• Reviewing the TAR Use Case for TAR Form
• Reviewing the TAR Use Case for Adjustments
• Reviewing the TAR Use Case for Add CurrentExpensePriorYear
• Generating the Default Mapping in the TAR Automation Form
• Generating Custom Mappings
• Generating Custom Mappings: Set Exclusions for Current Expense
• Generating Custom Mappings: Set Current Expense Prior Year
• Running TAR Automation Rollover
• Copying Configuration for TAR Automation Rules
• Reviewing Current Tax Payable
• Reviewing TAR Journal Posting
• Summary

Migrating Artifacts and Data

• Objectives
• Migration: Overview
• Performing Snapshot Backups
• Selecting Artifacts and Running Migrations
• Importing Snapshots
• Reviewing Migration Status Reports
• Reviewing Snapshot Modification History
• Summary

Managing Data

• Objectives
• Data Load Overview
• Data Load Options
• Preparing the Load File
• Importing Data
• Exporting Data
• Copying Data
• Clearing Data
• About EPM Automate
• About REST APIs
• Summary

Managing Security

• Objectives
• About Cloud EPM Security
• About Single Sign-on
• About Predefined Cloud EPM Roles
• Tax Reporting Roles
• About Application-Level Roles
• About Access Control
• Managing Security in Access Control
• Managing Users
• Managing Groups
• Assigning and Unassigning Cloud EPM Application Roles to Users
• Assigning and Unassigning Cloud EPM Application Roles to Groups
• Generating Reports
• Viewing the Role Assignment Report
• Viewing the User Login Report
• Viewing the User Group Report
• Viewing Access Control System Reports
• Managing Access Permissions
• Assigning Dimension and Member Security
• Inheritance Options
• Precedence and Inheritance of Access Permissions
• Assigning Permissions to Navigation Flows
• Access Permissions to Dashboards, Infolets, Forms, and Rules
• About Valid and Invalid Intersections
• Valid Intersection Groups
• Valid Intersection Rules
• Invalid Data and Invalid Intersection Reports
• About Cell-Level Security
• Cell Level Security: Creating and Enabling
• Summary

Managing Forms

• Objectives
• Forms Overview
• Form Design Considerations
• Designing Forms
• Creating Forms
• Setting Up the Form Layout
• Setting Up Properties
• Display Properties
• Selecting Members
• Selecting Members Based on Relationships
• Setting Other Options
• Associating Rules with Forms
• About Smart Lists
• About Variables
• Navigation Forms
• About Entering Data in Forms
• Summary

Managing Dashboards

• Objectives
• About Dashboards
• Viewing Dashboards
• Dashboard Versions
• Converting Dashboards 1.0 to 2.0
• Designing Dashboards 2.0
• Dashboards Considerations
• Working with Tables in Dashboards
• About Supported Chart Types
• Creating Dashboards
• Summary

Managing Navigation Flows

• Objectives
• Navigation Flow Overview
• About the Default Navigation Flow
• Managing Navigation Flows
• Creating Navigation Flows
• Editing Navigation Flows
• Adding Clusters, Cards, and Tabs
• Adding Tabs to a Tabular Page
• Adding Clusters
• Organizing Clusters, Cards, and Tabs
• Validating Navigation Flows
• Summary

Consolidating Data

• Objectives
• About Consolidation in Tax Reporting
• Consolidating Data Process
• Consolidating Data
• Consolidating Data – Calculation Status
• About the Consolidation Dimension
• About Data Translation
• Translation to Reporting Currencies
• Exchange Rates: Overview
• Average and Ending Rates
• Historical Rates
• NIBT FX Override Rates
• Configuring Exchange Rates
• Setting Up Amount/Rate Override for Tax Accounts
• Configuring Historical Amount/Rate Override: Book Accounts
• Applying FX Rate Account to a Book or Tax Account
• Enabling Weighted Average
• Setting Up Calculated Weighted Average Rates for NIBT
• Setting Up Weighted Average FX Rate Override for Tax Expense
• Setting Up NIBT FX Override Rates for Tax Accounts
• Defining Calculated Weighted Average FX Rate for Tax Expense
• Setting Up Entity Average FX Rate
• Setting Up CbCR Override Rates
• About Ownership Management
• Setting Up Ownership Management
• Enabling Ownership Management
• Reviewing Ownership Settings
• Consolidation Methods: Overview
• Recomputing Ownership
• Importing and Exporting Ownership Data
• Copying Ownership Data
• Viewing Ownership Settings
• Setting Up Weighted Ownership
• Setting up National and Regional Parent Tax Calculations
• Configuring the ParentEntity Member
• Setting Up Tax Rates
• Consolidating at the Parent Level
• Viewing the Current Provision
• Intercompany Eliminations: Overview
• Setting Up Intercompany Eliminations
• Setting Up the Entity Dimension
• Setting Up the Account Dimension
• Configuring Intercompany Dividend Eliminations
• Creating Book Accounts
• Creating Global Automation Rule Placeholders
• Intercompany Dividends Examples
• Configuring Global Automation Rules
• Viewing Current Provision for Intercompany Dividend Eliminations
• Summary

Managing Approvals

• Objectives
• About Approvals
• Approval Process Overview
• Approval Setup Overview
• Enable Dimension Members for Approval
• About Approval Unit Hierarchies
• Creating Approval Unit Hierarchies
• Selecting Approval Unit Hierarchy Members
• Assigning Owners and Reviewers
• Assigning Approval Unit Hierarchies to Scenarios
• Importing and Exporting Approval Unit Hierarchies
• About Promotional Paths
• Managing Promotional Paths with Data Validation Rules
• Viewing Approval Unit Hierarchy Usage
• Starting the Review Cycle
• Locking and Unlocking Entities
• Enabling Notifications for Approvals
• Setting Up Email for Approvals Notifications
• Summary

Performing Rollovers and Copying Configurations

• Objectives
• About Rollovers
• Performing Global Rollovers
• Performing Rollovers by Entity
• Running Copy Configuration
• Running Copy Configuration by Entity
• Overriding Opening Balances
• Summary

Managing Jobs and Configuring Auditing

• Objectives
• About Jobs Overview
• Creating Jobs
• Managing Jobs in the Jobs Console
• Scheduling Jobs
• Configuring Audited Tasks
• Managing Task Manager Audits
• Viewing Audit Details
• Summary

Setting Up EPM Task Manager

• Objectives
• Task Manager Overview
• Task Manager Sample Task Flow
• Task Manager Terms
• Task Manager Setup Prerequisites
• Task Manager Setup Prerequisites – System Settings
• Task Manager Setup Prerequisites – Organizational Units
• Task Manager Setup Prerequisites – Alert Types
• Task Manager Setup Prerequisites – Integrations
• Manage Tasks and Task Types
• About Task Templates
• Creating Task Templates
• Managing Task Templates
• Adding Tasks to Templates
• Setting Task Properties and Parameters
• Specifying Task Instructions and Workflow
• Adding Task Questions
• Setting Task Viewers and Task Predecessors
• Applying Task Attributes and Working with Task Rules
• Managing Schedules
• Creating Manual Schedules
• Creating Schedules from Templates
• Creating Schedule Alerts
• Navigating to Tasks
• Generating Task Manager Reports
• Reviewing Operational Dashboards
• Summary

Managing Supplemental Data

• Objectives
• About Supplemental Data
• Reviewing the Supplemental Data Form
• Supplemental Data Form Process
• Creating Additional Dimensions
• Creating Collection Intervals
• Configuring Data Collection Periods
• Creating Collections
• Creating Data Form Templates
• Specifying Form Template Instructions
• Defining Form Template Sections
• Assigning the Workflow
• Adding Questions
• Defining Access
• Deploying Data Form Templates
• Importing Supplemental Data
• Viewing Deployed Forms
• Viewing Deployed Forms – Transaction Details
• Drilling into Tax Reporting Forms
• Viewing Supplemental Data Dashboards
• Reporting on Supplemental Data
• Summary

Setting Up Country-by-Country Reporting Automation

• Objectives
• About Country-by-Country Reporting
• Enabling CbCR Automation
• Parent Tax Calculation in CbCR
• Setting the Parent Entity for CbCR
• About CbCR Automation
• Configuring CbCR Automation Rules
• Setting Up Additional CbCR Automation Rules
• Setting Up Rule Mappings
• About CbCR Process
• Data Entry Overview
• Viewing and Entering Data in Data Entry Tables
• Viewing Summary Reports
• About Filing CbC Reports
• Risk Assessment Dashboard
• Viewing Calculation Status
• Setting Up Approvals for CbCR
• CbCR Scenarios
• Migrating Existing CbCR Data
• Running Consolidate CbCR and Translate CbCR
• Validating and Submitting CbCR Filing Reports
• Summary

Reporting on Tax Data

• Objectives
• Cloud EPM Reports Overview
• Reports Features
• Considerations
• Navigating Reports
• Report Security
• Designing Reports
• Designing Reports: Elements to Consider
• Designing Reports: Dimensions
• Designing Reports: Performance Considerations
• About Connections and Data Sources
• Report Components and Objects
• Creating Reports
• Report and Object Properties
• General Properties
• Layout Properties
• Report Designer Layout
• About the Report Data Point of View
• Adding Report Sheets
• Inserting Report Objects
• Adding Text Boxes
• Inserting Text Functions
• Inserting Images
• Adding Grids
• Grid Designer
• Setting the Grid POV
• Managing Grid Rows and Columns
• Grouping Data and Nondata Segments
• Formulas and Calculations in Grids
• Conditional Formatting, Text, and Suppression
• Zoom and Drill to Content
• Drilling Through to the Source
• Adding Charts
• Chart Designer
• About Shared Report and Objects
• About Shared Report and Objects: Shared Grids
• About Shared Report and Objects: Shared Charts and Text Boxes
• Considerations for Shared Reports and Objects
• Managing Report Objects
• Correcting Report Errors
• Viewing Reports
• About Books
• About Bursting
• Migrating Financial Reports
• Summary