Managing Revenue Recognition

This chapter provides an overview of revenue management and discusses how to:

Review revenue.
Reverse revenue.
Redistribute revenue.
Reconcile billing and revenue.

Understanding Revenue Management

Contracts enables you to capture revenue information for a contract and allocate that information to specific contract lines within the Contracts system. You can associate revenue information with a revenue recognition method, manage when the conditions for recognizing revenue have been met, and generate journal entries to book revenue in your General Ledger system.

You can actively manage accounting activity that is generated by Contracts. You define accounting information (amounts and accounting distributions) within Contracts at the individual contract line level. You then assign these contract lines to revenue plans. A revenue plan has one of four possible revenue recognition methods: apportionment, milestone, percent complete, and as-incurred. How you manage a revenue plan depends upon its revenue recognition method.

Managing revenue consists of managing the revenue plan and revenue plan events, and managing the contract line. Managing the revenue plan and revenue plan events is part of your normal contract management cycle and is not governed by amendment processing. Changes to your contract line are generally governed by amendment processing, with the exception of changes to the accounting distributions for a contract line.

When we talk about managing revenue in Contracts, we are referring to what happens after you set up your contract, establish your contract lines, allocate your contract pricing, and activate your contract. Managing revenue is the process of setting up and readying your revenue plans and revenue plan events, and then managing these revenue plans and events as they become ready to book and are picked up by the Contracts revenue Application Engine processes.

This section discusses:

Managing accounting for revenue plans.
Managing the revenue process in Contracts.
Placing a revenue plan on hold.
Managing revenue plan event statuses.
Changing accounting distributions for amount-based contract lines.
Changing accounting distributions for rate-based contract lines.
Adjusting amounts and cancelling contract lines.
Changing revenue plan information.

Note. For contracts with a classification of Government, you can find additional revenue information in the Contracts for Government Contracting PeopleBook.

Understanding Accounting Distributions

Entering Accounting Distributions

Setting Up Revenue Plans

Setting Up Accounting for Projects

Prerequisites

Before you can begin to manage revenue, you need:

A contract with an Active processing status.
A contract line with an Active status that is assigned to a revenue plan with a Ready status.

Managing Accounting for Revenue Plans

There are several revenue inquiry/management pages that enable you to query on and manage accounting for revenue plans, revenue plan events, and projects that are assigned to revenue plans.

From the Review Revenue - Plans page you can query across all your contracts and review information, such as revenue plan status, the total revenue amount for a revenue plan, and the pending revenue amount for a revenue plan. From this page, you can:

Navigate to the Revenue Plan page to edit revenue plan events, place or remove a hold on a revenue plan, or cancel a revenue plan.
Navigate to the Fixed Fee Revenue History page to review the accounting transactions that have been processed for a fixed-fee revenue plan.
Reverse a plan.
Set the revenue plan status to Pending or Ready.

A more detailed level of management pages also exist that enable you to query across the revenue plan events and the projects or activities that are assigned to revenue plans. From these pages, you can review the status of individual events and the revenue that has been booked for these events. From these pages, you can:

Navigate to the Revenue Plan page to edit revenue plan events.
Reverse a revenue plan event on the Review Revenue - Events page.
Set revenue plan events to Pending or Ready status from the Review Revenue - Events page.
Initiate a redistribution of the revenue that has been booked for that revenue plan to date.

Additional revenue management pages enable you to reverse amount-based revenue for an entire contract (Contract Reversal page), to redistribute revenue that has been booked for an event (Redistribute Fixed Fee page) or for a project/activity (Redistribute As Incurred page), and to reconcile billing to revenue for rate-based contract lines (value-based and as-incurred billing plans).

Managing the Revenue Process in Contracts

You can view revenue that has been recognized to date and pending revenue recognition for any cross-section of your Contracts system. When managing revenue, you may need to perform the actions listed in the following table. The pages on which you perform each action are also listed:

Revenue Management Action	Revenue Recognition Method	Page
Putting the entire revenue plan on hold to freeze revenue recognition for all events within that revenue plan.	All	Revenue Plan
Changing a revenue plan event status to Ready to enable revenue recognition for that event.	All	Review Revenue - Events
Changing the accounting distribution of an amount-based contract line for future revenue entries.	Apportionment Milestone Percent Complete	Accounting Distribution
Changing the accounting distribution of a rate-based contract line for future revenue entries.	As-Incurred	Accounting Rules
Reversing revenue already recognized for a revenue plan.	Apportionment Milestone Percent Complete	Review Revenue - Plans
Reversing revenue already recognized for a revenue plan event.	Apportionment Milestone Note. For Percent Complete, enter a smaller total percent complete to calculate a negative incremental percent event.	Review Revenue - Events
Reversing amount-based revenue already recognized for an entire contract.	Apportionment Milestone Percent Complete	Contract Reversal
Changing the accounting distribution for amount-based revenue already recognized (redistributing revenue).	Apportionment Milestone Percent Complete	Redistribute Fixed Fee
Changing the accounting distribution for rate-based revenue already recognized (redistributing revenue).	As-Incurred	Redistribute As Incurred
Defining or changing event conditions, schedule, or amounts to be recognized for a specific event.	All	Revenue Plan
Reassigning contract lines from one revenue plan onto another revenue plan.	Apportionment Milestone Percent Complete	Reverse revenue recognized from the Review Revenue - Plans page (the revenue plan must be cancelled). Unassign the contract line from its current revenue plan on the Assign Rev Rec Plan - Accounting Plan page. Assign the contract line to a new revenue plan on the Assign Rev Rec Plan - Accounting Plan page.
Cancelling a revenue plan.	All	Revenue Plan

Placing a Revenue Plan on Hold

The revenue management pages enable you to perform a search for all revenue plans that have been placed on hold. For all revenue recognition methods, access the Revenue Plan page to either place a revenue plan on or remove a revenue plan from a hold.

Managing Revenue Plan Event Statuses

To expedite processing, you may set all revenue plan events to Ready upon creation of the events. You can then control the revenue recognition with the process’s run control parameters or use the Hold feature on the plan itself.

Manage the revenue plan event status for all revenue recognition events from the Review Revenue - Events page. Set the status of individual events to Ready to enable revenue recognition processing for these events.

Changing Accounting Distributions for Amount-based Contract Lines

Contracts enables you to modify a contract line’s accounting distribution for future revenue recognition that you book against the contract line. You do this on the Accounting Distribution page, which stores accounting distributions for fixed-amount contract lines. The Accounting Distribution page is effective dated; when you run the Amount-based Revenue process for any contract lines included in the process, the process uses the current accounting distributions prior to the event accounting date being processed to create revenue entries. Thus, if there are two effective-dated accounting distributions (01-01-01 and 03-01-01), and the revenue plan event has an accounting date of 02-15-01, the system uses the accounting distribution effective 01-01-01. The Accounting Distribution page also stores deferred revenue and unbilled accounts receivable (AR) accounting information for the fixed-amount contract lines. To ensure that the accounting remains consistent for the entire revenue recognition and billing cycle, do not change the deferred revenue and unbilled AR accounting information once you have set the contract processing status to Active.

