Kurt_M
Moderator

Employees and payroll

I appreciate you joining the thread, David. I'll provide more details and visuals to help generate a payroll report by state inside QuickBooks Desktop (QBDT).

 

Running the Payroll Detail Review report and adding the Name State and State fields to the report can provide the information needed to see inside your company file. I'll outline the steps below to get you going:

 

  1. Access your QuickBooks Desktop company.
  2. Go to the Reports menu and click Employee & Payroll.
  3. Select Payroll Detail Review and then click the Customize button.
  4. In the Display section and then Columns field, enter Name state or State and then click on them. You can also add them both to ensure the accuracy.
  5. Once done, click the OK button.

 

For visual reference, see the screenshot below.

 

 

After customizing the report, you'll want to export it outside of the program so you can modify it and add those extra data needed. These are the steps:

  1. Access your QuickBooks Desktop company.
  2. Go to the Reports menu and then select Employee & Payroll.
  3. Choose Payroll Detail Review.
  4. In the Payroll Detail Review report, click the Excel beside the E-mail button.
  5. Select Create New Worksheet and then click the Export button.
  6. Choose where you want to save the file and then click the Save button.

 

If the issue persists, I recommend utilizing the Verify and Rebuild feature to help check for possible data issues and fix them inside the program. See this page for more details: Verify and Rebuild Data in QuickBooks Desktop.

 

In addition, here's an article to help you save your current report settings for future use inside the program: Create, access, and modify memorized reports.

 

I want to emphasize that I am consistently here to assist you with creating a report that displays payroll data by state or performing specific tasks in QuickBooks. I encourage you to visit the Community space or share your thoughts in the comments below.