Table of Contents

• Report Description & Purpose
• Report Calculations Explained
• Predefined Filters
• Drill-Down Behavior
• Use Case Examples

Report Description & Purpose

This report shows the balance of all Unbilled Receivables Accounts as of the end of a selected month, and a forecast of expected changes in Unbilled Receivables based on the latest Billing Schedules and Revenue Schedules.

This report forecasts changes to Unbilled Receivables in future periods (relative to the selected As of date) based on any relevant Revenue Schedules or Billing Schedules. Manual Journal Entries are included for future periods.

Report Calculations Explained

• Deferred Revenue Balance: Total balance in all Unbilled Receivables accounts* as of the end of the selected month.
  * Accounts with Unbilled Receivables as the Account Sub-Type.
• Sum of Future Amounts: Total anticipated increase or decrease to Unbilled Receivables accounts in future periods beyond the selected month, determined by an unposted Subscription's Billing Schedules (-) and Revenue Schedules (+), Draft Invoices, as well as Future Postings (Total balance in all Unbilled Receivables accounts after the end of the selected month).
• Variance: The anticipated remaining balance in Unbilled Receivables accounts after all future Journal Entries for Billing and Revenue Schedules have been posted.
• Total Amount (by month): Net anticipated increase or decrease to Unbilled Receivables accounts in a given month, determined by an unposted Subscription's Billing Schedules (-) and Revenue Schedules (+), Draft Invoices, as well as Future Postings (Total balance in all Unbilled Receivables accounts after the end of the selected month).

Predefined Filters

The following filters are automatically applied to the Unbilled Receivables Waterfall by Customer Report. Click the Filters arrow to expand the section and adjust the criteria as needed. 

Notes on Filters

• The As of filter determines the starting point for the report and sets the month for calculating balances.

• The End filter defines how far into the future the system should forecast changes (Billing/Revenue Schedules, Draft Invoices, etc.).

• Subscription Status ensures that only subscriptions matching the criteria are included in calculations.

• Reporting Currency allows users to run the report in a consistent currency for multi-currency environments.

Drill-Down Behavior

Clicking any value in the report (except Variance) opens a detailed Unbilled Receivables Waterfall by Customer view with supporting data such as:

• Journal Entries

• Billing Schedule Lines

• Revenue Schedule Lines

This drill-down shows the transactions contributing to that period’s values.

Use Case Examples

Example 1: Billing and Revenue Schedule Impact

When a Subscription Charge is configured with both Billing and Revenue Schedules:

• Negative amounts appear in periods where invoices are scheduled to post (Billing Schedule).

• Positive amounts appear when revenue is scheduled to post (Revenue Schedule).

• Manual Journal Entries affecting Unbilled Receivables also appear.

Example 2: Exact Days Revenue Recognition

If revenue is recognized using Exact Days:

• Future periods show Positive amounts when Revenue Schedules post revenue.

• Subscription-related adjustments or Manual Journal Entries affecting Unbilled Receivables will also be included.

Example 3: Recognize on Invoicing

If the Subscription Charge is set to Recognize on Invoicing, and no Unbilled Receivables activity is generated:

• The charge will not appear in this report.