6th Pay Arrear Calculator For Tn

  • Uploaded by: Balakumar
  • 0
  • 0
  • May 2020
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View 6th Pay Arrear Calculator For Tn as PDF for free.

More details

  • Words: 1,837
  • Pages: 18
Programe Developed by S.ANTONY ANBARASU ,PGT(Phy),Arasunilaipalayam Uploaded by C.Ramasamy PGT(phy), Thiruparaithurai 1)Enter U R Basic Pay+PP as on 1-1-2006= 2) Enter U r Increment Amount 2) Enter u R Grade Pay 3) Enter the 3 months arrear drawn

5500 175 4300 40000

Enter the data above and directly goto your increment date worksheet and find u r pay as on 1-5-09 & arrears

11925

d by S.ANTONY ANBARASU ,PGT(Phy),Arasunilaipalayam

ploaded by C.Ramasamy PGT(phy), Thiruparaithurai

o your increment date worksheet and find u r pay as on 1-5-09 & arrears

PAY

Due Rs.

Drawn Rs.

Diff. Rs

Arrears RS.

From 1-1-2006 to 30-6-2006 Pay as on 1-1-2006 ( +i/c @ 3%) Dearnes Pay Dearnes Allowance @ 24%

14970

5500

Total From 1-7-2006 to Pay as on 1-7-2006 31-12-2006

14970

2750 1980 10230

