Managing Revenue Recognition

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

Click to jump to parent topicUnderstanding Revenue Management

PeopleSoft Contracts enables you to capture revenue information for a contract and allocate that information to specific contract lines within the PeopleSoft 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 PeopleSoft General Ledger system.

You can actively manage accounting activity that is generated by PeopleSoft Contracts. You define accounting information (amounts and accounting distributions) within PeopleSoft 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 PeopleSoft 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 PeopleSoft Contracts revenue Application Engine processes.

This section discusses:

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

See Also

Managing Revenue and Billing for Government Contracts

Understanding Accounting Distributions

Entering Accounting Distributions

Setting Up Revenue Plans

Setting Up Accounting for Projects

Click to jump to top of pageClick to jump to parent topicPrerequisites

Before you can begin to manage revenue, you need:

Click to jump to top of pageClick to jump to parent topicManaging 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:

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:

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

Click to jump to top of pageClick to jump to parent topicManaging the Revenue Process in PeopleSoft Contracts

You can view revenue that has been recognized to date and pending revenue recognition for any cross-section of your PeopleSoft 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

Click to jump to top of pageClick to jump to parent topicPlacing 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.

Click to jump to top of pageClick to jump to parent topicManaging 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.

Click to jump to top of pageClick to jump to parent topicChanging Accounting Distributions for Amount-based Contract Lines

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

Click to jump to top of pageClick to jump to parent topicChanging 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.

Click to jump to top of pageClick to jump to parent topicAdjusting 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

Click to jump to top of pageClick to jump to parent topicChanging 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.

Click to jump to parent topicReviewing Revenue

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

See Also

Setting Up Revenue Plans

Click to jump to top of pageClick to jump to parent topicUnderstanding 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 PeopleSoft 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 PeopleSoft Contracts.

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

Processes for Review Revenue - As Incurred Page

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

  1. In PeopleSoft 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.

  2. In PeopleSoft 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 PeopleSoft Project Costing analysis type.

  3. When the Contracts to Billing interface is run, PeopleSoft Contracts sends rows to PeopleSoft Billing, and the system creates bill lines on the Billing Worksheet.

  4. 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 PeopleSoft Contracts).

  5. In PeopleSoft 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.

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

  7. 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 PeopleSoft Receivables, PeopleSoft 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 PeopleSoft Receivables.

Analysis Types in PeopleSoft 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.

Click to jump to top of pageClick to jump to parent topicCommon 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)

PeopleSoft 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 PeopleSoft 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

PeopleSoft General Ledger business unit.

PC Business Unit

PeopleSoft Project Costing business unit.

Processed On

Last date upon which the system recognized revenue for this revenue plan or event.

Click to jump to top of pageClick to jump to parent topicPages 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 PeopleSoft 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 PeopleSoft 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.

Click to jump to top of pageClick to jump to parent topicReviewing 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 PeopleSoft General Ledger ChartFields.

Click to jump to top of pageClick to jump to parent topicReviewing 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

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

Click to jump to top of pageClick to jump to parent topicReviewing 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.

Click to jump to top of pageClick to jump to parent topicReviewing 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 PeopleSoft General Ledger business unit established for the PeopleSoft 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 PeopleSoft General Ledger business unit that is associated with the PeopleSoft 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 PeopleSoft 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 PeopleSoft General Ledger business unit.

Stat (statistics)

Displays the statistics code, if you created statistical entries for the line.

Click to jump to top of pageClick to jump to parent topicInquiring 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 PeopleSoft General Ledger business unit.

Journal

Displays the PeopleSoft 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 PeopleSoft Project Costing project ID.

Affiliate

Displays the other PeopleSoft 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 PeopleSoft 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.

Click to jump to top of pageClick to jump to parent topicInquiring 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.

Click to jump to parent topicReversing Revenue

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

Click to jump to top of pageClick to jump to parent topicUnderstanding Revenue Reversal

PeopleSoft 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 PeopleSoft Receivables and you change the revenue distribution after payments have been posted in PeopleSoft Receivables, you must create manual journal entries for the budget in order to keep the collected revenue in sync.

Click to jump to top of pageClick to jump to parent topicPages 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.

Click to jump to top of pageClick to jump to parent topicReversing 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.

Click to jump to top of pageClick to jump to parent topicReversing 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.

Click to jump to parent topicRedistributing Revenue

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

Click to jump to top of pageClick to jump to parent topicUnderstanding 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 PeopleSoft Receivables and you change the revenue distribution after payments have been posted in PeopleSoft 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:

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

  2. 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:

  1. On the Redistribute Fixed Fee page, you select the lines that need to be redistributed.

  2. Click the Redistribute button.

  3. For each row that you selected, the system creates a reversing row in CA_AP_DST.

  4. For each reversed row, the system prompts you for the new ChartField values.

  5. 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 PeopleSoft Project Costing) from the revenue management pages in PeopleSoft 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:

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 PeopleSoft Contracts application so that you can reconcile your changes with the entries that are posted to PeopleSoft General Ledger.

See Also

Redistributing Revenue

Entering Accounting Distributions

Click to jump to top of pageClick to jump to parent topicCommon 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

PeopleSoft General Ledger business unit.

GL Currency

Currency specified for the PeopleSoft General Ledger business unit that was associated with this contract’s PeopleSoft 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.

Click to jump to top of pageClick to jump to parent topicPages 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.

Click to jump to top of pageClick to jump to parent topicRedistributing 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 PeopleSoft General Ledger business unit to which this row is being booked.

Project

Captures additional information useful for project accounting.

Click to jump to top of pageClick to jump to parent topicRedistributing 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 (PeopleSoft Project Costing business unit)

Displays the PeopleSoft Project Costing business unit with which a contract line is associated. Each contract line is associated with only one PeopleSoft 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 PeopleSoft General Ledger business unit’s base currency that was booked for this row.

Redistribute As Incurred Page: Chartfields Tab

Select the Chartfields tab.

Click to jump to parent topicReconciling Billing and Revenue

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

Click to jump to top of pageClick to jump to parent topicUnderstanding 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:

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

See Also

Using Inter/Intraunit Processing in General Ledger

Click to jump to top of pageClick to jump to parent topicPages 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.

Click to jump to top of pageClick to jump to parent topicDefining Reconciliation Options

See Defining Reconciliation Options.

Click to jump to top of pageClick to jump to parent topicSelecting 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.

Click to jump to top of pageClick to jump to parent topicRedistributing 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:

  1. Enter the amount of the adjustment for your row.

  2. Click the Calculate button.

  3. Click the Create Entries button.

To redistribute revenue to an alternate account:

  1. Enter the positive amount (debit revenue) for the row that you want to adjust.

  2. Click the + button to add a new row.

  3. Enter the new account, department ID, and affiliate on this new row, in addition to a negative amount (credit for revenue).

  4. Click the Calculate button.

  5. 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 PeopleSoft 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.

Calculate

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

Click to jump to top of pageClick to jump to parent topicSummarizing 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.