Understanding Accounting Distributions

This chapter discusses:

Click to jump to parent topicAccounting Distributions

The accounting distribution entries made by PeopleSoft Contracts depend upon several factors. This table shows the type of accounting distribution setup that is required based upon the product that is managing revenue, whether or not you are booking entries to deferred revenue, and the contract line’s pricing type:

Product That Manages Revenue

Deferred Revenue Enabled

Contract Line Pricing Type

Required Distribution Types

PeopleSoft Contracts

Yes

Amount, Percent

Revenue, deferred revenue, unbilled accounts receivable (AR)

PeopleSoft Contracts

No

Amount, Percent

Revenue, unbilled AR

PeopleSoft Contracts

No

Rate

Unbilled AR (only if assigned to a value-based billing plan)

PeopleSoft Billing

No

Amount, Percent, Recurring

Revenue

PeopleSoft Billing

Yes

Recurring

Revenue, deferred revenue

Note. PeopleSoft Billing can manage revenue for fixed-amount and recurring contract lines only. When PeopleSoft Billing manages revenue for fixed-amount contract lines, PeopleSoft Contracts does not support booking to deferred revenue. Billing Manages Revenue is the only available revenue recognition method for recurring contract lines.

This section discusses:

See Also

Entering Accounting Distributions

Click to jump to top of pageClick to jump to parent topicFixed-Amount Contract Lines

A fixed-amount contract line is a product or service for which you charge a defined amount. Fixed-amount contract lines have a price type of Amount or Percent. When PeopleSoft Contracts manages revenue for fixed-amount contract lines, you associate the contract line with a revenue plan that has a revenue recognition method of Apportionment, Milestone, or % Complete. When PeopleSoft Billing manages revenue for a fixed-amount contract line, you do not associate the contract line with a revenue plan. Regardless of which product manages revenue, you must associate the fixed-amount contract line with account distribution information either using distribution sets and distribution codes or by manually entering PeopleSoft General Ledger ChartField information.

Click to jump to top of pageClick to jump to parent topicRate-based Contract Lines

A rate-based contract line is a transaction-based product or service for which you have set up one or more projects in PeopleSoft Project Costing. The revenue and unbilled AR accounting distributions for these types of service products are stored in the accounting rules. As work is performed against a project, PeopleSoft Project Costing receives transactional information relating to that work. PeopleSoft Project Costing prices the transactions based on the rate plan or rate set. PeopleSoft Contracts picks up the PeopleSoft Project Costing billable transactions and sends them to PeopleSoft Billing.

Upon sending the billable transactions to PeopleSoft Billing, the PeopleSoft Contracts process also sends the unbilled AR accounting distribution. For rate-based lines assigned to as-incurred billing plans, the unbilled AR is pulled from the accounting rules. For rate-based lines assigned to value-based billing plans, the unbilled AR is pulled from the accounting distribution page in PeopleSoft Contracts (CA_DETAIL_UAR).

Additionally, the rate-based revenue process (Accounting Rules Engine) picks up eligible Projects PROJ_RESOURCE rows and sends them to PeopleSoft General Ledger. The revenue and unbilled AR accounting distributions are defined to each PeopleSoft Project Costing transaction eligible for revenue recognition based on the accounting rules defined.

Click to jump to top of pageClick to jump to parent topicRecurring Contract Lines

A recurring contract line is a product or service for which you charge recurring bills. With a revenue recognition method of Billing Manages Revenue, for a recurring contract line, you do not associate the contract line with a revenue plan. However, you must associate the recurring contract line with account distribution information using distribution sets and distribution codes or by manually entering PeopleSoft General Ledger ChartField information on the Accounting Distribution page.

When setting up billing for recurring contract lines, you must select the recurring billing method. There are no billing plan lines or events associated with a recurring billing plan. You define the start date and schedule, and each time the plan is eligible for billing, the system generates the appropriate invoice lines and sends them to PeopleSoft Billing along with the accounting distribution.

Click to jump to parent topicMulticurrency

The timing of the exchange rates that the system uses to perform conversions depends upon whether you enabled the deferred revenue recognition option at the product group level. This exchange rate is used for converting the revenue amount when the contract currency is different from the PeopleSoft General Ledger base currency and for interunit transfers in which the base currency for the PeopleSoft General Ledger business unit to which you are transferring is different from the base currency of the PeopleSoft General Ledger business unit from which you are transferring.

If you did not select the option to book to deferred revenue, then the Amount-based Revenue process uses the exchange rate that is current for the accounting period in which you are running the process. If you selected the option to book to deferred revenue, then the Deferred Revenue process and the Amount-based Revenue process use the same exchange rate to convert the deferred revenue amount from PeopleSoft Contracts.

