Creating an Employee Payroll Record

I need a payroll report for each employee that includes the period August 25, 2022 through August 25, 2023.  I need this for one my clients for their annual workman's comp insurance payroll audit.  Any one know how to do this without having to generate numerous Excel files for each employee and then "cobbling" together the worksheets for two separate years

Ted Watkins