محاسبة/كل الحراج/رواتب/برمجة وتصاميم/اكسيل

Professional Payroll Sheet

Al Mubarraz
Updated 14 hr. ago
M
100
The end of the month has arrived... and you're still calculating each employee's absences on paper and a calculator? 😩 Every month, the same cycle: review attendance, calculate deductions, remember advances, and end up with a small mistake that turns into a problem with an employee. I've prepared the solution for you: an integrated payroll and attendance system in one Excel file. Enter the month's data, and it calculates everything on its own. 👇 ✅ Monthly attendance and absence record with a dropdown list for each day, and automatic coloring for attendance, absence, and leaves. ✅ Full payroll statement from basic salary to net salary, without touching a single formula. ✅ Calculation of allowances (housing, transportation, other allowances) and bonuses. ✅ Overtime and lateness are automatically calculated by the hour and minute. ✅ Social insurance and taxes with rates and brackets that you adjust yourself according to your country. ✅ Record of advances with installments deducted each month automatically, stopping when the advance is fully repaid. ✅ Ready-to-print payroll slips (Pay Slips) for each employee, or individual slips with the employee code. ✅ A dashboard showing total salaries, deductions, and costs by department. ✅ No macros or complex programs, all of this in one organized and easy Excel file. 🎯 Suitable for any shop, office, or small to medium-sized company. ⏱ What you need to do each month: change the month number, record attendance, and it will handle the rest. Save hours of end-of-month work, and provide each employee with their slip professionally. 💼 #Accounting #Payroll #Excel #HR #Business_Management #Small_Projects #Attendance #Accountant
Professional Payroll Sheet 0