The system always translates interunit transfer amounts by using the rate type, the current accounting month’s rate, and the contract’s PeopleSoft General Ledger business unit currency (not the contract’s billing currency). For example: Contract CON0001 has a contract currency of DEM. Contract CON0001 is associated with PeopleSoft Contracts business unit CABU01. PeopleSoft Contracts business unit CABU01 is associated with PeopleSoft General Ledger business unit GLBU01, which has a currency of USD. The system performs the conversion from DEM to USD when populating deferred revenue (assuming that you’ve enabled the option to book to deferred revenue). The system then performs the interunit-related conversions from USD to the currency of the PeopleSoft General Ledger business unit receiving revenue (such as CAD).

Click to jump to parent topicAccounting Distribution Defaults

To set up default accounting distributions for your products, you:

  1. Define distribution rules.

  2. Define distribution sets.

  3. Associate a default distribution rule with your PeopleSoft Contracts business unit.

Distribution Rules

Distribution rules identify the hierarchy that the system uses to identify which distribution set to use for a particular product. You can define any number of combination criteria and hierarchy to tell your system how to identify and apply the accounting distributions. For example, you might set up your distribution rules to satisfy one of these scenarios:

In the previous examples, you build one distribution rule by determining which scenario is the most important and then arranging the three scenarios in order of priority by using the sequence numbered rows on the Distribution Rules page. The distribution rule that you define is then associated with a PeopleSoft Contracts business unit. When you select a product onto a contract, the system examines the distribution rule for that PeopleSoft Contracts business unit to determine which distribution set to use for populating the revenue distribution code values onto the Accounting Distribution page for each contract line.

Distribution Sets

A distribution set is made up of distribution codes. Each code in a distribution set can have a distribution percentage. You can define multiple distribution sets. Then, you associate the set with a product, product group, customer, and so forth.

Note. Note. If you use region codes, do not use the region code on the contract header, but instead specify the region code at the customer level.

Default Distribution Association

When defining a PeopleSoft Contracts business unit, you must identify a default distribution rule code to the business unit. This distribution rule code is the link between the PeopleSoft Contracts business unit and the distribution rules and distribution sets. When you select a product onto a contract, the system examines the distribution rule for that PeopleSoft Contracts business unit to determine which distribution set to use for populating the revenue distribution code values onto the accounting distribution page for each contract line.

See Also

Establishing Distribution Rules and Sets

Click to jump to parent topicAccounting Distribution Creation

The initial accounting distributions for a contract line are populated by the system. For fixed-amount and recurring contract lines, the revenue accounting distribution codes are obtained from distribution sets. If you enabled the deferred revenue recognition option at the product group level, the system checks the revenue distribution code for a related deferred revenue distribution code and populates the Accounting Distribution page with those revenue and deferred revenue values.

Note. If you did not associate a deferred revenue distribution code with the revenue distribution code, the system populates only the revenue distribution. You must manually add the deferred revenue accounting information to the contract line's accounting distribution before the contract can be activated.

When you save a contract line, ChartField combination editing verifies that the revenue, deferred revenue, and unbilled AR accounting distributions are valid for the PeopleSoft General Ledger business unit listed. You cannot save a contract with an Active processing status until all of its accounting distributions pass ChartField combination editing.

This section discusses:

See Also

Editing ChartField Combinations

Click to jump to top of pageClick to jump to parent topicRevenue Accounting

This section discusses revenue accounting for:

Amount-based Contract Lines

When you select a product onto a contract, the system populates the revenue distribution accounting based on distribution sets to the revenue fields on the Accounting Distribution page. Additionally, the PeopleSoft General Ledger business unit on the accounting distribution is populated with the PeopleSoft General Ledger business unit associated with the PeopleSoft Contracts business unit of the contract. The PeopleSoft General Ledger business unit and revenue accounting distribution are editable for each fixed-amount contract line on the Accounting Distribution page. You can edit the existing revenue accounting distribution or split the revenue across multiple accounting distributions (such as departments). When you save the Accounting Distribution page, the system performs combination editing to ensure that the combination of ChartFields that you specify are valid for the selected PeopleSoft General Ledger business unit.

When you save the Accounting Distribution page, the system performs combination editing to ensure that the combination of ChartFields that you specify are valid for the selected PeopleSoft General Ledger business unit.

In addition to ChartField Combo-Editing, the system checks to ensure that the amount distributed on the Accounting Distribution page equals the amount on the contract line defined through negotiated amount allocation. If you complete amount allocation after you distribute the accounting, an error may appear. If ChartField Combo-Editing or distribution amount errors exist, you see an Action Required link on the Details tab of the Contract - Lines page.

Warning! If you use the PeopleSoft Enterprise Commitment Control option to update the revenue budgets in PeopleSoft Receivables, PeopleSoft recommends that you use the same revenue distribution lines for fixed-amount contracts throughout the life of the contract so that the collected revenue lines are updated correctly when payments are made in PeopleSoft Receivables.

Rate-based Contract Lines

For rate-based contract lines, the revenue distribution accounting is defined by using accounting rules through the As Incurred Accounting Distribution page. Like distribution sets, rate-based accounting rules may reference distribution codes for ease of use. However, each accounting rule allows only one revenue distribution to be defined. When forecasting revenue for rate-based lines, use distribution sets with distribution codes.

