Enhanced interface

Deferred revenue details report—Accounts Receivable or Order Entry

The Deferred revenue details report shows the transaction line item details for which you have deferred revenue.

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

Subscription

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

User type

Business user

Permissions

General Ledger

Deferred revenue details: Run

What's in this report?

The Deferred revenue details report includes the columns listed in the following table.

Column heading	Description
Customer ID*	The identifier associated with the customer.
Customer name*	The customer associated with the corresponding revenue amount.
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.
Transaction date	The sales transaction date.
GL posting date	The sales transaction's GL posting date. Only applicable if Accounts Receivable is configured to Enable override of GL posting date during entry.
Cancellation date	The termination date. This date depends on the option selected when the revenue schedule was terminated: All: If no revenue was posted, the cancellation date equals the schedule start date. If revenue was posted, the cancellation date is the day after the last posted entry. Any scheduled after the schedule's next posting date: The cancellation date is the day after the last open entry (soon to be posted). Any after specified date: The cancellation date equals the date that you select.
Item ID	The item ID associated with the corresponding document line number.
Item name	The item name associated with the corresponding item ID.
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.
Revenue recognition category	The reason for the hold or termination. This field only displays for revenue recognition schedules with On hold or Terminated status and for which a category was selected when the schedule was acted upon.
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.
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.
Department Location/Entity Class Customer Supplier Project Employee Warehouse	The report displays the dimension names 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.
Base amount*	The total amount to be recognized for the corresponding transaction line item expressed in the base currency.
Amount deferred*	The portion of the total amount that has not been recognized.
Amount recognized*	The portion of the total amount that has been recognized.
FX gain or loss recognized*	The total gain or loss recognized for the corresponding recognized amount. These values are posted to the Multi-currency gain and loss account defined in the Configure Accounts Receivable page.
Amount paid*	The portion of the total amount that has been paid.

* indicates columns that display in both summary and detail views.

Choose report options and run this report

See Field descriptions for detailed information on each field.

Go to Order Entry or Accounts Receivable > All > Reports > Deferred revenue > Details.
Specify the desired Time period settings.
Select the desired Format options.
(Optional) Enter a title, subtitle, and footer for your report.
Select View. The report appears.
If you do not see the desired results, select Customize, adjust the report options, and select View again.

Field descriptions

The following tables describes each report option in the following sections on the Deferred revenue details page.

Time period
Filters
Format
Title

Time period

Either select a Reporting period/As of date combination or select a Start/End date combination.

If you complete all of the fields, Intacct bases your report only on the specified Start or End date combination.

Field	Description
Reporting period	The standard time interval such as current month, current quarter, and so on, that contains the transactions you want.
As of date	The date from which the selected Reporting period is calculated. For example, say you set the As of date to April 15. You want to see revenue for a transaction dated March 21. If you select Reporting period = current month and run the report, it will not display the transaction dated March 21 as the month in the As of date is April. If you select Reporting period = prior month, it will display the transaction dated March 21. Similarly, if you set the As of date to March 15 and select Reporting period = current month, it will display the transaction dated March 21 as March is the current month in this scenario. This field defaults to the current date.
Start date End date	Specify a date range that includes the transactions you want. Leave the Start Date blank to include all information from the earliest date you entered data into your company up to and including the End date. Leave the End Date blank to include all information from the Start date up to today. If you leave both the Start date and End date blank, Intacct uses the Reporting period/As of date combination.
Prompt on Run	Select this checkbox to force the system to wait for you (or anyone using this report) to enter a location, department, and/or time period before it will run the report.
Display amount deferred, recognized, and paid as of this date	Specify a date to display the deferred, recognized, and paid amounts at a specific point in time. For example, say that you specify May 1 as this date and you have a transaction with a revenue schedule for which you posted revenue on May 2 and you run the report. The Amount recognized for that schedule will not include the revenue posted May 2. To reconcile the amount recognized, deferred, and paid to the General Ledger, change this date to a GL month-end date.
Based on

