Wrong Provision Of Gratuity - Accounting Problem - XLS Download

Respected Mr. kumar.s. Sir
here I am attaching payroll excel file which is suitable for Indian system only .I tried my very best to make it suitable to middle east salary system but i couldn't,
dear sir please help me to solve this problem..I need below mentioned items in my salary slip,
Payments
Basic Pay
HRA
Overtime
Telephone Allowance
Temporary Assignment -
Arrears (in increment)
Special allowance
DEDUCTIONS
Company Loan
Passage Loan
Cash Advance
Others
Regards
Murali
attribution http://citehr.com#ixzz3EmBqyUIY

Dear Murali,

So far as format of a Pay roll concerned, items as emoluments broken down into various heads should find places in your Excel sheet. I hope you have your structure already finalised with your employees, if so put them under appropriate heads. Likewise the deductions also then you get the Net payable/credited to the Bank a/cs of the concerned. I don't find difficulty in formating the Excel sheet for a pay roll. On the other hand if you are yet to finalise what are the break ups of salary, I have no answer, you have to do there. However, I hope the information available in the following links should give you some more information in the matter. Try them.

Payroll Software Dubai - HR Management - WPS - HRMS - Document Management System

Dubai Salary Details and Negotiation Tips

https://answers.yahoo.com/question/i...9225558AAjAnJF

Salary Slip Format

Regards

There is no problem since the employee is still continuing with you, if the employee leaves in this year you can make the payment and account for on actual basis or if the employee continues even in next year you can make provision on actuarial. Please consult your Chartered Accountant for this he will guide you.