Skip to content
DeferSheet › Deferred revenue schedule template (Excel)

Deferred revenue schedule template (Excel)

Download the free Excel template — invoice lines down the side, 24 months across, with a daily-proration formula in every cell. Or drop your invoices below and let DeferSheet build it for any number of lines.

🔒 Invoices never leave your browser🧾 Stripe · QuickBooks · Xero · CSV/Excel📊 Excel with live check formulas🆓 Free, no signup

How it works

  1. Download the template and replace the example lines with your invoices: amount, service start and end.
  2. Change the first month in the header row; every column recalculates. Deferred revenue at a month-end is the amount minus the months up to and including it.
  3. Outgrown the spreadsheet? Drop your invoice export into the tool above to get the same schedule plus the rollforward, waterfall and journal entries.

Why DeferSheet

For founders, controllers and bookkeepers of subscription and services businesses who close the books monthly — and are tired of maintaining the deferred revenue spreadsheet by hand.

Starts from your invoices

Drop a Stripe invoice export, a QuickBooks Sales by Customer Detail report, a Xero invoice export or any CSV/Excel. Combine several files; DeferSheet maps the columns and skips voids, drafts and total rows.

Exact schedules

Daily proration or equal months, mid-month starts, multi-year prepaids, setup fees recognized at once, billing in arrears, and credit notes netted per contract. Every line adds up to the cent.

Waterfall & rollforward

Opening + billings − revenue = closing, month by month, with unbilled revenue separately. The revenue waterfall shows each month's billings turning into revenue.

Journal entries you can import

The month-end entry split by revenue account, as a QuickBooks Online journal CSV or a Xero manual journal CSV, using your account names and codes.

Current vs long-term

Deferred revenue at the close, split into the next 12 months and later — per contract and in total — ready for the balance sheet.

Private by design

Invoices are processed in your browser tab. No account, no upload, no connection to Stripe or your books. Only your settings are remembered.

FAQ

What formula does the template use?

Each month cell is amount × days of service inside that month ÷ total days of service, rounded to cents: =ROUND(amount × MAX(0, MIN(end, month end) − MAX(start, month start) + 1) ÷ (end − start + 1), 2).

Is the template really free?

Yes. It's a plain .xlsx file with no macros, no signup and no watermark.

Is my data uploaded?

No. Your invoice files are read and calculated by JavaScript running in your browser tab and are not saved anywhere — not even in your browser. Only your settings (close month, method, account names) are remembered locally. There's no account and no server copy.

What is deferred revenue?

Money invoiced for service you haven't delivered yet — for example the unused months of an annual subscription paid upfront. It's a liability until it's earned, then it moves to revenue month by month.

Which exports work?

Stripe invoice exports and Sigma line-item queries, QuickBooks Online Sales by Customer Detail and invoice lists, Xero invoice exports, Chargebee or any billing system's invoice CSV, and Excel files. You need an amount and an invoice date per line, ideally with service start and end dates or a term.

Is this ASC 606 compliant?

DeferSheet applies ratable (or point-in-time) recognition over the service periods in your file, which is how ASC 606 and IFRS 15 treat most subscriptions and services. It doesn't decide performance obligations, allocate prices or handle contract modifications — review the policy with your accountant.

What's free?

Deferred revenue, current vs long-term, unbilled revenue, the rollforward, the future schedule and a waterfall preview for files of any size, plus journal entries and every download for files up to 50 invoice lines. Pro unlocks the full waterfall, entries and downloads for any number of lines.

More deferred revenue tools & guides