Budgeting & Forecasting

Budget Basics - Learning Path

Budgets are maintained on budget worksheets.

Budgeting Basics - Learning Path

Introduction

Budgeting in Martus is all about the budget worksheet. Within a budget worksheet, it is possible to budget easily based on reference data from the previous year. Within this learning path, you will learn about the Worksheets page, the worksheet, and the Budget Widget, in order to budget successfully in Martus.


Learning Path:

  1. Planner Worksheets
  2. The Budget Worksheet
  3. The Budget Widget
  4. Budget Reporting - Planner Summary

Use the link below to navigate through the learning path.


Budgeting Basics - Learning Path >> Planner Worksheets








Planner - Worksheets (Video)

The  Planner > Worksheets page provides a list of available worksheets. It is important to note that the worksheets displayed are determined by the dimension restrictions applied to the current user.



Selecting a Worksheet - Step by Step

  1. Go to Planner > Worksheets.
  2. Ensure the appropriate Year is selected.


  3. Utilize any filters as needed to find the worksheet.
  4. Click Edit (pencil icon) next to the appropriate worksheet.


Use the links below to navigate through the learning path.

Introduction << Budgeting Basics - Learning Path >> The Budget Worksheet


The Budget Worksheet (Video)

The budget worksheet is designed to make budgeting easy. A budget worksheet is a unique combination of dimensions that allow a user to enter the values for that specific budget area. This article will explain the various actions that are available on the worksheet. We recommend utilizing the Budget Widget to update lines within the worksheet.


The following assumes that you are on the Worksheet screen and the worksheet is unlocked. If you aren't sure how to get there, review the Budget Worksheets article.


Budget Worksheet Anatomy

Worksheet Header - Displays which worksheet is open, whether the worksheet is locked or not, and the Worksheet Actions menu.

 

Worksheet Tabs - Allows switching between the worksheet, statistical accounts (if applicable), attachments, and approvals.


Worksheet Options - Options to hide or show reference data, change reference data, filter the worksheet, refresh the worksheet, and the Line Actions menu.


Reference Data - Only shows when Show Reference Data is selected. This will show all actuals and/or budget amounts based on the reference data chosen. It will be organized into sections by Income, Cost of Goods, Expense, Other Income, and Other Expense as applicable. 

  • Note: Amounts in blue represent actuals and are drillable (if you have permission to drill into the account), whereas budget amounts will show in black.


Budgeting Area - Will show all lines organized into sections by Income, Cost of Goods, Expense, Other Income, and Other Expense as applicable.


Reference Data

By default, the reference data is hidden. However, it can be viewed in two places.

  • Reference Section
    1. Click Show Reference Data to view all reference data related to this worksheet.


    2. You can choose which reference data to view via the drop-down menu.


    3. When referencing the budget in your data, the budget shown is the budget that is set as the Dashboard default for that year.
    4. Click the blue link to drill into the transaction detail (with the appropriate permissions).

  • Line Reference 
    1. Navigate to a line.
    2. Click > (carrot icon) to expand the reference data box.


    3. Click the blue link to drill into the transaction detail (with the appropriate permissions).


Worksheet Actions

Worksheet Actions - Step-by-Step

Within the worksheet, there are actions available that affect the entire worksheet. See below for the definition of each option in this menu.

  1. Click Worksheet Actions.
  2. Click the appropriate option. A greyed-out option indicates it is not available.
  3. Some actions may require more data to be provided.