( Dearnes Pay Dearnes Allowance @ 29% Dearnes Allowance @ 2%

14970

Total From 1-1-2007 to Pay as on 1-1-2007 30-6-2007 ( ( +i/c @ 3%) Dearnes Pay Dearnes Allowance @ 35% Dearnes Allowance @ 6%

Total From Pay as 1-7-2007 on 1-7-2007to 31-12-2007 ( Dearnes Pay Dearnes Allowance @ 41% Dearnes Allowance @ 9%

Total From Pay as 1-1-2008 on 1-1-2008to 30-6-2008 ( ( +i/c @ 3%) Dearnes Pay Dearnes Allowance @ 47% Dearnes Allowance @ 12%

Total From Pay as 1-7-2008 on 1-7-2008to 31-12-2008 ( Dearnes Pay Dearnes Allowance @ 54% Dearnes Allowance @ 16%

Total From 1-1-2009 to Pay as on 1-1-2009 30-5-2009 ( ( +i/c @ 3%) Dearnes Pay Dearnes Allowance @ 64% Dearnes Allowance @ 22%

Total

4740

28440 (notional)

4626

27756 (NOTIONAL)

4852

29112

4805

28830

4898

29388

4918

29508

5149

25745

5500 2750 2393

299 15269

10643

15420

5675 2838 2980

925 16345 15420

11493 5675 2838 3490

1388 16808

12003

15890

5850 2925 4124

1907 17797 15890

12899 5850 2925 4739

2542 18432

13514

16370

6025 3013 5784

3601 19971

14822

Arrears From: From 1-1-2007 to 30-6-2007 From 1-7-2007 to 31-12-2007 From 1-1-2008 to 30-6-2008 From 1-7-2008 to 31-12-2008 From 1-1-2009 to 30-5-2009

29112 28830 29388 29508 25745 142583

Interim arrears Sanctioned (3 months basic Pay + Dearnes Pay + Dearnes allowance.) Balance Amount Due

40000 102583

Arrears Payment in 3 instalments First Instalment 2009-10 Second Instalement 2010-11 Third and Final instalement 2011-12

34195 34194 34194

34194 102582 1

PAY From 1-1-2006 to 31-3-2006

Due Rs.

Drawn Rs.

Pay as on 1-1-2006 Dearnes Pay Dearnes Allowance @ 24%

14530

Total From 1-4-2006 to 30-6-2006

14530

5500 2750 1980 10230

14970

5675

14970

2838 2043 10556

Pay as on 1-4-2007 ( ( +i/c @ 3%) Dearnes Pay Dearnes Allowance @ 24%

Total From 1-7-2006 to 31-12-2006 Pay as on 1-7-2007 ( Dearnes Pay Dearnes Allowance @ 29% Dearnes Allowance @ 2%

Total From 1-1-2007 to 31-3-2007 Pay as on 1-1-2007 Dearnes Pay Dearnes Allowance @ 35% Dearnes Allowance @ 6%

Total From 1-4-2007 to 30-6-2007 Pay as on 1-4-2007 ( ( +i/c @ 3%) Dearnes Pay Dearnes Allowance @ 35% Dearnes Allowance @ 6%

Total From 1-7-2007 to 31-12-2007 Pay as on 1-7-2007 ( Dearnes Pay Dearnes Allowance @ 41% Dearnes Allowance @ 9%

Total From 1-1-2008 to 31-3-2008 Pay as on 1-1-2008 Dearnes Pay Dearnes Allowance @ 47% Dearnes Allowance @ 12%

Total From 1-4-2008 to 30-6-2008 Pay as on 1-4-2008 ( ( +i/c @ 3%) Dearnes Pay Dearnes Allowance @ 47% Dearnes Allowance @ 12%

Total From 1-7-2008 to 31-12-2008

14970

299 15269 14970

Diff. Rs

Arrears RS.

4300

12900 (notional)

4414

13242 (NOTIONAL)

4287

25722 notional

4375

13125

4499

13497

4435

26610

4371

13113

4511

13533

5675 2838 2469 10982 5675 2838 2980

898 15868

11493

15420

5850 2925 3071

925 16345

15420

1388 16808 15420

11846

5850 2925 3598 12373 5850 2925 4124

1850 17270

12899

15890

6025 3013 4248

1907 17797

13286

Pay as on 1-7-2008 ( Dearnes Pay Dearnes Allowance @ 54% Dearnes Allowance @ 16%

TOTAL From 1-1-2009 to 30-3-2009 Pay as on 1-1-2009 Dearnes Pay Dearnes Allowance @ 64% Dearnes Allowance @ 22%

Total From 1-4-2009 to 30-5-2009 Pay as on 1-4-2009 ( ( +i/c @ 3%) Dearnes Pay Dearnes Allowance @ 64% Dearnes Allowance @ 22%

Total

15890

2542 18432

6025 3013 4881 13919

15890

4513

27078

4564

13692

4719

9438

6025 3013 5784

3496 19386

14822

16370

6200 3100 5952

3601 19971

15252

Arrears From:

130086

From 1-1-2007 to 30-6-2007 From 1-7-2007 to 31-12-2007 From 1-1-2008 to 30-6-2008 From 1-7-2008 to 31-12-2008 From 1-1-2009 to 30-5-2009

26622 26610 26646 27078 23130

Total Interim arrears Sanctioned (3 months basic Pay + Dearnes Pay + Dearnes allowance.) Balance Amount Due

Arrears Payment in 3 instalments First Instalment 2009-10 Second Instalement 2010-11 Third and Final instalement 2011-12

130086 40000 90086 30028 30029 30029

30029 90087 -1

F

Due Rs.

PAY

Drawn Difference Arrears Rs. Rs RS.

From 1-1-2006 to 30-6-2006 Pay as on 1-1-2006 Dearnes Pay Dearnes Allowance @ 24%

Total

14530

5500 2750 1980

14530

10230

14970

5675

4300

25800 (notional)

4287

25722 (NOTIONAL)

4375

26250

4435

26610

4371

26226

4513

27078

4564

22820

From 1-7-2006 to 31-12-2006 Pay as on 1-7-2006 ( ( +i/c @ 3%) Dearnes Pay Dearnes Allowance @ 29% Dearnes Allowance @ 2%

Total

2838 2469 299

15269

10982

14970

5675 2838 2980

From 1-1-2007 to 30-6-2007 Pay as on 1-1-2007 ( Dearnes Pay Dearnes Allowance @ 35% Dearnes Allowance @ 6%

Total

898

15868

11493

15420

5850

From 1-7-2007 to 31-12-2007 Pay as on 1-7-2007 ( ( +i/c @ 3%) Dearnes Pay Dearnes Allowance @ 41% Dearnes Allowance @ 9%

Total

2925 3598 1388

16808

12373

15420

5850 2925 4124

From 1-1-2008 to 30-6-2008 Pay as on 1-1-2008 ( Dearnes Pay Dearnes Allowance @ 47% Dearnes Allowance @ 12%

Total

1850

17270

12899

15890

6025

From 1-7-2008 to 31-12-2008 Pay as on 1-7-2008 ( ( +i/c @ 3%) Dearnes Pay Dearnes Allowance @ 54% Dearnes Allowance @ 16%

Total From 1-1-2009 to 30-5-2009 Pay as on 1-1-2009 ( Dearnes Pay Dearnes Allowance @ 64% Dearnes Allowance @ 22%

Total

3013 4881 2542

18432

13919

15890

6025 3013 5784

3496

19386

14822

Arrears From: From 1-1-2007 to 30-6-2007 From 1-7-2007 to 31-12-2007 From 1-1-2008 to 30-6-2008 From 1-7-2008 to 31-12-2008 From 1-1-2009 to 30-5-2009

26250 26610 26226 27078 22820

Total Interim arrears Sanctioned (3 months basic Pay + Dearnes Pay + Dearnes allowance.) Balance Amount Due

Arrears Payment in 3 instalments First Instalment 2009-10 Second Instalement 2010-11 Third and Final instalement 2011-12

128984 40000 88984

29662 29661 29661

29661 88983 1

PAY From 1-1-2006 to 30-6-2006 Pay as on 1-1-2006 Dearnes Pay Dearnes Allowance @ 24%

Total

Due Rs.

Drawn Rs.

14530

5500 2750 1980

14530

10230

14530

5500 2750 2393

Differen ce Arrears Rs RS.

4300

25800 (notional)

4178

12534 (notional)

4287

12861

4375

26250

3944

11832

4064

12192

3984

23904

From 1-7-2006 to 30-09-2006 Pay as on 1-7-2007 ( Dearnes Pay Dearnes Allowance @ 29% Dearnes Allowance @ 2%

Total

291

14821

10643

14970

5675

From 1-10-2006 to 31-12-2006 Pay as on 1-10-2007 ( ( +i/c @ 3%) Dearnes Pay Dearnes Allowance @ 29% Dearnes Allowance @ 2%

Total

2838 2469 299

15269

10982

14970

5675 2838 2980

From 1-1-2007 to 30-6-2007 Pay as on 1-1-2007 ( Dearnes Pay Dearnes Allowance @ 35% Dearnes Allowance @ 6%

Total

898

15868

11493

14970

5850

From 1-7-2007 to 30-10-2007 Pay as on 1-7-2007 ( ( +i/c @ 3%) Dearnes Pay Dearnes Allowance @ 41% Dearnes Allowance @ 9%

Total

2925 3598 1347

16317

12373

15420

6025

From 1-10-2007 to 31-12-2007 Pay as on 1-10-2007 ( ( +i/c @ 3%) Dearnes Pay Dearnes Allowance @ 41% Dearnes Allowance @ 9%

Total

3013 3706 1388

16808

12744

15420

6025 3013 4248

From 1-1-2008 to 30-6-2008 Pay as on 1-1-2008 ( Dearnes Pay Dearnes Allowance @ 47% Dearnes Allowance @ 12%

Total

1850

17270

13286

From 1-7-2008 to 30-09-2008 Pay as on 1-7-2008 ( ( +i/c @ 3%) Dearnes Pay Dearnes Allowance @ 54% Dearnes Allowance @ 16%

Total From Pay as 1-10-2008 on 1-10-2008to 31-12-2008 ( ( +i/c @ 3%) Dearnes Pay Dearnes Allowance @54% Dearnes Allowance @ 16%

Total

15420

6025 3013 4881

2467

17887

13919

15890

6200

3968

11904

4110

12330

4134

20670

119082

119082

3100 5022 2542

18432

14322

15890

6200 3100 5952

From 1-1-2009 to 30-5-2009 Pay as on 1-7-2007 ( Dearnes Pay Dearnes Allowance @ 64% Dearnes Allowance @ 22%

Total

3496

19386

15252

Arrears From: From 1-1-2007 to 30-6-2007 From 1-7-2007 to 31-12-2007 From 1-1-2008 to 30-6-2008 From 1-7-2008 to 31-12-2008 From 1-1-2009 to 30-5-2009

26250 24024 23904 24234 20670

Total Interim arrears Sanctioned (3 months basic Pay + Dearnes Pay + Dearnes allowance.)

40000

Balance Amount Due

79082

Arrears Payment in 3 instalments First Instalment 2009-10

26360

Second Instalement 2010-11

26361

Third and Final instalement 2011-12

26361

26361 79083 -1

PAY From 1-6-2006 to 30-6-2006

Due Rs.

Pay as on 1-6-2006 Dearnes Pay Dearnes Allowance @ 24%

14530

Total From 1-7-2006 to 31-12-2006

14530

Pay as on 1-7-2006 ( Dearnes Pay Dearnes Allowance @ 24%

14530

Total From 1-1-2007 to 31-3-2007

14530

Pay as on 1-1-2007 Dearnes Pay Dearnes Allowance @ 35% Dearnes Allowance @ 6%

14530

Total From 1-4-2007 to 30-6-2007 Pay as on 1-4-2007 ( ( +i/c @ 3%) Dearnes Pay Dearnes Allowance @ 35% Dearnes Allowance @ 6%

Total From 1-7-2007 to 31-12-2007 Pay as on 1-7-2007 ( Dearnes Pay Dearnes Allowance @ 41% Dearnes Allowance @ 9%

Total From 1-1-2008 to 31-3-2008 Pay as on 1-1-2008 Dearnes Pay Dearnes Allowance @ 47% Dearnes Allowance @ 12%

Total From 1-4-2008 to 30-6-2008 Pay as on 1-4-2008 ( ( +i/c @ 3%) Dearnes Pay Dearnes Allowance @ 47% Dearnes Allowance @ 12%

Total

Drawn Rs.

Diff. Rs

Arrears RS.

5500 2750 1980 10230

4300

4300 (notional)

5500 2750 1980 10230

4300

25800 (NOTIONAL)

4264

12792

4375

13125

4314

25884

4252

12756

4371

13113

4373

26238

5500 2750 2888

872 15402

11138

14970

5675 2838 2980

898 15868

14970

1347 16317 14970

11493

5675 2838 3490 12003 5675 2838 4001

1796 16766

12514

15420

5850 2925 4124

1850 17270

12899

From 1-7-2008 to 31-12-2008 Pay as on 1-7-2008 ( Dearnes Pay Dearnes Allowance @ 54% Dearnes Allowance @ 16%

TOTAL

15420

2467 17887

5850 2925 4739 13514

From 1-1-2009 to 30-3-2009 Pay as on 1-1-2009 Dearnes Pay Dearnes Allowance @ 64% Dearnes Allowance @ 22%

Total From 1-4-2009 to 30-5-2009 Pay as on 1-4-2009 ( ( +i/c @ 3%) Dearnes Pay Dearnes Allowance @ 64% Dearnes Allowance @ 22%

Total

15420

5850 2925 5616

3392 18812

14391

15890

6025

4421

13263

4564

9128

3013 5784 3496 19386

14822

Arrears From:

126299

From 1-1-2007 to 30-3-2007 From 1-4-2007 to 30-6-2007 From 1-7-2007 to 31-12-2007 From 1-1-2008 to 31-3-2008 From 1-4-2008 to 30-6-2008 From 1-7-2008 to 31-12-2008 From 1-1-2008 to 30-3-2008 From 1-4-2009 to 30-5-2009

12792 13125 25884 12756 13113 26238 13263 9128

Total

Interim arrears Sanctioned ic Pay + Dearnes Pay + Dearnes allowance.) Balance Amount Due

126299 40000 86299

Arrears Payment in 3 instalments First Instalment 2009-10 Second Instalement 2010-11 Third and Final instalement 2011-12

28767 28766 28766

28766 86298 1

Related Documents


More Documents from ""