Manage schedules in bulk—Contracts

Simplify your contract management process by using bulk actions on multiple contracts from a centralized view.

Use the Manage Schedules page to:

  • Post revenue or expense recognition for contract lines
  • Clear revenue or expense recognition for contract lines
  • Hold billing, revenue, or expense schedules for contract lines
  • Resume billing, revenue, or expense schedules for contract lines
  • Deliver contract lines (if your company is using event-based recognition)
  • Update percent complete revenue schedules

Basic steps to manage schedules

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

1. Set filter options and preview results

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 schedules for a specific customer or a specific project.

In a multi-entity company, you can only act upon schedules that are created at the same level in which you are accessing the Manage 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 ContractsAllManage schedules.
  2. Select your desired Action.
  3. In the As of date field, use the calendar tool to select a date on or before which includes the schedules or contract lines you want to act on.
  4. Set other options relevant to the selected action, if any.
  5. Select your desired filters to narrow the focus of the results you want to act on.

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

  6. Select Preview.

    The table below displays only the results that meet the filter criteria.

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

    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.
  8. Enter any details related to the selected action.

    For example, if you're posting revenue, indicate which posting date to use.

  9. Optionally, sort or filter to refine the results list further.

    • 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 textbox at the top of a column. The results display all schedules that contain the entered values.

2. Select results and execute the action

  1. Do one of the following:
    • Select the checkbox to the far left of each row.

    • Select the dropdown next to the checkbox in the column header and choose Select all on this page to select all rows currently visible.

    • If there are multiple pages of results, select the dropdown next to the checkbox in the column header and choose Select all to select all rows across all pages.

  2. Use the navigation at the top right of the section to go to the next page and select more results, if applicable.
  3. Select the applicable action button.

    For example, select Post.

Actions

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

Field descriptions

The following tables describe each field in the following sections on the Manage Schedules page:

Options

Options section field descriptions
Field Description

Action

Select the type of action that you want to perform. The results list will display only items to which the selected action applies. The options are:

  • Post: Post revenue or expense recognition for contract lines.

  • Clear: Clear revenue or expense recognition for contract lines.

  • Hold: Hold billing, revenue, or expense schedules for contract lines.

  • Resume: Resume billing, revenue, or expense schedules for contract lines.

  • Deliver: Deliver contract lines.

As of date

Select the calendar icon and then select the date on or before which contains the schedules or contract lines you want to view or the percent complete schedules you want to update.

In most scenarios for contract lines associated with projects, Intacct will use the As of date for the Scheduled posting date for project revenue. See Scheduled posting dates for more information.

Schedule type: Revenue and Expense

This field is only applicable to the Post and Clear actions.

Filters the list by revenue schedules or expense schedules. Revenue is selected by default.

Journal: Journal 1 and Journal 2

This field is only applicable to the Post and Clear actions.

Indicates to which journal the revenue or expenses will be posted cleared. Depending on your Contracts configuration, you might use one or two sets of journals. If you are using two sets, you can only post to one set of journals at a time.

Your field labels for Journal 1 and Journal 2 will display the journal symbols selected in the Configure Contracts page for Revenue journal 1 and Revenue journal 2.

Filters

Filters section field descriptions
Field Description

Customer or customer group

Contract or contract group

Location or location group

Department or department group

Class or class group

Item or item group

Project or project group

Task or task group

Employee or employee group

Filters the list of results to display only lines pertaining to the selected dimension or dimension groups. 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 results to display only items associated with the selected customer type (for example, reseller, partner, and so on).
Contract type Filters the list of results to display only items associated with the selected contract type.
Transaction currency

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

Only applicable if your company uses multi-currency transactions.

Template Filters the list of results to display only items that are associated with the selected revenue or expense template.
Project type Filters the list of results to display only items associated with the selected project type.
Project manager Filters the list of results to display only items associated with the selected project manager.
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).

User-defined dimensions

If any user-defined dimensions are available, filters for them will appear in a dedicated User-defined dimensions section.

Additional options

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

Posting options

This section appears when you select Post in the Action field and then select Preview.

Posting options section field descriptions
Field Description
Posting options

