Construction Hub
WIP Report · Over and Under Billing · Bonds and Overdrafts
Most builders treat the WIP report as accounting paperwork for tax time. For a lender or bond provider it is often the report a credit team reads before the accounts, because it shows what every open job is earning right now. Here is how over billing, under billing and job fade are read, and how to get the schedule ready before you borrow.
Quick Answer
A WIP report lists every open job with its contract value, costs to date, estimated cost to complete and amount billed, and lenders and bond providers read it to see whether the builder has billed ahead of the work or is carrying unbilled work that could squeeze cash. It is defined in our WIP glossary entry, and a current, reconciled schedule makes a business loan, bond or overdraft application easier to assess.
Also called: WIP schedule, work in progress report, job schedule. A construction WIP schedule tracks open contracts, which is different from manufacturing WIP, where the term means stock that is part-made (covered in our manufacturing cash flow post).
What is a WIP report in construction?
A WIP report in construction is a schedule of every open job, showing what each contract is worth, what it has cost so far, what it will cost to finish and how much has been billed. The term itself is defined in our WIP glossary entry; this post is about how the schedule is read when you borrow.
Most builders run it for their accountant or their own job costing. A lender or bond provider reads the same columns for a different reason: it is the report a credit team reads before the accounts, because the accounts can be many months old and the WIP is current.
| Column | What it shows | What a lender typically checks |
|---|---|---|
| Contract value | The agreed price of the job | Size of each job against the size of the business, and concentration with one client |
| Approved variations | Signed changes added to the contract | Whether only signed variations are counted |
| Costs to date | Everything spent on the job so far | Whether costs agree with the accounts and supplier records |
| Estimated cost to complete | What is still to be spent to finish | Whether it has been updated recently or left at the tender estimate |
| Percentage complete | Costs to date as a share of total estimated costs | Whether it matches the physical progress on site |
| Billed to date | Total of every progress claim issued | Whether claims are being approved and paid on time |
| Over or under billed | Billed to date less revenue earned | The size of the gap, the direction, and whether it is explained |
Two columns carry most of the weight. Cost to complete, updated every month, tells the reader whether the margin on a job is still real, and the gap between billed and earned tells them whether cash in the bank belongs to work not yet done. Signed variations matter because an unsigned variation sitting in contract value inflates the job until the client agrees to pay it.
How do you calculate over billing and under billing on a job?
You calculate over billing and under billing by comparing what a job has billed with what its percentage of completion says it has earned. The usual method in construction accounting is cost to cost: costs to date divided by total estimated costs gives the percentage complete, and that percentage applied to the contract value gives earned revenue.
Neither result is good or bad on its own. Being billed ahead of the work is normal on jobs with a deposit or a front-loaded claim schedule, and some under billing is normal when a claim is about to go out. What matters is the size of the gap, whether it is explained, and whether it keeps moving the same way month after month.
Over or under billing a lender can live with
- Over billing that matches a deposit or a front-loaded claim stage
- Under billing that clears when the next claim is issued
- Cost to complete refreshed at every month end
- Variations signed before they enter contract value
Over or under billing that stalls a file
- Over billed cash already spent on other jobs
- Under billing that grows every month
- Cost to complete unchanged since the tender
- Unsigned variations counted as earned
Why do lenders and bond providers ask for a WIP report?
Lenders and bond providers ask for a WIP report because it shows whether a builder's cash position is real or borrowed from work still to be done. From the underwriter's seat, over billing is cash the builder is holding for unfinished work: it looks like liquidity in the bank statements, but it will be spent finishing those jobs.
Under billing is the quieter risk. It is unbilled work the builder is carrying, and it sits in the numbers as an asset until the client is invoiced and pays. A credit team will ask why it has not been billed. A claim about to go out is fine; a dispute or an unapproved variation is not. Persistent under billing across several jobs can also mean cost overruns are being parked as work not yet claimed instead of being written off.
| Position | What it means | How a lender usually reads it | What to have ready |
|---|---|---|---|
| Over billed | Billed ahead of the work | Cash in the account is partly committed to finishing jobs, so it is discounted when judging liquidity | Claim schedules and deposits that explain the gap, and margins that are holding |
| Under billed | Work done but not yet claimed | Earned income that has not been agreed or collected, so it is treated with caution | The date of the next claim, and signed variations for any extra work |
| Roughly even | Billing tracks progress | Cash flow follows the work, which is the easiest position to lend against | A current schedule reconciled to the accounts |
The report also shows concentration: how much of the order book sits with one head contractor or one client, and how much of the coming months is already contracted. Our post on overdrafts covers what work in progress and debtor days tell a lender about an overdraft limit. The point here is that the same schedule drives term loans, equipment finance and bonds as well, and the business loans guide covers how term debt is sized once the schedule is accepted.
What does job fade tell a lender, and how do you stop it?
Job fade tells a lender that the margin a builder priced into a job is shrinking as the job gets closer to finishing. It shows up when estimated cost to complete keeps rising month by month, so a job that looked profitable at the start lands close to break even, or below it.
Lenders read job fade across the whole schedule, not one job. One faded job is a bad job. A pattern of fade on finished work suggests estimating or cost control problems, and it makes the margins on current jobs harder to believe. Where this commonly lands is a lower limit or a request for more security, more often than an outright decline.
What usually causes job fade?
- Late cost to complete updates. Estimates are left at the tender figure until the final month, so the loss appears all at once.
- Missing variations. Extra work is done before the variation is signed, then never recovered.
- Price rises on fixed price work. Subcontractor and supplier increases are absorbed because the contract cannot pass them on.
- Defects and rework. Costs land near practical completion, when there is little contract value left to bill.
The fix is discipline more than paperwork: update cost to complete at every month end from actual commitments, sign variations before the work starts, and close out finished jobs promptly so the report shows real final margins. On larger jobs, an independent quantity surveyor review gives the lender a second view of cost to complete.
How does WIP affect the current ratio and QBCC minimum financial requirements?
WIP affects the current ratio because over billing and under billing change the current assets and current liabilities a builder reports, and in Queensland those figures feed the licensing tests. The QBCC sets minimum financial requirements for licensees, including a current ratio of at least one to one for QBCC licensees, at the time of writing, net tangible assets of at least zero, and enough working capital for the licensee's maximum revenue. Annual financial reports feed those tests, and the smallest sole trader categories (SC1 and SC2) still have to meet them without annual reporting, according to the QBCC page.
The QBCC page does not set out how WIP is treated in those figures, and that treatment is a question for your accountant. What matters for finance is that a lender reading your accounts will often look at the same ratio, and a builder sitting close to the line has less room for a new facility. Other states run their own licensing and home warranty eligibility tests, so check the rules where you hold a licence. For Queensland projects, our Brisbane construction finance post covers how those rules sit around a build.
How does a WIP report change a bond, bank guarantee or overdraft limit?
A WIP report changes a bond or bank guarantee limit because the provider sizes its facility against the work you already have on and how well that work is going. A surety provider reads the schedule to see whether new bonds would sit on top of faded or under billed jobs. The mechanics of headroom and approval are covered in our posts on performance bonds and bank guarantees for civil contractors and cash backed bonds against bank guarantees.
For an overdraft or a business line of credit, the lender is asking whether the limit will be repaid from claims already earned. Clean under billing that clears on the next claim supports a limit; unexplained under billing weakens it, because the lender cannot tell when the cash flow arrives. The business overdraft guide covers how those facilities are structured.
Retentions sit outside the WIP columns but right beside them: a retention is earned but not yet paid. How that gap builds over a run of jobs is covered in how retention holdbacks create a cashflow gap.
How should a builder prepare a WIP report before applying for finance?
A builder should prepare a WIP report for finance by cutting it off at a clear date, updating every estimate and reconciling it to the accounts before a lender sees it.
- Pick a cut-off date. Use the most recent month end, and match it to the bank statements and debtor list you supply.
- Update cost to complete by job. Use committed costs and current quotes, not the tender estimate.
- Get variations signed. Leave unsigned variations out of contract value, or show them separately as pending.
- Reconcile to the accounts. Total over billing and under billing should agree with what your bookkeeper or accountant carries in the balance sheet.
- Explain the outliers. Add a short note for any job with large over or under billing, fade or a dispute, and for any concentration with one head contractor. If you subcontract, show which claims have been checked, as covered in progress claim verification for subcontractors.
Bring the schedule together with the rest of your file using the construction loan pack, and browse the Construction Hub for related reading on bonds, overdrafts and contract finance. When the report is ready, check eligibility for a business loan or speak to a broker about which facility your WIP supports.
A WIP report is the most current picture of a building business a lender gets. Over billing shows cash that belongs to unfinished work, under billing shows work that still has to be claimed and collected, and job fade shows whether the margins are real. Builders who keep cost to complete current, sign variations early and reconcile the schedule to their accounts give a credit team fewer reasons to cut a limit or ask for more security.
Key takeaway: treat the WIP report as a finance document, not accounting paperwork, and have it current and reconciled before you ask for a loan, bond or overdraft.Frequently Asked Questions
A WIP report in construction accounting is the schedule that tracks each open contract's value, costs to date, estimated cost to complete and billings, so revenue can be recognised by percentage of completion. Your accountant uses it to work out over billing and under billing at balance date, and lenders use the same figures to judge current cash. Our WIP glossary entry has the short definition.
You calculate WIP for a construction company job by job: divide costs to date by total estimated costs to get the percentage complete, multiply that by the contract value to get earned revenue, then compare earned revenue with what has been billed. The difference is over billing or under billing, and the totals across all jobs go into the accounts. A quantity surveyor or your accountant can test the estimates behind cost to complete.
A builder can sometimes borrow against work in progress that has not been billed, but most lenders lend against a claim once it is issued and approved, not against the unbilled work itself. Unbilled work is harder to value because the client has not agreed it, so it usually supports a facility indirectly through stronger cash flow rather than as security. The same question for professional firms is answered in our professional services working capital post.
Over billing is generally recorded as a current liability on the balance sheet, because the builder has been paid for work it still has to do, while under billing is generally recorded as a current asset. That is why both move the current ratio that lenders and the QBCC read. How your own accounts treat them is a question for your accountant.
Surety providers do look at over billing, because it shows how much of a builder's cash is already committed to finishing current jobs. Moderate over billing on jobs with healthy margins is usually read as normal, while large over billing alongside job fade suggests the cash may not cover the work left to do. Our post on performance bonds and bank guarantees for civil contractors covers how bond limits are assessed.