Hi there, Lisalu.
I appreciate you coming back to the thread and adding extra details about your concern. With this, I'll ensure you'll be able to get a report that appears what you need by following the steps below.
There are several Excel reports available in QuickBooks to show all payroll data. That said, I recommend running the Summarize Payroll Data in Excel report. This contains Pay Type for earnings items, such as Regular and Overtime, Sick, and Vacation. Also, the pay period with the breakdown of hours, overtime, etc.
- Under Reports from the QuickBooks menu, choose Employees & Payroll. Then, select Summarize Payroll Data in Excel.
- If prompted by the Excel security warning, follow the directions to enable macros in Excel.
- From the QuickBooks Payroll Workbook - Welcome screen, choose OK.
- Enter a date range and select Get QuickBooks Data.
- Choose the State Wage Listing tab at the bottom. Then, you can now see the data you need.
Furthermore, you can open this article to see additional information about the report: Excel based payroll reports.
Lastly, you may refer to this article to see steps on how you can customize any report in QBDT to personalize the font and style of the page: Customize reports in QuickBooks Desktop.
Please get back to the thread if you need anything else about Reports. I'll be more than happy to help you, Lisalu. Have a great day!
