# Record Attendance Manually or via Excel import
**YouTube:** [How to Record Attendance Manually or via Excel import?](https://www.youtube.com/watch?v=ogOTHAlej5U)
## How to Record Attendance Manually or via Excel import?
In this tutorial, we will learn how to **define employee attendance** in the **Payroll module** of Logic ERP, using both **manual entry** and **Excel import** methods.
***
### **Method 1: Mark Attendance Manually**
#### **Open Attendance Register**
* Navigate to **Main Menu → Payroll Entries → Attendance Register**.
* This option allows you to define attendance manually for employees.
* Select the **Shift Type** and **Date**.
#### **Choose Employee Selection Type**
* Choose whether to mark attendance for a **Single Employee** or **Multiple Employees**.
* Click on the **More Options (three dots)** button to open the **Attendance Register** window.
#### **Mark Attendance**
* Select the employee(s) by ticking the checkbox next to their names.
* In the grid on the right, mark each employee as **Present** or **Absent**.
* For present employees, define the **Time In** and **Time Out**.
* Click **Save** once attendance is entered.
* You can also sort the employee list by **Name** or **Code**, as required.
#### **Mark Attendance for Multiple Employees**
* Tick multiple employees at once.
* Choose **Present** or **Absent**, select the appropriate **Attendance Attribute** (e.g., Full Day, Half Day), and define **Time In** and **Time Out**.
* Click **Save** to record the data.
* The total work hours and rate per day can also be viewed or edited at the bottom of the screen.
***
### **Method 2: Mark Month-wise Attendance**
#### **Open Month-wise Attendance Register**
* Go to **Payroll Entries → Attendance Register (Month-wise)**.
* Select the **Payroll Year** and **Month**, then click **Refresh** to load employee records.
#### **Update Attendance**
* Double-click on any date cell or press **F6** to open the marking option.
* For present employees, select **Present** and choose the attribute (**Full Day / Half Day**).
* For absentees, mark as **Absent** and select the **Leave Type**.
* To mark multiple employees together, **drag to select** the required cells and press **F6**.
> *Note: If an employee’s attendance appears blank, it may be due to a joining date after the selected date.*
#### **Edit or View Leave Balance**
* Press **F6** again to edit any entry.
* To view leave balance, click on the employee’s name and press **F2** — their leave summary will appear on screen.
***
### **Method 3: Import Attendance from Excel**
#### **Open Import Option**
* Go to **Payroll Entries → Import Attendance Data from External Source**.
* Click **Configuration** to create a new setup.
* Enter a **Configuration Name** and **Save** it.
#### **Configure Excel Import Settings**
* Open the configuration again and select **Excel** as the import type.
* Under **Date Format**, choose the same format used in your Excel file.
* Similarly, match the **Time Format** with your file’s format.
* Enable **Get Entry Type on Basis of Employee Shift** to load attendance according to assigned shifts.
* Then enable **Validate Shift Type** to include specific shifts (e.g., Night Shift or All Shifts).
* Define **Maximum Time Validation** limits (before and after shift time).
* Tick **Mark Leave Without Pay for Employees Not in File** to automatically assign LWP for missing records.
* Under **Excel Option Settings**, browse and select your attendance file.
* Set the **Header Row** as **1**.
* Map:
* **Employee Code** → corresponding Excel column
* **Date** → Date column
* **Time In / Time Out** → respective columns
* Choose **Excel File Type = Row Based**, then click **OK** to save mapping.
#### **Import Attendance**
* Select your Excel file again and tick **Show Employees in File Only** to restrict import to listed employees.
* Define the **Date Range** and optionally select a **Branch**.
* Click **Start Import** to begin.
> *If “Show Employees in File Only” is unchecked, the system will display all employees — those not in the file will be marked as absent.*
#### **Save Attendance**
* Once the import completes, verify the data.
* Click **Save** to record the imported attendance in the system.
***
### **Result**
You have successfully learned how to:
* Mark attendance manually (single or multiple employees).
* Update month-wise attendance.
* Import attendance from an Excel sheet.
This ensures accurate and efficient attendance management within the Payroll module of Logic ERP.
---
# Agent Instructions: Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://kb.logicerp.com/logic-erp-installation-configuration-and-troubleshooting-solutions/faqs/payroll/record-attendance-manually-or-via-excel-import.md?ask=
```
The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.