EN
See the demo

Billing delivered work

How to find delivered work that was never invoiced

Finance managers and project managers often close a month with the sense that some finished work never reached an invoice. This guide names the five places where that work hides and gives a month-end method to find all of it.

Short answer

To find delivered work that was never invoiced, check the five places where work happens without an invoice trigger: hours above a prepaid package, closed project months, contract milestones, won deals and subscription periods. Compare each with the invoices and completion certificates already issued, then total what is missing for each client.

  • Places to check: five
  • Check: once a month
  • You need: hours, contracts, deals and invoices
On this page
  1. Short answer
  2. When to look
  3. The seven-step check
  4. Sources and documents
  5. Example total
  6. Common mistakes
  7. Month-end checklist
  8. In Krokul
  9. FAQ

When you need to look for unbilled work#

Unbilled work is the revenue gap that opens between delivery and invoice. It is one part of the wider problem described in the guide on billing everything you deliver, and the size of the whole gap is the subject of revenue leakage in professional services.

  • The month closes and the invoice total looks lower than the work your team remembers doing.
  • Support hours went above the prepaid package and nobody sent an invoice for the extra.
  • A project finished and the client accepted it, yet only some of the contract milestones were invoiced.
  • A deal was marked won weeks ago and the client has not yet received an invoice.
  • A subscription period started and the invoice for it is still unsent.
Unbilled work
Unbilled work is work already delivered or sold for which the client has not yet received an invoice or a completion certificate.
Completion certificate
A completion certificate is a document that records the work, hours or contract stages the client accepted and the amount due, and that supports the invoice.

How to find delivered work that was never invoiced in seven steps#

Finding unbilled work means comparing what was delivered with what was invoiced, source by source. Each of the five sources has its own record of delivery, so each needs its own comparison. Run the steps in order at every month end.

  1. Set the lookback window

    Choose how far back to look before you open any record. Three closed months for project work and twelve months for won deals cover most gaps that can still be invoiced.

    Older items need a decision from the owner, either an invoice with an explanation or a write-off, so keep them on a separate list.

  2. List the hours above each prepaid package

    For every project with a monthly package of hours, take the billable hours logged in the current month and subtract the package. The remainder is billable overage, and it grows through the month, so check it weekly.

    Multiply the extra hours by the overage rate in the contract. A project with no overage rate on file gets a line on the list with a question mark, because the amount cannot be known yet. The guide on billing retainer overage covers rates and client notice.

  3. Match closed project months to certificates

    For each closed month, list the projects with billable hours and look for a completion certificate or invoice dated to that month. Hours without a document are unbilled.

    Skip months before the project started and months after it ended, because no work was owed there.

  4. Compare contract milestones with what was certified

    For every one-off contract that is in force, add up the value of the milestones that are finished and subtract the value already covered by certificates or invoices. A completed milestone with no document belongs on the list.

    The guide on billing fixed-price projects by milestones explains how to keep milestones and invoices in step.

  5. Find won deals that have no invoice

    Open the deals marked won within the lookback window and check each one for an invoice, a certificate, a contract or a project that will invoice it. A won deal with none of these has a date and an amount, and nobody has been told to invoice it.

    Record the date the deal was won, because that date shows how long the money has waited.

  6. Check each subscription period

    For every active subscription, compare the periods that have started with the invoices issued for them. A period that began and has no invoice is unbilled, even though the contract is fine.

    The guide on invoicing retainers automatically every month removes this check by issuing the invoice on schedule.

  7. Total by client and by age

    Put every item into one list with the client, the source, the amount and the date the work has been waiting since. Sort by client to decide who gets a call, and by age to decide what to invoice first.

    Create the certificate or invoice for each line the same day, and the list shrinks to the items that need a conversation.

    Tip. Add the lines in the client’s own currency and convert only the total, so a rate change never alters a line.

Which source needs which document#

Each source produces a different document, so the table below doubles as the routing rule for the list you built. Hours and contract stages go through a completion certificate, and deals and subscription periods go straight to an invoice.

The five sources of unbilled work
SourceHow to detect itDocument to create
Hours above the packageBillable hours this month minus the package hoursCompletion certificate for the extra hours
Closed project monthBillable hours in a closed month with no document for that monthCompletion certificate for the month
Contract milestoneFinished stages not covered by a certificate or invoiceCompletion certificate for the stages
Won dealDeal marked won with no invoice, certificate or projectInvoice from the deal
Subscription periodPeriod started with no invoice for that periodInvoice for the period

