Description of Each Standard Report
  • 11 Minutes to read
  • Dark
    Light
  • PDF

Description of Each Standard Report

  • Dark
    Light
  • PDF

Article summary

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.

The IDX (Index number) column is available in the Standard Report for all Segment Hierarchy. The IDX columns display the Index number associated with the member. You can use the IDX number in the Standard Report to create formulas in the report.

Note:
You must redeploy the Standard Report to view the IDX column.

Segment Listing

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

Note: 
The Segment Listing and Segment Hierarchy Standard reports support up to 25 user-defined attributes for each segment (Account, Entity, and other dimensions). Previously, only the first 10 attributes were displayed, but all attributes, up to 25, are now visible.

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.

Deploy User Security and Report Output

Administrators must deploy the report by accessing the Standard Reports page (Maintenance > Reports > Standard Reports).

  1. Navigate to Maintenance > Reports > Standard Reports.
  2. Select the checkbox next to User Security.
  3. Click Run.
  4. Select the user for which you want to view all security privileges, and click Run.

The following describes the fields on the User Security report output page.

  • Send Email: Open the Email page and email the report to one or multiple recipients.
  • User: Select a user and click Run to rerun the report for the newly selected user from the report interface itself.
  • Percentage list box: Select the percentage of the report to view. You can also select to view by page width or the whole page.
  • Select a format:
    • XML file with report data
    • CSV (comma delimited) – If you select this option, the Level names will not be included in the output.
    • PDF – Not recommended due to the number of columns this report generates.
    • MHTML
    • Excel
    • Tiff
    • Word – Not recommended due to the number of columns this report generates.
  • Export: Select this option to export the report in any format of your choice.
  • User Name: The name of the user for which you are running the report.
  • User Email: The email address for the user for which you are running the report.
  • Navigation Role: The role assigned to the user via the Navigation Role page. Navigation roles allow users to access specific navigation paths, which provides them with access to certain application pages and associated functionality. Learn more about navigation roles here.
  • Reporting Role: The role assigned to the user via the Add or Edit User Management page. There are two roles; regular user and reporting administrator. Learn more about the navigation role here. Learn more about reporting roles here.
  • Status: Indicates whether the user is active or inactive. Users must have an active status to access the Planful application.
  • Locked Status: Indicates whether the user is locked or unlocked. The user must have an unlocked status.
  • Authentication Mode: The way the Planful application authenticates the user when the user attempts to perform certain actions.
  • Support Role: The role assigned to the user via the Add or Edit User Management page. The number of available Administrator support roles is based on your Service Level Agreement (SLA). Select whether the user you are adding needs an Administrator support role or a User support role.
  • Task Manager Role: The role assigned to the user via the Add or Edit User Management page. There are two roles you can assign for Task Manager; Regular User and Admin User. Learn more about Task Manager Roles here.
  • Created Date: This column records the date and time when the user was created.
  • Created By: This column indicates the user who created the entry/user.
  • Modified Date: This column records the most recent date and time when the user was modified.
  • Modified By: This column identifies the user or system entity that last modified the user.
  • Level: The report displays entity hierarchy security privileges for up to 15 levels. If the user has security privileges for more than 15 levels, an alert message will be displayed while generating this report.
  • Approval Role: The role is assigned to the user via the Add or Edit Approval Role page. Approval roles allow users to perform budget activities for an entity. Users with varying levels of user responsibility for budget entities should be set up using Approval Roles. For example, when a user has access to two entities (A and B), but has HR responsibility for entity B only you can restrict the user to only view specific data based on HR access for the approval role assigned for the entity. Learn more about approval roles here.

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.

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. To learn how to run a Capital Budget Analysis report, click here.

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 HR details associated with a scenario and budget entity.

Staffing Summary

This report is based on HR 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.

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.
  • HR Attribute - select the attribute and then choose the value you want to apply. For example, if you select Work State, select the CA value.
