Monthly Pension Payment Report Totals

We run a weekly payroll and therfore have weekly pension deductions. Payment to the pension provider has to be submitted on a monthly basis. It would be great to have a monthly report that shows the total monthly deductions for each employee so we know the pension liability to be paid over for that month. At the moment, each weekly report has to be manually added up, then manually entered at the pension providers portal. Time consuming if you have a lot of employees and entry mistakes could be easily made.