Table of Contents
In Planning Maestro, the Planning module enables you to review, add, edit, and delete budgetary data. This module includes five applications: Operating Expenses, Revenue, Personnel, Drivers, and Adjustments.
Each of these applications has a similar structure:
- A table or “working screen” of Data Projections (line items) with rows, columns, and filters you can use to customize your view.
- A Properties pane that enables you to determine dates, descriptions, amounts, schedules, and other information about this Data Projection.
- A Details pane that shows how each Data Projection affects your Income Statement, Balance Sheet, and cash flow.
This document shows you, a Planning Maestro user, how to navigate the Planning applications (Operating Expenses, Revenue, Personnel, Drivers, and Adjustments) to customize your view and review and edit budgetary data.
Please Note: The Operating Expenses, Revenue, Personnel, Drivers, and Adjustments pages each have different fields and labels, especially for their Properties panes. This document uses the Revenue application as an example and focuses on features all applications have in common.
Reviewing Data Projections (Line Items)
The Operating Expenses, Revenue, Personnel, Drivers, and Adjustments pages are designed as a table or “working screen” with Rows, Columns, and Filters.
Rows, Columns, and Filters help you customize your view and organize this table to:
- View the Data Projections you need to see at a given time.
- Hide information you do not need to see at a given time (to make it easier to navigate).
When you add budgetary Data Projections to this page, you can use the Filters to see Data Projections associated with various Dimensions (building blocks of your budget, such as departments or account numbers).
Customizing Your View
The Filters work because each Data Projection you add to a Planning application is unique for its:
- Transaction type (Operating Expenses, Revenue, Personnel, etc.).
- Its Name.
- The Dimension Member it is associated with in each of your Dimensions. Each Data Projection’s associated Dimensions are filters you can use to show certain Data Projection on the page.
Example: An Operating Expense Data Projection named “New employee swag” is associated with the following Dimension Members:
- The Benefits GL Account from the Account Number Dimension.
- The 2022 Version from the Version Dimension.
- The Human Resources Entity from the Entity Dimension.
- The Training Program from the Program Dimension.
- The default Member for other Dimensions.
When you filter Data Projections, you can choose to see Data Projection associated with certain Dimension Members (one department, one Version, one program, etc.).
To customize your view of this page, review the current setup of Dimensions in the Rows, Columns, and Filters at the top.
- Rows – The items listed under Rows are the headings of the columns on the left side of the table below. Items in Rows have Data Projections associated with all their Dimension Members displayed in the table.
Example: If you have Name and Account Number under Rows, then Name and Account Number are the first two columns of the table below. If you add your Product Dimension to Rows, items associated with all products appear in the table (instead of Data Projections associated with just one product).
- Columns – The only item listed under Columns is Default [Time], which sets the headings of the columns on the right side of the table. Default [Time] controls this page’s calendar, or which years and periods (months) you see in this table.
- Filters – The items listed under Filters are Dimensions which show only one Dimension Member at a time. You can filter these Dimensions to determine which information appears in the table (for example, which Version you want to view).
Example: If you have Dimensions named Product, Entity, and Customer listed under Filters, you can filter those Dimensions to show Data Projections associated with one product, one entity, and one customer at a time. If you drag these Dimensions from Filters to Rows, you can see all products, all entities, and all customers in the table, and Product, Entity and Customer columns appear in the table to show which product and customer each Data Projection is associated with.
Please Note: If you have more Dimensions in the Filters section than the page can display, click on the Arrow ( ) to see the rest of the Dimensions you can add to the table or use to filter your data.
The Dimensions in the Filters section display one Member at a time. Only Data Projections associated with that Dimension Member appear in the table.
Example: When your Version Dimension is in the Filters section and is filtered to show only your Actuals Version, only Data Projections from your Actuals appear on this page.
Step 1: To see Data Projections associated with a certain Member of one of the Dimensions in Filters, click on the arrow ( ) on the right side of the Dimension.
Please Note: For detailed instructions for filtering Dimensions, see Filtering in Planning Maestro.
Adding Columns to the Table
You can add a column from the Filters section or from the Properties pane on the right (which is explained further in a following section). Moving an item from Filters to Rows:
- Enables you to see all the Members for that Dimension in the table, instead of just one Member (for example, Data Projections associated with all departments, instead of line items just associated with the Human Resources department).
- Adds that Dimension as the column in the table.
Example: You have a Dimension named Program which contains all your companies’ programs. When that Dimension is in the Filters section and filtered to show Program A, only Data Projections associated with Program A appear in the table.
When you move the Program Dimension from Filters to Rows, you are no longer filtering for one program: Data Projections associated with all programs appear in the table, and a Program column in the table shows you which program each Data Projection is associated with.
Please Note: For detailed instructions for adding or removing columns, see Filtering in Planning Maestro.
Customizing Your Calendar
The Default [Time] setting under Columns controls which years and periods appear on the right side of the table below. You can customize this setting to see the range of years, quarters, and periods you want to focus on to build a budget.
Example: You can set up the Default [Time] setting to show only Quarter 1 and Quarter 2 for the next five years, or all quarters for the next three years.
Step 1: To customize your calendar settings, under Columns, select the More icon ( ) on the right side of Default [Time].
Please Note: For detailed instructions for customizing your calendar view, see Customizing Your Calendar View.
Saving your View
After making sure your view includes the columns, calendar settings, and filters you want, save your view. Saving changes the default view for all users.
Step 1: Select the Save icon ( ) to save this view.
Step 2: Click Confirm.
- The view is saved.
- Now, this view opens whenever you open this application and use the Default [Time]
- A confirmation message appears.
Importing/Exporting from Excel
The Import/Export feature in the Planning application enables you to export data to an Excel spreadsheet, review or edit it as needed, and import it back in. You can also import new Data Projections (line items) directly from Excel. This feature enables you to use Excel’s features to manipulate data and easily send it to Planning Maestro.
Exporting to Excel
Step 1: To export data to Excel, hover over the Export/Import icon ( ) and select one of the following formatting options:
Please Note: For detailed instructions for exporting or importing Excel templates, see Exporting/Importing Excel Templates in Planning.
Viewing Transaction Rows
The Data Projections in every Planning application have one value as the main one in the Amount column (one main expense, one main adjustment, etc.), but they may have other amounts within that amount column (for example, a Revenue Data Projection's price, cost, booking amount, etc.). You can view Data Projections by their main amount or by other related transaction amounts.
Example: In the Revenue application, you can change the display to view every Data Projection's Cost Per Unit.
Please Note: These transaction amounts (which are different in each application – for example, the Drivers application has Rate and Related Cost) related to the Data Projection are listed in the Details pane at the bottom of the application.
To change your view of this table and view Data Projections by a different amount or transaction type, click on the Transaction Row dropdown menu and select a transaction from the list.
- The right side of the table displays amounts related to the transaction you chose.
Please Note: The Amount column continues to display the “main” or total amount for this Data Projection.
- If a Data Projection does not have an amount for the transaction type you chose, the columns on the right side of the table (which show the amount per year, quarter, or period) are blank.
This feature is useful if you want to edit the amount of any transaction type through the main table, without having to open the Details pane for each individual Data Projection.
Example: In the Revenue application, to edit the Unit Price of several items at once without opening the Details pane for each one, follow steps 1-2 to view Unit Price (Input) as the Transaction Row. Then, click on any cell on the right side of the table to manually enter a Unit Price for a particular period.
Each application has different Transaction Row options.
Example: In the Personnel application, you can use Regular Hourly Wages as the Transaction Row to view all employees’ regular hourly wages.
Transaction Row options in each application:
Filtering Your Table
You can filter the columns of your table to view only certain sets of data: for example, only Data Projections that use the Period Amount Spread Method. For more information, see Filtering in Planning Maestro.
Reviewing the Properties Pane
The Properties pane for each application displays a Data Projection's properties: rates, processes, schedules, Data Links, and GL Accounts connected with this Data Projection.
To open the Properties pane of any application, click the Expand icon ( ) on the right.
The Properties pane opens. Every application’s Properties pane has a General and Date section, but each has unique sections described in the table below.
Reviewing the Details Pane
The Details pane displays how a Data Projection affects your Income Statement, Balance Sheet, and cash flow.
To open the Details pane, click the Expand icon ( ) at the bottom.
The Details pane opens.
The Details pane contains three sub-sections:
- Main Section (named Expense, Revenue, Headcount, Driver, or Adjustment, depending on which Planning application you are in) – This section shows how this Data Projection debits or credits GL Accounts related to this application.
- P&L (Profit & Loss) – This section shows how this Data Projection debits or credits revenue and expense GL Accounts (accounts displayed in your Profit and Loss Statement, or Income Statement).
- Balance Sheet – This section shows how this Data Projection debits or credits asset, liability, and equity GL Accounts (accounts displayed in your Balance Sheet).
Reviewing General Details
Use the main section of the Details pane (Expense, Revenue, Headcount, Driver, or Adjustment) to review how this Data Projection debits or credits the GL Accounts specifically related to this application. You can edit which GL Accounts are debited or credited for each section through the Properties pane.
Example: The main section of the Details pane in the Revenue application has three smaller sections: Revenue (revenue accounts), Cost (cost accounts) and Statistical Data (statistical data accounts).
Reviewing P&L Details
Scroll down and use the P&L section of the Details pane to review how this Data Projection affects GL Accounts included in the P&L (Profit and Loss) Statement, or Income Statement.
Example: In the screenshot above:
- Net revenue is $50,000.00 each period this year.
- The Revenue account (S-4010) is credited $50,000.00 each period.
Reviewing Balance Sheet Details
Use the Balance Sheet section of the Details pane to review the asset, liability, and equity GL Accounts debited or credit for this Data Projection.
Editing Amounts Individually
You can edit the individual amounts in the main application and in the Details pane for each period, quarter, or year (however your calendar view is set up). This function enables you to spread out an amount with individual, inconsistent amounts over a time period, instead of using a Spread Method (which is automatic, but more uniform).
Please Note: You and other users can edit individual amounts. You can also reverse your edits and return to the original amount. For detailed instructions, see Editing Data Projections (Line Items) Manually in Planning.