ࡱ>  ZO\p Ba==i9J8X@"1CCalibri1CCalibri1CCalibri1CCalibri1 CArial1CArial1 CArial1&C Draft 12cpi1CArial1CArial1 CArial1 CArial1 CArial1CArial1CArial1*8C Comic Sans MS1CArial1 CArial1 CArial1CArial1CArial1xCArial1CArial1CArial1CArial1QCTahoma1QCTahoma1QCTahoma1 CTahoma1QCTahoma1 CTahoma1QCTahoma15CArial1 CArial1 CArial1QCTahoma1CArial1CArial1CCalibri1 CCalibri1CCalibri14CCalibri1 CCalibri1CCalibri1CCalibri1,8CCalibri18CCalibri18CCalibri1>CCalibri14CCalibri1<CCalibri1?CCalibri1h8CCambria1CCalibri1 CCalibri1 CArial1<CArial1CArial1 CArial1>CArial1CArial1 CArial1 CArial1CArial1CArial1CCalibri1CArial1CArial1CArial1<CArial1CArial1 CArial1 CCalibri1CArial1 CArial1& C Bahnschrift1CArial1CCalibri18CArial1 CArial3" "\ #,##0;" "\ \-#,##0=" "\ #,##0;[Red]" "\ \-#,##0?" "\ #,##0.00;" "\ \-#,##0.00I"" "\ #,##0.00;[Red]" "\ \-#,##0.00u*8_ " "\ * #,##0_ ;_ " "\ * \-#,##0_ ;_ " "\ * "-"_ ;_ @_ .))_ * #,##0_ ;_ * \-#,##0_ ;_ * "-"_ ;_ @_ ,@_ " "\ * #,##0.00_ ;_ " "\ * \-#,##0.00_ ;_ " "\ * "-"??_ ;_ @_ 6+1_ * #,##0.00_ ;_ * \-#,##0.00_ ;_ * "-"??_ ;_ @_ $[$-4009]dddd\,\ d\ mmmm\,\ yyyy% [$-F800]dddd\,\ mmmm\ dd\,\ yyyy ' ' ' ' ' ' ' ' ' ' ' ' ' '   '  '  '  '  '  '  '  '  '  '  '  '  (  (  (  (  (  (  (  (  (  (  (  (  )  *   + ff '+ ') ', '* , -  . P / P 0  0 1   2 ` 3  '    4  ' 5 6 a> 7  @ @   @ @ +  @ @     @ @ /   8@ @ / / @ @ * @ @ * 9"@ @ + 9" @ @ +  /  /  /  /    @ @  "   :    ;  ;  @ @  @ @ * @ @ * @ @ * @ @ * 9"@ @ + 9"@ @ + @ @ + !@ @ + @ @ +  @ @ + @ @  <@ @  @ @  @ @  @ @  @ @   @ @ /    @ @  @ + !@ + >1 8@ @  ?!@ @  @@ @  A@ @ + ? @  ?@ @  B / @ @  @ @  #@ @   @ @   !@ @  @ @ + "@ @ +  @ @ + #@ @  #@ @  C@ @  C@ @ + D@ @  D@ @  @ @ + @@ @  @@ @  H@ @  O @ @  O !@ @  @ @  !@ @  P1> K"@ 5 K"@ @ 5 K"  5 L"@ @ < H @  H   /  @ @ / D@ @  D@ @  @ @    @  H@ @  H@ @  M@ @ 3 M@ @ 3 @ @  @ @  @ @  @ @  @ @  @ @  @ @  G@ @ 3 G@ @ 3 G@ @ 3 @ @  @ @  @ @  @ @   @ @   @ @  G@ @ 3 G@ @ 3 @ @ / @ @ / @ @  @ @  @ @  @ @   @ @   @ @   @ @  @ @  @ @  @ @  @ @  @ @  @ @  @ @  F@ @ / F @ @ / E@ @  E@ @  @ @  @ @  @ @  @ @  @ @  @ @  @ @  @ @  I"@  I"@ @  I"   J@ @ 3 J@ @ 3  @ @     @  9@ @ / 9 @ @ / G@ @ / G @ @ / @ @  &@ @  &@ @  H!@ @  H!@ @  @@ @  @@ @  N!@ @  N!@ @  @ @  @ @  @ @  @ @  @ @  %@ @  %@ @  O!@ @  O!@ @  @ @  @ @  @ @  @ @ > @ @ >   @ > @ @  J@ @ / J @ @ / =@ @  9@ @  9 @ @  || }-}  yyyy_ *}-}  yyyy_ *}-}  yyyy_ *}-}  yyyy_ *}-}  yyyy_ *}-}  yyyy_ *}-}  yyyy_ *}-}  yyyy_ *}-}  yyyy_ *}-}   yyyy_ *}-}   yyyy_ *}-}   yyyy_ *}-}   yyyy_ *}-}   yyyy_ *}-}  yyyy_ *}-}  yyyy_ *}A}  yyyy_ *ef * \}A}  yyyy_ *ef * \}A}  yyyy_ *ef * \}A}  yyyy_ *ef * \}A}  yyyy_ *ef * \}A}  yyyy_ *ef * \}A}  yyyy_ *L * \}A}  yyyy_ *L * \}A}  yyyy_ *L * \}A}  yyyy_ *L * \}A}  yyyy_ *L * \}A}  yyyy_ *L * \}A}  yyyy_ *23 * \}A}  yyyy_ *23 * \}A}  yyyy_ *23 * \}A}  yyyy_ *23 * \}A}   yyyy_ *23 * \}A}!  yyyy_ *23 * \}A}"  yyyy_ * * \}A}#  yyyy_ * * \}A}$  yyyy_ * * \}A}%  yyyy_ * * \}A}&  yyyy_ * * \}A}'  yyyy_ * * \}A}(  yyyy_ * * \}}) } yyyy_ * * \.00_"\ * _ ;_ }}*  yyyy_ * * \???.00_???"\ * ???_ ;_ ???}-}+  yyyy_ *}-},  yyyy_ *}-}-  yyyy_ *}-}.  yyyy_ *}-}/  yyyy_ *}A}0 a yyyy_ * * \}A}1  yyyy_ * * \}A}2  yyyy_ *? * \}A}3  yyyy_ *23 * \}-}4  yyyy_ *}}5 ??v yyyy_ *̙ * \.00_"\ * _ ;_ }A}6 } yyyy_ * * \}A}7 e yyyy_ * * \}}8  yyyy_ * * \.00_"\ * _ ;_ }}9 ??? yyyy_ * * \???.00_???"\ * ???_ ;_ ???}-}:  yyyy_ *}-};  yyyy_ *}U}<  yyyy_ * * \.00_}-}=  yyyy_ *}-}A  yyyy_ *}-}B  yyyy_ *}<}D  yyyy_ *ef  *}<}H  yyyy_ * *}<}I  yyyy_ * *}-}J  yyyy_ *}-}L  yyyy_ *}-}P  yyyy_ *}(}T  yyyy_ *}-}U  yyyy_ *}(}V  yyyy_ *}(}W  yyyy_ *}<}]  yyyy_ * *}<}^  yyyy_ * *}(}d 23 yyyy_ *}<}n  yyyy_ *ef *}<}o  yyyy_ * *}<}p  yyyy_ * *}(}q P yyyy_ *}(}r P yyyy_ *}<}s  yyyy_ * *}<}t  yyyy_ * *}-}u  yyyy_ *}(}vef yyyy_ *}(}wef yyyy_ *}(}xef yyyy_ *}(}yef yyyy_ *}(}zef yyyy_ *}(}  yyyy_ *}(}  yyyy_ *}(}  yyyy_ *}(}  yyyy_ *}(} P yyyy_ *}(} P yyyy_ *}<}  yyyy_ * *}<}  yyyy_ *ef *}<}  yyyy_ *ef *}(}ef yyyy_ *}<}  yyyy_ * *}<}  yyyy_ *  *}<}  yyyy_ *  *}<}  yyyy_ *  *}<}  yyyy_ * *}<}  yyyy_ * *}<}  yyyy_ * *}(}  yyyy_ *}(}  yyyy_ *}<}  yyyy_ * *}<}  yyyy_ * *}<}  yyyy_ * *}<}  yyyy_ * *}<}  yyyy_ * *}<}  yyyy_ * *}<}  yyyy_ * *}<}  yyyy_ * *}<}  yyyy_ * *}(}ef yyyy_ *}(}ef yyyy_ *}<}  yyyy_ *ef  *}<}  yyyy_ *ef  *}(}  yyyy_ *}(}  yyyy_ *}(}ef yyyy_ *}(}ef yyyy_ *}(}ef yyyy_ *}(}ef yyyy_ *}(}ef yyyy_ *}(}ef yyyy_ *}(}ef yyyy_ *}A}  yyyy_ * * \}A}  yyyy_ * * \}A}  yyyy_ * * \}<}  yyyy_ * *}<}  yyyy_ * *}<}  yyyy_ *ef *}<}  yyyy_ *ef *}<}  yyyy_ *ef *}<}  yyyy_ *ef *}(}ef yyyy_ *}(}ef yyyy_ *}<}  yyyy_ * *}<}  yyyy_ * *}(} P yyyy_ *}(} P yyyy_ *}A}  yyyy_ * * \}A}  yyyy_ * * \}(}ef yyyy_ *}(}ef yyyy_ *}(}ef yyyy_ *}(}ef yyyy_ *}(}ef yyyy_ *}<}  yyyy_ *ef *}<}  yyyy_ *ef *}(}23 yyyy_ *}(}23 yyyy_ *}(}23 yyyy_ *}<}  yyyy_ *ef *}<}  yyyy_ *ef *}<} p yyyy_ *ef *}<}  yyyy_ *ef *}<}  yyyy_ *ef *C  !%C  !%C  !%C  !%C  !%C  !% 20% - Accent1M 20% - Accent1 ef % 20% - Accent2M" 20% - Accent2 ef % 20% - Accent3M& 20% - Accent3 ef % 20% - Accent4M* 20% - Accent4 ef % 20% - Accent5M. 20% - Accent5 ef % 20% - Accent6M2 20% - Accent6  ef % 40% - Accent1M 40% - Accent1 L % 40% - Accent2M# 40% - Accent2 L渷 % 40% - Accent3M' 40% - Accent3 L % 40% - Accent4M+ 40% - Accent4 L % 40% - Accent5M/ 40% - Accent5 L % 40% - Accent6M3 40% - Accent6  Lմ % 60% - Accent1M 60% - Accent1 23 % 60% - Accent2M$ 60% - Accent2 23ږ % 60% - Accent3M( 60% - Accent3 23כ % 60% - Accent4M, 60% - Accent4 23 % 60% - Accent5M0 60% - Accent5 23 %! 60% - Accent6M4 60% - Accent6  23 % "Accent1AAccent1 O % #Accent2A!Accent2 PM % $Accent3A%Accent3 Y % %Accent4A)Accent4 d % &Accent5A-Accent5 K % 'Accent6A1Accent6  F %(Bad9Bad  %) Calculation Calculation  }% * Check Cell Check Cell  %????????? ???+ Comma,( Comma [0]-&Currency.. Currency [0]/Explanatory TextG5Explanatory Text % 0Good;Good  a%1 Heading 1G Heading 1 I}%O2 Heading 2G Heading 2 I}%?3 Heading 3G Heading 3 I}%234 Heading 49 Heading 4 I}% 5InputuInput ̙ ??v% 6 Linked CellK Linked Cell }% 7NeutralANeutral  e%3Normal % 8Noteb Note   9OutputwOutput  ???%????????? ???:$Percent ;Title1Title I}% <TotalMTotal %OO= Warning Text? Warning Text %XTableStyleMedium2PivotStyleMedium9`j pension-20-21w pension-19-20[:#MROUND%ffl@nf  2B*S AA@A@   |JNotes:Verify the ceiling limits of various deductions with latest IT rulesGDo not double click yellow boxes, just click once and enter the figure.7White boxes are formulated to AUTOMATICALLY calculate< Do not DELETE any number,put a 0 if you want to start over.;If your template no longer works ,down load a new template.TOTALDearness Relief(%)Arrears Income TaxADMISSIBLE DEDUCTIONSSCH-VIAmount Eligible AmtSEC 80D Sec 80C - PPFSEC 80DD LIC SEC 80DDBNet Taxable IncomeSEC 80ESEC 80G SEC 80 GGEquity Linked Saving Scheme SEC 80 GGABank FDRs 5,00,001-10,00,000 SEC 80GGCPost Office Term DepositAbove Rs 10,00,000SEC 80 UUTI / ULIP / PLI Total TaxTOTAL DEDUCTIONSEdu.+Health cess-4%Deductions u/s 80TTB(SB+FD INT) Tax Payable TDS(Pension)Standard Deductions TDS(Other) DeductionsSelf assessment TaxTax dueBankFD INTSB INTTDS HDFC BankTotal(Basic pay on day of Retirement (VII CPC)State Bank of India Central Bank Bank Of IndiaPunjab National BankIndian Overseas Bank ICICI Bank Post OfficeSr. Citizen's DepositOther DepositsDeveloped By : Lalit KhandelwalGross Pension Net PensionPENSIONTAXABLE INCOME #Full Pension on Retirement-VII CPC Commuted PensionReduced Pension AAll you have to do is fill in required DATA in Yellow Boxes only./!;DBe sure to save this sheet as a blank template before you fill it . Total Pension Gross PensionInterest IncomeBANK INTEREST/ TDS DETAILSAny other SavingTotal Savings under sec 80CAdmissible Deductions-Sec80CAPR'20MAY'20JUN'20JUL'20AUG'20SEP'20OCT'20NOV'20DEC'20JAN'21FEB'21MAR'21#PENSION & INCOME TAX - F.Y. 2020-21 Edu. cess-4%Up to Rs 300000Rs 500001-Rs 750000Rs 750001-Rs 1000000Rs 1000000-Rs 1250000Rs 1250000-Rs 1500000Total Admissible Ded.Deductions under sch-VITOTAL ELIGIBLE Deductions Axis Bank Gross IncomeTDS(Pension+Other) Refund Due March 2020 Sr CitizenUP TO Rs 3,00,000 Rs3,00,001-5,00,000#PENSION & INCOME TAX - F.Y. 2019-20 March 2019APR'19MAY'19JUN'19JUL'19AUG'19SEP'19OCT'19NOV'19DEC'19JAN'20FEB'20MAR'20Tax Due As Per New Slabs for FY 2020-21Prepared By : Lalit Khandelwal&TAXABLE INCOME Rs Sec 80C - PPFZ` aFbblBcc.dde5f? gog!hhYifi ccB ZO 4l  dMbP?_*+%,&ffffff?'ffffff?(?)?MS odXXLetter"dXX333333?333333?&<3kU} A} mA}  A} mA} A} A} A} $ A}  A} A} A} A} I A}  A} mA} A}  A} I A} A4h,,,,,,,, , , , , ,,;,,,,,,,,,,,,,;; , W$  y   B  C neC      C  0 ~ ?#@  Sr Citizen Sr Citizen @!> D(    ?  > D2 A"> DD j = DK DL DM DN DO DP DQ  DR  DS  DT  DU  DV  ~ b5@c5@Dc5@ Lc5@c5@b5@b5@D b5@  c5@  c5@  c5@  c5@  Dc# DDLA c c c c c c  c  c  c  c  c #  %   N bbbbbbbbbbbb #  %  %  ;  d    -%% d   d   d   d   d   d   d   d   d   d   d  % DD    N bbbbbbbbbbbb #  %     <     LL                           #  %     z    X G  EfD  Y Z F G [ Y\  F  ]* ^  ^+ H, I- F!f D D  ~ |"g $PB   ~  {  1  __` x  b"f DD ~ |"g $PB   ~  {  2  a_`3 Income Tax for Sr Citizen Income Tax for Sr Citizen  ^7f !D   $  B ~ |"g $@B   ~  {  3  __` Y~ ~ Eo/DD DD B ~ |gD   ~  {  4  __`*Rs300001-Rs500000Rs300001-Rs500000~sDA XDOA DA B$ DOAA '"BB,)Income Tax for Sr Citizen-Existing Slabs ,)Income Tax for Sr Citizen-Existing Slabs  ~ |gD   ~  {  5  __` Z~tDA YDA D`&A B$ DA A a"B+UP TO Rs 3,00,000 UP TO Rs 3,00,000 ~ ~ ~ |gD   ~   6  __` [~tD`&A YD`&A D.A B$ D`&AA |"B,Rs3,00,001-5,00,000Rs3,00,001-5,00,000;%DA  'B ~ |kD H  ~   .  __` \~tD.A YD.A D3A B$ D.AA P"B zDA _DA D.A B$ DAAj@"B ~ |"k $:B  a  llm ]~tD3A YD3A D`6A B$ D3AA $"B U?D.A  D.AA B ~ |gD I  # h %   8  __` #~ % # %   #x  %#v % J  0 h % OAB  9  __` X'~DA !'DA "  ) h D DPB  7  __` #09DD B #" DD %  _   hD  9  __` $ D  c! D D '~ }j@>z (D  $PBB `  . wD D D D  / # y % B#y %#y % &D (~  EEJJJJJJJJJJB (~  )_tI9DDD DDD " B EEJEEEJJJuEEi )ktU9DDDD DDDD " B d_sI9DDD DDD " B KKLMMMMMMMM dksU9DDDD DDDD " B NN NNNNOD%l6b`FbN#ll p&&' ,( ,, ,/ ,0 ,1 ,2 ,3 ,'P(P, Q /RS 0RS 1TS 2UU 3VWW $ W A DA(  ~  < XPP?U@]4@ hاYDg4s  <Sum of Band Pay & Grade Pay <~~  < X? X]4@ 騯jOW{ <Commutated Pension <~~  < X?@]4@ \*Q*KT <DA revised from01.01.2020 <~~   < XPP?= ]4 @ qZ-uOK !BmY Z~~ % <Hj XPP? y]4%@ ףfS}E*# <Under sec 80TTB Max Rs 50000 <~~ ( </XPP?"s]4(@ [P1]KA: (<)Annual Interest paid.Max Limit Rs 200000<sp( - T- X? _]4-@ Qfj@pKM <Pension+FD Int+SB Int < . TX X?]4.@  ZPS  XPPQQ? ]4>@ J Mb9 <@25% <1~~ ? <S X?3]4?@  4D~LI <TDS deducted at other sources <  @ TS  X?|]4@@ $Q%)K}^ST: <Tax paid in Bank <e` A ZS  XPPQQ?  ]4A@ nJ Hg| !<"80C+80TTB+Sch VI +STD Deductions <$  !+pAuthorAuthorAuthor Author-AuthorAuthorAuthorAuthorAuthorAuthor:Author Author;Author!Author<Author"Author=Author#Author>Author$Author%Author(AuthorAAuthor?Author.Author@Author>@hojo  2f                                         ?     ?     ?     ?     {+{ {+{{+{{+{b(b(?ϿggDh<haRange1 ZO {<  dMbP?_*+%,&ffffff?'ffffff?(?)?MS odLetter"d333333?333333?&<3YU}  } $ } h,,,,,,,, , , , , ,,,,,,,,,,,,,,,,; ; i*AAA  :   B AAA C jC   AAA AAA  C AAA 0 ~ ? @f @ > D(   AAA ?  > D2A A!> DD jAAA = Dk Dl Dm Dn Do Dp Dq  Dr  Ds  Dt  Du  Dv AAA ~ b(@c(@Dc(@ Lc(@c(@b(@b(@ ~  b1@ c1@  c1@  c1@  c1@ AAA Dc# DDLA c c c c c c  c  c  c  c  c #  % AAA  N bbbbbbbbbbbb #  %  % AAA ;  d    -%% d   d   d   d   d   d   d   d   d   d   d  %  DD  AAA  N bbbbbbbbbbbb #   %    AAA <      LL                          #  %    AAA >    X G AAA EfD  Y Z F G [ Y\  F  ]* ^  ^+ H, I- AAA F!f D D  ~ {"h $PB {  ~  {  1  __` AAA b"f DD ~ {"h $PB   ~  {  2  a_` AAA ^7f!D   $  B ~ {"h $@B   ~  {  3  __` AAA E/DD DD B ~ {hD   ~  {  4  __` AAA3Income Tax for Sr Citizen Income Tax for Sr Citizen  ~ {hD   ~  {  5  __` AAA g~ e ~ {hD   ~   6  __` AAA h;f%DA  'B ~ {D H  ~   .  __` AAA fzDA _DA D.A B$ DAAj@"B ~ {" $:B  a  llm AAA Uf?D.A  D.AA B ~ {hD I  # h %   8  __` AAA #f %   #w %#w % J  0 h % OAB  9  __` AAA !'fDAAAAA "  ) hD DPB  7  __` AAA #"q DD %  _   hD  9  __` AAA c!q D D '~ {j@> (D  $PBB `  . wD D D D  / #  % B# %# % AAA (~ r&EEJJJJJJJJJJBAAA w_pI9DDD DDD " B&EEJEEEJJJJEEiAAA d_pI9DDD DDD " B&KKLMMMMMMMMAAAByX<hfRh  N=9P$  K M A, ) (  ~  <S XPP?P]4@ E7qJ2E <Sum of Band Pay & Grade Pay <~~  <`S X? * s]4@ vGHFXԎ <Commutated Pension <~~  <@S XPP? ]4@ B.BvCo> <DA arrears & other arears <~~  <S XPP?  ]4@ i>[@iq4Ҵ <tax deducted from pension <  TS  X? ]4@ LVseK9ja <Pension+FD Int+SB Int <~~   <S  XPP?Z]4 @ SzJC0 L(<MMedical Insurance and Health checkup Max amount Rs 50000 <($O/78DL~~   <0S  XPP?3]4 @ qWBmY Z~~  <S  XPP?  ]4@ j8zC,\jU <Under sec 80TTB Max Rs 50000 <~~  <`S XPP?l]4@ $SA-a@|D@; (<)Annual Interest paid.Max Limit Rs 200000<sp(  ZS  XPPQQ?  @]4@ yAڷMd8[z !<"80C+80TTB+Sch VI +STD Deductions <$  !+p ( ZS  XPPQQ? ]4(@ ߣnGMM#w <DA revisedfrom 01/01/2019 < ) TS  X? ]4)@ IONj"{ <Tax paid in Bank <e`Author Author (Author  Author  Author Author  Author  Author  Author  Author  Author Author Author Author Author Author Author Author Author )Author >@hojoV                                         ?   ?   {+{{+{b(b(PggDh>haRange1_1 Oh+'0@HT` x Microsoft Excel@| #@Q ՜.+,0 PXd lt|  pension-20-21pension-19-20  Worksheets  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~Root Entry FWorkbookSummaryInformation(DocumentSummaryInformation8 Multifarious Website for Indian Railway Engineers
Multifarious Website for Indian Railway Engineers

ARCHIVES PART VII

NEWS ABOUT 49TH ANNUAL CONFERENCE AND CGB MEETING HELD AT CHITTARANJAN

NEWS ABOUT 7TH CENTRAL PAY COMMISSION

CADRE RESTRUCTURING ORDERS

DOCUMENTS FOR READY REFERENCE:

IRTSA ANNUAL CONFERENCE 14TH & 15TH NOVEMBER, 2013 - TRICHY

RECENT ADMINISTRATIVE ORDERS

Archives

Part-I |  Part-II |  Part-III |  Part-IV |  Part-V |  Part-VI |  Part-VII |  Part-VIII |  Part-IX |  Part-X |  Part-XI

Back to Top

Last Updated ( Sunday, 9 September, 2018 10:09 )
 

Visitors Counter

IRTSA CEC 2017-18

IRTSA CEC 2017-18

IRTSA Theme Song

Broken Links

Report Broken Links

Copyright © Indian Railways Technical Supervisors Association. All Rights Reserved.
Joomla! is Free Software released under the GNU/GPL License.