Skip to content
DeferSheet › QuickBooks deferred revenue schedule

QuickBooks deferred revenue schedule

Outside QuickBooks Online Advanced's revenue recognition feature, QuickBooks doesn't build a deferred revenue schedule from your invoices. Export a sales report, drop it here, and import the month-end journal entry back.

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

How it works

  1. Export from QuickBooks: Reports → Sales by Customer Detail (or Invoice List), customize to add Service Date and Product/Service, and export to Excel.
  2. Drop the file. DeferSheet reads QuickBooks' customer sections, skips total rows and nets credit memos. Add service end dates or a default term for lines without one.
  3. Import the entry: download the QuickBooks journal CSV and use Settings → Import data → Journal entries in QuickBooks Online.

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

Does QuickBooks track deferred revenue?

QuickBooks Online Advanced has a revenue recognition feature for products and services set up with a recognition schedule. Other plans need manual journal entries — which is what DeferSheet generates, for any plan.

Do account names have to match?

Yes. QuickBooks matches journal entry lines by account name, so set the deferred revenue, revenue and unbilled account names in Settings to exactly the names in your chart of accounts (use Parent:Child for sub-accounts).

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