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.

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 > Reports > Bank Account Listing

RUN_FIN0056

FSX3000

Bank Statement Register

Lists all transactions in an electronic bank statement.

Banking > Bank Statements > Review Bank Statement

Banking > Reconcile Statements > 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 > Reconcile Statements > 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 > Reconcile Statements > Automatic Reconciliation and select Errors in the Reports field.

BNK_RCN_CYC_STSA

FSX3004

Account Register

Lists reconciled and unreconciled system transactions.

Banking > Reports > Account Register

RUN_FIN3004

FSX4004

Manual Account Register

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

Banking > Reconcile Statements > Schedule ID Reconciliation

Banking > Reconcile Statements > Reverse Schedule ID Recon

Banking > Analyzing Exceptions > Transactions by Account

Banking > Reconcile Statements > 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 > Reports > 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 > 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 > Reconcile Statements > Book to Bank Reconciliation and click Detail. Click Report on the Book to Bank Reconciliation Details page.

BNK_BTB_HDR