WIP in Professional Services: How to Track It Without Spreadsheets

In professional services, work in progress or WIP usually refers to work delivered but not yet invoiced. It can also include accrued revenue, depending on your accounting policy. Either way, WIP sits between delivery and cash. It shows effort that clients have not paid for. It can also hide problems that teams avoid discussing.

Many firms feel busy, yet cash stays tight. WIP often explains that mismatch. You can reduce WIP, but you must track it clearly. Spreadsheets feel flexible, yet they create new risks. They drift, break, and lose context.

If you want one source of truth, start with one single accounting and reporting system for professional services. This supports controlled workflows and consistent reporting. It also reduces offline adjustments and version confusion. You can then manage WIP with shared definitions and reliable data.

What WIP means in professional services accounting

WIP grows when you deliver work before you invoice it. That pattern feels normal in many service-based firms. It still creates risk and delays cash. Each day of unbilled delivery increases exposure to dispute. It also reduces the accuracy of project profitability reporting.

Most firms benefit from splitting WIP into separate queues. One queue rarely tells the full story. Different WIP types come from different process failures. Each type needs a different owner and workflow. When you blend them, you fix the wrong problem.

The table below helps you separate WIP types. It also links each type to a first practical control. Use it during WIP reporting reviews to reduce debate. Shared definitions improve trust in the numbers. Trust then drives better behaviour across finance and delivery.

Type of WIP	What it looks like	Typical cause	Best first fix
Unbilled time	Approved hours, not yet invoiced	Billing delays, weak narratives	Shorten billing cadence, enforce narratives
────────────────────────────────────────────────────────────
Unbilled expenses	Posted costs, not yet invoiced	Missing receipts, slow approvals	Receipt rules, faster approvals
────────────────────────────────────────────────────────────
Accrued revenue	Revenue recognised before invoicing	Unclear milestones, weak evidence	Define milestones, attach evidence

When you split WIP like this, action becomes easier. You can assign owners by queue and remove confusion. You can also report each queue with the right context. That prevents one number from hiding multiple causes.

What creates WIP and why it stays hidden

WIP grows when delivery moves faster than admin processes. Delivery teams often optimise for utilisation and deadlines. Finance teams optimise for controls and accuracy. Project managers sit between both pressures. Without a clear workflow, WIP becomes the buffer.

Once WIP becomes normal, it hides in plain sight. People stop challenging ageing and delays. Billing teams chase data instead of issuing invoices. Leaders then see high activity with low cash movement. That creates stress and reactive decisions.

Late timesheets push unbilled work into limbo

Timesheets drive billing in many professional services models. When people submit time late, billing stalls. When managers approve late, billing stalls again. Finance then spends time chasing entries, not billing work. The month-end rush makes things worse.

Late entry reduces detail and weakens descriptions. People forget what they did after a few days. They then write vague notes that clients challenge. Disputes rise, and write-offs follow. WIP then becomes a symptom of weak habits.

Daily entry with the support of a dedicated time entry app usually beats weekly memory, because it prompts timely capture and improves description quality. Clear task codes also help, as they match client language. Your PSA system should support prompts, approvals, and missing time alerts. A same day time-entry policy strengthens that habit and keeps WIP from drifting. The white paper on time-entry patterns explores this idea in more detail.

The list below outlines controls that reduce timesheet-driven WIP. It focuses on practical routines that teams can maintain. Use it to agree a standard with delivery leaders. It also reduces the need for chasing emails.

Set a daily submission norm for client-facing staff, and make it visible. This improves accuracy and reduces rework.
Use task codes that match client language and statements of work. This makes invoices easier to defend.
Set description rules for time entries. This reduces write-offs during billing.
Escalate missing time by project impact, not personal criticism. This keeps focus on cash and delivery risk.
Share a weekly compliance view with leaders and team leads. This supports coaching and early intervention.

These controls work best when people see the benefit. Link compliance to faster invoicing and fewer disputes. Recognise teams that improve, not just those that fail. Over time, the admin effort drops and billing becomes routine.

Unapproved expenses block billing and distort project margin

Expenses create another WIP queue, and it often moves slower. Receipts go missing and approvals sit in inboxes. Costs then post to projects, yet invoices do not follow. Project margin looks worse than reality, which drives poor decisions.

