Monthly bookkeeping in Xero or QuickBooks, closed, reviewed and proven every period by the team that does the work.
BOOKKEEPING PACKAGES
Guides to running Xero properly, written from monthly practice rather than from the product documentation.
THE XERO HANDBOOK
Already on QuickBooks? Stay on it. An Elite-tier ProAdvisor team closes the month in QuickBooks Online, Desktop and Intuit Enterprise Suite.
QUICKBOOKS AT LOGIFRAME
The books look different in every sector. So does the way we close them.
ALL INDUSTRIES
What running other people's books teaches you: costs, platforms, and the industries where the books work differently.
ALL INSIGHTS
Thirteen years of accounting work, a delivery team in Indonesia, and engagement management in San Jose.
ABOUT LOGIFRAMEGuide
Construction breaks the simple bookkeeping most small businesses run on. Revenue is billed in stages, part of it is held back as retainage, costs land months before the final invoice, and every job is its own small business. QuickBooks Online handles this well when it is set up around jobs from the start. Set it up as a general ledger and job costing gets rebuilt in a spreadsheet every month.
The build
QuickBooks Online Plus and Advanced include Projects. Each job becomes a project under its customer, and every estimate, invoice, bill, expense and timesheet can be attached to it.
Projects is what turns QuickBooks from a record of the company into a record of each job. Once transactions are attached, the project carries its own income, costs and profit, and the standard project reports read straight from it.
| Report | Answers |
|---|---|
| Project profitability | What has this job earned and cost so far, and what is the margin? |
| Estimates vs actuals | Is the job running over the estimate, and on which lines? |
| Unbilled time and expenses | What has been spent that has not yet been billed to the customer? |
| Time cost by employee or vendor | Whose labor went into this job, and at what cost? |
Two decisions are worth making before the first job is entered. Name projects the way the field team refers to them, usually the job number and site address, so a bill can be matched without a phone call. And decide how change orders are tracked: as a revised estimate on the same project, so the estimate stays the true contract value, rather than as a new project.
Money out
A project report is only as complete as the costs attached to it. Every job cost needs two codes: the project it belongs to, and the cost type it falls under.
The project answers which job. The cost type answers what kind of cost: labor, materials, subcontractors, equipment, permits and other. Set cost types up as products and services or as cost of goods sold accounts, and keep the list short enough that a field supervisor can pick the right one without asking.
Money in
With progress invoicing turned on, QuickBooks Online creates invoices from an estimate by percentage or by line amount, and tracks how much of the estimate has been billed.
The estimate becomes the schedule of values. Each draw bills a percentage of each line, or a set amount, and QuickBooks keeps the running total billed and the balance remaining. When the last draw goes out, the estimate is closed and the project shows the full contract billed.
Change orders belong on the estimate before they are billed. An approved change added as a new line keeps the remaining balance correct. A change billed on a separate invoice that is not linked to the estimate leaves the estimate understating the contract, and the estimates vs actuals report stops meaning anything.
Some general contractors and owners require pay applications on a specific form, such as the AIA G702 and G703. QuickBooks Online’s standard invoices do not produce those forms. Contractors who bill on them usually prepare the pay application from the progress figures and attach it to the invoice, or use a construction billing add-on that syncs to QuickBooks.
Held back
Retainage is the share of each progress payment the customer holds back until the job is complete, often 5 to 10 percent. It has been earned, but it has not been paid, and it will not be for months.
QuickBooks Online Plus and Advanced have no dedicated retainage field. The standard approach is to set it up once and use it on every draw.
Kept in its own account, retainage stops inflating accounts receivable aging and shows up as what it is: cash the business is owed and cannot use yet. Intuit Enterprise Suite has added construction-specific features, so if you are on it, check what your edition already handles before building this manually.
The schedule most files miss
On a job that runs over months, what you have billed and what you have earned are rarely the same number. The work-in-progress schedule measures the gap.
For each open job, the WIP schedule compares the percentage of the job complete, usually costs to date divided by estimated total cost, with the percentage billed. Billed ahead of the work is overbilling, a liability: the customer has paid for work not yet done. Billed behind the work is underbilling, an asset: work done that has not been invoiced.
| Position | Means | On the balance sheet |
|---|---|---|
| Overbilled | Billings exceed earned revenue. Cash looks better than the job does. | Billings in excess of costs and estimated earnings, a liability |
| Underbilled | Earned revenue exceeds billings. Work is being financed by the contractor. | Costs and estimated earnings in excess of billings, an asset |
QuickBooks Online does not produce a WIP schedule by itself, but it holds every input: the estimate for each project, the costs attached to it and the amounts billed. The schedule is built from those figures each month, and an adjusting journal posts the net over or under billing so the profit and loss reflects work performed rather than invoices sent.
Bonding companies and lenders often ask for a WIP schedule. A contractor who produces one monthly finds out which job is losing money while there is still time to change it, rather than at closeout.
Compliance
Choosing
| Edition | Fits |
|---|---|
| QuickBooks Online Plus | Contractors running a handful of jobs at once who need Projects, progress invoicing and job profitability |
| QuickBooks Online Advanced | More jobs, more users, custom fields for job details, and more room for classes and locations |
| Intuit Enterprise Suite | Larger contractors or several entities, where project profitability with construction job costing and multi-entity reporting justify the step up |
Simple Start and Essentials do not include Projects, which is the single feature a contractor most needs. If you are still on QuickBooks Desktop, the move to Online is the moment to set Projects up properly rather than carrying old customer:job lists across unchanged.
The failure modes
Questions
Next
If job profitability lives in a spreadsheet, the costs are not reaching the projects. Tell us how many jobs you run at once.
Book a free 30-minute call Our QuickBooks services