Sage 50 Payroll - Advanced Report Library

Pre-update Gross to Net (Excel format)

This report shows one line per employee and displays a detailed breakdown of all the main and custom elements of pay for the current period. Including up to 30 individual payments and deductions. Run the report using the Report to Excel option. This report uses custom report settings to choose which individual payment and deduction elements appear on your report. Here's a video on youtube.com for more help on custom report settings. 

BACS Pay Transfer Report with Totals by BACS Ref

Net pay and bank details for the employee's first bank account. Employees must have a current un-updated value to be paid to their first bank account.

BACS Pay Transfer Report with Totals by Surname

Net pay and bank details for the employee's first bank account. Employees must have a current un-updated value to be paid to their first bank account.

Cost Centre Payment Summary (Part 1) Landscape

A detailed breakdown of pay for the current period from gross to net, by cost centre. Includes totals per cost centre.

Cost Centre Payment Summary (Part 2) Landscape

A detailed breakdown of employer's and employee's NI contributions for the current period, by cost centre. Includes totals per cost centre.

Cost Centre Payment Summary Part 1 & Part 2 (Excel)

Cost Centre Payments report combining Part 1 and Part 2 reports, for export to Excel.

Department Analysis of Payroll Totals

Full company totals for the current un-updated payroll run, by the Department.

Departmental Payment Summary (Part 1) Landscape

A detailed breakdown of pay for the current period from gross to net, by department. Also it includes the total per department.

Departmental Payment Summary (Part 2) Landscape

A detailed breakdown of employer's and employee's NI contributions for the current period, by department. Also it includes the total per department.

Department Payment Summary Part 1 & Part 2 (Excel)

Department Payments report combining Part 1 and Part 2 reports, for export to Excel.

Dot Matrix (1 per 4in. page) inc 4 Attachments

Standard payslip layout for dot matrix printers, including 4 attachments.

Dot Matrix (1 per 4in. page) with Loans by Surname

Standard payslip layout for dot matrix printers, including loan information and sorted by employee surname.

Dot Matrix (1 per 6in. page) with Address by Surname

Standard payslip plus format payslip, including name and address sorted by employee surname.

Laser (2 per A4 sheet) with 4 attachments

Standard laser payslip, two per A4 sheet including 4 attachments.

Laser (2 per A4 sheet) with Address, sorted by Surname

Standard laser payslip plus format, two per A4 sheet. Includes name and address and sorted by employee surname.

Laser (2 per A4 sheet) with Loans, sorted by Surname

Standard laser payslip, two per A4 sheet. Includes loan information and sorted by employee surname.

Payment Summary (Part 1) Inc Holiday Fund and Loans, by Surname

Detailed breakdown of current period pay from gross to net, including holiday fund and loans, sorted by employee surname.

Payment Summary (Part 1) Inc Holiday Fund and Loans. (ER NIC copy) by Surname

Detailed breakdown of current period pay from gross to net, including holiday fund and loans, by surname. With employer NIC included for RTI reconciliation and cash rounding removed.

Payment Summary (Part 1) Landscape by Surname

Detailed breakdown of current period pay from gross to net, sorted by employee surname and including totals per payment period.

Payment Summary (Part 1) Portrait by Surname

Detailed breakdown of current period pay from gross to net, sorted by employee surname and including totals per payment period.

Payment Summary Part 2 Landscape (inc. Gross for NIC)

Detailed breakdown of employer's and employee's NI contributions for the current period. The report includes totals per payment period, including Gross for NIC for Apprenticeship Levy.

Payment Summary (Part 2) Landscape by Surname

Detailed breakdown of employer's and employee's NI contributions for the current period, sorted by employee surname. The report includes totals per payment period.

Payment Summary (Part 2) Portrait by Surname

Detailed breakdown of employer's and employee's NI contributions for the current period, sorted by employee surname. The report includes totals per payment period.

12 Week Averages with Payment Selection

Calculates the employee's weekly average, based on the chosen start date and for the selected payment references, for 12 weeks.

52 Week Averages with Payment Selection

Calculates the employee's weekly average, based on the chosen start date and for the selected payment references, for 52 weeks.

Attachment History By Employee

A breakdown of attachments by employee, by process date, for the period selected.

Average Hours & Amounts - Payment Selection

Employee average hours and amounts for selected payments.

Cost Centre - Average Hours & Amounts - Payment Selection

A breakdown by cost centre and employee of the average hours and amounts for selected payments.

Cost Centre Deduction Type History (Detailed)

By cost centre and employee, a breakdown of deductions made along with hours, rate and total value, for each process date within the selected period. Includes totals per cost centre and grand report total.

Cost Centre Employee History Report (Detailed)

