Skip to topic
    ← Back to course topics

    Composition of an employee payroll record — Institute of Accountants and Bookkeepers Vocational Accounting & Finance

    The IAB Level 2 Certificate in Computerised Payroll for Business covers the fundamental principles and legal requirements of payroll processing using computerised systems. It equips students with the skills to accurately calculate gross pay, deductions, and net pay, while ensuring compliance with HMRC regulations and real-time information (RTI) reporting.

    Composition of an employee payroll record explained

    This element explores the essential processes for constructing accurate employee payroll records, covering the collection of new starter information, completion of statutory deduction forms like the P11, and handling of income tax documentation.

    Read the full explanation

    It ensures learners can set up computerised payroll records in compliance with HMRC requirements and align employer data through RTI submissions, maintaining data integrity and legal adherence.

    Learning outcomes

    1. Identify the mandatory personal and tax information required to set up a payroll record for a new employee.
    2. Complete a P11 deduction sheet (or equivalent computerised record) accurately for a new employee using real-world data.
    3. Process relevant income tax forms (e.g., P45, Starter Checklist) to determine correct tax codes for new employees.
    Show all 5 objectives
    1. Demonstrate the procedure for submitting Full Payment Submission (FPS) and Employer Payment Summary (EPS) returns to align with HMRC records.
    2. Verify payroll data against HMRC online records to resolve discrepancies in employee information.

    Which command word is this?

    You must perform the necessary arithmetic to arrive at a numerical answer. Show all workings clearly and include units (e.g., £).

    Composition of an employee payroll record assessment help

    Topic Overview

    Computerised payroll is a critical function in any business, ensuring that employees are paid accurately and on time while complying with UK tax laws. The IAB Level 2 Certificate in Computerised Payroll for Business introduces students to the principles of payroll processing using popular software such as Sage Payroll or QuickBooks. This qualification covers the entire payroll cycle, from setting up employee records to calculating statutory payments and submitting reports to HMRC.

    The course emphasises the importance of accuracy and legal compliance. Students learn how to calculate gross pay, including overtime and bonuses, and how to deduct income tax and National Insurance contributions correctly. They also explore voluntary deductions such as pension contributions and student loan repayments. A key component is understanding Real Time Information (RTI), which requires employers to report payroll data to HMRC on or before each payday.

    Mastering computerised payroll is not just about using software; it requires a solid understanding of payroll legislation and the ability to apply it in practical scenarios. This qualification is ideal for those seeking a career in payroll administration or bookkeeping, as it provides the skills needed to manage payroll efficiently and avoid costly errors. By the end of the course, students will be confident in producing payslips, maintaining payroll records, and handling year-end procedures.

    Key Concepts
    • →Gross pay: total earnings before deductions, including basic pay, overtime, bonuses, and commission.
    • →Statutory deductions: income tax (PAYE) and National Insurance contributions, calculated based on tax codes and thresholds.
    • →Voluntary deductions: pension contributions, student loan repayments, and other employee-authorised deductions.
    • →Real Time Information (RTI): mandatory electronic submission of payroll data to HMRC on or before each payday.
    • →Payslips: legal requirement to provide employees with a detailed breakdown of their pay and deductions.
    Assessment Criteria
    • Award credit for accurately extracting and inputting new employee details (name, address, NI number, date of birth) into the payroll system.
    • Credit should be given for correctly calculating tax code from P45 or Starter Checklist and applying cumulative/non-cumulative basis.
    • Look for evidence of completing a P11 deduction sheet with correct pay, deductions, and year-to-date figures.
    • Assess ability to identify and correct mismatches between employer-held employee data and HMRC records via RTI reconciliation.
    Assessment Guidance
    • 💡Always cross-reference employee details with original documents (e.g., passport, P45) before setting up the record to avoid HMRC submission errors.
    • 💡Practice using HMRC basic PAYE tools or software to simulate RTI submissions and understand common error messages.
    • 💡Show all workings, especially when apportioning tax allowances or calculating NICs for mid-year starters, as partial credit is often awarded.
    • 💡Always show your workings in calculations. Even if the final answer is wrong, you can gain method marks for correct steps.
    • 💡Use the current tax year's rates and thresholds. The exam will specify the tax year, so ensure you are familiar with the latest figures.
    • 💡Read the question carefully to identify whether it asks for monthly, weekly, or annual figures. Convert amounts correctly to avoid errors.
    Common Mistakes
    • Confusing the use of emergency tax codes versus correct tax codes when a P45 is unavailable.
    • Incorrectly calculating year-to-date (YTD) figures on P11 sheets for a new employee with previous employment.
    • Failing to update HMRC with employee changes, leading to misalignment of data between employer and HMRC.
    • Misconception: Net pay is the amount before deductions. Correction: Net pay is the final amount after all deductions have been subtracted from gross pay.
    • Misconception: All employees pay the same rate of National Insurance. Correction: NI rates vary depending on earnings and employment status (e.g., employee vs. self-employed).
    • Misconception: Tax codes are the same for everyone. Correction: Tax codes are personal and depend on an individual's tax-free allowance, which can be affected by benefits, multiple jobs, or underpaid tax from previous years.
    Revision Plan
    1. 1Week 1: Focus on understanding the payroll cycle and key terminology. Review the legal requirements for payroll, including RTI and payslips.
    2. 2Week 2: Practice calculating gross pay, income tax, and National Insurance using sample data. Use the HMRC tax tables or online calculators to verify your answers.
    3. 3Week 3: Explore voluntary deductions and how to record them. Work through case studies involving pension contributions and student loans.
    4. 4Week 4: Familiarise yourself with payroll software by completing practical exercises. Practice entering employee data, processing payroll, and generating reports.
    5. 5Week 5: Review past exam questions and attempt mock exams. Focus on time management and accuracy in calculations.
    Exam Question Types
    • 📋Multiple-choice questions testing knowledge of payroll definitions and legal requirements.
    • 📋Calculation questions requiring you to compute gross pay, deductions, and net pay for a given employee.
    • 📋Scenario-based questions where you must identify errors in a payslip or payroll process.
    • 📋Short-answer questions explaining concepts such as RTI or tax codes.
    Command Word Expectations (INSTITUTE OF ACCOUNTANTS AND BOOKKEEPERS)
    Calculate

    You must perform the necessary arithmetic to arrive at a numerical answer. Show all workings clearly and include units (e.g., £).

    Explain

    Provide a detailed account of a concept or process, including reasons and implications. Use correct terminology and give examples where appropriate.

    Identify

    State the key points or items from a given scenario or data. Be concise and accurate, listing all relevant factors.

    How Students Lose Marks (Examiner Pitfalls)
    Pitfall: Students often confuse gross pay with net pay and incorrectly calculate deductions such as income tax and National Insurance, leading to errors in the final net pay figure.
    ❌ Weak Answer (Loses Marks):Gross pay is the amount the employee takes home, and net pay is the total before deductions.
    Example improved answer:Gross pay is the total amount earned by an employee before any deductions are made, including basic pay, overtime, and bonuses. Net pay is the amount the employee actually receives after all statutory and voluntary deductions, such as income tax, National Insurance contributions, and pension contributions, have been subtracted.
    Examiner Tip: Always start by identifying gross pay from the employee's hours and pay rate, then subtract each deduction in the correct order to arrive at net pay. Use the tax code and National Insurance category correctly.
    Pitfall: Students often fail to apply the correct income tax code or misunderstand how tax codes affect the calculation of taxable pay, leading to incorrect tax deductions.
    ❌ Weak Answer (Loses Marks):The tax code is just a number and doesn't affect the calculation.
    Example improved answer:The tax code determines the amount of tax-free pay an employee is entitled to in a tax year. For example, a tax code of 1257L means the employee can earn £12,570 tax-free. To calculate taxable pay, subtract the tax-free allowance from gross pay, then apply the appropriate tax rate (basic, higher, or additional) to the taxable amount.
    Examiner Tip: Always check the tax code on the employee's P45 or new starter checklist. Use the current tax year's rates and thresholds. Remember that tax codes can be cumulative or non-cumulative, which affects how tax is calculated each pay period.
    Step-by-Step Worked Solutions

    Question: An employee works 40 hours per week at a rate of £12.50 per hour. They have a tax code of 1257L and are in National Insurance category A. Calculate their gross pay, income tax, National Insurance, and net pay for the month (assuming 4 weeks in the month). Use the current tax year rates: income tax basic rate 20%, National Insurance employee rate 12% on earnings above £1,048 per month.

    1. 1.Step 1: Calculate gross pay: 40 hours × £12.50 = £500 per week. Monthly gross pay = £500 × 4 = £2,000.
    2. 2.Step 2: Calculate income tax: Annual tax-free allowance = £12,570, so monthly tax-free amount = £12,570 ÷ 12 = £1,047.50. Taxable pay = £2,000 - £1,047.50 = £952.50. Income tax = 20% × £952.50 = £190.50.
    3. 3.Step 3: Calculate National Insurance: Earnings above £1,048 per month are subject to 12%. NI = 12% × (£2,000 - £1,048) = 12% × £952 = £114.24.
    4. 4.Step 4: Calculate net pay: Net pay = Gross pay - Income tax - NI = £2,000 - £190.50 - £114.24 = £1,695.26.
    Final Answer: Gross pay: £2,000; Income tax: £190.50; National Insurance: £114.24; Net pay: £1,695.26.

    Question: Explain the purpose of Real Time Information (RTI) and describe the information that must be submitted to HMRC on or before the employee's pay date.

    1. 1.Step 1: Define RTI: RTI is a system introduced by HMRC that requires employers to report payroll information to HMRC on or before each payday, rather than annually.
    2. 2.Step 2: Identify the key information: This includes employee details (name, address, National Insurance number), pay details (gross pay, taxable pay, deductions), and the employer's details (PAYE reference).
    3. 3.Step 3: Explain the purpose: RTI helps HMRC to track tax and National Insurance contributions in real time, ensuring that employees' tax codes are accurate and that benefits and tax credits are calculated correctly.
    4. 4.Step 4: State the deadline: The submission must be made on or before the pay date, and a late submission can result in penalties.
    Final Answer: RTI requires employers to submit payroll data to HMRC on or before each payday, including employee and pay details, to ensure accurate tax and benefit calculations.
    Active Recall Memory Test
    What is the difference between gross pay and net pay?
    Key Fact: Gross pay is the total earnings before deductions, while net pay is the amount received after all deductions.
    What does RTI stand for and what is its purpose?
    Key Fact: RTI stands for Real Time Information, a system that requires employers to report payroll data to HMRC on or before each payday.
    How is income tax calculated using a tax code?
    Key Fact: The tax code determines the tax-free allowance. Subtract this from gross pay to get taxable pay, then apply the appropriate tax rate.
    Name three types of voluntary deductions.
    Key Fact: Pension contributions, student loan repayments, and charitable donations.
    Frequently Asked Questions
    What is the difference between PAYE and RTI?
    PAYE (Pay As You Earn) is the system for deducting income tax and National Insurance from employees' pay. RTI is a reporting mechanism that requires employers to submit payroll data to HMRC in real time, on or before each payday. RTI is part of the PAYE system, ensuring HMRC has up-to-date information.
    How do I calculate National Insurance contributions?
    National Insurance is calculated based on an employee's earnings above a certain threshold. For most employees (Category A), the rate is 12% on earnings between the primary threshold and the upper earnings limit, and 2% on earnings above the upper limit. The thresholds change annually, so always use the current rates.
    What is a tax code and how does it affect my pay?
    A tax code tells your employer how much tax-free pay you are entitled to in a tax year. For example, 1257L means you can earn £12,570 before paying tax. Your tax code can change if your circumstances change, such as starting a new job or receiving benefits.
    Do I need to provide payslips to employees?
    Yes, it is a legal requirement to provide a payslip to every employee on or before their payday. The payslip must show gross pay, net pay, and all deductions, including tax, National Insurance, and any voluntary deductions.
    What happens if I make a mistake in payroll?
    If you make a mistake, you should correct it as soon as possible. If it affects an employee's pay, you may need to adjust the next payroll run. For tax and NI errors, you may need to submit a correction to HMRC. It's important to keep accurate records and double-check calculations to avoid penalties.
    Can I use any payroll software for the IAB exam?
    The IAB exam is computer-based and may use a specific payroll software package. It is essential to practise with the software you will be assessed on. The course usually includes training on a particular package, such as Sage Payroll, so ensure you are familiar with its features.
    Unit assessment details

    Loading assessment details…