Changing Accounting Distributions for Rate-based Contract Lines

For rate-based contract lines (except those attached to billing plans with value-based billing methods), change the accounting distributions on the Accounting Rules page. The Accounting Rules page is not effective-dated. Therefore, any changes that you make impact the revenue and billing accounting entries for transactions without regard to the transaction date. To ensure that the accounting remains consistent for the entire revenue recognition and billing cycle, do not change the unbilled AR accounting information once you have begun processing transactions.

Note. Additional rules can be set up for a specific contract, project and activity, and project ChartField combination if you want to change accounting for a particular set of transactions.

Note. For rate-based contract lines tied to billing plans with value-based billing methods, set up your unbilled AR on the Accounting Distribution page.

Adjusting Amounts and Cancelling Contract Lines

You can increase or decrease contract line amounts, as well as cancel contract lines as part of the amendment process. When increasing or decreasing contract line amounts, you must choose whether to adjust revenue and billing retroactively or to adjust revenue and billing for future events only. The adjust revenue and billing choices are independent of each other and are can be selected on the Amendment Amount Allocation page. When cancelling the contract line, you can select the Reverse Amounts option from the Amendment Amount Allocation page. This option applies to both billing and revenue. If you select the Reverse Amounts option, then you are indicating that you want to adjust revenue and billing retroactively for the cancelled contract lines. If you do not select the Reverse Amounts option, then for cancelled contract lines, the system adjusts revenue and billing for future events only.

See Also

Working with Amendments

Changing Revenue Plan Information

The system stores all accounting information (events, schedules, and percentages to be recognized per event) on the revenue plan. You can change the revenue plan only on the Revenue Plan page. The changes that you can make depend on the status of the revenue plan:

Revenue Plan Status	Changes
Pending	The first stage for the revenue plan. You can make any changes.
Ready	The system has validated all components of the plan, and most fields are unavailable for entry. However, you can reset the status to Pending and make changes.
In progress	One or more events has processed (a portion of revenue has been recognized). All fields are unavailable for entry. You cannot change any events that are In Progress or Completed. You can modify Pending, and Ready events and you can add events.
Completed	All events, if they exist, have been completed (all revenue has been recognized). You cannot make any changes. You can only reverse the plan's revenue, which sets the status to Reversed.
Cancelled	Cancellation may occur due to the entire contract being terminated or superseded, a contract line being dropped, or to consolidate contract lines onto another revenue plan. Once cancelled, a revenue plan cannot be reopened.
Action Required	A contract line amendment has been processed or an event reversed. The system set the revenue plan status to Action Required. You can edit all Pending and Ready events and add new events. Once you have reviewed the revenue plan and made any necessary changes, the system continues with revenue processing and changes the revenue plan status back to In Progress.
Reversal In Progress	When you initiate the reversal of a revenue plan, the system changes the status of the revenue plan to Reversal In Progress.
Reversed	This status indicates that you have reversed the revenue plan and that all processing has occurred.

Reviewing Revenue

This section provides an overview of reviewing revenue, lists common elements, and discusses how to:

Review revenue plans.
Review revenue plan events.
Review as-incurred revenue plans.
Review revenue details for accounting activities booked to the GL.
Inquire about amount-based accounting journal entries.
Inquire about rate-based accounting journal entries.

See Also

Setting Up Revenue Plans

Understanding Revenue Review

Use the Review Revenue - Plans, Review Revenue - Events, and Fixed Fee Revenue History pages to review revenue for fixed-fee contracts. Use the Review Revenue - As Incurred page to review revenue for rate-based contracts.

Revenue History

The Fixed Fee Revenue History page enables you to view the accounting distributions of the amounts that have been booked for all fixed-fee revenue plans for which Contracts is managing revenue. The Amount-based Revenue process loads this page with accounting information for the fixed-amount contract lines associated with apportionment, milestone, and percent complete revenue plans.

The data source for the Fixed Fee Revenue History page is the CA_AP_DST, CA_AP_DFR, and CA_AP_UAR tables.

The accounting distributions for fixed-amount revenue plans is real-time information, because all revenue information for these contract lines is stored within Contracts.

Warning! You should not make any revenue adjustments to the contract lines for fixed-amount revenue plans outside the Contracts system (for example, in Billing, Receivables, or General Ledger), as these changes will not flow back into Contracts.

Processes for Review Revenue - As Incurred Page

For as-incurred revenue plans, revenue amounts come from Project Costing and may be adjusted in Billing or Receivables. Therefore, the information on the Review Revenue - As Incurred page is not in real time. Any changes made in Billing are first written back to the revenue rows in Project Costing. These rows are then picked up by Contracts in the next run of the rate-based revenue process. Adjustments made in Receivables are sent to Project Costing, but Receivables handles all the accounting. This example walks you through the scenario:

In Contracts, you enter a contract with a rate-based contract line, and define a rate plan or rate set and project ID for that contract line.
In Project Costing, rows for that project ID come into the PROJ_RESOURCE table from source systems and get priced.

As work is performed, the system creates BIL rows in the PROJ_RESOURCE table. BIL is a Project Costing analysis type.
When the Contracts to Billing interface is run, Contracts sends rows to Billing, and the system creates bill lines on the Billing Worksheet.
When you run the rate-based revenue process (PSA_ACCTGGL), the system selects the BIL rows with a GL_DISTRIB_STATUS of C (contracts) from the PROJ_RESOURCE table, and creates accounting entries by using the accounting rules to recognize revenue for those rows.

This process places these accounting rows in the CA_ACCT_LN_PC table (to be picked up when you run Journal Generator) and in the CA_AP_PC_DST and CA_AP_PC_UAR tables (to be accessed or displayed by the revenue management pages in Contracts).
In Billing, the billing administrator adjusts bill lines in the Billing Worksheet, and then marks the worksheet for acceptance.

Once the system accepts the bill, all adjustment rows are written to the PROJ_RES_TMP_BI table. The billing administrator may further adjust the bill before finalization. Upon bill finalization, the additional adjustment rows are written to PROJ_RES_TMP_BI.
The Billing to Project Costing interface process picks up adjustment rows that were written to the PROJ_RES_TMP_BI table, and places them in the PROJ_RESOURCE table.