Choose one of the following options:

  • Use scheduled posting date: Intacct will post revenue or expenses for all selected rows on the Scheduled posting date from each contract line's revenue or expense schedule. Learn more About Scheduled posting dates.
  • Specify posting date: Intacct will post revenue or expenses for all selected rows on the date you enter in the Posting date field.
Posting date

You only need to specify a date in this field if you select Specify posting date in the Posting options. This will be the actual date the selected revenue or expense lines will post.

For example, say that a revenue schedule row is scheduled to post on 11/30/2022. You select Specify posting date, enter 11/27/2022 in the Posting date field, and select Post. The revenue schedule for the selected row will show 11/30/2022 as the Scheduled posting date and 11/27/2022 as the Actual posting date.

Hold options

This section appears when you select Hold in the Action field and then select Preview.

Field Description
Schedules to hold

Select one or more of the following contract schedule types to place on hold:

  • Billing schedules
  • Revenue schedules
  • Expense schedules

Hold date

The date on which the hold takes effect for the selected contract schedules.

Hold memo

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

Resume options

This section appears when you select Resume in the Action field and then select Preview.

Field Description

Schedules to resume

Select one or more of the following contract schedules to resume:

  • Billing schedules
  • Revenue schedules
  • Expense schedules
Resume date The date on which the resume takes effect for the selected contract schedules.

Memo

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

Revenue adjustment type

Specifies what Intacct should do with revenue that was scheduled to post while the schedule was on hold. This field is only applicable for revenue templates where the Recognition method = Straight line or Daily rate.

Options are:

  • Use template default: Uses the Revenue adjustment option selected on the associated revenue template.

  • Catch-up: One time: Sets the Scheduled posting date for all revenue that was scheduled prior to the Resume date to the Resume date.
  • Catch-up: Distributed: Recalculates the revenue schedule term using the Resume date as the start date and spreads the total revenue amount across the shortened schedule so that any periods skipped during the hold are eventually caught up.
  • Walk forward: Regenerates the revenue schedule as of the Resume date and pushes the end date out to the date that is equal to the number of days from the original revenue template Start date to the Resume date. Intacct prorates any partial periods. The whole period amount remains equal to the originally scheduled whole period amount.

Deliver options

This section appears when you select Deliver in the Action field and then select Preview.

Field Description

Delivery date

Select the applicable Delivery date, which is when the contract line's Delivery status will be set to "Delivered"

The Delivery date field is not updated on the record until you select an entry and execute Deliver.

Results sections

The results sections appear after you select Preview.

To see all columns for a row, select in a row and select Show details.

You can sort or filter most of the columns in the results 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.

Revenue schedules or Expense schedules sections

These sections appear when you select Post or Clear in the Action field and then select Preview.

Revenue schedules or Expense schedules sections field descriptions
Field Description
<checkbox> Select the checkbox in each row for which you want to post recognition.
Customer The customer associated with the contract schedule. Select the link in this field to display the customer in a popup window.
Contract The contract ID and name associated with the contract schedule. Select the link in this field to display the contract in a popup window.
Contract line no.

The contract line number associated with the contract schedule.

Select the link in this field to display the contract line in a popup window.

If the contract line no. for an expense schedule is blank, that indicates that the expense line is at the contract level rather than the contract line level.
Expense line no.

The expense line number associated with the expense schedule.

Select the link in this field to display the expense line in a popup window.

Item The contract line item associated with the contract schedule. Select the link in this field to display the item in a popup window. This column only shows for revenue schedules.
Expense item The expense line item associated with the contract schedule. Select the link in this field to display the item in a popup window. This column only shows for expense schedules.
Project The project ID and name associated with the contract schedule. Select the link in this field to display the project in a popup window.
Scheduled posting date The scheduled posting date for the revenue or expense from the associated revenue or expense schedule. Learn more About Scheduled posting dates.
Actual posting date The date the revenue or expense amount was posted to the General Ledger.
Amount The amount of revenue or expense scheduled to be recognized expressed in the transaction currency. Select the link in this column to display the revenue or expense schedule for the selected journal in a popup window.
Total amount

For revenue schedules: The total flat/fixed amount for the contract line expressed in the transaction currency. Select the link in this column to display the contract line in a popup window.

For expense schedules: The total expense schedule amount expressed in the transaction currency. Select the link in this column to display the expense line in a popup window.