Recurring Contract Lines

For recurring contract lines, the system handles the accounting similar to fixed-amount. The system populates the revenue distribution on the Accounting Distribution page based on distribution sets. If the revenue distribution code in the distribution set has a related deferred revenue distribution code, the system also populates the deferred revenue distribution on the Accounting Distribution page.

Warning! If you use the PeopleSoft Enterprise Commitment Control option to update the revenue budgets in PeopleSoft Receivables, PeopleSoft recommends that you use the same revenue distribution lines for fixed-amount contracts throughout the life of the contract so that the collected revenue lines are updated correctly when payments are made in PeopleSoft Receivables.

See Also

Entering Accounting Distributions

Setting Up Accounting for Projects

Click to jump to top of pageClick to jump to parent topicDeferred Revenue Accounting

This section discusses deferred revenue accounting for:

Note. PeopleSoft Contracts books entries to deferred revenue only for contract lines for which PeopleSoft Contracts is managing revenue. If PeopleSoft Billing is managing revenue, no deferred revenue is booked in PeopleSoft Contracts. It is recommended that you do not use the deferred revenue functionality in PeopleSoft Billing for fixed-amount contract lines generated from PeopleSoft Contracts. However, for recurring contract lines, PeopleSoft Billing manages revenue and handles all deferred revenue information.

Note. For fixed-amount and recurring contract lines, the default deferred distribution is not specified directly on the distribution set, unlike the revenue distribution. The system retrieves the deferred distribution by default by using the revenue distribution code's associated deferred distribution code. You can edit the existing deferred revenue accounting distribution or split the distribution across multiple accounting entries.

Amount-based Contract Lines

If you selected deferred revenue recognition for a contract line, the deferred revenue accounting distribution is editable for each fixed-amount contract line on the Accounting Distribution page. The GL Unit (general ledger unit) field populates with the PeopleSoft General Ledger business unit associated with the PeopleSoft Contracts business unit of the contract.

Note. The PeopleSoft General Ledger business unit of the deferred revenue accounting distribution is not editable.

Note. Splitting deferred revenue accounting distribution across PeopleSoft General Ledger ChartFields could result in complex account reconciliation and is not recommended.

When you save the Accounting Distribution page, the system performs combination editing to ensure that the deferred revenue accounting that you specify is valid for its general ledger (GL) business unit.

The contract line contains a deferred accounting date. When you run the Deferred Revenue process, you specify a date range for that process run. The system processes any contract lines belonging to active contracts with a deferred accounting date within the range specified and that have not already been processed.

If you enter a deferred accounting date that falls before a contract line's earliest accounting distribution effective date, the system warns you that an effective-dated accounting distribution needs to be defined for the deferred revenue accounting date. The deferred revenue process does not generate accounting entries for the contract lines until you do one of these:

For each fixed-amount contract line, the deferred revenue process creates a credit to the deferred revenue account that you specified for that contract line, and a debit to the unbilled AR account that you specified for that contract line.

Rate-based Contract Lines

Rate-based contract lines are not associated with deferred revenue because no known amount is associated with these types of lines. Revenue for rate-based lines is only recognized as work is performed.

Recurring Contract Lines

If you selected deferred revenue recognition for a recurring contract line, the deferred revenue accounting distribution is editable on that contract line's Accounting Distribution page. The GL Unit field populates with the PeopleSoft General Ledger business unit associated with the PeopleSoft Contracts business unit of the contract. PeopleSoft Billing handles the deferred revenue processing for recurring contract lines.

See Processing Deferred Revenue (CA_LOAD_DEF).

Click to jump to top of pageClick to jump to parent topicUnbilled AR

PeopleSoft Contracts manages revenue separately from PeopleSoft Billing by using unbilled AR accounting distributions. You establish an unbilled AR distribution code at either the PeopleSoft Contracts business unit level (mandatory) or lower at the product group level (optional).

Note. You do not define unbilled AR accounting distributions for recurring contract lines because billing manages revenue for this price type.

This section discusses unbilled AR accounting for:

Amount-based Contract Lines

If a contract line's product is associated with a product group for which an unbilled AR distribution code is defined, the system writes that unbilled AR accounting distribution to the Accounting Distribution page for that contract line. The unbilled AR accounting distribution for a contract line is editable on the Accounting Distribution page. The GL Unit field is populated with the PeopleSoft General Ledger business unit associated with the PeopleSoft Contracts business unit of the contract. When you save the Accounting Distribution page, the system performs combination editing to ensure that the unbilled AR distribution that you specify is valid for the PeopleSoft General Ledger business unit. When PeopleSoft Contracts manages revenue, unbilled AR is debited when you credit either revenue or deferred revenue. Unbilled AR is credited when the bill is generated (PeopleSoft Billing debits AR). Unbilled AR is not used if PeopleSoft Billing manages revenue. Because unbilled AR is populated and depleted throughout the life of the contract line, its distribution on the Accounting Distribution page cannot be changed after the contract is activated. In addition, you can specify only one line of unbilled AR accounting distribution.

