Using the Projects Reconciliation Workbench

Projects Recon Workbench - Projects Page

PC_TIP_GROUP

Search for and review all Project Costing transactions not costed or priced for a project or specific project activity, and all unbilled transactions for the period when the project was inactive.

Projects Reconciliation Workbench - Billing Page

PC_TIP_GROUP_BI

Search for and review billing transactions in progress for a project or specific project activity.

Projects Reconciliation Workbench - Budgets Page

PC_TIP_GROUP_BD

Search for and review unposted project budgets, budgets not distributed to PeopleSoft Commitment Control, or budgets not distributed to PeopleSoft Project Costing for a project or specified project activity.

Projects Reconciliation Workbench - Contracts Page

PC_TIP_GROUP_CA

Search for and review any activities that are not assigned to a contract line that are sourced from PeopleSoft Grants, PeopleSoft Project Costing, or both for a project.

Projects Reconciliation Workbench - Expenses Page

PC_TIP_GROUP_EX

Review PeopleSoft Expenses transactions in progress for a project or specified activity.

Projects Reconciliation Workbench - Grants F & A (facilities and administration) Page

PC_TIP_GROUP_FA

Search for and review Grants F & A transactions in progress for a project or specified project activity.

Projects Reconciliation Workbench - General Ledger Pager

PC_TIP_GROUP_GL

Search for and review journal transactions in progress for a project or specified project activity.

Projects Reconciliation Workbench - Inventory Page

PC_TIP_GROUP_IN

Search for and review Inventory transactions in progress for a project or specified project activity.

Projects Reconciliation Workbench - Purchasing Page

PC_TIP_GROUP_PO

Search for and review purchase orders and requisitions in progress, unsourced purchase orders and requisitions in selected states for a project, or a specified project activity.

Projects Reconciliation Workbench - Payables Page

PC_TIP_GROUP_AP

Search for and review Payables transactions in progress, unpaid vouchers already distributed to Project Costing based on a selected payment method for a project, or a specified project activity.

Projects Reconciliation Workbench - Receivables Page

PC_TIP_GROUP_AR

Search for and review Receivables transactions in progress for a project or a specified project activity.

Reconciliation ID (reconciliation identification)

Enter an ID for this Projects Reconciliation Workbench that represents a project scenario such as End of Month Close on the Projects Recon Workbench - Add a New Value page.

Business Unit

Enter or select the Project Costing business unit associated with the project that has the transactions in progress that you want to review by clicking the Lookup icon on the Projects Recon Workbench - Add a New Value page

Project

Enter or select the project that has the transactions in progress that you want to review by clicking the Lookup icon on the Projects Recon Workbench - Add a New Value page.

Billing Transactions in Progress

Select this check box and click the Search button to display any PeopleSoft Billing transactions in progress for this project or this project's activity in the Billing Transactions in Progress grid.

Click the Save button to save the search criteria on this page.

Click the Detail icon in a row on the grid to drill down to the source transaction.

Unposted Project Budget

Select this option and click the Search button to display all unposted budget transactions associated with the selected project or the project's selected activity in the Budgets Transactions in Progress grid.

Budgets not distributed to KK (budgets not distributed to Commitment Control)

Select this option and click the Search button to display all budget transactions that have not been distributed to Commitment Control and are associated with the selected project or the project's selected activity in the Budgets Transactions in Progress grid.

Budgets not distributed to PC(budgets not distributed to Project Costing)

Select this option and click the Search button to display all budget transactions that have not been distributed to PeopleSoft Project Costing and are associated with the selected project or project's selected activity in the Budgets Transactions in Progress grid.

Click the Save button to save the Search criteria.

Click the Detail icon in a row to drill down to the transaction's source.

Project Source

Select the source of a project that has activities that are not assigned to a contract line. Values are:

• All

• GM (Grants Management)

• PC (Project Costing)

  The project is sourced from PeopleSoft Project Costing.

Activities not assigned to Contract Line

Select to display any activities associated with the project that are not assigned to a contract line based on the selected source. If you selected one activity on the Projects Reconciliation Workbench - Projects page, then only the selected activity appears if it is not assigned to the contract line.

Click the Save button to save the search criteria.

Expenses Transactions in Progress

Select this check box and click the Search button to display any PeopleSoft Expenses transactions in progress associated with the project or the project's selected activity in the Expenses Transactions in Progress grid.

Click the Save button to save the search criteria.

Click the Details icon in a row to drill down to the source expenses transaction.

Approved Time Transactions in Progress

Select this check box and click the Search button to display any PeopleSoft Expenses-approved time transactions in progress associated with the selected project or the project's selected activity in the Approved Time Transactions in Progress grid.

Click the Save button to save the search criteria.

Click the Details icon in a row to drill down to the source approved time transaction.

F & A Transactions in Progress(facilities and administration transactions in progress)

Select this check box and click the Search button to display PeopleSoft Grants facilities and administration transactions in progress associated with the selected project or the project's selected activity in the F & A Transactions in Progress grid.

