I am also happy to know that officers of some Departments received the first instalment of arrears even before their first salary drawn as per the accepted recommendations of the 6th Central Pay Commission, as per feedback received over phone/email.
Meanwhile, alongwith several of my colleagues, I am still awaiting receipt of the first instalment of arrears.
A copy of the Resolution and the CCS Pay (Revised) Rules, are available at http://excisebangalore3.gov.in/.
The pay calculator is now largely updated and covers almost the entire spectrum, including -S1 Pay Band corresponding to Old Scales S-1 to S-3. I have now covered even Merger and Upgradation of posts.
It can be used by
- Those who had joined the Department before 01 January 2006 and have not had pay fixation on account of promotion or ACP,
- Those who had joined the Department before 01 January 2006 and had pay fixation on account of promotion or ACP,
- Those who had joined the Department after 01 January 2006 and have not had pay fixation on account of promotion / Selection grade.
- Physically Handicapped / disabled employees.
It is not suitable for use by Defence employees with MSP.
You may feel free to download, test and give your comments and feedback. While giving feedback on errors in the calculator, please furnish details about input you have given to the calculator, so that I can locate the exact cause of the error, and also know whether the instructions in the entry screen are being followed correctly, as wrong input will definitely result in wrong results. In some cases, the errors are genuine are have been, or are being, fixed, and wherever the feedback was received through mail, I have informed them about the reason for the error and whether it has been fixed.
Those accessing this blog from Headquarters Office, Bangalore-III Central Excise Commissionerate click here to download.
Those with upgraded and merged pay, and those who have received promotions after 01 January 2006 may use this version
Feedback regarding alterations, corrections or modifications are most welcome.
Windows Settings required for using the application:
In Regional Options, Currency should be set to Rupees and Date should be set to European format. otherwise, the figures will be shown in $ instead of Rs. and dates may be shown as ########.
To do this in Windows XP: Go to Control Panel, select Date, Time, Language and Regional Options, then select Regional and Language Options. There, select Location as India (Default is United States). Select Language as English (United Kingdom) and click on the Customize button. In the new dialogue box that opens, click on the Currency tab and change the currency from $ or £ or € to Rs. and then click on the Date button and change the Short Date Format to DD/MM/YYYY and remove the Weekday from the Long Date Format. Then click OK on the Customize tab and again OK on the Regional and Language Options Tab.
To do this in Windows Vista: Go to Control Panel, select Change Display Language. In the dialogue box that opens, click on the Formats Tab and select Current Format as English (India). Click on the Location Tab and select India. Then click OK.
Feedback can be sent by clicking comments below or email to bsudhiracharya@gmail.com or sudhiracharya@hotmail.com or bsudhiracharya@yahoo.co.uk.
116 comments:
scales S24 and above have been put in PB4 and your calculator does not take this into account
Very informative and useful. Quiet easy to use and certainly the best of calculators I have seen. I am not well versed to know how the Pay and allowances are calculated and hence not sure about the accuracy. You may pl cross verify with admn/accts section.
Dear Mr Sudhir,
Today you have uploaded a new calculator which is totally
different and probably contradicts the PB4 calculations and pay band
provided by you in the same calculator.
Please check and let us know which is correct one.
I am working in Department of Atomic Energy, my details are below (as on Jan-2006)
Scale 14300-400-18300 with basic at 15100
your cal shows
Pay Band at 41900-71600 (PB4)
grade pay 7600
but total pay is 35690 (less than starting of PB4)
What will be the Pay-Band and Grade-Pay in my case?
What will be my present pay?
What are the allowances which are sanctioned finally?
with thanks
Rajesh Gupta
Sir,
I think there is error in calculation of new pay for the month of appointment for new recruits as it shows the same amount irrespective of date of joining. It is also seen that -ve figures are apperaring in the difference of due-drawn.
Please rectify.
with regard,
Jayaseelan.
bahut hi achcha hai, behtar ho agar baaki scale bhi incorporate kar den to, kal tak intzaar rahega kisi amendment ka notification ke baad agar koi ho raha hai to
GROUP B OFFICERS IN INCOME TAX AND CENTRAL EXCISE ARE IN PB 3 OR PB 2. AS PER PRESS RELEASE, THOSE GR.B OFFICERS WITH 4 YEARS SERVICE ARE PUT INTO PB 3 FOR CERTAIN SERVICES. WHY NOT FOR US. ANY IDEA ?
Hai Sudhir
You've worked out a wonderful calulator. HOWEVER, ur calculator does not take into account the "Erratta" of the CPC Report, wherein, officers drawing pay of 4000/- & above are also eligible for TA @ Rs.600 & 800/- for A1 & other cities respectively. Pl. rectify your calculator accordingly. Otherwise, ur work is almost perfect. But see there may be certain changes in the official notification to bereleased tomorrow and the same may be incorporated.
Regards
V SRIRAM
SIR, PLEASE MAKE PROVISION FOR SOME SPECIAL CASES IN WHICH SALARY IS UPGRADED LIKE NURSES, TEACHERS ETC. THANKS IN ADVANCE
what will be the calculation for doctors including NPA.
Dear Sh. Sudhir
I just downloaded your calculator and on a cursory look itself, found it very erroneous.Your calc has kept the grade pay changing with each increment and in case of a promotion after 1.1.06, it just becomes equal to that stipulated for the new grade ,while the Pay band portion also sings an amusing tone!It becomes even less than that before the promotion!
Very good programme, I hope it will be helpful after the notification come and mdification implemented if any.
I found some problem as follows:
My scale was 14300-400-18300 and my basic was 15900 as on 01/01/2006. My increment date is 1st. Feb. I got promotion on 1st Aug. 2007, the new pay scale is 16400-450-20000. In the arrears calculation my new pay after the promotion is less than the salary before promotion. Please check.
Excellent. Kindly update it after notification and it will be useful to all the govt.offices. Great work. do you have pay package for govt offices?
Sir,
Please round up the new pay to the next higher multiple of 10, then it will be the correct calculation as per pay commission guide line
ex. 17685/- wiil be 17690/-
The notification is available at http://india.gov.in/govt/studies/decision.PDF. From that PB -4 is 37400-67000. Hence correct your programme for PB-4
Notification is available at pib.nic.in
Dear Sir
I entered following data in your beta version calculator.
present pay scale - 14300-400-18300
pay on 1/1/2006 - 17100
increment date - January
calculated new pay is shown 40880 +8700 =49580 where as it should be 37400+8700=46100
Please check this anamoly in the calculator.
thanks.
anil47kumar@hotmail.com
Congaradulation for doing a wonderful job at short time. As per me there is one problem. Eventhough your software asks for increment date in the old scale in arrearscalculation pay is changing in old pay also in July only .Please correct. As for as fixing basic I think yours is correct. Error may be in tens. Once again congardulation. Fix this increment problem in old scale.
sir, pls remove background color from sheets.
Dear Sudhir
I posted my data and found that calculator is correct. congratulations for your great efforts.
Sunil Choudhary
AFAO
CAZRI Jodhpur
You did a great job. Its appreciable.
But results are varies from Staff corner calculator. The difference is coming right from January'06. We hope yours is more accurate than Staff Corner. Please verify. We are closely watching your calculator & corrections.
Pl compile the 'calculator' and keep refining to incorporate all changes. Eager to know what is my new pay and arrears.
Very good work
My basic pay on 1/01/06 was 12750 in 12000-375-16500. with increment date june
i got promotion on 1/1/08 to 14300-400-18300 with fixation date as 1/1/2008.
Every thing comes OK But the july 2008 salary came as 39650 instead of 38790 ie (3 % of bp+grade pay) +BP
Is it a bug or whether any of my entry got wrong?
Thanks in advance
Sir,
I am balaji t p, Inspector working in Ranipet Divison of Chennai III Commissionerate. You have done a very good job, it reduces the work of accounting staff. For the people promoted after 02.01.2006, if we give details of promotion date it gives less pay then the previous month, plz. check this. Otherwise the calculator is working very good. After correction, if possible please send a copy to cex5804rnpt@rediffmail.com or bava65@rediffmail.com
Thanking you sir
sir, please remove background colors- great effort indeed - a complete solution
I was in the scale of 10000-325. My increment month in 2006 was June. As per our Joint Director, it is not yet clear in any of the notification that how to fix the pay and when to give increment. He says no clear instructions for people whose increment month is from Feb to June. What are your comments ?
For all those who were in the payband PB4 as on 1.1.2006, their minimum salary comes out to be Rs. 70,000 and minimum basic is minimum payband + GP. Also, whose basic was more than the start of the scale they will be getting 3 % increments while fixing ( This is for only PB4 bands).Maximum benefits to only PB4.
sudhir ji, thanks for your calculator. i found some errors . i mailed sheet to you so please check them and let me inform me please.
Respected sir, its a nice work u r doing
keep it up..
I am Draughtsman Gde I
my pay was 6500 on 1.1.06 in 5000 pay scale
my month of increament was may
then i got acp Dman gde I in may 07 ( 12 years)
my pay was fixed at 7075 in the 5500 pay scale
on 31/12/07 i got promotion to d'man Gde
on may 08 increament - 7250 basic pay
can u please provide the fixation of pay with some clarification
i will be very thankful to You
Sir,
You have done a wonderful job. Congrats for that. But I have my doubts.
My Basic pay on 1.1.2006 was 4050 in the pay scale 3200-85-4900.
The pay scale has been upgraded 4000-100-6000
I got ACP on jun 2007
present basic 4400
resolution page 50 (part-I sec-I (3)says that the ta admissible for employees in pb-1 with 7440 corresponding to 4000 basic in pre- revised scale and above will be eligible for grant of ta at the rate of 1600/800 for a1/a cities where as your calculator shows it as 600
Then the grade pay after entering above data is still shown as 2400 throughout. Please verify
Hi Sudhir
It will be cliche if I repeat the words, I can sum it in one word, excellent. I found one small problem for entry scale of each pre-revised scale if you refer to gazette on page 43 of section II of Part A of The First Schedule, you can find entry band pay for each grade pay. Though it is deviating by small amount, it still is deviation.
Regards
Your work is excellent... but I have a doubt. In my view, in case of new recruits (appointed after 1 Jan 2006) like Teachers (PRT, TGT and PGTs whose scale have been upgraded), your calculator does not calculate the pay acoording to upgraded scale. As per Section II of notification (page 43) , the Pay of newly appointed PRT, TGT and PGT should be 13500, 17140 and 18150 respectively. Please examine and comment whether I am right or wrong.
As per the Notification in Hindi, the increment month has been done in two minths i.e for the increment of the officials falls in betwenn August - Dec then their increment month will be July and if the increment falls in between Jan - Jun then the increment month will be January.
This is a good news for who are effecting deu to the uniform mode of increment in July.
This point has been clearly indicated under para 7 in hindi version
What will be the increment month from Jan'06? is it July only? No, as per the gezette, Part - I - Section - 1. dt.29-8-08 in hindi there are two months has been clearly specified. i.e. for the officials whose increment falls betwee 1st Jan - 1st July the increment month will be January & for the remaining will get increment on 1st July.
Pl. verify the following.
(VII) वार्षिक वॆतन्व्रुधिया
सर्कार का निर्णय
संशॊधित ! वार्षिक वॆतन्व्रुधि की दॊ एक समान तारीखॊ हॊगी, अर्धित प्रत्यॆक वर्ष की 01 जन्वरी तध 01 जुलाई ! सभी कर्मचारियॊं कॊ अपनी वॆतन्व्रुद्दि प्रत्यॆक वर्ष की 01 जन्वरी अथवा 01 जुलाई कॊ मिलेगी!
How do you feel?
Congrats Sudhir.
Doing excellent service. keep it up.
But, I am not able to work out my salary. For. ex. On Jan 2006 my basic was 9375 in 8000 scale. Promoted on 17/01/2007 to 10000 scale. But I am not able to work with your work sheet. When I fill the column of opting date, it is filling it with ########### and there on I am not able to follow the content in the following sheets also. It is giving lakhs of rupees as arrears, which I feel is wrong. Kindly guide me, or send an example worksheet to my mail id 'crswami@yahoo.com'
Thanks a lot.
dear sudhir
you have done a wonderful job.congratulations.I have one suggestion.Its not possible to calculate arrears for persons who have retired after 1/1/06 but before august 2008.you can simply allow entry of basic pay of Rs.0.0 after the month of retirement and your calculator will show arrears correctly.
Great Job Mr. Sudhir. Though some bugs still there but surely you will correct them earlier than anybody else. Its been of great help really. Keep up the good work.
Certainly the most exhaustive calculator ever published on the net. Hearty congratulations and sincere thanks for the effort.
congradulations once again for doing an excelent work. One small sugesstion for improvement. PF in new scale will be different from old . So this difference will be deducted from arrears. Since pf is 10% min. You can provide for PF calculation in old basic and new fixed salary to arrive at difference. You may also provide for entry of PF amount for those who had contributed more than minimum. Still there is prob;lem for those who got promotion in between 1.1.06 and 1.8.08. Please check. In left side you enter date of promotion in old scale and new sacle calculation is not corect. If you add these date in right hand side then ############ comes and nothing comes. Or you may hav e to give clear instruction for promotion cases if programme is correct.
my salary is being still wrongly calculated as per ur 4.1.0 latest calculator, pls see it.
My old pay scale on 1/1/2006 was 10000-325-15200 and basic was 10650, increament due date 1st Jan.
I got promotion on 01/01/2008 in the scale of 12000-375-16500 my basic was fixed 12000.
Ur Calcultor fail to calculate my salary and arrear. pls see it and rectify it.
Presently I am in the 5000-8000 grade having 5750 as basic pay as on 1.1.2006. Because of merger of three grades our new pre-revised grade is 6500-10500. I have completed my 20 years of service in March, 2007. I have got one ACP in the year 1999. Can you please communicate my pay calculations......thanks
I am at present in the grade of 5000-8000. Due to merger my new pre-revised pay comes to 6500-10500. My basic pay as on 1.1.06 is 5750. I have completed my 20 years of service last year (2007). So far I have got one ACP in 1999. Can you please communicate my revised pay calculations......thanks
R/Sir
I have a query regarding Grade Pay for Directo Recruits appointed after 01.01.06.
Kindly refer Page No.43 of the 6th Pay Notification.
It shows the lower Grade Pay for appointments after 01.01.06.
For eg. for 4000-6000 the Grade Pay is Rs.2400/- for recruits appointed before 01.01.06.
Whereas recruits appointed after 01.01.06 will get grade pay of Rs.1800/-.
Kindly suggest us the right option.
Thanks and regards,
Shaunak
sir, a very good attempt, i must say. considering the following details of mine:
as JAO on 01.01.06 basic 6700/- in 6500-200-10500 (now upgraded to 7500-250-12000 with grade pay 4800) with dni being 01.04.2006. promoted as AAO on 01.04.2008 in 7450-225-11500 with pay fixed as 7675 and dni 01.04.2009 (now upgraded to 7500-250-12000 with grade pay 4800).
your calculator goes blank as soon as opted date for promotion is filled in & entered as 01/04/2008. moreover grade pay is shown as 4600 instead of 4800 as 7450-225-11500 is also upgraded to 7500-250-12000.
kindly correct and mail me the latest and correct version of your useful calculator. hats off to you.
Dear Sudhir,
your calculator is excellent and the most comprehensive of all that are available. But surprisingly the latest one has some bugs. For example I was drawing a salary of rs.12275 as on 1.1.06 in the scale 10000 and promoted to 12000 scale on 1.10.2007. My grade is shown as 6600 whereas it should have been 7600. this wrong information is shown on the pay fixation sheet also. kindly rectify.
Arrears are not matching in case of promotion after 01/01/2006.
Data Entered is scale-5000-150, basic as on 01/01/2006 is 5450, increment in May, Promotion to scale 5500-175, promoted date-01/05/2007. Arrears indicate fixation of promotion from 01/02/2006 which is not correct
Mr. Sudhir,
I want to know "deputation allowance details" are notified or not?
If notified, can u furnish me the details
Dear Sudhir,
The new version of 4.1.1 has some bugs in the Arrears calculation w.r.t persons got promotions after 2006.kindly correct it. once again congratulations to you for the excellent work.
from your 4.1.1 version it is seen that in the calcualtion sheet, in respect of the pay scale 7500-250-12000, the grade pay has been shown to be 4600 in S-14. it should have been 4800.it contradicts your earlier calculation. please clarify
R. Choudhury
Sir,
I am balaji, inspector working in central excise, ranipet division, chennai iii commissionerate. I am unable to download your latest arrears version 4.1.1. Why i can't download the same please clarify, if possible e-mail the same to cex5804tnpt@rediffmail.com or bava65@rediffmail.com.
Thanking you sir,
balaji t p
for TA ,if one is selecting Class C or unclassified ,TA comes as zero
Thanks
Dear Sir,
No doubt, U have done an excellent work. Congratualations.
Here are some mistakes I noticed.
1. For grade 4800. TA in arrear calculation is shown 1600 instead of 800.
2. For those who got promotion after 01/01/2006 and the cader got upgraded, the effect in arrear starts right from 01/01/2006 instead of from date of promotion.
For example, My case is as under
1. Pay as on 01/01/2006 - Rs 4750 in the scale 4500-7000
2. Promoted as SO(A) w.e.f. 19/03/2007 in scale of 6500-10500 which has been upgraded to 7500-12000.
In my arrear my upgraded pay in pay band has been shown w.e.f. 01/01/2006 itself whereas I got promoted from 19/03/2007.
Please clerify and oblige thereby
thanks
Dear Sir,
I am kumar, Executive Engineer from Railways.
Please refer to my earlier mail on this subject wherein I had poited out a small error in your Excel sheet wherein increment was being accorded to employees who were having increment month from Jan to Jun as against the accepted VI PC recommendations to grant increment only to employees who were to draw increments on 1-07-2006 to 01-01-2007. Thus a minor check and correction is necessary.
Further, I was in 8000-275-13500 at Pay 9375 with increment month of Jun. I was promoted in Dec 2007 to scale 10000-325-15200 with revised increment month of Dec.
The calculator 4.1.1 is fixing my pay at Rs. 26650 (giving the benifit of Bunching) + grade pay as on 01-01-2006 which I believe is not appropriate. Kindly enlighten me if I am wrong and if your calculator is correct thereby requesting you to explain the concept of bunching icrements. If your calculator is wrong, kindly make necessary corrections please.
Kindly accept this as a constructive and not otherwise.
Thanks
kumar
sir, we are unable to download this, there is some problem with your server. pls get is solved
Dear Sudhir,
Thanks a lot for this wonderful calculator. However I want one clarification from you. What is the method adopted in your latest software version 4.2.0 for pay fixation on account of promotion after 1st jan 2006.
I think you have taken it as (Present Band pay)*1.03 rounded off to next higher multiple of 100(hundred) + enhanced grade pay. In my view it should be (Present Band pay + present grade pay)*1.03 rounded off to next higher multiple of 10(ten) + difference in new and old grade pay. I think this was the case in your earlier calculator. Why the change. Have you got some inputs regarding this?
Hi Sudhir
There is one mistake I could found out with existing pay scale of 8000-275-13500 (Group A Entry). Now in PB-3. For basic pay of Rs 8000 in pre-revised scale,pay fixation errorneously comes to Rs 26650, it should be Rs 15600. Same applies to all succeeding stages in the scale. Though if this scale is acquired after 1.1.2006, either by new entry or by promotion provides correct fixation.
Thanks.
Hello Mr. Sudhir,
I am Ajay.
Thanks a lot for good and accurate calculator, and salute to your efforts for making it error free and considering the suggestons.
One big thing which remain in this is TA for Class C cities is not calculted correctly, it is showing Zero which should be 1600 or 800.Please calculate it correctly.
Dear Sudhir,
There is some bug still exist in the calculator. for example my basic pay was Rs.12275 in the scale 10000-325-16500 as on 1--1-2006 and my increment month is Oct. I got a promotion on 1-7-2007, to 12000-375-18400 and my basic was fixed at 13125. In your calculator, the arrears was shown was more than 10 lakhs whereas it should be Rs.2.5 lakhs. How is this possible? Please help. Otherwise it is an excellent software and most comprehensive.
sir, abhi bhi aapka calculator download nahi ho raha hai.
Hi Sudhir,
Thanks a lot for incorporating the suggested changes. Your calculator is best and most comprehensive. However, I still have some doubts.
For the employees getting promotion between January to July, pay fixation on account of promotion is done as per recommendations(i.e one increment + change in grade pay), but no increment in the month of July (normal yearly increment) is granted in your calculator in this case.
I think , the employee should get normal increments as well, since pay commission recommends one EXTRA increment on account of promotion.
I am very happy to use your program for 6th PC arrears.My scale is
18400-500-22400 and I was at Rs 22400/ on 01-01-2006 ( one year stagnation)
There is a problem in calculaion of old scale I got pomoted on 01-08-2006 to the grade 22400-525-24500. I was fixed at 23975/-
due to stagnation increment and promotion increment. The stagnation
incremenet, i think that the program is not considering and hence my arrears is more than what shiould be. My email id is anantharaman1c@hotmail.com
Sir,
The Technical Employees (2Year ITI)working in the government autonomous institutes like National Institute of Hydrology were no scope for promotion was placed in the 5th Pay commission in 33200-85-4900 as Technician gr.III.Is any common cadre for the Technicians with 2 year ITI, in the Ministry of Water Resources and other Departments
i am unable to download the latest version, pls see
Someone please mail me latest version of sudhirji's program
dayanidhibatsa@rediffmail.com
dnbatsa@gmail.com
I have set language area and date as per your instruction still I get ###### in date field. As told by Rathika I think there is some problem in old pay fixation when there is promotion with stagnation increment or notional increment due to some anomaly. So if you are unable to take care by a common programme you can ask the user to input the fixed pay after promotion when it is between Jaan1 ,2006 and Aug,1, 2008
using version 4.3.0. A very elaborate effort. Effort should be commended. A small bug. The CCA rates (Old pay) for 4000 range is 150. But the calculator is showing it as 300.
zSomeone please mail me latest version of sudhirji's program
dayanidhibatsa@rediffmail.com
dnbatsa@gmail.com
It is wonderful. However, it is giving transport allowance even if I am having official transport.
Dear Sudhir,
You seem to be continuousely working on the pay calculator to eliminate inacuracies. But the date on top of your blog always displays 19th August 2008. It may give an impression to a new visitor that blogs are not latest. Pl try to set it right.
Dear Mr Sudhir,
My details as on 1.1.2006:
BP :6700 in the Scale of 6500-200-10500
Month of Increment: Apr
City Classification: B-2
Resident of Govt Qtr: Yes
Further my post has been upgraded to 7450-225-11500
My problem with calultor is:
In version 4.3.0 my basic is correctly fixed at 13860+4600 but in increment sheet it is 12470+4200as per previous scale and in version 5.0.0 even my basic pay is not correctly fixed.
Sir,
I have downloaded your arrear calculator Revised-PayIT-6PC-v4.3.0. It is the most excellent easy and user friendly preparation. I have two confusions.
1. The month which is displaying in cell L8 of the sheet named Statement of Arrears.
2. Regarding grade pay admissioble for existing pay scale 6500-200-10500. Whether it should be Rs.4600 or Rs.4200 in the light of the provision(ii) of Section I of PART-B of the Notification dated 29-08-08 pasted below.
PART - B
REVISED PAY SCALES FOR CERTAIN COMMON CATEGORIES OF STAFF
Section I
(i) The revised pay structure mentioned in Column (5) and (6) of this part of the Notification for the posts mentioned in Column (2) have been approved by the Government. The initial fixation as on 1.1.2006 will be done in accordance with Note 2 below Rule 7 of this Notification.
(ii) On account of merger of pre-revised pay scales of Rs.5000-8000, Rs.5500-9000 and Rs.6500-10500, some posts which presently constitute feeder and promotion grades will come to lie in an identical grade. The specific recommendations about some categories of these posts made by the Pay Commission are included Section II of Part B. As regards other posts, the posts in these three scales should be merged. In case it is not feasible to merge the posts in these pay scales on functional considerations, the posts in the scale of Rs.5000-8000 and Rs.5500-9000 should be merged, with the post in the scale of Rs.6500-10500 being upgraded to the next higher grade in pay band PB-2 i.e. to the grade pay of Rs.4600 corresponding to the pre-revised pay scale of Rs.7450-11500. In case a post already exists in the scale of Rs.7450-11500, the post being upgraded from the scale of Rs.6500-10500 should be merged with the post in the scale of Rs.7450-11500.
If possible, please clarify my confusions.
With Regards.
-Ghanshyam Patel
R/Sir
I have a query regarding Grade Pay for Directo Recruits appointed after 01.01.06.
Kindly refer Page No.43 of the 6th Pay Notification.
It shows the lower Grade Pay for appointments after 01.01.06.
For eg. for 4000-6000 the Grade Pay is Rs.2400/- for recruits appointed before 01.01.06.
Whereas recruits appointed after 01.01.06 will get grade pay of Rs.1800/-.
Kindly suggest us the right option.
Thanks and regards,
Shaunak
R/Sir
I have a query regarding Grade Pay for Direct Recruits appointed after 01.01.06.
Kindly refer Page No.43 of the 6th Pay Notification.
It shows the lower Grade Pay for appointments after 01.01.06.
For eg. for 4000-6000 the Grade Pay is Rs.2400/- for recruits appointed before 01.01.06.
Whereas recruits appointed after 01.01.06 will get grade pay of Rs.1800/-.
Kindly suggest us the right option.
Thanks and regards,
Shaunak
Dear Sudheer,
There is a small modification. the transport allowance for the pay scale 4000(pre-revised+ and above are incresed upto Rs.800/-+DA. For B1 cities(Page No 50 of the resolution). Kindly correct in the calculator. It shows Rs.400 at present.
Dear Sudhir.
As pointed out earlier, in your calculator, for the employees getting promotion between January to July, pay fixation on account of promotion is done as per recommendations(i.e one increment + change in grade pay), but no increment in the month of July (normal yearly increment) is granted in your calculator in this case.
I think , the employee should get normal increments as well, since pay commission recommends one EXTRA increment on account of promotion.
This has not been fixed in version 5 as well. Correct me if I am wrong, but please reply.
Hai Sudhir
There is a problem in the income tax calculation in the latest version. The chapter VI/80c deductions are not deducted properly from the gross income.The previous version was ok.
Another problem I found was when an entry for promotion is given, for example the official got promotion in 4/2008 from 4500 (PB1) scale to 5500 (PB 2) scale, the grade pay is not changed in the new pay band. This problem exists in the latest version also.
Big bytes' version of increment,and i suggest to opt for the date of next increment as date of pay fixation on promotoin which may be beneficial for people who get the promotion in feb to june or august to december
Hello Sudhir,
It is exceptional work and your efforts to constantly improve shows your zeal for perfection. I was just checking calculations for medical officers drawing NPA and found the DP drawn column showing wrong values. For doctors, the DP is drawn on basis of NPA as well, so it should be approx. 62.5% and not 50% as you have calculated. Thanks!
Great You are updatting on a continuous basis as per feedback. I feel you can do one more improvement. You have given provision for inputting special pay, stagnation increment etc. While calculating due and drawn statement you are including this input. But for calculating arrears breakup and statement of arrears you are not including them. In income tax calculation atrrears amount comes from this and hence that is also wrong . You please incorporate change by including these while calculating arrears. One more thing you may condsider is enhansed PF will be deduted from arrears before arriving at Arrears due. Hence you may subtaact difference in enhanced PF ( Diffrence between 10% of New pay in pay band +grade pay ) and old PF. You may also provide option for people to enter the amount of PF for those who contribyted more than minimum in old pay to arrive at difference
My appointment date = 18.3.1987
Scale in the prevised = 4000-6000
Got 1st ACP in July-August, 1999
Scale of pay = 5000-8000
Completed 21 years in March, 2008
As per 6th CPC pay merged with
6500-10500.
Can you please pass on my pay calculation.
download links not working at the moment
The OM giving illustration of pay fixation in case of merged pay scales, 5000-8000,5500-9000 & 6500-10500 does not give any benefit of bunching on account of merging. Can you please comment.
Dear Sudhir
You have done really best job. Why can't you add modules for those who availed some 'leave without pay' and/or 'half pay leave'
jyn
Dear Mr. Sudhir,
Could you please let me know that ‘bunching’ and how it got included in the calculation while fixing ones basic pay. Is it applicable to all employees?
Secondly, I joined my service on 01 November 2004 (8000-275-13500 New Entry) in Kolkata, but staying outside (not in office quarter). Then on 27 September 2007 I was promoted or joined as (through direct recruitment in the same Dept.) Scientist-C with basic of Rs. 10000/- but posted in Itanagar, Arunachal Pradesh ( Unclassified City ) and staying in office quarter.
Now my question is how to calculate arrear using your Excel Sheet.
Could you please let me know?Regards, Mahes.
Dear Sudhir,
Do you have some orders in which if your ACP/Promotion is after1.1.2006 and in the months from 2nd January to 30th June then your will get next increment on immedite 1st July. Our office is giving next increment after a period of more then 12 months. In my case I got ACP from 13.01.2008 but they are giving next increment only in July,2009
Those who are not able to download the file ..please use this link...
http://61.95.206.227//OfficersArea/Downloads/Revised-PayIT-6PC-v5.0.3.xls
Dear Sudhir,
In version 5.0.3, you have added EXTRA increment for promotion in July (Version 5.0.3)... but not if the promotion is befor jully i.e between January to June. May I know why?
Dear Subhash Gupta
The PC report clearly states that on promotion the employee will get one extra increment. Your office is giving next increment after a period of more then 12 months. You got ACP from 13.01.2008 but they are giving next increment only in July,2009. I think this is wrong . how can they deny you your normal increment??
Sir
My basic pay on 1/1/06 is 9925/- in scale S15 and promoted to scale S19 on 1/8/2007 and fixed in 10975/-. But you calculator takes as 10650/-. Please correct
Dear Sudhir,
First of all i want to thank for you for providing a excellent version of calculator for calculating the arrears and pay.The pain you took and work you did it come out with a top class calculator. In this I found some discrepancies. kindly make necessary changes in the existing calculator.
1. In the Income tax calculation sheet the savings Under sec 80c is added instead of detection
hence it results in higher tax to be paid.
2. In the promotion/Acp : If a person promoted on 25th of a month The calculator takes the earnings from 25th to end of the month. It is not including the pre-promotion period of 1st of the month to 24th of the month. Please look in to it.
Thanks ,
Badhrinarayanan.K
CPRI-Bangalore
Sudhir, Great job. Here are some suggestions. For Group "B" officers in CBEC/CBDT after 4 years get upgraded to 8000 scale with the corresponding new grade pay of 5400/-. In your calculator, when the upgraded scale is seleted, it calculates the grade pay as 5400 from 1.1.2006, which may not be correct as the scale of 7500 was applicable to these officers from 21.4.2004 only. could you do something about that. Further, what is the new PP (Family planning) allowance.
Keep up the good work.
Please also take into account the deductions due on account of GPF while generating the Arrears Statement.
Hi Sudhir,
Once again problems with NPA particulars. Under new pay fixed, the 24% DA on old NPA should be merged with Basic, which then becomes new basic with additional grade pay as per pay bands. Secondly, under drawn pay, DA should be based on Basic+DP(62.5%)+NPA(25%).
Thanks!
Sudirji
You have not explained to me till date about the 'bunching' and how it got into the pay fixation sheet. I request you to let me know more about this and whether is it applicable to all. Mahes.
Excellent work, this has helped many in arriving at their present pay and arrears. You have made all of us proud.
sudhir can you clarif in the comment as to whether a person who is getting a promotion between February to Jun 2006 after getting his pay fixed in January 2006 will be eligible for normal increment in July 2006 or July 2007.
In the data entry sheet while selecting S-2A pay scale, the dropdown menu for basic pay selection as on 01 January 2006 ends at Rs 2910/- only. This may require correction.
...Yours sincerely, Subhasish Dutta.
Sir
Hindi version of 6th Pay Commission says that Government has amended the date of increment will be 1st January or 1st July but Engish version says only 1st July.Please clarify.
thabks.
SNchakravarti
sir,
my bp 7900(1/1/06)(6500-200-10500)
new scale upgraded
(7500-250-12000) 9300-34800 (4800)
my date of increment jan
if i opt fix at
7700 and then my jan increment is it benificial for me .pl do calculation
<<<<<<<< sudhir ji, in your calculator when i enter Pay Rs.8275/- in 8000-275-13500, it shows band pay rs.29650/- with grade pay 5400/- total pay rs.35050/- w.e.f. 9-2008, which seems incorrect, the benefit of bunching is not correct. please look into this matter.>>>>>
How come you omitted my name from the list of followers? I was one of the pioneers who discovered your innate genius to do some public good with your handy pay calculator.
Dear Sudhir
The clarification on CCS rules 2008 is now available on pay
commission's website. It answers most of the queries regarding pay
fixation on account of promotion etc. I think you can modify your
calculator accordingly.
CCS Clarification is available as told by bigbite at http://164.100.50.223/six_pay_comm/clarifications.pdf
PROBLEM EXISTS
<<<<<<<< sudhir ji, in your calculator when i enter Pay Rs.8275/- in 8000-275-13500, it shows band pay rs.29650/- with grade pay 5400/- total pay rs.35050/- w.e.f. 9-2008, which seems incorrect, the benefit of bunching is not correct. please look into this matter.>>>>>
DEAR SUDHIR AS PERNEW CALCULATION IT IS NOT AUTOMATICALLY GOING TO PAY SCALE WHEN THERE IS PROMOTION IN BETWEEN IT IS NOT TAKING INTO ACCOUNT AS PER REPORT AO GRADE PAY HAS BEEN CHANGE TO 5400 IN S14
Dear Sudhir
Hats off to your contineous efforts in keeping the viewers glued to your blog !!!
For your calculator is very perfect,I have mailed the same to my friends .....
But I seek your help for a friend .... details are .....
On 1/1/2006 (increment in Dec)
Pay Scale = 6500-200-10500
Basic Pay = 9500
Joined on Promotion on 30/3/2007
New Post Pay Scale= 7450-225-11500
Pay Fixed = 9925 in March 2007
promotion benefit in
Dec 2007
Basic Pay = 10150
Present Basic
(Aug-08) = 10150
Can you help me for
fixation /arr etc.?
(The person completed 18 yrs but did not get ACP???? )
Please E mail..me
Thanks
The taxation of salaries (including arrears) requires clarification from legal angle. As per section 15 of the IT ACT, the salary due to be received, allowed to the employee, whether received or not is taxable in the year in which it is due. Accordingly, the employee is required to offer the same on accrual basis whether he likes it or not. However, as far as TDS is concerned, the deductor is bound to deduct tax only at the time of making actual payment of arrears. This dichotomy in law, apparently looks like a mistake. However, it is not so. The deductor is expected to make TDS only at the time of actual payment of salary / arrears. The employee is required to calculate taxes on accrued salary and make good the tax short fall by way of either Advance tax or TDS itself. All employees of Central government should take care of this situation. Only hope is that the CBDT gives clarification / guidelines to the Assessing Officers, so that taxation of arrears can be done on actual receipt basis. At present this is not provided in law.
I went through the comments and would like to give my views. It is not appropriate to withhold implementation on the ground that it is not justified for 5% employees/oficers(I am not sure of this percentage). As we all know, there is a good jump in pay for which we were waiting since 2006. Even though the jump do not commensurate with the expectations of many, (for having waited for more than 12 years from the implementation of last pay commission) it does not augur well to refuse to implement. No doubts about the integrity and honesty of men in Armed forces. But please do not think too much of yourself. The civilian employees do take pride in their contribution to nation building (nation which you are protecting, also needs to be built strongly). The money needed for protecting also comes from building a sound economy. I feel, if we had a sound foreign policy and good neighborly relations for the past several decades, we would have saved lakhs of crores of rupees spent on defence expenditure and used the same for the betterment of poorest of poor in our country. These issues apart, I strongly feel that you cannot withold implementation of the CPC recommendations and wait. There are other legal avenues open for redressal. Each DDO is bound by the OM issued by the Dept of Expt and implement new pay scales from Sept.08.
Dear Sir Your calculator is not working OK. I am Staff Nurse In Central Govt. Hospital and my basic pay as on 01-01-2006 is 6200 in pay scale of 5000-150-8000 with increment month of October. Now 6CPC has upgraded pay scale of staff nurses from 5000-150-8000 to 7450-225-11500. Now as per pay fixation rule and your calculator also my revised pay is like 6200*1.86 = 11532 i.e. 11540 (rounded off to next multiple of 10) + 4600 (Grade pay). This comes out to be 16140. Now as per 6CPC notification file name revised.pdf at page no. 43, the entry basic pay for grade pay of 4600 is 17140. So in my opinion my basic pay as on 01-01-2006 should be 17140. Please comment/reply
Dear Sudhir
I firstly congratulate you for making very good package for calculation of sixth pay arriers.
I introduce myself.
I am Anil D Patil, belonging to Indian Statistical Service presently posted as Joint Director in National sample Survey Organisation, Baroda, Gujrat.
My basic was 10650 on 1/1/06 in the scale of 10000-325-15200 . I got promoted on 30/10/2007 but resumed duties on 3/12/2007 in scale of 12000-375-16500 with basic 12000. When I filled this data in your software- data entry sheet , I found pay fixation , increments & promotion sheets correctly. Other sheets income tax, arrears , brakeup not showing old pay correctly. Please suggest corrections in my data entry sheets so that I can advice same to my colleagues. One of my colleague got 2 promotions after 1/1/06 then how to fix his pay?
Once again congrats.
Anil D Patil
Joint Director
National sample Survey Organisation,
Baroda, Gujrat.
Dear Sudhir
I firstly congratulate you for making very good package for calculation of sixth pay arriers.
I introduce myself.
I am Anil D Patil, belonging to Indian Statistical Service presently posted as Joint Director in National sample Survey Organisation, Baroda, Gujrat.
My basic was 10650 on 1/1/06 in the scale of 10000-325-15200 . I got promoted on 30/10/2007 but resumed duties on 3/12/2007 in scale of 12000-375-16500 with basic 12000. When I filled this data in your software- data entry sheet , I found pay fixation , increments & promotion sheets correctly. Other sheets income tax, arrears , brakeup not showing old pay correctly. Please suggest corrections in my data entry sheets so that I can advice same to my colleagues. One of my colleague got 2 promotions after 1/1/06 then how to fix his pay?
Once again congrats.
Anil D Patil
Joint Director
National sample Survey Organisation,
Baroda, Gujrat.
We are following Sudhir's Blogs...
but.....
Is he going through them...???
(our comments)
Seems busy with updating his Calculator..!!!!
Really the calculator is very useful & widely used.
Thanks
Sir my wife is a staff nurse and her pay scale is 5000-150-8000. Her basic as on 01-01-2006 is 6200 (08 increments) and her increment month is October. Now 6th CPC has recommended the pay scale of 7450-225-11500 (Grade pay 4600) for staff nurses.
Now as per your illustration her Pay fixation will be like she is drawing drawing 6200 on 01-01-06 in the scale of 5000-150-8000.
Her fixation on 01-01-2006 will be:
Existing Pay Scale: 5000-150-8000
Pay Band Applicable: 9300-34800
Existing Basic Pay as on 01-01-2006: 6200
Pay after multiplication factor of 1.86: 11532
Pay in the Pay Band: 11540
Pay in the pay band after including benefit of bunching if any: 11540 (Not sure about this bunching process)
Grade Pay attached to the scale: 4600
Revised Pay = total of pay in the pay band and grade pay: 16140
Sir as per your calculator my wife's pay fixes at 16140 as on 01-01-2006 But as per http://civilaccounts.blogspot.com/ my wife's basic pay as on 01-01-2006 should be 17140 (as this is the min basic for the grade pay of 4600/- for the people who have entered the service on or after 01-01-2006). Does this mean that somebody junior to my wife will draw more salary than her.
Minimum of the pay in this grade: 17140
Revised Pay = total of pay in the pay band and grade pay: 17140
Further I would also like to know about what happen to someone who has entered the department as staff nurse on 01-01-2006 at basic pay of 5000 (on same pay scale of 5000-150-8000}. As per your 6 CPC notification her basic will be 17140 (as this is the starting pay of the scale), while my wife who has already served the Govt. for 8 years will be fixed at 16140. My question is someone who has served the department for eight years and who has earned eight increment will be placed at lower basic (or at the the same basic pay) than some one who has just entered the service. In my opinion the person who has served for eight years should get some more benefit. Sir Please help
Further Sir I would like to draw your attention towards the Railways notification in r.o. 6th CPC (http://www.indianrailways.gov.in/) RBE No. 109 Notification No. PC-VI/2008/I/RSRP/I dt. 12.09.2008 wherein detailed fixation tables for each stage in each of the pre revised scales of Running Staffs are given. If you compare any table (say 5000-150-8000 pre-revised) with that of Finance_Ministry_OM_-_Pay_Fixation_-_Arrears.pdf file table, you will find a huge difference for example in the table of 5000-150-8000 at 6200 basic Railways has recommended a revised pay of 17340 while Finance Ministry has recommended only 15740. Can anybody tell why this difference is there. Waiting anxiously for your reply.
sudhir ji, in your calculator when i enter Pay Rs.8275/- in 8000-275-13500, it shows band pay rs.29650/- with grade pay 5400/- total pay rs.35050/- w.e.f. 9-2008, which seems incorrect, the benefit of bunching is not correct. please look into this matter.>>>>>
mkgarg
Hello Ssudhir
Good work
Avinash Dagliya
Dear.........
I joined a new school as accountant on a basic salary of Rs. 8500/- in the garde of 6500-200-10500 on july 2006. Presently my basic is 8900 according to CPC what basic should be on 1.7.2009
Dear Sir,
In continuation of tele conversation I am placing my request.
I am KANNAN G working in Chennai Corporation. Tamil Nadu Government have issued orders implementing revised pay in accordance with 6th CPC with some changes in allowances, increments etc.
As conversed I request that an unlocked copy of your 6th CPC pay calculator may please be sent to the following email id
g_kannan03@yahoo.com.
with regards
G KANNAN
+919840478804
Post a Comment