Attendance System

👤 User ID

🔒 Password

👷 Attendance System

🏢 Company Name:

📋 Attendance Records Excel

📁 Data stored in month-wise Excel files 0 records

👤 Select Worker:

Month

Year

#	Date	Worker	Department	Mobile	In	Out	Hours	OT	Break	Status	Salary
No records

Add Attendance

Worker *

Date *

Status *

Check In

Check Out

☕ Break / Lunch Timing

Break Start

Break End

Break Hours

Include break deduction

Net Hours

Overtime (after 8 hrs)

Working Day Status

Break Deducted

Auto-calculate hours

📈 Worker Summary

Select a worker from dropdown or table

👥 All Workers Excel WhatsApp PDF

Total: 0 workers 💡 Click on any row to edit | 📱 Send PDF button for WhatsApp

ID	Name	Department	Mobile	Hourly Rate	OT Rate	Action	WhatsApp PDF
No workers

Add Worker

Name *

Department *

Mobile Number (10 digits)

Hourly Rate (₹)

OT Rate (₹)

💰 Advance Records Advances

📁 All advance records 0 records

👤 Filter by Worker:

#	Date	Worker	Department	Amount (₹)	Reason	Action
No advance records

Add Advance

Worker *

Date *

Amount (₹) *

Reason

📊 Advance Summary

Select a worker to see advance summary

🎁 Bonus Records Bonus

📁 All bonus records 0 records

👤 Filter by Worker:

#	Date	Worker	Department	Amount (₹)	Reason	Action
No bonus records

Add Bonus

Worker *

Date *

Amount (₹) *

Reason

📊 Bonus Summary

Select a worker to see bonus summary

📊 Monthly Reports With Advances With Bonus WhatsApp PDF

👤 Single Worker Report

Complete report with attendance, salary, advance & bonus

Select Worker

Month

Year

📊 All Workers Report

Complete report for all workers with advance & bonus deductions

Month

Year

Workers

Working Days (12h+)

Partial Days

Hours

Gross Salary

Advance

Bonus

📱 PDF on WhatsApp: PDF download hoga + WhatsApp chat khulega. Bas attach icon (📎) dabakar PDF select karein aur send karein.

ℹ️ Note: Working Day sirf tab count hoga jab duty 12 ghante ya usse zyada ho. 12 ghante se kam duty wale din Partial Days me count honge, lekin unka payment milta rahega. Absent days ka koi payment nahi.

Select worker and month, then click Generate

📁 Personal Folder - Month-wise Files Auto Save

📂 Folder Location: 🔴 Select folder first Auto-restores on reload

📁 Select Your Personal Folder

Ek baar folder select karein - uske baad saara data (Workers + Attendance + Advances + Bonuses) mahine ke hisaab se alag Excel files mein save hoga. Folder automatically restore ho jayega next time.

📌 Month-wise File System:
✅ Har mahine ki alag file — January, February, March...
✅ Workers Sheet - सभी Workers की List
✅ Attendance Sheet - सभी Attendance Records
✅ Advances Sheet - सभी Advance Records
✅ Bonuses Sheet - सभी Bonus Records
✅ Summary Sheet - Company Info & Statistics

🔄 Kaise kaam karta hai:
• Same mahine me save → purani file delete, nayi file current date+time ke saath
• Naya mahina aane par → purane mahine ki file safe rahegi, nayi file banegi
• Reload par current mahine ki latest file load hogi

👷 Attendance System

📁 Select Your Personal Folder

📥 Download

📊 Export

💰 Export