- 15 Minutes to read
- Print
- DarkLight
- PDF
Working with Financial Package
- 15 Minutes to read
- Print
- DarkLight
- PDF
Overview
Financial Package utilizes content from sources internal and external to Planful to generate multi-page reports that can be distributed across your organization.
Financial Package allows you to gather and organize content from various sources and generate output into a single Microsoft Word or Microsoft PowerPoint document.
Access an existing Financial Package report in the File Cabinet or add a new one by navigating to the File Cabinet, selecting Add, and then selecting Financial Package.
How to Set Up Financial Package?
- Click Reports.
- From the reports home page, click Add from the top menu.
- Select Financial Package, and the financial package home page appears. It contains three panes by default.
- Left Pane - It displays the groups and sections hierarchy created within a financial package. You can drag and drop the desired section or group to rearrange this hierarchy. The center pane displays the fields based on the hierarchy selected here.
- Center Pane - The center pane displays the properties of the hierarchy selected in the left pane. You can configure these properties as per your requirements and define the layout of each section or group. The center pane mainly consists of two sub-sections; Details and Content.
- Right Pane - Based on the center pane configurations, the right pane displays various options needed to configure the properties in the center pane. For example, if you choose Content Type as Dynamic Reports, the right pane displays the file cabinet from where you can select the desired dynamic report.
- Fill in the fields related to the financial package available in the Details and Content subsections in the center pane and Save the package. You can add sections, groups, or variables to a financial package only after saving the package.
- You can use the Add (plus icon) on the top menu of the financial package home page to add a new section, group, or variable to create a hierarchy within the package.
- Once all the details are added, change the Status toggle from In-progress to Complete.
Top Menu Options
Top menu options:
Add
Add section children, group children, and variables to create a reporting hierarchy.
New Group Child - Adds a folder under the selected folder. Organizes sections and provides various options in the Properties pane.
New Group Sibling - Adds a folder as a sibling to the selected folder. Organizes sections and provides various options in the Properties pane.
New Section Child- Adds a section as a child to the selected folder. Provides more options in the Properties pane.
New Section Sibling- Adds a section as a sibling to the selected folder. Provides more options in the Properties pane.
New Variable - Add a new variable to use in the creation of the report. Enter the name of the variable, and a description, and select a variable type.
Copy
Copy the active section or group (not the entire Financial Package report). Enter a code and name for the new section or group. Select the folder where you want the section or group to be located.
Preview
Preview a Financial Package section or group without generating the entire Financial Package report. When you click Preview, you will receive an option to open or save the section or group you want to preview. The Preview is generated in Microsoft Word or PowerPoint based on the Document Type selected in the Financial Package Properties pane.
How to Generate a Financial Package?
To Generate a Financial Package report, perform the following steps:
- Save the Financial Package report with updated changes.
- Click Generate from within the Financial Package interface to open the Financial Package Generate page. Determine where you want to place the output file and what kind of notification you want.
Email notification - Add email recipients to send a copy of the report.
Attach generated document to email - Include the report output in the status notification email.
Save to File Cabinet - Save the output document to a folder in the File Cabinet.
- Click OK on the Financial Package Generate page. A message will be displayed indicating that the Financial Package document has been created successfully. Click the link provided in the message to download the created Financial Package document.
Save - Save the file to your local system or a shared file system.
Open - Launch Microsoft Word (if not previously open) and render the Financial Package Output file. You will be prompted to save to a local or shared file when you close the document.
Cancel - Return to the Financial Package Report within the File Cabinet.
Apply POV
Select this option to apply or remove Point of View (POV). You can modify the page level settings to display specific dimension members. If you apply the Point of View (POV) setting to a dimension and save the report, the applied POV setting is retained when you navigate to another page or log in to the application the next time.
When you open a shared report with POV settings defined by another user, the report is displayed with the applied POV setting.
Left Pane
Variable Type
Text - Specify a text value for the variable and open the Parameters pane.
Member - Specify the value of the variable with a dimension member and open the Parameters pane.
In the Parameters pane, select a Reporting Area where you want the variable defined.
Select the Dimension where you want the variable defined.
Expand and collapse the tree structure to find the variable member.
Click on the member in the tree structure to populate the Member field in the Properties pane.
Click Save.
Data - Open the Data field to select data from a dimension intersection to populate the variable value. You can also format the data.
In the Parameters pane, select a Reporting Area to view associated Dimension information.
Expand and collapse the tree structure to find the variable value to populate the Data field.
Click on the member in the tree structure to populate the Data field in the Properties pane.
Click Save.
Associate a numeric value with the variable and open the Content pane and select a format.
Number - Indicates and applies a numeric value to the variable.
Currency - Indicates and applies a currency symbol (such as $) to the variable value.
Percentage - Indicates and applies a percentage symbol (%) to the variable value.
Decimals - Select the number of decimals to associate with the variable value.
Amount Format - Format the variable amount in tens, hundreds, or thousands.
Import
Import already defined variables from another Financial Package report and open the Import Variables dialog page.
Financial Package - view existing Financial Package reports with variables.
Check All - import all available variables. Or, select the checkbox located next to a variable to select the variable for import.
Click OK.
Center Pane
The node selected in the Reports pane determines the display of the Properties pane. The main sections in the center pane are as follows:
Details
Code - Enter a code, which will appear in the Report pane.
Due Date - Click the calendar to select the Due Date. The Due Date represents the completion date for the report, group, or section, and controls the status (for information purposes).
Assigned To - Add users who can add new sections under groups and are responsible for section-level completion.
Content Type - Select a content type, which determines the type of content within the report. The content type selection determines subsequent content options, including the Parameters pane (right).
Content
Report Folder - Locate the File Cabinet folder to identify where the report will reside.
Owner - The owner of the report is the person who created the report by default.
Participants - Locate the required list of users who need to access and contribute to the report. Subsequently, the Assigned To field within groups or sections retrieves the list of participants defined here.
Template - Click Browse to select a *.dot file (Microsoft Word Template) or *.dotx file. Financial Package functionality allows you to create a template (with header/footer, watermark, logos, page numbers, text styles, for example) in Microsoft Word and apply it to a Financial Package Report.
The fields below are available for a new section child:
Table of Contents - Select to automate a table of contents and page numbering based on the document structure. If you want a selected group or section name to appear in the table of contents and as a header within the Microsoft Word document, select this checkbox.
Page Break - Insert page breaks, which will occur after the section or group.
Orientation - Control page orientation by section. Select Portrait or Landscape.
Shrink to Fit - Shrink report contents to fit page specifications.
Report Display in Output:
Table - Select Table to insert the Dynamic Report as an object within the Financial Package report, which allows you to double-click to edit report details. Report Display in Output is not available when Shrink to fit is selected.
Image - Select Image to insert the Dynamic Report as an image in the Financial Package report. Images cannot be edited. Selecting Image opens Header & Footer Display Configuration.
Header & Footer Display Configuration: Allows you to have repeating header and footer details on each page of your Dynamic Report output in a Financial Package report.
Header & Footer section – Select to have the header and footer details displayed on each page of the Dynamic Report in the Financial Package output, which can be Microsoft Word or PowerPoint.
Rows – Select to have the header and footer details displayed only once for the entire Dynamic Report in the Financial Package output. The header will be displayed on the first page of the Dynamic Report and the footer on the last page of the report. This is similar to the way Financial report output is displayed.
Content Type
The Content Type selected determines the output on the right pane.
Text - Add text content to your report. Click Search to open the Text pane. The Text pane resembles a Microsoft Word document, enter text and modify as desired. Formatting options are preserved.
Default options are used as well as the order of precedence when you have a template, text editor change, or default value. Consider the matrix below and the various scenarios presented.
| No template. No change in text editor. | No template. Change in text editor. | Template assigned. No change in text editor. | Template assigned. Change in text editor. |
Word | Microsoft Word default options are used. Font Family - Calibri Font Color – Black, Text 1 Font Size – 12 pt Bold – not selected Italics – not selected Underline – not selected | Change in text editor applies to Financial Package output. | Template definition is used. | Change in text editor overrides template and applies to Financial Package output. |
PowerPoint | Microsoft PowerPoint default options are used. Font Family - Calibri Font Color – Black, Text 1 Font Size – 32 pt Bold – not selected Italics – not selected Underline – not selected | Change in text editor applies to Financial Package output. | Template definition is used. | Change in text editor overrides template and applies to Financial Package output. |
Document - Add a document and enable the File field. Click Browse and locate the document on your machine, a shared drive, or within the File Cabinet, and click Open to insert the document path in the File field. Supported document types are Microsoft Word and Microsoft Excel.
Dynamic Report- Add a Dynamic Report to your Financial Package and click Search to open the Dynamic Report pane. Use the File Cabinet structure to locate the report. The selected Dynamic Report is reflected in the Dynamic Report field in the Properties pane. Print Setup selections for a Dynamic Report are applied to Financial Package reports. For example, you have a Content Type of Dynamic Report associated with a Financial Package Section when you preview or generate the Financial Package report, the print settings created for a Dynamic Report are retained in the output.
The Print Setup for Dynamic Reports is accessed by clicking Output and selecting Print Setup to open the Print Setup dialog page.
Snapshot - Select to add a snapshot to your report and click Search to open the Snapshot pane to search for snapshots. Click on the desired snapshot to update the Snapshot field in the Properties pane.
Agenda - Similar to a table of contents. The Group sections added to a Financial Package report when a PowerPoint Presentation is selected are added to a bulleted Agenda slide. To add Group sections to an Agenda slide, select the Slide Title Content Property.
Excel Add-In- Financial Package Word documents support the selection of a report generated by the Excel Add-In provided all connections are removed before adding the Excel Add-In report to the Financial Package report. The supported extension is XLSX. Financial Package PowerPoint documents support a report generated by the Excel Add-In with or without connections. Supported extensions are XLS and XLSX. Connections for the Excel Add-In report cannot be removed when saved in XLS format.
Document Type
Select Microsoft Word or PowerPoint Presentation
Supported versions of Microsoft PowerPoint are 2003 and 2010. You can upload a PowerPoint template to use when generating the output format loaded using the Template Property for the Financial Package Report. Supported versions of templates are:
PowerPoint Presentation (*.pptx)
PowerPoint 97-2003 Presentation (*.ppt)
Microsoft PowerPoint Specific Properties
Microsoft PowerPoint presentations are quite different from Word documents and therefore the design of PowerPoint presentation document types requires updated properties. The following sections describe the PowerPoint-specific properties and tips for using them most effectively.
Report
When PowerPoint Presentation is selected as the Document Type, the available content types are updated to support the creation of PowerPoint presentations. The supported content types for PowerPoint presentations are the following:
Agenda
Custom Graph
Document – Supported formats are .xls, .xlsx, .jpg, .jpeg, .gif
Dynamic Report
Snapshot
Text
Agenda
The Agenda Content Type replaces the Table of Contents (TOC) content type found in Microsoft Word Document Types. The Agenda is constructed similarly to the TOC. The Group sections added to a Financial Package report when a PowerPoint Presentation is selected are added to a bulleted Agenda slide. To add Group sections to an Agenda slide select the Slide Title Content Property. The Agenda slide can be renamed by using the Code property located under Details. Consistent with how users can update the titles of other sections, the Agenda type section can also be renamed.
Document
For the Document Content Type, Microsoft Word documents are not supported when PowerPoint Presentation is selected.
Text
Creating slides in Microsoft PowerPoint using the Text Editor in Financial Package ensures a consistent design and output environment. The following lists the supported formatting options:
Default PowerPoint font size is 32 pt unless overridden with a template or specific selections in the text editor.
Bold, italics, underline, font color, font family, font size selections
The limit for the number of indents made for a single bullet is 8. Any indents that exceed 8 will be rounded to the 8th indent.
Text that is not bulleted in the text editor will display as not bulleted in PowerPoint output.
Different bullet formats (solid circle, hollow circle, square, for example)
Group
If Slide Title is selected, the name of the group is used as the PowerPoint slide title. Group sections are handled as Title type slides and therefore the appropriate style will be applied in the generated PowerPoint presentation. The group is added to the Agenda slide if an agenda has been added to the Financial Package report. If Slide Title is not selected then the group is not included in the output. If there is an agenda slide, the group does not appear in the agenda bulleted list.
Section
When the Slide Title is selected, the name of the content type is used as the slide title in the generated PowerPoint presentation.
For Text content type, you can use the horizontal ruler to create slide breaks in the text editor, which is reflected in the PowerPoint presentation. For example, you can create two slides with bulleted lists of information as follows:
Q1 Financial Results Analysis
North America
EMEA
APAC
Q2 Forecast Preview
North America
EMEA
APAC
Rather than creating two different sections with a Text content type, use the horizontal ruler to act as a slide break. So, if you created the text content type, then two slides would be created in the PowerPoint presentation. The first slide would discuss Q1 Financial Results and the second slide would discuss Q2 Forecast Preview.
Q1 Financial Results Analysis
North America
EMEA
APAC
Q2 Forecast Preview
North America
EMEA
APAC
If Slide Title is selected, the name of the Text Content type is used for all slides included in the text editor. You can provide different subtitles for the first line of the slide before the bulleted list as displayed above.
Generated PowerPoint Presentation
The following slide types are used when generating a PowerPoint presentation, which can be viewed by reviewing the PowerPoint Layout for the template used for presentation creation.
Financial Package Report Slide – Title Slide
Agenda – Title and Content
Group – Section Header
Section – Title and Content
Status
Section / Group Status
Use the status bars to manage the status of a section or group.
Click to return the item to a status of In Progress.
Click to complete the item, which displays a checkmark next to the completed section or group.
The status of a report, group, and section is shown on the report hierarchy. The status at the bottom of the page is a legend that does not change.