Deferred Revenue Schedule Template: Free 36-Month Excel Workbook

This free deferred revenue schedule template takes you from your invoice list to the month-end journal. It gives you 36 months of revenue recognition, a 24-month roll-forward that ties to the cent, and unbilled revenue on its own line, so it never hides inside the liability. Type each contract once and the rest fills in.

It is the liability-side twin of our prepaid expense schedule template: prepaid expenses are costs you paid before using them, deferred revenue is cash you billed before earning it.

Download the deferred revenue schedule template (free Excel)

The deferred revenue schedule template comes with sample contracts for a subscription business, so every sheet shows real numbers the moment you open it. Type over them, or delete them as whole rows, and add your own. The table holds 300 contracts, invoices or credit notes. It is a plain deferred revenue schedule Excel workbook with no macros, only formulas you can inspect.

It has eight sheets: Start Here, Settings, Contracts, Dashboard, Roll-forward, Schedule, Balances and Journal Entries, and it is built for Excel 2016 or later and Excel for the web.

Watch the deferred revenue schedule template walkthrough

The walkthrough adds a new contract on camera and follows it through the schedule, the roll-forward, unbilled revenue, a credit note, the journal entries and the checks, all in the real workbook.

• 0:00 Intro
• 0:42 The idea in one minute
• 1:14 Set up the template
• 1:37 Add a contract
• 2:31 The revenue schedule
• 2:55 Roll-forward and the current split
• 3:35 Arrears, credit notes, cancellations
• 4:20 Journal entries
• 4:40 Dashboard and checks
• 5:15 Recap

What is inside this deferred revenue schedule template

What is a deferred revenue schedule?

Deferred revenue is money you have billed or collected before you deliver the service. Until you deliver it, you owe the customer the work or the money back, so it sits on the balance sheet as a liability with a credit balance.

IFRS 15 and ASC 606 call this balance a contract liability, but both allow other labels such as deferred revenue. Unearned revenue is the same balance under another name, so an unearned revenue schedule is the same tool.

The schedule releases that liability into revenue month by month as you deliver. For a subscription, support plan or licence that the customer uses evenly over time, that means spreading the amount over the service period. The same pattern fits annual maintenance contracts, retainers, prepaid training, memberships and software support, not only SaaS.

Deferred revenue schedule example: a $12,000 annual subscription

Take one contract: a $12,000 annual subscription, invoiced on 15 March 2026, with service from 15 March 2026 to 14 March 2027. That is 365 days. Here is what the deferred revenue schedule template does with it.

Monthly method

Seventeen days of service fall in March, which is at least 15, so March counts as the first full month. The template recognises $1,000 a month for 12 months, from March 2026 to February 2027.

Daily method

The template spreads $12,000 over the 365 days and recognises each month’s actual days. Because each month is the cumulative amount to date, rounded, less the cumulative amount to the month before, the 13 monthly figures add up to exactly $12,000.00.

What the balance sheet shows at 30 June 2026

Under Monthly, four months are recognised, so deferred revenue is $8,000. Under Daily it is $8,449.32. All of it is current, because the rest of the revenue is recognised within 12 months of 30 June.

The journal entries for this contract

How to use the deferred revenue schedule template in Excel, sheet by sheet

1. Settings. Type your company name and currency label. Pick the first month of the schedule (any date in that month) and the month you are reporting on, which must be within the first 24 months. Choose Units or Thousands, and Monthly or Daily as the default method. List your revenue accounts with their codes, then the receivable, deferred revenue and unbilled revenue accounts your entries use.
2. Contracts. Type over the sample rows, delete them as whole rows, or insert whole rows anywhere above Totals. Fill the yellow cells: contract ID, customer, revenue account, invoice or credit note number, invoice date, service start, service end and amount, plus remarks if you like. Leave Method blank to use the default. Never type in the grey cells. Row check should say OK; rows billed in arrears or cancelled show a blue note.
3. Schedule. Read each contract across the months, and each month’s total in the top row.
4. Balances. Take the deferred revenue total for your reporting month and tie it to the deferred revenue account in your general ledger. Need one month line by line? On Contracts, the last three grey columns show each contract’s revenue for the reporting month and its deferred and unbilled balance at that month end; their totals match the Roll-forward and Journal Entries.
5. Roll-forward. Read the closing balance and its current and non-current split, and confirm the difference line is zero.
6. Journal Entries. Post the two entries for the month. Debits less credits must be zero. Change the reporting month on Settings to get any other month.
7. Dashboard. “Checks: all clear” means formulas are present, no row is flagged, the roll-forward ties out, the entries balance, no account code is used twice and the Contracts sheet agrees with Balances.

