Custom Fingerprint Software for Attendance & Excel Reports
Budget: ₹12,500 – ₹37,500 INR
I am the Manager at **Company A (UK)** and **Company B (India)**.
As discussed, I’m sharing the complete requirements for the **biometric attendance and payroll integration software** for Company A.
---
### Organisation Summary
Company A is a care home where staff operate in multiple shifts (including nights), across various departments. The organisation has defined policies for **attendance, leave, payroll**, and **role-based pay structures**.
---
### Documents Provided for Development
The attached Excel file includes:
* Active staff list (name, DOB, joining date, grade, pay rate, etc.)
* Department-wise grade structure
* Shift schedule and staff limits
* Leave types and entitlement rules
* Role-specific pay conditions
* Payroll month: 16th to 15th
* Payroll year: 16th March to 15th March
---
### Leave Types & Entitlement Logic
**Annual Leave (AL):**
* 0–23 months: 35 days/year
* 24–47 months: 42 days/year
* 48+ months: 49 days/year
* Leave lapses if not used
* Paid based on average hours from the past 104 weeks
**Sick Leave (SL):**
* First 3 days: Unpaid
* After 3rd day: £118.75/week (up to 28 weeks)
* Must have average weekly pay ≥ £125
**Statutory Maternity Pay (SMP):**
* Minimum 26 weeks’ service before the 15th week prior to due date
* Average earnings ≥ £125
* First 6 weeks: 90% of pay
* Next 33 weeks: £187.18/week or 90%, whichever is lower
---
### Pay Logic & Role-Based Variations
* Hourly pay based on grade and shift
* Extra £0.50/hour for Shift Leaders/Deputy Managers
**Training Pay:**
* 70% after 7 months
* Additional 10% at 10, 12, and 13 months
* Manual entries allowed for **Extra Pay/Escort Duty**
* **Bank Holiday Bonus:** +£1/hour
* **Christmas/New Year Post-Midnight Work:** Double pay
---
### Late Login / Early Logout Policy
* 1–15 minutes late/early: Deduct 15 mins
* 16–30 minutes: Deduct 30 mins, and so on
* No extra pay if logout is ≤1 hour late
* Full extra time paid if >1 hour late logout
---
### Biometric Clock-In Role Prompt
At clock-in, the system must prompt for role selection:
* HCA
* SHCA
* Shift Leader
* Deputy Manager
This must directly impact pay rate calculation.
---
### Payroll Period
* Monthly salary cycle: 16th to 15th
* Payroll year: 16th March to 15th March
---
### Required Reports (Excel & PDF Downloads)
1. Late Login / Early Logout Summary
2. Missing Swipes Report
3. Daily & Monthly Staff Attendance + Pay Summary (with AL/SL/SMP details)
4. Payroll Import Report – directly usable in BrightPay software
---
### Mandatory Excel Report Templates
**Tab 1 – Daily Report**
* Attendance + pay breakdown in required format
**Tab 2 – Monthly Summary (16.03 to 15.04)**
* Attendance + pay breakdown in required format
**Tab 3 – Monthly Biometric Log**
* Daily & monthly records per employee
**Tab 4 – BrightPay Import Format**
* Final import-ready file for payroll integration
---
### Integration & Upgrade Scope
* All staff already use the biometric machine
* This project is an upgrade to automate calculations and improve reporting
---
### Kindly Share:
1. Estimated timeline for delivering this customized, cloud-based solution
2. Your quotation, including:
* a) Software development & customization
* b) Biometric integration
* c) Support/maintenance (if offered)
If you need clarification on the attached Excel structure or workflow, I’m happy to explain further over a call or email.
Looking forward to your response.
As discussed, I’m sharing the complete requirements for the **biometric attendance and payroll integration software** for Company A.
---
### Organisation Summary
Company A is a care home where staff operate in multiple shifts (including nights), across various departments. The organisation has defined policies for **attendance, leave, payroll**, and **role-based pay structures**.
---
### Documents Provided for Development
The attached Excel file includes:
* Active staff list (name, DOB, joining date, grade, pay rate, etc.)
* Department-wise grade structure
* Shift schedule and staff limits
* Leave types and entitlement rules
* Role-specific pay conditions
* Payroll month: 16th to 15th
* Payroll year: 16th March to 15th March
---
### Leave Types & Entitlement Logic
**Annual Leave (AL):**
* 0–23 months: 35 days/year
* 24–47 months: 42 days/year
* 48+ months: 49 days/year
* Leave lapses if not used
* Paid based on average hours from the past 104 weeks
**Sick Leave (SL):**
* First 3 days: Unpaid
* After 3rd day: £118.75/week (up to 28 weeks)
* Must have average weekly pay ≥ £125
**Statutory Maternity Pay (SMP):**
* Minimum 26 weeks’ service before the 15th week prior to due date
* Average earnings ≥ £125
* First 6 weeks: 90% of pay
* Next 33 weeks: £187.18/week or 90%, whichever is lower
---
### Pay Logic & Role-Based Variations
* Hourly pay based on grade and shift
* Extra £0.50/hour for Shift Leaders/Deputy Managers
**Training Pay:**
* 70% after 7 months
* Additional 10% at 10, 12, and 13 months
* Manual entries allowed for **Extra Pay/Escort Duty**
* **Bank Holiday Bonus:** +£1/hour
* **Christmas/New Year Post-Midnight Work:** Double pay
---
### Late Login / Early Logout Policy
* 1–15 minutes late/early: Deduct 15 mins
* 16–30 minutes: Deduct 30 mins, and so on
* No extra pay if logout is ≤1 hour late
* Full extra time paid if >1 hour late logout
---
### Biometric Clock-In Role Prompt
At clock-in, the system must prompt for role selection:
* HCA
* SHCA
* Shift Leader
* Deputy Manager
This must directly impact pay rate calculation.
---
### Payroll Period
* Monthly salary cycle: 16th to 15th
* Payroll year: 16th March to 15th March
---
### Required Reports (Excel & PDF Downloads)
1. Late Login / Early Logout Summary
2. Missing Swipes Report
3. Daily & Monthly Staff Attendance + Pay Summary (with AL/SL/SMP details)
4. Payroll Import Report – directly usable in BrightPay software
---
### Mandatory Excel Report Templates
**Tab 1 – Daily Report**
* Attendance + pay breakdown in required format
**Tab 2 – Monthly Summary (16.03 to 15.04)**
* Attendance + pay breakdown in required format
**Tab 3 – Monthly Biometric Log**
* Daily & monthly records per employee
**Tab 4 – BrightPay Import Format**
* Final import-ready file for payroll integration
---
### Integration & Upgrade Scope
* All staff already use the biometric machine
* This project is an upgrade to automate calculations and improve reporting
---
### Kindly Share:
1. Estimated timeline for delivering this customized, cloud-based solution
2. Your quotation, including:
* a) Software development & customization
* b) Biometric integration
* c) Support/maintenance (if offered)
If you need clarification on the attached Excel structure or workflow, I’m happy to explain further over a call or email.
Looking forward to your response.