Solved: Deferent in Annual Gross Salary Previous Month & C...

Hi..Dear Experts,

Please resolve my problem one my employee annual gross salary showing different May & June month salary his monthly Gross 25000/- May-12 WD -26 Earnings 20967/- annual gross 256927/- but in the June-12 salary earnings 25000/- WD-29 annual gross 297257/-. deducted TDS of Rs.144/-. So in this case his annual gross amount showing deference May beetwin Jun-12 Gross 256927-297257=40330 difference month of Jun-2012. And i have already checked in RT table this specific different gross salary not showing please suggest me accordingly.

Thanks in advance,

Satish L.

SAP Managed Tags:
HCM (Human Capital Management)

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (1)

Hi..please any one adivce me... matter is most urgent...

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Can you share the employee RT screen shots using Pc00_m40_clstr.

Do you have any Sec 89 payments (Payment of March salary in april)?

Best Regards

Venkata Manikanth

Hi.Venkat,

Thanks for your valuable reply I have sent attacehed file in XLS file of RT tables May & June-12, so please downolad & suggest the next steps.

Awaiting for your reply.

Thansk & regards,

Satish

Hi Satish

I'm not able to read the RT result clear, when I download them these are opening in Note pad.

Can you check again and attach them.

Best Regards

Venkata Manikanth

Ok Dear Venkat,

I have sent in text. format but that not supported to you so, please find the below RT details are mentioned it is May-2012 data.

/101 Total gross amount

20,967.00

/111 EPF Basis

14,153.00

/112 ESI Basis

20,967.00

/113 ESI Basis Nominal

100,000.00 25,000.00

/114 HRA Basis

14,153.00

/115 COA/CLA Basis

20,967.00

/116 Gratuity Basis

14,153.00

/117 Superannuation Basis

14,153.00

/120 Nom. ExGrat Base Lo limit

100,000.00 16,875.00

/121 Nom. ExGrat Base Hi limit

100,000.00 16,875.00

/124 Mon Reg Income

20,967.00

/128 Leave Encashment Basis

/129 Voluntary Retirement Bas.

16,875.00

/134 Annual Non-perk amounts

419.00

/136 1DSD Basis Nominal

16,875.00

/137 1DSD Basis Actual

14,153.00

/138 Form 217 2(A) Basis

20,967.00

/139 VPF Basis

14,153.00

/140 LWF Basis

20,296.00

/3F1 Ee PF contribution 01 01

780.00

/3F3 Er PF contribution 01 01

239.00

/3F4 Er Pension contribution 01 01

541.00

/3F5 Ee Mon PF contribution

780.00

/3F6 Ee Ann PF contribution

9,360.00

/3F7 EDLI contri * 1,00,000 01 01

32.50

/3F8 EDLI adm chrgs * 1,00,000 01 01

1.00

/3FA PF basis for Ee contrib 01 01

6,500.00

/3FB PF Basis for Er Contrib 01 01

6,500.00

/3FC Pension Basis for Er cont 01 01

6,500.00

/3FJ VPF basis for Ee contrib 01 01

6,500.00

/3FL PF Basis for Er Contrib 01 01

6,500.00

/3I1 Deduction u/s 80

73,760.00

/3I2 Gross amount u/s 88

73,760.00

/3P1 Prof Tax - split period 01 10 01 03

200.00

/3P2 Professional Tax Basis 01 10 01 03

22,146.00

/3P3 Prof Tax - Full period

200.00

/401 Projection Factor

10.00

/410 Ann Reg Income

255,221.00

/411 Ann Irr Income

2,109.00

/416 Gross Salary

256,927.00

/418 Balance

256,927.00

/422 Empmnt tax (Prof Tax)

2,400.00

/424 Aggrg Deduction

2,400.00

/426 Incm under Hd Salary

254,527.00

/430 Gross Tot Income

254,527.00

/432 Agg of Chapter VI

73,760.00

/434 Total Income

180,770.00

/456 Tax deducted so far

729.00

/458 Net tax payable

729.00-

/4ME Monthly Education cess

