Spreadsheet: 550483d1512393604-adding-a-subtotal-to-diffrent-lenghts-subtotal
Sheet: Sheet1

Employee:
Process_x000D_Date | Tax_x000D_Week | Tax_x000D_Month | Taxable_x000D_Gross | Employer_x000D_NIC | Employer_x000D_Pension*
2015-01-02 00:00:00 | 39 | 9 | 619.66 | 65.07 | 5.14
2015-01-08 00:00:00 | 40 | 10 | 619.66 | 65.07 | 5.14
2015-01-16 00:00:00 | 41 | 10 | 0 | 0 | 0
2015-01-22 00:00:00 | 42 | 10 | 644.41 | 68.52 | 5.39
2015-01-30 00:00:00 | 43 | 10 | 773.07 | 86.46 | 6.69
2015-02-06 00:00:00 | 44 | 11 | 644.41 | 68.52 | 5.39
2015-02-13 00:00:00 | 45 | 11 | 644.41 | 68.52 | 5.39
2015-02-20 00:00:00 | 46 | 11 | 773.07 | 86.46 | 6.69
2015-02-27 00:00:00 | 47 | 11 | 773.07 | 86.46 | 6.69
2015-03-06 00:00:00 | 48 | 12 | 819.68 | 92.88 | 6.94
2015-03-13 00:00:00 | 49 | 12 | 882.16 | 101.57 | 6.94
2015-03-20 00:00:00 | 50 | 12 | 659.88 | 70.72 | 5.54
2015-03-27 00:00:00 | 51 | 12 | 773.07 | 86.46 | 6.69
2015-04-03 00:00:00 | 52 | 12 | 644.41 | 68.52 | 5.39
2015-04-10 00:00:00 | 1 | 1 | 510.81 | 49.47 | 4.03
2015-04-17 00:00:00 | 2 | 1 | 639.47 | 67.41 | 5.33
2015-04-24 00:00:00 | 3 | 1 | 644.42 | 68.1 | 5.38
2015-05-01 00:00:00 | 4 | 1 | 644.42 | 68.1 | 5.38
2015-05-08 00:00:00 | 5 | 2 | 773.08 | 86.04 | 6.68
2015-05-15 00:00:00 | 6 | 2 | 639.47 | 67.41 | 5.33
2015-05-22 00:00:00 | 7 | 2 | 773.08 | 86.04 | 6.68
2015-05-29 00:00:00 | 8 | 2 | 644.42 | 68.1 | 5.38
2015-06-05 00:00:00 | 9 | 2 | 768.13 | 85.35 | 6.63
2015-06-12 00:00:00 | 10 | 3 | 644.42 | 68.1 | 5.38
2015-06-19 00:00:00 | 11 | 3 | 593.69 | 61.06 | 4.87
2015-06-26 00:00:00 | 12 | 3 | 768.13 | 85.35 | 6.63
2015-07-03 00:00:00 | 13 | 3 | 644.42 | 68.1 | 5.38
2015-07-10 00:00:00 | 14 | 4 | 1142.61 | 137.03 | 7.03
2015-07-17 00:00:00 | 15 | 4 | 887.69 | 101.84 | 7.03
2015-07-24 00:00:00 | 16 | 4 | 644.42 | 68.1 | 5.38
2015-07-31 00:00:00 | 17 | 4 | 644.42 | 68.1 | 5.38
2015-08-07 00:00:00 | 18 | 5 | 883.97 | 101.43 | 7.03
2015-08-14 00:00:00 | 19 | 5 | 684.02 | 73.62 | 5.78
2015-08-21 00:00:00 | 20 | 5 | 0 | 0 | 0
2015-08-28 00:00:00 | 21 | 5 | 1117.61 | 133.58 | 7.03
Employee: |  |  |  |  |  | Subtotal |  |  |  |  | Expected results
Process_x000D_Date | Tax_x000D_Week | Tax_x000D_Month | Taxable_x000D_Gross | Employer_x000D_NIC | Employer_x000D_Pension*
2015-01-02 00:00:00 | 39 | 9 | 337.71 | 25.87 | 2.29
2015-01-08 00:00:00 | 40 | 10 | 674.31 | 72.79 | 5.69
2015-01-16 00:00:00 | 41 | 10 | 1170.56 | 141.32 | 6.94
2015-01-22 00:00:00 | 42 | 10 | 990.56 | 116.48 | 6.94
2015-01-30 00:00:00 | 43 | 10 | 1064.31 | 126.69 | 6.94
2015-02-06 00:00:00 | 44 | 11 | 715.15 | 78.45 | 6.1
2015-02-13 00:00:00 | 45 | 11 | 1213.06 | 147.25 | 6.94
2015-02-20 00:00:00 | 46 | 11 | 918.06 | 106.54 | 6.94
2015-02-27 00:00:00 | 47 | 11 | 918.06 | 106.54 | 6.94
2015-03-06 00:00:00 | 48 | 12 | 823.06 | 93.43 | 6.94
2015-03-13 00:00:00 | 49 | 12 | 918.06 | 106.54 | 6.94
2015-03-20 00:00:00 | 50 | 12 | 1998.06 | 255.58 | 6.94
Employee:
Process_x000D_Date | Tax_x000D_Week | Tax_x000D_Month | Taxable_x000D_Gross | Employer_x000D_NIC | Employer_x000D_Pension*
2015-01-02 00:00:00 | 39 | 9 | 223.98 | 10 | 1.14
2015-01-08 00:00:00 | 40 | 10 | 372.56 | 30.7 | 2.64
2015-01-16 00:00:00 | 41 | 10 | 676.51 | 73.07 | 5.71
2015-01-22 00:00:00 | 42 | 10 | 397.31 | 34.15 | 2.89
2015-01-30 00:00:00 | 43 | 10 | 476.55 | 45.19 | 3.69
2015-02-06 00:00:00 | 44 | 11 | 355.21 | 28.22 | 2.47
2015-02-13 00:00:00 | 45 | 11 | 397.31 | 34.15 | 2.89
2015-02-20 00:00:00 | 46 | 11 | 397.31 | 34.15 | 2.89
2015-02-27 00:00:00 | 47 | 11 | 476.55 | 45.19 | 3.69
2015-03-06 00:00:00 | 48 | 12 | 397.31 | 34.15 | 2.89
2015-03-13 00:00:00 | 49 | 12 | 0 | 0 | 0
2015-03-20 00:00:00 | 50 | 12 | 0 | 0 | 0
2015-03-27 00:00:00 | 51 | 12 | 0 | 0 | 0
2015-04-03 00:00:00 | 52 | 12 | 0 | 0 | 0
2015-04-10 00:00:00 | 1 | 1 | 579.01 | 58.99 | 4.72
2015-04-17 00:00:00 | 2 | 1 | 162.98 | 1.03 | 0.51
2015-04-24 00:00:00 | 3 | 1 | 88.45 | 0 | 0
2015-05-01 00:00:00 | 4 | 1 | 353.1 | 27.53 | 2.44
2015-05-08 00:00:00 | 5 | 2 | 397.32 | 33.74 | 2.88
2015-05-15 00:00:00 | 6 | 2 | 149.7 | 0 | 0.38
2015-05-22 00:00:00 | 7 | 2 | 0 | 0 | 0
2015-05-29 00:00:00 | 8 | 2 | 236.3 | 11.25 | 1.26
Employee:
Process_x000D_Date | Tax_x000D_Week | Tax_x000D_Month | Taxable_x000D_Gross | Employer_x000D_NIC | Employer_x000D_Pension*
2015-01-02 00:00:00 | 39 | 9 | 575.11 | 58.86 | 4.69
2015-01-08 00:00:00 | 40 | 10 | 570.16 | 58.17 | 4.64
2015-01-16 00:00:00 | 41 | 10 | 476.15 | 45.06 | 3.69
2015-01-22 00:00:00 | 42 | 10 | 594.91 | 61.62 | 4.89
2015-01-30 00:00:00 | 43 | 10 | 713.67 | 78.18 | 6.09
2015-02-06 00:00:00 | 44 | 11 | 722.95 | 79.56 | 6.18
2015-02-13 00:00:00 | 45 | 11 | 594.91 | 61.62 | 4.89
2015-02-20 00:00:00 | 46 | 11 | 490.38 | 47.13 | 3.83
2015-02-27 00:00:00 | 47 | 11 | 594.91 | 61.62 | 4.89
2015-03-06 00:00:00 | 48 | 12 | 623.36 | 65.62 | 5.18
2015-03-13 00:00:00 | 49 | 12 | 651.82 | 69.62 | 5.46
2015-03-20 00:00:00 | 50 | 12 | 713.67 | 78.18 | 6.09
2015-03-27 00:00:00 | 51 | 12 | 575.74 | 58.99 | 4.69
2015-04-03 00:00:00 | 52 | 12 | 580.06 | 59.55 | 4.74
2015-04-10 00:00:00 | 1 | 1 | 570.17 | 57.75 | 4.63
2015-04-17 00:00:00 | 2 | 1 | 589.97 | 60.51 | 4.83
2015-04-24 00:00:00 | 3 | 1 | 533.07 | 52.65 | 4.25
2015-05-01 00:00:00 | 4 | 1 | 476.16 | 44.64 | 3.68
2015-05-08 00:00:00 | 5 | 2 | 594.92 | 61.2 | 4.88
2015-05-15 00:00:00 | 6 | 2 | 471.21 | 43.95 | 3.63
2015-05-22 00:00:00 | 7 | 2 | 551.62 | 55.27 | 4.44
2015-05-29 00:00:00 | 8 | 2 | 594.92 | 61.2 | 4.88
2015-06-05 00:00:00 | 9 | 2 | 589.97 | 60.51 | 4.83
2015-06-12 00:00:00 | 10 | 3 | 589.97 | 60.51 | 4.83
2015-06-19 00:00:00 | 11 | 3 | 713.68 | 77.76 | 6.08
2015-06-26 00:00:00 | 12 | 3 | 594.92 | 61.2 | 4.88
2015-07-03 00:00:00 | 13 | 3 | 594.92 | 61.2 | 4.88
2015-07-10 00:00:00 | 14 | 4 | 589.97 | 60.51 | 4.83
2015-07-17 00:00:00 | 15 | 4 | 803.02 | 90.32 | 6.98
2015-07-24 00:00:00 | 16 | 4 | 669.37 | 71.69 | 5.63
2015-07-31 00:00:00 | 17 | 4 | 669.37 | 71.69 | 5.63
2015-08-07 00:00:00 | 18 | 5 | 803.02 | 90.32 | 6.98
2015-08-14 00:00:00 | 19 | 5 | 644.62 | 68.24 | 5.38
2015-08-21 00:00:00 | 20 | 5 | 798.07 | 89.63 | 6.93
2015-08-28 00:00:00 | 21 | 5 | 845.47 | 96.05 | 7.03
2015-09-04 00:00:00 | 22 | 5 | 1047.97 | 124.06 | 7.03
2015-09-11 00:00:00 | 23 | 6 | 911.72 | 105.15 | 7.03
2015-09-18 00:00:00 | 24 | 6 | 826.72 | 93.42 | 7.03
2015-09-25 00:00:00 | 25 | 6 | 1085.47 | 129.17 | 7.03
2015-09-30 00:00:00 | 26 | 6 | 1030.47 | 121.58 | 7.03
2015-10-09 00:00:00 | 27 | 7 | 711.44 | 77.49 | 6.06
2015-10-16 00:00:00 | 28 | 7 | 622.34 | 65.07 | 5.16
2015-10-23 00:00:00 | 29 | 7 | 1069.22 | 126.96 | 7.03
2015-10-30 00:00:00 | 30 | 7 | 849.22 | 96.6 | 7.03
2015-11-06 00:00:00 | 31 | 8 | 832.97 | 94.39 | 7.03
2015-11-13 00:00:00 | 32 | 8 | 1272.97 | 155.11 | 7.03
2015-11-20 00:00:00 | 33 | 8 | 865.35 | 98.81 | 7.03
2015-11-27 00:00:00 | 34 | 8 | 726.29 | 79.56 | 6.21
2015-12-04 00:00:00 | 35 | 8 | 451.57 | 41.33 | 3.43
2015-12-11 00:00:00 | 36 | 9 | 572.84 | 58.17 | 4.66
2015-12-18 00:00:00 | 37 | 9 | 774.56 | 86.32 | 6.69
2015-12-24 00:00:00 | 38 | 9 | 865.47 | 98.81 | 7.03
2015-12-31 00:00:00 | 39 | 9 | 847.97 | 96.46 | 7.03
Employee:
Process_x000D_Date | Tax_x000D_Week | Tax_x000D_Month | Taxable_x000D_Gross | Employer_x000D_NIC | Employer_x000D_Pension*
2015-01-02 00:00:00 | 39 | 9 | 1163.38 | 140.35 | 6.94
2015-01-08 00:00:00 | 40 | 10 | 580.42 | 59.68 | 4.74
2015-01-16 00:00:00 | 41 | 10 | 743.81 | 82.45 | 6.39
2015-01-22 00:00:00 | 42 | 10 | 870.17 | 99.92 | 6.94
2015-01-30 00:00:00 | 43 | 10 | 815.78 | 92.33 | 6.94
2015-02-06 00:00:00 | 44 | 11 | 893.3 | 103.09 | 6.94
2015-02-13 00:00:00 | 45 | 11 | 743.81 | 82.45 | 6.39
2015-02-20 00:00:00 | 46 | 11 | 779.71 | 87.43 | 6.75
2015-02-27 00:00:00 | 47 | 11 | 923.06 | 107.23 | 6.94
2015-03-06 00:00:00 | 48 | 12 | 614.91 | 64.51 | 5.09
2015-03-13 00:00:00 | 49 | 12 | 768.36 | 85.91 | 6.64
2015-03-20 00:00:00 | 50 | 12 | 576.55 | 59.13 | 4.7
2015-03-27 00:00:00 | 51 | 12 | 591.4 | 61.2 | 4.85
2015-04-03 00:00:00 | 52 | 12 | 743.61 | 82.45 | 6.39
2015-04-10 00:00:00 | 1 | 1 | 743.62 | 82.04 | 6.38
2015-04-17 00:00:00 | 2 | 1 | 743.62 | 82.04 | 6.38
2015-04-24 00:00:00 | 3 | 1 | 308.02 | 21.32 | 1.98
2015-05-01 00:00:00 | 4 | 1 | 0 | 0 | 0
2015-05-08 00:00:00 | 5 | 2 | 0 | 0 | 0
2015-05-15 00:00:00 | 6 | 2 | 149.62 | 0 | 0.38
2015-05-22 00:00:00 | 7 | 2 | 0 | 0 | 0
2015-05-29 00:00:00 | 8 | 2 | 0 | 0 | 0
2015-06-05 00:00:00 | 9 | 2 | 149.62 | 0 | 0.38
2015-06-12 00:00:00 | 10 | 3 | 0 | 0 | 0
2015-06-19 00:00:00 | 11 | 3 | 0 | 0 | 0
2015-06-26 00:00:00 | 12 | 3 | 0 | 0 | 0
2015-07-03 00:00:00 | 13 | 3 | 0 | 0 | 0
2015-07-10 00:00:00 | 14 | 4 | 0 | 0 | 0
2015-07-17 00:00:00 | 15 | 4 | 0 | 0 | 0
Employee:
Process_x000D_Date | Tax_x000D_Week | Tax_x000D_Month | Taxable_x000D_Gross | Employer_x000D_NIC | Employer_x000D_Pension*
2015-01-02 00:00:00 | 39 | 9 | 818.06 | 92.74 | 6.94
2015-01-08 00:00:00 | 40 | 10 | 743.61 | 82.45 | 6.39
2015-01-16 00:00:00 | 41 | 10 | 930.56 | 108.2 | 6.94
2015-01-22 00:00:00 | 42 | 10 | 1118.06 | 134.14 | 6.94
2015-01-30 00:00:00 | 43 | 10 | 1118.06 | 134.14 | 6.94
2015-02-06 00:00:00 | 44 | 11 | 1200 | 165.19 | 6.94
2015-02-13 00:00:00 | 45 | 11 | 1125 | 154.84 | 6.94
2015-02-20 00:00:00 | 46 | 11 | 825 | 113.44 | 6.94
2015-02-27 00:00:00 | 47 | 11 | 787.5 | 108.2 | 6.94
2015-03-06 00:00:00 | 48 | 12 | 1012.5 | 139.25 | 6.94
2015-03-13 00:00:00 | 49 | 12 | 1012.5 | 139.25 | 6.94
2015-03-20 00:00:00 | 50 | 12 | 787.5 | 108.2 | 6.94
2015-03-27 00:00:00 | 51 | 12 | 806.25 | 110.82 | 6.94
2015-04-03 00:00:00 | 52 | 12 | 825 | 113.44 | 6.94
2015-04-10 00:00:00 | 1 | 1 | 813.5 | 111.36 | 7.03
2015-04-17 00:00:00 | 2 | 1 | 1072 | 147.11 | 7.03
2015-04-24 00:00:00 | 3 | 1 | 837 | 114.68 | 7.03
2015-05-01 00:00:00 | 4 | 1 | 790 | 108.19 | 7.03
2015-05-08 00:00:00 | 5 | 2 | 1025 | 140.62 | 7.03
2015-05-15 00:00:00 | 6 | 2 | 1189.5 | 163.25 | 7.03
2015-05-22 00:00:00 | 7 | 2 | 978 | 134.13 | 7.03
2015-05-29 00:00:00 | 8 | 2 | 978 | 134.13 | 7.03
2015-06-05 00:00:00 | 9 | 2 | 978 | 134.13 | 7.03
2015-06-12 00:00:00 | 10 | 3 | 978 | 134.13 | 7.03
2015-06-19 00:00:00 | 11 | 3 | 1166 | 160.08 | 7.03
2015-06-26 00:00:00 | 12 | 3 | 978 | 134.13 | 7.03
2015-07-03 00:00:00 | 13 | 3 | 813.5 | 111.36 | 7.03
2015-07-10 00:00:00 | 14 | 4 | 978 | 134.13 | 7.03
2015-07-17 00:00:00 | 15 | 4 | 790 | 108.19 | 7.03
2015-07-24 00:00:00 | 16 | 4 | 813.5 | 111.36 | 7.03
2015-07-31 00:00:00 | 17 | 4 | 932.97 | 108.19 | 7.03
2015-08-07 00:00:00 | 18 | 5 | 932.97 | 108.19 | 7.03
2015-08-14 00:00:00 | 19 | 5 | 1987.97 | 253.78 | 7.03
2015-08-21 00:00:00 | 20 | 5 | 1687.97 | 212.38 | 7.03
2015-08-28 00:00:00 | 21 | 5 | 1492.97 | 185.47 | 7.03
2015-09-04 00:00:00 | 22 | 5 | 1792.97 | 226.87 | 7.03
2015-09-11 00:00:00 | 23 | 6 | 1680.97 | 211.41 | 7.03
2015-09-18 00:00:00 | 24 | 6 | 1792.97 | 226.87 | 7.03
2015-09-25 00:00:00 | 25 | 6 | 2092.97 | 268.27 | 7.03
2015-09-30 00:00:00 | 26 | 6 | 1492.97 | 185.47 | 7.03
2015-10-09 00:00:00 | 27 | 7 | 1792.97 | 226.87 | 7.03
2015-10-16 00:00:00 | 28 | 7 | 2392.97 | 309.67 | 7.03
2015-10-23 00:00:00 | 29 | 7 | 1268.97 | 154.56 | 7.03
2015-10-30 00:00:00 | 30 | 7 | 932.97 | 108.19 | 7.03
2015-11-06 00:00:00 | 31 | 8 | 1830.47 | 231.98 | 7.03
2015-11-13 00:00:00 | 32 | 8 | 2355.47 | 304.43 | 7.03
2015-11-20 00:00:00 | 33 | 8 | 2130.47 | 273.38 | 7.03
2015-11-27 00:00:00 | 34 | 8 | 1567.97 | 195.82 | 7.03
2015-12-04 00:00:00 | 35 | 8 | 2430.47 | 314.78 | 7.03
2015-12-11 00:00:00 | 36 | 9 | 1942.97 | 247.57 | 7.03
2015-12-18 00:00:00 | 37 | 9 | 1617.97 | 202.72 | 7.03
2015-12-24 00:00:00 | 38 | 9 | 2730.47 | 356.18 | 7.03
2015-12-31 00:00:00 | 39 | 9 | 1492.97 | 185.47 | 7.03
Employee:
Process_x000D_Date | Tax_x000D_Week | Tax_x000D_Month | Taxable_x000D_Gross | Employer_x000D_NIC | Employer_x000D_Pension*
2015-01-02 00:00:00 | 39 | 9 | 723.81 | 79.69 | 6.19
2015-01-08 00:00:00 | 40 | 10 | 718.86 | 79 | 6.14
2015-01-16 00:00:00 | 41 | 10 | 1103.06 | 132.07 | 6.94
2015-01-22 00:00:00 | 42 | 10 | 1103.06 | 132.07 | 6.94
2015-01-30 00:00:00 | 43 | 10 | 1103.06 | 132.07 | 6.94
2015-02-06 00:00:00 | 44 | 11 | 1288.06 | 157.6 | 6.94
2015-02-13 00:00:00 | 45 | 11 | 1103.06 | 132.07 | 6.94
2015-02-20 00:00:00 | 46 | 11 | 918.06 | 106.54 | 6.94
2015-02-27 00:00:00 | 47 | 11 | 918.06 | 106.54 | 6.94
2015-03-06 00:00:00 | 48 | 12 | 1170.56 | 141.32 | 6.94
2015-03-13 00:00:00 | 49 | 12 | 1103.06 | 132.07 | 6.94
2015-03-20 00:00:00 | 50 | 12 | 1283.06 | 156.91 | 6.94
2015-03-27 00:00:00 | 51 | 12 | 895.56 | 103.37 | 6.94
2015-04-03 00:00:00 | 52 | 12 | 913.06 | 105.85 | 6.94
2015-04-10 00:00:00 | 1 | 1 | 912.97 | 105.43 | 7.03
2015-04-17 00:00:00 | 2 | 1 | 1277.97 | 155.8 | 7.03
2015-04-24 00:00:00 | 3 | 1 | 1192.97 | 144.07 | 7.03
2015-05-01 00:00:00 | 4 | 1 | 917.97 | 106.12 | 7.03
2015-05-08 00:00:00 | 5 | 2 | 907.97 | 104.74 | 7.03
2015-05-15 00:00:00 | 6 | 2 | 1097.97 | 130.96 | 7.03
2015-05-22 00:00:00 | 7 | 2 | 728.77 | 79.97 | 6.23
2015-05-29 00:00:00 | 8 | 2 | 917.97 | 106.12 | 7.03
2015-06-05 00:00:00 | 9 | 2 | 892.97 | 102.67 | 7.03
2015-06-12 00:00:00 | 10 | 3 | 892.97 | 102.67 | 7.03
2015-06-19 00:00:00 | 11 | 3 | 892.97 | 102.67 | 7.03
2015-06-26 00:00:00 | 12 | 3 | 1072.97 | 127.51 | 7.03
2015-07-03 00:00:00 | 13 | 3 | 1140.47 | 136.76 | 7.03
2015-07-10 00:00:00 | 14 | 4 | 1185.47 | 142.97 | 7.03
2015-07-17 00:00:00 | 15 | 4 | 1207.97 | 146.14 | 7.03
2015-07-24 00:00:00 | 16 | 4 | 892.97 | 102.67 | 7.03
2015-07-31 00:00:00 | 17 | 4 | 1442.97 | 178.57 | 7.03
2015-08-07 00:00:00 | 18 | 5 | 1492.97 | 185.47 | 7.03
2015-08-14 00:00:00 | 19 | 5 | 1492.97 | 185.47 | 7.03
2015-08-21 00:00:00 | 20 | 5 | 1422.97 | 175.81 | 7.03
2015-08-28 00:00:00 | 21 | 5 | 1492.97 | 185.47 | 7.03
2015-09-04 00:00:00 | 22 | 5 | 1422.97 | 175.81 | 7.03
2015-09-11 00:00:00 | 23 | 6 | 1290.47 | 157.46 | 7.03
2015-09-18 00:00:00 | 24 | 6 | 1492.97 | 185.47 | 7.03
2015-09-25 00:00:00 | 25 | 6 | 1992.97 | 254.47 | 7.03
2015-09-30 00:00:00 | 26 | 6 | 1992.97 | 254.47 | 7.03
2015-10-09 00:00:00 | 27 | 7 | 1672.97 | 210.31 | 7.03
2015-10-16 00:00:00 | 28 | 7 | 1492.97 | 185.47 | 7.03
2015-10-23 00:00:00 | 29 | 7 | 1742.97 | 219.97 | 7.03
2015-10-30 00:00:00 | 30 | 7 | 1290.47 | 157.46 | 7.03
2015-11-06 00:00:00 | 31 | 8 | 1742.97 | 219.97 | 7.03
2015-11-13 00:00:00 | 32 | 8 | 1742.97 | 219.97 | 7.03
2015-11-20 00:00:00 | 33 | 8 | 1742.97 | 219.97 | 7.03
2015-11-27 00:00:00 | 34 | 8 | 1742.97 | 219.97 | 7.03
2015-12-04 00:00:00 | 35 | 8 | 1742.97 | 219.97 | 7.03
2015-12-11 00:00:00 | 36 | 9 | 1492.97 | 185.47 | 7.03
2015-12-18 00:00:00 | 37 | 9 | 3462.97 | 457.33 | 7.03
2015-12-24 00:00:00 | 38 | 9 | 1742.97 | 219.97 | 7.03
2015-12-31 00:00:00 | 39 | 9 | 1157.97 | 139.24 | 7.03
Employee:
Process_x000D_Date | Tax_x000D_Week | Tax_x000D_Month | Taxable_x000D_Gross | Employer_x000D_NIC | Employer_x000D_Pension*
2015-01-02 00:00:00 | 39 | 9 | 953.06 | 111.37 | 6.94
2015-01-08 00:00:00 | 40 | 10 | 953.06 | 111.37 | 6.94
2015-01-16 00:00:00 | 41 | 10 | 953.06 | 111.37 | 6.94
2015-01-22 00:00:00 | 42 | 10 | 953.06 | 111.37 | 6.94
2015-01-30 00:00:00 | 43 | 10 | 953.06 | 111.37 | 6.94
2015-02-06 00:00:00 | 44 | 11 | 953.06 | 111.37 | 6.94
2015-02-13 00:00:00 | 45 | 11 | 953.06 | 111.37 | 6.94
2015-02-20 00:00:00 | 46 | 11 | 953.06 | 111.37 | 6.94
2015-02-27 00:00:00 | 47 | 11 | 953.06 | 111.37 | 6.94
2015-03-06 00:00:00 | 48 | 12 | 953.06 | 111.37 | 6.94
2015-03-13 00:00:00 | 49 | 12 | 953.06 | 111.37 | 6.94
2015-03-20 00:00:00 | 50 | 12 | 953.06 | 111.37 | 6.94
2015-03-27 00:00:00 | 51 | 12 | 953.06 | 111.37 | 6.94
2015-04-03 00:00:00 | 52 | 12 | 953.06 | 111.37 | 6.94
2015-04-10 00:00:00 | 1 | 1 | 952.97 | 110.95 | 7.03
2015-04-17 00:00:00 | 2 | 1 | 952.97 | 110.95 | 7.03
2015-04-24 00:00:00 | 3 | 1 | 952.97 | 110.95 | 7.03
2015-05-01 00:00:00 | 4 | 1 | 952.97 | 110.95 | 7.03
2015-05-08 00:00:00 | 5 | 2 | 952.97 | 110.95 | 7.03
2015-05-15 00:00:00 | 6 | 2 | 952.97 | 110.95 | 7.03
2015-05-22 00:00:00 | 7 | 2 | 952.97 | 110.95 | 7.03
2015-05-29 00:00:00 | 8 | 2 | 952.97 | 110.95 | 7.03
2015-06-05 00:00:00 | 9 | 2 | 952.97 | 110.95 | 7.03
2015-06-12 00:00:00 | 10 | 3 | 952.97 | 110.95 | 7.03
2015-06-19 00:00:00 | 11 | 3 | 952.97 | 110.95 | 7.03
2015-06-26 00:00:00 | 12 | 3 | 952.97 | 110.95 | 7.03
2015-07-03 00:00:00 | 13 | 3 | 952.97 | 110.95 | 7.03
2015-07-10 00:00:00 | 14 | 4 | 952.97 | 110.95 | 7.03
2015-07-17 00:00:00 | 15 | 4 | 952.97 | 110.95 | 7.03
2015-07-24 00:00:00 | 16 | 4 | 952.97 | 110.95 | 7.03
2015-07-31 00:00:00 | 17 | 4 | 952.97 | 110.95 | 7.03
2015-08-07 00:00:00 | 18 | 5 | 952.97 | 110.95 | 7.03
2015-08-14 00:00:00 | 19 | 5 | 952.97 | 110.95 | 7.03
2015-08-21 00:00:00 | 20 | 5 | 1072.97 | 127.51 | 7.03
2015-08-28 00:00:00 | 21 | 5 | 892.97 | 102.67 | 7.03
2015-09-04 00:00:00 | 22 | 5 | 892.97 | 102.67 | 7.03
2015-09-11 00:00:00 | 23 | 6 | 892.97 | 102.67 | 7.03
2015-09-18 00:00:00 | 24 | 6 | 892.97 | 102.67 | 7.03
2015-09-25 00:00:00 | 25 | 6 | 892.97 | 102.67 | 7.03
2015-09-30 00:00:00 | 26 | 6 | 892.97 | 102.67 | 7.03
2015-10-09 00:00:00 | 27 | 7 | 892.97 | 102.67 | 7.03
2015-10-16 00:00:00 | 28 | 7 | 892.97 | 102.67 | 7.03
2015-10-23 00:00:00 | 29 | 7 | 892.97 | 102.67 | 7.03
2015-10-30 00:00:00 | 30 | 7 | 892.97 | 102.67 | 7.03
2015-11-06 00:00:00 | 31 | 8 | 892.97 | 102.67 | 7.03
2015-11-13 00:00:00 | 32 | 8 | 892.97 | 102.67 | 7.03
2015-11-20 00:00:00 | 33 | 8 | 892.97 | 102.67 | 7.03
2015-11-27 00:00:00 | 34 | 8 | 892.97 | 102.67 | 7.03
2015-12-04 00:00:00 | 35 | 8 | 892.97 | 102.67 | 7.03
2015-12-11 00:00:00 | 36 | 9 | 892.97 | 102.67 | 7.03
2015-12-18 00:00:00 | 37 | 9 | 1792.97 | 226.87 | 7.03
2015-12-24 00:00:00 | 38 | 9 | 892.97 | 102.67 | 7.03
2015-12-31 00:00:00 | 39 | 9 | 892.97 | 102.67 | 7.03