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:
- Revenue: debit the applicable Deferred Revenue account and credit the applicable Sales Revenue account. Learn more about the revenue recognition accounting flow.
- Expense: debit the Recognized Expense account and credit the Deferred Expense account. Learn more about the expense recognition accounting flow.
| Subscription |
Contracts |
|---|---|
| Regional availability |
|
| User type |
Business |
| Permissions |
|
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.
| 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. |
| 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.
- Set filters and preview revenue or expenses.
- 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.
- Go to Contracts > All > Manage schedules.
-
In the Action dropdown, select Post.
- 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.
-
In the Schedule type field, select Revenue to display only revenue schedules, or Expense to display only expense schedules.
- 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.
-
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.
- 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.
- 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.
-
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.
-
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.
-
- 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.
- 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.
- Use the navigation at the top right of the section to go to the next page and select more schedules, if applicable.
- Select Post.
-
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.
- 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
| 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:
|
| 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
| 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
| Field | Description |
|---|---|
| Posting options |
Choose one of the following options:
|
| 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
| 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:
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:
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:
|
| 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. |