CYBER MONDAY SALE 70% OFF QuickBooks for 3 months*   Ends 12/5

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks. Explore QuickBooks Payroll

Reply to message

View discussion in a popup

Replying to:
Kevin_C
Moderator

Reply to message

Thanks for posting today, SS2024. I'm here to share additional steps to pull up the payroll data report from your QuickBooks Desktop (QBDT) account into Excel.

 

You can still find the reports under the Employees & Payroll menu if you have an active payroll subscription. I'd be glad to show you how:

 

  1. Go to the Reports menu, then Employees & Payroll
  2. Pick More Payroll Reports in Excel.
  3. Choose the type of report you want to generate.
  4. Enable Macros if prompted.
  5. Select the dates, then Get QuickBooks Data or Create Report.

 

Additionally, here's an article that lists the available Excel-based reports you can generate from QBDT and steps to create worksheets: Export reports as Excel workbooks in QuickBooks Desktop.

 

However, if you don't see these reports, can you please send a screenshot of what it looks like on your end? Also, what QBDT payroll subscription do you have?

 

Additionally, you can play around with the reports and use this link to learn more about how to personalize your data in QuickBooks: Customize reports in QuickBooks Desktop.

 

Don't hesitate to respond if you have more questions about exporting reports in QBDT. I'll be here to lend a helping hand. Have a great day!

Need to get in touch?

Contact us