Managing Federal Schedule ID Reconciliations

This topic discusses how to reconcile vouchers by using Treasury payment information that is obtained from the Government Online Accounting Link System - Regional Finance Center Agency Link (GOALS - RFCAL) website and undo previously reconciled schedule ID payments, if desired.

Page Name

Definition Name

Usage

Schedule ID Reconciliation Page

BNK_RCN_MAN_TRE

Reconcile a series of federal schedule ID payments.

Run the Account Register report (FSX4004). Use the report to view a list of reconciled or unreconciled Federal Schedule ID payments.

Reverse Schedule ID Recon Page

BNK_RCN_MAN_TRE

Reverse reconcile any schedule ID payments reconciled in error.

Run the Account Register report (FSX4004). Use the report to view a list of reconciled or unreconciled Federal Schedule ID payments.

The U.S. Federal Government requires its agencies to group together vouchers with similar characteristics for payment. You assign each group of vouchers a common schedule ID as an identifier and then submit them to the U.S. Treasury for payment. After the Treasury Disbursement Office (TDO) sends notification that the vouchers are paid, the agencies log into the Government Online Accounting Link System - Regional Finance Center Agency Link (GOALS - RFCAL) for the disbursement information, which is used to reconcile the outstanding vouchers.

The federal payment schedules and federal schedule ID reconciliation functionality are an integration of Payables and Treasury applications. You use the Payables Federal Payment Schedules functionality to:

  • Specify Payables installation and set up options.

  • Create and submit Treasury applications' schedule vouchers to the TDO.

After the Payables information is set up, you use the Treasury applications' federal schedule ID reconciliation function to:

  • Specify bank account set up information.

  • Reconcile transactions by schedule ID after receiving notice that the U.S. Treasury has disbursed the payment.

  • Undo reconciliation of payments that have been reconciled in error.

Before you reconcile federal payments, you must perform the following tasks:

  • Specify an agency location code to identify the correct TDO for a bank on the Bank Information page.

  • Select the Payment Schedule option on the Payment Methods page to direct generation of prenotification files for a specified bank account.

  • Select the Prenote Required option on the Prenotification page to generate a prenotification notice for the bank account.

Field or Control

Description

Schedule ID

A code that identifies vouchers that are grouped together with the similar characteristics such as agency location code, schedule type, and payment method. Vouchers that are grouped and assigned to a schedule ID are submitted to the TDO for payment.

Account Register Report

Click to run a report of reconciled or unreconciled federal schedule ID payments.

Use the Schedule ID Reconciliation page (BNK_RCN_MAN_TRE) to reconcile a series of federal schedule ID payments.

Run the Account Register report (FSX4004). Use the report to view a list of reconciled or unreconciled Federal Schedule ID payments.

Navigation:

Banking > Reconcile Statements > Schedule ID Reconciliation

This example illustrates the fields and controls on the Schedule ID Reconciliation page. You can find definitions for the fields and controls later on this page.

 Schedule ID Reconciliation page

Field or Control

Description

Pay Confirm # From and Thru

Enter a range of payment confirmation numbers that are obtained from GOALS - RFCAL.

Assign Confirmation Number icon

Click the Assign Confirmation Number icon to assign a range of schedule ID treasury payment numbers to display unreconciled data.

Sent Date

Enter the date on which you sent the payment to the TDO.

Disbursed Date

Enter the date on which the TDO disbursed the schedule ID payments.

Reconciled Amount

Enter the sum of the payments' amounts that you have assigned in the Pay Confirm # From and Thru fields.

Reconcile

Click to reconcile the unreconciled data with the information you enter. This function also performs various audits and displays error messages as appropriate. If the reconciled amount differs from the sum of the payments' amounts (payments assigned a confirmation number), an error message displays.

When you click reconcile, the system:

  • Updates the Payables Bank Schedule ID table (AP_BANK_SCHED) with three dates: the payment date, the disbursement date, and the date on which the schedule was sent from Payables to PeopleSoft banks.

  • Updates the appropriate Federal payments in Payables with a U.S. Treasury Payment confirmation number.

  • Updates the IPAC Document Reference Number on an IPAC payment with the U.S. Treasury Payment confirmation number, if a bank account is configured for IPAC and uses a payment method of EFT.

Account Register Report

Run the Account Register report.

Use the Reverse Schedule ID Recon (reverse schedule ID reconciliation) page (BNK_RCN_MAN_TRE) to reverse reconcile any schedule ID payments reconciled in error.

Run the Account Register report (FSX4004). Use the report to view a list of reconciled or unreconciled Federal Schedule ID payments.

Navigation:

Banking > Reconcile Statements > Reverse Schedule ID Recon

This page displays reconciled items that match your search criteria.

Select the items that were reconciled in error and click Unreconcile to reverse reconciliation. The item's status changes from REC (reconciled) to UNR (unreconciled). In addition, the system clears the Disbursed Date and Sent Date field values, and the Payment Confirmation Number and IPAC Document Reference Number.

Note: You cannot reverse reconcile payments after running the Cash Clearing process (APCSHCLR).