Payroll Qualification
Model answers
Level 2 Certificate in Payroll Administration (QCF)
Determining net pay (DNP)
June 2010
The model answers may, in parts, be longer than would be expected of candidates in the exam. The fuller version is given for teaching purposes.
Section 1
Task 1.1
Calculation for Task 1.1 – Donna Bellony – April 2010 gross to net payBasic pay / 2,087.50
Pension contribution for April 2010
(1 mark only for incorrect rounding) / 2,087.50 x 6.5%= / 135.69
AVC for April 2010 / 75.00
Tax calculation
Cumulative gross pay / 2,087.50
Less cumulative allowable deductions / 135.69 + 75.00 = / 210.69
Cumulative pay for tax purposes / 2,087.50 - 210.69 = / 1,876.81
Tax code used / 647L / Tax basis / Cumulative
Adjustment for tax code / 416.67 + 123.25 = / 539.92
Cumulative net taxable pay / 1,876.81 – 539.92 = / 1,336.89
Tax calculation
1,336.00 x 20%= / 267.20
Tax due for April 2010 / 267.20
NICs calculation / NI table letter used / D
2,087.50 – 476.00 = / 1,611.50
476.00 – 412.00 = / 64.00
Employee’s contribution payable
1,611.50 x 9.4% = / 151.48
64.00 x 1.6% = / (1.02)
Total / 150.46
Employer’s contribution payable
1,611.50 x 9.1% = / 146.65
64.00 x 3.7% = / (2.37)
Total / 144.28
Payslip for April 2010
Employee: Donna Bellony / Date: 30 April 2010Payments
£ / Deductions
£ / Year to date
£
Basic pay:2,087.50 / Income tax:267.20 / Gross pay: 2,087.50
NIC:150.46 / Pay for tax purposes: 1,876.81
Pension:135.69 / Income tax:267.20
AVC: 75.00 / Employee’s NIC:150.46
Leisure club: 87.50 / Employer’s NIC:144.28
Pension:135.69
AVC: 75.00
Leisure club: 87.50
Total gross pay: / 2,087.50 / Total deductions: / 715.85 / Net pay: 1,371.65
NI number:TP205169ATax code:647L
Calculation for Task 1.1 – Donna Bellony – May 2010 gross to net payBasic pay / 4,175.00
Bonus / 2,500.00
Pension contribution for May 2010 / 6,675.00 x 6.5%= / 433.88
AVC for May 2010 / 75.00
Charitable giving for May 2010 / 250.00
Cumulatives: / Pension 135.69 + 433.88 = 569.57
AVC 75.00+ 75.00= 150.00
Charitable Giving 250.00
Cumulative gross pay to May 2010 / 6,675.00 + 2,087.50 = / 8,762.50
Less cumulative allowable deductions / 569.57 + 150.00 + 250.00 = / 969.57
Cumulative pay for tax purposes / 8,762.50 – 969.57 = / 7,792.93
Tax code used / BR / Tax basis / Cumulative
Adjustment for tax code / Nil
Cumulative net taxable pay / 7,792.93
Tax calculation
7,792.00 x 20% = / 1,558.40
Tax due to May 2010 / 1,558.40
Tax deducted in April 2010 / 267.20
Tax due for May 2009 / 1,558.40 – 267.20 = / 1,291.20
NICs calculation / NI table letter used / D
6,675.00 – 3,656.00 = / 3019.00
3,656.00 – 3,337.00 = / 319.00
3,337.00 – 476.00 = / 2,861.00
476.00 – 412.00 = / 64.00
Employee’s contribution payable / 3,019.00 x 1% = / 30.19
319.00 x 11% = / 35.09
2,861.00 x 9.4% = / 268.93
64.00 x 1.6% = / (1.02)
Total / 333.19
Employer’s contribution payable / 3,338.00 x 12.8% = / 427.26
2,861.00 x 9.1% = / 260.35
64.00 x 3.7% = / (2.37)
Total / 685.24
Payslip for May 2010
Employee: Donna Bellony / Date: 28 May 2010Payments
£ / Deductions
£ / Year to date
£
Basic pay: / 4,175.00 / Income tax: 1,291.20 / Gross pay: / 8,762.50
Bonus 2,500.00 / NIC:333.19 / Pay for tax purposes: / 7,792.93
Pension:433.88 / Income tax: / 1,558.40
AVC: 75.00 / Employee’s NIC: 483.65
Charitable giving:250.00 / Employer’s NIC: 829.52
Leisure club 87.50 / Pension: 569.57
AVC: 150.00
Charitable giving: 250.00
Leisure club: 175.00
Total gross pay: / 6,675.00 / Total deductions: / 2,470.77 / Net pay: 4,204.23
NI number:TP205169ATax code:BR
Calculation for Task 1.1 – Debjani Mukherjee – April 2010 gross to net payBasic pay / 1,750.00
Tax calculation
Cumulative gross pay / 1,750.00
Cumulative pay for tax purposes / 1,750.00
Tax code used / 647L / Tax basis / Month 1
Adjustment for tax code / 416.67 + 123.25 = / 539.92
Cumulative net taxable pay / 1,750.00 – 539.92 = / 1,210.08
Tax calculation
1,210.00 x 20% = / 242.00
Tax due for April 2010 / 242.00
NICs calculation / NI table letter used / A
Employee’s contribution payable / 1,750.00 – 476.00 x 11% = / 140.14
Employer’s contribution payable / 1,750.00 – 476.00 x 12.8% = / 163.07
Payslip for April 2010
Employee: Debjani Mukherjee / Date: 30 April 2010Payments
£ / Deductions
£ / Year to date
£
Basic pay: / 1,750.00 / Income tax: / 242.00 / Gross pay: / 1,750.00
NIC: / 140.14 / Pay for tax purposes: / 1,750.00
Tax: 242.00
Employee’s NIC: 140.14
Employer’s NIC: 163.07
Total gross pay: / 1,750.00 / Total deductions: / 382.14 / Net pay: 1,367.86
NI number:YT370249CTax code:647L
Calculation for Task 1.1 – Debjani Mukherjee – May 2010 gross to net payBasic pay / 3,850.00
Pension contribution for May 2010 / 3,850.00 x 6.5% = / 250.25
Cumulative gross pay to May 2010 / 1,750.00 + 3,850.00 = / 5,600.00
Less cumulative allowable deductions / 250.25
Gross taxable pay / 5,600.00 – 250.25 = / 5,349.75
Pay from previous employer / 1,963.46
Cumulative pay for tax purposes / 5,349.75+ 1,963.46 = / 7,313,21
Tax code used / 162L(1) / Tax basis / Cumulative
Adjustment for tax code / 271.50
Cumulative net taxable pay / 7,313.21 – 271.50 = / 7,041.71
Tax calculation
6,234.00 x 20% / 1,246.80
807.00 x 40% / 322.80
Tax due to May 2010 / 1,246.80 + 322.80 = / 1,569.60
Tax deducted in April 2010 / 242.00
Tax deducted by previous employer / 365.40
Tax due for May 2010 / 1,569.60 – 242.00– 365.40 = / 962.20
NICs calculation / NI table letter used / D
Employee’s contribution payable / 3,850.00 – 3,656.00 x 1% = / 1.94
3,656.00 – 3,337.00 x 11% = / 35.09
3,337.00 – 476.00 x 9.4% = / 268.93
64.00 x 1.6% = / (1.02)
304.94
Employer’s contribution payable / 3,850.00 – 3,337.00 x 12.8% = / 65.66
3,337.00 – 476.00 x 9.1% = / 260.35
64.00 x 3.7% = / (2.37)
323.64
Payslip for May 2010
Employee: Debjani Mukherjee / Date: 28 May 2010Payments
£ / Deductions
£ / Year to date
£
Basic pay: / 3,850.00 / Income tax: / 962.20 / Gross pay: 7,563.46
NIC: 304.94 / Pay for tax purposes: 7,313.21
Pension: 250.25 / Income tax: 1,569.60
Guide dogs: 150.00 / Employee’s NIC: 445.08
Student loan: 234.00 / Employer’s NIC: 486.71
Leisure club: 65.00 / Pension: 250.25
Guide dogs: 150.00
Student loan: 234.00
Leisure club: 65.00
Total gross pay: / 3,850.00 / Total deductions: / 1,966.39 / Net pay: 1,883.61
NI Number:YT370249CTax code: 162L
Task 1.2
(a)April’s total gross payroll cost
Pay elements:Salary218,914.87
Commissions 73,290.93
Expenses claimed 21,723.41
Statutory maternity pay 6,418.94
Statutory paternity pay 984.48
Statutory sick pay 854.82
Total322,187.45
Employer’s:NICs 38,321.94
Pension contributions 17,475.19
Gross cost377,984.58
(b)The total payment to be made to HMRC
Income tax 43,070.61
Student loan deductions 6,253.00
Net income tax value 49,323.61
Employees’ NIC 32,775.72
Employer’s NIC 38,321.94
SMP recovery (5,905.42)
SPP recovery ( 905.72)
Net NICvalue 64,286.52
Payment due for April113,610.13
Section 2
Task 2.1
(a)No
(b)It is a statutory deduction. Employee authority for deduction is not relevant.
(c)Any one of the following:
Stop notice
Employee leaves
Employee dies
ReachesState pension age
Task 2.2
(a)No
(b)Any one of the following:
Each employee must give their express written authority for the disclosure
Breaches the Data Protection Act
Not proper use of the data
(c)Send it to the Chief Executive and ask for confirmation.
Task 2.3
(a)No
(b)The list needs each employee’s signature.
(c)1. Statutory deduction
2. Contractual deduction
Task 2.4
(a)The employer needs to hold a valid certificate of election.
(b)C
(c)A
Task 2.5
(a)Employee without a Form P45.
(b)A general notice is issued which specifies a value to be addedto standard tax codes, such as L suffix codes and a date after which the increase is to be applied. Also accepted new emergency code
Task 2.6
(a)Any two of the following:
P45
P46
P46 (PEN)
P46 (EXPAT)
(b)Only those employers with less than 50 staff
(c) After the first salary payment is made to the employee
Task 2.7
(a)On or beforethe contractual pay day
(b)1. Gross pay
2. Itemised deductions (Not worried about word “itemised”)
3. Net pay
Task 2.8
(a)Voluntary
Statutory
Statutory
Voluntary
Voluntary
Statutory
(b)Any two of the following:
The payment must be made by the employer to an agency.
The agency must be approved by HMRC.
The payment must be made within the statutory deadlines.
Donation must not exceed gross pay.
Remitted to agency by 19th.
Task 2.9
(a)A code representing the NI record for the employee
(b)Employee
Task 2.10
(a)Take the reconciled number from past pay period, deduct all leavers and add new employees. Add any returning employees to the result and this should reconcile with the total number of payments made.
(b)1. See each employee personally at least once a year
2. Get employees to sign for their payslips
(c)Any two of the following:
Proper contracts of employment
Compatibility checks
Comparing with previous periods
Getting an independent check, sample testing
1