Employee Payroll List Columns

The Employee Payroll List contains a standard set of columns. You cannot select columns for this report. In the header, the report lists the W-2 year and quarter for which data is displayed. The body of the report displays the hours and pay data for the reporting period that you specify on the General tab, as well as withholding data for each employee.

Columns

Column Description
Employee Number/ Name This column displays the employee's identification number and name.
Social Security No This column displays the employee's Social Security number.
Rate For salaried employees, this column displays the employee's actual pay amount for each payroll period. For hourly employees, it displays their hourly pay rate.
Ovt Pct This column displays the percentage applied to the employee's payroll rate to calculate standard overtime wages.
Ovt-2 Pct This column displays the percentage to apply to the employee's payroll rate to calculate special overtime wages.

This column is available only if Secondary Overtime is selected on the General tab of the Accounting System Settings form (Settings > Advanced Accounting > System).

Regular This column displays the regular hours the employee worked during the period that you specify on the General tab, during the Form W-2 year, and during the Form W-2 quarter.
Overtime This column displays the overtime hours the employee worked during the period you specify in Time Frame on the General tab, during the Form W-2 year, and during the Form W-2 quarter.
Overtime-2 This column displays the secondary overtime hours the employee worked during the period you specify in Time Frame on the General tab, during the Form W-2 year, and during the Form W-2 quarter.

This column is available only if Secondary Overtime is selected on the General tab of the Accounting System Settings form.

Total This column displays the total hours the employee worked during the period you specify in Time Frame on the General tab, during the Form W-2 year, and during the Form W-2 quarter. The total hours is the sum of the regular, overtime, and secondary overtime hours.
Regular This column displays the regular pay the employee received during the period you specify in Time Frame on the General tab, during the Form W-2 year, and during the Form W-2 quarter.
Overtime This column displays the overtime pay the employee received during the period you specify in Time Frame on the General tab, during the Form W-2 year, and during the Form W-2 quarter.
Overtime-2 This column displays the secondary overtime pay the employee received during the period you specify in Time Frame on the General tab, during the Form W-2 year, and during the Form W-2 quarter.

This column is available only if Secondary Overtime is selected on the General tab of the Accounting System Settings form.

Other Pay columns These columns display the other types of pay the employee received during the period you specify in Time Frame on the General tab, during the Form W-2 year, and during the Form W-2 quarter.
Total This column displays the total pay the employee received during the period you specify in Time Frame on the General tab, during the Form W-2 year, and during the Form W-2 quarter.
Code This column displays the codes for types of withholding from the employee's pay.

You assign withholding codes to employees on the Payroll tab of the Employees hub.

Active This column displays the status of the withholding code for the employee: Active or Inactive.
Method This column displays the method used to calculate withholding amounts:
  • Amount: DPS withholds a fixed amount. The Amount or Percent column displays that amount.
  • System: DPS calculates withholding based on the default method set up for the type of withholding in Payroll Settings.
  • Percentage: DPS withholds a specified percentage of the employee's pay. The Amount or Percent column displays that percentage.
Amount/Pct If the Method column contains Amount or Percentage, this column displays the amount or percentage of wages withheld.

If the Method column contains System, this column is blank.

Add'l Amount If an amount is withheld for the employee in addition to the withholding amount DPS calculates, this column displays that amount.

Examples: An amount to supplement federal or state withholding amounts to guard against under-withholding, or an amount to compensate for withholding too much or too little for prior paychecks.

Limit If the withholding has a limit on the amount that is withheld, this column displays that maximum amount.
Limit-to-Date If the withholding code has a limit, this column displays the amount withheld to date that applies to that limit.
Last Payroll This column displays the amount withheld the last time payroll was processed.

This column is only displayed if you select the Print Last Payroll Withholding Column check box on the General tab.

Withheld amounts columns These columns display the amounts withheld for the following:
  • CUR or Periods or Dates: The amount withheld during the period that you specify in Time Frame on the General tab.
  • QTD: The amount withheld during the Form W-2 quarter that you specify on the General tab.
  • YTD: The amount withheld during the Form W-2 year that you specify on the General tab.
St. If the withholding is for a tax that requires a filing status, this column displays the employee's filing status (for example, M for Married, S for Single, or H for Head of Household).
Ex. If the withholding is for a tax for which there are exemptions, this column displays the number of exemptions that the employee claims.
OE.s If the tax locale distinguishes between types of exemptions, this column displays any "other" exemptions the employee claims.