Manage revenue recognition schedules—AR or Order Entry

Revenue recognition schedules track revenue deferred from Accounts Receivable or Order Entry sales transactions. Each schedule shows when a transaction line item's deferred revenue is expected to be recognized during the recognition term.

Use the Manage Revenue Schedules page to:

  • Post revenue from revenue recognition schedules
  • Hold, resume, or terminate revenue recognition schedules
  • Deliver transaction line items (if your company is using event-based recognition)

To see a list of all revenue recognition schedules, see the Revenue recognition schedules list.

Learn more about revenue recognition schedules.

Basic steps to act upon revenue recognition schedules

  1. Set filters for the desired action and preview revenue recognition schedules.
  2. Select the desired revenue schedules, add any action details (if applicable), and execute the action.

1. Set filter options and preview schedules

Setting filter options enables you to narrow the focus of the items upon which you want to act. For example, you might only want to act upon revenue recognition schedules for a specific customer or a specific project.

In a multi-entity company, you can only act upon revenue recognition schedules on transactions that are created at the same level in which you are accessing the Manage Revenue Schedules page. If you're at the top level, you can act upon schedules created at the top level. If you're at the entity level, you can act upon schedules created at that entity level.

  1. Go to Accounts Receivable or Order Entry> All > Revenue recognition > Manage revenue schedules.

  2. Select the desired Action option.
  3. Use the calendar tool in the Revenue posts on or before field to select the date on or before which contains the schedules you want to act upon.
  4. Select the desired filters in the Filters section

    See the Filters section of this topic for details about each filter field.

  5. Select Preview.

    The Filtered schedules section displays only the transaction items that meet the filter criteria.

  6. If you do not see the desired results, expand the Filters section, adjust the filter criteria, and select Preview.

Always select Preview after adjusting the filter criteria. Sometimes it might look like the list changed when you select different filter criteria, but Intacct will not execute the filter until you select Preview.

2. Select schedules and execute the action

  1. Optionally, sort or filter the Filtered schedules.
    • To sort by a column: select the desired column label. Each time you select the label, the column is sorted in the opposite order.
    • To filter a column: enter all or part of the desired value in the applicable column. The results display all schedules that contain the entered values.
  2. Enter any details related to the selected action in the applicable details fields. For example, if you're posting revenue, indicate whether to post currency gains and losses.
  3. Do one of the following:

    • Select the checkbox to the far left of each revenue recognition schedule that you want to act upon.
    • Select the dropdown next to the checkbox in the column header and choose Select all on this page to select all schedules currently visible.
    • If there are multiple pages of schedules, select the dropdown next to the checkbox in the column header and choose Select all to select all schedules across all pages.
  4. Select the applicable action button. For example, select Post.

    • If the action was successful, a green bar and check mark appear in the header and indicates the number of successful schedules.
    • If the action was not successful, a red bar and x appear in the header and indicates the number of affected schedules.
  5. If there were errors, select Fix these schedules to view source transactions and line item numbers to use to investigate the errors.

Action options

See the following help topics for detailed information on each action.

Post revenue recognition

Place a revenue recognition schedule on hold

Resume a revenue recognition schedule from hold

Terminate a revenue recognition schedule

Deliver a transaction line item

Field descriptions

The following tables describe each field in the following sections on the Manage revenue schedules page.

Options

Options field descriptions
Filter Description

Action options

Filters the list of transaction items to display only items to which the selected action applies. Options are:

  • Post—post revenue from a schedule.
  • Hold—place the revenue schedule on hold
  • Resume—resume the revenue schedules from hold
  • Terminate—cancel the revenue schedule
  • Deliver—indicate the recognition event has occurred.

Revenue posts on or before

Select the calendar icon and then select the date on or before which contains the schedules you want to view.

Filters

Filters field descriptions
Filter Description

Include unscheduled project revenue

Select this filter to include revenue recognition schedules that contain one or more rows without scheduled posting dates.

This filter option is applicable to revenue schedules that use the Percent completed or Milestone recognition methods, which are applicable to projects and nonprofit revenue recognition.

Include automatic posting schedules

Includes transaction items with revenue recognition schedules that use the automatic posting method.

Revenue schedule status

