Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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.
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.
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.
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.
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?
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:
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here