How to Run a Job Costing Report in QuickBooks While Using a Third-Party Payroll Processor
As a business owner, you are most likely familiar with the famous quote, "Time is money." This is especially true with a service-based business that heavily relies on a labor workforce as the primary means of production. Accordingly, when it comes to reviewing profit per job, it's very important to include your employees' payroll in the job costing report.
In this article, we will demonstrate how to import employee job costing information into QuickBooks Desktop. Note: This article addresses QuickBooks Desktop. Look out for our future post for QuickBooks Online instructions.
If you run payroll through QuickBooks Desktop and use TSheets for time tracking, the process is very simple. The weekly timesheet from TSheets for your payroll can be used by syncing TSheets to QuickBooks. This can also be utilized for an employee with a fixed salary. In such a case, QuickBooks will automatically allocate the payroll based on the hours worked.
However, most business owners do not use QuickBooks Desktop as their payroll provider. For those businesses using Intuit Online Payroll, note that it does not integrate with TSheets- despite it being a QuickBooks product. If you are using other third-party payroll providers (such as Fingercheck, CHS, Megapay, or ADP) they all have time tracking capabilities, yet those are not integrated with QuickBooks Desktop, forcing you to enter all your jobs manually or to enter them via a spreadsheet. Since we try to streamline the process and eliminate manual data input, this represents a challenge, how do you import the job cost data by employee into QuickBooks? Using TSheets for employee time tracking is strongly recommended as this can really automate the process.
In the following tutorial, we will provide you with a step-by-step guide how to bring in the employees payroll cost into the job costing report through TSheets, regardless whether you process payroll through QuickBooks or any other third-party payroll provider.
- Create each employee as a vendor
- Enter the name in the "Full Name" field
Warning: If a company name is entered in the Full Name field, it will also sync through TSheets (TSheets pricing is based on users). Only use the Full Name field for Employees.
Pro tip: If the employee already exists in the employee center, add a period or comma to the existing saved employee and make it inactive, so you can create the new employee as a vendor.
- Now, try syncing TSheets to QuickBooks. TSheets should automatically mark the employee as a vendor. Confirm that by going to My Team > click on any team member > General Tab,
- Create a payroll expense account named "Payroll L&E" (Exchange/Wash account). This should be a sub-account under the gross payroll account.
- Create items that the employees will use while logging their time in TSheets. All items should be linked to the "Payroll L&E" account,
- If the items are also being used on invoices, check the box called “This service is used in assemblies or is performed by a subcontractor or partner” that will enable to also link it to an expense account.
Pro tip: If the items are already being used on the income and expense side, create new items for all TSheets items and put a P (stands for Payroll) to all items, so the employees and the AR/AP team will not get confused about which items to use.
- Enable the feature to Import vendors as team members by clicking on the QB icon on the upper right corner > Preferences > Other Options, the option should be on the pop-up box on the bottom.
- By default, all items will come into TSheets from QuickBooks. This can be customized based on the companies needs. (Making it inactive in TSheets won't make it inactive in QuickBooks). This feature can be found by going to Feature Add-ons > Custom Fields > Service Item.
- You can also create different items for every employee if needed.
Note: The following steps are not required to be done while processing payroll, however, it is considered best practice to do it at the same time, thus ensuring that you don't forget to do it, as well as remembering which ones you have already included.
- Review and approve your employee timesheets.
- After Syncing QuickBooks with TSheets, go to the employee by the vendor section to create a new bill. When opening the bill, a pop-up a message will appear that you have time data for that vendor. Click yes to use it.
- Select the correct period and bring in the timesheet.
- In the cost field, enter the pre-calculated cost per hour for this employee.
- Go to the expenses column and enter the "Payroll L&E" account and make sure the bill has a zero effect on the Income Statement by entering the amount due with a negative symbol.
- Now when you review the "Job Profitability Detail" report, you will have your payroll cost included there.
Questions, comments? Please share below.