I found the best report for payroll by class is under the report tab click on employees and in the pop up box click More payroll reports in Excel then click on Payroll by Department/Class.  This report has a payroll by transaction class that will give you the info you need.