Template The name of the revenue or expense template associated with the contract schedule. Select the link in this column to display the template in a popup window.
Schedule start date The start date of the revenue or expense schedule.
Schedule end date The end date of the revenue or expense schedule.
Task The task associated with the contract schedule.
Customer type The customer type associated with the contract schedule.
Contract type The contract type associated with the contract schedule.
Project type The project type associated with the contract schedule.
Base currency The accounting currency used by your company.
Transaction currency The currency in which the transaction amount is expressed. This field is only applicable to companies using multiple currencies.
Percent to recognize The percentage of the Total amount that has been posted.
Delivery status

Options are:

  • Delivered: the contract line's recognition event has occurred
  • Undelivered: the contract line's recognition event has not occurred

This field only applies if your company is using event-based recognition.

Delivery date

The Effective date selected when the contract line's Delivery status was set to "Delivered". If the item's default status = "Delivered", this date is equal to the contract line start date.

This field only applies if your company is using event-based recognition.

Schedule status

The status of the associated schedule.

For revenue schedules

Displays one of the following:

  • Completed: all revenue for this schedule has been recognized.
  • Draft: the contract line's state is Draft. Revenue cannot be recognized until the contract line is posted.
  • Estimate revalued: only applicable to Project time contract lines. The Revalue estimation function was used to either close out or revise the remaining Unbilled balances for the project.
  • In progress: revenue for this schedule is available to be recognized.
  • On hold: only applicable to termed contracts. Revenue for this schedule cannot be recognized until the revenue schedule is resumed.
  • Pending delivery: only applicable to termed contracts. The contract line's Delivery status is "Undelivered".
  • Pending delivery of all items: only applicable to termed contracts. The contract line's Revenue recognition deferral status = "Defer revenue until all items are delivered". This indicates that this revenue schedule will not start until all contract lines in the contract have Delivery status = "Delivered".
  • Terminated: the contract line was canceled.

There is additional status of Renewal forecast that is only applicable to report data and never displays in the user interface.

For expense schedules

Displays one of the following:

  • Completed: all expense amounts for this schedule have been recognized.
  • Draft: expense amounts for this schedule can't be recognized until the expense is posted. Learn how to post a draft expense.
  • In progress: expense amounts for this schedule are available to be recognized.
  • On hold: expense amounts for this schedule can't be recognized until the expense schedule is resumed. Learn how to resume an expense schedule.
  • Terminated: the associated expense was canceled. Learn more about canceled expenses.
Computation memo

Shows the daily rate for revenue schedules that use the Daily Rate recognition method.

For percent complete recognition when the GL posting date occurs later than a source record used to calculate percent complete recognition, it may show "The scheduled posting date is the GL posting date. The source used to calculate the percentage of completion was created prior to the GL posting date on <date>.

Dates displayed in this field use YYYY/MM/DD format.

Contract lines section

This section appears when you select Hold, Resume, or Deliver in the Action field and then select Preview.

Field Description
<checkbox> Select the checkbox in each row for which you want to hold or resume.
Customer The customer associated with the contract line. Select the link in this field to display the customer in a popup window.
Contract The contract ID and name associated with the contract line. Select the link in this field to display the contract in a popup window.
Contract line no.

The contract line number. Select the link in this field to display the associated contract in a popup window.

Item The item associated with the contract line. Select the link in this field to display the item in a popup window.
Project The project ID and name associated with the contract line. Select the link in this field to display the project in a popup window.
Total amount

The total flat/fixed amount for the contract line expressed in the transaction currency. Select the link in this column to display the contract line in a popup window.

Line start date The start date of the contract line.
Line end date The end date of the contract line.
Task The task associated with the contract line.
Customer type The customer type associated with the contract line.
Contract type The contract type associated with the contract line.
Project type The project type associated with the contract line.
Base currency The accounting currency used by your company.
Transaction currency The currency in which the transaction amount is expressed. This field is only applicable to companies using multiple currencies.
Delivery status

Options are:

  • Delivered: the contract line's recognition event has occurred
  • Undelivered: the contract line's recognition event has not occurred

This field only applies if your company is using event-based recognition.

Delivery date

The Effective date selected when the contract line's Delivery status was set to "Delivered". If the item's default status = "Delivered", this date is equal to the contract line start date.

This field only applies if your company is using event-based recognition.