Deferred Revenue Revaluation Report—AR or Order Entry

If your company uses multiple transaction currencies and revenue recognition, you can use the Deferred Revenue Revaluation Report to revalue revenue recognition schedule entries. When the system created those entries, it used a specific exchange rate as of a certain date. You can change the exchange rate type and as of date, and calculate the currency gain/loss for every row of the revenue recognition schedule-entry table.

  • General Ledger Revaluation report: a general-purpose revaluation report.
  • Cash Management Revaluation report: for revaluing foreign currency bank accounts.
  • AP Open Items Revaluation report: for revaluing pending foreign-currency transactions.
  • AR Open Items Revaluation report: for revaluing pending foreign-currency transactions.
  • Deferred Revenue Revaluation report: for revaluing revenue recognition schedule entries.

Revalue inter-entity transactions by including your inter-entity accounts in your General Ledger revaluation report.

You can filter the resulting data in several ways, such as by customer, customer type and transaction currency, as well as any enabled dimensions. And you can generate a condensed summary report or a more detailed one that contains additional columns of information. You can group the information by customer and currency or location and currency.

The Deferred Revenue Revaluation report is provided as an informational source only.

To find the Deferred Revenue Details report:

  • Go to Order Entry or Accounts Receivable > All > Reports > Deferred revenue > Revaluation.

Subscription
  • Order Entry
  • Revenue recognition for Order Entry or Accounts Receivable
User type Business
Permissions

General Ledger

  • Deferred revenue revaluation report: Run

Get the monthly report right away

  1. On the report settings page, select View.

    The report displays all results for the default reporting period.

  2. To refine the report, select Customize.

Customize and run this report

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

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.

  1. 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, revenue account or deferred revenue 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.

  2. 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.

  3. Type a title, subtitle, and footer for your report.
  4. View, process, memorize, or export the report.

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.

Set 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:

Filter fields Description

Revalue as of date

The date to use (on or before)to select revenue recognition schedule entries for this report. Intacct uses this date to select those revenue recognition schedule entries with a posting date on or before this date.
Revaluation exchange rate types Determines the exchange rate type to use for the revaluation calculation. Select an exchange rate type such as Intacct Daily Rate or WSJ Published Rate.

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.

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.

  1. 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.

  2. 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.

  3. 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

Displays only for multi-currency multi-entity organizations. Enables you to display transactions for certain locations regardless of the location selected in the Location drop-down list.

  • All locations: show transactions for all locations, regardless of the location selected in the Location drop-down list.
  • This location: show transactions only for the currently selected entity.
  • Child locations: shows transactions only for areas subordinate to the location of your entity.

Hide entries

Select this checkbox to hide the schedule details.

Dimensions

Filter the report by any dimensions that you've enabled, including user-defined dimensions, and dimension groups.

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.

Project type

Vendor type

Employee type

Filter the report by dimension types that you've created. Dimension types are used to categorize objects.

Learn more about project types, vendor types, and employee types.
Product line Filter the report by product line.

Set the report format

You can choose Customer and currency or Location and currency. The system sorts the records by customer (or location) and then by the currency of the particular transaction.

  1. Select the desired report display format. Summary is the default.
  2. To arrange related data together by group, select the desired Group by option.
  3. To change the page layout, select the desired Page orientation option.
  4. Select the dimension values you want to appear on the report.

The following table describes each item in the Format section of this report settings page:

Format field Description

Show
  • Summary: Produces a shorter report in which the detail for each customer and currency or location and currency is summarized in one line.
  • Detail: Displays additional columns to the report and breaks down information by item or account label.

Group by
  • Customer and currency: Groups report data by each unique combination of customer and currency.
  • Location and currency: Groups report data by each unique combination of location and currency.

Page Orientation
  • Portrait: Displays the report pages vertically. This is the default.
  • Landscape: Displays the report pages horizontally.

Show dimension values

 Select one or more dimension values to display in the Detail view of the reports. Select Add or edit to move Available items to Selected items.

Add titles and a 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.

  1. Type the title in the Report title 1 box.
    • This title displays in large type at the top of the page, directly under your company name,
    • You can type over any default name that appeared automatically in this box.
  2. Type the subtitle in the Report title 2 box.

    This subtitle displays in smaller type, directly beneath the main title.

  3. Type the footer text in the Footer text box. Footer text displays at the bottom center of the report.

You can use up to 80 characters, including spaces, in each title, subtitle, and footer.