Work in Progress and Lockup

A measured lockup baseline, agreed targets, payment terms that work, weekly credit control, monthly WIP reviews and the campaigns, policies and forecasts that turn unbilled time and old invoices into cash.

Free · Mac (Apple silicon) and Windows · v1.0.5 · Other platforms

Then open the Marketplace in the app, search for Work in Progress and Lockup, and click Install. It goes into your own files, and works offline from then on.

Before you start: this plan is general information to help you organise decisions about money. It is not financial, investment, tax or legal advice, and it does not recommend any product, investment or deal. Rules differ between countries, so check decisions that matter with a qualified, licensed adviser in yours. Investing and trading can lose money, and raising or managing other people's money is regulated in most countries.

What it installs.

1

Pillar

1

Area

50

Projects

200

Starter tasks

🔑 Professional Practice Ownership

Work in Progress and Lockup

Reducing the cash tied up in a practice: unbilled work in progress, debtor days, billing cycles, payment terms and chasing old invoices.

  1. Lockup baseline from the last twelve months
  2. Agreed lockup formula and definitions
  3. WIP and debtor ageing reports
  4. Lockup targets by partner and work type
  5. Payment terms in engagement letters
  6. Credit control owner and escalation ladder
  7. Credit check before accepting a new client
  8. Billing contact and purchase order details at intake
  9. What a day of lockup costs the practice
  10. Clean-up of stale WIP and uncollectable debts
  11. Lockup checks on matter closure
  12. Weekly aged debt chase list
  13. Monthly WIP review with each partner
  14. Monthly lockup report to the partners
  15. Unbilled WIP threshold alerts
  16. Monthly statements of account
  17. Unallocated cash and remittance matching
  18. Quarterly bad debt provision review
  19. Disputed invoice log
  20. Client payment plan register
  21. Quarterly top-client lockup review
  22. Making the collection call
  23. Reading an aged debtor report
  24. How WIP is valued in the accounts
  25. Chase letter and email sequence
  26. Late payment interest and recovery rights
  27. Negotiating terms with large corporate clients
  28. Lockup briefing for fee earners
  29. Ninety-day lockup reduction campaign
  30. Money on account policy for new matters
  31. Online payment links on invoices
  32. Direct debit for fixed monthly fee clients
  33. Stop-work and file release rules for unpaid fees
  34. Choosing a collection agency or debt recovery firm
  35. Lockup in the partner scorecard
  36. Funding third-party costs and disbursements
  37. Year-end WIP count and debtor cut-off
  38. Pre-holiday billing and collection push
  39. Bank or lender review of the debtor book
  40. Taking a debt to small claims or court
  41. When a client becomes insolvent
  42. Lockup routine for a sole practitioner
  43. Payment applications and retentions for design firms
  44. Seasonal lockup in an accounting firm
  45. Long-running and contingent matters in a law firm
  46. Lockup during rapid growth or a new office
  47. Lockup in the cash flow forecast
  48. Invoice finance and fee funding options
  49. Lockup benchmarking against peer firms
  50. Sizing working capital from lockup

Where it starts.

Each project arrives with its purpose, milestones and first tasks written out. Here is how the first three read.

Lockup baseline from the last twelve months

Few owners can say how many days of fees are tied up in their practice, yet the figure often runs to 120 days or more once unbilled time and unpaid invoices are added together. Working out WIP days and debtor days for each of the last twelve month ends gives a starting number, shows whether it is drifting, and tells you which half of the problem is bigger.

First tasks

  • Export the month-end WIP and debtor totals for the last twelve months
  • Pull monthly fee income from the management accounts for the same months
  • Calculate WIP days, debtor days and total lockup for each month end
  • Write a one-page summary of the trend for the partners

Agreed lockup formula and definitions

Two partners can argue for an hour about lockup and discover they were measuring different things: one uses gross WIP at charge-out rates, the other WIP after expected write-offs, and neither agrees whether disbursements count. Writing down one formula, the averaging method and what is included means every later report is trusted and compared like with like.

First tasks

  • List how each partner currently describes lockup and debtor days
  • Compare the count-back and simple average methods on last month's figures
  • Draft the inclusion rules for disbursements, tax, money on account and suspense cash
  • Put the definitions to the partners for approval and file the agreed version

WIP and debtor ageing reports

A single total hides the difference between a matter billed every month and one with two years of unbilled time behind it. Setting up two ageing reports, WIP by age of the oldest unbilled entry and debtors by invoice date, in bands of 0 to 30, 31 to 60, 61 to 90, 91 to 180 and over 180 days, shows where the money is stuck and who is responsible for it.

First tasks

  • Check which ageing reports the practice system already offers
  • Set the five age bands on the WIP report by date the work was done
  • Build the debtor ageing report by client and invoice date
  • Reconcile both report totals to the month-end ledger

Make it yours.

Install Work in Progress and Lockup, then tell Aurum the date you're aiming for. It checks whether the plan fits the weeks you actually have.

Free · Mac (Apple silicon) and Windows · v1.0.5 · Other platforms

Blueprints are general information to help you organise your own work. They are not medical, financial, legal or other professional advice. See the Terms.