Job Costing Tips
Money doesn’t grow on trees and neither does your profit on a construction project!
QuickBooks® can provide you with some good job costing reports, the Estimate vs. Actual is one of my personal favorites, BUT QuickBooks needs to be setup correctly and job costing information needs to be entered consistently.
Remember … Garbage in (to QuickBooks®) — equals garbage out (of QuickBooks® reports).
This section provides you with helpful tips to make the job costing capabilities in QuickBooks® work for you.
- You create an Estimate for EVERY job/project
- You've modified the QuickBooks Estimate Template to include Cost and Markup columns and you utilize those columns when building your Estimate
- All of your "Items" have been set-up to capture BOTH revenue and costs (double-sided items)
- You enter ALL job related employee time and vendor costs using double-sided items
- You create Job Types for Over/Under and Completed (with sub-types for years) and assign them correctly to your jobs
Calculating and distributing employee overtime is a burdensome process that many business owners and payroll administrators have to deal with on a weekly basis. Everyone has a different opinion on just "HOW" that overtime is to be calculated and distributed. By everyone, I mean the business owner, the payroll clerk, heck even the Federal and State government. No wonder it's just a problematic situation!Continue reading
Using an outside payroll service, such as Paychecx or ADP, is a popular option for many business owners. While using a payroll service often provides many benefits one of the biggest challenges or drawbacks is for the company that needs job costing. See this question submitted by a reader.
My company uses a 3rd party to do all of our payroll. We receive an itemized report back showing what we spent for the week. I am having trouble trying to get this information charged out to individual jobs. I track all of the hours separately in Excel, with estimated costs. How can I job cost this information?Continue reading
A reader asks - I'm looking for a report so I can compare hours reported via the timesheet or really hours that have been paid out Vs. the hours that have been paid for or Invoiced.
See what reports we've suggested.Continue reading
The CSI (Construction Specifications Institute) MasterFormat contractor item list is a standard item list used for most commercial building design and construction projects in North America. It lists titles and section numbers for organizing data about construction requirements, products, and activities. The latest version, revised in April 2012, contains 48 main categories or divisions. Two readers have asked questions recently about the CSI MasterFormat list - here's what they had to say.Continue reading
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 - and my suggestion on how to resolve this.Continue reading
Entering payroll for normal employee work hours and drive time and passing only the work hours through to client invoices is not only important but confusing. The following question was submitted by a reader who pays from the start of the first job till the end of the last job of the day (not including lunch break). I have my employees fill out a time tracker sheet each day that shows the time started at the first job till the end, drive time in between jobs, so on and so forth. I enter this into QuickBooks but I can't figure out where to enter in drive time to pay the girls their hourly wage on payroll but to not invoice anyone for drive time. Continue reading
- QuickBooks 2015- The Good, Bad and Ugly, Part 1
- “Overstating” the Importance of Cost Reporting-Free Webinar
- QuickBooks 2015 Announced – Important System Requirements
- How do Amazon Merchants Reconcile in QuickBooks? Webinar
- Happy 14th Birthday Sunburst Software Solutions, Inc.
- Simple Controls You Can Put Into Place to Discourage Fraud
- Business Susceptibility to Theft and White Collar Crime – Are You a Target?
- Warning Signs & Red Flags of Fraud – Are Your Employees Stealing From You?
- Is Managing QuickBooks Purchase Orders Driving You Insane?
- Free Webinar-Identify and Safeguard Against Business Fraud
- Technology is Changing How We Submit Certified Payroll Reports
- Ask Me Anything – 10 Common Questions about Certified Payroll
- Are Your QuickBooks Payroll & Certified Payroll Processes Efficient?
- QuickBooks Tip: How to find “Notes” after an Upgrade
- QuickBooks Timely Payroll Alerts, Updates & Issues for 2013 Payroll Tax Returns
- QuickBooks Tip: How to Calculate Over/Under Billings
- Happy Holiday’s to you!
- Employee Reimbursements-Accountable vs Non-Accountable Plans
- Sunburst’s Weekly Wrap-Up of Popular Posts 12/2 – 12/8/2013
- Q & A: QuickBooks Employee Payroll Reimbursements & Job Costing
- Using Account Numbers in Your QuickBooks Chart of Accounts
- Straight from the IRS - Social Security Tax Reduced to 4.2%
- Calculating & Displaying Fringe Benefits on a Certified Payroll Report
- QuickBooks 2013 Upgrade Do's, Don'ts & Frequent Questions
- QuickBooks 2012 - Frequently Asked Questions About Upgrading
- QuickBooks Payroll Tip - Tracking Employee Advances or Loans
- QuickBooks Tip - Job Costing Starts With A Simple Item
- QuickBooks Tip-Handling Employee Reimbursements for Expenses
- QuickBooks Tip - Determing Cost of Goods Sold
- QuickBooks Creating a More Meaningful Payroll Expenses Section
- QuickBooks for Contractors Tip – Advanced Progress Invoicing
- QuickBooks for Contractors Tip – Basics of Progress Invoicing
- QuickBooks Tip - Child Support Garnishments
- Create a QuickBooks Job Cost Report With Hours & Payroll Costs
- New FHWA-1391 & 1392 Annual EEO Forms For Highway Contractors
- QuickBooks 2012 Announced
- QuickBooks Tip-Creating a Functional Payroll Liabilities Section
- Frequently Asked Questions - California Prevailing Wage
- QuickBooks 2012 - Best Practices & Tips for Installing an Upgrade
- QuickBooks Tip: Important Facts About Items Left as Billable