Hi Members,
Can someone help me in preparing the payroll in excel or in MS Access with the following requirements:-
Thanking you,
Vinod Sharma
From India, Lucknow
Acknowledge(0)
Amend(0)
1Can 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
From India, Lucknow
Acknowledge(0)Amend(0)
Dear Vinod,
Regarding payroll, every company follows its own methods. Some companies fix a basic salary and then calculate additional components such as HRA (40%), Conveyance (10%), and fringe benefits (40%).
Please review this information and let me know if you have any concerns. You can reach me at raghavendrababu2020@gmail.com or 7799581189.
Regards,
Raghu
From India, Hyderabad
Acknowledge(0)Amend(0)
Regarding payroll, every company follows its own methods. Some companies fix a basic salary and then calculate additional components such as HRA (40%), Conveyance (10%), and fringe benefits (40%).
Please review this information and let me know if you have any concerns. You can reach me at raghavendrababu2020@gmail.com or 7799581189.
Regards,
Raghu
From India, Hyderabad
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
Leave Encashment & Salary Calculation.xls x
LEAVE ENCASHMENT NOT INCLUDED IN WAGES FOR P. F. CALCULATION.pdf