For example: Best Customer Corporation is installing PeopleSoft Contracts and it wants to recognize all unbilled AR by business unit, except for unbilled AR from services. Best Customer Corporation sets up unbilled AR for all PeopleSoft Contracts business units. Best Customer Corporation also sets up unbilled AR for the services-related product groups. Best Customer Corporation does not set up any unbilled AR accounting distribution for product groups that are not related to services:

Business Unit (BU)

Product Group (PC)

Unbilled AR Account

M04

 

129999

M02

 

128000

 

Services

120000

This table lists the results of combinations of PeopleSoft Contracts business units and product groups based on the previous setup:

Business Unit

Product Group

Unbilled AR Account

M02

Fee

128000

M02

Maintenance

128000

M02

Product

128000

M02

Service

120000

M04

Fee

129999

M04

Maintenance

129999

M04

Product

129999

M04

Service

120000

When you select a product onto a contract line, the product's unbilled AR account information is stored on the contract line as a part of the contract line's accounting distribution. This ensures that the unbilled AR account information existing for a product at the time it was selected onto a contract line does not change, even if the unbilled AR information defined at the business unit or product group level is subsequently changed.

Rate-based Contract Lines

For rate-based contract lines, the unbilled AR is stored in two places to be used in these ways:

Note. It is recommended that the setup for unbilled AR in the accounting rules and on the Accounting Distribution page be the same for rate-based activity to avoid accounting discrepancies. If two unbilled AR distributions are used, the user must balance the two by making adjustments on the Revenue and Billing Reconciliation page.

Click to jump to parent topicAccounting Distributions for Discounts and Surcharges

When you define discounts and surcharges, you have the option of associating the discount or surcharge with a distribution code. When you add a discount or surcharge to a contract line with a price type of Amount or Percent, the system creates accounting distribution lines for the discount or surcharge amount on the Accounting Distributions Discounts page. The discount revenue distribution code that you specified populates as a default value. If you did not specify a distribution code, you must access the Accounting Distributions Discounts page. You may choose the same distribution as the contract line or manually enter the revenue accounting distribution for the discount or surcharge. The unbilled receivable and deferred revenue accounting distributions are obtained from the contract line with which the discount or surcharge is associated.

The PeopleSoft General Ledger business unit populated into the discount accounting distribution is the same as that which is populated by default to the contract line accounting distribution. If you change the PeopleSoft General Ledger business unit for the discount revenue accounting distribution, the system generates interunit entries when the Accounting process runs.

After you associate discounts or surcharges with a contract line and save the Amount Allocation page, the system runs combination editing to verify that the revenue distribution that you entered for the discount or surcharge is valid.

For contract lines with a price type of rate, enter discounts on the Related Projects page.

For contract lines with a price type of recurring, the system does not allow discounts and surcharges.

Note. For information on accounting distributions for discounts and surcharges on renewable contract lines, see the “Understanding Discounts and Surcharges for Renewable Contract Lines” section of the Entering Renewals chapter.

See Also

Reviewing and Updating Accounting Distributions for Discounts and Surcharges

Working with PeopleSoft Project Costing

Understanding Discounts and Surcharges for Renewable Contract Lines

Click to jump to parent topicAccounting Distributions for Interunit Transfers

When you define a PeopleSoft Contracts business unit, you associate it with a PeopleSoft General Ledger business unit. When you select a product onto a contract line, the system populates the Accounting Distribution page with the distribution code that you defined for that product. The system also populates the GL Unit field for that contract line with the PeopleSoft General Ledger business unit that you defined for that PeopleSoft Contracts business unit. For contract lines where PeopleSoft Billing manages revenue, the GL Unit field is not editable. When PeopleSoft Contracts manages revenue for a contract line, you can change the PeopleSoft General Ledger business unit on an accounting distribution line to a PeopleSoft General Ledger business unit different from the one associated with the PeopleSoft Contracts business unit. When you do this, the system generates interunit transfer entries. Interunit transfers enable you to specify revenue to be booked to a PeopleSoft General Ledger business unit that is different from the one originally defined on the contract.

Note. Interunit transfers are enabled only for revenue line distributions; they are not enabled for the unbilled AR and deferred revenue entries. The system does not book any balance sheet entries to a PeopleSoft General Ledger business unit other than the one to which the contract’s PeopleSoft Contracts business unit is linked.

Click to jump to top of pageClick to jump to parent topicSetting Up Interunit Transfers for Fixed-Amount Contract Lines

You can perform interunit transfers for fixed-amount contract lines by editing the PeopleSoft General Ledger business unit for a contract line’s revenue distribution rows on the Accounting Distribution page. When you save the Accounting Distribution page, the system performs ChartField edit combinations to check that the ChartFields that you entered are valid for the PeopleSoft General Ledger business unit that you specified for a particular distribution row.

