Enhanced interface

Deferred Revenue Details Report—AR or Order Entry

The Deferred Revenue Details report shows the details of customers and transactions for which you have deferred revenue.

Use this report to see the transaction detail behind those deferred numbers and to tie back to the deferred balance on your GL (like an audit report).

Report content: transaction amount, transaction date, deferred amount, recognized amount, and amount paid.

Who typically needs this report?

Auditors who need to determine what constitutes the balance on the GL
Finance staff

To find the Deferred Revenue Details report, go to Order Entry or Accounts ReceivableAll > Reports > Deferred revenue and select Details.

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

Understand this report

The Deferred Revenue Details report is not, by default, a cumulative report; instead, it's a report for a specific period.

For example, if the current month is March and you want to see revenue recognized as of March 31, running this report shows you any transactions processed in March along with a breakdown of the revenue for the transactions that were deferred, recognized, and paid. However, if you want to see the cumulative results as of March 31, you need to backdate your report to include older transactions. Because you may have revenue schedules posting in the month of March for transactions dated six months ago, you must select a date range that includes the oldest schedule.

To ensure that you accurately display the cumulative amount deferred, recognized, and paid, be sure the date range you enter includes all transactions processed from inception (that is, from the time your company went live in the Sage Intacct application) to date.

This report includes only those transactions that are attached to a deferred revenue schedule line item. When you attach a line item to a deferred revenue recognition schedule, you begin the deferral process. Any line items not associated with a revenue recognition template don't go through a deferral process; this revenue is recognized immediately. These line items are not part of this report.

You should not use this report to tie back to revenue for the period on the GL because you may have a combination of revenue recognized , and some deferred and then recognized in this period (that is, deferred from a prior quarter and recognized this quarter).

View a monthly report

To run a report:

On the report settings page, select View.
The report displays all results for the default reporting period.
To refine the report, select Customize.

Customize and run

If you want to see every result for a particular category, simply run this report without entering any search or filtering information. However, the report may take a long time to run and may return too many results to be useful.

Before running the report, you can select the time period and types of items to include as well as specify how you want the report to appear.

To customize and run a report:

Select the reporting period from the drop-down menu, or enter the start and end dates you want the report to cover. If you don't specify a reporting period, the system generates a report for the current month to date.
You can specify either the reporting period or the start and end dates, but not both.
The start date and end date identify transactions created within this date range. Normally, the start date is from inception.
Set the filters to get the specific data you want.
Filters enable you to include or exclude specific types of data in the report, such as customer, item, or account. If you use dimensions, you can specify one or more dimensions or dimension groups. As a general rule, to get fewer and more precise results in your report, set more filters.
Format the report.
Format options vary from report to report. Generally, you can set the layout of the report and the grouping and display of the report contents. For example, you can select dimension values to be displayed in the report. Each selected dimension adds one column of information to the report.
Enter a title, subtitle, and footer text for your report.
If you don’t see the desired results, adjust the filter criteria and select View.
Learn more about report filters.

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

You can use the As of Date fields, or create your own period using the Start Date and End Date fields.

To set the time period you want to search:

In the Time Period section:
EITHER:
1. Select the Reporting Period down arrow, and then select the period you want.
2. Enter an As of Date (the date that the system uses as a baseline for the period you select. Leave blank for today's date).
OR:
Enter a specific start date and/or a specific end date. (If you prefer, you can also specify these dates by selecting the icon next to the each date box to open up a calendar window, and then selecting the date you want.
Enter a date into the Display Amount Deferred, Recognized and Paid As of This Date box to set a regular date. For example, you can set the first date of each month on which the system will defer, recognize, or pay the amount.

Time Period Section	Notes
As Of Date	Leave this box blank to use today's date. Only works with Reporting Period. Does not apply if you select a Start Date or an End Date.
Start Date, End Date	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.
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	To reconcile the amount recognized, deferred, and paid to the General Ledger, change this date to a GL month-end date.

Report filters

Use filters to focus the results of your report. In effect, filters enable you to isolate and assemble just the data you want. You can set any combination of filters.

To set filters to fine-tune your report results

Filters Section	Notes
Include schedules not started	By default this option is selected, which means the report includes revenue details for schedules that haven't started yet.
Include schedules in progress	By default this option is selected, which means the report includes revenue details for schedules that are in progress.
Include schedules on hold	By default this option is selected, which means the report includes revenue details for schedules that are on hold.
Include partially terminated schedule	The report includes revenue schedules that have Revenue posting status = Partially terminated. This field is selected by default.
Include terminated transactions	By default this option is selected, which means the report includes transactions that were the schedule was terminated.
Include completed transactions	By default this option is selected, which means the report includes transactions that were completely 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

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

Format this report

Select the desired Report type.
- The Summary report type condenses all account details to a single line
- The Detail report type displays one line per customer per account. It also includes additional columns of information.
  If you don't want to see subtotals for each customer, clear the Display subtotal checkbox.
Arrange related data together by group. To do this, select the Group By drop-down box, and then select the group you want. 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 the data in the report by category. To do this, select the Sort By drop-down box, and then select the sort order you want.
The abbreviation "desc" after an option means "Descending order", reverse alphabetical or reverse numerical order.
If you don't want the report to display sub-level totals, clear the Report Type checkbox.
This checkbox is unavailable (that is, you can't clear this checkbox) if you set the Report Type to Summary.
Set the report layout to either Portrait or Landscape mode. To do this, select the Page Orientation drop-down box, and then select the layout you want.
If you want to display specific values for your dimensions, select them in Show dimension values. To do this, select or multi-select values in the Available field, and select the right arrow to move them to the Selected field.

Format Section	Notes
Report type	Summary is the default type
Display subtotal	If you select Detail, by default the report also includes subtotals for each customer. If you don't want to see subtotals for each customer, clear this checkbox. Available only for a detail report
Group by	Arrange related data together by group
Sort by	The default sort order and number of options change depending on whether you want a summary report or a detail report
Page orientation	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.