Staff Attendance & Salary Automation System

Project Title:

Google Form + Google Sheet Automation for Staff Attendance & Salary Calculation

Project Description:

I need a professional who can create and integrate a Google Form with Google Sheets to manage staff attendance. The system should track check-in & check-out timings, maintain attendance records, and automatically calculate monthly salary based on working hours/days.
Key Requirements:
• A Google Form where staff can mark their Check-in & Check-out.
• Data should automatically update in a linked Google Sheet.
• Automatic calculation of:
• Date, Day, and Month of each entry
• Total working hours per employee
• Total present/absent days
• Salary calculation based on working days/hours & rate (to be entered per employee).
• Easy to use, clean, and reliable setup.
• Bonus: If possible, send monthly reports automatically.

Deliverables:
• Google Form (for attendance logging)
• Google Sheet (with formulas/automation for salary & reports)
• Documentation on how to use and maintain the system
Budget:

(Open to offers – please quote your best price)

Deadline:

Preferably within 5–7 days