Your revenue recognition schedule and deferred revenue waterfall

The Schedule sheet is the deferred revenue waterfall: one row per contract, one column per month, so you can see when each contract’s revenue lands and how much revenue is already locked in for the months ahead.

Your monthly close in four lines: add the month’s invoices and credit notes, move the reporting month, read the checks, then post the two entries and tie Balances to the ledger.

The deferred revenue roll-forward, line by line

Here is November 2026 from the sample contracts in the workbook:

Why is there an unbilled line? Part of November’s revenue came from a contract that will only be invoiced in December. That revenue did not come out of deferred revenue, so it is added back here and shown on its own line instead.

The bottom line rebuilds the closing balance contract by contract from the Balances sheet. If a formula is broken or a row is missing, the difference stops being zero and the Dashboard says so.

IFRS 15 and ASC 606 ask for the opening and closing balances of receivables, contract assets and contract liabilities in the notes, plus the revenue recognised from the opening liability. The roll-forward and the Balances sheet give you those raw numbers; the wording of the note is still yours.

Current vs non-current deferred revenue

The part of the closing balance you will recognise within 12 months of the reporting date is current, and the rest is non-current. In the sample, a three-year $54,000 contract billed on 1 March 2026 is recognised at $1,500 a month. At 30 November 2026 its balance is $40,500: $18,000 current and $22,500 non-current.

For the whole book in November that is 65,649.32 current and 22,500.00 non-current. The template recalculates the split every month for each invoiced row: the balance now, less the balance 12 months later.

Unbilled revenue: why it stays apart from deferred revenue

Some customers are billed after the service starts. In the sample, Juniper Clinics buys quarterly support of $2,700 for October to December 2026 and is invoiced on 31 December 2026.

• October: $900 of revenue is earned with no invoice yet, so unbilled revenue is $900 (debit unbilled revenue, credit support revenue).
• November: unbilled revenue grows to $1,800.
• 31 December: the invoice clears it. Debit accounts receivable 2,700, credit unbilled revenue 1,800, credit deferred revenue 900. December’s $900 then moves from deferred revenue into revenue.
• End result: receivable 2,700, deferred revenue 0, unbilled revenue 0.

Within a single contract, the standards present one net position, a contract asset or a contract liability (ASU 2014-09, paragraphs 606-10-45-1 to 45-4). Across different contracts, the general rules against offsetting assets and liabilities apply, so one customer’s unbilled revenue should not reduce another customer’s deferred revenue. That is why the template keeps unbilled revenue on its own line in the roll-forward, the Balances sheet and the journal entries.

Call it unbilled revenue: a contract asset when the right to payment still depends on more performance, or an unbilled receivable when only time stands between you and payment. If one contract has an advance-billed row and an arrears row, give them the same contract ID and net them for that contract on the balance sheet. Review ageing unbilled balances for credit losses.

This also answers a common question: can deferred revenue be negative? On a single row, a negative usually means revenue was earned before billing, which is unbilled revenue, or a credit note.

Journal entries for deferred revenue, for any month

The Journal Entries sheet gives you two entries for the reporting month. Here is November 2026 from the sample:

In December, entry 1 includes the arrears invoice from the unbilled section: debit receivable 2,700, credit unbilled revenue 1,800 and deferred revenue 900. A credit note on its own is the reverse of an invoice: debit deferred revenue, credit accounts receivable.

A line called “No revenue account chosen” catches any row without a revenue account, or with a code that is not on Settings, so revenue never goes missing from the entry.

One timing point: a contract liability arises when the customer pays or when payment falls due, whichever is earlier. If your contracts can be cancelled until they are paid, enter the payment or due date in the invoice date column.

Monthly vs Daily, and the 15-day rule

Both are practical ways to measure progress evenly over time; neither is named in the standards. Use one method consistently for similar contracts, and check that the difference between them is not material for you.

Even spreading only fits services the customer benefits from evenly, such as a subscription or a support plan. If the work is uneven, like a project delivered in milestones, it needs a different measure.

Why cumulative rounding makes every contract add up

Split $10,000 over three months and you get 3,333.33, 3,333.34 and 3,333.33: exactly 10,000.00. The naive way rounds a daily rate first, for example $32.88 a day on $12,000, and 32.88 times 365 is 12,001.20, which is $1.20 too much.

The template rounds the cumulative amount to date and subtracts the previous month’s cumulative amount. That is why April shows 986.31 and June 986.30 in the Daily example above. Our guide to Excel formulas for finance covers the rounding functions behind it.