Note. The accounting for the adjustment rows in PROJ_RESOURCE come from the Accounting Rules page setup for the adjustment row’s analysis type (for example, BAJ). It is recommended that you use the same accounting in the adjustment accounting rules as you defined for the BIL and BLD analysis types.
When you run the rate-based revenue process (PSA_ACCTGGL), the system picks up adjustment rows from PROJ_RESOURCE with a GL_DISTRIB_STATUS of C, and books the revenue adjustment that was initiated from billing.

Note. If an adjustment is made on that same bill in Receivables, Receivables writes adjustment rows to a temp table that the Receivables to Projects Application Engine process (PC_AR_TO_PC) picks up and places in the PROJ_RESOURCE table. The accounting is handled in Receivables.

Analysis Types in Project Costing

The Receivable Adjustment analysis type is specified on the Installation Options - Project Costing page. After you have selected an analysis type for receivable adjustments, you must then include that analysis type in the Revenue Analysis Group for it to be picked up by the rate-based revenue process.

See Defining Analysis Types.

Common Elements Used in This Section

Hold	Select to search for all revenue plans that have been placed on hold.
Revenue or Revenue Plan	Each contract can contain multiple revenue plans. You must select a contract number before you can search by revenue plan.
Plan Status	Each revenue plan has a revenue plan status. The status controls the processing that can occur against a revenue plan.
Search	Click this button to carry out a search based on the search criteria that you entered. Results appear in the Details or Event Details scroll area.
Business Unit or BU (business unit)	Contracts business unit.
Contract or Contract No (contract number)	Contract number.
Contract Classification	You can search for revenue plans attached to contracts with a specific contract classification. You select a value for the contract classification when creating a new contract. The contract classification selection determines the way that fields and pages are displayed in the Contracts application. Additional functionality is accessible depending on the classification type. Values for the Contract Classification field include: Standard,Internal,Government, and Federal Reimbursable Agreement.
Customer ID or Cust ID (customer ID)	Sold to customer ID.
GL Business Unit	General Ledger business unit.
PC Business Unit	Project Costing business unit.
Processed On	Last date upon which the system recognized revenue for this revenue plan or event.

Pages Used to Review Revenue

Page Name	Object Name	Navigation	Usage
Review Revenue - Plans	CA_AP_MANAGE1	Customer Contracts, Review Revenue, Plans	View revenue plan activity, both pending and recognized amounts, for any cross-section of the Contracts system. Update revenue plan status to Pending, Ready, or Reversal in Progress.
Review Revenue - Events	CA_AP_MGMT_EVENTS	Customer Contracts, Review Revenue, Events	View amounts by event, that have been recognized to date and are pending. You can update the status for an event, reverse the revenue that was booked for an event, and navigate to the Revenue Plan page.
Review Revenue - As Incurred	CA_AP_DTL_ASIN	Customer Contracts, Review Revenue, As Incurred Click the Method link for a specific revenue plan on the Review Revenue - Plans page.	Inquire about the details for revenue plans with an as-incurred revenue recognition method. From this page, you can review the details of the revenue that has been booked, and redistribute that revenue.
Fixed Fee Revenue History	CA_AP_EVENT_DTL	Customer Contracts, Review Revenue, History	Review the revenue details divided into deferred revenue, revenue, and unbilled AR for Contracts fixed-fee accounting activities that have been booked to the GL.
Ca Acct Line Jrnl	CA_ACCT_LINE_JRNL	Customer Contracts, Review Revenue, Fixed Fee Jrnl Acctg Lines	Inquire about the details of each journal entry after you've run the Contracts Fixed Amounts Revenue process and your accounting entries have gone through the Journal Generator process and have posted to the GL.
Acct Rate Jrnl	CA_ACCT_RATE_JRNL	Customer Contracts, Review Revenue, As Incurred Jrnl Acctg Lines	Inquire about the accounting entries after you've run the rate-based revenue process (Accounting Rules Engine) and your accounting entries have gone through the Journal Generator Update process and have been posted to the GL.

Reviewing Revenue Plans

Access the Review Revenue - Plans page.

Search Criteria

Use the fields in the Search Criteria group box to filter your search results by entering specific values in these fields. If you leave all fields blank, the search returns all revenue plans for all Pending and Ready contracts within your system. Results appear in the Revenue Detail scroll area. The system summarizes the results by revenue plan ID, and displays amounts in the contract or transaction currency. In the case of any as-incurred revenue plans, a row appears for every transaction currency found within a revenue plan.

Note. You must enter a value in the Business Unit field.

Method

Selecting the check box of a revenue recognition method limits your search to include only those revenue plans with a recognition method equal to the recognition methods that you selected. If you leave all check boxes cleared, the system returns all revenue plans matching the rest of your search criteria. Values include: Milestone, Percent Complete, Apportionment, and As Incurred.

Fee Type

To view revenue plans, you must select a value of None in the Fee Type group box. For contracts with a classification of Government, you can select other values in this field.

Plans: General Tab

(select)	Select this check box if you want to update the status for this revenue plan to Pending, Ready, or Reversal in Progress. Depending on your selection in the Update Plans group box, when you click the Update Plan Status button, the system updates the status of the revenue plan.
Plan	Click this link to review and update revenue plan events or place the entire revenue plan on hold.
Status	Displays the status of the revenue plan. The status controls the processing that can occur against a revenue plan.
Revenue Method	For revenue plans with a revenue recognition method of Apportionment, Milestone, and % Complete, click to access the Review Revenue - Events page, where you can view and update the status of events or projects associated with the revenue plan. For revenue plans with a revenue recognition method of As Incurred, click to access the Review Revenue - As Incurred page, where you can review booked revenue and redistribute revenue.
Total Amt (total amount)	Displays the total amount for the revenue plan associated with this row. For as-incurred revenue plans, if the contract lines assigned to the plan have estimated amounts, the sum of those amounts appears here as the total amount.
Amt Recog (amount recognized)	Amount of revenue that has been recognized to date for this revenue plan. Click the link to view the accounting entries made for this amount. This link does not appear for revenue plans with a revenue recognition method of As Incurred.
Pending Amount	Displays the pending revenue amount, which is the total amount minus the amount recognized.
Processed On	Displays the last time the revenue was processed for the plan.

Update Plans

The status for each row in the Search Results half of the page can be changed from Ready to Pending or from Pending to Ready. You can update the status of multiple revenue plans at the same time by selecting the new status (either Pending or Ready), selecting the check box next to the appropriate revenue plans, clicking the Update Plan Status button, and saving. You also use this group box to reverse revenue plans.

Pending	Select to update the status of the selected Ready event to Pending.
Ready	Select to update the status of the selected Pending event to Ready.
Reversal in Progress	Select to reverse a revenue plan. You can reverse plans in a status of In Progress or Completed only.
Accounting Date	Enter a date for the system to use as the accounting date for the reversing entries.
Update Plan Status	Click to update the revenue plan status of the selected contract lines in the Revenue Detail: General tab with the Pending, Ready, or Reversal in Progress status that you selected. If you selected the Reversal in Progress option, clicking this button initiates the reversal for the revenue plan.

