Scheduled Billing

A bill schedule is usually established when reimbursement from the sponsor is based on clinical trials or deliverables instead of specific actual expenses. The sponsor usually outlines the bill schedule in the award document. Instead of using feeder systems to add transactions to the Project Resource table (PROJ_RESOURCE), you use the Add Transactions page in PeopleSoft Project Costing to add scheduled bill lines directly to the Project Resource table.

Here are the steps to creating a bill schedule:

Step Navigation

Define an analysis type to represent scheduled bill rows (for example, SCH).

Setup Financials/Supply Chain, and then Product Related, and then Project Costing, and then Transaction Options, and then Analysis Types

Associate the analysis type with an analysis group (for example, All).

Setup Financials/Supply Chain, and then Product Related, and then Project Costing, and then Transaction Options, and then Analysis Groups

Map the analysis type to the PSWKS analysis group.

Note: PSWKS is the analysis group that the system uses for the billing process. The system will not bill the rows without this association.

Setup Financials/Supply Chain, and then Product Related, and then Project Costing, and then Transaction Options, and then Analysis Groups

Create a rate set or rate plan for your schedule analysis type.

Note: This is an important step. To create BIL rows, you need to price the scheduled bill transactions that you create on the Add Transactions page. The rate set or rate plan is required for this purpose. Also, to limit the system from processing all transactions rows that populate the Add Transactions page, you must define a special rate set or rate plan that processes only scheduled bill rows. This ensures that only scheduled bill rows are used to create an invoice.

Setup Financials/Supply Chain, and then Product Related, and then Project Costing, and then Pricing Structure, and then Rate Set

AND

Setup Financials/Supply Chain, Product Related, Project Costing, Pricing Structure, Rate Plan

Generate your award in PeopleSoft Grants.

Grants, and then Proposals, and then Generate Award

In PeopleSoft Contracts, make sure the contract is set to process scheduled bills:

  • Associate the bill schedule rate set or rate plan with your contract before you process billing

  • Make sure the Method of Payment field on the Billing Options page is set to the Cost Reimbursable billing method.

Customer Contracts, and then Create and Amend, and then General Information, and then Billing Plan

AND

Customer Contracts, and then Create and Amend, and then General Information, and then Billing Options

Enter the scheduled bill rows into the Add Transactions page and apply the transactions to the Project Resources table by clicking the Process Transactions button.

Project Costing, and then Transaction Definitions, and then Add Transactions

Run the Pricing Engine in PeopleSoft Project Costing.

Project Costing, and then Cost Collection

Then select Expenses, General Ledger, Inventory, Order Management, Payables, Purchasing, Purchasing Adjustment, Time and Labor, or Services Procurement.

Instructions on using analysis types, creating rate sets and rate plans, adding transactions, and running the pricing engine appear in the PeopleSoft Project Costing documentation. Instructions on associating rate sets and rate plans with contracts and setting billing options appear in the PeopleSoft Contracts documentation.