Excel Requirements for the ProPunch Data Import Follow
The USB flash drive in the ProPunch Bundle contains three essential Excel spreadsheets for importing data into the software: Employees.xlsx, Punches.xlsx, and WorkCodes.xlsx. Below are detailed requirements and an example illustrating how to populate each spreadsheet. For instructions on uploading the files, check out this articles:
Employees:
Required Fields: All red fields are required.
Username: alphanumeric
Employee Id: Value must be unique.
Employee Type: (Employee, Supervisor, or Administrator)
First Name:
Last Name:
Start Date: MM/DD/YYYY
Pay Calculations: Go to company setup >> pay calculations to retrieve the correct name.
Time Zone: It will auto-generate once you import the employees successfully.
Clock User Id: Up to 9 digits. Required for enrolling employees on the clock.
Security Level: Employee or Administrator
Password: Numeric only. Limit 9 digits.
ID Card #: Enter the number printed on the badge
Example:
Punches:
Required Fields: All red fields are required.
Employee Id: Numeric
Local Time: MM/DD/YYYY 00:00 (24 hr format)
Type: IN OUT (Punches associated with a timestamp)
Pay Category: Regular, Vacation, Holiday, Sick (Leave this field blank for punches that have a timestamp and IN OUT type)
Date: MM/DD/YYYY
Minutes/Amount: Enter the value in minutes or the amount.
Work Code 1:
Work Code 2:
Work Code 3:
Example:
Work Codes:
Required Fields: All red fields are required.
Work Code List Name: This field is limited to 50 characters, and it must be enabled and created in the ProPunch software before attempting to import.
Work Code Name: Up to 50 characters allowed.
Abbreviation: Up to 6 characters allowed.
Payroll Code: Up to 32 characters allowed.
Example: