Enhanced interface

Deferred Revenue Forecast Report—AR or Order Entry

The Deferred Revenue Forecast Report shows how deferred income is recognized as revenue over time. Use this report to forecast revenue by time period, account, customer, and more.

Who typically needs this report?

Finance staff who need to:

Budget and forecast revenue in-flows, based on prior projections.
Place revenue on hold or terminate it, or analyze revenue lost due to contract cancellations and terminations.
Determine how much revenue has yet to be recognized (on-hold forecasting). Running this report shows what the revenue would look like if the on-hold revenue were released. With that information, finance staff can look into the reasons why revenue is on hold. For instance, are there issues with collecting revenue or delivering products? Is the service team not turning things around as fast as it could? The report can make visible problems in excess deferred revenue.

For information on terms that may differ in your location, see Terminology across locales.

To find the Deferred Revenue Forecast report, go to Order Entry or Accounts Receivable > All > Reports > Deferred revenue and select Forecast.

Subscription	Order Entry or Accounts Receivable Revenue recognition for Order Entry or Accounts Receivable
User type	Business
Permissions	General Ledger Deferred revenue forecast report: Run

Subscription

Order Entry or Accounts Receivable
Revenue recognition for Order Entry or Accounts Receivable

User type

Business

Permissions

General Ledger

Deferred revenue forecast report: Run

View a report

On the report settings page, enter the desired filter criteria. The Location filter is required for multi-entity companies that have enabled multiple base currencies.
Select View.
The report displays all results for the default reporting period.
To refine the report, select Customize.

You can use trial-and-error to get the precise results you want. Just fill in the desired fields, and select View to see the report. If the results aren't what you want, select Customize to return to the report setup page and refine the report further. Repeat this process until you're satisfied.

For complex financial reports that will be run regularly, save the report after you're done setting it up. The next time you're ready to run the report, you only have to change the As of date before running the report.

Time period

To set the time period that the report should cover, do one of the following:
- Enter an As of date and enter the desired number of periods to display.
- Enter a specific Start date and End date.
From the Forecast Period dropdown, select the desired forecast period format. Each column of the report will represent one period.

Limit online reports to no more than 60 periods. Limit PDF reports to no more than 12 periods.

Time period fields	Description
As of date	The date the system will use as a baseline for the reporting period you select. Defaults to today's date. Format = MM/DD/YYYY If you select an As of date, don't select a Start date and End date.
Start date End date	Enter both a Start and an End date to get forecast information for a date range. The maximum number of periods allowed is 60. For example, if you choose Monthly as the forecast period, the date range can only encompass 60 months. If you select a Start date and End date, don't select an As of date.
Forecast period	Select the forecast period format. Each column of the report will represent one period. Options are: Monthly: displays as MMM-YY. For example, Jun-20 Quarterly: displays as MMM-YY to MMM-YY. For example, Jan-20 tp Mar-20. Semi-annually: displays as MMM-YY to MMM-YY. For example, Jan-20 to Jun-20. Annually: displays as Year-YYYY. For example, Year-2020.
Number of periods	Use with the As of date and Forecast period fields as an alternate way to set the period of time you want the report to cover. For example, if you want a year of data and the Forecast period = Quarterly, enter 4 here and set the As of date to the beginning of the year; if the Forecast period = Monthly, enter 12 here, and so on. The maximum number of periods allowed are: 60 for online reports 12 for PDF reports

Filters

Use filters to focus the results of your report. You can set any combination of filters.

