How do I run the Employee 52 Weekly Average Report?

Summary

How to run the Employee 52 Weekly Average Report in Sage 50 Payroll.

Description

Use this report to check your employees' average weekly hours and average weekly pay over a 52-week period.

 NOTE: This report can be useful if you're calculating employee holidays. However, if you're unsure how to do this, contact ACAS for advice. 

Resolution

To run the report:

  1. Select the relevant employees.
  2. Click Reports, then Employee.
  3. Find and select the Employee 52 Weekly Average Report.
  4. Click Preview or Print as required.
  5. In the Criteria window, enter the starting point of the 52-week period in the Processing date box.
  6. Click the blank dropdown box to the right of Payment ref.
  7. Select the payments to include on this list.
    TIP: The report includes all payments if you make no selections on this list.
  8. Click OK.

Image

 

CAUTION: The calculation built into this report always divides by 52. 

In the Sage 50 Payroll - Advanced Report Library, Sage Cover Extra and higher include two reports that help you calculate average pay and holiday pay:

  • Average Hours Worked and Amounts Paid Excluding Statutory Pay – Summary
  • Average Hours Worked and Amounts Paid Excluding Statutory Pay – Detailed

You can run these reports for weekly paid employees over a 104-week period. They show the total amount paid, total hours worked, and average pay per pay date based on the pay elements you select.

These reports provide guidance only. You are responsible for checking the accuracy of the information and making any decisions based on the report data.

 

Upgrade your licence

Growing business? Add more companies, users, or employees to your licence with ease. Leave your details and we’ll be in touch.

Image

 

 




Solution Properties

Solution ID
221006103727543
Last Modified Date
Mon Jun 22 10:51:09 UTC 2026
Views
0