What is a deferred revenue schedule, and how do you build one?
If you invoice anything in advance — annual retainers, prepaid blocks, upfront project fees — this one schedule is the difference between a P&L that reflects your business and one that swings wildly for no operational reason.
A deferred revenue schedule is a running record of money you have invoiced or collected but not yet earned, showing how much releases to revenue in each future period. It exists because revenue is recognised when you deliver the work, not when you send the invoice. Without one, a twelve-month retainer billed in January lands entirely in January — making one month look extraordinary and the following eleven look like decline.
Why the schedule exists
Cash timing and revenue timing are different things, and only one of them belongs on the P&L.
When a client pays you in advance, you have taken on an obligation rather than earned income. Until the work is delivered, that money is a liability — you owe them either the service or their money back. Both US GAAP and IFRS treat it that way, and the schedule is simply how you keep track.
The mechanics are two journal entries. On invoice or receipt, you debit cash or accounts receivable and credit deferred revenue. Then in each period you deliver, you debit deferred revenue and credit revenue for the portion earned.
Deferred revenue is a liability on the balance sheet, not an asset. If yours is sitting in the wrong place, that is worth fixing before anything else — it distorts working capital and every ratio derived from it.
What a schedule actually looks like
At minimum, one row per contract with a column per period. Here is a single $120,000 annual retainer invoiced in full in January:
| Month | Opening balance | Released to revenue | Closing balance |
|---|---|---|---|
| January | 120,000 | 10,000 | 110,000 |
| February | 110,000 | 10,000 | 100,000 |
| March | 100,000 | 10,000 | 90,000 |
| … | … | … | … |
| December | 10,000 | 10,000 | 0 |
Straight-line release works when delivery is genuinely even across the term, which for an ongoing retainer it usually is. It is the wrong answer when the work is front-loaded — a project with heavy discovery in month one and light maintenance afterwards should be released against milestones or effort, not evenly.
Scaled up, the schedule has one row per contract and a total row that must reconcile to the deferred revenue balance on the balance sheet every single month. That reconciliation is the whole control. If they do not agree, something has been invoiced without being scheduled, or released without being delivered.
The five mistakes that make a schedule useless
1. It is rebuilt once a year
A schedule reconstructed at year end gives you one correct number, twelve months late. The point is to know what this month's revenue actually was while you can still act on it.
2. Nobody adds new contracts
The schedule is only as good as its completeness. New retainers signed mid-year have to be added when they are signed, not when someone notices. Make it part of the same routine that issues the first invoice.
3. Cancellations and scope changes are not reflected
A client who leaves in month seven leaves five months of unearned revenue on your balance sheet. Depending on your terms it is either refundable or it is not, and either way it needs handling — not quietly releasing to revenue because the schedule was set and forgotten.
4. Nobody reconciles it to the balance sheet
Without a monthly tie-out to the deferred revenue account, drift accumulates silently. This is the single highest-value control in the whole exercise and it takes minutes.
5. It ignores the cash consequence
A large deferred balance means you are holding money for work you still owe. That is a real obligation and it should inform how freely you spend against it. Agencies that treat prepayment as available cash discover the problem in the quarter the work has to be delivered without the funds to deliver it.
What it changes about how the business reads
The visible effect is that seasonality stops being an illusion. Without the schedule, an agency that lands three annual retainers in Q1 looks like it is booming and then collapsing. With it, revenue tracks delivery, which is what you are actually managing.
The second effect matters more in a transaction. Buyers, lenders and investors all want to see revenue recognised properly, and a business that recognises annual contracts up front looks either careless or optimistic. Neither is a good position to negotiate from.
The third is internal. Once revenue reflects delivery, margin by client becomes meaningful — you are comparing what you earned in a period against what it cost to deliver in that same period. Compare mismatched periods and the answer is noise. The cost side of that equation has its own problems.
Common questions
Is deferred revenue an asset or a liability?−
A liability. You have received money for work you have not yet delivered, so you owe the client either the service or a refund. It sits on the balance sheet under current liabilities if it will be earned within twelve months, and long-term liabilities for anything beyond that.
When should an agency recognise retainer revenue?+
Generally as the service is delivered — for an ongoing monthly retainer, that means ratably across the term regardless of when you invoiced. If delivery is genuinely uneven, such as a project with heavy front-loaded work, recognise against milestones or effort rather than straight-line.
What's the difference between deferred revenue and accounts receivable?+
They are near opposites. Accounts receivable is work you have delivered but not been paid for — an asset. Deferred revenue is money you have been paid but not yet earned — a liability. An agency billing annually in advance will typically carry a large deferred balance and modest receivables.
Do I need a deferred revenue schedule if I bill monthly in arrears?+
Usually not, because invoicing and delivery land in the same period. It becomes necessary the moment you invoice ahead of delivery: annual retainers, prepaid hour blocks, upfront project deposits, or any multi-month contract billed at signature.
How often should the schedule be reconciled?+
Every month, as part of the close. The total of the schedule must equal the deferred revenue balance on the balance sheet. It takes a few minutes and it is the only thing preventing silent drift between what you have promised and what you have recorded.
We run the schedule
Monthly, reconciled to the balance sheet. Part of every Close + Margin engagement.
Get a free books reviewGeneral information for agency owners and operators, not accounting, tax or legal advice. Figures shown are illustrative unless stated otherwise.