Hi Members,
Can someone help me in preparing the payroll in excel or in MS Access with the following requirements:-
Thanking you,
Vinod Sharma
Can someone help me in preparing the payroll in excel or in 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 with the Days of the month i.e. 31/30/29/28 and multiplying with Paid Days (Days of month – 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 the 18 all the above allowances are paid proportionately, means (Rate of Allowances / month days * Paid Days)
- Overtime is being paid 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 maximum 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 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 and 5 Casual Leaves and Privilege Leave as earned in the previous Calendar Year, 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, Out Door 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 all the heads in the next month.
- Detail for Form 16 of Income, available at any time.
- Salary / Wages are being paid through Bank, in the case of new appointment if Bank A/C is not available; we pay A/C Payee Cheque or Cash as the case may be.
- Full and Final Settlement also be made through the System.
Thanking you,
Vinod Sharma