Utilization and profit
Unbilled Work in Progress: Why It Builds up and How to Bill Sooner
Unbilled work in progress is work an engineering firm has done and not yet invoiced. Every week it waits is a week the firm pays salaries for it out of its own cash.
On this page
Terms Used
- Unbilled work in progress (WIP): work done on projects and not yet invoiced, valued at the rates the firm will bill.
- Receivables: invoices sent and not yet paid.
- Days of unbilled work: unbilled work divided by average daily fees.
- Days to collect: how long invoices take to be paid, on average.
What It Is
Unbilled work in progress, often shortened to WIP, is the value of hours and expenses the firm has already spent on projects and not yet invoiced. On the balance sheet it is an asset. In the bank account it is salaries paid for work the client has not been asked to pay for.
Measure It in Days
Days of unbilled work = unbilled work ÷ average daily fees
For example, a firm that earns $250,000 of fees a month earns about $8,200 a calendar day. If $205,000 of work is unbilled, that is 25 days of work waiting to be invoiced. Add the days it then takes clients to pay, and the firm may be funding two months of salaries before the money arrives.
Track the number weekly, and by project. A firm-wide total hides the two or three projects holding most of it.
From Work to Cash
Unbilled work is the first half of a longer wait. The second half is the time clients take to pay. Together they say how long the firm carries each dollar of work before it sees the cash.
| Example, round numbers | Days | Cash tied up |
|---|---|---|
| Unbilled work in progress | 25 | $205,000 |
| Receivables | 45 | $370,000 |
| From work to cash | 70 | $575,000 |
In this example, at about $8,200 of fees a day, every day cut from either wait frees about $8,200 of cash, and a week frees about $57,500. That cash comes from the firm’s own work, with no new client, loan or price change behind it. Unbilled work is usually the easier half to shorten, because the firm controls when it invoices and the client controls when it pays.
Why It Builds Up
- Invoicing waits for the month-end. Work done on the 2nd waits almost a month to be invoiced, and the client’s payment terms only start then.
- Invoices wait for a review. A project manager who is busy on projects reviews invoices last.
- The contract does not say when to bill. Without milestones or a monthly billing clause, the firm waits for a natural stopping point.
- Hours sit in the wrong place. Time charged to an internal or general code has to be moved before it can be billed, and often is not.
- The work is outside scope. Extra work that was never agreed as additional services has no invoice to go on.
- The client needs something first. A purchase order number, a signed change, a report in their format: each one holds the invoice until it arrives.
Habits That Turn It into Cash Sooner
- Bill on a fixed day. The same day each month, or each fortnight on large projects where the contract allows it, rather than waiting for a phase to finish.
- Agree billing in the proposal. Monthly invoicing by percent complete, or named milestones, written into the fee proposal and the contract.
- Make the review small. Send each project manager a draft invoice built from the timesheets, so the review takes minutes.
- Close timesheets first. Invoices built from incomplete timesheets either wait or go out short. See timesheets.
- Ask for what the client needs at the start. Purchase order, invoice format, who approves: collected when the contract is signed, not when the first invoice bounces.
- Follow up on schedule. A reminder before an invoice is due, and a call when it passes, so days to collect do not drift.
A Weekly Unbilled Report
One page, one row per project with unbilled work, sorted by amount, with what is holding each one and who will clear it.
| Example | Unbilled | Oldest hours | Holding it | Who clears it |
|---|---|---|---|---|
| Project D | $62,000 | 7 weeks | Change not signed | Project manager, with the client |
| Project A | $41,000 | 3 weeks | Invoice waiting for review | Project manager, this week |
| Project F | $18,000 | 2 weeks | Next billing day | Nobody: on schedule |
The “oldest hours” column matters as much as the amount. Hours that have sat unbilled for weeks are the ones most likely never to be billed at all.
Old Unbilled Work Is a Write-Off Waiting to Happen
Unbilled work that keeps getting older is often not waiting for an invoice at all. It may be work the client won’t accept: hours over a fixed fee, a revision nobody agreed to pay for, time on a project that has gone quiet. Left in WIP, it makes the balance sheet look stronger than the firm is.
Review the aged unbilled work once a month. For each old item, decide: bill it this month, raise it with the client as a change, or write it off and record why. A write-off taken on purpose is information for the next fee; one discovered at year-end is a surprise. It also shows up in realization, which is where the partners should see it.
Fixed-Fee Projects: Ahead or Behind on Billing
On a fixed-fee project billed by percent complete, the firm can bill ahead of the work or behind it. Billing behind leaves work unbilled. Billing ahead means the firm has invoiced work not yet done: once the client pays, it is cash in hand for work still owed; until then, it is a receivable for work still owed. Neither is wrong for a month; both are wrong if they persist. Compare each project’s billing with its percent complete every month, from the same figures as the weekly budget check. How the difference is shown in the accounts is a question for your accountant.
Progress Billing
Progress billing means invoicing a project in parts as it advances: by percent complete, by milestone, or for the hours worked each month on an hourly project. It is the most direct way to keep unbilled work low on long projects. On construction-related work in Ontario, check how the Construction Act’s rules on holdback and payment timing apply to your contract; your lawyer can confirm.
The Number to Watch Beside It
Unbilled work and receivables together are the firm’s working capital tied up in its own projects. When the firm is busy, both grow, which is why cash can run short in a good year. Watching them weekly, beside utilization and project budgets, shows where those surprises come from. Our article on engineering firm KPIs puts all of them on one page.
Common Unbilled Work Mistakes
- Measuring it only at month-end. By then a month of work has piled up, and the reasons are hard to recall.
- Reading only the total. A few projects can hold most of it, and the total hides them.
- Leaving old hours in WIP. Work the client won’t pay for is a write-off, whatever the balance sheet says.
- Waiting for a “natural” stopping point. Long phases have none; bill on the calendar, within the contract’s billing terms.
A Checklist for Unbilled Work
- Write the billing terms into every proposal and contract: monthly, or named milestones.
- Collect the client’s invoicing needs when the contract is signed.
- Close timesheets on the same day each week.
- Send project managers draft invoices built from the timesheets.
- Bill on a fixed day, within the contract’s billing terms.
- Report unbilled work weekly by project, with its age and what holds it.
- Review aged unbilled work monthly: bill it, raise it, or write it off.
- Watch days of unbilled work and days to collect together.
How We Approach This
Billing and collections are part of our performance work: work billed on time, and invoices followed up before they age. Unbilled work sits on the same weekly page as utilization and project budgets, built from your own timesheets and invoices.
Questions
What Is the Difference Between Unbilled Revenue and Work in Progress?
At an engineering firm they usually mean the same thing: work done that has not yet been invoiced. Some accountants keep “work in progress” for unfinished projects and “unbilled revenue” for work finished but not invoiced.
How Do You Reduce Unbilled Work?
Invoice on a set day each month, agree billing milestones in the contract, and track what holds invoices up, such as a missing approval or a project manager’s review.
How Do You Calculate Days of Unbilled Work?
Divide unbilled work by average daily fees. For example, $205,000 unbilled at about $8,200 of fees a day is 25 days (205,000 ÷ 8,200).
What Is Progress Billing?
Invoicing a project in parts as the work advances, by percent complete or by milestone, instead of at the end.
When Should Unbilled Work Be Written Off?
When the client won’t pay for it: hours over a fixed fee, a revision nobody agreed to pay for. Decide each month, and record why, so the next fee is better.
Updates
- : Rewritten at full length: from work to cash with a worked example, a weekly unbilled report, old unbilled work and write-offs, billing ahead or behind on fixed fees, common mistakes and a checklist.