cancel
Showing results for 
Search instead for 
Did you mean: 
AbbyHCU
Level 3

Sort employees per branch/department

Is there a way I can sort employees I pay per branch/department so I know how much in SS and Medicare tax those employees in each branch were paid?  I would also like to sort our 401K company match per branch too.

1 Comment 1
Angelyn_T
QuickBooks Team

Sort employees per branch/department

Hi there, Abby.

 

Yes, you can sort your employees per branch/department. I'm here to guide you on how.

 

If you had added a custom field for branch/department, you may open two reports to sort your employees with their taxes or contributions.

 

Here's how:

 

  1. Open your QuickBooks Desktop, then go to the Reports tab.
  2. Click on Employees & Payroll, then open the report that displays your employees' contributions/deductions (Payroll Transaction Detail, Payroll Item Detail).
  3. Review the information from there.
  4. After that, open the Employee Contact List report from the Employees & Payroll.
  5. Add the Department field/column from the Customize Report window.

 

Once done, export both reports to Excel and customize the data from there.

 

For more tips about managing reports in QuickBooks Desktop, you can also open this link: Understand reports.

 

Moreover, here's how you can create and use custom fields in QuickBooks Desktop.

 

If you have any other questions about sorting your employees in QuickBooks, please let me know by adding a comment below. I'm always here to help. Have a good one!

Need to get in touch?

Contact us