Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesFinanceFinancial Statements & ReportingDeferred Revenue Schedule

SpreadsheetFinancial Statements & ReportingFree

Deferred Revenue Schedule

Recognise prepaid contracts month by month, split the deferred balance into current and long-term, and forecast revenue from contracts already billed.

Shown with sample data

Colour

Deferred Revenue Schedule

Recognise prepaid contracts month by month, split the deferred balance into current and long-term, and forecast revenue from contracts already billed.

Deferred revenue balance
$306,150
Agree to the trial balance
Revenue this month
$18,490
Current portion
$182,150
Recognised in the next 12 months
Long-term portion
$124,000
Contracted revenue, next 12 months
$182,150
Contracted revenue by month
  • Dec 1, 2026$22,090
  • Jan 1, 2027$22,090
  • Feb 1, 2027$19,990
  • Mar 1, 2027$13,790
  • Apr 1, 2027$13,790
  • May 1, 2027$13,300
  • Jun 1, 2027$13,300
  • Jul 1, 2027$13,300
  • Aug 1, 2027$13,300
  • Sep 1, 2027$12,400
  • Oct 1, 2027$12,400
  • Nov 1, 2027$12,400
Deferred balance by customer
  • Ridgeway Clinics$161,200
  • Cedar Health$68,400
  • Summit Dental Group$43,200
  • Harbor Logistics$18,600
  • Bluepeak Retail$8,100
  • Atlas Freight$4,200
  • Pine & Paper$2,450

How to use it

  1. 1On Settings, type the period-end date you are reporting.
  2. 2Add each billed contract with its value, the date service starts and the term in months.
  3. 3Read revenue this month and the deferred balance; agree the total to the deferred revenue account in the trial balance.
  4. 4Use the Waterfall sheet to see revenue to be recognised in each of the next 12 months, and add new billings as they happen.
  5. 5Report the current and long-term portions separately on the balance sheet.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

When customers pay up front, the cash is not revenue yet. This schedule takes each billed contract, recognises it straight-line over the service period, and shows revenue to date, revenue this month, the remaining deferred balance and its split into current (next 12 months) and long-term, plus a forward waterfall of revenue already contracted and a roll-forward of the deferred revenue balance.

Who it’s for

  • Annual and multi-year subscriptions billed in advance
  • Month-end deferred revenue reconciliation
  • Forecasting revenue already under contract

What’s included

  • Contracts sheet: Each billed contract and its recognition to the period end.
  • Waterfall sheet: Revenue already contracted for each of the next 12 months, and the deferred balance roll-forward.
  • Settings sheet: The reporting date.

How to use it

  1. 1On Settings, type the period-end date you are reporting.
  2. 2Add each billed contract with its value, the date service starts and the term in months.
  3. 3Read revenue this month and the deferred balance; agree the total to the deferred revenue account in the trial balance.
  4. 4Use the Waterfall sheet to see revenue to be recognised in each of the next 12 months, and add new billings as they happen.
  5. 5Report the current and long-term portions separately on the balance sheet.

Tips

  • Only billed (or collected) amounts belong in deferred revenue. Signed but unbilled contract value is backlog, not a liability.
  • Recognise implementation or set-up fees according to your revenue policy; under ASC 606 and IFRS 15 they are often spread over the contract.
  • Agree the waterfall total for the next 12 months to the current portion; it should match when no new billings are included.

Questions

What is deferred revenue?

Money received or billed for goods or services not yet delivered. It is a liability until the work is done, then it moves to revenue.

How is deferred revenue recognised?

For subscriptions, usually straight-line over the service period: contract value ÷ months, each month. This schedule uses a full-month convention, starting in the month service begins.

What is the journal entry each month?

Debit deferred revenue and credit revenue with the amount recognised this month.

Is this ASC 606 compliant?

It applies straight-line recognition to a single performance obligation. Contracts with several obligations, variable pricing or milestones need allocation under ASC 606 or IFRS 15; ask your auditor.

Related searchesdeferred revenue schedulerevenue recognition scheduleunearned revenue templatedeferred revenue waterfallasc 606 schedulesaas revenue recognition

Details

Format
Spreadsheet
Category
Financial Statements & Reporting
Sheets
3
Setup
10 min
Level
Advanced
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetFinancial Statements & ReportingFree

Deferred Revenue Schedule

Recognise prepaid contracts month by month, split the deferred balance into current and long-term, and forecast revenue from contracts already billed.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Financial Statements & Reporting
Sheets
3
Setup
10 min
Level
Advanced
Price
Free

Your copy is private to you.

More financial statements & reporting templates

View all
Small Business Profit and Loss Statement3 sheets

Revenue

$54,650

Gross margin

64%

Net profit

$7,460

Net profit by month
$7,460
$6,365
$3,620
$3,080
$1,650
Nov 2026Oct 2026Sep 2026Jul 2026Jun 2026
SpreadsheetFinancial Statements & Reporting

Small Business Profit and Loss Statement

Monthly P&L against budget and last month, with gross and net margin and a six-month trend.

10 min setupPreview
Monthly Financial Dashboard2 sheets

Revenue this month

$655,000

Revenue, last 12 months

$7,013,000

EBITDA margin this month

16%

EBITDA by month
$57k
$38k
$62k
$79k
$78k
Dec 2025Jan 2026Feb 2026Mar 2026Apr 2026
SpreadsheetFinancial Statements & Reporting

Monthly Financial Dashboard

One page that answers how the business did this month: revenue, margins, EBITDA, cash, DSO and customers against target, with 12-month trends.

10 min setupPreview
Trial Balance2 sheets

Adjusted debits

$57,150

Adjusted credits

$57,150

Difference

$0

ABCD
1AccountTypeDebitCredit
2BankAsset$18,400$0.00
3Accounts receivableAsset$6,200$0.00
4Prepaid insuranceAsset$1,200$0.00
5EquipmentAsset$9,000$0.00
Trial balance
SpreadsheetGeneral Ledger & Trial Balance

Trial Balance

Closing balances by account in debit and credit columns with a balance check and totals by statement section.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