ChamberOne

WIP ageing and cash flow: a monthly routine

By the ChamberOne team 4 minute read

A law firm can be busy, profitable on paper and short of cash. The usual reason is that time worked has not been billed, or bills have been sent and not paid. Both are invisible unless someone looks. A monthly routine that ages work in progress and unpaid invoices shows where money is stuck and who needs a conversation. It takes a couple of hours once it is established. This article describes the steps, the questions to ask and where AI can help without making financial decisions for you.

Key points

  • Age both unbilled WIP and unpaid invoices using the same bands every month.
  • Put a name next to every large old balance and agree one action with a date.
  • Use billing cut-offs with three clear options: bill, write down with a reason, or defer with approval.
  • Let AI draft narratives and reminders, but keep fees, write-downs and disputes with people.
  • Keep client money separate from the cash-flow review and follow your accounts rules.

Two pools of money waiting to move

Work in progress, usually shortened to WIP, is time and costs recorded on matters that have not yet been billed. Receivables are invoices that have gone out and are unpaid. Cash arrives only when the first becomes the second and the second is paid.

Each pool ages. Unbilled time is harder to bill the longer it sits, because memories fade and clients forget what they asked for. Unpaid invoices are harder to collect the longer they stay unpaid. Ageing simply means grouping each pool by how old it is, so that the oldest and largest items stand out.

Set the buckets

Choose age bands that suit your billing rhythm. Many firms use bands such as under thirty days, thirty to sixty, sixty to ninety and over ninety, and apply them to both WIP and receivables. What matters is that the bands are the same every month so that you can compare.

Run two reports: unbilled time by matter and age, and unpaid invoices by client and age. If your system cannot produce them, a spreadsheet export will do for now. Add a column for the responsible fee earner, because every number should have a name next to it.

The monthly meeting

Keep it short and fixed. An hour with the managing partner, the finance manager and heads of practice groups is typical for a mid-sized firm. In a small firm, it may be two people and a coffee.

  • Look at the totals for each age band and compare to last month.
  • List the ten largest old WIP balances and ask why each has not been billed.
  • List the ten largest overdue invoices and ask who has contacted the client and what was said.
  • Agree one action per item, with a name and a date.
  • Note any client whose behaviour has changed, such as paying late for the first time.
  • Record decisions in a short note and review it at the start of the next meeting.
  1. 1Compare the totals for each age band with last month
  2. 2Question the ten largest old balances in each pool
  3. 3Agree one action per item, with a name and a date
  4. 4Record decisions in a short note
  5. 5Review the note at the next meeting
  6. Then back to step 1.
The monthly WIP and receivables meeting

Billing cut-offs

A cut-off is a date after which unbilled time is reviewed whether or not the matter is ready for a bill. It prevents the habit of waiting for a perfect moment. For ongoing matters, a regular billing date, agreed in the engagement letter where appropriate, makes bills predictable for both sides.

Decide what happens at the cut-off. Fee earners might have to bill, write down with a reason, or ask for a deferral approved by a partner. Having three options makes the conversation easier and creates a record.

Reviewing the exceptions

Most balances are routine. The exceptions are where cash is lost. Typical ones are time recorded on a matter that has gone quiet, a bill held back because the fee earner is unsure of the number, a client disputing part of an invoice, and fixed-fee matters where costs have overrun.

For each exception, ask three questions. What is the obstacle? Who can remove it? By when? An overdue invoice that is stuck because the client has an unanswered query is not a collection problem. It is a service problem, and the fix is a reply from the lawyer.

Where AI can help

AI can read time entries and draft bill narratives from them, which shortens the delay between work and invoice. It can summarise a matter's activity so that a partner can decide quickly whether a bill is ready. It can also draft polite reminder wording for overdue invoices.

It should not decide write-downs, set fees or decide how to treat a disputed bill. Those are commercial and professional judgements. Any narrative it drafts must be read by the fee earner for accuracy, because a bill is a statement to the client and, in some places, a regulated document. Check the guidance from your regulator or bar on billing and client communication.

AI can draft
  • Bill narratives from time entries
  • A summary of a matter's activity
  • Polite reminder wording for overdue invoices
People decide
  • Write-downs and fees
  • How to treat a disputed bill
  • Whether each narrative is accurate before it goes out
Billing tasks for AI and for people

Fixed fees and milestone matters

Hourly matters age through unbilled time. Fixed-fee and milestone matters age differently: the risk is that a milestone has been reached and nobody has raised the invoice, or that costs have overrun the fee and nobody has noticed. Add a column to the WIP report showing, for each fixed-fee matter, the next milestone, whether it has been met and how much time has been recorded against the fee.

A fee earner who sees recorded time approaching the fee early can raise it with the client, renegotiate scope or accept the overrun knowingly. One who sees it at the end can only absorb it.

Client money is separate

Money held for clients is not part of the firm's cash flow and must not be treated as such. Keep client money records and reconciliation separate from the WIP and receivables review, and follow the accounting rules that apply to you. If your system has a client money ledger, remember that a ledger on its own does not make a firm compliant with professional accounts rules.

A hypothetical first month

Suppose a six-lawyer firm runs the routine for the first time. It finds that a large share of old WIP sits in three matters whose fee earner is on leave, and that two long-standing clients have invoices past the age bands. The managing partner reassigns the three matters for a billing review, calls both clients personally and agrees a payment date with one. Nothing clever was needed. The routine simply put the numbers in front of someone who could act.

Time and billing in ChamberOne

  • Record time with the timer in the top bar, or use the finder for work you did but did not log.
  • Apply rate cards, fixed fees, per-appearance fees or milestones, and put the invoice through approval.
  • Send statements and payment reminders.

What it does not do

  • It does not decide write-downs or fees. Those stay with the firm.
  • The client-money ledger has not been assessed against any professional accounts rules and does not by itself make a firm compliant with them.
  • Prices shown on the site exclude tax.

This article is general information about the law, legal practice and technology, current when it was published. It is not legal advice. Laws and guidance change: check the sources linked above and take advice on your own circumstances from a lawyer qualified where you are.

Read next

WIP ageing and law firm cash flow: a monthly routine