Bank Reconciliation Reports: A to Z

This table lists the reports that are provided with PeopleSoft banking functionality, sorted alphanumerically by report ID. All are BI Publisher reports, unless noted.

For samples of these reports, see the Report Samples that are published with this online documentation.

Report ID and Report Name Description Navigation Run Control Page

FSX0056

Bank Account Listing

Lists bank accounts by SetID. A description and the account type appears for each account.

Banking, and then Reports, and then Bank Account Listing

RUN_FIN0056

FSX3000

Bank Statement Register

Lists all transactions in an electronic bank statement.

Banking, and then Bank Statements, and then Review Bank Statement

Banking, and then Reconcile Statements, and then Automatic Reconciliation and select Register in the Reports field.

BNK_RCN_STMT_GEN

BNK_RCN_CYC_STSA

FSX3001

Auto Recon Exception

Lists exceptions encountered during an automatic reconciliation. Identifies differences between the bank and system transactions.

See Understanding Reconciliation Exceptions

Banking, and then Reconcile Statements, and then Automatic Reconciliation and select Exceptions in the Reports field.

BNK_RCN_CYC_STSA

FSX3002

Auto Recon Errors

Lists errors encountered during an automatic reconciliation.

See Understanding Reconciliation Exceptions.

Banking, and then Reconcile Statements, and then Automatic Reconciliation and select Errors in the Reports field.

BNK_RCN_CYC_STSA

FSX3004

Account Register

Lists reconciled and unreconciled system transactions.

Banking, and then Reports, and then Account Register

RUN_FIN3004

FSX4004

Manual Account Register

Lists reconciled or unreconciled system transactions, depending on the status set on the page.

Banking, and then Reconcile Statements, and then Schedule ID Reconciliation

Banking, and then Reconcile Statements, and then Reverse Schedule ID Recon

Banking, and then Analyzing Exceptions, and then Transactions by Account

Banking, and then Reconcile Statements, and then Manual Reconciliation and select Reconciled or Unreconciled in the Status field.

BNK_RCN_MAN_TRE

BNK_RCN_ALL_GEN

BNK_RCN_MAN_GEN

TRX1010

Settlement Instructions

Shows settlement instruction information for all settlement IDs of a specific SetID.

Banking, and then Reports, and then Settlement Instructions Detail

RUN_TRC1010

TRX4050

Fee Structures

Shows comprehensive fee structure information for a specified bank code, including the fee description, type, minimum and maximum ranges, and rate and price information.

Banking, and then Account AnalysisFee Structures Report

RUN_TRC4050

TRX4090

Book-to-Bank Reconciliation

Lists book-to-bank reconciliation details for a selected bank account, including adjusted bank statement balance or ledger balance information.

Banking, and then Reconcile Statements, and then Book to Bank Reconciliation and click Detail. Click Report on the Book to Bank Reconciliation Details page.

BNK_BTB_HDR