Budgeting & Forecasting

Budget Management

Information for budget managers.

Planner Setup (Video)

Planner Setup allows an Admin user to:

  • create, edit, and manage the budget
  • update the default budget year
  • add or remove worksheets in the budget
  • export/import budgets as needed





All Admin users have access to all tabs in Planner Setup. Any non-admin user with access to Planner Setup will only have access to the Worksheet Management tab.


Each tab within Planner Setup allows for various actions.


Budget Management Tab

This is the default tab in Planner Setup. It provides options for managing your budgets.


  • Create a budget - Set the year and click Load, and then click Create Budget to create a blank budget or one based on the prior year's information. Review New Budget Cycle for more details.


  • Edit the budget name and comments
    1. Click anywhere on the budget name or on the pencil icon.
    2. Edit as appropriate.
    3. Click Save.

  • Action menu - Select any budget using the box to the left of the budget name to load the action menu:


  • Copy - Create a copy of the selected budget AND post all Special Purpose Worksheets to the copy.
  • Delete - Remove the budget from the Budget Management tab and create a copy under the Manage Archived Budgets tab.
  • Set as Dashboard - Make the budget the default in the Dashboard section; any user with access to Dashboard Financials or ReportBuilder will be able to see this budget.
  • Set as Planner - Make the budget the default in the Planner section; any user with access to Planner Summary or Worksheets will see this budget.
  • Load Actuals - Load actuals through the Last Closed Month into the selected budget. (Note the option to "Limit to Selected worksheets" -- to see the impact of this go to Dashboard > Financials and navigate to the "Worksheet Budget Comparison" report.  Any rows with a red "X" will be created as a worksheet if "Limit to Selected Worksheets" is unselected.)
  • Set Viewable - Allows a non-admin with the explicit rights "Can View Non-Default Budgets" on the user record to see this budget.
  • Freeze/Unfreeze - Freeze all months through the Last Closed Month; budgets are automatically frozen when actuals are loaded.
  • Lock/Unlock Worksheets - Lock or unlock all worksheets within the budget. Martus recommends keeping all budget worksheets locked unless actively budgeting.
  • Export - Export the budget into an Excel file. (Note this is the ONLY format that can be manipulated in Excel and re-imported into Martus.)
  • Archive - Create a copy of the budget in the Manage Archived Budgets tab. Martus recommends archiving the budget before making any major changes in case of mistakes.
  • Set Default Reference Data - Set the default reference data on that budget's worksheets. The options are: current or prior year budget, actuals, actuals + budget, or 12-month trailing actuals.

Worksheet Management Tab

View the list of worksheets in the selected budget, and manage their settings here. This tab is the only tab in Planner Setup available to non-admins who have "Planner Setup" selected on their user record.


  • Manage worksheets in other budgets/years - Use the drop downs to choose which budget and/or fiscal year to manage.


  • Add a new worksheet to a budget - Create a new worksheet with a dimension combination that does not currently exist in this budget. The Add Worksheet dialog allows you to assign owners and approvers and specify a target for the worksheet.


  • Action menu - Select one or more worksheets using the check box to the left of the name to load the action menu:
    • Set Target - Set the gain/loss target using a % increase/decrease or manually.
    • Update Owners & Approvers - Assign or remove users as owners and approvers.
    • Lock/Unlock - Lock or unlock worksheets.
    • Delete - Delete the worksheet from the budget.

Import Tab

Import budgets based on an exported budget template into Martus. Choose the fiscal year for the imported budget, and then the file to import.

  • Import into Existing Budget - The imported budget overwrites existing lines and creates new lines.
  • Create New Budget - A new budget is created from the import.


Manage Archived Budgets Tab

Archiving a budget before making major changes is best practice, as it makes it easy to restore if there is a mishap.

  • Select a year and budget to view the Action menu.
    • Restore - Restore the budget to the Budget Management tab.
    • Delete - Delete the budget permanently.


Set Budget Year Tab

  • Set as Budget Year - Set the default year for the Planner section.



Worksheet Status - Locked versus Unlocked

Locking Worksheets