Filters the list of transaction items to display only items that are associated with the selected schedule statuses.

Options are:

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

If a status option is grayed-out, you cannot select that option in combination with the selected Action option.

Customer or customer group

Contract or contract group

Location or location group

Department or department group

Class or class group

Project or project group

Filters the list of transaction items to display only items pertaining to the selected dimension or dimension group. Each dropdown list contains a combination of dimensions and dimension groups.

To quickly select the desired dimension or dimension group, enter the first few characters of the desired dimension or dimension group in a filter field. Intacct limits the display to only those dimensions or dimension groups that match the criteria.

 

Customer type

Filters the list of transaction items to display only items associated with the selected customer type (for example, reseller, partner, and so on).

Transaction type

Filters the list of transaction items to display only items associated with the selected transaction document type (for example, OE sales invoice, Sales Order, and so on).

Document number

Filters the list of transaction items to display only items associated with the specified document number.

Transaction currency

Filters the list of transaction items to display only items associated with the selected transaction currency.

Only applicable if your company uses multi-currency transactions.

Revenue recognition template

Filters the list of transaction items to display only items that are associated with the selected revenue recognition template.

Deferred revenue account

Filters the list of transaction items to display only items associated with the selected deferred revenue account.

Revenue account

Filters the list of transaction items to display only items associated with the selected revenue account.

Maximum number of records to select

Displays records matching the filter criteria up to the selected number of records.

For example, if this field is set to 20 and there are a total of 37 records that match the filter criteria, Intacct will only display the first 20 records that match the filter criteria.

Sort by / Sort order

Displays the results sorted by the selected column and in the selected order (ascending or descending).

Details

When you select a particular Action option and select Preview, additional detail fields display that are applicable to the selected action.

Currency gains and losses

This section appears when you select Post in the Action options field and your company uses multiple currencies.

Currency gains and losses field descriptions
Field Description

Post currency gains and losses

Select to post currency gains and losses based on the date you post the revenue.

Exchange rate type

Select the desired exchange rate type. If you select Post currency gains and losses, you must select an exchange rate type to use for the currency conversion.

Hold details

This section appears when you select Hold in the Action options field.

Hold details field descriptions
Field Description

Category

Optionally, select the reason for the hold. This category will be applied to all selected schedules when you select Hold. The selected category displays next to the applicable transaction line item in the Deferred Revenue Details report.

Memo

Optionally, enter any comments regarding the hold. These comments will be applied to all selected schedules when you select Hold.

Resume details

This section appears when you select Resume in the Action options field.

Field Description

Past scheduled entries use next posting date

Optionally, select this field if you want all past unposted scheduled journal entries that were on hold to be entered using the next posting date in the schedule.

Memo

Optionally, enter any comments regarding the resumption of the schedule. These comments will be applied to all selected schedules when you select Resume.

Terminate details

This section appears when you select Terminate in the Action options field.

Terminate details field descriptions
Field Description

For the remaining unrecognized revenue, terminate:

Select one of the following termination options:

  • All: Sets the status for the remaining Open entries to Terminated. This revenue cannot be recognized.
  • Any scheduled after the next posting date: Intacct leaves one Open row on the schedule and terminates the rest of the schedule.

    For example, suppose that 1,000.00 is scheduled to be posted on the next scheduled posting date of March 31. In this scenario, the system leaves the 1,000.00 scheduled to post on March 31 Open and terminates the remaining schedule.

  • Any after specified date: Terminates the schedule as of the date you choose. If the date you select results in a partial period, a pro-rated amount will be posted based on an Intacct-calculated percentage.

    For example, say that the revenue recognition schedule is set to recognize 1,000.00 at the end of each month. On April 8, you choose to terminate the schedule as of April 15. In this scenario, Intacct calculates the percentage of the period to use for the recognition (15 days divided by 30 days = 50%), recognizes a portion of April's revenue (50% of 1,000.00 = 500.00), and terminates the remaining schedule.

The Any after specified date option is available only for revenue recognition schedules that post at the end of the month. If the revenue recognition template you're using does not have the Posting day set to End of Period, the Any after specified date option will not be available.

Category

Optionally, select the reason for the termination. This category will be applied to all selected schedules when you select Terminate. The selected category displays next to the applicable transaction line item in the Deferred Revenue Details report.