How to total unbilled work for one client#

The total for a client is the sum of the amounts found in the five sources. The example below shows one client at month end, with each line calculated from its own record.

Example: unbilled work for one client at month end
SourceWhat was foundAmount
Hours above the package12 hours above a 40-hour package, at £90 an hour£1,080
Closed project month30 billable hours in September at £80, no certificate£2,400
Contract milestoneStage 3 finished, not certified£6,000
Won dealDeal won 40 days ago, no invoice£5,000
Subscription periodOctober period started, no invoice£1,200
TotalUnbilled work for this client£15,680

Unbilled total = hours over the package × overage rate + billable hours × hourly rate + finished stage value + won deal value + subscription period value, each net of documents already issued. In the example, 12 × 90 + 30 × 80 + 6,000 + 5,000 + 1,200 gives £15,680. A client with an unpaid invoice of the same size would already be on the debtor list, and this amount is still missing from it.

Which mistakes hide unbilled work#

  • Comparing this month’s invoices with last month’s. Every gap then looks normal. Compare invoices with hours, contracts and deals instead.
  • Checking hours only. Contract milestones, won deals and subscription periods sit outside the timesheet, so give each its own comparison.
  • Waiting for the client to ask. Clients rarely request an invoice for work they could keep for free, so issue the document when the work is accepted.
  • Leaving won deals to memory. A deal marked won becomes an invoice only when someone remembers it, so list every won deal without a document each month.
  • Keeping the list in a spreadsheet nobody refreshes. An old list shows old gaps, so recalculate it from the source records every month.

A month-end checklist for unbilled work#

Copy the list into your close routine. The full month-end routine for a service company is in the month-end billing checklist.

  • Set the lookback: three closed months of project work, twelve months of won deals.
  • Export billable hours by project for the closed month and compare each project with its documents.
  • Subtract package hours from the current month’s hours and price the overage.
  • List one-off contracts with finished stages that no certificate covers.
  • List deals won in the window that have no invoice, certificate or project.
  • List subscription periods that started without an invoice.
  • Total by client, sort by age and create each document the same day.

How Krokul shows unbilled work in one list#

Krokul CRM is a B2B CRM for contract-based companies: deals, projects and profit per client in one system, implemented by integration partners. Its Unbilled screen runs the seven-step check above for every client at once.

Open Documents, then Unbilled. The header shows the total to invoice in the company’s base currency and the lookback, with project months three months back and won deals 365 days back. Five tiles show the amount and the number of rows for each source, and a switch turns the list from rows into clients, with the largest amount first.

Each row names the client, the source, the project or document, the date the work has been waiting since, and the amount in the document’s currency. A button in the row creates the completion certificate for hours and contract stages, or the invoice for a won deal and a subscription period. When the document exists, the row disappears, because Krokul recalculates the list from hours, contracts, deals and subscriptions every time it opens.

A row that cannot produce a document shows the reason in place of the button, for example a project without an hourly rate or a deal without line items. A subscription period skipped earlier appears without a button and is invoiced from the contract card. Admins and managers see the screen. The projects and billing page shows where it sits among hours, margin and contracts.

Act from contract stages window with unfinished stages, remaining amounts and a disabled Create act button
The certificate window opened from a contract card in a Krokul demo workspace: unfinished stages with their remaining amounts.

Frequently asked questions#

How far back should I look for unbilled work?

Look back three closed months for project work and twelve months for won deals. Older items need a decision from the owner, either an invoice with an explanation or a write-off.

How often should I check for unbilled work?

Check once a month at close for the closed months, and once a week for hours above a package, because that overage grows during the month.

Should I include work the client has not accepted yet?

List it separately. A certificate or an invoice needs accepted work, so ask the client to confirm first and add the item to the total after acceptance.

Who should own the unbilled list?

A finance manager owns the list and the month-end total, and each project manager confirms the lines for their own projects. That split gives every line a named person.

What if an invoice exists but covers a different period?

Treat the period without an invoice as unbilled. An invoice for October does not cover November, so the November period stays on the list until its own invoice is issued.

Krokul Team

The people who build Krokul CRM

We write about getting paid, billing delivered work and project margin, and check every product statement against Krokul itself.

First published

See the demo