Description of Each Standard Report

Planful provides the following system-defined reports:

Segment Hierarchy

Based on selected defined segments and hierarchies and provides detailed information on the contents of a segment hierarchy. For example, you might select Company as the segment and Management as the hierarchy. The results will include management rollup details for the company segment.

Segment Listing

Based on a selected defined segment and provides detailed information for the selected segment.

User Listing

Provides a listing of all users including their first name, last name, login, and status (active or inactive).

User Security

Provides detailed security privilege information for a selected user. This report offers a quick way to find out a user's reporting role, navigation role, and so on.

Capital Budget

Based on scenario, budget entity, and asset, asset category, purchase month, depreciation start month, and finance mode. The purpose of this report is to provide you with information on capital costs, budget, scope and so on.

Workforce Planning Budget

Based on scenario, budget entity and view, this report provides a detailed level of organization for budgets related to human resources and allows you to view Workforce details associated with a scenario and budget entity.

Staffing Summary

This report is based on Workforce Attribute selected for time, scenario and budget entity. It displays the headcount for each month and is calculated based on the number of positions starting each month.

In this example, there is 1 total Mr. X position starting in May for the 2017 year.

In this example, in California, there are total of two positions available in 2017. One position is available in May and the other in November of 2017.

Selections for report:

• Scenario - select one scenario to display data.

• Budget Entity - select one or more budget entities to display data.

• Time - select one or more years for time.

• Workforce Attribute - select the attribute and then choose the value you want to apply. For example, if you select Work State, select the CA value.

Template HR Budget

Based on scenario, budget entity, and template, this report provides all HR budget details by template.

Template Notes

Allows you to view all notes associated with a template in one consolidated location.

Workflow Status

Based on scenario and provides workflow status information, including in progress, forwarded, approved and finally approved details per entity.

Elimination Variance Report

Provides results of elimination entries that were posted during the Elimination process.

Natural Account Balances Validation

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 can be used to market a new product.

Balance Sheet

Lists all liabilities and equities for a scenario. A balance statement is a statement of financial position, which includes a full listing of balance sheet line items for a company for a specified time period.

Income Statement

Provides a statement of earnings, which includes a full listing of income statement line items.

Trial Balance

Lists all general ledger accounts in the ledger plus debit and credit information.

Trial Balance Detailed Report

Lists all general ledger accounts in the ledger plus debit and credit information by providing a detailed listing.

Trial Balance Summery Report

Lists all general ledger accounts in the ledger plus debit and credit information by providing a summary listing.

Budgeted Data

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.

You can see that the Budgeted Expense for Postage and Delivery 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 your budgeted data for all Capex items in all templates for a specified scenario and entity.

Filter and view report output based on month or scenario. In the example below, the filter is set to By Month.

In the example below, data in the report is displayed by month.

In this example, data is displayed by scenario.

Select up to 3 scenarios when you select View By Scenario. In the example below, 2016 Budget, 2017 Plan, and 2018 Target scenarios are selected.

Display report output based on Time. In the example below, 2016 and 2017 is selected.

Filter report output based on the Account dimension filter. In the example below, report data is displayed for the Asset account, for 2016 and 2017, the 1000 budget entity, the 2016 Budget scenario, and the data is displayed by month.

Subline Data

Run the Subline Data report to report on sublines for all templates for a selected scenario and budget entity. You can go into each template and view sublines, but this comprehensive report provides a simpler way to view the data in one central location.

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 > Templates > Template Setup.

In Practice

An example Subline Data report is shown below. You can filter by Scenario, Entity, View, Time, Template, and Line Name. You can view this report by Month, Quarter or Scenario. The report displays sublines for the 6308 Trade Shows account.

If you open a template in the Planning Control Panel for this scenario and budget entity, the 6308 account is displayed in the template and the L is highlighted indicating there is subline data as shown below.

Click L to launch the Subline page where you can see the same data in the report.

Optionally, filter by Template and Line Name for more granular reporting. Line Name displays the lines with sublines for the selected template.

View only those sublines for a selected template. The output below is a result of filtering on Template and Line Name.

In comparison, the output below is less granular as Template and Line Name is not filtered.

Variance is available as an option in the Subline Data Standard Report. If selected, both Scenario and Time dimensions are enabled in the filters in addition to Budget Entity. Up to 2 scenarios can be selected and multiple members can be selected for the time dimension.

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

• Capital Budget Analysis

• Budgeted Data

• Subline Data

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.

In Practice

1. Navigate to Maintenance > Reports > Standard Reports.

2. Select the Pay Plans Exception report.

3. Click More and select Deploy.

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

5. Run the report from the File Cabinet or within the Standard Reports screen.

6. After you click Run, select filters. You can 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 plans 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 for the HQHR Home Budget Entity and the 2016 Plan and 2017 Plan Elim Demo scenarios.