When actively budgeting, a worksheet is unlocked and users are updating it. Once it has been submitted, the worksheet will be automatically locked, and no further changes can be made to the worksheet or an associated special purpose worksheet. It is recommended that all worksheets in a budget stay locked once the budget has been approved to prevent accidental changes.


Locking Versus Freezing

When a budget is frozen, all months up through the current Last Closed Month are frozen and cannot be modified, for all worksheets in the budget. Approved and reforecast budgets are typically frozen. Non-frozen months can be modified if the worksheet is unlocked. 


Locking and Unlocking from the Worksheet

A Martus Admin or any non-admin user who has "Can Unlock Worksheets" on their User Permissions can lock or unlock a worksheet.

  1. Start on Planner > Worksheets.
  2. Click Edit (pencil icon) next to any worksheet.
  3. Click the Lock icon to unlock/lock the worksheet.
    OR
  4. Go to Worksheet Actions > Submit and Lock or Unlock.

 


Locking and Unlocking from Planner Setup

A Martus Admin can lock or unlock all or specific worksheets from Planner > Planner Setup.

Unlocking/Locking all worksheets in a budget:

  1. Start in Planner > Planner Setup.
  2. Select the check box for the appropriate budget.
  3. Click on Lock Worksheets or Unlock Worksheets.


Unlocking/Locking one or more worksheets in a budget:

  1. Start on Planner > Planner Setup.
  2. Go to the Worksheet Management tab.
  3. Select one or more worksheets.
  4. Click on Unlock or Lock.







Worksheet Status - Frozen versus Unfrozen

Frozen Worksheets

When a budget is frozen, all months up through the current Last Closed Month are frozen and cannot be modified, for all worksheets in the budget. Approved and reforecast budgets are typically frozen.

Budgets are frozen in two ways:

  • Manually using Budget Actions in Planner > Planner Setup 
  • Automatically whenever actuals are loaded into a budget

Freezing Versus Locking

A Locked worksheet means that no changes can be made to any of the months in the worksheet. A budget and individual worksheets can both be locked.


Freezing or Unfreezing the Budget

A Martus Admin can unfreeze or freeze all worksheets in a budget.

  1. Start in Planner > Planner Setup.
  2. Select the check box for the appropriate budget.
  3. Click on Freeze or Unfreeze.


Freezing or Unfreezing a Budget Worksheet

A Martus Admin can unfreeze or freeze any worksheet in a frozen budget.

  1. Start in Planner > Worksheets.
  2. Click on Edit (pencil icon) next to any worksheet.
  3. Go to Worksheet Actions > Unfreeze/Freeze Worksheet.



Notes:

  • Frozen months cannot be updated on the worksheet itself, by posting SPWs, or by posting a personnel scenario to the budget. 
  • If the budget is not frozen, individual worksheets cannot be unfrozen or refrozen. However, if a budget is frozen, an Admin can temporarily unfreeze a worksheet in that budget. The worksheet can be refrozen with a Worksheet Action, and it is automatically frozen when the Admin user leaves the worksheet.
Budget Worksheet Owners and Approvers (Video)


Martus Admins are responsible for managing budget worksheet owners and approvers. Non-admin users with the "Planner Setup" permission can manage owners and approvers for the worksheets to which they have dimensional access.


One of the easiest and most efficient ways to update budget owners and approvers is via the Planner > Planner Setup > Worksheet Management tab.

 




