Manual payroll data entry

Last updated: 2024-09-10

Roles:

  • Compliance Specialist and Payroll = modify access
  • All other construction and CRL roles including the Contractor role = no access

This is one of the four methods used to enter or import payrolls into AASHTOWare Project Civil Rights & Labor (AWP CRL). The information below outlines the manual payroll data entry process.

Requirements:
  • This process is the same for both prime contractors and subcontractors.
  • Payroll numbers should be sequential. The begin date should be one day later than the end date of the previous payroll.
  • The contractors role does not have access to enter payrolls. Contractor and subcontractor staff who enter payrolls must use the Payroll role. Contractor staff with multiple roles will need to switch to the Payroll role to complete these tasks.

 

  1. Log onto WisDOT AASHTOWare Project with your WAMS ID and associated password. Go to System log on for assistance with this.
  2. Make sure "PROJECT WisDOT Payroll" is the active role. If it is not, go to Understanding roles - How to switch between roles for detailed instructions.
  3. From the dashboard search for and select the contract on the Vendor Payrolls Overview component by searching for the Contract ID, controlling project ID, project description, vendor (contractor) ID or contractor in the search box.
    Tips:
    If the contract is not found, contact the AWP System Administrators at AWPSupport@dot.wi.gov for assistance as the vendor payroll contact may not have vendor authority access to the contract.

  4. Click on the payroll hyperlink for the contract that your company is entering payrolls for.


  5. Note the number of the last payroll entered. Select Open Component Actions Menu | Add New Payroll.


  6. On the External Add Certified Payroll component, enter the following fields:
    1. Enter the next payroll number in the sequence (based on the number noted for the last payroll entered on the previous component plus 1).
    2. Begin Date - The date the payroll period began (based on a 7-day work week, normally a Sunday).
    3. End Date - The date the payroll period ended (based on a 7-day work week, normally a Saturday).
    4. Comments - any additional comments about the payroll record.
    5. Click <Save>.

Complete these steps for reference employees who were previously recorded in AASHTOWare Project because they already have payrolls entered in the system or they worked for a different contractor in the past.

  1. Select the Employee quick link OR select Open Component Actions Menu | Open Payroll Employees Summary.
  2. From the Employees collapsible panel, select Open Component Actions Menu | Add Ref Employees.

  3. Search for and select the reference employee records under the Select Reference Employees component by searching for the employee first or last name, a portion of the address, city, or partial social security number in the search box. An Advanced Filter may also be used. See Searching, sorting, and filtering lists for details.
  4. Click <Add to Employees>.

  5. Go to Entering payrolls for each employee to finish recording payroll information for each employee by entering the required information as described in this section.

Complete these steps to add a new contractor or subcontractor employee who does not have a Reference Employee record from a previous payroll or former employer.

  1. On the External Payroll Employees component, click the Employee quick link.


  2. On the External Payroll Employees component, select Open Component Actions Menu | Add Employee to add a brand new employee to the system.


  3. On the Payroll Employee component, enter the following fields:
    1. First name
    2. Middle initial (optional)
    3. Last name
    4. Social Security number - This value MUST be entered correctly as it cannot be updated later. Only a limited number of staff can see this value once it has been entered.
    5. Payroll Type - Select from drop down list. Either Hourly or Salaried.
    6. Gender - Select from drop down list.
    7. Ethnic Group - Select from drop down list
    8. Personal street address plus city, state and zip code
    9. Employee Comments (i.e. check number, per diem paid, other payments, other project hours, mileage, etc.)
    10. Click <Save>.
      11. Info:
      • Repeat steps 2-3 to add additional employees for this payroll.
      • The fields noted above are all required fields.


