Planner User Guide

Step 1: Viewing your Revenue/Expense Budget

1. 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.

   1. Accounts

      There is numerical logic in the account sequence. Any account that begins with a 4XXX will be a revenue account. To filter to all revenue accounts, in the Account field, type "4*". The * will act as a wildcard and pull up all accounts that begin with a 4.  For your reference, we've provided a short summary of the account logic:

      4XXX - Revenues

      5XXX - Wages and Personnel Costs

      6XXX - Ancillary and Internal Costs

      7XXX - Utilities, Vehicles, and Equipment

      8XXX - Discretionary Spending 

      Work Orders

      Filtering by work order will help to reduce the number of transactions you see in your entry screen. This also helps you to budget by a specific project, school, etc. To easily filter to your work orders, you can use the type-ahead functionality in this box. There are a few different ways you can do this, depending on your preference: 

      1 - Use the first 4 digits in the name of your work order (e.g. type in "2213" for the work order, "2213 Accounting Services Administration), 

      2 - Type any word from the name of your work order (e.g. "Accounting" to look up "Accounting Services Administration")

      3 - Type in the actual work order number (e.g. 30-110-001)

      **Tip** - don't forget to go to each work order in your Cost Centre if you do use this function!

2. Once you are satisfied with your filters, click Load.
3. You will now see a list of transactions by work order and by account in your Transaction entry screen. 
4. 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 Revenue/Expense Budget

1. 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. 
   1. 
   2. You will not be able to edit anything in the other two value columns (FY23 Actuals or FY24 Budget).
2. If you make any changes to the values in the Transaction entry screen, please also include a note in the notes column. 
3. You can click Save as much as you want as you work. Don't forget to press Save when you are completed making changes!  
   1. 

Step 1: Viewing your Payroll  Budget

1. 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.
   1. 
2. Once you are satisfied with your filters, click Load.
3. You will now see a list of transactions by wage account (5000, 5299, and 5003), work order, and position in your Transaction entry screen. 
4. 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

Wages have been loaded with bargained and expected annual lifts, so there is no need to enter a 2% wage increase unless you think a position will be re-evaluated.

• Once your Payroll budget is loaded, your screen should look like the screen shot below.  You can use the FTE Change column to increase or decrease an FTE. The forecasted budget for that position will change accordingly. 
  1. **REMINDER** - if you modify the FTE in a wage account (5000 row), you also need to modify the FTE for the benefits (5299 row). 
  2. 
• If you make any changes to the values in the Transactions 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.  
• As a final step, it is important to check your total budgeted FTEs. The best way to do that is to go back to Selection criteria, and filter to account 5000. Your results will now show the total FTE (in thousands) in the New FTE column. 
  • 
  • Here is a screen shot of the New FTE total for position 100855. 200% FTE is 2.0 FTE. However, if I filter to only account 5000, my FTE would correctly show at 100%. 
  •