Plans: Additional Info Tab

Select the Additional Info tab.

Redistrib (redistribute revenue)

Click this link to redistribute revenue for this revenue plan to a different set of General Ledger ChartFields.

Reviewing Revenue Plan Events

Access the Review Revenue - Events page.

Search Criteria

Use the fields in the Search Criteria group box to filter search results by entering specific values in these fields. If you leave all fields blank, the search returns all revenue plan events for all Ready and Pending contracts within your system. Search results appear in the Revenue Detail scroll area. Amounts appear in the contract or transaction currency. In the case of any as-incurred revenue plan events, a row appears for every transaction currency found within a revenue plan event.

Note. You must enter a value in the Business Unit field.

Method

Fee Type

To view revenue plan events, you must select a value of None in the Fee Type group box. For contracts with a classification of Government, you can select other values in this field.

Events

(select)	Select this check box if you want to update the status for this revenue event to Pending, Ready, or Reversal Initiated. Depending on your selection in the Update Events group box, when you click the Update Event Status button, the system updates the status of the revenue event.
Revenue Plan	Displays the revenue plan associated with the revenue event.
Plan Status	Displays the status of the revenue plan. The status controls the processing that can occur against a revenue plan.
Method	Displays the revenue recognition method associated with the revenue event.
Event	Displays the event number for this revenue recognition event. Each revenue plan contains one or more revenue plan events. Revenue plan events depict how much revenue to recognize based on the revenue plan event status.
Event Status	Displays the event status for the revenue event. Controls your ability to enter information for, and the processing that occurs against, an event. Available revenue plan event statuses are: Pending, Ready, In Progress, Completed, and Reversed. Pending and Ready are the only statuses that you can set manually. Other statuses are set as a result of a system process.
Hold	Indicates whether this revenue event is tied to a revenue plan that has been placed on hold.
Hold Date	Displays the date on which the revenue plan was put on hold, if this revenue event is tied to a revenue plan that has been placed on hold.
Amount	Displays the total amount for the revenue recognition event associated with this row.

Update Events

The status for each row in the Search Results half of the page can be changed from Ready to Pending or from Pending to Ready. You can update the status of multiple revenue plan events at the same time by selecting the new status (either Pending or Ready), selecting the check box next to the appropriate revenue plans, clicking the Update Plan Status button, and saving. You also use this group box to reverse revenue plan events.

Pending	Select to update the status of the selected Ready event to Pending.
Ready	Select to update the status of the selected Pending event to Ready.
Reversal Initiated	Select to reverse events. You can reverse events in a status of In Progress or Completed only. Note. You cannot events on Percent Complete revenue plans.
Accounting Date	Enter a date for the system to use as the accounting date for the reversing entries.
Update Event Status	Click to update the event status of the selected contract lines Events group box with the pending, ready, or reversal initiated status that you selected. If you selected the Reversal Initiated option, clicking this button initiates the reversal for the revenue event.

Reviewing As-Incurred Revenue Plans

Access the Review Revenue - As Incurred page.

Search Criteria

Use the fields in the Search Criteria group box to filter search results by entering specific values in these fields. If you leave all fields blank, the search returns all revenue plans for all Active contracts within your system. Click the Search button to carry out a search based on the search criteria that you entered. Search results appear in the Details scroll area. Amounts appear in the contract or transaction currency. For as-incurred revenue plan events, a row appears for every transaction currency found within a revenue plan event.

Fee Type

To view as incurred revenue, you must select a value of None in the Fee Type group box. For contracts with a classification of Government, you can select other values in this field.

Detail: General Tab

(select)	Select this check box if you want to redistribute the revenue that has been booked for a row.
PC Business Unit	Displays the value that you specified in the Search Criteria group box.
Project	Displays the name of the project with which this billing is associated. A single project can be associated with multiple contracts.
Activity ID	Displays the ID with which this billing is associated. Contract lines are linked to projects at the activity level—directly or indirectly. Each activity ID can be associated with only one rate-based contract line.
Transaction ID	Displays the ID with which this billing is associated.
Accounting Date	Displays the accounting date, which reflects the accounting period in which entries were booked.
Discount ID	Displays the discount ID, if this row is associated with a discount ID.
Amount	Displays the amount of revenue that was recognized for this row.
Redistribute	Click this button to redistribute the revenue for the rows that you selected on the General tab of the Detail scroll area.

Detail: Contract Tab

Contract Line Num (contract line number)	Displays the contract line that you associated with the revenue plan for this project/activity ID. Each project is linked to a contract line; each contract line is assigned to a revenue plan.
Distribution Type	Each different type of accounting distribution entry is distinguished by distribution type. Examples include revenue, deferred revenue, unbilled AR, interunit credit, and interunit debit.
PostSeq# (posting sequence number)	When you have multiple accounting entries for the same contract line, revenue recognition event, and distribution type, such as when you split revenue across departments, the system uses a posting sequence number to make them unique.
Reversing Entry	Indicates if this entry was redistributed.

Reviewing Revenue Details for Accounting Activities Booked to the GL

Access the Fixed Fee Revenue History page.

Note. The Fixed Fee Revenue History page displays accounting entries for amount-based contract lines only.

Currency	Displays the currency code for the contract.
GL Business Unit	Displays the General Ledger business unit established for the Contracts business unit.
Revenue Plan	Displays the revenue plan ID number. Each contract can contain multiple revenue plans.
GL Currency	Displays the currency code for the General Ledger business unit that is associated with the Contracts business unit.

Revenue Plan History

Dist Seq # (distribution sequence number)	Each accounting distribution entry is identified by a unique distribution sequence number.
GL Unit	Displays the General Ledger business unit where accounting was booked.
Discount ID	Displays the discount ID, if this row is associated with a discount ID.
Amount	Displays in the contract currency the amount of revenue that was recognized for this row.
Base Amount	Displays the amount of the line in the base currency of the General Ledger business unit.
Stat (statistics)	Displays the statistics code, if you created statistical entries for the line.

Inquiring About Amount-Based Accounting Journal Entries

Access the Ca Acct Line Jrnl page.

Your contracts accounting entries must have posted successfully to the GL by the Journal Generator process in order to view them here.

Unit

Displays the General Ledger business unit.

Journal

Displays the General Ledger journal ID.

Line Descr (line description)

Displays the journal line description, if you entered a line description when you created the line.

GL Journal

Click to access the journal for this accounting line.

Project

Displays the Project Costing project ID.

Affiliate

Displays the other General Ledger business unit for interunit accounting entries.

Statistic Amount and Stat

Displays the statistical amount and statistical code if you created statistical entries for the line.

Base Amount

