Revenue
$54,650
Gross margin
64%
Net profit
$7,460
Small Business Profit and Loss Statement
Monthly P&L against budget and last month, with gross and net margin and a six-month trend.
SpreadsheetFinancial Statements & ReportingFree
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
Recognise prepaid contracts month by month, split the deferred balance into current and long-term, and forecast revenue from contracts already billed.
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.
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.
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.
Debit deferred revenue and credit revenue with the amount recognised this month.
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.
Download a copy
Downloads need a free account.