Forecast - Expense Planner

The Expense Planner is available for customers that prefer to manage planned expense entries for multiple projects on a single screen (possibly for multiple periods).  This screen is comprised of Search, Plan and Summary tabs and is available to users with Administrator, Project Manager or Project Lead roles.

This screen can be used to view existing planned expense entries as well as add new planned expense entries.

Topics covered on this help page include:


You may also be interested in:

Search Tab

Using the Search tab, the Project Manager can control the layout and contents of the Plan and Summary tabs, such as whether the grid will include tasks, the number of periods included, whether the periods reflect days, weeks, months or quarters, and which projects, tasks and expense types will be available for viewing and planning.

Save Criteria

Selection criteria for specific lists can be saved by clicking the  () link after criteria has been entered.  This criteria can be later recalled on this screen by selecting a previously saved criteria from the Saved List drop down.  Individual saved criteria list can be managed via the Reports >> Saved screen in the  My Lists  section.

By default, all expense types previously planned for the project or specific task will be included in the resulting grid (even if they do not have an entry for the time frame specified).  Using the Projects to Plan and Expenses to Plan options, the Project Manager can narrow down the set of projects / tasks and expense types that will be displayed on the remaining Plan and Summary tabs.

After supplying the desired selection criteria, click on the Plan tab to display the resulting matrix.

Field Descriptions (click on a link below for additional information)



Plan Tab

The resulting grid will resemble the following screen shot.  The cells in the grid will reflect the expense amounts previously planned for a particular time frame (e.g. month).  Additionally, the project manager can quickly add or change amounts via these cells.

When saved, these cell values will be translated into individual expense plan entries having a date range from the beginning of the period to the end of the period (e.g. a monthly July -08 entry will be saved as 7/1/08 --> 7/31/08).  These entries can be viewed and edited via the other planning screens such as the Project >> Expense Plans >> List .


Field Descriptions (click on a link below for additional information)




Shifting Cell Contents Right and Left

This functionality provides for the ability to move the contents of a row of cells X number of cells to the right or left.  When moving a populated cell, the values in the cell, as well as any override values associated with the cell (applicable to People Plans & Assignments only), will be moved.  This feature may be helpful, for example, if you need to delay a project for one or several months and would like to shift existing entries without having to re-key them in.

The controls involved in this functionality include the leading check box on each row, the Shift Left and Shift Right buttons, as well as the Number of Periods entry field.  Note that you can check the check box at the very top of the grid which acts as a toggle to check / uncheck all available check boxes in the grid.  


To move cell contents:




Grayed Out Entries


Turning Expense Plans into Expense Budgets

Planned expense entries can be copied into expense budgets by clicking on the Budget button from this screen, and further specifying which entries should be copied.  This will navigate you to the Expense Plans to Budget screen.

You can also navigate to the Project Profile >> Budget Plans screen where you can further narrow down which plans you would like to copy into expense budget entries.


Summary Tab

The Summary tab could be considered somewhat of a report of what has previously been entered for this project.  Using the Summarize by options, you can control whether the details will be accumulated by task, expense type or both task and expense type.  

The projects, expense types and time frame reflected on this tab are governed by the selection criteria entered on the Search tab.



Related Topics