pooja3545_sharma
28

Dear All,

All of you will be happy to know that I got a HR job in new company. The first task I got is to make Salaries. This is a automobile Industry so calculation policies are different. I need your help to manage this salary sheet. I need some Formulas setting bcoz old one is very difficult to understand.

The steps are:-

Late Time (LT):- 3 late time (LT) are considerable and after that we need to deduct half day salary.

Half Day:- for Half day need to deduct half day salary.

Sunday Present: Need to pay full day salary or can adjust with Absents.

For leaves:- Leaves have to be adjusted with Opening leave balance. If leave balance is zero then consider it as absent to deduct amount.

Closing leaves:- Need to calculate closing leave and carry forward it for next month.

Advances deduction

Mobile deduction

Deposit deductions

Then ESI / PF calculation.

Please help me to put formulas setting in this sheet. I will be very thankful. you can mail me at or in case of emergency can call me at 9630097328 (Official contact No).

Thanks

Poja Sharma

From India, Indore
pooja3545_sharma
28

PFA and help me for the same. Really need a help from excel expert. If any one from you can teach me that will be more good.
From India, Indore
Attached Files (Download Requires Membership)
File Type: xls Sample sheet.xls (32.0 KB, 859 views)

Abhijit_Barua
47

Dear Pooja Hum apko help nahi karenge Simple simple formula v apko logo se puchna parta hai, its not good dear.
From India, Kolkata
bhaktinarang_123
148

Hi,
Kindly find attached file.
Let me know if any help required.
Salary Statement Format « hrmexpress
Thanks,
Bhakti

From India, Mumbai
Attached Files (Download Requires Membership)
File Type: xls Salary Statement.xls (37.5 KB, 270 views)

pooja3545_sharma
28

Hi Bhakti,
Plz share ur No. or call me at 9630097328
Its urgent............................................ .................................................. .................................................. .................................................. ............................

From India, Indore
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.