Accounting Software
How to Set Up QuickBooks for a Construction Company
Set up QuickBooks for a construction company around jobs, cost codes, change orders, retainage, reconciled opening balances, and useful project reports.
To set up QuickBooks for a construction company, design the job-costing structure before importing transactions. Decide how customers, projects, cost categories, change orders, retainage, subcontractors, and payroll will reach the general ledger and the project reports. Connecting the bank first usually creates cleanup instead of a construction accounting system.
The setup should answer two questions at the same time: what did the company earn overall, and what did each job earn after labor, materials, subcontractors, equipment, and other direct costs? QuickBooks can support that analysis, but only when the edition, account structure, products and services, and transaction coding work together.
Choose the QuickBooks product before designing the file
Start with the reporting result you need, then confirm the current US product and plan on Intuit’s website. QuickBooks Online Projects is currently available in Plus and Advanced, and Intuit’s current documentation also describes project features in Intuit Enterprise Suite. QuickBooks Online class tracking is limited to Plus and Advanced. Those boundaries matter because a design that depends on projects or classes cannot be reproduced in a plan that does not include them.
QuickBooks Desktop Enterprise remains a separate desktop product. Existing subscribers may also use older Desktop products, but a Desktop procedure should not be copied into QuickBooks Online. Menus, permissions, integrations, hosting, and job-cost reports differ. Write the exact product and plan at the top of the setup memo.
Do not choose a plan only because it says “contractor” or “construction.” Test the actual reports with a sample job. A product can record customer invoices and vendor bills yet still miss the labor detail, committed cost, change-order history, or work-in-progress analysis that management expects.
Collect clean opening information
Prepare the opening package before creating accounts or connecting feeds. At minimum, collect:
- the reconciled trial balance and most recent financial statements;
- bank, credit-card, loan, and equipment-financing statements;
- open customer invoices, customer deposits, vendor bills, and vendor credits;
- active jobs with contract values, approved change orders, billings, collections, and costs to date;
- retainage receivable and payable schedules, when applicable;
- payroll and subcontractor reports that identify labor by job;
- fixed-asset and accumulated-depreciation schedules; and
- sales-tax, payroll-tax, and other liability reconciliations.
Choose one conversion date. The opening trial balance, subledgers, and job schedules must agree at that date. If they do not, record the differences before importing. A new file should not silently convert an unexplained balance into an opening-balance adjustment.
Build a construction chart of accounts without turning every job into an account
Use general-ledger accounts for financial-statement categories and projects or other supported dimensions for jobs. Creating a separate income and expense account for every project makes the chart expand indefinitely and makes company-wide reporting harder.
A practical construction chart commonly separates contract revenue, change-order revenue, direct labor, subcontractors, materials, equipment, permits, and other direct job costs. Overhead accounts capture costs that are not assigned directly to one job, such as office rent, general insurance, administrative payroll, and company-wide software.
Retainage, customer deposits, progress billings, unbilled work, and work in progress require accounting-policy decisions. Do not create those accounts from a generic template and assume the resulting balance is correct. The contract terms, accounting basis, tax treatment, and reporting needs determine the appropriate entries. Have the responsible accounting or tax professional approve that part of the design.
Create customers, projects, and cost categories
Use one naming convention for customers and projects. A project name should remain identifiable even if the project manager, phase, or contract amount changes. Avoid creating duplicate customers for estimating, invoicing, and field systems.
In supported QuickBooks Online plans, a project groups transactions connected with a customer and can support project-level income and cost reporting. Intuit’s current documentation says Projects can track income and costs, and the current project workflow includes estimates, expenses, invoices, and project reports. Test the fields and reports in your specific plan because advanced construction capabilities can have additional requirements.
Set up products and services as the operational bridge to accounting. An invoice item can describe work performed while mapping to the correct income account. A purchased item or service can help users code materials, subcontract work, equipment rental, or permits consistently. Keep the list detailed enough to support estimating and review, but not so detailed that staff choose similar items at random.
Decide what projects, classes, and locations mean
Give each dimension one job. Projects are usually the natural place for individual construction jobs. Classes may be useful for divisions or service lines, and locations may be useful for branches or operating units when the selected product supports the required reporting. Do not use projects, classes, and locations interchangeably.
Document the rule with examples. If “Commercial” is a division, it should not sometimes appear as a class and sometimes as a project. If a cost belongs to Job 2417, the coding rule should explain whether the user assigns only the project or also assigns a class. Consistent dimensions make project reports comparable and prevent uncoded costs from accumulating in a general bucket.
Map the construction transaction cycle
Estimates and change orders
Record the original estimate and approved changes in a controlled process. QuickBooks is not automatically the legal record of the contract. Preserve signed documents outside the accounting entry and establish who may approve a change before it affects billing or forecast reports.
Progress invoices, deposits, and retainage
Decide how the company will distinguish customer deposits, earned revenue, billed amounts, and retained amounts. Test a progress invoice, a partial collection, a change order, and final release. The customer balance, retainage schedule, project report, and general ledger should tell the same story.
Vendor bills and subcontractors
Require job coding on direct vendor costs. Collect vendor identity and tax documentation during onboarding, not after year-end. Purchase orders, subcontracts, lien documentation, insurance certificates, and approvals may live in a construction-management system, but the accounting workflow still needs a controlled total from that system to QuickBooks.
Labor and equipment
Choose the source of job labor hours and labor cost. Payroll, time tracking, and field applications may calculate different measures. Define which amount reaches the ledger and how it reconciles to payroll reports. Treat owned-equipment cost allocation as a management calculation unless the accounting policy supports a specific book entry.
Illustrative setup for one job
Assume a contractor opens illustrative Project 2417 for a renovation. The approved contract is $180,000, including an approved $20,000 change order. During the first reporting period, the company issues a $45,000 progress invoice, records $18,000 of materials, $9,500 of subcontractor bills, and $7,200 of assigned labor cost, and collects $40,500 because the customer retains $4,500. These figures illustrate the workflow and are not industry norms.
The reviewer should be able to trace the $45,000 invoice to the billing support, the $4,500 difference to a retainage schedule, and the $34,700 of direct costs to vendor and payroll detail. The project report should show the same assigned revenue and cost population used in the reconciliation. An unapproved purchase, an uncoded time entry, or a bill assigned only to the customer rather than the project should appear on an exception list.
This example also shows why a profit-and-loss statement is not enough. The company needs the open receivable, retainage, cash collection, vendor obligations, and job-cost detail, not only the revenue and expense totals.
Connect banks and applications only after the structure works
Connect bank and credit-card feeds after opening balances and coding rules are approved. A feed supplies transaction candidates; it does not prove the account is reconciled. Match existing entries where appropriate, avoid duplicates, and reconcile every account to an external statement.
Test each field or estimating integration with one complete job before expanding it. Compare record counts and dollar control totals for estimates, invoices, payments, bills, credits, taxes, and fees. Assign ownership for rejected records and corrections. A “sync successful” message does not establish that the correct account, project, or period received the transaction.
Reports that should pass before launch
- balance sheet and profit and loss tied to the opening trial balance;
- accounts receivable tied to open invoices and retainage support;
- accounts payable tied to open vendor bills and credits;
- project profitability for each test job;
- uncategorized and unassigned project-cost reports reviewed to zero or explained;
- bank, card, loan, payroll, and clearing accounts reconciled; and
- user-access and audit-history review completed.
Save the reports used for approval. If another person cannot reproduce the job result from retained records, the file is not ready for live construction activity.
Where construction QuickBooks setups go wrong
- Every job becomes a ledger account. Company reporting breaks down as the account list grows.
- Only invoices receive job codes. Revenue appears by project while materials, subcontractors, or payroll remain in company-wide expense accounts.
- Bank feeds are treated as bookkeeping. Downloaded activity is categorized without matching, support, or statement reconciliation.
- Change orders bypass the accounting workflow. Contract value, billing, forecast, and collection reports use different numbers.
- Retainage is tracked in an unsupported spreadsheet. Customer balances and the separate schedule drift apart.
- The integration owns the design. Default mappings create duplicate customers, vague items, or transactions in the wrong period.
- Opening balances are plugged. The new file begins with an unexplained difference that later contaminates job profitability.
Continue with the Accounting Software and Tools hub, the guides to QuickBooks for construction, QuickBooks setup, and QuickBooks printer setup.
Educational information only. Tax, payroll, and compliance rules change and may vary by jurisdiction. Confirm the current requirements for your facts with the appropriate agency or a qualified professional.
If your opening balances, job costs, and project reports do not agree, review Steady’s QuickBooks setup and cleanup services.
Frequently asked questions
How do I set up QuickBooks Online for a construction company?
Select a plan that supports the project and reporting features you need, load reconciled opening balances, create the chart of accounts and cost categories, define customers and projects, map payroll and vendor costs, and test one complete job before connecting every bank or application.
Should every construction job be a separate QuickBooks project?
Usually, a distinct contract or management job is a useful project boundary. Small service calls may need a different workflow. Use a consistent rule and confirm that the resulting project reports match how managers estimate, bill, and review work.
Do I need classes if I already use projects?
Not necessarily. Projects can identify jobs, while classes may identify divisions or service lines. Add a second dimension only when it answers a recurring reporting question and staff can code it consistently. QuickBooks Online class tracking currently requires Plus or Advanced.
How should I track construction retainage in QuickBooks?
Start with the contract and accounting policy, then design receivable, payable, invoicing, and schedule procedures that reconcile. Product workflows vary, so verify the current feature set and have the accounting treatment reviewed for the company's facts.
Can QuickBooks calculate work in progress automatically?
Do not assume that ordinary project reports produce the work-in-progress calculation your contracts or accounting method require. Define the calculation, source data, approval, and journal-entry process, then test the result against the job schedule.
When should a contractor get help with the setup?
Help is useful when opening balances do not reconcile, retainage or progress billing is material, payroll and field systems must integrate, the chart needs redesign, or the company cannot reproduce job profitability from source records.
Turn this guide into action