All calculators

Guide · Freelance Rates

Billable Write-Offs: Trace Lost Fee Value

Reconcile unbilled effort, invoice concessions and delayed collections so the same lost fee value is not removed from the model twice.

By PriceAndProfit Editorial Updated 3 min read

On this page
  1. Build a fee-value bridge
  2. Keep unbilled work in the cost record
  3. Classify causes before changing the next quote

The phrase billable write-off can describe time that never reaches an invoice, an agreed reduction in the invoice, or an amount that remains unpaid. These events affect different parts of the service model. Define each category before calculating realization or an effective rate, and keep the original time record so the cost of delivering the work remains visible.

Build a fee-value bridge

Assume a hypothetical project uses 50 client-delivery hours with a $120 reference billing rate. Reference fee value is $6,000. Five hours are excluded from billing under the entered scenario, removing $600. An additional agreed invoice concession is $400. The resulting invoice and earned-revenue assumption for this example is $5,000, giving fee realization of 83.33% of the original $6,000 reference value.

Realized fee value = reference fee value − excluded-time value − separate fee concessions
Reconciliation stageAmount
Reference value: 50 × $120 $6,000
Five hours excluded from billing −$600
Separate invoice concession −$400
Final fee in this scenario $5,000
Collected by review date $4,500
Remaining receivable $500

The $500 still unpaid at the review date is not automatically another fee write-off. It may be a timing difference. Cash collected is 90% of the $5,000 invoice, while fee realization is 83.33% of reference value. Using those two denominators consistently gives $4,500 of receipts; treating both percentages as deductions from the same base would be incorrect.

Keep unbilled work in the cost record

If all 50 hours cost an internal $60 each, delivery cost is $3,000. The $5,000 fee leaves $2,000 after that cost, or a 40% margin on revenue. Removing the five unbilled hours from the cost record would understate cost by $300 and overstate the result. Work still consumes resources when the business elects or agrees not to charge for it.

Likewise, do not reduce billable capacity to 45 hours and then apply an 83.33% realization factor derived from all 50 hours without reconciliation. That would remove some of the same fee leakage twice. A model using 45 invoice-eligible hours has a $5,400 reference base and must treat the separate $400 concession against that different base.

Classify causes before changing the next quote

Record whether the excluded effort came from estimating error, internal rework, an agreed courtesy, unclear scope, or a deliberate commercial decision. An additional service never promised in the original scope should not automatically be called a write-off; its treatment depends on the actual approval and billing arrangement.

Preserve actual hours, approved invoice changes, receipts, and outstanding balances in separate columns. Zero reference value makes realization undefined, while an actual refund can create a negative revenue adjustment that should remain visible. This managerial bridge does not determine accounting treatment of bad debts or legal collection rights. It shows where fee value changed and prevents an unpaid invoice from being mistaken for the same issue as unbilled work.

Method references: OpenStax: Standard Costs and Variances. Accessed October 22, 2026. All dollar figures are hypothetical worked examples.

Related calculators & guides