#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.
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:
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.
Summary
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