Note:
Budget Entity and Template security are retained across all standard reports. All amounts are displayed in local currency for the Budget Entity. The default format of the report is applied based on the user location. Default formats include number format, thousand separator and decimals.

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 Summary 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. 

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.

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.

Make sure you 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 > Templates > Template Setup).

In Practice

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

imagea3jz123b.png

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.

imagea3jz123c.png

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.

imagea3jz123hz1239uz12367101238.png

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

imagea3jz123hz1239uz12367101239.png

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

imagea3jz123hz1239uz123671012340.png

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

IMPORTANT!
If you have already deployed the Subline Data report prior to June 18, you must redeploy it to take advantage of variance reporting. Additionally, updates to the following reports will be effective only after they are redeployed:
  • 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.

Note:
The Pay Plans Exception report must first be deployed to the File Cabinet in order for users to run the report.
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.

    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.

    imagea3jz123hz1239uz12367101236.png

  8. Click Run to execute the report. 


CTA Set and CTA Detailed Report

Accounting principles mandate that when translating financial statements to a reporting currency, the closing rate for all Balance Sheet accounts is used, as well as the weighted average rate for Profit and Loss Accounts, and historical rates for Historical Accounts and Retained Earnings. After translating using these principles, if the books do not balance, then a plug account can be posted to a balancing account called Cumulative Translation Adjustment (CTA) to balance the books.

The balance posted to the CTA account is also known as unrealized gains or losses due to currency fluctuations. The balance posted to the CTA account is an accumulation of the FX gains\losses generated by multiple accounts in the natural hierarchy.

In Planful, a plug account must be specified for posting the unrealized gains or losses during Consolidation Setup. Consolidation Setup (discussed in the Consolidation Admin Guide ) is also where you specify the rollup accounts for Total Assets, Total Liabilities and Total Equity. For converted currencies such as; common currency, interim currency and reporting currencies, the system calculates Total Assets - (Total Liabilities + Total Equity). If the results of the calculation does not equal zero (unbalanced books), the difference is posted to the CTA plug account to balance the books. Using this method, Planful doesn’t provide the account detail for the balance posted to the CTA account. You can overcome this using the functionality called CTA Sets (discussed in the Consolidation Admin Guide under the CTA topic).

Note:
If it is a hyper-inflationary company, for the accounts selected in the CTA sets mapped to “Target Income Statement” will be considered.
Note:
Account detail for the CTA balance is provided in a reporting currency and not in common or interim currencies.
In Practice
  1. Navigate to Maintenance > Currency > CTA Sets.
  2. Click New (Add button).
  3. Enter a title and description.
  4. Specify a Base Rate. Typically this base rate has to be the closing rate of the period such as End of the Month rate (EOM).
  5. Click Add Accounts and select the accounts that contribute to the CTA balance. Typically these are historical accounts such as Common Stock, Retained Earnings, and PPE accounts.
  6. Under Target CTA Setup , specify the segment combination of the CTA account. This might be the same CTA account specified in Consolidation Setup.
  7. Save the CTA Set. Create as many sets as required.
  8. Navigate to Maintenance > Hierarchy . Select the Reporting dimension and click Show .
  9. Create a new Reporting Currency (See documentation on how to create Reporting Currency in the Currency Admin Guide ).
  10. Select a leaf level member of the Reporting Currency in Hierarchy Management. The Properties pane appears. Under Segment Properties, select Account Based for Calculation Type. Select other properties as required.
  11. Select Overwrite default CTA.
  12. Under CTA Sets , select the sets created earlier (steps 1 - 6) based on which accounts for FX gains\losses. Save.
  13. Run the Consolidation process for the Reporting Currency.
  14. Navigate to Reporting > Standard Reports and open\run the CTA Detailed Report (which must be deployed by an Admin user).
  15. Select a Scenario, Period Range, Account rollup, Company, Reporting currency and the CTA set and run the report.
  16. For the accounts selected in the CTA set, the report provides the difference between the local currency balances converted using the currency type specified against the account versus the currency type specified in the CTA set definition.

Was this article helpful?