WIP Days, AR Days and Lockup Calculator for a CPA Firm

Is the practice earning what it should for the hours it spends?

Unbilled WIP days, billed receivable days and total lockup days from WIP, receivables and billings for the period.

  • Runs in your browser
  • Nothing stored or sent
  • Free, no sign-up
Your figures
Example figuresIllustrative only. Type over them with your own.
Lockup days
79.1 days
Days from work done to cash collected
WIP days
30.4 days
Receivable days
48.7 days
Drawn to one scale
WIP days30.4 days
Receivable days48.7 days
Lockup days79.1 days
All results
MeasureResult
WIP days30.4 days
Receivable days48.7 days
Lockup days79.1 days
Cash tied up in WIP and receivables$650,000
How this was worked out
Work shownrecomputed as you type
Daily billings = billings for the period / days in the period
WIP days = WIP / daily billings
Receivable days = billed receivables / daily billings
Lockup = WIP days + receivable days

Illustrative arithmetic on the figures you enter. Check the result against your firm's methodology before relying on it.

The formulas

  • Daily billings = billings for the period / days in the period
  • WIP days = WIP / daily billings
  • Receivable days = billed receivables / daily billings
  • Lockup = WIP days + receivable days

How it works

Lockup is the number of days of billings that sit in work done but not yet paid. WIP days measure billing lag. Receivable days measure collection lag.

Illustrative figures only. Check the result against your firm's methodology before relying on it.

Common questions

Is WIP net or gross of write-downs?

Use the figure your ledger carries. Use the same basis each period.

Which billings figure?

Trailing twelve months of billings gives a steadier ratio than a single month.

Formulas on this page are the standard definitions.

Runs in your browser. The figures you type are not sent to CORAA or stored. Check the result against your firm's methodology before relying on it.

Related audit calculators

For US CPA firms

Join the CORAA waitlist

CORAA AI drafts audit working papers from your client’s QuickBooks books and does the first pass: lead schedules, tie-out, memos, draft notes and letters. CORAA Network reviewers clear every finding. Your firm reviews and signs.

  • First audit free, so you can judge the quality on a real file
  • Flat fee by entity size; messy books included
  • We work only with CPA firms, never their clients
See how it works →

* required