Job Costing

How to Set Up Job Costing in QuickBooks Online for Contractors

By Lena Hanna, CPA, EA, CIA

Updated

How to Set Up Job Costing in QuickBooks Online for Contractors

QuickBooks Online was not designed for construction. Don't get me wrong: if the income and direct expenses of a job are attached to that project or customer, you get clean, basic job costing. But it stops at gross profit. It is not a full job costing system.

In fact, I have never seen an accounting program that can allocate general and administrative expenses to a job using different allocation methods, such as direct labor hours, total direct labor cost or sales. For most subcontractors QuickBooks is still the right tool. You just have to equip yourself to calculate the other half of the equation.

Does that other half really matter? Always. It is where most contractors get hurt. When they bid a job, they may know its direct costs. They may estimate them and even get very close. But is that the whole story? Absolutely not.

I've configured QBO for dozens of contractor clients. Here's the exact framework I use to get clean job costing out of a generic accounting tool, and where that job costing stops.

Step 1: Enable Projects (or Use Sub-Customers)

Turn on Projects, or set up each job as a sub-customer under the parent customer when that customer does multiple jobs with you. Either one is your job tracking mechanism. Pick one and stick with it.

Give every active contract its own project. This lets you assign income and expenses directly to specific jobs.

For contractors running multiple divisions or entities, use Classes at the division level. That gives you a P&L by division.

Step 2: Heavily Edit Your Chart of Accounts for Construction

Look at your chart of accounts. Make sure it has every account a construction company in your specialty needs, and add anything that is missing. The more consistently transactions land in the correct classification, the better the accounting tends to be.

Here's what you need:

Income accounts:

  • Contract Revenue
  • Change Order Revenue
  • T&M Revenue

COGS/Job Cost accounts:

  • Direct Labor (field)
  • Payroll Taxes (field)
  • Materials
  • Subcontractor Costs
  • Equipment Rental
  • Permits & Fees
  • Other Direct Job Costs

Overhead (general and administrative) accounts:

  • Officer Salaries
  • Office Salaries
  • Payroll Taxes (office)
  • Employee Benefits
  • Insurance (GL, Auto, Umbrella)
  • Rent
  • Utilities
  • Telephone & Internet
  • Software & Subscriptions
  • Office Supplies
  • Vehicle Expenses
  • Professional Fees (Accounting, Legal)
  • Advertising & Marketing
  • Licenses & Dues
  • Travel & Meals
  • Bank Fees
  • Depreciation
  • Interest Expense
  • Income Taxes

Step 3: Create Items That Map to Cost Codes

Your Items list in QBO becomes your cost code structure. Create items for each cost type you want to track at the job level:

  • Labor - Journeyman
  • Labor - Apprentice
  • Labor - Foreman
  • Materials - Rough
  • Materials - Finish
  • Sub - [Trade]
  • Equipment

When you enter bills or timesheets, always assign both the Project AND the Item. This gives you two-dimensional reporting: cost by job and cost by type. Alternatively, ask your payroll company to map the items to the general ledger directly, by employee.

Step 4: Use Timesheets Religiously

If your field guys aren't logging time by project in QBO (or a connected app), you don't have full job costing. You have expense tracking.

You need to fill in the payroll gaps to get the full expense of a job. Complete a weekly timesheet entry that allocates payroll to the correct category and job. Every hour gets a project and a service item. No exceptions.

Step 5: Enter Bills with Job Detail

Every vendor bill should be split by project. That $3,000 electrical supply order that covers three jobs? Split it three ways, using multiple lines on the bill entry. It takes 30 extra seconds and gives you accurate job costs.

Step 6: Run the Right Reports

The reports that matter for contractors in QBO:

  1. Profit & Loss by Project (or by sub-customer, if you track jobs that way). Your job profitability report
  2. Project Profitability Summary. Quick snapshot across all active jobs

Common QBO Pitfalls for Contractors

  • Not reconciling monthly. If your bank rec is 3 months behind, your job costs are meaningless. You could be missing a ton of expenses that should have been allocated to jobs.
  • Using "Uncategorized" as a parking lot. Every transaction needs a project and account. Period.
  • Ignoring retention. Track retention receivable and payable separately. It's not optional for contractors.

When QBO Isn't Enough

If you want to know the true, full cost of a job, including the share of general and administrative expenses that job should carry, you need controller-level support. No accounting software will calculate that, nor should it.

That calculation should always live outside the books, in a schedule. It is not a journal entry. Post an overhead allocation into QuickBooks and you have damaged your financial statements to produce a management number.

Need professional QuickBooks setup for your contracting business? →

Related reading:

For help turning the QuickBooks setup into a repeatable management process, review my contractor job costing services. Job coding, labor allocation and estimates to finish all need consistent ownership.

For Long Island contractors, my construction CPA work in Suffolk and Nassau covers job costing alongside cleanup, WIP and certified payroll.

Want help with your contractor finances?

Schedule a free 20-minute Contractor Books Review.

Book a Contractor Books Review

Contractors only.