The problem
In many professional services and project-based businesses, work in progress (WIP) builds up across multiple systems: time recording, practice management, project accounting, billing platforms and finance spreadsheets. Finance teams typically pull exports, paste them into spreadsheets, age the balances manually and chase partners or project managers for billing decisions.
Billing exceptions — unbilled time beyond agreed thresholds, fixed-fee overruns, missing rate cards, expenses not on-charged, or matters with no recent activity — are often only spotted late, if at all. The result is a slow, manual, reactive process that depends heavily on individual reviewers and spreadsheets that are difficult to audit.
Why it matters
Aged WIP is one of the most common sources of margin leakage. Time that sits unbilled for too long is significantly more likely to be written off, discounted or disputed. It also distorts profitability reporting, delays cash collection and creates uncomfortable conversations at month-end.
From a control perspective, billing decisions made informally in email or spreadsheets are hard to evidence. Leadership wants confidence that WIP is being actively managed, exceptions are being reviewed, and write-offs are deliberate rather than accidental.
The opportunity
A no-code, governed workflow can bring together time, billing, project and finance data into a single view of WIP and exceptions. Business logic can flag the cases that matter — by age, value, client, partner, matter type or fee arrangement — and route them to the right reviewer with clear options and an auditable trail.
Where helpful, AI can support reviewers by summarising matter activity, suggesting likely billing actions based on history, and drafting commentary for partner review. The aim is not to remove judgement, but to make the judgement faster, more consistent and better evidenced.
Example workflow
1. Connect the source data
Pull time entries, WIP balances, billing history, matter or project metadata and rate cards from the relevant systems. This typically includes a practice management or PSA platform, the finance ledger and any spreadsheets used for fee arrangements.
2. Standardise and prepare the data
Normalise client, matter, partner and fee-earner references. Apply consistent ageing buckets, currency conversion and fee arrangement tagging so that every line of WIP can be analysed on the same basis.
3. Apply business logic
Define the exception rules that matter to the business. Examples include:
- WIP older than a defined number of days
- WIP value above a threshold with no recent billing
- Fixed-fee matters where WIP exceeds the agreed fee
- Matters with time recorded but no rate applied
- Expenses not on-charged within an agreed window
4. Run checks and controls
Validate data completeness, flag missing rates, duplicate entries, and matters with inconsistent status. Highlight anything that should not be in the WIP population before it reaches a reviewer.
5. Produce outputs
Generate a partner or project manager pack showing their aged WIP, exceptions and suggested actions. Provide a leadership dashboard showing total WIP, ageing profile, exception volumes and trend.
6. Review exceptions
Route each exception to the right reviewer with clear options: bill now, hold with reason, write down with reason, or escalate. Capture the decision, the rationale and the reviewer in a structured way. AI-generated matter summaries can be offered to support the decision, but the decision itself is human.
7. Move to governed operation
Run the workflow on a defined cadence (weekly or monthly), with version-controlled rules, documented approvals and an audit trail of every exception, decision and write-off.
What good looks like
- A single, trusted view of WIP across all systems
- Exception rules that reflect the firm’s actual commercial policy
- Clear ownership of each exception by partner, project manager or matter lead
- Decisions captured with reason codes, not buried in email
- Audit-ready evidence of who reviewed what, when and why
- Leadership reporting that shows trend, not just a point-in-time snapshot
- AI used to assist reviewers, not to make billing decisions
Benefits
For the business team
Finance and billing teams spend less time preparing spreadsheets and chasing reviewers, and more time on genuine exceptions. Partners and project managers get a focused list rather than a full WIP report to wade through.
For leadership
Clearer visibility of WIP ageing, exception volumes and write-off patterns. Confidence that billing decisions are being made deliberately and consistently, with evidence to support audit and partner discussions.
For the wider business
Faster billing, improved cash collection, fewer disputed invoices and better-informed conversations about fee arrangements, scope and profitability.
Where to start
Start with a single practice area, division or project portfolio where aged WIP is known to be a problem. Agree two or three exception rules that matter most — typically age, value and fixed-fee overrun — and build the first version of the workflow around those. Prove the value, then extend the rules, the coverage and the reviewer experience.
How 4th Revolution can help
4th Revolution is finance-led and data-led. We specialise in no-code automation and embedded AI for finance, operations and leadership teams. We understand WIP, billing, fee arrangements and the practical realities of getting partners and project managers to engage with exceptions.
Our goal is not just to build a workflow. It is to create a governed, repeatable process — with clear rules, clear ownership, clear evidence and the right use of AI to support reviewers rather than replace them.
Example outcome
Before: Finance pulls a WIP export each month, ages it in a spreadsheet, emails partners individually and chases responses. Older WIP is frequently written off at year-end with limited explanation.
After: A weekly workflow surfaces aged WIP and billing exceptions to the right reviewer, with suggested actions and structured decision capture. Leadership sees trend reporting on WIP ageing and exception volumes. Write-offs become deliberate decisions, evidenced and explained, rather than a year-end surprise.