Notes:

  • A budget worksheet can only have one owner, but it can have multiple approvers. 
  • Approvers can be assigned approval levels for customers with the Advanced Plus and higher subscription. Approval levels are used to manage the flow of approval emails.*
  • Any user with the appropriate dimension access and software permissions can edit an unlocked budget worksheet. (You don't have to be an owner or approver to edit a worksheet.) 
  • Assigning a user as an owner or an approver does NOT grant dimension access! When you assign owners and approvers, you must make sure they have the appropriate dimension permissions.  You'll be notified at the time of assignment if they don't have appropriate dimension permissions, and if you are an Admin user, you can add those permissions at that time.
  • Budget worksheets are locked when they are submitted for approval
  • Only a Martus Admin, or a non-admin with the privilege Unlock Budget Worksheets can unlock a budget worksheet
  • When you copy a budget, the owners and approvers are copied too. 
  • When you create a new budget based on a budget from a prior year, the owners and approvers are carried forward to the new budget.
  • If you are an owner or approver and take the action that would normally prompt an email, Martus will suppress that email as it assumes you know that the worksheet was submitted or approved (by you) and thus the email would be redundant. 


* Approval levels are new!

  • Levels do not need to be used. Non-hierarchical approvers all have the same level - typically 0 - on the same worksheet.
  • Levels and approvers are defined by worksheet. They are unique to each worksheet.
  • Any user can be an approver on any worksheet they have dimension access to, and they can have different approval levels on different worksheets.
  • Levels can be set from 0 to 99, but do not need to be used sequentially. The lowest approver is 0, and the 99 is highest.
    • Multiple approvers can have the same level. They function as a 'group' of approvers.
    • When a worksheet is submitted, the submission approval email goes to all user(s).
    • Once the lowest level user approves the worksheet, the next level user gets an approval email letting them know of the status.
    • If the lowest level user denies approval of the worksheet, the owner will get an email with the status.
  • The highest level approver can approve the worksheet, even if lower level users have denied it. 
  • Approvals can be done out of order, but emails are sent in order. All approvals must be done in order for the worksheet to show as fully approved.
  • When any approver denies the worksheet, only the owner gets an email letting them know, and the next level is not alerted.


Approving and Denying Budget Worksheets (Video)


The Approval feature is part of the Martus Advanced and Advanced Plus subscriptions.


The video below illustrates how to approve and deny budget worksheets within Martus.



Changing a Budget via Export/Import

Whenever a global change is needed on a worksheet or budget, it may be easier to export, update, and then import the worksheet or budget. Some examples include:

  • Changing dimensions on worksheets
  • Adjusting all account lines across all worksheets
  • Adding a line dimension to multiple worksheets/lines
  • Adding/removing worksheets

These methods can only be used if you do not have any SPWs that affect the worksheet(s) for which you are making changes. If you have SPWs of any kind that affect the worksheet, please contact Martus Support for assistance.


Method 1 – One Worksheet at a Time 

  1. Open a worksheet.
  2. Click Worksheet Actions > Export Worksheet (xlsx).


  3. Open the file from your computer.
  4. Make changes as needed and save the file. If you change dimensions for any rows, use the Id columns to the right - these are the columns Martus will use on import.


  5. Go to the worksheet and click Worksheet Actions > Import Worksheet (xlsx).


  6. Choose the file from your computer and click Import.
  7. Wait for Martus to finish importing.
  8. Review changes in Planner > Summary reports.

If sheet dimensions were changed, you may need to delete the old worksheet from the budget in Planner > Planner Setup > Worksheet Management.


Method 2 – All Affected Worksheets within a Budget

This method allows you to update or change all affected lines regardless of the worksheet.

  1. Go to Planner > Planner Setup.
  2. From the Budget Management tab, select the budget by checking the box next to the name.
  3. Click Export from the action menu.
  4. Open the downloaded file in Excel.
  5. Navigate to the "Budget" sheet.
  6.  Modify all of the desired worksheet lines. If you change dimensions for any rows, use the Id columns to the right - these are the columns Martus will use on import.


  7. Delete the sheet named "Setup".
  8. Save the updated Excel file.
  9. Go to Planner > Planner Setup > Import tab.
  10. Change the year if needed and click Load.


  11. To create a new budget:
    1. Choose Create New Budget.
    2. Specify a Budget Name.
    3. Choose the file from your computer.
    4. Click Import.
    5. Go to your home screen to await the completion of the import.
    6. Go back to Planner > Planner Setup and set the new budget as the Planner and/or Dashboard default as desired.
  12. To import into an existing budget:
    1. Choose Import into Existing Budget.
    2. Select the Destination Budget from the dropdown.
    3. Choose the file from your computer.
    4. Click Import.
    5. Go to your home screen to await the completion of the import.
    6. Go back to Planner > Planner Setup > Worksheet Management tab.
    7. Delete any unneeded worksheets using the action menu.


Notes on Importing

  • Martus will add new and adjust existing, but won't remove unmatched lines when importing.
    • New lines: Martus will import all new lines from the file.
    • Adjusted lines: Martus will update all values for the line to the values found in the file.
    • Removed lines: Martus will do nothing - the lines that were in the budget originally remain unchanged.
  • To remove lines and/or worksheets from a budget, you may want to utilize the export/import method and the option to import into a new budget. The new budget only contains the lines indicated in your file.
  • The tab with the budget in Excel must be called "Budget". The file names do not matter.
  • There can be no duplicate combinations of dimensions and accounts. (We recommend testing this by concatenating these fields in a separate column and checking for duplicates.) If there are duplicates, the last one processed is the only one that will be imported into the budget ("last one wins").
  • There can be no Excel formulas in any field that is to be imported. Copy and paste as values if needed.

Anatomy of the Import File


  • Dimension & Account Friendly names - Yellow:
    These are for reference only. You can fill them in, leave them blank, or even delete those columns entirely.
  • Monthly Amounts - Green:
    The total per month for that line.
  • Notes - Purple:
    The Notes columns (1-12) apply to each corresponding month in your fiscal year. There's a 150-character maximum on each note.
  • ID Columns - Blue:
    • The columns for the Dimension IDs and account numbers are shown to the right of the Notes columns.
    • The headings for these columns are essential and must be in the format of the dimension name plus Id (for example, DepartmentId). Only optional dimensions may be left blank. 
    • Utilize the code ID, not the name, and ensure there are no leading or trailing spaces.







Creating and Updating an Empty Budget

When needed, it is possible to start a budget without a previous budget or one based on actuals. While an export/import is possible, at times it makes sense to create and update the budget within Martus.


Creating and Updating a New Budget - Step by Step

  1. Go to Planner > Planner Setup > Budget Management tab.
  2. Click Create Budget.
  3. Choose the option to create an empty budget.
  4. Select the newly created budget and click Set as Planner.
  5. Go to the Worksheet Management tab.
  6. Click Add Worksheet and fill out the form as needed.


  7. Click Save.
  8. Add all needed worksheets.
  9. Go to Planner > Worksheets.
  10. Click Edit (pencil icon) next to a worksheet.

     
  11. Click Worksheet Actions > Add Line to add the needed accounts to the worksheet.
    Note: Depending on your Martus configuration, you may also need to add additional dimension values such as program, activity, or project codes to each line. 
  12. Enter the budgeted amounts using the Budget Widget.
  13. When you are completely done, click Submit to lock the budget worksheet; this also submits it for approval if you are using that feature of Martus. 


Top Level Budgeting

Top Level and All Level Budgeting allow budgeting at alternate dimension levels even though actuals are posted elsewhere.  


Top Level and All Level Budgeting are optional features of Martus. They are available for clients at any subscription level. These features must be activated by Martus Support. If you would like to utilize these features, please reach out to support@martussolutions.com.


Top Level Budgeting

The Top Level Budgeting feature helps when you want to budget at a parent dimension level even though actuals are posted to children of that dimension value. 

  • When budgeting, the actuals shown in the reference data section of the worksheet include the total for all child dimensions plus the parent. 
  • If you drill down from the reference data, you’ll see all the transactions that make up that total, whether those transactions are at the child or parent level. 
  • When you load actuals into a budget, the values for the parent and its child dimensions are included in the budgeted totals.

Examples where you might like to use Top Level Budgeting: 

  • A parent department named New Generation, with child departments for Preschoolers and School-Age.
  • A parent program for External Affairs, with child programs for Federal and State. All Level Budgeting is a feature available within Top Level Budgeting that allows reference data to be summarized for all dimension values. 


All Level Budgeting

The All Level Budgeting feature helps when you want to budget for all values within a dimension, rather than a singular or top level. This requires a worksheet with one dimension that is blank. 

  • When budgeting, the actuals shown in the reference data section of the worksheet include the total for dimensions on the blank dimension.
  • If you drill down from the reference data, you’ll see all the transactions that make up that total across all dimension values for the blank dimension.
  • When you load actuals into a budget, the values for blank dimensions are loaded into the budget.


Setting Top or All-Level Budgeting


Warning: If you do budget at the top level for a given dimension value, you should not also budget to the children of that dimension! 


Each worksheet will have an option at the top to select Top Level for each dimension. The best practice is to only use top level budgeting on one dimension at a time.

  1. Edit the worksheet.
  2. Click Top Level or All Levels next to the appropriate dimension.


  3. Martus refreshes and will update the reference data to include the child dimension amounts.

Loading Actuals into a Top-Level Budget

There are considerations to be aware of with top-level budgeting when loading actuals.

  • When loading actuals, there is an option to Limit to Existing worksheets. When unselected, Martus will create new worksheets as needed for all lines with actuals.
  • When using top level budgeting, select the appropriate dimension so that Martus will create the worksheet at the top level, rather than the lower levels, of that dimension.


Notes: 

  • Utilizing more than one dimension for top level is not recommended. While the actuals will be summarized when loading actuals, Martus only supports one dimension for loading actuals.
  • All Level Budgeting and loading actuals: When you Load Actuals and do not limit the results to existing worksheets, no worksheets are created for All Levels. If you want to include any All Levels worksheets in the output, be sure to create them before running Load Actuals. 
  • If you use the Planner Allocations feature of Martus, top-level budgeting is used on all of the Pre-Allocation worksheets.
Planner Allocations

The Planner Allocations feature provides for a different type of budget, called a pre-allocation budget. Each worksheet in a pre-allocation budget can be allocated on a percentage basis to any worksheet(s) in the default Planner budget.


Planner Allocations are an optional feature of Martus, available with the Standard+, Advanced+, and Enterprise level subscriptions. This feature must be enabled by support. If you would like to utilize this feature, please reach out to support@martussolutions.com.


Important Facts about Pre-Allocation Budgets

  • The pre-allocation budget should include worksheets only for those dimensions that need to be allocated. 
  • Each worksheet within a pre-allocation budget should only budget to those accounts that need to be allocated. Do not add accounts that are allocated elsewhere such as in Personnel Budgeting.
  • Each pre-allocation budget can be managed within Martus with the same tools used for Planner budgets. This includes reporting, setting the default pre-allocation budget, and other standard functions such as copying, importing and exporting, using SPWs, and the approval process.
  • The pre-allocation budget, when allocated to the default Planner budget, will replace all values associated with the lines in the pre-allocation budget.

Creating a Pre-Allocation Budget

  1. Go to Planner > Planner Setup > Budget Management tab.
  2. Select the appropriate year if needed.
  3. Click Create Budget.
  4. Choose Empty Budget.
  5. Give the budget a Name.
  6. Choose Pre-Allocation from the Budget Type drop-down.



  7. Click Create Budget.
  8. Select the budget that was just created.
  9. Click Set as Allocation.



Adding Worksheets to a Pre-Allocation Budget

  1. Go to Planner > Planner Setup > Worksheet Management tab.
  2. Select the year and the pre-allocation budget from the budget dropdown and click Load.
  3. Click Add Worksheet.
  4. Fill out the fields as appropriate.

    Note: Most Planner Allocation worksheets have one dimension that is blank so that roll-up amounts across that dimension can be utilized in the budget worksheet.

  5. Click Add Worksheet.

Adding Lines and Values to a Worksheet

  1. Go to Planner > Worksheets.
  2. Select the Year and Budget from the dropdown and click Load.
  3. Click Edit (pencil icon) for the appropriate worksheet.
  4. Click Line Actions > Add Line.
  5. Select the appropriate Account and any line dimensions desired.
  6. Click Add Line.
  7. Add additional lines as needed. Note: Remember that only lines that need to be allocated should be added.
  8. If needed, click Show Reference Data or use > (carrot) on the row. As an example, all reference data for the Department below is showing regardless of what Corporation it is tied to as Martus will automatically select the "Top Level" option for the empty dimension.



  9. Update the line with the appropriate budget numbers.

Allocating the Worksheet

  1. From Planner > Worksheets, select a worksheet to edit.
  2. Click Worksheet Actions > Allocate worksheet.



  3. Click Add New Target and select the appropriate worksheet to allocate.



  4. Enter the percentage to allocate to the target worksheet and click + to save.
  5. Continue adding targets worksheets as needed.
  6. When finished, click Post to Planner Budget to post the allocated amounts to the matching lines in the default Planner budget.