Memo

Optionally, enter any comments regarding the resumption of the schedule. These comments will be applied to all selected schedules when you select Terminate.

Delivery details

This section appears when you select Deliver in the Action options field.

Delivery details field descriptions
Field Description

Specify a delivery date and Update grid (button)

To specify the same delivery date for all items, enter a date in the Specify delivery date field and select Update grid.

This date change only affects the line items displayed in the Filtered schedules grid at this point. The Delivery date field is not updated on the record until you select a line item and execute Deliver.

If you use a delivery date that's in a closed period, the next scheduled posting date for the line item might also be in a closed period. You'll receive an error if you try to post the revenue in a closed period. In this scenario, edit the applicable revenue schedule to move the posting date to an open period.

Filtered schedules columns

To see all columns for a scheduled entry, select in a row and select Show details. Intacct Administrators can customize the Filtered schedules grid layout.

You can sort or filter most of the columns in the Filtered schedules table.

  • To sort by a column: select the desired column label. Each time you select the label, the column is sorted in the opposite order.
  • To filter a column: enter all or part of the desired value in the applicable column. The results display all schedules that contain the entered values.
Filtered schedules columns field descriptions
Field Description

Select

Select the checkbox to the far left of each revenue recognition schedule that you want to act upon or select the checkbox in the Select column header to select all schedules in the view.

Customer

The customer ID-name associated with the transaction item.

Source transaction

The transaction identifier for the transaction from which the revenue recognition schedule originates. Select a link in this column to open the associated source transaction in a popup window.

Line no.

The line item number from the source transaction that has a revenue recognition schedule associated with it.

Schedule status

The status of the associated revenue recognition schedule will be one of the following:

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

Posting method

The posting method defined on the revenue recognition template associated with the transaction item.

  • Automatic—Intacct automatically creates a revenue recognition journal entry on the next scheduled posting date.
  • Manual—a user must manually execute post to create a revenue recognition journal entry from the schedule.

You can manually post automatic schedules before the scheduled posting date if desired. To see these schedules, select the Include automatic posting schedules filter when you preview schedules.

Start date

The start date for the revenue recognition schedule.

End date

The end date for the revenue recognition schedule.

Item

The sales item for which the revenue recognition schedule applies.

Component

If the sales item is a kit, separate revenue recognition schedules will be generated for each component.

Delivery status

Delivered or Undelivered. This column only displays if your company is using event-based recognition.

Delivery date

If the item's Delivery status is Undelivered, this column defaults to the source transaction date.

If the item's Delivery status is Delivered, this column displays the Delivery date entered when the item was marked as Delivered.

This column only displays if your company is using event-based recognition.

Total amount

The total amount of revenue to be recognized for the transaction item expressed in the Base currency. Select a link in this column to view the applicable Revenue Recognition Schedule window.

Amount recognized

The portion of the Total amount that has posted.

Amount deferred

The portion of the Total amount that has not been posted.

Amount terminated

The portion of the Total amount that was not recognized when the revenue recognition schedule was terminated.

Next posting date

The date on which the next available journal entry is scheduled to post.

If this date is in a closed period, you'll receive an error when you execute post. In this scenario, edit the revenue schedule to move the posting date to an open period and then try posting again.

Next posting amount

The amount of the next available journal entry that's scheduled to post expressed in the Base currency.

Template name

The name of the revenue recognition template associated with the transaction item.

Percent recognized

The percentage of the Total amount that has been posted.

Project

The project ID associated with the transaction item.

Base currency

The accounting currency used by your company.

Txn currency

The currency in which the transaction amount is expressed. This field is only applicable to companies using multiple currencies.

Txn next posting amount

The amount of the next available journal entry that's scheduled to post expressed in the Txn currency.

Txn total amount

The total amount of revenue to be recognized for the transaction item expressed in the Txn currency.

Txn amount recognized

The portion of the Txn Total amount that has posted expressed in the Txn currency.

Txn amount deferred

The portion of the Txn Total amount that has not been posted expressed in the Txn currency.

Txn amount terminated

The portion of the Txn Total amount that was not recognized when the revenue recognition schedule was terminated expressed in the Txn currency.