BLACK FRIDAY SALE 70% OFF QuickBooks for 3 months*   Ends 11/30

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.

Reply to message

View discussion in a popup

Replying to:
Kurt_M
Moderator

Reply to message

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.

Need to get in touch?

Contact us