WIP / Unbilled Revenue Calculator
A WIP unbilled revenue calculator shows how much money your agency has earned but hasn't invoiced yet. Enter each active project, the hours worked or value of work completed since your last invoice, and your bill rate. It totals your work-in-progress revenue across all open projects and tells you how long that money has been sitting unbilled.
WIP / Unbilled Revenue Calculator
How much your agency has earned but not yet invoiced, across all active projects.
Active projects
Total unbilled WIP
$5,280
If invoiced today, expect payment around June 18, 2026.
Close the gap between work done and invoice sent.
Ascend tracks hours against each project automatically and generates invoices from those hours — so billing doesn't require a separate admin step. Free plan included.
Share this exact scenario
Generates a permanent URL with these inputs pre-filled.
How to read your result
Total WIP is the raw number: real money your agency earned that hasn't turned into an invoice. It's not hypothetical — the work is done. The cash just hasn't been claimed yet.
Aging is the signal to act on. WIP that's a week old is a normal billing cycle. WIP that's 45 days old is a loan you're extending to your client, interest-free. The longer it ages, the harder it becomes to recover — clients forget what the work covered, disputes surface, and the further you get from a large invoice date, the more awkward it feels to send.
Projected cash receipt tells you when the money arrives in your account if you invoice today and your clients pay at their normal pace.
How WIP revenue is calculated
For hourly projects: multiply the uninvoiced hours by your bill rate. For fixed-price projects: estimate the value of work completed as a percentage of the total fee, and enter that dollar amount. Sum across all projects. That total is your WIP. The formula is simple; getting the inputs right — honest hours, honest completion estimates — is the hard part.
A worked example
A small brand studio has three active projects:
- Client A (hourly): 18 hours unbilled at $120/hour = $2,160 WIP. Last invoiced 12 days ago.
- Client B (fixed): $8,500 project, 60% complete, last invoiced at 30%. Earned but uninvoiced value: 30% × $8,500 = $2,550 WIP. Last invoiced 31 days ago.
- Client C (hourly): 6 hours at $95/hour = $570 WIP. Last invoiced 5 days ago.
Total WIP: $5,280. Average payment days: 28. If all three are invoiced today, expect $5,280 in the account in roughly four weeks.
Client B is the flag. At 31 days since the last invoice it is approaching the point where the studio is carrying over a month of their fee. Send that invoice today.
The gap between "busy" and "paid"
Most agency cash-flow problems don't start with a bad month. They start with good months that don't get invoiced on time. Work piles up. The studio is busy, the client is happy, the invoicing gets pushed to "end of the week" and then to "next Monday." Four weeks later there's a real cash gap — not because the revenue isn't there, but because it's sitting as WIP.
A WIP / unbilled revenue calculator makes the gap visible. It doesn't change the billing — it tells you what to invoice and pushes back on the instinct to delay. The best billing practice is the simplest: invoice the moment a milestone is reached, not at the end of the month when it's convenient.
To see the full cash-flow picture, pair this tool with the agency financial runway calculator.
Frequently asked questions
What is WIP (work in progress) revenue for an agency?+
WIP revenue is money your agency has earned — by completing work — that you haven't yet sent an invoice for. The work is done; the cash hasn't been claimed. It sits between "delivered" and "billed" and creates a timing gap in your cash flow.
How do I calculate unbilled revenue?+
For hourly work: multiply uninvoiced hours by your bill rate. For fixed-price projects: estimate the percentage of the project complete, multiply that by the total fee, and subtract what you've already invoiced. Add all projects together to get your total WIP.
Is WIP the same as accounts receivable?+
No. Accounts receivable is money invoiced but not yet paid — you've billed the client and are waiting for payment. WIP is money earned but not yet invoiced — you haven't billed yet. Both affect cash flow; they just sit in different stages of the billing cycle.
How long is too long to leave WIP unbilled?+
As a general rule, any earned work older than 30 days that hasn't been invoiced is a cash-flow risk. For retainer work, invoice on the same date each month. For project-based work, invoice at each completed milestone rather than at the end.
What causes WIP to build up at agencies?+
Usually a combination of: milestone billing at the end rather than as work is completed, scope additions that aren't tracked or billed, fixed-fee projects where completion is estimated late, and administrative delays in the invoicing step.
Why does high WIP mask a cash-flow problem?+
Because your P&L may show revenue recognised (when the work was done) while your bank account shows nothing. High WIP means the business looks fine on paper but is operationally cash-light — especially dangerous if a large client delays a payment.
How does Ascend help with WIP?+
Ascend tracks time against every project record as the work happens and generates invoices from those tracked hours. That means the gap between "work done" and "invoice sent" can be near-zero — you invoice directly from the time log without a separate admin step.
Related tool
Agency Financial Runway Calculator
Collecting your WIP is step one of extending your runway. See how many months your agency can operate at current burn.
Close the gap between work done and invoice sent.
Ascend tracks hours against each project automatically and generates invoices from those hours — so billing doesn't require a separate admin step. The free tier covers one client end to end.
Start with Ascend free