Setting Up a Mapping Profile

The mapping profile is used to automate the bank reconciliation process by reading a bank statement using the mapping definitions. This removes dependency to receive the bank statement with specific column headers and allows the application to specify any file format if the mapping is defined.

  1. 1. Open the Bank Statement Mapping Fields form.
  2. Specify this information:
    Bank Code
    Select the code related to the bank of which the bank statement is uploaded.
    Description

    The description for the mapping profile.

    Date Format

    Select the date format for the date values.

    Number Of Header Records To Skip

    The number of header rows that are not included in reconciliation.

    Archive Logical Folder

    The folder in which processed files are stored after the reconciliation.

  3. In the Details section, specify this information:
    Table Name
    Select the code related to the bank of which the bank statement is uploaded.
    Column Name

    Select the internal field that is equivalent to the header in the bank statement.

    Field Number

    Select the date format for the date values.

    Amounts Contain Implied Decimals

    Select this check box if amounts in the bank statement do not contain an explicit decimal point but have an implied decimal.

    Field Is Amount

    Select this check box if you are defining an amount field.

    Digits following Implied Decimals

    The number of implied decimals that the amount contains.

    Amount Type

    Select the amount type.

    Field Is Date

    Select this check box to identify that the column contains a date value.

  4. Click Save.