When using the payroll salary schedules, you may want to run separate projections for different salary schedules — for example, for certified and classified.
You may click on a previous tab at any time to return
to the previous window if you need to make changes.
You may save a set of parameters at any time while using the development
tool.
Complete the selections on all tabs, and then return to Using the Budget Development Tool to complete the budget development process.
Select the Cycle whose salary schedules you want to use as a base. Note: You can use salary schedules from a different cycle than you selected in the previous window.
Select one or more salary schedules in the Salary Schedules grid.
Check the Increment employee's Salary Schedule Step box if you want to move the employees up one step for the projections.
You can use the parameters on this tab to get very specific about the positions included in the projections.
Complete as many Job Selection parameters as needed to create a subset of positions for the projections.
Jobs States: Check the boxes to include new, approved, and/or closed jobs.
Job Type: Check the boxes to include daily, hourly, and/or salary jobs.
Unpaid jobs: Check the box if you want to include them.
Supplemental jobs: Check the box if you want to include them.
Designations: Check these boxes if you want to include only certain designations for the positions using the salary schedule(s).
Job Account Code Filter: Click the , and use the Account Code Expression dialog to select the set of account codes you want to use. Note: Expenses will be projected only for jobs that include one or more of these account codes.
Complete the Employee Selection parameters as described.
Paycheck Site: Check the boxes if you want to generate a budget for one or more sites. Leave the boxes unchecked to include all sites.
Department: Check the boxes if you want to generate a budget for one or more departments. Leave the boxes unchecked to include all departments.
Display Name: Check the boxes to include specific employees.
Select the Optimization options as described.
You may want to use the second option (speed) first
using only a couple of employees to see the results, then compare
them to the results you get using the first option (accuracy) with
a couple of employees. When the results are close to what you want,
you can run the wizard using the first option.
Option 1: Calculate expenses for each payroll period in the Source Account Cycle. This option produces the most accurate projection and may take a very long time because it takes each employee with his/her deduction set and calculates the cost for 12 actual pay periods.
Option 2: Selecting this option causes the budget projections to be made by calculating the deduction expenses for one payroll period for each employee and then multiplying those results by the appropriate number of periods. These projections will be less accurate, but will take much less time to calculate.
Model Period Date: Enter the date to be used to select the single payroll period that will be used in the calculation. We recommend that you choose a date that will be representative of employees' pay for the majority of the year. For example, if teachers are paid on a ten-month basis, do not pick a date that falls during the summer break.
Number of Periods: Enter the number of payroll periods to be used in the calculation. For example, if you pay employees twice a month, enter 24; if you pay them biweekly, enter 26.
The list includes all deductions defined in the selected Accounting Cycle that have an employer-side amount. The FICA and Medicare deductions will not appear in this list as their amounts are calculated by the tax engine and therefore harder to override.
Select the deductions you want to include in the projections.
You can edit deduction amounts if you know they're changing.
Check the box for the deduction you want to edit, and click the Edit button. The Edit Deduction dialog opens.
Enter the new Amount, and click Save.
The Balance & Account Type Selection parameters aren't available or required for the Payroll Positions projections.
Result Account Code Filter:
Skip this step if you want to include all GL accounts.
Click the , and use the Account Code Expression dialog to select the set of GL accounts you want to use. Note: Projections will be calculated and then filtered to show only the selected account codes.
Balance Selection: Select either Actual or Budget. Note: Selecting Actual will use the current YTD expenditures; selecting Budget will use the amounts budgeted for the current year.
Account Type Selection: Check or uncheck boxes to include or exclude expenditures, revenue, other financing uses, and/or other financing sources.
Salary Increase: Check the box(es) and enter an amount and/or a percentage. Note: If you don't check the box, the increase or decrease won't be calculated, even if you enter an amount or percentage.
If both the Increase Amount and the Increase Percentage boxes are checked, the Increase Percentage will be applied first, followed by the Increase Amount.
Both fields will accept negative values to allow for projected decreases.
Once you've completed the selections on all tabs, return to Using the Budget Development Tool to complete the budget development process.
Return to Using the Budget Development Tool