Breaking Down Payroll by Job, Phase and Cost Code
Breaking down payroll by job, phase, and cost code is something that I’m often asked about by the construction clients/customers that I work with. Construction payroll is probably one of the more complex payrolls that anyone can encounter, see this question submitted by a reader.
Thanks for stopping by and submitting this awesome question!
Actually, I’m asked this question a lot and have been working on an entire training series (eBook and several videos) about different ways that contractors can set up QuickBooks to handle even the most complex payrolls like this – unfortunately it won’t be finished until later this fall.
Here is what I suggest, it’s going to take a little work on your part – and you should make a copy of your current QuickBooks data file to play around with my suggestion before you make any changes to your current working file.
My suggestion involves working with your QuickBooks Items list – which is where your Phases and Cost Codes ultimately “live”; the Items list can have both Items and Sub-Items which we’ll use for your Phase and your Cost Codes. Each Phase should be set up as an Item and then the Cost Codes used within that Phase should be set up as Sub-Items – see the screenshot below:
Use these same items when you create your Estimates in QuickBooks:
When you enter employee time in QuickBooks using the Weekly Timesheet, select the appropriate Job Name. Phase/Cost Code, Payroll Item and enter the number of hours worked each day:
When you enter vendor bills for this job, use those same Phase/Cost Code items:
When you set up your Item List in this manner, and use the Phase/Cost Codes consistently, you’ll get very well organized Actual vs. Estimate reports from QuickBooks:
There are several other things that can be done to “tweak” this to further meet your needs, this is just one of them. Please feel free to contact me to arrange a training/consultation appointment if you’d like.
Did you find this article to be helpful? If so, please share it with others on your favorite social media network – or leave a comment below.
4 Responses to Breaking Down Payroll by Job, Phase and Cost Code
Leave a Reply
- The Great Debate – QuickBooks Desktop vs. QuickBooks Online
- Using Account Numbers in Your QuickBooks Chart of Accounts
- QuickBooks Creating a More Meaningful Payroll Expenses Section
- QuickBooks Tip - Child Support Garnishments
- Calculating & Displaying Fringe Benefits on a Certified Payroll Report
- How To Turn On and Use Manual Payroll in QuickBooks
- Create a QuickBooks Job Cost Report With Hours & Payroll Costs
- QuickBooks Payroll Tip - Tracking Employee Advances or Loans
- QuickBooks for Contractors Tip – Basics of Progress Invoicing
- QuickBooks Tip - Job Costing Starts With A Simple Item
- QuickBooks Tip-Creating a Functional Payroll Liabilities Section
- QuickBooks Tip: Important Facts About Items Left as Billable
- Welcome to the QuickBooks for contractors blog
- QuickBooks Tip-Handling Employee Reimbursements for Expenses
- QuickBooks Tip - Determing Cost of Goods Sold
- QuickBooks Tip - Handling Retainage
- QuickBooks 2015 Announced - Important System Requirements
- How to Calculate & Display Retainage on an AIA G-702/G-703
- Tips for Effectively Using QuickBooks Purchase Orders
- Straight from the IRS - Social Security Tax Reduced to 4.2%