When you run the Amount-based Revenue process, the system looks for revenue distributions where the PeopleSoft General Ledger business unit value differs from the contract’s PeopleSoft General Ledger business unit (which is identified by the PeopleSoft Contracts business unit). For each row where a difference exists, the system creates two additional rows of distribution in the CA_ACCTG_LINE table, where the rows are picked up and sent to the GL when you run the Journal Generator process. The PeopleSoft General Ledger tables that these rows are written to depend upon these factors:

The system does not store these interunit entries in the PeopleSoft Contracts historical tables (CA_AP_DST, CA_AP_DFR, and CA_AP_UAR) because each revenue distribution row reflects the PeopleSoft General Ledger business unit to which the entry was made. Entries that the system makes to the GL are always to the primary ledger of the target PeopleSoft General Ledger business unit.

If the transfer is between PeopleSoft General Ledger business units that use different currencies, the system performs the currency conversions on the interunit entries by using the rate type and GL currency exchange rates from the translated amount.

The Amount-based Revenue process verifies that the accounting entries are in balance both before and after the transfer.

See Also

Using Inter/Intraunit Processing in General Ledger

Click to jump to top of pageClick to jump to parent topicExample 1: Interunit Accounting Without Deferred Revenue

The following example examines the entries generated by PeopleSoft Contracts when PeopleSoft Contracts manages revenue for a fixed-amount contract line. In this example, the user did not enable deferred revenue recognition at the either the contract line or product group level.

First, establish a new contract with these parameters:

Field Name

Value

Comments

Contract Number.

9999999

 

Contracts business unit.

USA1

 

General Ledger business unit that is mapped to the Contracts business unit.

123

The base currency for this PeopleSoft General Ledger business unit is USD.

All balance sheet entries are managed on the PeopleSoft General Ledger business unit 123’s books, including: deferred revenue, unbilled AR or inventory, and billed AR

Billing business unit.

 

All billing plans within the contract must be mapped to PeopleSoft Billing business units that are associated with PeopleSoft General Ledger business unit 123.

Contract gross amount/currency code.

100,000/DEM

The contract was signed on January 1999, but no accounting is booked until there is activity against the contract.

Contract/Billing currency.

DEM

 

To perform interunit accounting without deferred revenue, you:

  1. Bill for the total contract amount.

    PeopleSoft Contracts sends the billing information to PeopleSoft Billing, and PeopleSoft Billing books accounting entries upon finalization of invoice. The accounting month for the bill finalization is February 1999. In February 1999, the contract total in the currency of the primary PeopleSoft General Ledger business unit (GLBU 123) equals DEM 100,000 @ 2/99 rate .580930 = USD 58,093.00.

  2. Indicate that revenue should be recognized.

    On the Accounting Distribution page you have split the revenue between two PeopleSoft General Ledger business units: 50 percent for GLBU 123 and 50 percent to GLBU XYZ. The currency code for GLBU XYZ is in CAD. The accounting month for this transaction is May 1999. The contract total in the currency of GLBU 123 = DEM 100,000 @ 5/99 rate .540435 = USD 54,043.50.

    You run the Amount-based Revenue process to generate the revenue entry and its associated interunit transfer from GLBU 123 to GLBU XYZ, and the system uses GLBU 123’s currency as the base currency code for the transfer: USD 54,043.50 * 50% = USD 27,021.75 @ 5/99 rate (USD/CAD) 1.4565 = CAD 39,357.18.

  3. Harmonize the unbilled AR in PeopleSoft General Ledger by using PeopleSoft General Ledger functionality for balances with foreign and base amounts with differing currencies.

    To enable this functionality, the Amount-based Revenue process and PeopleSoft Billing populate the foreign amount field with the DEM value of 100,000.

    Revaluation in PeopleSoft General Ledger compares the May 1999 balances for both amount fields and translates at the current rate of .540435. The system compares the foreign amount = 0 (DEM 100,000 − DEM 100,000) at .540435 = 0 to the base amount = (USD 4049.50), then generates a reduction entry crediting foreign exchange gain or loss and debiting unbilled AR (in this scenario) for the difference = USD 4049.50.

Interunit accounting distribution flows

Click to jump to top of pageClick to jump to parent topicExample 2: Interunit Accounting with Deferred Revenue

The following example examines the entries generated by PeopleSoft Contracts when PeopleSoft Contracts manages revenue for a fixed-amount contract line. In this example, the user enabled deferred revenue recognition at the either the contract line or product group level.

First, establish a new contract with these parameters:

Field Name

Value

Comments

Contract Number.

9999999

 

Contracts business unit.

USA1

 

General Ledger business unit that is mapped to the Contracts business unit.

123

The currency for this PeopleSoft General Ledger business unit is USD.

All balance sheet entries are managed on PeopleSoft General Ledger business unit 123’s books, including: deferred revenue, unbilled AR or inventory, and billed AR.

Billing business unit.

 

All billing plans within the contract must be mapped to Billing business units that are associated with PeopleSoft General Ledger business unit 123.

Contract gross amount/currency code.