Displays the amount of the line in the base currency of the General Ledger business unit unless you display debits and credits separately.

Base Amount DR (base amount debit) or Base Amount CR (base amount credit)

If you display debits and credits separately, these fields display the amounts in the base currency of the business unit.

Item Amount

Displays the item amount for each accounting line, unless you enabled the Display Separate Debit/Credit in Subsystem option on the Operator Preferences - Overall page.

Amount

Displays the monetary amount of the line in the base currency (Currency Code), if you are not displaying the debits and credits separately.

Transaction Amount DR (transaction debit amount) or Transaction Amount CR (transaction credit amount)

Displays the amounts in the base currency of the business unit, if you are displaying the debits and credits separately.

Amount

Displays the foreign amount in the amount of the transaction in the entry currency (Foreign Currency Code) unless you enabled the Display Separate Debit/Credit in Subsystem option on the User Preferences - Overall Preferences page. If you enabled the Display Separate Debit/Credit in Subsystem option, the Debit Amount or the Credit Amount and currency appear for each accounting line.

Note. If you are not displaying separate debits and credits, negative amounts indicate a credit to the account and positive amounts indicate a debit.

Inquiring About Rate-Based Accounting Journal Entries

Access the Acct Rate Jrnl page.

Note. Your contracts accounting entries must have successfully been posted to the GL by the Journal Generator process to view them here.

The fields on this page are the same as those on the Ca Acct Line Jrnl page.

Reversing Revenue

This section provides an overview of revenue reversal and discusses how to:

Reverse accounting entries for amount-based contracts.
Reverse deferred revenue accounting entries.

Understanding Revenue Reversal

Contracts enables you to reverse revenue that has been generated, by the amount and deferred revenue processes, or journaled by the Journal Generator process. When you reverse revenue, the system generates reversing entries that back out each original entry. You do not enter any new accounting information into the system.

You can reverse revenue previously recognized for an entire contract, a single revenue plan, or a single revenue plan event. You can reverse amount-based revenue previously recognized for a revenue plan event only when the status is In Progress or Completed. You can reverse revenue for an entire revenue plan only if the revenue plan status is In Progress or Completed.

When you reverse a revenue plan, the system sets the plan status to Reversal In Progress. The system sets revenue recognition events that are in progress or complete to Reversal Initiated. The LOAD_GL1 process picks up the Reversal Initiated (RIN) events and sets them to Reversal In Progress. The LOAD_UPD process updates Reversal In Progress (RIP) events to Reversed. If there are no events with RIN or RIP, then the LOAD_UPD process sets the revenue plan status to Reversed.

When you reverse a revenue recognition event, the system sets the events status to Reversal Initiated and the revenue plan status to Action Required. The LOAD_GL1 process picks up the event and creates the reversing accounting entry, and updates the event status to Reversal In Progress. Then, the LOAD_UPD process updates the status to Reversed when the Journal Generator has picked up the entry.

Warning! Before journal generating reversing accounting entries with the Journal Generator process, you must journal-generate the original accounting entries.

Note. If you want to create reversing entries for deferred revenue, you must run the LOAD_DEF process in addition to running the LOAD_GL1 process.

Any of these events may trigger a contract revenue reversal:

Reason	Effect
Change in revenue recognition method.	Revenue plan needs to be reversed.
Change in revenue plan event status.	Revenue plan event needs to be reversed.
Change in revenue plan schedule for previously booked events.	Revenue plan events need to be reversed.
Whole contract negated.	All accounting associated with the contract needs to be reversed.

This table takes a more detailed look at the field-level changes that need to occur to initiate a reversal, the pages where you make the field-level changes, and the Application Engine process that you need to run to process the change:

Reason	Action and Field Level	Initiated From
Change in revenue recognition method.	Revenue plan needs to be reversed.	Review Revenue - Plans page
Revenue plan event was incorrectly set to Ready and booked.	The revenue plan event needs to be reversed.	Review Revenue - Events page
Change accounting distribution for future bookings of a contract line.	The accounting distributions for the contract line must be updated. You must add a new effective-dated row.	Accounting Distribution page Accounting Rules page
Change start date, end date, or schedule on a revenue plan.	Revenue plan needs to be reversed. Then, unassign the contract lines and reassign them to another revenue plan. Alternatively, reverse the events on the plan instead of reversing the entire revenue plan.	Review Revenue - Plans page
Reverse contract (negate contract completely).	Entire contract needs to be reversed.	Contract Reverse Header page

Note. You cannot reverse revenue events for Percent Complete revenue plans. However, you can enter a smaller total percent complete, which initiates a negative incremental event.

Warning! If you use the PeopleSoft Enterprise Commitment Control option in Receivables and you change the revenue distribution after payments have been posted in Receivables, you must create manual journal entries for the budget in order to keep the collected revenue in sync.

Pages Used to Reverse Revenue

Page Name	Object Name	Navigation	Usage
Contract Reversal	CA_REVERSE_HDR	Customer Contracts, Adjust Revenue and Billing, Reverse Contract, Contract Reversal	Reverse all accounting entries created for a specific amount-based (price type of amount or percent) contract. You can also reverse billing for an entire contract.
Deferred Revenue Reversal	CA_REVERSE_DFR	Customer Contracts, Adjust Revenue and Billing, Reverse Contract, Deferred Revenue Reversal	Reverse deferred revenue accounting entries created for a specific amount-based (price type of amount or percent) contract.

Reversing Accounting Entries for Amount-Based Contracts

Access the Contract Reversal page.

Contract Reversal Detail

Revenue Plans	Select this check box if you want to reverse revenue for all amount-based revenue plans associated with this contract.
Accounting Date	Displays the date on which reversal entries are booked.
Reverse Deferred Revenue	Select this check box if you want to reverse the deferred revenue associated with this revenue plan. This check box is available if your contract contains lines with deferred revenue already processed.
Billing Plans	Select this check box if you want to reverse billing for all billing plans associated with this contract. The system generates bills with credit amounts only for billing plans with a method of Percent Complete, Milestone, and Immediate.
Reverse	Click this button to enable the system to reverse revenue plans in a status of In Progress or Complete.

Reversing Deferred Revenue Accounting Entries

Access the Deferred Revenue Reversal page.

Select the deferred revenue rows that you want to reverse for this contract.

Revenue Plan	Click the link to access the revenue plan for this contract line.
Revenue Method	Displays the associated revenue method for this contract line.
Revenue Plan Status	Displays the associated revenue plan status for this contract line.
Drf Rev Status (deferred revenue status)	Displays the deferred revenue status for the contract line. When you reverse deferred revenue, the system sets the status to Reversal Initiated.
Deferred Rev Reversal Date (deferred revenue reversal date)	Displays the date on which you processed the deferred revenue reversal.
Dfr Rev Acct Dt (deferred revenue accounting date)	Displays the deferred revenue accounting date. For a contract line, this is the contract sign date. For an amendment, this is the amendment date. For renewals, this is the renewal cycle start date. Once you reverse deferred revenue, the system clears this field and it remains blank.
Amount	Displays the amount of deferred revenue for this contract line.
Reverse Deferred Revenue	Click to reverse the deferred revenue for the selected contract lines.

