logo

Attendance Import

{primary} Attendance Import can be used to import employee monthly attendance that helps in calculating working days and loss of paydays while running payroll.

In employees details, the employee Attendance source should be set to "Upload File".

Employees-->View Employees-->Click on any employee name-->Attendance Source-->Upload File (Attendance Import)

{primary} Note: Only 100 employees attendance data can be imported at a time.

Step 1:

Go to Time & Attendance--> Attendance--> Attendance Import

Step 2:

Upon clicking on the submenu Attendance Import, the "Attendance Import" page will appear on the screen. Click on the 'Sample Import File' link to download the sample file.

Alternatively, the User can click on the Import Attendance button and click on the Download button to download the sample file.

Step 3:

Open the downloaded .xlsx file and enter the attendance details of the employees for whom the User wants to import the attendance. Save the file on your system.

Step 4:

Now, click on the Import Attendance button to import the file.

Step 5:

Select the pay period for which you want to import the attendance.

Step 6:

Attendance calculated using Days is the only option selected by default.

Step 7:

After this click on "Choose File" button to upload the saved attendance .xlsx file.

Step 8:

After uploading the file, click on Import Attendance button.

Step 9:

After clicking on the Import Attendance button, check the mapping of the Attendance Excel Fields to Sumopayroll Attendance Mapping Fields and click on Next button.

Step 10:

Review the data that is being imported. After reviewing and validating the correctness of the data click on the "Save" button.

Step 11:

Upon clicking on the "Save" button, a confirmation will appear on the screen and you can view the imported file in the grid in the 'Attendance Import' page. Attendance Import summary report will be emailed to the User.