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 |
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. |
Payee Payroll - Detailed | Reports the gross pay, gross deductions, net pay and net deductions of payees paid in one or more pay batches. |
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. |
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:
|
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. 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. |