cancel
Showing results for 
Search instead for 
Did you mean: 
AmandaV2
Level 1

Quickbooks time and Accounting entries

Can someone please help with a question regarding the accounting behind the QB Time sync to QB Desktop?  Our employees today clock into a customer, then a service item.  I want to maintain the way they are clocking in as we want that data available for analysis.  However, my problem comes in with the accounting side of this.  I am trying to change our accounting standards to absorb at a standard labor and OH rate and right now, what comes through on the customer side is the actual cost of the employees payroll/taxes, etc.

 

There are two options to fix this, but I don't know how to make either of them happen.

 

1) Preferred option: When syncing to QB Desktop, time and payroll cost does not go to the customer, only to the assigned class.  Then we would do a month-end entry to do the absorption of labor overall to WIP.  Cost would go to the customer when we release from WIP to CGS.  

 

2) Absorb labor to the customer through the sync at the labor/Overhead rate combined instead of at the actual cost of the employee.  This feels like it will be more complex and potentially create other issues, but open to suggestions.

 

We are in the Contractor addition but are kind of a mixed business between contracting and manufacturing.  I am trying to deal with the manufacturing part of the business with this issue.

 

Thanks for any advice.

4 Comments 4
IrishNinoJ
QuickBooks Team

Quickbooks time and Accounting entries

I can suggest steps to make your preferred option achievable, AmandaV2.

 

In QuickBooks Time, you can assign pay rates to classes instead of customers if you want time and payroll costs to not go to the customer. 

 

  1. In QuickBooks Time, select the QuickBooks dropdown, then Preferences.
  2. Select Payroll Item Mapping Tool.
  3. Select the Map Customer (or Map Service Item) tab. 
  4. Place a checkmark for ALLOW OVERRIDES BY: drop-down list.
  5. Select Class.

 

Furthermore, you can check out this article to answer the most frequently asked questions about QuickBooks Time and QuickBooks Desktop integration: QuickBooks Time and QuickBooks Desktop Integration FAQs. It includes topics about integrating using the Web Connector and Windows.

 

I'll keep an eye out for your reply. If you have further questions besides QuickBooks Time, feel free to include them in the comments. We're here to assist you 24/7.

AmandaV2
Level 1

Quickbooks time and Accounting entries

Thank you for the response!  This seems to make sense and I just made the change.  We'll run payroll in the next few days and I'll be able to see if it worked how I was hoping.  If not, I'll reach out again.  

AmandaV2
Level 1

Quickbooks time and Accounting entries

Sorry for delay in responding as I had to wait for payroll to run and then was out for a few days.

 

I made these changes, but it doesn't appear to have done anything different in QB Desktop.  As a reminder, I want employees to clock to a customer/job in QB time, but NOT have those customer entries carry over into QB Desktop.  I want reports available to pull on customer detail in QB Time, but having the payroll data going into the customer in QB Desktop is duplicating an absorption entry I am doing manually.

 

Any further ideas?

Ivan_G
QuickBooks Team

Quickbooks time and Accounting entries

Thanks for the update and for posting your follow-up concerns, Amanda. I'm here to help you resolve the duplicated data and clarify some things about the data syncing from QuickBooks (QB) Time to QuickBooks Desktop (QBDT).

 

The syncing process depends on how you've set up your QB Time integration to your QBDT. If the job/customer selected is inactive, it would be the reason you have duplicate data in the system.

 

To confirm if the job/customer is inactive, kindly follow the steps below:

 

  1. Open your QuickBooks Desktop (QBDT) company file.
  2. Go to the Customer menu and select Customer Center.
  3. From the Active Customers dropdown, pick All Customers.
  4. Look for the Customer/Job. If it's inactive, you'll see an X icon beside it.
  5. Double-click the Customer/Job, and on the lower-left corner of your screen, uncheck the box icon beside Customer is inactive.
  6. Once done, click OK.

 

On the other hand, the feature of having your customer entries carried over to QBDT works as designed. It's how the system functions since you've linked your QB Time to your QBDT company file. Your data in QB Time automatically gets uploaded to QBDT to attain accurate information.

 

Additionally, you may check this article to learn more about handling Time Off in QB time and use this functionality seamlessly:

 

 

You can always add additional queries to this thread regarding the syncing process of QB time to QBDT. Just comment below, and the Community will ensure to provide prompt assistance.

Need to get in touch?

Contact us