Payroll Preparation Assistance Needed
Can someone help me in preparing the payroll in Excel or MS Access with the following requirements:
- Earning Heads are Basic_DA, HRA, Conveyance, Medical, LTA, Education, Leave Encashment, and Overtime.
- We are dividing all the Earning Heads by the Days of the month (i.e., 31/30/29/28) and multiplying by Paid Days (Days of the month minus Absent and LWP (Leave without Pay)).
- To one group, we are paying the Allowances HRA, Conveyance, Medical, LTA, and Education fully if the Paid Days are not less than 18. If Paid Days go below 18, all the above allowances are paid proportionately, meaning (Rate of Allowances / month days * Paid Days).
- Overtime is being paid as round (Basic and DA/month days/4*OT Hours,0).
- Deduction Heads are PF, ESI, Prof. Tax, Income Tax, Advance, Loan, Canteen, and Mobile, etc.
- PF is calculated on a maximum of Rs. 6500/- Basic only.
- ESI as per Act.
- Professional Tax IF(Earnings>=12000,200,IF(Earnings >=9000,150, IF(Earnings >=6000,80,IF(Earnings >=3000,20,0)))).
- Loan/Advance Register (Balances to be maintained and updated on processing Payroll).
- Loan is also being paid and deducted monthly in equal installments, and installments can be corrected as per need.
- We are giving 5 Sick Leaves, 5 Casual Leaves, and Privilege Leave as earned in the previous Calendar Year, with the balance to be maintained.
- Bonus is also paid as per Act.
- PF Deductions as per Act.
- ESI Deductions as per Act.
- Attendance includes (Weekly Off, Presence, Outdoor Duty, Public Holiday, Compensatory Off, Privilege Leave, Casual Leave, Sick Leave, Accidental Leave, Leave Without Pay (LWP), Absent).
- Adjustment for the previous month's less or excess paid/deductions for all the heads in the next month.
- Detail for Form 16 of Income is available at any time.
- Salary/Wages are being paid through Bank. In the case of a new appointment, if a Bank A/C is not available, we pay A/C Payee Cheque or Cash as the case may be.
- Full and Final Settlement is also made through the System.
My email address is [Email Removed For Privacy Reasons].
Thanking you,
Vinod Sharma
Can someone help me in preparing the payroll in Excel or MS Access with the following requirements:
- Earning Heads are Basic_DA, HRA, Conveyance, Medical, LTA, Education, Leave Encashment, and Overtime.
- We are dividing all the Earning Heads by the Days of the month (i.e., 31/30/29/28) and multiplying by Paid Days (Days of the month minus Absent and LWP (Leave without Pay)).
- To one group, we are paying the Allowances HRA, Conveyance, Medical, LTA, and Education fully if the Paid Days are not less than 18. If Paid Days go below 18, all the above allowances are paid proportionately, meaning (Rate of Allowances / month days * Paid Days).
- Overtime is being paid as round (Basic and DA/month days/4*OT Hours,0).
- Deduction Heads are PF, ESI, Prof. Tax, Income Tax, Advance, Loan, Canteen, and Mobile, etc.
- PF is calculated on a maximum of Rs. 6500/- Basic only.
- ESI as per Act.
- Professional Tax IF(Earnings>=12000,200,IF(Earnings >=9000,150, IF(Earnings >=6000,80,IF(Earnings >=3000,20,0)))).
- Loan/Advance Register (Balances to be maintained and updated on processing Payroll).
- Loan is also being paid and deducted monthly in equal installments, and installments can be corrected as per need.
- We are giving 5 Sick Leaves, 5 Casual Leaves, and Privilege Leave as earned in the previous Calendar Year, with the balance to be maintained.
- Bonus is also paid as per Act.
- PF Deductions as per Act.
- ESI Deductions as per Act.
- Attendance includes (Weekly Off, Presence, Outdoor Duty, Public Holiday, Compensatory Off, Privilege Leave, Casual Leave, Sick Leave, Accidental Leave, Leave Without Pay (LWP), Absent).
- Adjustment for the previous month's less or excess paid/deductions for all the heads in the next month.
- Detail for Form 16 of Income is available at any time.
- Salary/Wages are being paid through Bank. In the case of a new appointment, if a Bank A/C is not available, we pay A/C Payee Cheque or Cash as the case may be.
- Full and Final Settlement is also made through the System.
My email address is [Email Removed For Privacy Reasons].
Thanking you,
Vinod Sharma