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

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.

    Here is an example of a CTA Detailed Report:

    

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

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.

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

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 - see second image).

Here is an example of a report output when the By Month view is selected and Entity is selected for Group By.

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.

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.

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.