Setting Up Reconciliation Processing

Before you can initiate bank reconciliation processing, you must do the following:

• Define reconciliation record source types.

• Define reconciliation field aliases.

• Define reconciliation status codes.

• Define reconciliation rules.

• Create reconciliation SQL.

• Create reconciliation tolerances.

PeopleSoft delivers predefined data in the reconciliation setup tables. You should review this information to determine whether you need to set up your own information to meet your organization's needs.

When you initiate reconciliation processing, the Application Engine validates rules and tolerances set for the respective source, bank, and bank account and reconciles the transactions using the bank ID, bank account, and statement ID submitted on the run control page.

The parent BNK_RECON Application Engine process evaluates the source. Based on an individual source, the respective Application Engine is invoked.

Reconciliation Application Engine	PeopleSoft Application Transaction Source
BNK_RECON_AP	Payables
BNK_RECON_DB	Receivables Direct Debits
BNK_RECON_DP	Receivables Deposits
BNK_RECON_DR	Receivables Drafts
BNK_RECON_PY	Receivables Payments
BNK_RECON_TR	Treasury
BNK_RECON_XT	External Transactions

If you use Cash Management, you can establish bank statement accounting for your reconciliation processing. You establish rules the system uses to match exceptions, or NTFs (No Transactions Found). When the system encounters an exception that matches a rule, it automatically creates a system-side accounting entry for the exception, and marks the exception as reconciled. This process reduces the number of exceptions that you must resolve. Use the TR_RECON_EXC program and TR_UNRECON_TRANS component interface to load reconciliation exceptions.