Purpose of Planner Module
The Planner Module is to be used for the preparation of the annual budget. Selkirk College assigns budget authority at the Cost Centre level. Each Cost Centre may hold multiple Work Orders. Refer to Organizational Structure HERE. The Budget Holder that is responsible for the Cost Centre will be assigned access to view and modify the transactions for their respective Cost Centres. The transactions are broken into two different transaction entry screens:
- Revenue/Expense Transaction Screen ~ This screen will capture all of the accounts in the revenue, discretionary spending accounts, and discretionary personnel expenses. The Budget Holder will have access to edit the current fiscal year budget ONLY. Additional columns of financial information will be provided for reference. These columns will include prior year actuals, as available, and prior year budgets.
- Payroll Transaction Screen ~ This transaction screen will capture all of the accounts in the wages and benefits categories. The transactions in this screen will be populated through the use of a report that pulls data from the Position Register. The report calculates the projected fiscal year's wages by using the position's pay step, FTE, annual hours, and contract term. The value that populates will be split according to any work order splits that are assigned at the position level. We budget based on positions and the respective FTE of those positions, not employment, or the person in the position.
FAQs
- Do I have access to a budget? How do I find it?
- How do I go about editing my current year budget?
- I don't see a line for something - How do I add that to my budget?
- How do I delete something from my budget?
How to View and Edit Your Budgets
Navigating to Planner Module
- Login to Unit4. Navigate to the vertical Main Menu along the left-hand side of the screen. Click on the Planner tab.
- You will see two rows for each cost centre (per fiscal year) for which you are responsible, or oversee. Choose the cost centre and type of budget (revenue/expense or payroll) that you want to view or edit.
View and Edit your Revenue/Expense budget
Step 1: Viewing Your Revenue/Expense Budget
Step 1: Viewing your Revenue/Expense Budget
- Once you've selected the Transaction Entry Screen that you want to view, you will see a Selection Criteria screen. This screen will default some values, including your cost centre. However, you can use this screen to filter your results in the Transaction Entry Screen. For revenue/expense, you can filter by Account or Work Order. By applying a filter, the number of results in the transaction screen will be narrowed.
- Once you are satisfied with your filters, click Load.
- You will now see a list of transactions by work order and by account in your Transaction entry screen.
- Your screen will look like the the below image when it loads. Items to note:
- NEW FOR FY25 - Rows will be highlighted red when there is an account with an actual value amount from the prior year, but no budget. This is just to help guide you in determining if budget amounts should be allocated differently.
- You can sort the columns by clicking on the header - I have sorted by Work Order in the screen shot.
- The amount columns include the budget for the next fiscal year, last year's actuals, and the current year's budget.
- Black numbers represent money in/revenue
- Red negative numbers represent money out/expenses
- The totals per column will show at the bottom of the table
Step 2: Editing Your Budget
Step 2: Editing Your Revenue/Expense Budget
- Once your Revenue/Expense budget is loaded, your screen should look like the screen below. To edit any of the figures in the budget column, click on the number you want to edit, and the cell will open.
- You will not be able to edit anything in the other two value columns (FY23 Actuals or FY24 Budget).
- If you make any changes to the values in the Transaction entry screen, please also include a note in the notes column.
- You can click Save as much as you want as you work. Don't forget to press Save when you are completed making changes!
View and Edit your Payroll budget
Step 1: Viewing Your Payroll Budget
Step 1: Viewing your Payroll Budget
- Once you've selected the Payroll Transaction Entry Screen that you want to view, you will see a Selection Criteria screen. This screen will default some values, including your cost centre. However, you can use this screen to filter your results in the Transaction Entry Screen. For Payroll transactions, you can filter by Account, Work Order, Employment Group, Position, or Pay step. By applying a filter, the number of results in the transaction screen will be narrowed.
- Once you are satisfied with your filters, click Load.
- You will now see a list of transactions by wage account (5000, 5299, and 5003), work order, and position in your Transaction entry screen.
- Your screen will look like the the below image when it loads. Items to note:
- You can sort the columns by clicking on the header. I would suggest sorting by account, Position, or Work Order.
- Each position will load a base wage amount (account 5000) AND a benefit load (account 5299). The benefit load is a flat rate by union - 26% for PPWC and Exempt, 28% for BCGEU and 31% for SCFA.
- The amount columns include:
- The Base Budget - Please don't make changes to this amount. This comes from the settings in the system and represents our starting, draft amount. Changes can be made in other columns to affect the calculated value in "$$ after FTE Change"
- Total Position FTE - this represents the FTE for the position, not necessarily what is budgeted in a work order or cost centre.
- FTE per WO - this represents the FTE budgeted for the specific work order listed in the second column, Work Order.
- FTE Change - this is a field that you can use to edit any expected changes to a position FTE during the year. Note that any changes made in this column will not actually impact the HR personnel file, only your budget. To make a change to the employee's contract, you will have to submit the necessary contract.
- New FTE - this is the calculation of the FTE per WO and the FTE Change columns. Note* - if the position is a partial year position, the calculation will not add properly across the row. See tip below on making changes to partial year positions.
- $$ after FTE Change - This is your new calculated budget for wages or benefits for the position.
- The account column will include:
- Account 5000 - Wages
- Account 5003 - Stipends
- Account 5299 - Benefits.
Step 2: Editing Your Payroll Budget