Filters Section	Description
Include schedules not started	Show revenue details for schedules that have not yet started. By default the report will cover revenue details for schedules that have not yet started (that is, the checkbox is checked).
Include schedules in progress	Show revenue details for schedules that are in progress. By default the report will cover revenue details for schedules that are in progress (that is, the checkbox is checked).
Include schedules on hold	Show revenue details for schedules that are on hold. By default the report will cover revenue details for schedules that are on hold (that is, the checkbox is checked).
Include terminated transactions	Show the details of transactions that have been terminated. By default the report will cover transactions that have been terminated (that is, the checkbox is checked).
Include completed transactions	Show the details of transactions that have been fully recognized. By default the report will cover transactions that have been fully recognized (that is, the checkbox is checked).
Include open period schedules	Show project revenue that has not been scheduled or posted. This filter is associated with Percent completed or Milestone recognition methods.
Report on	Options are: Revenue account Deferred revenue account (default)
Revenue account	Limit the report to transactions for a specific revenue account. By default this box is blank, which means the report will cover transaction details for every revenue account.
Deferred revenue account	Report deferred revenue accounts rather than revenue accounts. By default this box is blank, which means the report will cover transaction details for every deferred revenue account. Use this filter when Report on = Deferred revenue account.
Revenue recognition template	Limit the report to transactions that belong to a specific revenue recognition template. By default this box is blank, which means the report will cover transaction details for every revenue recognition template.
From customer / To customer	The report includes transactions for every customer unless you limit the report to transactions to a specific customer, or set of customers: Specific customer: Select a customer in From customer. The same name is used in To customer, but can be overridden. Set of customers: Select the first customer to be included in the set in From customer, then select the last customer to be included in the set in To customer.
Customer type	Limit the report to transactions for a specific customer type (such as Direct or Partner). By default this box is blank, which means the report will cover transactions for every customer.
Show transactions	This option defaults to All, which means the report includes all transactions regardless of whether they are posted. To limit the transactions covered, select: Posted transactions: includes only posted transactions Unposted transactions: includes only transactions yet to be posted
Document number	Limit the report to a single transaction. For example, if you want the report to cover only a specific invoice, type the number of the invoice that you want in this box.
Transaction currency	If you work in a multi-currency environment, you can set the currency you want the report to use. If you don't select a currency, the report contains transactions in your base currency. Displays only for multi-currency organizations.
Show for	Only applicable to multi-entity companies. If you want the report to cover certain locations regardless of what you select in the Location box, use the Show for dropdown list to select the locations you want the report to cover: If you want the report to include data for all locations regardless of the entity you're currently using, select All Locations. If you want the report to include data only for the entity you're currently using, select This Location. If you want the report to include data only for locations that are child locations of your current entity, select Child Locations. For example, if your current entity is California, and you have child locations for San Francisco and Los Angeles, use this option to have the report include data only for Los Angeles and California.
Dimensions Include subdimensions	Filter the report by any dimensions that you've enabled, including user-defined dimensions, and dimension groups. Location is required for multi-entity companies that have enabled multiple base currencies. What are dimensions? A dimension is a category of data that you can organize and sort in meaningful ways. Sage Intacct provides the following predefined dimensions: Location Department Class Customer Item Project Supplier Employee Warehouse (if you subscribe to Inventory Control) Contract (if you subscribe to Contracts) In addition, Intacct enables you to define new dimensions to suit your needs. Use these user-defined dimensions to organize and sort categories of data unique to your business. For example, if you’re a software company with multiple product lines, you can create a user-defined dimension called Line of business. Then add the values Direct customers, Channel partner, and OEM. Dimensions enable you to collect, sort, analyze, and report on data within one category, or between categories, so you can identify key factors such as: Your most profitable or most costly items or customers The return on investment of a project or department Whether and to what degree a new product or product line is successful Which way a particular aspect of your business is trending Intacct dimensions give you fine control over data definition and data hierarchy With dimensions, you can customize financial reports around specific business activities, get greater visibility into how the business is doing, and make faster, more meaningful business decisions. Think of dimensions as a more powerful alternative to subaccounts. Additional fees can apply for the Project dimension and user-defined dimensions. Contact your account representative for more information. To include child dimensions, such as child locations or child departments, check the Include subdimensions checkbox. Deselect this checkbox if you don't want to include children of the dimension when filtering.
Product line	Limit the report to items in a particular product line.
Supplier type Project type Employee type	Limits the report to the selected supplier, project, or employee type.

Format

Use the fields in this section to order the report results and to select the report layout.

