How do I run the Employee 52 Weekly Average Report?

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

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. 

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.

 

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

---

Bespoke report

There may be cases where you need a 52-week average where you didn't pay employees in some periods. The report included in your software can't do this as it always divides by 52.

To get a report that calculates this correctly, you can submit a Report Design Request. This option is only available for weekly pay frequency.

 NOTE: If you set up payroll mid year by entering year to date values, the bespoke report isn't an option. This is because the report requires processing history to calculate from. 

For more information, visit the additional reports, and the Report Design Service article.

---