Attendance+Sal Stmt+ Payslipmail with NO Password.....!!!!!

newmoon_1984 · 02-11-2009, 10:54 AM

Hello,
Dear,

Thanks for sharing.
Keep posting such stuff

a2287884 · 02-11-2009, 10:56 AM

please clear me below mentioned points

how does it calculate
is there any mandary % percentage formula from goverment of india
like x % of CTC is basic
x % of basic PF
x % of hra
x % of other allowance

My company deduct PF from my CTC how to calculate it then
my company gives education, and much other allowance in payslip

is there any percentage schemes if yes then how to get addition in those excel file
please let me know on

mediah · 02-11-2009, 11:14 AM

Dear Sir,

I need some information on PF :

- What should be the minimum salary from which the PF is mandatory.
- What should be the maximum salary when PF becomes optional.
- what should be the employee strength of the organisation when PF becomes mandatory.

If anyone can give me information on the PF.

Regards,
Swaroop

Quote:

Originally Posted by mani.ragi

Dear all,

Enclosed the zip file for your reference. U can use according to your organisation.

Usage : Update attendance, salary and verify.

In sal Stmt select all (Ctrl+A) copy and paste special as values.
Now go to word document and open, click yes (to update database).GO to Mailings in the document (OFF-07 users) change the company name logo at your convinience and and clik on finish and merge,select send mail messages and click ok.

This completes the operation(sal stmt,attandance and payslip generation).

Regards,

mani.ragi · 02-11-2009, 11:22 AM

Dear a2287884,

There is not mandatory % mentioned by GOI,but GOI Stated few rules/Acts like Minimum wages Act,Labour welfare Act,others for salary schemes.

All the companies will follow it relying on the nature of work.

U have stated that your Company deducts PF From your CTC (Cost To Company)according to company policy.

CALCULATION OF YOUR CTC:

The CTC structure ,I think u have this details bcoz evry company will provide these details in the offer letter.

rdas · 02-11-2009, 11:23 AM

Thanks for attechment its realy helpful...............

mani.ragi · 02-11-2009, 11:33 AM

Dear Swaroop,

The minimum emp strength must be 20 to start PF for an organisation.
If the Basic is more than 6500 for all the employees in the organisation then company will send the nil return.

Regards

vsplash · 02-11-2009, 12:15 PM

Nice One Do keep posting such useful information

Thank you.

Maady · 02-11-2009, 02:16 PM

Hi
Very nice,

Its very useful

Thank You
Ur's
Maady

c.subramanian · 02-11-2009, 03:20 PM

Hi Mani

Good Work frd, keep posting

Subramanian

mallela.ravikiran · 02-11-2009, 05:18 PM

it's very nice.
thank you so much for shareing U R views

Regards,
Ravi Kiran

View Poll Results: Is this helpful?
Yes	4	50.00%
Excellent very Useful	4	50.00%
More features required	0	0%
Voters: 8. You may not vote on this poll