100,000/DEM

The contract was signed on January 1999, but no accounting is booked until there is activity against the contract.

Billing currency.

DEM

 

To perform interunit accounting with deferred revenue, you:

  1. Run the Deferred Revenue process for the accounting month January 1999 to book entries to the balance sheet: DEM 100,000 @ 1/99 rate .599018 = USD 59,901.80.

  2. Bill for the total contract amount.

    PeopleSoft Contracts sends the billing information to PeopleSoft Billing; the system books accounting entries upon finalization of invoice. The accounting month for the bill finalization is February 1999. In February 1999, the contract total in the currency of the primary PeopleSoft General Ledger business unit (GLBU 123) = DEM 100,000 @ 2/99 rate .580930 = USD 58,093.00.

  3. True-up unbilled AR in PeopleSoft General Ledger by using PeopleSoft General Ledger functionality for balances and base amounts with foreign and differing currencies.

    To enable this functionality, the Amount-based Revenue process and PeopleSoft Billing populate the Foreign Amount field with the DEM value of DEM 100,000.

    Revaluation in PeopleSoft General Ledger compares February 1999 balances for both amount fields and translates at the current rate of .580930. The system compares the foreign amount = 0 (DEM 100,000 − DEM 100,000) at .580930 = 0 to the base amount = (USD 1,808.80), then generates a reduction entry crediting foreign exchange gain or loss and debiting unbilled AR (in this scenario) for the difference = 1,808.80.

  4. Indicate that revenue should be recognized.

    On the Accounting Distribution page, you have split the revenue between two PeopleSoft General Ledger business units: 50 percent to GLBU 123 and 50 percent to GLBU XYZ. The currency code for GLBU XYZ is in CAD. The accounting month for this transaction is May 1999.

    When you run the Amount-based Revenue process, the system generates the entry for the interunit transfer from GLBU 123 to GLBU XYZ. The system uses GLBU 123’s currency as the base currency code for the transfer: USD 59,901.80 * 50% = USD 29,950.90 @ 5/99 rate (USD/CAD) 1.4565 = CAD 43,623.49.

Click to jump to top of pageClick to jump to parent topicSetting Up Interunit Transfers for Rate-based Contract Lines

You set up the revenue distribution and offsetting unbilled AR account for rate-based contract lines on the Accounting Rules page. If the PeopleSoft General Ledger business unit for the debit side of a transaction is different from the PeopleSoft General Ledger business unit for the credit side of a transaction, the system generates interunit entries when you run the rate-based revenue process (Accounting Rules Engine - PSA_ACCTGGL). The system performs conversion of amounts for currency differences in the current accounting month. For rate-based contract lines with a value-based billing method, the Accounting Distribution page displays the unbilled AR account information. PeopleSoft Contracts does not associate deferred revenue for rate-based contract lines.

Click to jump to parent topicProducts Managing Revenue

You can recognize revenue associated with a contract either through PeopleSoft Contracts or PeopleSoft Billing. You designate which product manages revenue for each individual contract line. By using PeopleSoft Contracts as the default product to manage contract revenue, you have a higher degree of flexibility and control in managing your revenue. By selecting PeopleSoft Billing as the default product to manage contract revenue, you can speed up contract entry by only entering minimal contract information into the system, and recognizing the revenue through PeopleSoft Billing at the time the bills are finalized. However, when you do this, you lose many revenue management and tracking features that would be available if you were using the default, PeopleSoft Contracts, as the product to manage revenue.

When you define products in PeopleSoft Contracts, you specify the revenue recognition method for that product. The revenue recognition method appears by default to the contract line and may or may not be overwritten depending on system setup. When you select a revenue recognition method of apportionment, milestone, or percent complete, PeopleSoft Contracts manages the flow of revenue. When you select billing manages revenue as the revenue recognition method, PeopleSoft Billing manages the flow of revenue.

This section discusses:

Click to jump to top of pageClick to jump to parent topicAccounting Entries in PeopleSoft Contracts

When you set up a contract, you associate that contract with a PeopleSoft Contracts business unit. The PeopleSoft Contracts business unit is associated with a PeopleSoft General Ledger business unit; associating a PeopleSoft Contracts business unit with a PeopleSoft General Ledger business unit is a required step in the PeopleSoft Contracts business unit setup. A contract derives its PeopleSoft General Ledger business unit from its PeopleSoft Contracts business unit.

When you select a product onto a contract line, the system writes the distribution codes for that contract line to the line's accounting distribution definition. Distribution codes do not include the PeopleSoft General Ledger business unit. The contract's General Ledger business unit appears by default on the contract line's accounting distributions. You can change the PeopleSoft General Ledger business unit on the revenue accounting distribution. If the line’s General Ledger business unit differs from the contract’s General Ledger business unit, the system generates interunit accounting entries. However, the PeopleSoft General Ledger business unit for the deferred revenue and unbilled AR accounting distributions must be the same as the PeopleSoft General Ledger business unit associated with a PeopleSoft Contracts business unit.

