jagomart
digital resources
picture1_Bonus Calculation Excel Sheet 46481 | 2021 Paye Regulation 6 Formula


 187x       Filetype XLSX       File size 0.06 MB       Source: www.frcs.org.fj


File: Bonus Calculation Excel Sheet 46481 | 2021 Paye Regulation 6 Formula
sheet 1 weekly calculation of income tax and srt to wtihhold d e h f g c1 c2 a1 a2 b1 b2 date pay no normal pay total paid in ...

icon picture XLSX Filetype Excel XLSX | Posted on 18 Aug 2022 | 3 years ago
Partial file snippet.
Sheet 1: Weekly

Calculation of Income Tax and SRT to Wtihhold























































































































D E
H F G C1 C2 A1 A2

B1 B2













Date Pay No. Normal pay Total paid in previous period Bonus, etc. Total bonuses, etc. to date No. of payment period Number of completed pay period including current Annual income
(normal)
Annual income
(normal plus bonus)
Total tax on C1 Tax withheld to date Tax to withhold Actual tax to withhold
FNPF deduction
Net salary
Income Tax SRT ECAL Total Income Tax SRT ECAL Total Income Tax SRT ECAL Total Income Tax SRT ECAL Total




0
-











- - - - - - - -




1
-
- 52 1 - - - - - - - - - - - - - - - - - -
-
-

2
-
- 52 2 - - - - - - - - - - #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

3
-
- 52 3 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

4
-
- 52 4 - - - - - - - - - - #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

5
-
- 52 5 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

6
-
- 52 6 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

7
-
- 52 7 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

8
-
- 52 8 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

9
-
- 52 9 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

10
-
- 52 10 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

11
-
- 52 11 - - - - - - - - - - #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

12
-
- 52 12 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

13
-
- 52 13 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

14
-
- 52 14 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

15
-
- 52 15 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

16
-
- 52 16 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

17
-
- 52 17 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

18
-
- 52 18 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

19
-
- 52 19 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

20
-
- 52 20 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - -
#NAME?
#NAME?

21
-
- 52 21 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

22
-
- 52 22 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

23
-
- 52 23 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

24
-
- 52 24 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

25
-
- 52 25 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

26
-
- 52 26 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

27
-
- 52 27 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

28
-
- 52 28 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

29
-
- 52 29 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

30
-
- 52 30 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

31
-
- 52 31 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

32
-
- 52 32 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

33
-
- 52 33 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

34
-
- 52 34 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

35
-
- 52 35 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

36
-
- 52 36 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

37
-
- 52 37 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

38
-
- 52 38 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

39
-
- 52 39 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

40
-
- 52 40 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

41
-
- 52 41 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

42
-
- 52 42 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

43
-
- 52 43 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

44
-
- 52 44 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

45
-
- 52 45 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

46
-
- 52 46 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

47
-
- 52 47 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

48
-
- 52 48 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

49
-
- 52 49 - - - - - - #NAME? - - #NAME? - - - - - - - -
#NAME?
#NAME?

50
-
- 52 50 - - - - - - #NAME? - - #NAME? - - - - - - - -
#NAME?
#NAME?

51
-
- 52 51 - - - - - - #NAME? - - #NAME? - - - - - - - -
#NAME?
#NAME?

52
-
- 52 52 - - - - - - #NAME? - - #NAME? - - - - - - - -
#NAME?
#NAME?
































-
-
















- - - -
-
-































Gross emoluments including bonuses






















-


































Total tax fpr the year



















- - - -


































Excess tax deducted



















- - - -
































































































[A1 / F x G] - B1 + income tax on C2 - income tax on C1 [if result < 0, then tax to be withhold = 0]




























[A2 / F x G] - B2 [if result < 0, then tax to be withhold = 0]


























































Income tax payable on C1




























SRT payable on C2


























































Income tax withheld to date




























SRT withheld to date


























































Number of payment periods in the tax year




























Number of completed pay periods including current period




























Tax withheld to date
























































































[D x (F - G + 1)] + E [however, if the pay period is the same as the previous, then C1 = C1 in the previous pay period]


























































C1 + H


























































Amount of employment income paid by the employer to the employee in the current payment period




























Total amount of employment income paid by the employer to the employee in the previous payment periods in the tax year




























Total bonuses paid to date including that paid in the current period


























Sheet 2: Fortnightly
Calculation of Income Tax and SRT to Wtihhold
























































































































D E
H F G C1 C2 A1 A2

B1 B2













Date Pay No. Normal pay Total paid in previous period Bonus, etc. Total bonuses, etc. to date No. of payment period Number of completed pay period including current Annual income
(normal)
Annual income
(normal plus bonus)
Total tax on C1 Tax withheld to date Tax to withhold Actual tax to withhold
FNPF deduction
Net salary
Income Tax SRT ECAL Total Income Tax SRT ECAL Total Income Tax SRT ECAL Total Income Tax SRT ECAL Total