Note. For contract lines where the system has begun processing revenue, you cannot reverse the deferred revenue unless you also reverse the revenue.

Redistributing Revenue

This section provides an overview of revenue redistribution, lists common elements and discusses how to:

Redistribute amount-based revenue.
Redistribute rate-based (as-incurred) revenue.

Understanding Revenue Redistribution

This section discusses redistributing amount-based or as-incurred revenue.

Warning! If you have PeopleSoft Enterprise Commitment Control installed, do not redistribute revenue once the system updates the collected revenue amount in Commitment Control. If you do redistribute revenue after the collected revenue is updated, your recognized revenue and collected revenue amounts are out of sync.

If you use the Commitment Control option in Receivables and you change the revenue distribution after payments have been posted in Receivables, you must create manual journal entries for the budget in order to keep the collected revenue in sync.

Redistributing Amount-Based Revenue

If a contract line’s specific accounting distribution needs to be changed, you can use the reversal methods previously explained or you can redistribute revenue. If you use the reversal method, reverse the revenue recognition event or plan or both. When reversing the event or plan, the system reverses the original entry—debiting revenue and crediting either unbilled AR or deferred revenue. To continue with the redistribution, you must then change the distribution for the contract line on the Accounting Distribution page, reset the revenue plan events to Ready, and rerecognize or redistribute revenue by using the Amount-based Revenue process. However, using the revenue redistribution process, you enter the new general ledger (GL) ChartFields for the transaction, and the system makes the required entries.

Revenue reversals differ from redistribution in two ways:

Revenue reversals reset the revenue plan or revenue plan event back as it was prior to the entry being created.

The revenue plan or revenue plan event status is set to Reversed to indicate that this has been done. For redistributions, the revenue plan or revenue plan event status is not changed.
For revenue reversal entries, the system generates the entries to offset both sides of the original entry.

For revenue redistribution entries, the system generates the entry for the reversal of the revenue row. You must specify the GL ChartField string for the offsetting entry.

You can initiate revenue reversals from the appropriate Revenue Management pages based on the level, event, plan, or contract that you need to reverse. Confirm the actual reversal on the Contracts Reversal page. Because reversals do not require you to enter the offsetting entry, you are required to enter an accounting date only.

You can generate reversals only for revenue plan events where the status is set to Completed. For revenue plans, you can initiate revenue reversal if the revenue plan status is In Progress or Completed.

The process for redistributing revenue accounting lines is:

On the Redistribute Fixed Fee page, you select the lines that need to be redistributed.
Click the Redistribute button.
For each row that you selected, the system creates a reversing row in CA_AP_DST.
For each reversed row, the system prompts you for the new ChartField values.
For each reversed row, the system enters a new row in CA_AP_DST to redirect revenue accounting to the wanted ChartFields.

Note. The amount or other information for each row that you are redistributing is not editable. Changes that you make as part of the redistribution process do not alter the status of the revenue plan or any events related to that revenue plan.

Note. When redistributing fixed-fee accounting entries, the system does not include discounts.

Redistributing As-Incurred Revenue

You can initiate a redistribution of the revenue accounting associated with a rate-based contract line (tied to Project Costing) from the revenue management pages in Contracts. For revenue plans that have an as-incurred revenue recognition method, the revenue management pages enable you to view all projects and activities for all contract lines associated with that revenue plan.

When you click the Redistribute button on the Redistribute As Incurred page, a query page appears with the following criteria:

Date Range Entry fields (with a check box indicating transaction date or accounting date).
A drop-down list box to select a specific project ID.
A drop-down list box to select a specific activity ID.
A drop-down list box to select a specific analysis type.
A scroll area with all CA_AP_PC_DST lines with a check box on each line for selecting individual rows.

If a check box on the scroll area is selected, then the drop-down list boxes are unavailable for entry, and vice versa.

When you are finished entering criteria, the system builds a where clause and queries CA_AP_PC_DST.

For each matching row, the system populates a reversing row into a work panel. At save time, the system creates a new row in CA_AP_PC_DST and in CA_ACCTG_LN_PC with seq_num = max (seq_num) + 1, and all other keys equal to the reversed row.

The system prompts you for a new account, department ID, and all other ChartFields to which revenue will be redistributed.

For each matching row, the system creates a new row with the new ChartFields and seq_num = max (seq_num) + 1 on the work panel. At save time, the system inserts the new row into CA_AP_PC_DST and into CA_ACCTG_LN_PC.

Note. If you selected the Project Organization option in Projet Costing for a contract line, you cannot redistribute your as-incurred revenue. When selecting this Project Organization option, you must be careful about any changes that you make here in the Contracts application so that you can reconcile your changes with the entries that are posted to General Ledger.

See Also

Redistributing Revenue

Entering Accounting Distributions

Common Elements Used in This Section

Discount ID	Displays the discount ID, if a row is for a discount.
Distribution Type	Each different type of accounting distribution entry is distinguished by distribution type. Examples include revenue, deferred revenue, unbilled AR, interunit credit, and interunit debit.
GL Business Unit	General Ledger business unit.
GL Currency	Currency specified for the General Ledger business unit that was associated with this contract’s Contracts business unit.
PostSeq# (posting sequencing number)	The system inserts a posting sequence number for each new row that is added to this table where the other keys for the row are the same.
Recognized Amount	Amount of revenue that has been recognized to date for this revenue plan. You can redistribute only revenue that has already been recognized. If revenue for a revenue plan event has not yet been recognized, you can use the Accounting Distribution page to change the distribution accounts for the contract lines that are tied to this revenue plan.
Redistribute	After you have selected the events or entries that you want to redistribute, click this button to initiate the redistribution process.
Redistribute	Select this check box to redistribute revenue for that row.
Revenue Plan	Revenue plan number for which you redistribute revenue.
Reversing Entry	This field indicates if this entry was the result of a reversal.

Pages Used to Redistribute Revenue

Page Name	Object Name	Navigation	Usage
Redistribute Fixed Fee	CA_AP_SUMMARY	Customer Contracts, Adjust Revenue and Billing, Redistribute Fixed Fee Click the Redistrib link on the Review Revenue - Plans page.	Redistribute revenue accounting lines that the system has generated for a revenue plan event. The system limits redistribution of revenue to redistributing revenue to different departments.
Redistribute As Incurred	CA_AP_PC_SUMMARY	Customer Contracts, Adjust Revenue and Billing, Redistribute As Incurred	Redistribute revenue accounting lines that the system has generated for an as-incurred revenue plan. The system limits redistribution of revenue to departments only.

