Payroll Reports Overview (Payroll UK)

The Portal > Pay module provides a number of reports that allow payroll staff to report on payroll related information. These reports can be run independently of the pay batch process to report on payroll related data across pay batches and pay periods or they can be run at the Review stage of the pay batch process, prior to closing a pay batch, thereby allowing you to report on payments that will be made in that pay batch. For more information, see How to Run a Payroll Report.
The following payroll reports are available:

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). This report references leave transactions that are pay batch based only. For example, the leave entitlement balance for a given leave type will only be inclusive of leave that accrued and was transferred into entitlement because of processing a pay batch. Leave can also be configured such that the accrual, transfer of accrual into entitlement and the resetting of entitlement balances can be triggered by the Leave Service. Such transactions are not factored into the amounts shown on this report. A version of this report is also available in the Leave module and that version of the report is inclusive of pay batch and Leave Service based transactions.
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.