0
-











- - - - - - - -




1
-
- 26 1.00 - - - - - - - - - - - - - - - - - -
-
-

2
-
- 26 2.00 - - - - - - - - - - #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
-

3
-
- 26 3.00 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

4
-
- 26 4.00 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

5
-
- 26 5.00 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

6
-
- 26 6.00 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - -
#NAME?
#NAME?

7
-
- 26 7.00 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

8
-
- 26 8.00 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

9
-
- 26 9.00 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

10
-
- 26 10.00 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

11
-
- 26 11.00 - - - - - - - - - - #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

12
-
- 26 12.00 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

13
-
- 26 13.00 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

14
-
- 26 14.00 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

15
-
- 26 15.00 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

16
-
- 26 16.00 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

17
-
- 26 17.00 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

18
-
- 26 18.00 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

19
-
- 26 19.00 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

20
-
- 26 20.00 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

21
-
- 26 21.00 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

22
-
- 26 22.00 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

23
-
- 26 23.00 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

24
-
- 26 24.00 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

25
-
- 26 25.00 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

26
-
- 26 26.00 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?
































-
-
















- - - -
-
-































Gross emoluments including bonuses






















-


































Total tax fpr the year



















- - - -


































Excess tax deducted



















- - - -





























































































Income tax to withhold =

[A1 / F x G] - B1 + income tax on C2 - income tax on C1 [if result < 0, then tax to be withhold = 0]

























SRT to withhold =

[A2 / F x G] - B2 [if result < 0, then tax to be withhold = 0]























































A1 =

Income tax payable on C1

























A2 =

SRT payable on C2























































B1 =

Income tax withheld to date

























B2 =

SRT withheld to date























































F =

Number of payment periods in the tax year

























G =

Number of completed pay periods including current period

























B =

Tax withheld to date





















































































C1 =

[D x (F - G + 1)] + E [however, if the pay period is the same as the previous, then C1 = C1 in the previous pay period]























































C2 =

C1 + H























































D =

Amount of employment income paid by the employer to the employee in the current payment period

























E =

Total amount of employment income paid by the employer to the employee in the previous payment periods in the tax year

























H =

Total bonuses paid to date including that paid in the current period


























Sheet 3: Monthly
Calculation of Income Tax and SRT to Wtihhold
























































































































D E
H F G C1 C2 A1 A2

B1 B2













Date Pay No. Normal pay Total paid in previous period Bonus, etc. Total bonuses, etc. to date No. of payment period Number of completed pay period including current Annual income
(normal)
Annual income
(normal plus bonus)
Total tax on C1 Tax withheld to date Tax to withhold Actual tax to withhold
FNPF deduction
Net salary
Income Tax SRT ECAL Total Income Tax SRT ECAL Total Income Tax SRT ECAL Total Income Tax SRT ECAL Total




0
-











- - - - - - - -




1
- - - 12 1.00 - - - - - - - - - - - - - - - - - -
-
-

2
- - - 12 2.00 - - - - - - - - - - #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

3
- - - 12 3.00 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

4
- - - 12 4.00 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

5
- - - 12 5.00 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

6
- - - 12 6.00 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

7
-
- 12 7.00 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

8
- - - 12 8.00 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

9
- - - 12 9.00 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

10
- - - 12 10.00 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

11
- - - 12 11.00 - - - - - - - - - - #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?

12
- - - 12 12.00 - - - - - - #NAME? - - #NAME? #NAME? - - #NAME? #NAME? - - #NAME?
#NAME?
#NAME?
































-
-
















- - - -
-
-































Gross emoluments including bonuses






















-


































Total tax fpr the year



















- - - -


































Excess tax deducted



















- - - -





























































































Income tax to withhold =

[A1 / F x G] - B1 + income tax on C2 - income tax on C1 [if result < 0, then tax to be withhold = 0]

























SRT to withhold =

[A2 / F x G] - B2 [if result < 0, then tax to be withhold = 0]























































A1 =

Income tax payable on C1

























A2 =

SRT payable on C2























































B1 =

Income tax withheld to date

























B2 =

SRT withheld to date























































F =

Number of payment periods in the tax year

























G =

Number of completed pay periods including current period

























B =

Tax withheld to date





















































































C1 =

[D x (F - G + 1)] + E [however, if the pay period is the same as the previous, then C1 = C1 in the previous pay period]























































C2 =

C1 + H























































D =

Amount of employment income paid by the employer to the employee in the current payment period

























E =

Total amount of employment income paid by the employer to the employee in the previous payment periods in the tax year

























H =

Total bonuses paid to date including that paid in the current period


























The words contained in this file might help you see if this file matches what you are looking for:

...Sheet weekly calculation of income tax and srt to wtihhold d e h f g c a b date pay no normal total paid in previous period bonus etc bonuses payment number completed including current annual plus on withheld withhold actual fnpf deduction net salary ecal name...

no reviews yet
Please Login to review.