on 07-12-2012 5:59 AM
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.
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.
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
Hi
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.
User | Count |
---|---|
106 | |
14 | |
10 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.