Creating reconciliation templates

  1. Select Reconciliation Templates.
  2. Click Create.
  3. Specify this information:
    System
    Optionally, select the system code to use for reconciliation.
    Line Match Field
    This field is used to match the bank statement line to the transaction. For example, Transaction Number is used to match the bank statement line's transaction number to the cash ledger transaction number.

    If Line Match Field is selected and the Text Variable Replacement of Transaction Number is selected, then the Transaction Number Source field is available. Valid options are Related Reference, Bank Reference, Text Reference. This is the value that is used in the Line Match Field.

    Remove Leading Zeros
    Select this check box to suppress the leading zeros on the transaction number in the bank statement. Remove leading zeros to match the bank statement transaction number to the transaction number in the system.
    Remove Alpha Characters
    Select this check box to remove alpha characters from the variable used for the transaction number. Only the numeric value is included in the Line Match Field.
  4. Click Save.