Format Section	Description
Report Type	Select the report type you want. By default, you will get a summary report which condenses all account details into a single line. Selecting a Detail report type displays one line per customer per account. It also includes additional columns of information. If you select Detail, by default the report will also include subtotals for each customer. If you don't want to see subtotals for each customer, clear the Display Subtotal checkbox.
Display Subtotal	Select to show subtotals for each customer. Available only for a detail report.
Group By	Arrange related data together by group. For example, to see all of the data for each customer, select the drop-down box, and then select either Customer Name or Customer ID.
Sort By	Sort the data in the report by category. The abbreviation "desc" after an option means "Descending order", reverse alphabetical or reverse numerical order. The default sort order and number of options change depending on whether you want a summary report or a detail report.
Display Sublevel Total	Select to display sublevel totals. Available only if Report Type is set to Detail. This box is checked by default. which means that, when the Report Type is set to Detail, the report will by default also display sublevel totals. This checkbox is unavailable (that is, you can't clear this checkbox) if you set the Report Type to Summary.
Page Orientation	Set the report layout to either Portrait or Landscape mode. Portrait is the default layout.
Show dimensions values	You can multi-select values, as needed, and move them between Available and Selected. Dimension values provide you with more granular details to analyze as needed. For example, you might want to view how much revenue is deferred by project.

Titles and footer

Titles, subtitles, and footers apply only to the print versions of this report. Export to Excel or CSV, or select Print for a PDF version.

What's in this report?

The Detailed view of this report contains the following columns:

Column heading	Description
Customer name	The customer associated with the corresponding revenue amount.
Customer ID	The identifier associated with the customer.
Deferred revenue account Deferred revenue account name	The GL account number and name of the deferred revenue account associated with the corresponding revenue amount. These columns appear when Report on = Deferred revenue account when running the report.
Revenue account ID Revenue account name	The GL account number and name of the revenue account associated with the corresponding revenue amount. These columns appear when Report on = Revenue account when running the report.
Transaction date	The sales transaction date.
Document type	The name of the sales transaction definition associated with the corresponding revenue amount.
Document number	The unique sales transaction identifier.
Document line number	The line item entry number associated with the corresponding item.
Item ID	The item ID associated with the corresponding document line number.
Item name	The item name associated with the corresponding item ID.
Term start date Term end date	The revenue start and end dates associated with the corresponding document line number.
Transaction currency	The currency in which the associated transaction is expressed.
Schedule status	The revenue recognition schedule status associated with the corresponding document line number. Displays one of the following, depending on the schedule status filters selected when running the report: Not started: all entries are still open; no revenue has been recognized. In progress: at least one entry is posted. Some revenue is recognized but not all. On hold: no further revenue is recognized until the transaction is resumed, and no modifications can be made to the schedule. Partially terminated: a portion of the schedule has been terminated. The schedule includes one or more entries that are still Open. Terminated: no future scheduled revenue will be recognized. Completed: all scheduled revenue has been recognized.
Transaction line total (Base)	The extended price for the corresponding document line number expressed in the base currency. Negative amounts appear in parentheses, for example -50.00 displays as (50.00). The actual amount that posted to the GL depends on how the associated transaction definition was set up. For example, if the corresponding sales transaction is an Order Entry adjustment transaction, the amount that posted may have the opposite sign of the amount shown here. This value is for reference only and should not be used for reconciliation.
Department Location/Entity Class Customer Supplier Project Employee Warehouse	The report displays the dimension names and/or IDs selected in the Show dimension values selection box when running the report. The report displays the dimensions in the same order as they appear in the Show dimension values selection box. You can re-order the dimensions in the selection box and then re-run the report as desired.
Open	Project revenue associated with the document line number that has not been posted or does not have a scheduled posting date. Displays when you select Include open period schedules when running the report. See Project revenue recognition.
(MMM-YY) (MMM-YY - MMM-YY) Year-YYYY	The total revenue amount scheduled to post and/or actually posted for the corresponding period for the associated document line number. The format of this column depends on the Forecast period selected when running this report. If you used the As of date when running this report, the first column defaults to the MMM-YY of the as of date. For example, if the As of date is May 19, 2020, the first column shown for a monthly report is May-20. The first column shown for a quarterly report is May-20 to Jun-20. If you used the Start/End date combination when running this report, the first column defaults to the MMM-YY of the selected Start date.