How the formulas work

In the final month the cumulative amount is set to the exact amount billed, so even amounts with more decimals than the currency uses add up. Every formula is visible in the workbook; there are no macros.

Opening balances, cancellations, credit notes and other real cases

Contracts that started before the schedule

Acme Analytics was billed $12,000 on 1 July 2025 for July 2025 to June 2026, and the schedule starts in January 2026. The $6,000 recognised before the schedule is left out, so the opening deferred revenue at 31 December 2025 is $6,000, followed by $1,000 a month to June. Tie that opening balance to your ledger at the cut-off date; differences usually come from old rounding, a different day count or partial billings.

Cancellations part-way through a contract

In the sample, Lumen Studios was billed $12,000 for March 2026 to February 2027 and cancelled from 1 September 2026. On the original row you type the cancellation date and leave the credit blank: the template recognises $1,000 a month from March to August, credits the unused $6,000 in September and the balance drops to zero.

Credit notes without a cancellation

Harbor Schools has a $7,200 plan for August 2026 to January 2027, at $1,200 a month. A downgrade credit note CN-1007, referring to invoice INV-1172, is minus $1,800 for November to January, so the net is $600 a month and the net balance at 30 November is $1,200.

If a credit note relates to months already passed, the template adjusts revenue in the credit note’s month instead of reopening closed months. A credit note that covers only part of a month should use Daily, so it nets exactly against the original. Row check flags a credit larger than the row’s amount, a credit typed as text, a cancellation dated before the invoice and a credit with no cancellation date.

Invoices raised before the service starts

Nimbus Analytics is invoiced $18,000 on 15 December 2026 for a renewal running through 2027. The whole amount is deferred revenue at 31 December 2026, all of it current, and the template starts recognising $1,500 a month in January 2027.

Invoices in another currency

Enter the amount converted at the rate on the invoice date. Deferred revenue is not revalued at month-end exchange rates; an unpaid receivable in a foreign currency still is, in your ledger.

Multi-year upfront billing

For most subscriptions billed annually in advance there is no financing to account for. If a customer pays more than a year ahead of the service, check whether the contract contains a significant financing component; the template does not model interest.

A book schedule, not a tax schedule

In the US, advance payments are generally taxed when received. Under the deferral method of section 451(c), an accrual-method taxpayer includes in the year of receipt the part the books recognise that year, and the rest in the next tax year, even when the books spread it over longer; IRS Publication 538 covers the rules. A 36-month book deferral therefore creates a book-tax difference. You elect the deferral method by filing a return that uses it; switching to it from a method you already use is a change of accounting method and needs Form 3115.

In India, Ind AS 115 follows IFRS 15 on contract assets, contract liabilities and revenue over time, with a few India-specific additions (ICAI educational material on Ind AS 115).

Who this deferred revenue schedule template is for, and what it does not do

It suits SaaS finance teams, agencies on retainers, maintenance and support providers, training and membership businesses, and the bookkeepers and auditors who need a clean tie-out. If you also run payables, our accounts payable template sits alongside it, and the bank reconciliation template closes the loop on cash.

It recognises revenue evenly over time. It does not allocate a bundled price between products, handle usage-based fees or milestones, revalue foreign currency or model financing interest.

Related templates and guides

• Prepaid expense schedule template: the asset-side twin of this workbook.
• Accounts payable template: bills, payments, ageing and vendor statements.
• Bank reconciliation template: match the bank to the books every month.
• Excel financial dashboard template: ten dashboard designs for management reporting.
• MIS report format: the monthly report pack that deferred revenue feeds into.
• Cash flow decision tool: cash timing, which deferred revenue deliberately separates from revenue timing.
• AI prompts for auditors: prompts for reviewing a roll-forward and its support.

Please note: we update this page from time to time, but accounting standards, tax rules and their interpretation change, and there can be a gap between a change and our update. Check the standard or your adviser before you act. This template and guide help with working papers and estimates; they are not accounting, tax or legal advice, and ReconScribe is not responsible for decisions made on them.

Frequently asked questions

Sources

• FASB, ASU 2014-09, Revenue from Contracts with Customers (Topic 606)
• FASB, Comparison of Topic 606 and IFRS 15
• IFRS Foundation, IFRS 15 Revenue from Contracts with Customers
• IFRS Foundation, IFRS 18 Presentation and Disclosure in Financial Statements
• IRS, Publication 538, Accounting Periods and Methods
• ICAI, Educational Material on Ind AS 115