Click to jump to top of pageClick to jump to parent topicAccounting Entries in PeopleSoft Billing

You associate each contract line with a billing plan. You associate each billing plan with a PeopleSoft Billing business unit; the system limits the valid PeopleSoft Billing business units to those that share the same PeopleSoft General Ledger business unit as the contract’s PeopleSoft Contracts business unit.

When the system generates billing activity for a billing plan, each bill row sent to PeopleSoft Billing is associated with its billing plan’s PeopleSoft Billing business unit. PeopleSoft Billing then generates accounting entries based on the PeopleSoft General Ledger business unit that is mapped to the bill row’s PeopleSoft Billing business unit. Because the system has enforced the rule that the PeopleSoft Billing business unit must share the PeopleSoft General Ledger business unit with the PeopleSoft Contracts business unit, the accounting entry that is made by PeopleSoft Billing for this bill row hits the same PeopleSoft General Ledger business unit as the accounting entry that was made by PeopleSoft Contracts for this contract line. No interunit entries are generated for accounting done from PeopleSoft Billing as it relates to PeopleSoft Contracts activity. Thus, if a contract line is designated for PeopleSoft Billing to manage revenue, the PeopleSoft General Ledger business unit is unavailable on the revenue accounting distribution for that contract line.

Click to jump to top of pageClick to jump to parent topicAccounting Distributions When PeopleSoft Contracts Manages Revenue

Use PeopleSoft Contracts to manage revenue when you want to book revenue on a different schedule (or under different rules) than when you bill for that contract line. The flow of accounting entries for fixed-amount contract lines depends upon whether you select to book contract revenue to deferred revenue.

Accounting Distributions for Fixed-Amount Contract Lines with Deferred Revenue Entries

After a contract has been activated, the Deferred Revenue process creates the following accounting entry for each active fixed-amount and percent-based contract line:

Account

Debit

Credit

Unbilled AR Account

100

 

Deferred Revenue Account

 

100

Note. The Deferred Revenue process picks up all active fixed-amount contract lines with deferred revenue enabled on an active contract, regardless of whether you have associated these contract lines with a revenue plan.

Once the contract line is assigned to a revenue plan and the plan contains a ready event, the Amount-based Revenue process creates the following accounting entry, moving the USD 100 from deferred to real revenue:

Account

Debit

Credit

Deferred Revenue Account

100

 

Revenue Account

 

100

Once the contract line is assigned to a billing plan and the plan contains a ready event (in the case of milestone and percent complete plans), the CA_BI_INTFC process sends the unbilled AR accounting distribution associated with the contract line to PeopleSoft Billing. PeopleSoft Billing creates the following accounting entry, moving the USD 100 from Unbilled AR to Billed AR:

Account

Debit

Credit

AR Account

100

 

Unbilled AR Account

 

100

The final step in the process is to collect cash for your outstanding invoices. Once cash is received, the following entry is made in PeopleSoft Receivables, moving the USD 100 from Billed AR to Cash:

Account

Debit

Credit

Cash Account

100

 

AR Account

 

100

Accounting Distributions for Rate-based Contract Lines and Fixed-Amount Contract Lines with No Deferred Revenue Entries

Once an active contract line on an active contract is assigned to a revenue plan and the plan contains a ready event (optional in the case of as-incurred plans), the amount-based or rate-based revenue process creates the following accounting entry:

Account

Debit

Credit

Unbilled AR Account

100

 

Revenue Account

 

100

Once the contract line is assigned to a billing plan and the plan contains a ready event (optional in the case of as-incurred plans), the CA_BI_INTFC process sends the unbilled AR accounting distribution associated with the contract line to PeopleSoft Billing. PeopleSoft Billing creates the following accounting entry, moving the USD 100 from Unbilled AR to Billed AR:

Account

Debit

Credit

AR Account

100

 

Unbilled AR Account

 

100

The final step in the process is to collect cash for outstanding invoices. Once cash is received, the following entry is made in PeopleSoft Receivables, moving the USD 100 from Billed AR to Cash:

Account

Debit

Credit

Cash Account

100

 

AR Account

 

100

Click to jump to top of pageClick to jump to parent topicAccounting Distributions When PeopleSoft Billing Manages Revenue

When PeopleSoft Billing manages revenue recognition for fixed-amount or recurring contract lines, PeopleSoft Contracts does not make any accounting entries. Revenue recognition for a contract line occurs upon booking the entries to PeopleSoft General Ledger after the bill finalization. Billing and revenue recognition occur at the same time.

Accounting Distributions for Fixed-Amount and Recurring Contract Lines with No Deferred Revenue Entries

Once an active contract line on an active contract is assigned to a billing plan and the plan contains a ready event (in the case of milestone and percent complete plans), the CA_BI_INTFC process sends the revenue accounting distribution associated with the contract line to PeopleSoft Billing. PeopleSoft Billing creates the following accounting entry, booking revenue, and billed AR simultaneously:

Account

Debit

Credit

AR Account