Click the Save button to save the search criteria.

Click the Detail icon in a row to drill down to the source F & A transaction.

Journal Transactions in Progress

Select this check box and click the Search button to display PeopleSoft General Ledger journal transactions in progress for the selected project or the project's selected activity in the Journal Transactions in Progress grid.

Click the Save button to save the search criteria.

Click the Detail icon in a row to drill down to the journal source transaction.

Inventory Transactions in Progress

Select this check box and click the Search button to display PeopleSoft Inventory transactions in progress for the selected project or the project's selected activity in the Inventory Transactions in Progress grid.

Click the Save button to save the search criteria.

Click the Detail icon in a row to drill down to the Inventory source transaction.

Purchase Orders in Progress

Select this check box and select the Search button to display PeopleSoft Purchasing purchase orders in progress in the Purchase Orders in Progress grid for the selected project or the project's selected activity for this project.

If you do not select this check box, the system does not display any of these purchase orders in progress.

Click the Save button to save the search criteria.

Click the Detail icon in a row to drill down to the purchase order.

Unsourced Purchase Orders

Select this check box and select one or more of these purchase-order status check boxes:

• Closed

• Mass Liquidated

• Open

• Unavailable for Sourcing

• Canceled

Select the Search button to display PeopleSoft Purchasing unsourced purchase orders with one or more selected statuses in the Unsourced Purchase Orders grid for the selected project or the project's selected activity.

If you do not select any of the status check boxes, the system does not display any unsourced purchase orders.

Click the Save button to save the search criteria.

Click the Detail icon in a row to drill down to the unsourced purchase order.

Requisitions in Progress

Select this check box and select the Search button to display PeopleSoft Purchasing requisitions in progress in the Requisitions in Progress grid for the selected project or the project's selected activity.

If you do not select this check box, the system does not display any requisitions in progress.

Click the Save button to save the search criteria.

Click the Detail icon in a row to drill down to the requisition in progress.

Unsourced Requisitions

Click this check box and select one or more of these requisition status check boxes:

• Closed

• Mass Liquidated

• Open

• Unavailable for Sourcing

• Canceled

Select the Search button to display PeopleSoft Purchasing unsourced requisitions in progress with one or more selected statuses in the Unsourced Requisitions grid for the selected project or the project's selected activity.

If you do not select any of these check boxes, the system does not display any of these requisition statuses.

Click the Save button to save the search criteria.

Click the Detail icon in a row to drill down to the unsourced requisition.

Payables Transactions in Progress

Select this check box and click the Search button to display PeopleSoft Payables transactions in progress for the selected project or the project's selected activity in the Payables Transactions in Progress grid.

Click the Details icon in a row to drill down to the Payables transaction.

Unpaid vouchers distributed to PC (unpaid vouchers distributed to Project Costing)

Select this check box and click the Search button to display PeopleSoft Payables unpaid vouchers that have been distributed to PeopleSoft Project Costing for the selected project or the project's selected activity for this project in the Payables Unpaid vouchers distributed to PC grid.

If you select the Unpaid vouchers distributed to PC check box, the Method of Payment field is enabled. This field is enabled only if PeopleSoft Contracts is installed.

Method of Payment

If the contract was created based on an award generated in PeopleSoft Grants, then PeopleSoft Grants writes the required award information to PeopleSoft Contracts. This process creates a contract, adds a contract line to the contract, associates PeopleSoft Grants projects and activities with the contract line, and creates billing and revenue recognition plans. Due to this integration with PeopleSoft Contracts, you can generate bills and recognize revenue for all transactions that are associated with your sponsored awards. You can set up Billing defaults on the Billing Options page for the contract. If the contract is associated with an award from PeopleSoft Grants, you can select Cost Reimbursable or Letter of Credit as the default method of payment for the award on the Billing Options page of the contract.

Select one of the following options if you selected the Unpaid vouchers distributed to PC check box:

• Blank

  Selecting a blank field value displays all of the unpaid vouchers distributed to PeopleSoft Project Costing in the grid.

• LOC (letter of credit)

  Selecting this option indicates a letter of credit was identified as the method of payment on the Billing Options page of the contract that will be used to pay out the award to the award's recipient based on the terms of a contract and the award. The system bills the sponsor that holds the letter of credit, the sponsor creates a voucher in PeopleSoft Payables, and the project and activity associated with the contract are updated in PeopleSoft Project Costing with unpaid voucher transactions in progress.

  See Letter of Credit Processing.

• Cost Reimbursable

  Select this method as part of establishing a bill schedule to use 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.

  See Scheduled Billing.

Click the Save button to save the search criteria.

Click the Details icon to drill down to the unpaid voucher.

Receivables Transactions in Progress

Select this check box and click the Search button to display PeopleSoft Receivables transactions in progress in the Receivables Transactions in Progress grid for the selected project or the project's selected activity.

Click the Save button to save the search criteria.