Description of Each Standard Report

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.

Segment Listing

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

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

To learn how to run the CTA Detailed Report, click here.

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.

To learn how to run a user security report, click 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.

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.

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. 

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.

Select up to 3 scenarios when you select View By Scenario . You can also view output by Month or Quarter .

Display report output based on Time . For example, select years 2016 and 2017 is selected.

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

Use the Group By field to filter by Entity or Asset Category. This field is available no matter which View you select (By Month or By Scenario).

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

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.

To learn how to execute a Pay Plans report, click here.