Deferred Revenue Calculator

Cash in the bank is not revenue yet. When customers pay upfront for a year of service, accounting rules say you owe them that service first: the cash sits on your balance sheet as deferred revenue, a liability, and converts to real revenue month by month as you deliver. This calculator builds the 12-month waterfall schedule auditors want to see: beginning balance, new billings, recognized revenue, and ending balance, plus the journal entries behind them. Read the model limit first: it recognizes revenue straight-line with no churn and no refunds, so a business with cancellations will not reproduce this waterfall. Treat it as a planning model, not a substitute for your revenue recognition policy or auditor.

Quick Answer

How to use this calculator

Enter the monthly new bookings, the contract term in whole months, and any starting deferred balance from prior billings, then press Calculate. The tool renders a 12-month table and a headline month-12 balance. Results stay hidden until you calculate, so the pre-filled $12,000, 12-month, $0 example is only a starting point, not a result. If your term is not a whole number of months, or it exceeds the tool’s 60-month cap, the tool says so plainly instead of silently rounding.

The model limit belongs in this section, not in a footnote. Every month’s bookings are recognized evenly over the term, every month bills the same amount, and nothing cancels or refunds. A real subscription business has churn, upgrades, downgrades, and refunds, and each of those bends the waterfall. Use this tool to understand the shape of a growing deferred balance and to reconcile a clean cohort, then adjust forward for contract changes in your own schedules.

The formula

Each month’s bookings are spread evenly over the contract term, so one month’s bookings contribute bookings ÷ term to revenue in each month of that contract. Month-k revenue is therefore bookings ÷ term × active cohorts, where active cohorts are the number of monthly cohorts still within their term, capped at the term itself. The ending balance each month is beginning balance + new billings − recognized revenue. That roll-forward is the whole waterfall: opening balance, plus billings, minus recognition, equals closing balance, repeated twelve times.

Worked example, checked against this exact tool

Using the pre-filled values, $12,000 monthly bookings on 12-month contracts with a $0 starting balance: month 1 has one active cohort, so it recognizes $12,000 ÷ 12 × 1 = $1,000 and ends at $0 + $12,000 − $1,000 = $11,000. Month 2 has two cohorts, recognizes $2,000, and ends at $21,000. The recognized column climbs $1,000 each month as cohorts stack, reaching $12,000 in month 12, when twelve cohorts are all active. The full table the tool prints is:

Month	Begin balance	New billings	Recognized	End balance
1	$0	$12,000	$1,000	$11,000
2	$11,000	$12,000	$2,000	$21,000
3	$21,000	$12,000	$3,000	$30,000
4	$30,000	$12,000	$4,000	$38,000
5	$38,000	$12,000	$5,000	$45,000
6	$45,000	$12,000	$6,000	$51,000
7	$51,000	$12,000	$7,000	$56,000
8	$56,000	$12,000	$8,000	$60,000
9	$60,000	$12,000	$9,000	$63,000
10	$63,000	$12,000	$10,000	$65,000
11	$65,000	$12,000	$11,000	$66,000
12	$66,000	$12,000	$12,000	$66,000

Totals check out: $144,000 billed, $78,000 recognized, $66,000 still deferred, and $78,000 + $66,000 = $144,000, so every billed dollar is either recognized or still deferred. A second check with a starting balance shows why that input matters: $6,000 monthly bookings on 6-month contracts with a $10,000 starting balance ends month 12 at $25,000, with $72,000 billed, $57,000 recognized, and a $15,000 delta on top of the opening balance. Run both sets in the tool and the tables match.

What deferred revenue is

Deferred revenue is cash you have collected but not yet earned: a liability on the balance sheet, not income on the profit and loss. Under ASC 606 (US GAAP) and IFRS 15, revenue is recognized only as you satisfy the performance obligation, delivering the service month by month. A $12,000 annual prepayment is twelve $1,000 monthly revenue events, not one $12,000 event on the day the cash arrives.

Reading the waterfall schedule

Each month has four columns. Beginning balance is what you still owe customers from prior billings. New billings add to what you owe. Recognized revenue is the portion earned that month and released to the profit and loss. Ending balance is what remains owed. The schedule proves the liability ties out: every dollar billed is either recognized or still deferred, never both, never neither. In the worked example the recognized column climbs $1,000 each month as new cohorts stack, and that ramp is the signature shape of a growing subscription business.

Read the table in this order: bill, then deliver, then recognize, then repeat until the balance hits zero. If the ending balance ever moves in a direction you cannot explain from those three steps, the input to question first is the starting balance: a wrong opening figure poisons all twelve months, while a wrong bookings figure only bends the slope.

Cash versus GAAP: why your bank balance lies

The $66,000 delta between cash billed and revenue recognized is the most important number in this calculation. Cash tells you $144,000 was collected, real money for payroll and spending, and that a growing deferred balance means future revenue is pre-sold. GAAP tells you $78,000 was earned, the true size of this year’s business, and that spending all $144,000 now borrows from next year’s obligations. Tax and investor reporting follow recognition, not cash. Founders get in trouble spending the cash as if it were all this year’s revenue, then facing the service obligation with an empty account. Treat the deferred balance as restricted: it is already spoken for. For the revenue side once earned, the monthly subscription revenue calculator picks up the story, and the net revenue retention calculator tracks what upgrades and downgrades do to growth, which this no-churn tool deliberately does not.

The journal entries, step by step

Two entries run the whole system. At billing: debit Cash $12,000, credit Deferred revenue $12,000. No revenue is recorded, and the balance sheet grows on both sides. Each month of service: debit Deferred revenue for the recognized amount, credit Subscription revenue for the same amount. The liability shrinks as income appears. At term end, the deferred balance for that contract is zero and the full $12,000 has moved to revenue, one month at a time. Keep records that tie each liability balance to its schedule, which is what the waterfall above produces, and reconcile monthly as part of the close. When contracts change mid-term, adjust forward from the change date: add a new line for upgrade payments spread over the remaining term, or stop the schedule on cancellation and refund the unused balance. Never rewrite closed months.

What competing calculators miss

Most deferred revenue tools divide one contract by its term and print a monthly number. They never build the multi-cohort waterfall, so they cannot show the ramp that defines a growing subscription business. None of the free tools I checked show the journal entries, none quantify the cash-versus-GAAP delta, and none handle a starting balance from prior billings. This page does all four, because a single-contract division is a classroom exercise and the waterfall is what auditors actually ask for. Honest gap, stated plainly: paid waterfall tools add churn, renewal, and export features this free tool does not, so if your cohorts cancel at a meaningful rate, this straight-line schedule will overstate your future recognized revenue and you should model churn separately before relying on it.

Frequently asked questions

Add This Calculator to Your Website

References