Budget Management
Budget Management
Glen Strack
Senior Implementation Consultant
Vanessa Chambers
Director of Service Delivery and Product Management
Agenda
BUDGET MANAGEMENT
Budget Worksheets
BUDGET MANAGEMENT
Worksheet –Worksheet 2.0
Worksheet – Worksheet 2.0
Worksheet 2.0 – Options
Worksheet 2.0 – Reference Data
Worksheet 2.0 – Reference Data
Worksheet 2.0 – Default Reference Data
Planner / Planner Setup / Budget Management tab
Worksheet 2.0 – Poll Question
Wksheet
5 Methods to Input – Direct Entry
5 Methods to Input – Initialization
5 Methods to Input – Excel
5 Methods to Input – Budget Widget
5 Methods to Input – SPW
Budget Approval Workflow
BUDGET MANAGEMENT
Workflow – Owner and Approver Setup
Planner / Planner Setup / Worksheet Management
Workflow
No Approver
Workflow – With Approvers
When Submitted
Workflow – With Approvers
Declined
Workflow – With Approvers
One Approver - Approved
Workflow – With Approvers
Multiple Approvers
Worksheet Status Report
Planner / Summary / Worksheet Status Report
SPWs
BUDGET MANAGEMENT
SPW - Types
Worksheet SPW
Global SPW
Template SPW
3 SPW Types
SPW - Types
Accessed from within a budget worksheet
Worksheet-specific, only affecting the single worksheet that they are part of
Available to any user with access to that worksheet
Worksheet SPW
Access to SPW Templates
SPW - Types
Accessed from the Planner / SPW menu
Admin functionality, but privileges may be given to non-admin users
Can impact multiple worksheets
Global SPW
Can not be overridden at worksheet level
SPW - Types
Accessed from the Planner / SPW menu
Admin functionality
Can be imported by WSPWs
SPW Template
Updates to SPWTs can be posted to the WSPWs that use them
SPW - Examples
Budgeting for attendance at conferences, where registration revenue and expenses are per participant
Budgeting several locations with similar types of underlying calculations and assumptions; for example, a school that charges tuition and program fees that vary by location
Budgeting for an event, where there is income expected from registrations and expenses associated with the event
For churches, budgeting for income, where tithes can be predicted based on historical giving rates and levels of attendance
Budgeting based on a value calculated within the worksheet (such as a 10% tithe to Missions) based on predicted income, or a 5% license fee based on predicted revenue)
Budgeting for the purchase of office furnishings where there are multiple components to be specified (desks, chairs, and filing cabinets) but all costs are to be assigned to the same account
Budgeting at the departmental level for amounts allocated by management. For example, applying rent or salary cost to departmental budgets, so that the amounts budgeted are predetermined and cannot be changed at the departmental level.
SPW - Walkthrough
Clickable link
SPW – Poll Question
Forecast Options
BUDGET MANAGEMENT
Forecast Module available at Advanced+ subscription level
Forecast Report
Dashboard / Financials / Forecast Report
Enhanced Forecast Report
Available at Advanced+ subscription level
Dashboard / ReportBuilder
Enhanced Forecast Report
Available at Advanced+ subscription level
Enhanced Forecast Report
Report Builder in beta as of Oct. 2022
Reforecast Budget
Planner / Planner Setup / Budget Management
Reforecast Budget
Forecast Module
Forecast Module available at Advanced+ subscription level
Locked vs. Frozen
Locked vs. Frozen
Locked vs. Frozen
Locked vs. Frozen
Start a New Budget Year
BUDGET MANAGEMENT
New Budget Year - Methods
Framework
Copy
Actual and Budget
3 Methods
New Budget Year – Checklist for New Year
Lock your new budget until you are ready for the budget process to begin
Set your dashboard and planner defaults
Best Practice
Upload your completed Martus budget to your accounting system
Resource Links
Parting Thoughts
BUDGET MANAGEMENT
Budget Management
Thank You!
We make budgeting better