Complete these steps to enter the classification, hours worked, wages, deductions and exceptions for each employee on this payroll. Repeat steps 1-3 for each employee.

  1. After all employees have been added to this payroll, click the Employees quick link to return to the External Payroll Employees component.>

  2. Select an employee from the drop down list in the Employees section.



  3. Data entry is broken down into these five sections. Click <Save> after entering data in each section.
    1. Classification
      This section is used to record the employee's classification, hourly rates, fringe benefits, if they are part of the OJT program, or an apprentice.
      1. Select the Contract Project ID for the employee.
      2. Search for and select the Labor Classification by entering the labor class ID number or a portion of the description.
      3. Select the Craft Code from the drop down list. The Craft Code is related to the Labor Class.
        4. Examples:

        Labor Class 1401 Bricklayer - 10 = Craft Code 400 - Bricklayer/Cement Mason/Concrete Finisher

      4. Straight Hourly Rate
      5. Overtime Hourly Rate
      6. Training Information (optional)
        • Check OJT Program Indicator if they are part of the training program.
          • Wage Percentage of 100% is required.
        • Check Apprentice Indicator if the employee is an apprentice.
          • Enter their apprentice ID
          • Apprentice wage percentage varies.
      7. Fringe benefits - need more information
      8. Click <Save>.

    2. Hours
      This section is used to record hours worked by the employee for the time period of the payroll.
      1. Straight Time Hours - Enter the straight time hours as they were paid for the week.
      2. Overtime Hours - Enter the overtime hours as they were paid for the week.
      3. Total Straight Time Hours - Enter the total straight time hours for the week.
      4. Total Overtime Hours - Enter the total overtime hours for the week.
      5. Classification Total Hours - Enter the total number of hours for the straight time and overtime hours for the week.
      6. Click <Save>.
      7. Once the record is saved, check to see if the total hours entered for straight time, overtime, and classification equal the calculated fields for the corresponding fields.

    3. Wages
      This section is used to record employee wage information.
      1. Project Classification Gross Pay - Wages the employee was paid for the above classification.
      2. Total Gross Pay - Gross amount on the employee's pay-stub / earning statement.
      3. Net Pay - Net pay on the employee's pay-stub / earning statement.
      4. Total Deductions - The sum of FICA, federal, state, and Medicare withholdings plus other deductions listed in the Deductions section.
      5. FICA Withholding Amount - The amount of Social Security tax to be deducted from the employee's gross amount for the pay period.
      6. Federal Withholding Amount - The amount of federal tax to be deducted from the employee's gross amount for the pay period.
      7. State Withholding Amount - The amount of state tax to be deducted from the employee's gross amount for the pay period.
      8. Medicate Withholding Amount - The amount of Medicare tax to be deducted from the employee's gross amount for the pay period.
      9. Total Fringe Benefits Paid - The total fringe benefit amount earned by the employee for the classification for the pay period.
      10. Click <Save>.

    4. Deductions
      This section is used to record other deductions that are additional or irregular deductions that the employee chooses to make.
      1. Click <New> to enter payroll deductions that are not withholdings. See image above as these other deductions should be added to the Total Deductions field under the Wages section.
      2. Enter a payroll deduction description.
        3. Examples:

        Child support, Levy, garnishments, union dues, vacation, 401 employee contributions

      3. Enter the amount.
      4. Click <Save>.
    5. Exception
      This section is for employees who do not receive the benefits listed on the payroll page.
      1. Click <New> to enter an exception.
      2. Enter an Expl (explanation).
        3. Examples:

        No benefits - seasonal employee

      3. Click <Save>.