By cost centre for each employee, a breakdown of each updated period showing process date, gross, employer and employee NIC, tax paid and final net pay.

Cost Centre Employee History Report (Summary)

By cost centre for each employee, a total for the period selected, showing gross, employer and employee NIC, tax paid and final net pay.

Cost Centre Payment Summary (Part 3) Portrait

By cost centre for each employee, year to date gross to net values. Includes totals per cost centre and grand report total.

Cost Centre Payment Summary History Part 1 - By Date

Gross to net figures per employee, by cost centre and process date.

Cost Centre Payment Summary History Part 2 - By Date

NI information per employee, by cost centre and process date.

Cost Centre Payment Type History (Detailed)

By cost centre and employee, a breakdown of payments made along with hours, rate and total value, for each process date within the selected period. Includes totals per cost centre and grand report total.

Cost Centre Payroll Analysis - History By Date

A summary of payments by date and cost centre.

Cost Centre Payroll Analysis by Date

A summary of the total hours and amounts for selected payments, by date and cost centre.

Deduction Type History (Summary)

A breakdown of deductions summarised for the period selected.

Deduction Type History By Employee (Detailed)

A breakdown of deductions per employee for each process date within the selected period.

Deduction Type History by Employee (Summary)

A breakdown of deductions per employee summarised for the period selected.

Department Deduction Type History (Detailed)

By department and employee, a breakdown of deductions made along with hours, rate and total value, for each process date within the selected period. Includes totals per department and grand report total.

Department Employee History Report (Detailed)

By department for each employee, a breakdown of each updated period showing process date, gross, employer and employee NIC, tax paid and final net pay.

Department Employee History Report (Summary)

By department for each employee, a total for the period selected, showing gross, employer and employee NIC, tax paid and final net pay.

Department Payment Summary History Part 1 - By Date

By department and process date, the gross to net figures per employee.

Department Payment Summary History Part 1 - By Employee

By department and employee, the updated gross to net values for each process date.

Department Payment Summary History Part 2 - By Employee

By department and employee, the NI and pension values for each process date.

Department Payment Type History (Detailed)

By department and employee, a breakdown of payments made along with hours, rate and total value, for each process date within the selected period. Includes totals per department and grand report total.

Departmental - Average Hours & Amounts - Payment Selection

Average hours and amounts paid by department.

Departmental Payment Analysis By Date

A breakdown of payments by date and department, payment totals only.

Departmental Payment Summary (Part 3) Portrait

By department for each employee, year to date gross to net values. Includes totals per department and grand report total.

Departmental Payroll Analysis by Date

A summary by date and department of the total hours and amounts for selected payments.

Employee Details - Emergency Contact

Employee emergency contact details.

Employee Details - Pension Schemes

By employee, each pension scheme set up for the employee showing employer/ee contributions, percentage or amount. To appear on the report the employee must have a pension scheme.

Employee Details - Personal (Excel)

Employee record details, for export to Excel.

Employee Details - Right to Work

Employee details are noted under the right to work.

Employee Personal Details inc RTI ID

Personal details from each employee record, including name and address, date of birth, marital status and RTI ID.

Employee Post-Graduate Loan Deductions TD

Shows employee post-graduate loan details and amount deducted for the current year to date

Employee Student Loan Deductions TD

Shows employee student loan details and amount deducted for the current year to date

Employee Upcoming Birthdays

Upcoming employee birthdays in date order.

Hours Statistics Gender Report

A breakdown of hours worked, by process date and by gender, showing hours worked over and under 30 hours.

Hours Statistics Gender Report - Inc Averages

A breakdown of hours worked, by process date and by gender, showing hours worked over and under 30 hours and including averages.

Monthly Employee Numbers

A breakdown by month of the number of employees in the company.

Monthly Employee Numbers by Department

A breakdown by department and month of the number of employees in the company.

Online Documents Employee Email Addresses

A list of Employees and the Online Documents email address entered on their record.

Payment Summary History Part 2 - By Date (inc. Gross for NIC)

A detailed breakdown by process date, NI and pension values for each employee, including Gross for NIC for Apprenticeship Levy.

Payment Type History (Summary)

A summary of each payment type, for the date period selected.

Payment Type History (Detailed) NIC Payments Only

By employee, a breakdown of payments eligible for NIC, along with hours, rate and total value, for each process date in the selected period.

Payment Type History By Employee (Detailed)

A breakdown of payments per employee for each process date in the selected period.

Payment Type History by Employee (Summary)

A summary of each payment type, per employee, for the date period selected.

RTI Employee Details Verification (Inc Email Address)

Send this letter to your employees to check that personal details are up to date for RTI. It also Includes an email address.