Filters

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

Field	Description
Include schedules not started	Displays transaction line items with revenue schedules with status = Not started. This indicates all entries are still open; no revenue has been recognized.
Include schedules in progress	Displays transaction line items with revenue schedules with status = In progress. This indicates at least one entry is posted. Some revenue is recognized, but not all.
Include schedules on hold	Displays transaction line items with revenue schedules with status = On hold. This indicates no further revenue is recognized until the schedule is resumed or the transaction line item is delivered and no modifications can be made to the revenue schedule.
Include partially terminated schedule	Displays transaction line items with revenue schedules with status = Partially terminated. This indicates a portion of the revenue schedule has been terminated.
Include terminated transactions	Displays transaction line items with revenue schedules with status = Terminated. This indicates no further revenue will be recognized for the transaction line item.
Include completed transactions	Displays transaction line items with revenue schedules with status = Completed. This indicates all scheduled revenue has been recognized.
Revenue account	The report includes transaction details for every revenue account, unless you select a specific account.
Deferred revenue account	The report includes transaction details for every deferred revenue account, unless you select a specific account.
Revenue recognition template	The report includes transactions for every revenue recognition template unless you filter the data by a specific template. For example you might want to see all the rev rec details for your 12-month contracts spread evenly versus viewing the data for all the different templates.
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 system default the same name to To customer. 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	The report includes transactions for every customer type unless you select a specific customer type. If your customers are grouped into subset types, such as Direct, Channel, and Partners, you could then filter the report for a specific subset, such as Direct.
Revenue recognition category	The report includes transactions for every revenue recognition category unless you select a specific category.
Transaction currency	If you are a multi-currency company, you can filter transactions based on a specific currency. (This field is visible only in a multi-currency environment). From the Transaction currency dropdown list, select the currency you want the report to show. If you do not select a currency, the report includes transactions in your base currency. In a multi-entity environment, you can filter by location, department, or both. To set location and department options: To filter the report by geographic location, either enter the name of the region, country, state or territory, or city in the Location dropdown list. Or, select the location from the list. Enter or select a location if you want to run this report at the top level. The system uses the location that you specify to determine the appropriate currency. To filter the report by department within the company, enter the name of the department in the Department dropdown list. Or, select the department from the list. If you want the report to cover certain locations regardless of what's selected in the Location dropdown list, use the Show for dropdown list to select the locations for the report: All locations: To include data for all locations regardless of the entity that you're currently using. This location: To include data only for the entity that you're currently using. Child locations: To include data only for the locations that are child locations of your current entity. 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.
Show for	The report includes transactions for all locations, unless you select a different option, such as the current location, or child locations.
Dimensions	Filter the report by any dimensions that you've enabled, including user-defined dimensions, and dimension groups. 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.

Format

Field	Description
Report type	Select one of the following options: Summary—Displays a subset of all possible report columns. See the columns marked with an asterisk in the What's in this report table. Detail—Displays all possible report columns.
Display subtotal	If you select Detail as the Report type, the report includes subtotals for each Group by section. For example, if you select Group by = Customer name, the report displays a subtotal for each customer. Clear this checkbox to not include subtotals.
Group by	Select how to group related data together. For example, you can group transaction line items by customer, by document number, by Item ID, and more.
Sort by	Select the data element on which to sort the transaction line items. For example, you can sort by Customer name, by amount deferred, and more. If you see "desc" after a data element, like Amount deferred desc, that indicates that option sorts in descending order.
Page orientation	Select whether to display the report as Portrait or Landscape.
Show dimensions values	Select the dimension values you want to appear on the report. Select Add or Edit to open the multi-select box and then add or remove the dimension values as applicable.

Titles and footer

Report titles and footer display on a report when you print or export it.

The maximum number of characters, including spaces, in each title or footer field is 80.