QuickBooks Online · Construction

QuickBooks for contractors: the setup that tracks cost by job

QuickBooks is paid for, but every job cost lands in the same expense account and no report shows the job.

A QuickBooks setup for a construction company comes down to four decisions: a chart of accounts that separates materials, labor, subcontractors, equipment and permits; every job entered as a project; cost items that send each bill to the right line; and classes by service type when the company runs more than one. Done this way, QuickBooks for contractors reports revenue, cost and margin job by job. GS Brasil handles the setup and the monthly routine remotely, with Gustavo, a Certified QuickBooks PRO Advisor.

This page is about the tool. Job costing as a concept, and why it changes your margin, is on the construction bookkeeping page. What changes when the job is in Florida is on construction bookkeeping in Florida. The W-9 and 1099 routine is on 1099 bookkeeping.

Signs in the file

Three signs QuickBooks is set up wrong for construction

The project exists and sits empty

Someone created the jobs in QuickBooks, but most expenses come in with no project. The report shows full revenue and almost no cost.

The same bill shows up twice

The cost comes in from Buildertrend and comes back through the bank feed, the automatic bank import. The job ends up with double the cost.

The deposit turned into profit

The client paid before work started, the amount was booked as income, and the month closed with a profit that does not exist yet.

The setup

How QuickBooks Online gets set up for a construction company

The chart of accounts for a builder

The chart of accounts is the system's list of categories. In a construction company it separates the cost that belongs to a job from the spending the company would have with no job at all. The first group is direct cost:

  • Materials. Supplies bought for the job, with the receipt tied to the project.
  • In-house labor. The share of payroll that went to the job, not all of it.
  • Subcontractors. Payments to trades, kept apart from material they supplied.
  • Equipment. Machine and tool rental, a job cost, kept apart from equipment purchases, which are assets.
  • Permits and fees. Licenses, inspections and fees paid because of that job.

Project, cost item and class

These are three layers, and each answers one question. The project answers which job the money went to: each job becomes a project under the customer. The cost item answers what was bought: it is the line on the bill that points to the right account, so whoever enters it picks drywall without needing to know the category.

The class answers what type of work it was. It only earns its place when the company runs more than one line, such as new builds, remodels and service calls. With a single line, skip classes: every extra field is one more field someone forgets.

Buildertrend and QuickBooks: who owns what

Buildertrend is the job system: schedule, budget, change orders and vendor bills tied to a stage. QuickBooks is the money system: bank, card, payroll, payables and receivables and the reports your CPA understands. Every cost needs one owner, and the owner is the system where it is born.

Double entry shows up when both systems create the same transaction. The rule that fixes it is simple: a cost enters once, and the bank feed exists to match the payment to the entry that is already there, never to create another. In practice that becomes a list of which cost comes from which system.

The material card and the right job

Material purchases are where cost gets lost most. A bank rule, the automatic rule in QuickBooks, guesses the category from the store name, but it cannot guess the job. The job comes from whoever bought it: a photo of the receipt the same day with the job name, or one card per crew. At close, every purchase with no project comes back on a list.

Deposits, draws and retainage inside the system

Money coming in is not always revenue. A customer deposit is an obligation: the company has been paid and still owes the work, so it sits as a liability and becomes revenue as the job is billed. A draw, the release by stage, is billed through a progress invoice that applies the deposit and recognizes the part that was built.

Retainage, the part held back until completion, gets its own place: a separate receivable, so the amount neither disappears from the report nor counts as collected. The contract side of that is on construction bookkeeping in Florida.

The vendor flagged for 1099

Subcontractor bookkeeping starts at the vendor record: every subcontractor is set up with 1099 tracking on, the W-9 attached and the address filled in. The yearly total then comes straight out of the system in January instead of being added up check by check. What the system will not split on its own is what was paid by card or platform: that comes from the payment method on each entry. The routine is on 1099 bookkeeping.

How it works

From a generic account to a report by job

01 Review

What the file already has

Accounts in use, open jobs, items on file and how each cost gets in today.

02 Structure

Accounts, projects and items

Building or adjusting the chart of accounts, the jobs as projects and the cost items, using the names your crew uses on site.

03 Inputs

Buildertrend, bank feed and cards

Buildertrend QuickBooks bookkeeping starts by setting which system originates each entry, with rules that keep one cost from entering twice.

04 Routine

A close with margin by job

Every month, cost checked job by job and the project report next to the company P&L, inside Strategic Bookkeeping Basic.

Deliverables

What ends up configured in your QuickBooks

A construction chart of accounts

Materials, labor, subcontractors, equipment and permits kept apart from the company's fixed overhead.

Jobs set up as projects

Each contract linked to its customer, with a name the crew recognizes and start and delivery dates.

Cost items ready to use

The list of what the company buys and hires, each item already pointing to the right account.

Classes by service type

New build, remodeling and service kept apart, when the company runs more than one line.

Vendors flagged for 1099

Subcontractors on file with the W-9 attached, address filled in and tracking on from the first payment.

A margin report by job

Revenue, cost and margin for each project at the monthly close, next to the company result.

What the setup does not decide.

The structure organizes cost and margin by job. Sales tax classification on materials, the revenue recognition method for tax purposes, depreciation of equipment purchased and the return itself belong to your CPA. GS Brasil does not prepare or file taxes.

Frequently asked

QuickBooks for contractors questions

Does my QuickBooks plan have projects?

Projects come with the fuller QuickBooks Online plans. On the first call we check what your subscription already includes before building anything, so the setup does not rely on a feature you do not have.

How do I stop the same cost entering twice between Buildertrend and QuickBooks?

By deciding, per cost type, which system creates the entry. What starts in Buildertrend reaches QuickBooks already carrying the job, and the bank feed only matches the payment to what is already there. At close, a check shows anything that came in from both sides.

Does a customer deposit count as revenue this month?

In the books, no. While the work has not been done, the amount sits as an obligation to the client and becomes revenue as the job is billed. How it appears on the return is for your CPA to decide.

Can in-house labor be split by job?

Yes, as long as someone records hours by job. With a time record and the payroll report, each employee's cost is spread across the projects. Without it, payroll stays as general cost and every job margin comes out incomplete.

My QuickBooks is already a mess. Do I set it up from scratch?

Almost always it is better to fix the file you have, because the history and balances stay standing. The new structure goes in with the correction, in a QuickBooks cleanup, and open jobs start taking cost from an agreed date.

First step

Start with the first conversation

Twenty minutes, no commitment, to understand where your company is and point the way.