How to Track Unbilled WIP and Client Billing in a Spreadsheet

Accounting and consulting firms stockpile work in progress — hours logged, not yet invoiced — until month-end becomes a scramble or old WIP gets written off. A free WIP and billing tracker spreadsheet shows unbilled WIP, hours, rates, and invoiced amounts per client.

Client-level WIP roll-up

For each engagement:

1. Client and project
2. Hours logged (period or cumulative)
3. Standard rate or agreed fee
4. WIP value — hours × rate or percent complete on fixed fee
5. Invoiced to date
6. Remaining WIP — billable work not yet on an invoice

Review weekly in firms with tight cash flow; monthly minimum for everyone else.

Realization vs. utilization

Utilization = hours worked. Realization = hours actually billed and collected. The sheet highlights WIP aging — entries older than 30 days often indicate scope creep, client hesitation, or forgotten billable tasks.

Law firms logging attorney time should start with billable hours entries; this tracker is the client WIP dashboard above raw time logs.

Invoice from WIP, not from guilt

Set a rule: no engagement goes more than one billing cycle with material unbilled WIP. Filter, approve descriptions, generate invoices, mark rows invoiced.

When PSA software replaces the sheet

Practice management with time import, approval workflows, and integrated invoicing wins at multi-office scale. Boutique CPA shops and consultants under ~30 active engagements often run WIP in a sheet until write-offs hurt.

These templates are billing operations tools, not audited financial statements or tax advice systems.