Salary Schedules

Salary Schedules are the tables used in Negotiations to define the pay scale for the school district.  Within the Salary Schedules option, five different tables can be built for each package, including the Salary Schedule - Amounts table, Salary Schedule - Percents table, FTE/Hours table, Salary Totals table, and Benefit Totals table.

If percents are used on the pay scale OR steps and lanes increment by percentages or fixed dollar amounts, build the Salary Schedule - Percents table first.  Otherwise, if each step and lane has a fixed dollar amount that is incremented without consistency, build the Salary Schedule - Amounts table first (and do not build the Salary Schedule - Percents table).  The Salary Schedule - Amounts table (if applicable) and the FTE/Hours table must be built prior to the Salary Totals and Benefit Totals tables.  Also, the Salary Totals table must be built before the Benefit Totals Table.

Note:  If all the employees in one package will have a fixed percentage or dollar increase from their previous year’s wages, the Salary Schedule - Percents or Salary Schedule - Amounts tables do not need to be built; only build the FTE/Hours, Salary Totals, and Benefit Totals tables.

Steps to Build a Salary Schedule - Percents Table

Steps to Build a Salary Schedule - Amounts Table

Steps to Build an FTE/Hours Table

Steps to Build a Salary Totals Table

Steps to Build a Benefit Totals Table

Steps to View Salary Schedules

Steps to Add Additional Dollars to a Step and Lane in a Salary Schedule

Steps to Add Labels for Steps and Lanes in a Salary Schedule

Steps to Close Steps and Lanes in a Salary Schedule

Steps to View Employees Included in a Step and Lane on a Salary Schedule

Steps to View Information Specific to a Step and Lane in a Salary Schedule

Tips:

• Once a table has been built successfully, lock the table to prevent if from being accidentally recalculated.
• A table created for one package can be copied to another package using the Copy Table option, or the Copy Package option can be used instead to copy an entire package including all the tables (and the labels for the steps and lanes).
• The salary schedules (tables) for a package can be exported to a spreadsheet file, if desired; refer to the Viewing Salary Schedules topic.
• The Salary Schedule - Amounts table for a package can be imported from a spreadsheet file, if desired.

Steps to Lock a Table

Steps to Copy a Table

Steps to Copy a Package

Steps to Import the Salary Schedule - Amounts Table