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.
QuickBooks Online · Construction
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
Someone created the jobs in QuickBooks, but most expenses come in with no project. The report shows full revenue and almost no cost.
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 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
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:
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 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.
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.
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.
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
Accounts in use, open jobs, items on file and how each cost gets in today.
Building or adjusting the chart of accounts, the jobs as projects and the cost items, using the names your crew uses on site.
Buildertrend QuickBooks bookkeeping starts by setting which system originates each entry, with rules that keep one cost from entering twice.
Every month, cost checked job by job and the project report next to the company P&L, inside Strategic Bookkeeping Basic.
Deliverables
Materials, labor, subcontractors, equipment and permits kept apart from the company's fixed overhead.
Each contract linked to its customer, with a name the crew recognizes and start and delivery dates.
The list of what the company buys and hires, each item already pointing to the right account.
New build, remodeling and service kept apart, when the company runs more than one line.
Subcontractors on file with the W-9 attached, address filled in and tracking on from the first payment.
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
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.
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.
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.
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.
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.
Keep reading
Job costing and margin per job in QuickBooks.
Hurricanes, draws, retainage and subcontractors in your job cash.
W-9s, contractor totals and a 1099 package for your CPA.
How to truly separate cost by job.
When QuickBooks is in use but the numbers are wrong.
Portuguese speaking bookkeeper for the Orlando area.
First step
Twenty minutes, no commitment, to understand where your company is and point the way.