1,941.75

/4MH Monthly Higher Edu cess

970.87

/4MI Monthly Taxable Income

14,129.70

/4MT Monthly Tax payable

97,087.38

/4T1 Income Tax Slab Rates 01 09

/4TE Edu Cess Ded Till Date

14.17

/4TT Tax Payable Ded Till Date

707.74

/550 Statutory net pay

19,987.00

/559 Bank transfer 01

19,987.00

/560 Net pay

19,987.00

/616 Add Gross Salary

403.00-

/700 Wage/salary + ER shares

21,747.00

/840 Diff.curr.from aver.month 01

16.00

/846 Total unpaid absences 01

40.00

1003 HRA

671.00

1018 Special allowance

5,724.00

1021 Medical Allowance

419.00

1042 Ex-Gratia

1,179.00

1051 Gratuity

812.00

1075 Mediclaim Insurance 128.00

1084 ER PF(Gokak)

780.00

9DUM HRA

671.00

/001 Valuation basis 1 01

146.49

/002 Valuation basis 2 01

146.49

/118 PTax Basis 01

22,146.00

/119 PTax Basis Nominal 01

100,000.00 26,406.00

1000 Basic 01

14,153.00

Thanks for your reply.

Satish.

Hi...Venkat

Please find the below June-2012 RT table here gross salary showing deferent WT /416 297,257.00 but both gross salary will shwoing deferent May-12 256,927.00-297,257.00= -40330.00. So my client was asking why it is deferent in June & May what purpose, so please check & advice the same.

/101 Total gross amount

25,000.00

/111 EPF Basis

16,875.00

/112 ESI Basis

25,000.00

/113 ESI Basis Nominal

100,000.00 25,000.00

/114 HRA Basis

16,875.00

/115 COA/CLA Basis

25,000.00

/116 Gratuity Basis

16,875.00

/117 Superannuation Basis

16,875.00

/120 Nom. ExGrat Base Lo limit

100,000.00 16,875.00

/121 Nom. ExGrat Base Hi limit

100,000.00 16,875.00

/124 Mon Reg Income

25,000.00

/128 Leave Encashment Basis

16,875.00

/129 Voluntary Retirement Bas.

16,875.00

/134 Annual Non-perk amounts

500.00

/136 1DSD Basis Nominal

16,875.00

/137 1DSD Basis Actual

16,875.00

/138 Form 217 2(A) Basis

25,000.00

/139 VPF Basis

16,875.00

/140 LWF Basis

24,200.00

/3F1 Ee PF contribution 01 01

780.00

/3F3 Er PF contribution 01 01

239.00

/3F4 Er Pension contribution 01 01

541.00

/3F5 Ee Mon PF contribution

780.00

/3F6 Ee Ann PF contribution

9,360.00

/3F7 EDLI contri * 1,00,000 01 01

32.50

/3F8 EDLI adm chrgs * 1,00,000 01 01

1.00

/3F9 PF adm chrgs * 1,00,000 01 01

72.00

/3FA PF basis for Ee contrib 01 01

6,500.00

/3FB PF Basis for Er Contrib 01 01

6,500.00

/3FC Pension Basis for Er cont 01 01

6,500.00

/3FJ VPF basis for Ee contrib 01 01

6,500.00

/3FL PF Basis for Er Contrib 01 01

6,500.00

/3I1 Deduction u/s 80

73,760.00

/3I2 Gross amount u/s 88

73,760.00

/3P1 Prof Tax - split period 01 10 01 03

200.00

/3P2 Professional Tax Basis 01 10 01 03

26,406.00

/3P3 Prof Tax - Full period

200.00

/401 Projection Factor

9.00

/403 Marginal tax rate

10.00

/404 Mrgnl tax rate with srch.

10.30

/410 Ann Reg Income

295,551.00

/411 Ann Irr Income

2,109.00

/416 Gross Salary

297,257.00

/418 Balance

297,257.00

/422 Empmnt tax (Prof Tax)

2,400.00

/424 Aggrg Deduction

2,400.00

/426 Incm under Hd Salary

