Accrued revenue is earned but not yet billed. Deferred revenue is billed but not yet earned.
Accrued revenue is income earned in the period but not yet invoiced, recorded as a debit to accrued income and a credit to revenue. Deferred revenue is income invoiced or received before it is earned, held as a liability and released to revenue as the work is delivered. Track both with Excel schedules, reconcile them monthly and check the timing against your revenue recognition policy.
Revenue recognition is governed by your accounting framework, such as IFRS 15, ASC 606 or FRS 102. This guide covers the month-end mechanics; check the framework and your auditors for when revenue is earned.
Common examples are services delivered in the last days of the month and invoiced next month, time-and-materials work billed in arrears, and milestones reached but not yet billed.
For income spread evenly over a service period, such as annual support contracts or subscriptions, build one row per contract:
Number of months, counting both the start and end month:
=(YEAR(D2)-YEAR(C2))*12+MONTH(D2)-MONTH(C2)+1
Monthly release, in G2 and copied across and down:
=IF(AND(G$1>=EOMONTH($C2,0),G$1<=EOMONTH($D2,0)),$E2/$F2,0)
This releases an equal amount in each month of the service period. If contracts start mid-month and you release by days instead, divide by the number of days and multiply by the days falling in each month.
Closing balance at any month end is the amount less releases to date. In a column after the monthly grid, for the month whose date is in a cell named ThisMonth:
=$E2-SUMIFS($G2:$R2,$G$1:$R$1,"<="&ThisMonth)
Here G to R hold twelve months; widen the ranges to cover every month column in your schedule.
Sum that column and agree it to the deferred revenue account in the ledger.
Sum the current month's release column and post: debit deferred revenue, credit revenue. Many teams post it as a recurring journal driven by the schedule total.
Both accounts belong on your list of balance sheet accounts to reconcile monthly.
UK teams usually say "accrued income" and "deferred income"; US teams say "accrued revenue" and "deferred revenue" or "unearned revenue", and IFRS 15 and ASC 606 also use "contract asset" and "contract liability". Exclude VAT (UK) or sales tax (US) from the schedule and check current HMRC or state rules for when tax is due on advance payments.
Risk-ranks every journal entry with an on-device AI and 17 audit tests, catches descriptions posted to the wrong account, runs Benford's law and selects a repeatable sample. Runs in your browser on your own computer: nothing is uploaded.
12 questions on how strong your close controls are. Free to use online.
The Balance Sheet Reconciliation Library covers the balance sheet with nine working papers: a known error blocks sign-off, every supported balance needs an evidence reference and every aged item needs an owner and a next action. Excel, no macros, one-time price.
A liability. You've been paid or have invoiced for something you still owe the customer.
No. Accrued revenue hasn't been invoiced yet. Once invoiced, it becomes a receivable.
Build a schedule with each contract's start date, end date and amount, divide the amount by the number of months, and release that amount in each month of the service period.
Last updated 28 October 2026. General guidance for finance teams; check it against your own policies, systems and local rules.