Redistributing Amount-Based Revenue

Access the Redistribute Fixed Fee page.

Redistribute Fixed Fee page: General Tab

Line # (line number)	Displays the contract line number that you associated with the revenue plan for this event. As accounting distributions are stored at the contract line level, you may have multiple contract lines associated with a single event number.
Event	Displays the revenue plan event number under which this revenue was booked.
Dist Seq # (distribution sequence number)	Displays the distribution sequence number. Each accounting distribution entry is identified by a unique distribution sequence number.
Amount	Displays the row amount in the transaction currency.
Base Amount	Displays the row amount in the base currency of the contract’s General Ledger business unit.

Redistribute Fixed Fee page: Chartfields Tab

Select the Chartfields tab.

GL Unit	Displays the General Ledger business unit to which this row is being booked.
Project	Captures additional information useful for project accounting.

Redistributing Rate-Based (As-Incurred) Revenue

Access the Redistribute As Incurred page.

Redistribute As Incurred Page: General Tab

Line #	Displays the contract line number that you associated with the revenue plan.
PC Bus Unit (Project Costing business unit)	Displays the Project Costing business unit with which a contract line is associated. Each contract line is associated with only one Project Costing business unit. Each contract line and projects business unit combination is reflected in as many rows as there are unique ChartField string combinations for the project ID, activity ID, and resource ID.
Project	Displays the ID with which this billing is associated. A single project ID can be associated with multiple contracts.
Activity ID	Displays the ID with which this billing is associated. Contract lines are linked to projects at the activity level—directly or indirectly. Each activity ID can be associated with only one rate-based contract line.
Transaction ID	Displays the ID with which this billing is associated.
Accounting Date	Displays the accounting date, which reflects the accounting period in which the entries were booked.
Amount	Displays the amount of revenue, in the General Ledger business unit’s base currency that was booked for this row.

Redistribute As Incurred Page: Chartfields Tab

Select the Chartfields tab.

Reconciling Billing and Revenue

This section provides an overview of reconciliation and discusses how to:

Define reconciliation options.
Select a contract, contract line, project, or project/activity to reconcile.
Redistribute revenue to an alternate account and offset the unbilled AR distribution.
Summarize your reconciliations.

Understanding Reconciliation

For contracts containing rate-based contract lines (with either value-based or as-incurred billing plans), you can view both the revenue recognized and the total amount billed-to-date for these levels:

Contract.
Contract line.
Project Costing business unit.
Project.
Project/Activity.

The level to which you can reconcile depends on the parameters specified on the Contracts Reconciliation Definition page and the information that you entered on the billing plan. You specify the search level (contract, contract line, project, or project/activity) and you specify how the data should be summarized. Your summarization choices are essential because these choices dictate how you can review and reconcile revenue transactions.

Revenue data is stored in the CA_ACCTG_LINE_PC table (where the accounting entries are stored), and billing data is stored in the BI_ACCT_ENTRY table. The data on the Reconcile Revenue and Billing page appears in the GL currency, but the accounting information is also available. The CA_ACCTG_LINE_PC table provides the revenue transactions in the actual amount currency booked to the GL, and it provides the interunit entries to reflect if revenue was transferred to another General Ledger business unit (potentially in another currency).

With the reconciliation tool, you can initiate revenue adjustments. From the Reconcile Entry page, you can redistribute revenue from the ChartFields displayed on a row on the page to another revenue account (for example, department or affiliate). You can also do this through the Review Revenue - Plans page. The unbilled AR Distribution section provides you with the ability to book the unbilled AR entry as the offset when revenue is decreased or increased.

Note. You can reconcile only on the ChartFields that were selected on the Contracts Reconciliation Definition page. If you did not break on those ChartFields, they do not appear.

Note. The Reconcile Revenue and Billing feature does not support prepaid amounts.

Note. Although you can reconcile rate-based contract lines with either value-based or as-incurred revenue plans, the Reconciliation page is used primarily for contract lines with the value-based billing method.

Pages Used to Reconcile Billing and Revenue

Page Name	Object Name	Navigation	Usage
Reconciliation Options by User	CA_RECON_DEFN	Set Up Financials/Supply Chain, Product Related, Contracts, General Options, Reconciliation Options by User	Specify your Review By and Break On parameters for reconciliation.
Reconciliation Search	CA_RECON_SEARCH	Customer Contracts, Adjust Revenue and Billing, Reconcile Revenue to Billing	Select a contract, contract line, project, or project/activity to reconcile. The fields that appear on this page depend on the parameters that you specified on the Contracts Reconciliation Definition page. You can change these parameters by clicking the Change Reconciliation Fields link. You can search only for rate-based contract lines (value-based or as-incurred billing plans; as-incurred revenue recognition method).
Reconciliation Entry	CA_RECON_ENTRY	Click from the Reconciliation Search page.	Redistribute revenue to an alternate account and offset your unbilled AR distribution. You can book only to GL ChartFields that are included in the break on on the Contracts Reconciliation Definition page. ChartFields that you do not break on do not appear on this page.
Create Reconciliation Summary	RUN_CA_RECON_SUM	Customer Contracts, Adjust Revenue and Billing, Create Reconciliation Summary	Summarize your reconciliations by running the Reconciliation Summary process. When the reconciliation process completes, it populates the CA_RECON_REV and CA_RECON_BI tables.

Defining Reconciliation Options

See Defining Reconciliation Options.

Selecting a Contract, Contract Line, Project, or Project/Activity to Reconcile

Access the Reconciliation Search page.

Search Criteria

Use the fields in the Search Criteria group box to filter the list of contracts or projects for which the system will search. When you leave a field blank, the system runs the process for all values for that field. The search fields that appear on this page depend on the criteria that you specified on the Contracts Reconciliation Definition page.

GL Unit	Enter the GL business unit for which you want to search. Note. If you’re using interunit accounting, the reconciliation needs to be shown in one currency. Therefore, enter the GL business unit that you want to view on the Reconciliation Entry page. For interunit accounting: If you select the GL unit of the contract, you see revenue and interunit (I/U) payables that total all revenue for the entire contract, contract line, project, or project/activity. If you select a GL unit that distributed only a portion of the revenue, you see revenue and the interunit (I/U) receivable sent to that particular GL unit.
Search	Click to initiate your search.
Summarize	Click to start the summarization process.
Change Reconciliation Fields	Click this link to modify your review by and break on criteria.

Search Results

The fields that appear depend on the criteria specified in the Search Criteria group box.

	Click to run the Reconciliation Summary process on the fly for this particular contract, contract line, project, or project/activity. You can also run the process from the Create Reconciliation Summary page. You can redistribute revenue or create offsets for a contract line.
