Prerequisites for Reconciling Statements

Before you reconcile bank statements, you must perform the following tasks:

  1. Review and configure bank reconciliation rules for individual source applications.

    • For each source, select the reconciliation type, such as many to many, many to one, one to many, or one to one.

    • For each rule, add aggregate statement lines criteria and aggregate transactions criteria.

    • Enter match criteria and filter criteria.

  2. Run the Reconciliation Rules SQL process.

  3. Define reconciliation tolerances in these categories: day tolerances and monetary tolerances.

  4. Assign an individual source and the reconciliation rules for that source to the bank and bank account. Assign defined tolerances for each rule.

  5. Load statements electronically or enter bank statement data manually.