100

 

Revenue Account

 

100

The final step in the process is to collect cash for outstanding invoices. Once cash is received, the following entry is made in PeopleSoft Receivables, moving the $100 from AR Account to Cash:

Account

Debit

Credit

Cash Account

100

 

AR Account

 

100

Accounting Distributions for Recurring Contract Lines with Deferred Revenue Entries

In the following example for deferred revenue, the bill for service during the month of September is sent out in August. However, the revenue is recognized in September.

The bill for service is sent out during the month of August:

Account

Debit

Credit

AR Account

100

 

Deferred Revenue Account

 

100

Revenue is recognized in September:

Account

Debit

Credit

Deferred Revenue Account

100

 

Revenue Account

 

100

Click to jump to top of pageClick to jump to parent topicAccounting Distribution Source

When the system prepares billing activity for the PeopleSoft Billing Interface tables, the process needs to know what distribution entries need to be created for each bill line. In the case of fixed-amount billing, the source of accounting information depends on the product (PeopleSoft Contracts or PeopleSoft Billing) that is managing revenue for the bill line. In the case of rate-based billing, the source of accounting information is always the same because PeopleSoft Contracts always manages the revenue. In the case of recurring billing, the source of accounting information is always the same because PeopleSoft Billing always manages the revenue.

This table lists accounting scenarios:

Source of Accounting Entries

Scenario #1: Deferred Revenue (revenue managed from Contracts)

Scenario #2: Unbilled AR Without Deferred Revenue (revenue managed from Contracts)

Scenario #3: Unbilled AR Without Deferred Revenue (revenue managed from Billing)

Amount-based contract lines

Scenario #4: Deferred Revenue (revenue managed from Billing)

Recurring contract lines

Entries created by deferred revenue process in PeopleSoft Contracts.

DB Unbilled AR

CR Deferred Revenue

None

None

None

Entries created by revenue management in PeopleSoft Contracts.

DB Deferred Revenue

CR Revenue

DB Unbilled AR

CR Revenue

None

None

Entries created by PeopleSoft Billing upon the generation of the invoice.

DB Billed AR

CR Unbilled AR

DB Billed AR

CR Unbilled AR

DB Billed AR

CR Revenue

DB Billed AR

CR Deferred Revenue

DB Deferred Revenue

CR Revenue

Note. It is recommended that you do not use PeopleSoft Billing for deferred contract revenue except in the case of recurring contract lines. For recurring contract lines, PeopleSoft Billing manages revenue and handles all deferred revenue processing. The information sent to PeopleSoft Billing for rate-based contract lines is always the same.

When PeopleSoft Contracts Manages Revenue

Fixed-amount billing methods derive the unbilled AR account from the CA_DETAIL_UAR table. In addition, as-incurred contract lines with the value-based billing method derive the unbilled AR account from the CA_DETAIL_UAR table. Although the unbilled AR distribution for each contract line is stored in this table, it may appear by default from the product group and/or the PeopleSoft Contracts business unit associated with the contract. This enables you to maintain unbilled AR accounting distribution data consistently for a particular PeopleSoft Contracts business unit or populate it by default consistently from the product group associated with the products. You may override the unbilled AR accounting distribution information on the Accounting Distribution page for each contract line.

Note. As-incurred contract lines not using the value-based billing method derive their unbilled AR distribution from accounting rules on the As-Incurred Accounting Distribution page.

When PeopleSoft Billing Manages Revenue

Only the fixed-amount billing methods (Milestone, % Complete, and Immediate) and the recurring billing method may be associated with contract lines that allow PeopleSoft Billing to manage revenue. The revenue distribution in these cases is stored in CA_DETAIL_DST. Each contract line has one or more accounting distribution lines associated with it. You can set up this information for each product in the product table by using distribution codes and distribution sets. The distribution for the product appears by default in the CA_DETAIL_DST table when you select the product onto a contract line. You can then override part or all of the revenue accounting distribution manually.

Deferred Revenue When PeopleSoft Billing Manages Revenue

The Billing Interface allows interfacing systems to define bill lines in a manner that qualifies them for deferred revenue processing within PeopleSoft Billing. The deferred revenue flag on the contract line defines whether or not deferred revenue processing is active in the Billing Load to GL process. If the option is inactive, this processing does not occur. This does not affect the Contracts Billing Interface process. If this option is active, it enables you to use the deferred revenue functionality in PeopleSoft Billing. Note that this deferred revenue isn't reflected in the PeopleSoft Contracts revenue management pages.

Note. When PeopleSoft Contracts manages revenue recognition, the revenue recognition basis is passed to the billing interface as INV (INTFC_BI.REV_RECOG basis = ‘INV’ Invoice date)—excluding these lines from deferred processing in PeopleSoft Billing.

Note. When PeopleSoft Billing manages revenue for recurring contract lines with deferred revenue, PeopleSoft Contracts sends the revenue recognition basis to the billing interface and populates the CHARGE_FROM_DT and CHARGE_TO_DATES.