# Attendance and Leave Import

### 1. How to do bulk Comp off Upload?

For the Compensatory off or Comp Off Attendance import in bulk first you need to import the attendance.

**Path:** Cloud login > Attendance > import > Attendance Import > Download sample file > Add new setting name > Select starting-ending row Range > Upload the template > Fill the date range > Mention component columns > Select the sheet name > Select employee code column > Click on Save settings > And Upload the file.\
**Step 1:** Log in to the **Cloud portal**, go to the **‘Attendance’** menu, and select **‘Import’**, then click on **‘Attendance Import’**.

<figure><img src="https://4282324958-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MXep_PEmh8mDPVWj49x%2Fuploads%2FBgaC5AMukQ5RbsXI0lAk%2F0.png?alt=media" alt=""><figcaption></figcaption></figure>

**Step 2:** Click **‘Sample attendance leave import’** to download the required template (Excel File) for the attendance data. Make necessary changes in the Excel file as per your need.

![](https://4282324958-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MXep_PEmh8mDPVWj49x%2Fuploads%2FlNEShVw7SRzv4SElEMGv%2F1.png?alt=media)

**Step 3:** Click **‘Add new setting name’** and enter a name for your template.

![](https://4282324958-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MXep_PEmh8mDPVWj49x%2Fuploads%2FaUmjiUUr5tZkEmJkP1SC%2F2.png?alt=media)

**Step 4:** Specify the range by mentioning the **‘starting row’** and **‘ending row’**. and **upload the template (Upload the Excel File which you have downloaded and made changes)** file you have filled.

<figure><img src="https://4282324958-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MXep_PEmh8mDPVWj49x%2Fuploads%2FkWh82tChEMp8x7u3hnM3%2F3.png?alt=media" alt=""><figcaption></figcaption></figure>

**Step 5**: Select the ‘**Date Range’,** Map the data by mentioning the **‘component columns’** from your file, selecting the correct **‘sheet name’**, and identifying the **‘employee code column’**. (Map all these elements from the Excel sheet uploaded).

![](https://4282324958-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MXep_PEmh8mDPVWj49x%2Fuploads%2FOecryfgi1fRvshro72vZ%2F4.png?alt=media)

**Step 6:** Finally, click **‘Save settings’** to save your import configuration. Then select **‘Upload File’** to complete the attendance import process.

![](https://4282324958-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MXep_PEmh8mDPVWj49x%2Fuploads%2FUMucJRP6OsMfy75lEN2S%2F5.png?alt=media)

**Link:** <https://cloud.pockethrms.com/Attendance/Settings/AttendanceImport?import=61>

To credit the comp off kindly refer to the link below:\
<https://docs.pockethrms.com/faqs/cloud-portal/leave#id-1.-how-to-credit-comp-off-for-multiple-employee-at-the-same-time>

For any queries, contact <support@pockethrms.com>