Complete these steps to enter the classification, hours worked, wages, deductions and exceptions for each employee on this payroll. Repeat steps 1-3 for each employee.

  1. After all employees have been added to this payroll, click the Employees quick link to return to the External Payroll Employees component.>

  2. Select an employee from the drop down list in the Employees section.



  3. Data entry is broken down into these five sections. Click <Save> after entering data in each section.
    1. Classification
      This section is used to record the employee's classification, fringe benefits, and if they are part of the OJT program or an apprentice.
      1. Select the Contract Project ID for the employee.
      2. Search for and select the Labor Classification by entering the labor class ID number or a portion of the description.
      3. Select the Craft Code from the drop down list. The Craft Code is related to the Labor Class.
        4. Examples:

        Labor Class 1401 Bricklayer - 10 = Craft Code 400 - Bricklayer/Cement Mason/Concrete Finisher

      4. Training Information (optional)
        • Check OJT Program Indicator if they are part of the training program.
          • Wage Percentage of 100% is required.
        • Check Apprentice Indicator if the employee is an apprentice.
          • Enter their apprentice ID
          • Apprentice wage percentage varies.
      5. Fringe benefits - need more information
      6. Click <Save>.

    2. Hours
      This section is used to record hours worked by the employee for the time period of the payroll.
      1. Salaried Employee Hours - Totals for Sunday - Saturday
      2. Total Project Classification Salaried Hours
      3. Total Pay Period Salaried Hours
      4. Normal Salary - Weekly salary
      5. Total Gross Pay
      6. Net Pay
      7. Total Deductions
      8. Click <Save>.
      9. Once the record is saved, check to see if the total hours entered for straight time, overtime, and classification equal the calculated fields for the corresponding fields.

    3. Wages
      This section is used to record employee wage information.
      1. Project Classification Gross Pay - Wages the employee was paid for the above classification.
      2. Total Gross Pay - Gross amount on the employee's pay-stub / earning statement.
      3. Net Pay - Net pay on the employee's pay-stub / earning statement.
      4. Total Deductions - The sum of FICA, federal, state, and Medicare withholdings plus other deductions listed in the Deductions section.
      5. FICA Withholding Amount - The amount of Social Security tax to be deducted from the employee's gross amount for the pay period.
      6. Federal Withholding Amount - The amount of federal tax to be deducted from the employee's gross amount for the pay period.
      7. State Withholding Amount - The amount of state tax to be deducted from the employee's gross amount for the pay period.
      8. Medicate Withholding Amount - The amount of Medicare tax to be deducted from the employee's gross amount for the pay period.
      9. Total Fringe Benefits Paid - The total fringe benefit amount earned by the employee for the classification for the pay period.
      10. Click <Save>.

    4. Deductions
      This section is used to record other deductions that are additional or irregular deductions that the employee chooses to make.
      1. Click <New> to enter payroll deductions that are not withholdings. See image above as these other deductions should be added to the Total Deductions field under the Wages section.
      2. Enter a payroll deduction description.
        3. Examples:

        Child support, Levy, garnishments, union dues, vacation, 401 employee contributions

      3. Enter the amount.
      4. Click <Save>.
    5. Exception
      This section is for employees who do not receive the benefits listed on the payroll page.
      1. Click <New> to enter an exception.
      2. Enter an Expl (explanation).
        3. Examples:

        No benefits - seasonal employee

      3. Click <Save>.

Complete these steps to create a second entry for an employee on this payroll if the employee has multiple classifications or tasks, if there are multiple projects the employee worked on, if the OT fringe benefits are different under certain circumstances, or the employee earns a different OT rate under certain circumstances.

  1. On the External Payroll Employees component Employees section, click the Open Components Action Menu | Add New Project / Classification to Employee.

  2. On the Add New Project/Classification to Employee component

    1. Update one or more of the fields under the Classification section

    2. Select the employee(s) on the lower portion of the component.

      3. Examples:

      In the example, we added

      Labor Classification: 402 - Cement Mason/Concreate Finisher - 10
      AND
      Craft Code: 400 - Bricklayer/Cement Mason/Concrete Finisher
      to the employee Mickey Mouse.

  3. Click <Add Classification/Project to Employee> to add the record to the selected employee(s).

  4. Upon saving the additional record for the employee, control will be returned to the External Payroll Employees component.

  5. From the Employees component section, select the new employee project or classification entry from the list.

  6. Go to Entering payrolls for each employee to enter payroll information for this project or classification.

To update the employee's name, personal address, etc. complete the steps below:

  1. On the External Payroll Employees component Employees section, select the employee from the drop down list.
  2. Click on the Employee Information hyperlink.
  3. Update the employee's information on the Payroll Employee component.
  4. Click <Save>.

Complete these steps to delete an employee record from a payroll.

Warning: Keep in mind that if the employee has multiple project or classification records, all employee records will be deleted from this payroll.

  1. On the External Payroll Employees component Employees section, select the employee from the drop down list.

  2. Note the employee name to ensure the correct record is selected.

  3. Select Open Component Actions Menu | Delete.