SU/VA Faculty Salary Calculation Template

Overview

The SU/VA Faculty Salary Calculation Template is a standardized Excel workbook used by many universities and academic institutions to compute faculty compensation consistently. It brings together the various pay elementsbase salary, step increments, merit raises, special allowances, and deductionsinto a single, transparent calculation engine.

The template is designed to comply with the salary guidelines set by the State University (SU) and the Virginia (VA) System of Higher Education. While the sheet can be adapted for other institutions, the prebuilt formulas, validation rules, and lookup tables reflect the specific policies that govern SU/VA faculty pay scales.

Key Components

1. Faculty Data Input

This section captures basic identifying information: name, department, rank (Assistant, Associate, Full), appointment type (tenuretrack, nontenuretrack, adjunct), and the effective date of the salary change.

2. Salary Scale Tables

Two lookup tables store the official salary ranges for each rank and step. The tables are referenced by the calculation engine to automatically pull the appropriate base pay when a rank and step are selected.

3. Merit & Incentive Adjustments

Separate columns allow the user to enter merit increase percentages, research awards, clinical stipend amounts, and any other performancebased increments. The template applies these values to the base salary before taxes and deductions are calculated.

4. Deductions & Contributions

Mandatory deductions (federal and state income tax, Social Security, Medicare) and optional contributions (retirement plan, health insurance, union dues) are automatically computed based on the gross salary.

5. Summary Report

A concise, printable summary shows the gross salary, total deductions, and net pay. It also displays a breakdown of each adjustment for easy verification.

How to Use the Template

1. Open the workbook and enable macros if prompted (the template uses a small macro to refresh lookup tables).
2. Enter faculty data on the Input sheet. Use the dropdown lists for rank and appointment type to avoid typographical errors.
3. Select the appropriate step. The step number determines the base salary from the Scales sheet.
4. Input any merit or incentive amounts in the Adjustments sheet. The template accepts either a percent (e.g., 3%) or a flat dollar amount.
5. Review the deductions. The default tax rates are preloaded, but you can edit them for fiscalyear changes.
6. Check the Summary sheet. All calculations are refreshed automatically. Verify that the net pay matches expectations.
7. Print or export the summary for inclusion in payroll records or faculty letters.

Example Calculation

Assume Dr. Jane Doe is an Associate Professor (rank code 2) at step 5 with a merit increase of 4% and a clinical stipend of $2,500.

This example demonstrates how the template pulls the base salary, applies merit and stipend adjustments, and then calculates the final net compensation.

Tips & Common Issues

• Keep the scale tables updated each fiscal year; otherwise base salaries will be outdated.
• Validate data entry by using the builtin dropdowns. Manual typing of rank or step can break the lookup.
• Check tax rate cells before each calculation cycle. State tax percentages can change annually.
• Backup the workbook before making large edits. Use Save As to preserve a clean version for later reference.
• If the net salary appears unusually high or low, review the Adjustments sheet for accidental doubleentry of incentives.

Download the Template

The latest version of the SU/VA Faculty Salary Calculation Template can be downloaded from the official university HR portal. The file is provided in .xlsx format and includes a brief user guide.

Download SU/VA Salary Template (Excel)