Working with Reports in Structured Planning

Reports can be run from the Planning Control Panel or the File Cabinet. 

Budget Entity Status Report

The Budget Entity Status report allows users to quickly retrieve a summary status for all budget entities they have access to. This report will provide information directly related to workflow status and budget entity status. It also allows users to filter entities based on status, such as forwarded and approved.

How to View Budget Entity Status Report?

1. Navigate to Structured Planning to open the Planning Control Panel 
2. Select a scenario and a budget hierarchy entity rollup or leaf member.
3. Click the Status Report option on the toolbar. The Status Report appears.
   
   

4. Once the Status Report appears, click members in the hierarchy to view information. If desired a different scenario can be selected from this screen. 

   
   

   Users can also see how many have not been started. Click Not Started for details.

   
   

   Click Forwarded to view the entities that are in a forwarded state as shown below.

   
   

   Users also perform actions on entities and templates from this report; the same actions that can be performed from the Planning Control Panel.

   

How to Report Employees Budgeted to a Specific Department?

1. Navigate to Structured Planning to open the Planning Control Panel 

2. In the Right pane click the Reports tab.

3. Click Workforce Planning Budget.
   

4. For View select GL Account View and click Run.
   

How to Report on the I/P Comp Items Tab in the Workforce Planning Template?

1. Navigate to Structured Planning to open the Planning Control Panel 

2. In the Right pane click the Reports tab.

3. Click Workforce Planning Budget.
   

4. Run the Workforce Planning Budget standard report to view data by Compensation Item.
   

Trial Balance Report

Display all debits and credits for an organization.

Workflow Status Report

View all Budget Entities by completion status. The status is determined by the actions performed in the Planning Control Panel for each budget entity, which can be viewed in standard reports.

• In Progress - the budget entity item is in a work in progress state. A red checkmark is the indicator

• Finally Approved - workflow for the item is complete. A green checkmark is the indicator

• Approved - initial approval is complete for the forwarded item. A blue checkmark is the indicator

• Forwarded - budget entity item has been forwarded for approval. A yellow checkmark is the indicator

Balance Sheet Report

View balance sheet data and drill down based on a dimension. Expand and collapse to drill down.

Capital Budget Report

Report on capital assets and expenditures by budget entity. Report by:

• Asset Category - report based on asset categories set up using the Add Asset Category page

• Budget Entity - report per budget entity on assets, asset categories, finance modes, purchase month, and depreciated start month all in one output

• Finance Mode - report based on the finance modes set up using the Add Finance Mode page

• Deprecation Start Month - report based on the month you started depreciating the asset(s)

• Purchase Month - report based on the date the asset(s) was purchased

• Asset - report based on assets set up using the Add Asset page

Template Notes Report

View all notes associated with a selected template. Template notes are entered on the Template Input page.

Workforce Planning Report

View Workforce budget details by compensation item, compensation item and position, GL account, or compensation item summary. Select report options and email or export the results. Select from the following for View:

• Compensation Item View - When selected, a prompt appears to choose how the compensation item will be displayed in the report. Options include displaying the name, code, or label, which combines both code and name. This report shows compensation items on a monthly basis.

• GL Account View - Provides a report based on employee position. This view is important when the compensation for an employee is divided across budget entities.

• GL Account Detail View - Provides a report on GL Account Detail data for Workforce Budgeting.

• By Compensation Item and Position - This report displays compensation items based on selected positions. For example, view all compensation items for the Account Director position.

• Compensation Item Summary - When selected, a prompt appears to choose a fiscal year, decide on decimal places in the report output, and select how the compensation item will be displayed. Options include name, code, or label, which combines both code and name. This report includes all compensation items for the chosen budget entity and fiscal year.

• By Compensation Item - When selected, users will be prompted to select a Compensation Item to report on. This view provides a report that includes compensation items by month.

• Notes - Report on template notes (for an employee position for example).

• Natural Account View - Natural accounts contain transaction-level data. These types of accounts are used for revenues, expenses, assets, liabilities, and equity type accounts. For example, a natural account may be used to market a new product. Natural accounts are segment members of hierarchies.

Budgeted Segments Report

View the detailed budget page-level segments for Block and Revenue planning templates. This report displays all individual combinations of page-level segments along with their budget data. To filter by Account, IC Segment, or Currency, enter the relevant criteria.

Budgeted Data Report

Report on planned budgets for a scenario and entity. View the data by month and time. This report provides a comprehensive look at all budgeted data for all templates mapped to an entity. An example of report output is shown below.

Open a template from the Planning Control Panel for the scenario and entity.

Users can see the data was pulled from the template mapped to the entity and scenario for which the report was run.

Capital Budget Analysis

This report provides a comprehensive look at budgeted data for all Capex items in all templates for a specified scenario and entity.

Subline Data

Run the Subline Data report to view sublines for all templates for a selected scenario and budget entity. Users can go into each template and view sublines, but this comprehensive report provides a simpler way to view the data in one central location. Make sure to deploy the report to make it available in the File Cabinet for users.

Additionally, map the report to templates to run it from the Template Input interface. Mapping reports to templates is done on the template add/edit screen (accessed by navigating to Maintenance > Planning Templates > Template Setup. Columns displayed in the report are:

• Template

• Line

• Subline

• Entity

• COA Segments

• Scenario - two scenarios are selected to calculate variance (displayed same order as they are selected by the user from the hierarchy)

• Time

• Variance (for each period)

• Total Variance - variance is calculated as the difference between the 2 scenarios (scenario 1 - scenario 2) for each period applied in the report

How to Access Subline Data?

1. Click on Structured Planning to open the Planning Control Panel.
2. Select a Scenario and Entity, then open the Template in either Input or View mode.
   
3. Click L to launch the Subline Template.
   
   
4. Users can now view the details of the selected line.
   
   
5. Optionally, to refine your view, click on Grid and select Show Data Filter.
   
   
6. Filter by Template and Line Name for more detailed reporting. The Line Name will display lines with sublines specific to the selected template, allowing it to focus solely on those sublines. The output shown below results from filtering by Template and Line Name.
   

Pay Plans Exception

The Pay Plans Exception standard report shows the employees that are not mapped to a selected Pay Plan for a selected Scenario and Home Budget Entity. It provides a quick and easy way to examine employee pay plan information.

How to Run Pay Plans Exception Report?

1. Navigate to Maintenance > Report Administration > Standard Reports.

2. Select the Pay Plans Exception report.

3. Click More and select Deploy Reports.

4. Select a folder in the File Cabinet to deploy the report to. Click Save.

5. Run the report within the Standard Reports screen.

6. Click Run and select filters. Select up to 3 scenarios on the Scenario Hierarchy popup (shown below). 

   
   

   For Budget Entity (home budget entity), select as many entities as needed. For Pay Plan, select as many pay plan exceptions as needed.

   
   

7. For Show Employees, select to include (mapped to selected pay plans) or exclude (not mapped to selected pay plans) the selected Pay Plans (the default is to Exclude) for the selected scenarios and home budget entities.

   
   

8. Click Run to execute the report. The report output shown below displays employees mapped to the Equal Monthly, Work Days, and Bi-Weekly pay plan.