cancel
Showing results for 
Search instead for 
Did you mean: 
jphenryjr
Level 2

Data Integration

Our tribal organization utilizes QuickBooks Enterprise Non-profit 20.0 R13P software and is in the process of working towards the data integration phase with a third party grants management tool. The basis of the core datasets will be stemming from the profit and loss by class reports. One of the sections of the report focuses on the salary and wages, payroll taxes, and worker's compensation expense. We used a third party tool, QXL, to export the data. The initial table tie in was to go from the Transaction table (EntityRefListID) to the Entity table (ListID) and to the Employee table (ListID). The last is from the Employee table (PayrollInfoClassRefListID) to the Class table (ListID). During payroll, when the employee is using the initial set up to a class, which is stored in the Employee table, the one-to-one connection provides the results I am looking for. However, it is only a partial result. There are instances during payroll where an employee can be assigned multiple Class designations. I have been looking for the proper table(s) that could provide insight to what the connections would be to account for multiple Class designations to an employee. Any assistance could be useful.

Solved
Best answer February 07, 2022

Best Answers
jphenryjr
Level 2

Data Integration

So, aside from the QuickBooks user end on associating multiple Class to an employee during payroll, I have stumbled across the answer through a third party tool, QXL. The QXL contains a stored procedure called CustomTxnDetail Report where I was able to include the column, Class, into the report, along with similar column fieldnames associated with the Transaction table. Aside from the QXL list of tables I exported, I had a difficult time in tracking the connection from the Transaction table to the Class table. Using the stored procedure CustomTxnDetail has allowed me to make those proper connections.

View solution in original post

5 Comments 5
AileneA
QuickBooks Team

Data Integration

Hello, jphenryjr.  

 

Allow me to provide with some information on how you can include multiple classes to an employee in QuickBooks. 

 

With QuickBooks Desktop, you can assign multiple classes once you've created a paycheck and add it in the paycheck details. Ensure you have set up your class tracking in Preferences.  

 

Here's how: 

 

  1. Go to Edit on the top menu.
  2. Choose Preferences.
  3. In the Preferences window, select Payroll & Employees in the list on the left.
  4. Tap the Company Preferences tab.
  5. In the Assign one class per section, select Entire paycheck or Earnings item.
  6. Press OK.

  

Now, you can assign classes for your payroll transactions. Here's how:

 

  1. Go to the Employees menu and select Employee Center.
  2. Double-click the name of the employee.
  3. Select Payroll Info and choose the Class.
  4. Click OK.
  5. Open the paycheck, click Paycheck Details, and assign a class.
  6. Press OK.

 

For more details about class tracking check out this article: Set up and use class tracking in QuickBooks Desktop

 

If you have any other questions, feel free to post here anytime. Thank you for your time and have a nice afternoon.  Stay safe!

jphenryjr
Level 2

Data Integration

I appreciate the approach from the software interface. However, my question pertains from the database perspective, more specifically on the tables themselves. Is there a table set up in QuickBooks that tracks the Class Tracking during payroll in the instance where an employee can have multiple Class designations?

Archie_B
QuickBooks Team

Data Integration

Thank you for following up, jphenryjr.

 

Let me share an idea on how you can assign multiple class for an employee in QuickBooks Desktop.

 

You can set up class for each earning item you assign for your employee. This way, you'll be able to track multiple classes for each employee.

 

Here's how:

 

  1. Go to Edit menu, then Preferences.
  2. Choose the Accounting icon. Then tap the Company Preferences tab.
  3. Tick to check the box for Use class tracking, then OK.
  4. Select Yes to save changes.
  5. In the Preferences window, select the Payroll & Employees icon, then Company Preferences tab.
  6. Be sure that Full payroll is selected in the QuickBooks Payroll Features section.
  7. Check the box for Job Costing, Class and Item tracking for paycheck expenses.
  8. Select Earnings item to assign one class to each item on the pay check.
  9. Once done, click on OK.

 

You should  be able to see the Class column in the Preview Paycheck window and assign one class for different earnings item. I've added this link for more information: Tracking payroll expenses by class, department, or location.

 

Check out this article to learn more about class tracking in QuickBooks Desktop: Set up and use class tracking in QuickBooks Desktop.

 

Don't hesitate post or comment for any follow up questions about class tracking. I'll be around if you need help. Have a good one!

jphenryjr
Level 2

Data Integration

So, aside from the QuickBooks user end on associating multiple Class to an employee during payroll, I have stumbled across the answer through a third party tool, QXL. The QXL contains a stored procedure called CustomTxnDetail Report where I was able to include the column, Class, into the report, along with similar column fieldnames associated with the Transaction table. Aside from the QXL list of tables I exported, I had a difficult time in tracking the connection from the Transaction table to the Class table. Using the stored procedure CustomTxnDetail has allowed me to make those proper connections.

AlcaeusF
Moderator

Data Integration

Hello @jphenryjr,

 

I have reviewed the solution you’ve shared and it's correct and accurate. Thank you for sharing your inputs to help address the issue.

 

We love to see members supporting one another! Have a great day.

Need to get in touch?

Contact us