It’s the start of construction season, is your job costing system in place?
While the start of a busy construction season may not be the time to do a full-scale revamp of your current job costing system, it is certainly time to give it a thorough review for the upcoming season and perhaps make some modifications to your existing system within QuickBooks. As you read through this article, take some notes and see what you can change now and what should wait until you are in “off season” before implementing.
- QuickBooks is a very flexible and versatile program. The Customer Center List provides you with the ability to track your Customers (project owners, awarding authorities, or general contractors) that you perform work for. For each Customer you can then track the various Jobs (projects) that you are working on for that specific customer. For each Job that you are working on you can also track Sub-Jobs (your Change Orders or Extra Work orders) that are specific to the original job.
Each Job and Sub-Job should have its own Estimate; the Estimate that you create at the Job level should be for the Original Contract, whereas, the Estimate that you create at the Sub-Job level should only be for the items that are specific to the change order/extra work order.
ALL costs that are entered into QuickBooks should be posted or job costed to either the Job or to the Change Order/Extra Work order.
Sometimes the contract owner wants the Change Order/Extra Work Order to be added or included with the original contract for billing purposes, in this case it is recommended that you still set up both the Job and Sub-Job records in QuickBooks for job-costing purposes and also add the Change Order/Extra Work Order (in whatever sort of detail required) to the BOTTOM of the Original Estimate for billing purposes.
NEVER, I repeat – NEVER simply open the original QuickBooks Estimate and simply change the dollar amounts of any line item to reflect the new amount after a change – this will NOT provide you with a good documentation system.
2. Review your QuickBooks Chart of Accounts and make sure that you have suitable accounts listed there for Direct and Indirect Job Costs
3. Review your QuickBooks Item List – it should be set up to match your industries cost code lists with all items being “Double-Sided” (having both a Purchase and a Sales price) and using “Group Items” as appropriate.
4. Review your QuickBooks Payroll Item List – does it have different payroll wage items that reflect the type of work (work classification) that the employee performs work under on the jobsite?
5. While we are on the subject of Payroll, you should be doing your payroll in-house or through the use of QuickBooks Assisted Payroll and entering employee hours using the weekly timesheet – mirroring the information that is sent from the field.
6. Make sure that you are accounting for your Equipment Costs on the job site and in your job costing reports.
7. Track committed costs, material purchases, and subcontracts using customized QuickBooks Purchase Orders and the Cost Codes you create in your Items List.
8. Create Estimates that reflect the Schedule of Values using the Cost Codes you create in your Items List and then use the Progress Invoicing feature to generate the base billing.
9. Use our free Project Info Worksheet as a means of providing essential contract information to the appropriate people.
10. Document procedures.
11. Get your employees involved; make sure that everyone is trained properly.
12. Monitor the work flow carefully and make adjustments as necessary.
Leave a Reply
- Using Account Numbers in Your QuickBooks Chart of Accounts
- Straight from the IRS - Social Security Tax Reduced to 4.2%
- QuickBooks 2012 - Frequently Asked Questions About Upgrading
- Calculating & Displaying Fringe Benefits on a Certified Payroll Report
- QuickBooks 2013 Upgrade Do's, Don'ts & Frequent Questions
- QuickBooks Tip - Job Costing Starts With A Simple Item
- QuickBooks Payroll Tip - Tracking Employee Advances or Loans
- QuickBooks Tip - Determing Cost of Goods Sold
- QuickBooks for Contractors Tip – Advanced Progress Invoicing
- QuickBooks Tip-Handling Employee Reimbursements for Expenses
- QuickBooks 2012 Announced
- Frequently Asked Questions - California Prevailing Wage
- QuickBooks Creating a More Meaningful Payroll Expenses Section
- QuickBooks 2012 - Best Practices & Tips for Installing an Upgrade
- New FHWA-1391 & 1392 Annual EEO Forms For Highway Contractors
- QuickBooks 2011 - New Balance Sheet by Class Report - Part 1
- QuickBooks 2011 - Computer Requirements & Office Compatibility
- QuickBooks for Contractors Tip – Basics of Progress Invoicing
- QuickBooks 2011 - 10 Tips for a Successful Installation/Upgrade
- QuickBooks 2012 - Basic File Maintenance Before & After You Upgrade
- QuickBooks Automatic Updates & Critical Fixes-What’s Your Policy?
- Unconditional Waiver / Release Upon Final Payment – Part 5
- QuickBooks Tip – How To Handle Stored Materials and AIA Pay Apps
- Certified Payroll-Numbering and “No Work” Performed Reports
- Conditional Waiver / Release Upon Final Payment – Part 4
- I-9 Form Updated – Make Sure You’re Prepared
- Automating Job Costing Overtime, an 800 pound gorilla with an attitude
- Is Someone at Work Wearing Too Much Perfume or Aftershave?
- Unconditional Waiver / Release Form Upon Progress/Partial Payment – Part 3
- Confused About Payroll Deductions and Payroll Liabilities?
- Understanding & Implementing Prevailing Wage Decisions
- Conditional Waiver/Release Form Upon Progress/Partial Payment – Part 2
- You Get What You Pay For – Do Cheap Bookkeepers Save Money?
- Entering Historical Paychecks – Payroll Taxes and the Accounts They Post To
- Conditional and Unconditional Lien Waiver/Release Forms for Progress and Final Payments – Part 1
- InformedContractors.com – A New Resource for Contractors
- Retainage Payable and Receivable – What’s the Difference?
- How-to Customize a Report – One Employee for All Jobs Worked
- Quick is a fantasy!
- Pardon the mess on the QuickBooks for Contractors blog