Spreadsheet: 861457d1709303299-searching-specific-cells-on-varying-alternate-rows-this-file-begs-for-pq
Sheet: Demo Site

PDF - CSV 1 | PDF - CSV 2 | PDF - CSV 3 | PDF - CSV 4 | PDF - CSV 5 | PDF - CSV 6 | PDF - CSV 7 | PDF - CSV 8 | Payroll Number | Ni Number | Tax Code | Name | Taxable Pay YTD | Tax Paid YTD | Annual Salary
Redacted
Redacted
[NAME]
566 Pages
Run Date: | Monday 27 March 2017
Run Time: | 15:08:56
Run by: | DDDD
Run Report ID: 4054480GlR
Redacted Name 1 |  |  |  |  | Redacted Business
Redacted Address 1
Redacted Address 1
Redacted Address 1
Redacted Address 1
Redacted Address 1
 |  |  |  |  | PRIVATE AND CONFIDENTIAL
Payroll Name | Redacted |  |  |  |  | Paydate | 2017-03-27 00:00:00
 |  |  |  |  |  | Tax Period | 12
Employee Name | Redacted Name 1 |  |  |  |  | Tax code | BR / 0
 |  |  |  |  |  | N.I. Number | N222222A
Reference No. | M00000188 |  |  |  |  | N.I. Code | A
Payments |  |  |  | Deductions |  | This Period
Description | U/T | Rate | Cash | Description | Cash | Description | Cash
Salary |  | 1629.93 |  | Tax | 307 | Taxable Payments This | 1535.39
 |  |  |  | NI - A | 114.95 | Pensionable Pay This | 1629.93
 |  |  |  | SPGA Main | 94.54
 |  |  |  |  |  | Year-to-date
 |  |  |  |  |  | Tax Paid YTD | 3684.8
 |  |  |  |  |  | [NAME] YTD - A | 1379.41
 |  |  |  |  |  | Taxable Pay YTD | 18424.7
 |  |  |  |  |  | Niable Pay YTD | 19559.17
Payments |  | 1629.93 |  | Deductions | 516.49
 |  |  |  |  |  | NET
Annual Salary: | 19559.19 |  |  | Tax Ref: 234/B1122 |  |  | 1113.44
 |  |  |  |  |  | PAY
 |  |  |  |  |  | Paid By | BACS
 |  |  |  |  |  | Sort Code | 200574
V1.4 |  |  |  |  |  | Account | ****2601
Redacted Name 2 |  |  |  |  | Redacted Business
Redacted Address 2
Redacted Address 2
Redacted Address 2
Redacted Address 2
Redacted Address 2
Redacted Address 2
 |  |  |  |  | PRIVATE AND CONFIDENTIAL
Payroll Name | AZAZ Co: Monthly |  |  |  |  | Paydate | 2017-03-27 00:00:00
 |  |  |  |  |  | Tax Period | 12
Employee Name | Redacted Name 2 |  |  |  |  | Tax code | 1108L / 0
 |  |  |  |  |  | N.I. Number | W444444C
Reference No. | M00000076 |  |  |  |  | N.I. Code | A
Payments |  |  |  | Deductions |  | This Period
Description | U/T | Rate | Cash | Description | Cash | Description | Cash
Salary |  | 3337.17 |  | Tax | 437.2 | Taxable Payments This | 3110.24
 |  |  |  | NI - A | 319.82 | Pensionable Pay This | 3337.17
 |  |  |  | SPGA Main | 226.93
 |  |  |  | Company Draw | 9.75
 |  |  |  |  |  | Year-to-date
 |  |  |  |  |  | Tax Paid YTD | 5384.8
 |  |  |  |  |  | [NAME] YTD - A | 3888.59
 |  |  |  |  |  | Taxable Pay YTD | 38014.02
 |  |  |  |  |  | Niable Pay YTD | 40773.88
Payments |  | 3337.17 |  | Deductions | 993.7
 |  |  |  |  |  | NET
Annual Salary: | 40046 |  |  | Tax Ref: 234/B1122 |  |  | 2343.47
 |  |  |  |  |  | PAY
 |  |  |  |  |  | Paid By | BACS
 |  |  |  |  |  | Sort Code | 90131
V1.4 |  |  |  |  |  | Account | ****2407
Redacted Name 3 |  |  |  |  | Redacted Business
Redacted Address 3
Redacted Address 3
Redacted Address 3
Redacted Address 3
 |  |  |  |  | PRIVATE AND CONFIDENTIAL
Payroll Name | AZAZ Co: Monthly |  |  |  |  | Paydate | 2017-03-27 00:00:00
 |  |  |  |  |  | Tax Period | 12
