Welcome to the Community! QuickBooks offers a variety of reports that help you bring your finances into perspective. I'll be happy to help so you're on the right track with completing your work with ease.
Based on what you've described, I recommend running the Payroll Tax and Wage Summary report. This report displays the total subject wages, excess wages, and taxable wages by tax type. You can learn more about customizing this report by checking out this helpful article here.
I also encourage you to explore some of the other payroll reports here: Run payroll reports. Let me know if this info helps by leaving a comment below.
I'll be a message away in case you need additional support.