Menu Close

#107 | NetSuite’s Deferred Revenue Waterfall Detail Report

The Deferred Revenue Waterfall Detail report reconciles the deferred revenue account balance on the balance sheet and provides a forecast of the expected revenue stream. In this guide, you will learn how to view the report and the other components in the report.

We will cover the following topics:

I suggest you watch the video. It’s easier to understand if you are a visual/audio learner. The content below is the same as the video. It’s for those who learn by reading.

Viewing Deferred Revenue Waterfall Detail Report

Once logged into NetSuite, follow these steps to view the report.

  • Step 1: Go to Reports → Revenue → Deferred Revenue Waterfall → Detail
  • Step 2: Accept the default value in the As of The default is the current period.
  • Step 3: Select a Value in the Subsidiary Context (if using OneWorld account).
  • Step 4: Select a Value in the Accounting Book (if using multi-book accounting).
  • Step 5: Click Refresh to apply filters.
Deferred revenue waterfall details in summary
Summary of Deferred Revenue Waterfall Details

When it comes to revenue recognition, A2Q2 has NetSuite Ninjas who can configure this in the system for you.

Deferred Revenue Categories

You run the Deferred Revenue Waterfall Detail Run after creating revenue recognition and deferred revenue reclassification journal entries for a current period.

The report divides deferred revenue into the following categories:

4 Deferred Revenue Categories
Deferred Revenue Categories

Report Columns

The report includes the following columns:

  • Customer
  • Unbilled Receivable Group
  • Currency (when the Multiple Currencies feature is enabled)
  • Source Document #
  • Source Type
  • Item
  • Deferred Revenue Account
  • Revenue Account
  • Deferred Revenue Balance

When looking at the report, remember the following:

  • You can click the values in the Customer and Transaction Number columns to open the associated records.
  • Report results are grouped by customer.
  • Unless the accounting preference Unbilled Receivable Adjustment Journal Grouping is set to Element, unbilled receivable adjustments are included in a separate row. This row has no revenue account.
  • There is one row for each group or arrangement.
Report Columns
Deferred Revenue Waterfall additional report columns

You just learned how to view the Deferred Revenue Waterfall Detail Report. To recap the topics discussed, click on the links below.

Leave a Reply

Your email address will not be published.

Share This

Copy Link to Clipboard