Standard Reports

Planful delivers presentation quality financial reports, budget workflow and administrative reports. These standard reports are organized into two major types:

• System Reports -These reports are available in all customer applications and cannot be edited. They are generated by leveraging the reporting categories maintained against each of the financial dimensions (Chart of Accounts).

• User Reports - These reports are published by uploading and deploying new reports and can be organized under Report Groups that you define.

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.

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

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:

    

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

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.

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.

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.

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.

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

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

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

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

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.

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.

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

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

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

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

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.

Deploy Standard reports to make them active and available to users. Once reports are deployed, Administrators must grant user access. Dimension security functionality is applicable to standard reports. Users will only generate standard reports for entities/data to which they have access either by their assigned Budget Approval Role or within Dimension Security.
Task 1 - Complete the following steps to deploy a standard report:

1. Navigate to Maintenance > Reports > Standard Reports .

2. Verify the Standard Reports tab is selected.

3. Select the appropriate reports.

4. Click the More list-box and select Deploy Reports . Select a place to store the reports within the File Cabinet.

5. The progress bar at the bottom of the screen will indicate when deployment is complete. Deployed reported have an Active status.

Task 2 - Complete the following steps to provide user access to a report:

1. Navigate to Maintenance > Admin > User Management .

2. Select a user and click More .

3. Select Report Access.

4. Select the reports deployed in task 1.

Optionally, you can provide access to a group of users by completing task 3 instead of task 2.
Task 3 - Complete the following steps to provide group access to a report:

1. Navigate to Maintenance >Admin > User Management .

2. Select a user group and click More .

3. Select Report Access.

4. Select the reports deployed in the task 1.

Enable or disable repeat labels for the following Standard Reports:

• Subline Data

• Budgeted Data

• Capital Budget Analysis

• Staffing Summary

Turning repeat labels on removes the subtotals in the report output. This is by design as the intent of having repeat labels enabled is to export the report and perform additional manipulations to the exported data.

What Are Labels

Labels in report output are for informational purposes. For example, the Asset Category label (i.e. Buildings/Leasehold improvements) for an entity (HQEXEC) will look as shown below when the Capital Budget Analysis standard report is executed.

In the example below, Repeat Labels is not enabled.

How Repeat Labels Work

Repeat labels provide you with another way to view report output for further manipulation. Using the image above, the same report output with repeating labels turned on would look as shown in the table below. Information is shown for every line in the example below whereas, in the image above, the entity, asset category, and asset fields are grouped according to account.

It is important to note that when repeat labels are ON, there are no totals in the report output. This is by design so that you can export the report and perform further manipulations.

In Practice: Enabling and Disabling Repeat Labels is Standard Reports

To disable (turn off) repeat labels:

1. Navigate to the standard report in which you want to enable or disable repeat labels (Maintenance > Reports > Standard Reports ). In the example below, the Capital Budget Analysis report is shown.

2. Click Repeat Labels Off (the field toggles to Repeat Labels On ).

3. Run the report.

   

   When repeat labels are Off, there are totals/subtotals in the report as shown above.

   To enable (turn on) repeat labels:

4. Navigate to the standard report in which you want to enable or disable repeat labels (Maintenance > Reports > Standard Reports ). In the example below, the Capital Budget Analysis report is shown.

5. Click Repeat Labels On (the field toggles to Repeat Labels Off ).

6. Run the report.

   

Planful delivers system-defined data sources to access reporting cubes and the application database. With Data Sources, you can specify parameters to import or exchange data with a SQL data source.

Access the Data Source page by navigating to Maintenance > Reports > Standard Reports and click the Data Sources tab.

Navigate to Maintenance > Reports > Standard Reports and click the Data Sources tab. Click Add to create a data source. On the Add Data Source page, the following fields are shown:

Server Type

Select from one of the two types of supported servers; Microsoft SQL Server or Microsoft SQL Server Analysis Services.

Server Name

Enter the name of the server you areconnecting to. The instance name must be correct and SQL Server must be properly configured to allow remote connections.

Database Name

Enter the name of the source database.

Authentication

• An Authentication allows you to connect to a SQL Servers. Authentications are required to access data sources.

• SQL Server Authentication is supported by Microsoft SQL Server.

• Windows Authentication is supported by Microsoft SQL Server Analysis Services.

User Name/Password

Specify a user name for the database connection when you are using SQL Server Authentication. Provide the password for the database connection when you are using SQL Server Authentication.

Group reports for categorization purposes. For example, group all budget reports, consolidation reports, and so on.

Access the Report Groups page by navigating to Maintenance > Reports >Standard Reports and click the Report Groups tab.