Midwest ADP Payroll

Import Legacy Payroll Data (CSV)

Upload Excel Export

Select the target Pay Period, and upload your raw 22-column CSV export.

Column Requirement: Your CSV must exactly match the 22-column export structure:
  1. RECORD TYPE
  2. Last Name
  3. First Name
  4. Date of Birth
  5. Date of Hire
  6. Current Perod Hours
  7. Reg Rate
  8. REG HRS
  9. OT HRS
  10. Utilization (W1 Bill)
  11. Unnnamed (W1 Paid)
  12. Unnamed (W2 Bill)
  13. Unnamed (W2 Paid)
  14. Reg Pay
  15. OT Pay
  16. Other Pay
  17. Other Pay (hrs)
  18. Gross Pay
  19. Reimbursable Expenses
  20. FTE Status
  21. Dept
  22. Loc

System Configuration

Departments

    Locations

      Other Pay Types

        User Access Management

        Create new accounts or change passwords for existing users.

          System Reports

          Payroll Summary

          Counselor Utilization

          Employees

          Name / DatesSSNRoleDept / LocFT/PT401(k)Pay TypeStatusActions

          Pay Periods

          Pay DateStart DateEnd DateStatus

          Run Payroll

          Employee Payroll HoursCounselor Wk 1Counselor Wk 2 Other PayLive Calculation Preview
          RegOTBillPaidBillPaid Reg $OT $Reg+OT $Other $Gross Pay+ Reimb $