Skip to main content

Payroll Reports ( UK )

Reports covering payroll activity, costs, leave, pensions, and tax compliance.


Payroll Reports

To access payroll reports:

1. Go to Reports > Payroll.

You can also access most of these from within a specific pay run by selecting Reports in the top-right corner.


Activity Tracking

Activity Details

Payroll information per employee for a particular pay run. Each statutory leave type paid gets its own column.


EOFY

P32

A breakdown of the amounts you've paid to HMRC for each tax month. Use this report at financial year end to reconcile what's been paid to HMRC.

To generate the P32 report:

  1. Choose the Financial Year.

  2. Choose the tax months, or All Tax Months.

  3. Click Generate, then export to CSV or PDF.

📝 Important to note: Only posted pay runs are included. The P32 also shows SMP, SPP and SAP recovered.


Leave & TOIL

Current Leave Balances and Liability Report

Current payroll leave and liability balances for employees.

Employee Leave Report

Leave balances at the start and end of a date range, plus the leave taken and accrued during that period.

💡 Tip: To see an employee's balance on a specific date, such as their leaving date, set that date as the end of the range. The Finishing Balance column shows the balance on that date. [Both reports have detailed columns in the existing Leave guide.]


Payroll

Earnings Attachment Summary Report

Shows earnings attachment orders, such as Attachment of Earnings Orders (AEOs) and Direct Earnings Attachments (DEAs), and the amounts deducted from employees' pay. The report covers one pay run at a time and shows the latest pay run by default.

Column

What it means

Employee Name

The employee the order applies to

Deduction Type

The deduction used for the order

Attachment Type

The type of order, for example AEO, CTAEO or DEA

Order Priority

The order's priority

Reference Number

The order reference number

Rate Type

How the deduction is calculated

Employee Net Pay

The employee's net pay for the period

Amount Deducted This Period

The amount deducted in this pay run

Admin Fee

Any admin fee deducted

Total Owed

The total amount owed under the order

Total Amount Deducted

The total deducted so far

Deduction Start Date / Deduction End Date

When the order starts and ends

Remaining Balance

The amount still to be deducted

💡 Tip: Council tax orders show as Attachment Earnings Order with a Rate Type of Fixed Council Tax Rate.

Employee Journal Detail

Breakdown of journal debits and credits by payslip line.

Note: This report doesn't include employee hourly rate adjustments or rounding, so it may not match exactly to the journal total.

Payment Summary by Location and Team

Payroll information grouped by location and team. There's one row per employee for each location or team they worked in, showing gross pay, taxable income, total tax and net pay.

Payroll Costs by Location

Payroll totals grouped by location and, optionally, team. Figures are added up across employees.

Column

What it means

Report Location

The employee's default location

Worked Location

The location where the hours were worked

Report Department / Worked Department

The default and worked team (shown when grouping by team)

Gross

Gross pay

Taxable Income

Taxable pay

Total Tax

Tax deducted

Net Pay

Net pay

Employer Pension / Employee Pension

Pension contributions

Employer NIC / Employee NIC

National Insurance contributions

💡 Tip: For one row per employee, use Payment Summary by Location and Team.

Timesheet vs Payslip Comparison

Use this report to check whether the cost of a payslip matches the cost expected from the timesheet. It covers both posted and unposted pay runs, so you can reconcile payroll before or after finalising a pay run.

Column

What it means

Name

Links to the employee's payroll profile

Pay Group

The employee's pay group

Pay Period

The start and end dates of the pay run, with a link to the pay run

Timesheet Cost

The total cost calculated from the timesheet's award interpretation

Payslip Cost

The total earnings on the posted payslip

Variance

The difference between the timesheet cost and payslip cost

A positive variance means the payslip cost is higher than expected from the timesheet. A negative variance means it's lower.

Common reasons for a variance:

  • Manual adjustments were made to the payslip after the timesheet was exported.

  • Earnings rates or award rules differ between the timesheet and payroll.

  • The employee has no timesheet for the period. Their timesheet cost shows as 0 and the variance is the full payslip cost.

    📝 Important to note: If a salaried employee has no timesheet for the period, the Timesheet cost column shows No timesheet values available and the Variance column shows User is salaried.


Pension

Auto Enrolment Status

Auto Enrolment status for all employees, showing AE worker category, pension status, assessment dates, and enrolment deadlines.

Pension Contributions

Pension contributions for each payslip.


Tax & Compliance

Benefits Summary

Per-employee summary of payrolled benefits.


FAQs

Why can't I see payroll reports?

To see payroll reports, your account must use Workforce Payroll and your role needs payroll access and the Payroll Reports permission. Admins and Payroll Officers have these by default.

To turn on the Payroll Reports permission:

  1. Go to Settings > All settings > Permissions.

  2. Scroll to Advanced and click Show Advanced Settings...

  3. Under Advanced Permissions, click Customise access & roles here. The Customise Permissions page opens in a new tab.

  4. Find the role and click View, then Edit role.

  5. In the Payroll section, turn on Payroll Reports, then save.

Where are P45s and P60s?

They're documents, not reports. Go to Payroll → Documents → P45s or P60s.

  • An employee appears under P45s once they've been paid at least once and have been deactivated, or have moved to another company file.

  • For P60s, click Actions → Bulk Generate P60s. Only generate P60s after the final pay run of the tax year. HMRC requires them to be given to employees by 31 May.

How do I see SSP or SMP?

There's no separate SSP or SMP report. Activity Details adds a column for each statutory leave type paid, such as Sick (Statutory). The P32 shows SMP, SPP and SAP recovered.

Why doesn't Employee Journal Detail match the journal total?

This report doesn't include hourly rate adjustments or rounding.

Why is a month missing from the P32?

The P32 only includes posted pay runs. Check that every pay run for that month has been posted.

Why is there an "Â" in my CSV?


Did this answer your question?