Employee Name | Redacted Name 3 |  |  |  |  | Tax code | 1099L / 0
 |  |  |  |  |  | N.I. Number | JG666666B
Reference No. | M00219642 |  |  |  |  | N.I. Code | A
Payments |  |  |  | Deductions |  | This Period
Description | U/T | Rate | Cash | Description | Cash | Description | Cash
Salary |  | 1299.87 |  | Tax | 61.6 | Taxable Payments This | 1224.48
[NAME] (Abs. offset) |  | -1090.21 |  | NI - A | 75.34 | Pensionable Pay This | 1299.87
[NAME] (Abs. payment) |  | 1090.21 |  | SPGA Main | 75.39
 |  |  |  |  |  | Year-to-date
 |  |  |  |  |  | Tax Paid YTD | 753
 |  |  |  |  |  | [NAME] YTD - A | 913.07
 |  |  |  |  |  | Taxable Pay YTD | 14764.2
 |  |  |  |  |  | Niable Pay YTD | 15673.23
Payments |  | 1299.87 |  | Deductions | 212.33
 |  |  |  |  |  | NET
Annual Salary: | 15598.38 |  |  | Tax Ref: 234/B1122 |  |  | 1087.54
 |  |  |  |  |  | PAY
 |  |  |  |  |  | Paid By | BACS
 |  |  |  |  |  | Sort Code | 600708
V1.4 |  |  |  |  |  | Account | ****9935
Redacted Name 4 |  |  |  |  | Redacted Business
Redacted Address 4
Redacted Address 4
Redacted Address 4
Redacted Address 4
Redacted Address 4
 |  |  |  |  | PRIVATE AND CONFIDENTIAL
Payroll Name | AZAZ Co: Monthly |  |  |  |  | Paydate | 2017-03-27 00:00:00
 |  |  |  |  |  | Tax Period | 12
Employee Name | Redacted Name 4 |  |  |  |  | Tax code | 1100L / 0
 |  |  |  |  |  | N.I. Number | JM777777C
Reference No. | M00218818 |  |  |  |  | N.I. Code | A
Payments |  |  |  | Deductions |  | This Period
Description | U/T | Rate | Cash | Description | Cash | Description | Cash
Standby | 20.3 |  | 20.3 | Tax | 317.8 | Taxable Payments This | 2506.12
STRATEGIC RESERVE | 13.53 | 324.72 |  | NI - A | 257.14 | Pensionable Pay This | 2469.83
Salary |  | 2469.83 |  | AFPG 2015 | 308.73
 |  |  |  | ACCIDENT INJURY | 3.47
 |  |  |  | CLO Fund | 5
 |  |  |  | Co Draw | 5
 |  |  |  | Company Draw | 8.67
 |  |  |  | SCE | 23.88
 |  |  |  | Course FUND | 0.74
 |  |  |  |  |  | Year-to-date
 |  |  |  |  |  | Tax Paid YTD | 3911
 |  |  |  |  |  | [NAME] YTD - A | 3153.14
 |  |  |  |  |  | Taxable Pay YTD | 30564.64
 |  |  |  |  |  | Niable Pay YTD | 34340.13
Payments |  | 2814.85 |  | Deductions | 930.43
 |  |  |  |  |  | NET
Annual Salary: | 29638 |  |  | Tax Ref: 234/B1122 |  |  | 1884.42
 |  |  |  |  |  | PAY
 |  |  |  |  |  | Paid By | BACS
 |  |  |  |  |  | Sort Code | 205740
V1.4 |  |  |  |  |  | Account | ****7030
Redacted Name 5 |  |  |  |  | Redacted Business
Redacted Address 5
Redacted Address 5
Redacted Address 5
Redacted Address 5
 |  |  |  |  | PRIVATE AND CONFIDENTIAL
Payroll Name | AZAZ Co: Monthly |  |  |  |  | Paydate | 2017-03-27 00:00:00
 |  |  |  |  |  | Tax Period | 12
Employee Name | Redacted Name 5 |  |  |  |  | Tax code | 646L / 0
 |  |  |  |  |  | N.I. Number | [NAME]
Reference No. | M00837406 |  |  |  |  | N.I. Code | A
Payments |  |  |  | Deductions |  | This Period
Description | U/T | Rate | Cash | Description | Cash | Description | Cash
Flexible Duty | 0.2 | 733.63 |  | Tax | 755.47 | Taxable Payments This | 3761.06
Car Contract-Diesel |  |  | 84.36 | NI - A | 365.7 | Non Taxable Payments | 95.2
Salary |  | 3668.17 |  | AFPG 1992 | 640.74 | Pensionable Pay This | 4215.39
VAT ON MILEAGE (NON |  |  | 10.84 | Car Lease | 163.58
 |  |  |  | Company Draw | 6.5