Clients also challenge late expense charges more often. They forget the context and dispute value. This creates avoidable friction and delays payment. Fixing expense WIP needs clear rules and fast workflow. Define what “complete” looks like for every claim.

Require the correct job, category, and business purpose. Set a receipt timing rule that fits your teams. Then automate reminders and routing where possible. Better process reduces WIP ageing and protects margin.

WIP ageing, WIP reviews, and write-offs

WIP ageing tells you where risk concentrates. New WIP can be healthy, depending on your billing model. Old WIP tends to become a dispute or a write-off. It also consumes senior time, which you cannot recover. Many firms review WIP monthly, which is too late.

Weekly review works better for professional services. It keeps issues small and visible. It also prevents unpleasant surprises during close. Ageing helps you spot systemic issues, not just project noise. A project with 60-day WIP often signals scope or approval problems.

A WIP review meeting should feel operational, not punitive. Keep it short and consistent each week. Use the same data cut and definitions every time. Focus on the oldest items by value and risk. Assign owners and deadlines, then track completion next week.

The agenda below supports a disciplined weekly review. It turns WIP into actions, not abstract figures. It also keeps finance and delivery aligned. Use it as a template, then adjust to your firm.

Review total WIP by type and by ageing band.
Highlight the ten oldest items by value and dispute risk.
Agree an invoicing plan for each item, with a date.
Confirm missing evidence, such as descriptions and receipts.
Escalate blockers, such as change approval or client sign-off.
Propose write-offs with reason codes and lessons learned.

This agenda builds rhythm and accountability. It also improves forecasting, because plans stay explicit. When teams repeat the cycle, old WIP shrinks. Cash improves, and month-end becomes less painful.

Write-offs usually come from weak scope control or poor evidence. If you cannot explain the work, you cannot defend the invoice. If you cannot link it to scope, you struggle to bill it. Faster approvals help, but they do not solve weak documentation.

WIP metrics and ERP controls that replace spreadsheets

Spreadsheets feel quick, yet they create hidden costs. They weaken audit trails and segregation of duties. They also encourage offline adjustments that nobody can explain. A better approach keeps the ERP for professional services as the single source of truth. You then use workflow, approvals, and reporting to drive action.

To improve invoicing speed, many firms standardise billing routines and tools. If you want a structured approach to billing and approvals, explore project billing software. It supports controlled billing cycles and clearer WIP status. It also improves auditability compared to spreadsheet-led processes.

Missing change approvals delay invoices and fuel disputes

Change control sits at the heart of WIP control. Many write-offs start as unapproved change. Delivery teams do extra work to maintain momentum. They plan to sort it later with the client. Later rarely arrives cleanly.

You can reduce this risk with a repeatable process. Define what counts as change using plain language. Require a change request before extra work begins. Capture client acceptance in the same record. Link the change to budget, schedule, and billing plan.

Good change control also depends on daily coordination and clear task ownership. If work moves across teams, you need consistent handovers and visibility. You can support that discipline with work management. Consider a tool built for professional services that tracks work items, progress, and time in one place.

To keep reporting focused, track a small set of WIP metrics. These measures should drive weekly behaviour, not create dashboard noise. Trends matter more than one snapshot. Compare by practice, client, and project manager. Then ask why when a trend worsens.

Three metrics usually give the clearest signal. WIP days shows how long cash stays trapped. Write-off rate shows the cost of weak control. Billing cycle time shows process speed from approval to invoice. Track each metric by WIP type where possible. That prevents one metric from hiding different causes.

You can build these measures from standard project accounting data. You need consistent time and expense capture. You also need approval timestamps and clear status fields. Use reason codes for write-offs and disputes. Reconcile WIP to revenue on a predictable cadence.

Conclusion

WIP is not just an accounting concept. It is a signal for cash, delivery risk, and process health. Split WIP into unbilled time, unbilled expenses, and accrued revenue. Review ageing weekly and focus on the oldest items first. Use clear owners, actions, and deadlines to unblock invoicing.

Replace spreadsheets with ERP-driven workflow and consistent definitions. Track WIP days, write-off rate, and billing cycle time as trends. Use those trends to find root causes early. If you halved your oldest WIP, what would change in your cash position? Get in touch. ↗