In this section, we discuss how to:
• Use the Reconciliation Manager.
• Reconcile statements automatically using the Auto Recon Manager.
• Schedule the Bank Reconciliation process (FSPRECON) to resolve statements automatically and to load bank statement data into PeopleSoft Receivables.
• Reconcile statements semi-manually.
• Reconciling statements manually.
Pages Used to Process Reconciliatons
Page Name Object Name Navigation Usage
Reconciliation Manager
BNK_RCN_MGR Banking, Reconcile
Statements, for statements for a single bank.
transactions with those received in a bank file.
The system searches for a one-to-one match.
You can also run various processes and reports from this page
Reconciliation RECON_REQUEST Banking, Reconcile
Statements, Automatic Reconciliation
Create a run control for the Bank
Reconciliation process or the Recon and Bank Stmt multiprocess job (RCNBSP) that runs both the Bank which loads payments into the PeopleSoft Receivables tables.
Page Name Object Name Navigation Usage there isn’t a one-to-one match between your bank and system transactions and you have reconciliation exceptions. Or, reconcile bank statements after entering a hard-copy bank statement online.
Manual Reconciliation BNK_RCN_MAN_GE N
Banking, Reconcile Statements, Manual Reconciliation
Reconcile statements for banks that don’t provide an electronic file of their transaction data.
Using the Reconciliation Manager Access the Reconciliation Manager page.
Reconciliation Manager page
Show Statements for Select Current Month, Last Month, or Today. The page refreshes with the specified information.
Add/Update Accounts Click to add to or update bank accounts.
Add a Bank Account to My List
Click to add more accounts for the selected bank to your My Accounts page.
On the right side of the grid, you see whether reconciliation has been set up for a particular account on the External Account - Account Reconciliation page and what type of reconciliation is in place:
• Manual Reconciliation
• Semi-Manual Reconciliation
• Automatic Reconciliation (AutoRecon Manager)
Click the reconciliation type link to perform reconciliation for the specific bank account.
See Also
“Setting Up Banks and Counterparties,” Viewing and Updating Account Groups Assignments
Using the Auto Recon Manager Access the AutoRecon Manager page.
AutoRecon Manager (automated reconciliation manager) page
Specify the Search Criteria by which to select bank statements for processing. Use wildcard characters to retrieve multiple banks and/or accounts. Click the Search button to display the results in the Bank Statements grid.
Control ID Run Control ID used for the Bank Reconciliation process or the BSP Transaction Loader process (TR_BSP_LOAD).
You must enter an ID before you run the processes.
Bank Statements
The Bank Statements grid displays the bank statements that match your search criteria.
Trans (Transactions Loaded) The number of detail transactions contained in the bank file.
Reconciled The number of detail transactions from the bank statement that have been reconciled with transactions in the system.
This number is 0 until the Bank Reconciliation process is complete.
After the Bank Reconciliation process is complete, if this number is less than the number of transactions loaded, it indicates there are transactions in the bank file that didn’t match those in the system. We refer to these as
reconciliation exceptions. You need to resolve the exceptions.
Cylce Status The reconciliation cycle processing status:
EDI Loaded: Indicates you loaded the bank files into the staging tables via EDI Manager but are not yet loaded into the application tables.
Appl Loaded: Indicates you loaded the bank files into the application and ready for reconciliation processing.
Load Failed: Indicates the bank files could not load.
Fatal Error: Indicates a fatal error occurred during automatic reconciliation processing.
Loading: Indicates the bank files are being loaded.
Reconciling: Indicates the files are being reconciled.
Ready: Indicates you have loaded the bank statement file and run automatic reconciliation, but some transactions could not be matched. These transactions are exceptions that you must resolve.
Complete: Indicates reconciliation processing is complete and all transactions were successfully matched.
Exceptions Click to view exceptions on the AutoRecon Exceptions page. This link is available only if there are exceptions when the reconciliation process is complete.
Before you use the options below, select the statements for which you want to run a process or generate reports.
File Load Runs the BSP Transaction Loader to load a bank
transaction file into the application tables. This button is enabled only when you’ve selected a bank statement that has a status of EDI Loaded.
Recon (reconciliation process)
Runs the Bank Reconciliation process for the selected bank statements.
Note. You must run the Bank Reconciliation process from the Reconciliation page once before you can run it from the AutoRecon Manager page.
Delete Deletes the bank statement file.
Reports Select the report to run and click OK.
Register - Generates a report of the bank statement.
Errors - Generates a report listing instances where a bank reference number does not match any reference number in the PeopleSoft Financials system.
Exceptions - Generates a report of AutoRecon exceptions.
Scheduling Reconciliation Processing Access the Reconciliation page.
Reconciling Statements Semi-Manually Access the Semi Manual Reconciliation page.
Semi Manual Reconciliation page
The page displays both bank transactions and system transactions reconciled by manual or automatic reconciliation. If you force reconcile a transaction that does not exist on the system side, and this transaction is a fee or expense that is properly mapped to a statement activity type, the transaction displays on both the External Transactions page and the Semi-Manual
Reconciliation page.
When the system reconciles transactions with currencies different from that of the bank statement, the amounts that appear on the system side are those already converted to the default currency for the bank account.
Search Criteria
Enter your search criteria for the transactions that you want to reconcile and click Search.
Recon Status Select a status for the transactions:
Unreconciled: Select if you want to reconcile transactions.
Reconciled: Select if you want to undo the reconciliation for a transaction.
Advanced Search Click to display additional search fields on the page to sort the transactions and restrict the transactions that appear in the list.
Bank Transactions and System Transactions
The search returns data based on your specified criteria and displays the results for both Bank Transactions and System Transactions.
The page displays the bank and system transactions online simultaneously, making it easy to scroll through and match corresponding transactions. You can only reconcile transactions by matching one bank transaction to one system transaction (one to one) or one bank transaction to many system transactions (one to many). Select the transactions on each side that you want to reconcile and click Reconcile.
Transactions must comply with the following rules to reconcile.
• The bank transaction amount must equal the sum of the system transaction amounts.
• You can select only one transaction on the bank side to match against one of more on the system side.
The system issues a warning if:
• The bank dates are not the same as the bank clear date.
• The transactions types don’t match between the bank and the system sides.
If you are displaying a list of reconciled transactions, select the transactions to unreconcile, and click Unreconcile.
Bank Date Date the bank recorded the transaction.
Tran Date (transaction date) Date the system transaction occurred.
Source Origin application from for the transactions:
AR: Accounts Receivables, includes receivables, direct debits, and drafts.
GN: Transactions from outside the system.
AP: Payables.
Reconciling Statements Manually Access the Manual Reconciliation page.
Manual Reconciliation page
Important! If you open a bank account in the Manual Reconciliation page that is set for automatic reconciliation, you get a warning message stating “This bank account is set up to use Automatic Recon. Using Manual Recon may cause AutoRecon errors.” This error is generated because the system thinks there are duplicate transactions: one that you manually reconciled and one that comes from the bank input file. To avoid this error, you should not perform manual reconciliation on bank accounts whose reconciliation method is Automatic.
In manual reconciliation, system transactions in different currencies display in the default currency for the bank account.
Search Criteria
Enter your search criteria and click Search.
Status Select a status for the transactions:
Unreconciled: Select if you want to reconcile transactions.
Reconciled: Select if you want to undo the reconciliation for a transaction.
System Transactions Recon Status (reconciliation status)
The reconciliation status: UNR (unreconcilled) or REC (reconciled).
Transaction Date The date the system transaction occurred.
Status The payment status for payables transactions.
Detail The transaction type or payment method.
To reconcile transactions either select individual transactions and click Reconcile, or click Reconcile All... to mark all transactions for reconciliation. The system prompts you to enter a reconciliation date, which defaults to the current date.