294,857.00

/430 Gross Tot Income

294,857.00

/432 Agg of Chapter VI

73,760.00

/434 Total Income

221,100.00

/436 Tax on total Income

2,110.00

/446 Tax payable

2,110.00

/447 Sec and Higher Educ Cess

21.00

/449 Education Cess

42.00

/450 Tax payable and surcharge

2,173.00

/456 Tax deducted so far

729.00

/458 Net tax payable

1,444.00

/460 Income Tax

144.00

/4ME Monthly Education cess

1,941.75 2.79

/4MH Monthly Higher Edu cess

970.87 1.40

/4MI Monthly Taxable Income

18,162.71

/4MT Monthly Tax payable

97,087.38 139.81

/4T1 Income Tax Slab Rates 01 09

442,600.00

/4T1 Income Tax Slab Rates 02

20.00 4,260.00

/4TE Edu Cess Ded Till Date

14.17

/4TT Tax Payable Ded Till Date

707.74

/550 Statutory net pay

23,876.00

/559 Bank transfer 01

23,876.00

/560 Net pay

23,876.00

/616 Add Gross Salary

403.00-

/700 Wage/salary + ER shares

25,780.00

/840 Diff.curr.from aver.month 01

16.00

/845 Total paid non-work 01

8.00

1003 HRA

800.00

1018 Special allowance

6,825.00

1021 Medical Allowance

500.00

1042 Ex-Gratia

1,406.00

1051 Gratuity

812.00

1075 Mediclaim Insurance

128.00

1084 ER PF(Gokak)

780.00

9DUM HRA

800.00

/001 Valuation basis 1 01

146.49

/002 Valuation basis 2 01

146.49

/118 PTax Basis 01

26,406.00

/119 PTax Basis Nominal 01

100,000.00 26,406.00

1000 Basic 01

16,875.00

Thanks & regards,

Satish

I think you forgot about the projections, if any employee is having an loss of pay in may then the payroll sytem will calculate that month salary mulitple remaining months,and in june the employee is not having any loss of pay so again system will calc accordingly

Month	Earnings in the month	Projection
April	25000 Gross salary	300000
May	20967 (April 25000+ May salary20967*11) Loss of pay - 5days	255637
June	April 25000+ May 20967 ( June projection 25000*10)	295967
	Difference	40330

Due to this you are getting difference in May and june salary, but system is calculating correctly.

Hope this is clear

Best Regards

Venkata Manikanth

Yes Dear Venkat,

I have appreciate for your feedback.

16.05.2012 to 16.05.2012- Half Day Absent 1/2 Day

12.05.2012 to 12.05.2012 -Half Day Absent 1/2 Day

11.05.2012 to 11.05.2012 -9007 Absent 1 Day

04.05.2012 to 06.05.2012 -9007 Absent 2.Days

Total May-12 4 Days

So, 25000/31*27=21774 but system will considering 5 days absence please suggest next steps.

Can you check any LOP between saturday and sundays is counted?

As I can see 40 hrs are unpaid in /846 wage type

Best Regards

Venkata Manikanth

May 4th (Friday) to May 6th (Sunday) is 3 days loss of pay,, not 2 days

Hope this is clear

Best Regards

Venkata Manikanth

Ya..Sorry Dear Venkat.

Thanks it is very correct & solved also my issue.

Thanks & regards,

Satish.

Hi Satish

I hope my suggestions helped in resolving your problem.

Good luck

Best Regards

Venkata Manikanth

Yes Mr. Venkat,

Up course...it's very well suggestion to me keep it up thanks once again.

Satish

You have taken the forum help and not reawarded the members...

Answers (0)

Ask a Question

Top Q&A Solution Author

User

Count

Deferent in Annual Gross Salary Previous Month & Current Month

Accepted Solutions (1)

Accepted Solutions (1)

Answers (0)

Re: Batch Number Assignment

Batch Number Assignment

Maintenance Order Components - PR should create wi...

Automate [Inventory Valuation Simulation Report] i...

Re: Is there a CDS view that contains Label Type (...