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.