Post revenue or expense recognition manually

The Manage Schedules page lets you manually post revenue or expense recognition for contract lines. Use the filters to display the desired contract schedules, then select the rows you want to post. If your Contracts configuration uses two sets of journals, you’ll execute the posting process for each journal.

The posting process creates journal entries in the selected journal set that do the following:

About Preview and Scheduled posting dates

To post revenue, you first need to execute Preview against an As of date to display revenue that's available to post. The As of date is the date on or before which contains the Scheduled posting dates for the revenue you wish to post.

Scheduled posting date by recognition method
Recognition method Scheduled posting date

Straight line and Daily rate

Intacct generates the revenue schedule based on the flat/fixed amount and the revenue template start and end dates entered on the contract line.

When the contract line is saved, Intacct creates rows in the revenue schedule for each applicable recognition period and assigns each row a Scheduled posting date.

The Scheduled posting date will always be the last day of the period, regardless of the revenue template start date, except when the contract line GL posting date is after the revenue template start date. In this scenario, the revenue schedule must start on or after the GL posting date.

Learn more about how the contract line GL posting date affects revenue schedules.

Predefined percentages

The revenue template maps the period for recognition to occur with the percentage of the flat/fixed amount to recognize that period.

Intacct generates the revenue schedule based on the template start date entered on the contract line.

When the contract line is saved, Intacct creates rows in the revenue schedule for each applicable recognition period as designated in the template and assigns each row a Scheduled posting date.

The Scheduled posting date will always be the last day of the period, regardless of the revenue template start date except when the contract line GL posting date is after the revenue template start date. In this scenario, the revenue schedule must start on or after the GL posting date. Learn more about how the contract line GL posting date affects revenue schedules.

Quantity-based

Quantity-based revenue schedules do not have any scheduled entries until usage is associated with the contract line.

When you add a usage record to a contract line that's using a quantity-based revenue template, Intacct creates a row in the associated revenue schedule for the amount of revenue available to recognize.

Intacct uses the Usage date on the usage record for the Scheduled posting date in the associated revenue schedule.

If two or more usage records for a contract line have the same Usage date and you have not posted revenue associated with any of those records, Intacct combines the associated portions of revenue into one row in the revenue schedule.

Project percent complete and Task percent complete

See Update percent complete revenue schedules for information.

Scheduled posting date vs. Actual posting date

When you manually post revenue and expenses, you can set a specific date for revenue to post to the GL or you can use the scheduled posting date. Whichever option you choose, Intacct records this date on the applicable schedule in the Actual posting date field.

Depending on your posting requirements, you might need to filter the schedules and post multiple times to record the desired posting dates.

Basic steps to post revenue or expense recognition

The following sections outline the steps for posting revenue or expense recognition for contract lines.

  1. Set filters and preview revenue or expenses.
  2. Select revenue or expenses and execute post.

1. Set filters and preview revenue and expenses

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

In a multi-entity company, you can only view or post recognition for contracts created at the same level in which you are accessing the Manage Schedules page. If you are at the top level, you can only view or post recognition for contracts created at the top level. If you are at the entity level, you can only view or post recognition for contracts created at that entity level.

If you want to recognize project revenue based on percentage of completion, run Update percent complete schedules before previewing.

  1. Go to Contracts > All > Manage schedules.
  2. In the Action dropdown, select Post.

  3. In the As of date field, use the calendar tool to select a date on or before which includes the schedules you want to post.
  4. In the Schedule type field, select Revenue to display only revenue schedules, or Expense to display only expense schedules.

  5. Select Journal 1 or Journal 2.

    Depending on your Contracts configuration, you might use one or two sets of journals. If you’re using two sets, you can only post to one set of journals at a time.

  6. Select your desired filters to narrow the focus of the schedules you want to post.

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

  7. Select Preview.

    The Revenue schedules or Expense schedules section displays only the available recognition that meets the filter criteria, and only the scheduled revenue or expenses that have not yet been posted and are not on hold.

  8. 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 looks like the list changed when you select different filter criteria, but Intacct will not execute the filter until you select Preview.
  9. In Posting options, choose whether the revenue or expense posts on the Scheduled posting date from the applicable revenue or expense schedule or on a date you specify in the Posting date field.

    See About Scheduled posting dates for more information.

  10. Optionally, sort or filter to refine the list of schedules 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.

  11. To view a particular revenue or expense schedule, select the <value> in the Amount column that corresponds to the desired schedule row.

    The schedule opens in a popup window.

    Learn more about Revenue schedules and Expense schedules.

2. Select revenue and expenses and post recognition

When you post revenue or expense recognition, Intacct creates a bulk action run record and runs the process offline. Intacct processes requests in the order in which they were received, so the time it takes to process the run will vary. You can view the bulk action run to check the processing status of the request.

When Intacct completes the posting process, it sends an email notification to the user who initiated the posting action. The email displays the number of schedule entries processed, the number of schedule entries that posted successfully, and the number of errors that occurred, if any. The bulk action run record also displays this information, so it's okay to delete the email.

Note the following expected behavior regarding revenue and expense posting:

  • There's no limit for how many revenue or expense entries you can post.
  • If an error occurs during the posting process, Intacct skips the contracts with the errors and continues the posting process for other selected contract schedules. It then provides the error details in the email notification and in the bulk action run record.

If you’re using two sets of journals, you will typically execute the post function at least twice: once for each journal set. For example, if you are posting revenue and expense separately, execute preview and post four times.

  1. 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 checkbox in the column header to select all schedules on the page.
  2. Use the navigation at the top right of the section to go to the next page and select more schedules, if applicable.
  3. Select Post.
  4. If you’re using two sets of journals, select the other Journal and select Preview.

    For example, if you previously posted revenue to Journal 1, select Journal 2.

  5. Select the same scheduled rows as in step 1 and select Post.

See Troubleshooting revenue and expense posting for solutions to common posting errors.

Clear a posted revenue or expense journal entry

See Clear contract revenue or expense recognition.

Update percent complete schedules

Revenue schedules based on percent complete recognition remain blank until you execute the Update percent complete schedules process as of the applicable date. See Update percent complete revenue schedules for more information.

Field descriptions

The following tables describe each field on the Manage Schedules page for the Post action.

Options section

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 section

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

Posting options section

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.

Revenue schedules or Expense schedules sections

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.