Payroll Reports Overview (Payroll UK)

Report Name

Description

Accrued Leave Balance

Reports leave accrual and entitlement balances by leave type and payee. The report shows the following information for each leave type that is included on the report:

• payee details (name, payee and candidate numbers, agency office, pay group, employment type)

• accrual balance

• entitlement balance

• type of value accrued (hours or wages)

• combined cost of accrual and entitlement balance (not applicable to leave types with an apply to type of days or those leave types that accrue a fixed number of hours or days)

• average rate of accrual (not applicable to leave types with an apply to type of Days or Wages and leave types with an accrual type of Percentage or Bank)

• year in which the leave entitlement must be taken (if applicable)

• job order and client details (if the accrual is attributable to a specific job).

Distribution of Funds

Reports on the earning and deduction amounts that need to be paid into various accounts as a result of processing one or more pay batches.

Multi Currency Distribution of Funds

Reports on the earning and deduction amounts that need to be paid into various accounts as a result of processing one or more pay batches for the payment methods of SEPA or International. It will also show the converted currency value and currency exchange rate used.

VAT

Reports on payees who are registered for VAT and the VAT liability for each of those payees.

Payee Payroll – By Client

Reports the gross and net pay of payees who were paid in one or more pay batches. 
Gross and net pay is broken down by pay code and client.

Payee Payroll - Detailed

Reports the gross pay, gross deductions, net pay and net deductions of payees paid in one or more pay batches. 
Gross and net pay is broken down by pay code, quantity and rate.

Gross to Net - By Pay Period

Reports a summed value of the gross pay, gross deductions, statutory payments, statutory deductions, net deductions, net pay, statutory employer costs within the pay batch range entered within a pay frequency for the pay period.

Gross to Net - By Pay Batch

Reports the gross pay, gross deductions, statutory payments, statutory deductions, net deductions, net pay, statutory employer costs in one or more pay batches.

Reimbursement

Reports reimbursements paid to payees in one or more pay batches, broken down by payee, batch number and reimbursement pay code.

If multi currency has been enabled, the values will be broken down by currency if there is more than 1 currency for a reimbursement of the same name.

Deductions

Reports on deductions withheld from payees' earnings in one or more pay batches including:

• the type of deductions applied

• if the deductions applied to gross or net earnings

• the monetary value of the deductions.

New Payees

Reports on payees who have commenced employment within a given period to ensure that the information required to process payees' pay is available in the system and that the information has been entered into the system correctly. 

Note

Icon

A Payee record can have multiple sets of payee details, whereby only one set of payee details is valid at any given time. Where a Payee record referenced by the report has multiple sets of payee details that are valid throughout the reporting period, the report will reference the set of payee  details that are valid on the date that the report is run. This is because that will be the only set of payee details that can be updated on the Payee record if any information is missing or incorrect.

This report is not available for reporting at the Review stage of the pay batch process.

Payment Method

Reports on the payment method applicable to payees within a pay batch and allows payroll staff to identify which payees must be issued cash or cheque. 
A payee's payment method maybe reported as BACS, Cash, Cheque or Balancing Payment. Where the payment method for a payee is Balancing Payment, this indicates that the payee was not actually paid in the corresponding pay batch but the payee was processed in a pay batch to adjust their pay data in the system.

If multi currency has been enabled, payment method SEPA/International columns will be displayed.

CIS - Payee

Reports those payees who have the tax type CIS. This report outputs the latest tax treatment and verification number.

This report is not available for reporting at the Review stage of the pay batch process.

CIS - CIS300

This report is to replicate the layout and validation imposed by the HMRC if the CIS300 was to be submitted electronically.

It reports the total gross (includes materials reimbursement payment), materials and tax deducted for each CIS tax type within the given Agency UTR number and Accounts Office Reference combination.

If the total value of the Materials or Total Amount Deducted for the given tax month is less than zero because adjustments have been made, the value that will be output is zero. This is because the HMRC does not accept values of less than zero. If an adjustment was made that related to a previous reporting period, it will be necessary to contact the HMRC directly to advise of the adjustment.

This report is not available for reporting at the Review stage of the pay batch process.

Negative Pay

Reports on payees who had a negative pay total in one or more pay batches.

Payee - Pension Contribution Report

Reports on payees who have had a pension/AVC or an employer pension contribution in one or more pay batches.

Pension Auto Enrolment Qualifying Earnings Report

Reports on payees qualifying earnings and age as at the time of the pay batch to ascertain if the payee should be auto enrolled into a pension scheme.

SSP

Reports on the SSP waiting days, SSP days and amount of SSP paid to a payee.

Statutory Pay and Deductions

Reports on the Taxable/NIable pay and statutory pay/deductions per payee per pay period. Where multiple pay batches have been processed for the same pay period, these will be summed for the pay period.

Statutory Pay and Deductions Summary YTD

Reports on the total Taxable/NIable pay and statutory pay/deductions per payee per tax year.

Terminated Payees

Reports on the payees who have been terminated in a pay batch and whether they have received a payment after leaving.

Unpaid leave report

Reports on where leave has been processed in the pay batch but has not been paid due to qualifying conditions not being met.

Calculation Report

Available from 11.44 Patch 1. A report that is available in the pay batch process only to output warnings and errors relating to conditions occurring in the payroll. An example of the types of warnings that are output onto the report are where a full AEO deduction could not be taken due to the net protected earnings being exceeded.