Worksheet Actions - Definitions

  • Load - This option will take into consideration all lines in the reference data and load any lines that are currently in the reference data but not in the budget. This is an easy way to add any missing lines to a budget.
  • Initialize - Add the values from the budget or actuals and apply the amounts to each line.
  • Zero Out Worksheet - Remove all values from the worksheet. Use with caution - there is no undo.
  • Round - Round all amounts to the nearest 1, 10, 100, or 1000 dollars. Use with caution - there is no undo.
  • Submit and Lock - Lock the worksheet and initiate the approval process.
  • Unlock - Unlock the worksheet to allow editing.
  • Create Special Purpose Worksheet - Create a new Worksheet Special Purpose Worksheet (WSPW) that is tied to this specific budget worksheet. (Only available until a Special Purpose Worksheet is created.)
  • Edit Special Purpose Worksheet - Open the Worksheet Special Purpose Worksheet (WSPW) associated with this worksheet (Only available after a Special Purpose Worksheet - SPW - is created).
  • Post [#] Applicable SPW - Post any applicable SPW budget lines to the worksheet.
  • Show Applicable SPWs - Show all Global and Worksheet Special Purpose Worksheets that are tied to this worksheet (Only available after a Special Purpose Worksheet is created).
    • Note: Only those with access to Global Special Purpose Worksheets (GSPWs) will see the GSPWs based on permissions and dimension restrictions. 
  • Export Worksheet (xlsx) - Exports the worksheet in an Excel format that can be re-imported.
  • Import Worksheet (xlsx) - Imports the worksheet assuming the format is the same as the export.


Line Actions

Line Actions - Step-by-Step

Within the worksheet, there are actions available that can affect one or more lines. See below for the definition of each option in this menu.

  1. Select one or more lines.
  2. Click Line Actions.
  3. Click the appropriate action. A greyed-out option indicates it is not available.
  4. Some actions may require more data to be provided.


Line Actions - Definitions
Line Actions will affect any selected line or lines.

  • Add Line - Allows a user to add a line to the worksheet if it does not yet exist.
  • Initialize - Add the values from the budget or actuals and apply the amounts to each line selected.
  • Adjust Amounts - Allows a user to change the current amounts by month with a percentage increase or decrease.
  • Move Line - Use this feature to summarize all selected lines into a target line. The target must be one of the selected lines. The action applies to all non-frozen months. Use with caution - there is no undo.
  • Round - This will round all amounts to the nearest 1, 10, 100, or 1000 dollars. Use with caution - there is no undo. 
  • Flat to Budget - Utilized with a frozen budget with actuals loaded. This option will split the remaining budgeted amount for one or more lines evenly among the unfrozen months, based on the reference data.
  • Change Dimensions - Utilized within systems that have line dimensions configured. This will allow the user to associate a different line dimension with the budget line. 
  • Delete Lines - Deletes the selected lines. Use with caution - there is no undo. Lines must be added back via the Load or Add Line options.


For more detailed descriptions, you can select the blue question marks in Martus from within the budget worksheet next to Worksheet Actions and Line Actions.


Use the links below to navigate through the learning path.


Planner - Worksheets << Budgeting Basics - Learning Path >> The Budget Widget



The Budget Widget (Video)

The Budget Widget simplifies budgeting by doing the math for you! Whether you need to adjust your budget to a flat amount or by a percentage, the Budget Widget makes it easy. The Budget Widget is available on all unlocked worksheet lines unless they are controlled by a Special Purpose Worksheet. Using the Budget Widget is best practice for updating your budget lines.



Using the Budget Widget - Step by Step

  1. Select an unlocked worksheet to edit.
  2. Click the Budget Widget button on the worksheet line.


  3. From the Budget Widget window, adjust amounts as needed.
  4. Adjust the monthly amounts manually, or use the Adjustment Type dropdown. (See below for a detailed explanation of each option).


  5. If you used an Adjustment Type to create values, click on Preview to see the results without committing to them just yet.
  6. Add any Notes as needed.


  7. Click Save to post your amounts and Notes back to the worksheet line.


Budget Widget Options

  • Weekly - Enter the starting date and the amount. Martus will calculate the weekly amount taking into consideration the months with five weeks.


  • Bi-Weekly - Enter the starting date and the amount. Martus will calculate the bi-weekly amount taking into consideration the months with 3 bi-weekly dates.


  • Monthly - Enter the starting and ending months and the amount. Martus will update every month within the date range with that value. Note: It will not adjust other months' values.


  • Quarterly - Enter the starting and ending months and the amount. Martus will update one month every 3 months with that value.


  • Annual - Enter the starting and ending months and the amount. Martus will divide the amount evenly between the months selected, with remaining pennies in the last month.


  • Adjust - Enter the starting and ending months, and a value with which to adjust amounts. Martus will adjust the values that are currently on the line by the percentage input. For example, an input of 105 will increase the amounts by 5%. An input of 95 will decrease amounts by 5%.


  • Additional Amounts - Enter an amount for each month as appropriate. Martus will add this amount to the current amounts.


  • Allocation - Enter an amount and choose a source (actuals and/or budget) for each month. Each month's total will be compared to the original total of the reference data (4,365.00) to provide a percentage per month. That percentage is then calculated against the amount indicated (5,000.00) and the monthly amounts are displayed.


  • Copy Existing Values - Enter an adjustment value and choose which reference data to use per month. Martus will utilize the appropriate data and adjust it by the adjustment value as appropriate.


  • Burn Rate - This option will take the total of the months sourced (3,450.96) and divide it by the total months sourced (5) and apply that calculated average to all unfrozen months (690.19).



Use the links below to navigate through the learning path.


The Budget Worksheet << Budget Basics - Learning Path >> Budget Reporting - Planner Summary


Budget Reporting - Planner Summary

The Planner Summary is the reporting tool for the budgets you create in Martus. It provides very flexible filtering and view options. This article considers the basic steps for viewing, adjusting and exporting the various reports, as well as an overview of what each report shows.


Anatomy of the Planner > Summary Page


Report Selector - Select a report from the Select Report dropdown, and wait for the selected report to load before proceeding.


Report Criteria - Once you have changed the report criteria, click Load to apply the changes. Note that any changes to the report criteria will be sticky as you move from report to report. For example, if you have a filter applied in one report, when navigating to another report, that same filter will be applied until you change it.



The most utilized options include:

  • Year - Specify the year for the report.
  • Budget - This is set to the default Planner budget for the chosen Year. If you have permissions in Martus to view more than the default Planner budget, you will see other budgets in this drop-down if they exist for the year in scope.
  • Rows - Group rows by other options such as viewing the rows by a dimension rather than by account.
  • Columns - Group columns in different ways such as other date groupings or by dimension.
  • Dimension filters - These are unique to your system configuration. In the example below, we have Corporation, Department, and Project-Grant.
  • Account Category - Select the desired account grouping.
  • Export (xlsx) & Export (pdf) - Export the report o either Excel or PDF format.

     

Planner Summary Reports Descriptions

  • Planner Summary - An overview of the budget by month. Set the rows or columns as needed to display the data differently. If the rows are set to Account, you can click on the link to review all worksheets utilizing that Account.
  • Budget Analysis - Will compare the current year Planner budget, the previous year Dashboard budget, and actuals. Set the rows to Accounts or Dimensions. Note: For this report to work, you must have two budgets in adjacent years.
  • Prior Year Budget Comparison - Displays a column per month of the current year's budget, last year's total budget, and a comparison column. Rows can only be set to Accounts. 
  • Side-by-Side Budget Comparison - Allows a user to pick multiple budgets* and compare them. Can set the rows to Accounts or Dimensions and hide or display the Difference columns.
  • Planner Summary by Worksheet in Excel - Will export the entire budget to Excel with a sheet per Planner Worksheet.
    * Essentials customers can compare two budgets at a time, while all higher subscriptions can compare up to five budgets at a time.

Frequently Asked Questions

  • Is there a report that will include all budget line notes from all worksheets?
    Yes - Utilize the Planner Summary report and scroll down below all of the lines. Choose an optional Dimension to sub-total by and click on "Detailed Budget Analysis Report."


  • Can I print reports?
    Yes - You can print any report by first utilizing the Export function to export the report to PDF or Excel. Then, print your report from within the desired program.

  • Departments are one of my dimensions. Can I see just a total row by department rather than income & expenses?
    Yes - Utilize a report such as the Planner Summary and set the Rows to Department View or Department View Gain/Loss (you can replace "Department" with any dimension in your system). The Gain/Loss view will provide one line for the dimension selected, netting all Income, COGS, Expense, Other Income, and Other Expense into one line.


  • Can I view more detail such as a hierarchy or second dimension?
    Yes - Utilize a report such as Planner Summary. Set the rows to a Dimension and click Load. Then utilize the Expand or All Dimension buttons. Expand will show all parent/child relationships with sub-totals as well as the accounts under each section. All Dimensions will show all parent/child relationships. Example: Rows set to Department > Expand:


Use the link below to move through the Learning Path.


The Budget Widget  << Budget Basics - Learning Path