Job costing, WIP and estimates to complete you can actually believe
In Columbia, Missouri your finish date belongs to somebody else. Campus work has to fit between commencement and move-in. Student housing has to hand over in August or a developer loses a year of rent. So when a job slips you do not get more time, you get more crew, more overtime and more shifts. Here is the part nobody warns you about: acceleration burns cost faster than it produces work, and if your percentage of completion is cost-based, the WIP schedule will report progress you have not made. The overrun then arrives all at once, in the last month, on the job you thought was fine.
On the ground
Francis Quadrangle, Columbia, Missouri
A market built around a university, a health system, a school district and a hard August rental calendar runs on fixed dates. Fixed dates put every accounting error into the same place: the estimate to complete.
They didn’t just record transactions and call it a day. They built a custom chart of accounts around how a remodeling company actually runs, did a full catch-up on years of bookkeeping inside QuickBooks Online, and now stay on top of my monthly bookkeeping and payroll. Every step, they broke it down in simple terms instead of burying me in accountant talk.
FinTruction rebuilt the whole thing from the ground up, with real job costing, work in progress, and retainage. They didn’t just hand me reports and disappear; they walked me through my numbers until I understood them.
Sahil and his team handle the bookkeeping and job costing for my painting business. They cleaned up my books and set up integrations that give me accurate, timely job costing with solid weekly data. Reliable, detailed, and genuinely invested in getting the numbers right.
FinTruction is the only bookkeeping team we’ve found that truly understands construction accounting and WIP reporting. They aligned our income and costs across 21 jobs and gave us full, monthly transparency. Fast, accurate, and an indispensable partner.
When I came to FinTruction I had no financial structure. No job costing, no WIP tracking, books behind. They did a full cleanup and rebuilt job costing and WIP tracking in QuickBooks. Now I know what’s billed, what’s owed, and where every job stands.
A couple of minutes from a contractor we support, sharing what working with FinTruction has been like and what changed once their numbers finally made sense.
A general bookkeeper can record transactions. Construction accounting is a different job.
| What you need | Generic local bookkeeper | FinTruction |
|---|---|---|
| Job-level costing | Lumps all jobs into one P&L | Cost codes and margin per project |
| WIP & revenue recognition | Cash-basis, no WIP schedule | Monthly WIP with over/underbilling |
| Retainage tracking | Buried in AR/AP, often missed | Tracked receivable & payable by contract |
| Bonding & lender packages | Not equipped to produce them | Bonding-ready statements and backlog |
| Construction software | QuickBooks set up like a retail shop | QuickBooks + integrations tuned for contractors |
We support contractors across Boone County and mid-Missouri, from campus and healthcare crews to the multifamily and commercial builders working a hard August calendar.
Running a Construction Company in Columbia, MO?
Get Your Free AuditThis is the service most Columbia contractors do not know they are missing. A cost-based percentage of completion is only as honest as the total estimated cost sitting in the denominator. Leave that figure at the bid number while the job accelerates and your reporting will flatter you for months, then correct all at once. We rebuild the estimate with the field, every month, on every open job.
Every construction platform claims to have a "QuickBooks integration." Most break the moment your books need to be accurate. Sales tax mismaps, retainage disappears, change orders create duplicates, and job costing reports stop matching project reality. We fix the integration so your software, your books, and your job‑level numbers all tell the same story.
Also work with Foundation, Sage 100, Bill.com, ADP, Gusto, Ramp, and more. See all platforms we integrate →
Deadline work generates a category of cost that ordinary job costing has nowhere to put. Premium time, shift differential, extra supervision, expedited freight and the productivity you lose when four trades share one corridor are all real, all caused by the schedule, and all invisible if they go into the same bucket as normal production.
A large share of Columbia work is for owners who are publicly funded, tax exempt, or both. That changes two things before the first hour is worked: how the material is taxed, and what the payroll has to prove. Both are decided at job setup, and both are painful to fix afterwards.
On a fixed handover date you bill monthly and pay weekly, which is exactly the shape that produces an underbilling. An underbilling is money you have already spent and not yet asked for. We prepare a monthly work in progress schedule, calculate earned revenue on percentage of completion, and show over and underbilling by job while the job is still open.
Deadline work concentrates risk into a few weeks of the year, and a contractor with three August handovers and one bank line is running a real exposure. Our controller services and CFO services cover how much of that you can carry at once, what a liquidated damages claim would do to the balance sheet, and whether your bonding capacity supports the next season.
Columbia is a mid-sized city with the construction demand profile of a much larger one, because the University of Missouri, its health system, the public school district, Boone County and the City are all buying at once. Add the insurance and financial employers headquartered here and the private commercial work that follows a stable professional payroll, and you get a market that is less cyclical than most of Missouri and considerably more calendar-driven.
That calendar is the thing to understand. Work inside occupied academic buildings is scheduled around teaching, which in practice means a summer window between commencement and move-in. Purpose-built student housing has a harder version of the same constraint: miss August and you have not lost a few weeks, you have lost a lease year. School district work runs to the same rhythm. Clinical work runs to a different one, but it is no more flexible, because a department cannot be down indefinitely.
When the date cannot move, the response to a delay is always more resource. That is where the accounting goes wrong. Overtime, added crews and stacked trades cost dramatically more per unit of work installed, so cost incurred stops being a fair proxy for progress. A cost-to-cost percentage of completion will keep reporting revenue you have not really earned, and the correction only surfaces when the remaining work is priced honestly. By then it is a large number arriving in a single month.
There is a cash version of the same problem. In the final weeks before a handover you are paying premium labor every week while billing the owner once a month, and retainage is still being held. Contractors who get into trouble on Columbia deadline work are rarely surprised by the deadline. They are surprised by the working capital the last eight weeks demanded, because nothing in their reporting showed it coming.
Prevailing Wage Was Amended, Not Repealed: Missouri public works still carry prevailing wage. House Bill 1729 took effect on August 28, 2018 and reshaped the law rather than ending it. Public works with an accepted bid or estimated cost of 75,000 dollars or less were exempted. Above that, two rate types exist: the Annual Wage Order rate where 1,000 or more reportable hours were worked in an occupational title in the locality, and the public works contracting minimum wage where fewer hours were reported. The Division of Labor Standards publishes the wage order. Which rate type applies to your trade in Boone County is a bid input, not a detail.
Federal Money Runs on Its Own Rules: Federally funded and federally assisted construction above 2,000 dollars falls under the Davis-Bacon Act, bringing a wage determination, weekly certified payroll and fringe accounting. Columbia contractors run into this on healthcare, housing and infrastructure work that carries federal dollars. Where federal and state requirements both apply to a job, you satisfy both. The workable approach is to load every applicable determination against the job at setup so the payroll process already knows what it owes.
Materials, and the Certificate You Need Before You Buy: Missouri generally treats the contractor as the final consumer of the materials it installs into real property, so tax attaches on purchase and becomes a cost of the job. When an exempt entity contracts for construction, repair or remodeling of its facilities, it can furnish a project exemption certificate that allows materials for that project to be bought tax free, and the Department of Revenue publishes Form 5060 for it. In a town where a large share of owners are exempt, that certificate is a job setup task with a deadline, because it does you no good after the purchase order has gone out.
Licensing Sits With the City and the County: Missouri has no statewide general contractor license, with electrical contracting the recognized statewide exception, so requirements are set locally. The City of Columbia and Boone County each set their own licensing, bonding, insurance and permitting rules, and a contractor working across mid-Missouri carries a portfolio of them. Confirm the current categories, fees and renewal dates for every jurisdiction you bid in. Book those costs to overhead by jurisdiction rather than to a miscellaneous account, or the overhead rate under your bids is quietly light.
Mechanics Lien Timing: Section 429.080 RSMo allows six months from the date you last furnished labor or material, measured from your last work rather than from project completion. Anyone other than the original contractor must give the owner ten days notice before filing, and the original contractor has a separate obligation under Section 429.012 to serve a statutory disclosure notice. We are not attorneys and we do not file notices. We keep unpaid amounts organized by job, tier and date furnished, so the calendar runs off real data.
Retainage, Prompt Payment and Contract Terms: Missouri has prompt payment provisions and limits on retainage held on public works, and private contracts follow their own terms. On deadline-driven work the terms that matter most are often the ones about time: liquidated damages, notice requirements for delay and the mechanism for claiming acceleration. Confirm those against the contract in front of you rather than a general rule. Our part is making sure retainage sits outside ordinary receivables with its release condition attached, and that any liquidated damages exposure is visible on the balance sheet before a surety asks about it.
A fair question if you already have a bookkeeper or a CPA who does the return. Here is the honest answer.
Contractors who were behind, off the bank, or heading into an audit. Same work, different trades.
$1M+ Rebuild
"FinTruction rebuilt the whole thing from the ground up, with real job costing, WIP, and retainage."
Built From Scratch
"FinTruction set the accounts up properly first, then cleaned up everything I never entered."
Most Columbia contractors do not need new software. They need what they already pay for configured for construction, so the estimate, the committed cost and the actual cost sit in one place and can be compared.
Most QuickBooks files we inherit were configured for a business that sells products. For a contractor that means jobs are customers, cost codes do not exist, retainage hides inside receivables, and there is nowhere in the file that holds a current estimate to complete, which is the one number a WIP schedule depends on.
Is your QuickBooks file working against you?
If your project managers already hold the budget, the commitments and the change orders in a construction platform, the office should not be retyping any of it. We connect the field system to the accounting so the estimate the field is working to and the estimate the WIP schedule uses are the same estimate.
One set of numbers that the field and the office both believe.
Once the systems are connected, reporting stops being a history lesson. These are the reports mid-Missouri contractors use to decide what to chase and what to walk away from:
See how we have done this for other contractors in our construction accounting case studies.
Because most contractors measure progress by cost. Under a cost-to-cost percentage of completion, the share of the job you report as earned is cost incurred divided by total estimated cost. Acceleration breaks the assumption underneath that: overtime, extra crews, night shifts and stacked trades buy you the same physical work at a much higher cost per unit. So costs run ahead of production, the formula reports progress you have not achieved, and the schedule looks healthy right up to the month the remaining work turns out to cost far more than the estimate said. The fix is not a new formula. It is an honest estimate to complete, revised the moment the schedule changes.
Separately, and from the day the direction is given, not after the job closes. Acceleration produces identifiable costs: premium time, shift differential, extra supervision, additional equipment, expedited material, and lost productivity from crowding trades into the same space. If those land in the same buckets as ordinary production, you can never show what the acceleration actually cost, which means you cannot recover it and you cannot price the next one. We set up cost codes that isolate acceleration and disruption on the job, so the number exists as a number rather than as an argument.
It is. Liquidated damages are a contingent liability tied to a date you can see coming months out, and both your surety and your lender will want to know how you are treating it. The accounting questions are whether a loss is probable and estimable, how it interacts with the estimate to complete on that contract, and whether a job that is now a loss job is being reported as one. A contract heading for a loss should be recognized as a loss when it becomes apparent, not spread quietly across the remaining months.
Missouri still has a prevailing wage law, and public works generally fall under it. House Bill 1729 amended rather than repealed the law with effect from August 28, 2018. It exempted public works with an accepted bid or estimated cost of 75,000 dollars or less, and above that threshold it created two rate types: where 1,000 or more reportable hours were worked in an occupational title in that locality, the Annual Wage Order rate applies, and where fewer hours were reported the public works contracting minimum wage applies instead. The Division of Labor Standards issues the wage order. Check which rate type applies to your occupational title in Boone County before you bid.
Federally funded and federally assisted construction above 2,000 dollars falls under the Davis-Bacon Act, with its own wage determination, weekly certified payroll and fringe accounting. That is a different regime from the state wage order, and if a job carries federal money you satisfy the federal requirements as well as anything the state or the owner imposes. The practical answer is to attach every applicable wage determination to the job at setup so the payroll run already knows what that job owes. Reconstructing it after the first payroll has gone out is where corrections and back wages start.
Not automatically, and this is worth getting right before you buy. Missouri generally treats the contractor as the final consumer of the materials it installs, so the tax is your cost rather than something you collect. When an exempt entity contracts for construction, repair or remodeling of its facilities, it can furnish a project exemption certificate that lets you buy materials for that project tax free, and the Department of Revenue publishes Form 5060 for the purpose. The certificate has to be in your hands before the purchase. Bid a job as exempt without one and you will pay the tax out of your margin.
Missouri has no statewide general contractor license, with electrical contracting as the recognized statewide exception, so licensing, registration and bonding are set by the city or county you are working in. The City of Columbia and Boone County each set their own requirements, and contractors working out across mid-Missouri end up carrying a portfolio of separate registrations, fees and renewal dates. Confirm the current categories and renewal dates for every jurisdiction you bid in. On the accounting side those fees belong in overhead by jurisdiction, because booked as miscellaneous expense they quietly understate the overhead rate every bid is built on.
Section 429.080 RSMo gives six months from the date you last furnished labor or material, and the clock runs from your last work rather than from project completion, which catches people out on a job that lingers. Everyone other than the original contractor must give the owner ten days notice before filing, and the original contractor has a separate duty under Section 429.012 to serve a statutory disclosure notice. We are not attorneys and we do not file notices. What we do is keep unpaid amounts organized by job, tier and date furnished so the deadline calendar runs off real data and your attorney gets the backup the same day.
Three things, and they should be current rather than a month behind. First, the estimate to complete for every remaining cost code, reviewed with the people actually running the work. Second, the cost of acceleration and disruption to date, isolated so it can be claimed or at least understood. Third, the cash position through handover, because the last eight weeks of a deadline job is when you are paying overtime weekly and billing monthly. Contractors who get hurt on these jobs are rarely surprised by the deadline. They are surprised by the cash gap in the run-up to it.
We work with contractors across Boone County and mid-Missouri: Columbia, Jefferson City, Ashland, Centralia, Fulton, Moberly, Mexico, Boonville and Fayette, and out toward both metros when the work takes you there. Start with the free Audit. Send your current accounting file and your last job profitability or WIP report and we will tell you what is wrong, what it is costing you, and whether your estimates to complete are believable. No obligation. After that it is a flat monthly fee based on transaction volume, active jobs and reporting needs, so asking a question does not start a clock. Sahil Ahmad, CPA reviews the work.
FinTruction provides construction accounting across Missouri. Select your city below for job costing, WIP and contractor bookkeeping support in your market.
If the job cost structure is sound and it is the monthly close that keeps slipping, we also run day-to-day construction bookkeeping: coding to cost codes, reconciliations, AP and AR, payroll runs and job-cost entry.
Construction Bookkeeping Services
Nearby
Kansas City contractors
Nearby
St. Louis contractors
Nearby
Springfield contractors
Not Seeing Your City?
We serve contractors across all of Missouri. View all locations →
Working across the state? Construction accounting in Missouri
Send us your current file and your last WIP or job profitability report. We will tell you what is wrong with it, what it is costing you, and whether the estimates to complete behind your reported margin are believable. No charge and no obligation for the Audit.
Looking for professional construction accounting in Columbia? Fill out the short form below and our contractor bookkeeping team will contact you within 24 hours.
