Hansa Vyas
A Good Learner Always
M.Sayeed
Procurements
Krishnamkn
H R Labour Laws & Payroll
Supriya1515
Counselling To Students
K.V.PADMANABHAN UNNI
Chief Accountant
K@prachi
Hr Admin
Mushahid Rajput
Hr Recruitment
+7 Others

Thread Started by #supriya1515

Hi
I newly joined as HR-Executive in one small concern with 25 to 30 members,can anyone help me in preparing the salary in simple format.And still we don't have PF,ESI and HRA etc only the Basic salary.Could any one forward me the format to calculate the salary in simple form with leave deduction
Thanks
23rd May 2011 From India, Bangalore
Hi Thanks for ur reply could u pls forward me the formulae for that,bcoz we dedute for more then one day salary and it would be fine for me if i get the formula for that
24th May 2011 From India, Bangalore
Please find attachments 1, With PF deduction 2, Without PF, just simple salary. Thanks,
24th May 2011 From Kuwait, Hawalli

Attached Files
Membership is required for download. Create An Account First
File Type: xls SALARY(1).xls (23.5 KB, 10133 views)
File Type: xls SALARY with out PF Deduction.xls (22.5 KB, 24635 views)

Hi
Supriya
I`ll suggst u to make compensation policy first... ya it will take time but without policy in Hr you will be needing the help of othr at every step....and aply for ESI & PF asap...
In Compnsation policy you will have to decide few things like
1. Grade of empolyees
2. Basic pay as per the grade
3. Conv. allw. as per the grade
4. HRA
5 . othr allw.
24th May 2011 From India, Delhi
dear sir,
i am kumudha, i am new joining in my company at hr department .how to handle the hr department? how to follow the ledger? and how many ledger follows the department?
kindly help me.
thanks & regards,
kumudha.7708959776
24th May 2011 From India, Selam
dear Mr. sayeed,
I have some doubts in the salary sheet with PF.i hope i can ask & clear my doubt.
1.In Basic salary u had used formula 1200/D4*F4,why you had taken 1200 & suppose if different people hv different basic than.
2. In DA column it is 900 from where does or only 900 is used ,is it standard or for what it is taken.
Regards,
Hansa Vyas
24th May 2011 From India, Udaipur
Dear Hansa Vyas,
Whatever Sayeed is given that is absolute perfect. in that there is no doubt at all.
Basic may be different for different people & DA there is Skilled Base & that there is table given Commercial office (Tardeo).
Regards,
Bhaven Gala
24th May 2011 From India, Mumbai
Dear Mr. Hansa,
1, 1200 is used as an example, if its other then 1200, then formula is same, total days - absent days..
2, Daily allowance 900 is also used as an example, its not standard.
Please review below attached for more detials its really very well explain..this I have downloded from this forum only.
Thanks,
24th May 2011 From Kuwait, Hawalli

Attached Files
Membership is required for download. Create An Account First
File Type: xls Salary Sheet & PF PT Calculation & Challan.xls (2.81 MB, 10600 views)

if you use attached sheet your work very easy
25th May 2011 From India, Delhi

Attached Files
Membership is required for download. Create An Account First
File Type: xls SALARY.xls (23.0 KB, 4756 views)

Dear Supriya,
The simple format for salary Calculation with necessary formula including PF, ESIC & PT. If its not necessary to you can delete columns. Its may be full fill your query.
Regards,
Krishna Murthy
Bangalore
25th May 2011 From India, Bangalore

Attached Files
Membership is required for download. Create An Account First
File Type: xls Sample Salary Statement.xls (34.0 KB, 2071 views)

Hi,
I am alok , I have 3 year exp. in Hr, my resonsibility is salary process and hr backend data prepared with MIS.
right now, my jobs has left. plz someone help me.
Thanks
Regd
Alok kumar -9560725164
17th August 2011 From India, Delhi
Dear all if basic 10000, & pf deduction for 6500, att. 28 day for the month of sep-2011. how to calculate pf. kindly suggest me. Thanks Pramod Keshari
14th October 2011 From India, Calcutta
Hi all,
I have been working for a sales company. In our company, we dont have proper payroll format. pls suggest me the proper salary format. pls throw light on how to calculate Basic, HRA , DA , Medical Reimbursement, Special Allowances.
Is it necessary to DA and conveyance for all Category employess?
Thanks
31st July 2012 From India, Madras
Dear Ms.Kumudha,
What are the ledgers to be followed is based on the nature of industry you are into.
muster roll, salary register, late attendance registers are some of the basic registers to be maintained.
Regards,
Kumar
13th June 2013 From India, Chennai
You can do this with MS access also with very simply.
see this link.
WHAT YOU GIVE TO WORLD LAST SECOND: Salary software for small Company
4th December 2013 From Maldives, Male
Dear Friends, I have recently joined as accountant in a private college. Could you please guide me the procedure for PF,ESI,TDS and PROFESSION TAX in excel format with journal entryy please. email; unnimenon2014p@rediffmail.com
Thanks in advance.
19th March 2015 From India, Palakkad
Hi
i newly joined a small company with less than 20 employees as HR executive i wanted to know regarding pf clauses is pf applicable to this company if yes than how should i mention those clauses in appointment letter
and also please send me some sample format of appointment letter with TDS, PT and PF rules that are mentioned into it
22nd July 2015 From India, Pune
my ctc is 19700.....900 is pf can i stop pf deduction pf from my salary even haven't competed my probation period in my company my ctc is 19700.....900 is pf can i stop pf deduction pf from my salary even haven't competed my probation period in my company
17th June 2016 From India, Mumbai
Hi, i am working in Karnataka Rural Infrastructure Development as Data entry Operator, My salary is 9734/-, how much deduct EPF amount in my Salary. and what are the rules about EPF deductions.
23rd July 2016 From India, Arsapur
Hello Sir,
i wont to know my salary pf contribution if i eligible or not..??
we received our monthly payment INR - 24667.00 per month
but my company had not paid/contribute PF.
one of my other employee are also worked be with & his salary 80,000 above taken by employer, and employer also paid/contribution PF.. i can't understand that condition..??
could u explain why is this for..?
12th June 2018 From India, Bhopal
Dear Sir/Mam,
I am looking job , i have 3- years experience in HR Operation , so if you have any vacancy so please let me know.
Regards
Manikant Kumar
16th May 2019 From India, Delhi
Reply (Add What You Know) Start New Discussion

Cite.Co - is a repository of information created by your industry peers and experienced seniors. Register Here and help by adding your inputs to this topic/query page.
Prime Sponsor: TALENTEDGE - Certification Courses for career growth from top institutes like IIM / XLRI direct to device (online digital learning)





About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2019 Cite.Co™