Last Updated	Displays the date on which this contract, contract line, project, or project/activity was last summarized.

Redistributing Revenue to an Alternate Account and Offsetting the Unbilled AR Distribution

This section discusses how to redistribute revenue to an alternate account and offset the unbilled distribution.

To make an adjustment:

Enter the amount of the adjustment for your row.
Click the Calculate button.
Click the Create Entries button.

To redistribute revenue to an alternate account:

Enter the positive amount (debit revenue) for the row that you want to adjust.
Click the + button to add a new row.
Enter the new account, department ID, and affiliate on this new row, in addition to a negative amount (credit for revenue).
Click the Calculate button.
Click the Create Entries button.

Because the total adjusted amount equals 0.00 when you redistribute revenue (because the two rows net out), no unbilled AR offset is created.

Access the Reconciliation Entry page.

The values that you searched on appear at the top of the page for the line that you selected. These values depend on the review by and break on criteria specified on the Defining Reconciliation Options page. The currency appears in the General Ledger currency.

Revenue

These values depend on the review by and break on criteria.

Use	Displays the type of accounting for this contract, contract line, project, or activity. Values are: REV: Revenue IUR: Interunit receivable IUP: Interunit payable
Adjustment Amount	To redistribute revenue to an alternate revenue account, enter the positive amount (debit revenue) in this field for the row that you want to adjust. To continue with the redistribution, click the + button to add a new row. Enter the new account, department ID, and affiliate on this new row, in addition to a negative amount (credit for revenue). Note. You can book only to GL ChartFields that were included in the break on in the reconciliation page. ChartFields that you do not break on do not appear on this page. Click the Calculate button, and then click the Create Entries button. Because the total adjusted amount equals 0.00 (because the two rows net out), no unbilled AR offset is created.
Total	Displays the total revenue booked for this contract, contract line, project or project/activity.
Total Adj Amt (total adjusted amount)	Displays the same value as in the Total field, when you first enter this page. This value changes as you make adjustments to this page.
Billed Amount	Displays the total amount billed to date. This value appears in the contract (or billing) currency, if the currency differs from the GL currency.
Difference	Displays the difference between the total adjusted amount and the billed amount.
Accounting Date	Displays the current date, which appears by default as the accounting date. You have the option of selecting a different accounting date.
Caclulate	Click to calculate distribution credits.
Create Entries	Click to create accounting entries in the Unbilled AR Distribution group box.

Unbilled AR Distribution

The Unbilled AR Distribution group box provides you with the ability to book the unbilled AR entry as the offset when revenue is decreased or increased. For multiple contracts, contract lines, projects, or project/activities, you can offset to the same accounting distribution, or you can choose to offset each line separately. You may want to offset each line separately if you want to establish different accounting for each (for example, a different department ID). Select where the offset is applied.

The values under the Unbilled AR Distribution group box appear by default based on whether you are reviewing by contract, contract line, project, or activity:

Contract	For a contract, displays the business unit by default.
Contract Line	Displays the unbilled AR of the contract line by default.
Project	If the all act (all activities) check box was selected on the Related Projects page for this project, then the project goes to one contract line, and the unbilled AR comes from that one line. If the project is split among multiple rows, then no value appears by default.
Activity	Because activities can belong to only one contract line, the unbilled AR from the contract line appears by default.

The distribution code appears by default based on the contract line that you are reviewing. The distribution codes are restricted, and you are allowed to select only distribution codes with an unbilled AR account type. However, the general ledger ChartFields—Account, Alt Acct (alternate account), Oper Unit (operating unit), Fund, Dept (department ID), Program, Class, Bud Ref (budget reference), Product, Affiliate, Fund Affil (fund affiliate), and Oper Unit Affil (operating unit affiliate)—are not restricted to unbilled AR accounts. Therefore, you can change the account number under the Unbilled AR Distribution group box to another type of account (for example, revenue), but it never appears in the revenue numbers in the Revenue region of this page. Use the Unbilled AR Distribution group box to offset the adjustments with unbilled AR only.

GL Unit	Displays the General Ledger business unit for your contract line. You can select a different business unit for the offset.
Distribution Code	Displays the distribution code by default, based on whether you are reviewing by contract, contract line, project, or activity. You can select a different distribution code. The distribution codes are restricted to allow you to pick only distribution codes with an unbilled AR account type.
Account	Displays the values for this unbilled AR account field by default from various sources, depending on whether you are reviewing by contract, contract line, project, or activity.

Summarizing Your Reconciliations

Access the Create Reconciliation Summary page.

Program Name

Process Frequency

Specifies how often the Reconciliation Summary process runs. Values are:

Always: Processes reconciliation every time the Reconciliation Summary process runs.

Don’t: Won’t initiate the program, even if you click the Run button.

Once: Runs reconciliation once; Don’t appears in the Process Frequency field.

Contract Options

Use the fields in the Contract Options group box to filter the list of contracts on which this process runs. When you leave a field blank, the system runs the process for all values for that field.

Project Options

Use the fields in the Project Options group box to filter the list of contracts on which this process runs. When you leave a field blank, the system runs the process for all values for that field.

Purging Options

Purge All Older Than

Enter a number if you want the system to delete all reconciliation records that are older than a specified number of days. If you leave this field blank, the system overwrites only the existing data for the contract for which you are currently running this process.

Unit	Displays the General Ledger business unit.
Journal	Displays the General Ledger journal ID.
Line Descr (line description)	Displays the journal line description, if you entered a line description when you created the line.
GL Journal	Click to access the journal for this accounting line.
Project	Displays the Project Costing project ID.
Affiliate	Displays the other General Ledger business unit for interunit accounting entries.
Statistic Amount and Stat	Displays the statistical amount and statistical code if you created statistical entries for the line.
Base Amount	Displays the amount of the line in the base currency of the General Ledger business unit unless you display debits and credits separately.
Base Amount DR (base amount debit) or Base Amount CR (base amount credit)	If you display debits and credits separately, these fields display the amounts in the base currency of the business unit.
Item Amount	Displays the item amount for each accounting line, unless you enabled the Display Separate Debit/Credit in Subsystem option on the Operator Preferences - Overall page.
Amount	Displays the monetary amount of the line in the base currency (Currency Code), if you are not displaying the debits and credits separately.
Transaction Amount DR (transaction debit amount) or Transaction Amount CR (transaction credit amount)	Displays the amounts in the base currency of the business unit, if you are displaying the debits and credits separately.
Amount	Displays the foreign amount in the amount of the transaction in the entry currency (Foreign Currency Code) unless you enabled the Display Separate Debit/Credit in Subsystem option on the User Preferences - Overall Preferences page. If you enabled the Display Separate Debit/Credit in Subsystem option, the Debit Amount or the Credit Amount and currency appear for each accounting line.