Paid up front, earned over time: a deferred revenue schedule you can check
An annual plan or a retainer puts a year of cash in the bank in one day. If the books call it income that day, one month looks spectacular and the next eleven look like losses, and the balance sheet hides the service you still owe. A deferred revenue schedule spreads it over the months you deliver; a waterfall shows what is still to come.
Worked example: three plans, $9,000.00 collected
A synthetic small business sells three things paid in advance: Acme's annual plan ($1,200.00 from 15 January, earned by the day), Beta's six-month retainer ($3,000.00 from 1 March, equal monthly shares) and Gamma's two-year plan ($4,800.00 from 10 May, by the day). Each payment is filed to 2400 Unearned revenue. At 30 June the register reads:
| Plan | Paid | Earned by 30 June | Still to earn |
|---|---|---|---|
| Annual plan (Acme), 167 of 365 days | $1,200.00 | $549.04 | $650.96 |
| Six-month retainer (Beta), 4 of 6 months | $3,000.00 | $2,000.00 | $1,000.00 |
| Two-year plan (Gamma), 52 of 731 days | $4,800.00 | $341.45 | $4,458.55 |
| Total | $9,000.00 | $2,890.49 | $6,109.51 |
Booked as cash, the first half shows $9,000.00 of income. Booked as earned, it shows $2,890.49, and the balance sheet carries $6,109.51 of service still owed. That second picture is the one a lender, an investor or a buyer of the business asks for, and the one that tells you whether this year's sales actually cover this year's costs.
The waterfall: what is already paid for, month by month
| Plan | Jul | Aug | Sep | Oct | Nov | Dec | Later |
|---|---|---|---|---|---|---|---|
| Annual plan | 101.91 | 101.92 | 98.63 | 101.92 | 98.63 | 101.92 | 46.03 |
| Six-month retainer | 500.00 | 500.00 | - | - | - | - | - |
| Two-year plan | 203.55 | 203.56 | 196.99 | 203.56 | 196.99 | 203.55 | 3,250.35 |
| Total | 805.46 | 805.48 | 295.62 | 305.48 | 295.62 | 305.47 | 3,296.38 |
Of the $6,109.51 still owed, $4,047.67 is earned in the next twelve months (a current liability) and $2,061.84 after (long term). The drop after August is the retainer ending: revenue that has to be renewed or replaced, visible four months ahead.
How to do it
- Import your bank statement in AI Bookkeeper and file each up-front payment to 2400 Unearned revenue (or put 2400 on the invoice, if you invoice).
- Register each plan on the page's "money paid up front" card, or from the command line:
deferred add Annual plan --amount 1200 --start 2026-01-15 --months 12 --customer Acme. Many at once:deferred import plans.csv(name, amount, start, end or months; customer, date, account and method optional). For periods that end on the anniversary, as subscription billing exports often write them, add--end-exclusive. - Read the reports. The monthly entries move each share to income at month end;
deferred waterfallprints the schedule (--csvfor a spreadsheet). The close checks warn when 2400 in the ledger and the register disagree: a payment with no plan, or a plan with no payment. - Cancellations.
deferred cancel DR-1 --date 2026-09-10stops earning that day and leaves the rest as a refund owed;--keepearns it instead, for a non-refundable plan. When you pay the refund, file it to 2400 and rundeferred refunded DR-1 --date ....
A straight line is the simple case. Bundles, set-up fees, usage pricing and discounts have more rules (ASC 606 in the US, IFRS 15 elsewhere), and tax timing can differ from the books: a cash-method filer generally counts the payment when it arrives, and the tool's cash-basis report does exactly that. Tested on hand-made plans only; check the output against your contracts.
Questions
What is deferred revenue?
Money a customer paid before you delivered what it pays for: an annual plan, a retainer, a prepaid class pass. Until you deliver, you owe the service (or a refund), so it sits on the balance sheet as a liability called deferred or unearned revenue, and moves to income as the service is delivered.
Why not count it as income when it arrives?
Because the month the cash lands then looks far more profitable than the months you actually serve the customer, and the balance sheet hides what you still owe. A lender, an investor or a buyer reading accrual statements expects the income spread over the service period. A cash-method tax filer may still count it when received for tax; that is a separate question for your preparer.
Daily or monthly?
Daily spreads by days of service, so a plan starting on the 15th earns about half a month in its first month. Monthly gives each calendar month the period touches an equal share, a common simplification for retainers. Both close to the exact cent at the end of the period.
What is a deferred revenue waterfall?
A table of what is still to be earned, month by month, from today forward. It shows the revenue already paid for in each coming month, and splits the balance into what will be earned in the next twelve months (current) and later (long term).
Is it free?
Yes. It is open source (MIT), runs in your browser or as a command line tool, and nothing is uploaded.
Open AI Bookkeeper and register your first plan.