Know the Figures

Committed vs Usage Revenue Schedule

A contract with a minimum and overage does not recognise in a straight line.

Replaces: Enterprise billing platforms’ revenue modules

How to use it

Enter the committed minimum, what usage it includes, and the price of anything beyond it. The committed portion is earned evenly across the term; overage is earned in the month the usage occurs. The two together rarely produce a straight line.

Where the number comes from

  • The committed minimum is spread evenly, because the customer has an unconditional obligation to pay it regardless of use.
  • Usage compounds at the growth rate you set, so month twelve is month one multiplied by growth to the eleventh power.
  • Overage units are usage above the included allowance, floored at zero — an under-used month does not create a credit.
  • Overage revenue is recognised in the month the usage happens, since that is when the service is delivered.
  • Total revenue is the commitment plus all overage, which is why it exceeds the contract’s headline value.

What goes wrong

The part most calculators leave out.

  • Forecast usage is a forecast. Overage revenue that has not happened cannot be recognised, no matter how confident the sales team is that it will.
  • This assumes overage is billed and earned monthly. Contracts that true up annually, or allow unused allowance to roll forward, behave differently and the rollover materially changes the schedule.
  • Growing usage is not always good news. A customer consistently exceeding their allowance is usually one negotiating a bigger commitment at a lower unit rate at renewal, which caps the overage you are modelling.
  • Minimum commitments with usage credits that expire may create a material right or a breakage estimate, neither of which appears here.
  • Back-loaded revenue distorts every annualised metric. Multiplying a strong month by twelve overstates a contract shaped like this one.

Why the run-rate lies both ways

A customer commits 120,000 a year with 100,000 units included each month and 12 cents beyond. They start at 72,000 units and grow 9% a month. For the first few months they are well inside the allowance and revenue is exactly the 10,000 committed portion — annualising month one gives 120,000 and understates the year. By the time usage passes the allowance the picture inverts: month twelve carries meaningful overage, and annualising that month overstates the year instead. The only figure that describes the contract is the schedule, and neither end of it does.

Questions

Can I recognise expected overage in advance?
No. Overage is earned when the usage occurs. Estimating it into earlier periods recognises revenue for a service you have not yet provided.
Why spread the committed minimum evenly?
Because the customer must pay it regardless of use, and you stand ready to serve throughout the term. That obligation is satisfied over time rather than at any particular moment.
What if usage falls short of the commitment?
The customer still pays the minimum and you still recognise it evenly. The shortfall is a commercial problem at renewal rather than an accounting one during the term.
Does anything I type get sent anywhere?
No. The whole calculation runs in your browser. Nothing is transmitted, stored, or logged, and there is no account to create.

Last updated .

Put this calculator on your site

Free to embed, on any site, commercial or not. No sign-up and no tracking script — the calculator runs in your reader’s browser exactly as it does here. All we ask is that you keep the credit line.

HTML

The small script resizes the frame as the reader changes inputs. Drop it if your CMS strips scripts — the calculator still works, it will just stay at a fixed height.

Related calculators