Import Tab of Banks Settings Form

Use this tab to define the format and matching rules for the bank file that you will be importing. You can complete the setup steps needed to import bank statements directly into bank statement reconciliation, allow the automatic matching of bank and Vantagepoint records, and make it possible to match any remaining records manually.

Contents

To see this tab, you must select the Import Enabled check box on the Options tab of Banks Settings.

File Format

Use this section to format field text (such as, special characters, separators, and decimal symbols) in the files that you plan to import.

Field	Description
Field Delimiter	From the drop-down list, select the character to use as a separator between the fields in the files that you will import. For example, you can select a TAB or a comma.
Text Qualifier	From the drop-down list, select the character that you are using as a text qualifier in the files that you plan to import. Options are: {None}: No text qualifier ": Double quotation mark ': Single quotation mark You can use a text qualifier in addition to delimiters in a file that you import. Text qualifiers are placed at the beginning and end of a value (field), inside the delimiters. Text qualifiers indicate that the content between them is part of one field. For example, if you use comma delimiters, a text qualifier (other than a comma) helps to distinguish commas that are used as delimiters and commas that are used within the value. In addition, if you also use a single quotation mark as the text qualifier, the resulting row of data displayed in the file is shown in the following example: 'John Bartlett', 'Marriott International, Inc', '10/20/2019', '$1,000.00' Using text delimiters ensures that the commas in Marriott International, Inc and in $1,000.00 are not interpreted as delimiters. These commas are part of the company name and the monetary amount.
Decimal Symbol	Enter the symbol that you use for decimals in import files.

Date Handling

Use this section to define date formats used in the import file.

Field	Description
Date Order	Select the order in which you want the month (M), day (D), and year (Y) to appear in dates.
Date Delimiter	Enter the character to use as the separator between month, day, and year, such as / or -.
Leading Zeros	Set this option to Yes to use leading zeros for one-digit months or days (for example, 01 instead of 1 for January).
Four Digit Years	Set this option to Yes to include all four digits for years (for example, 2019 instead of 19).

Import Values

Use this section to define receipt and payment information and view the Import Details grid.

Field

Description

Define Receipt/Payment

Use this field to define how Vantagepoint determines which bank records are receipt (deposit) records and which records are payment records. Click the drop-down list to select one of the following options: Receipts greater than zero: Select this setting if there is no other indicator in the file to define a receipt (deposit) or a payment. If you select this option, Vantagepoint can identify a deposit as a transaction amount greater than zero. Amounts equal to and less than zero will be payment amounts. Receipts less than zero: Select this setting if there is no other indicator in the file to define a deposit or a payment. If you select this option, Vantagepoint can identify a receipt (deposit) as a transaction amount less than zero. Amounts equal to or greater than zero will be payment amounts. Type Mapping: Select this setting to display the Bank Transaction Type Matching grid, where you set up how Vantagepoint identifies whether bank transactions are payment records or receipt records. Separate Columns: Select this setting if the deposits and payments are identified under different columns in the file to be imported.

Import Details Grid

Use the columns in this grid to select, define, and reorder fields that you want to include in the import file.

Field	Description
Include	This column displays a check box for each row in the grid. Select the check box for each field that you include in the import file.
Field Name	This column displays the fields that you can import from the file. The predefined fields are: Date: This field refers to the actual date on which the transaction occurred. This date is used as a reference when matching the transaction to a posted record. Reference Number: This field refers to the bank assigned reference number associated with the transaction. For checks, the reference number might be the check number. Payee/Description: This field refers to the description of a deposit transaction or the payee of a payment transaction. The user-defined fields can be used if there is more than one description on the import file. Type: This field is applicable when you select Type Mapping from the drop-down list for the Define Receipt/Payment option. This field uses the type mapping setup entered on the Bank Transaction Type Matching dialog box as a reference when transactions are imported. Amount: This field refers to the transaction amount. Receipt Amount: This field refers to the deposit amount on the receipt. This field is only available if you select Separate Columns from the drop-down list for the Define Receipt/Payment option. Payment Amount: This field refers to the payment amount in the receipt. This field is only available if you select Separate Columns from the drop-down list for the Define Receipt/Payment option. User-defined fields 1 through 5: You can set up the user-defined fields to reference other fields in the import file that are not available in the list of pre-defined fields in the grid. User-defined fields are optional. Use them to provide information that would be helpful with the manual matching process, such as an additional description field in a payment.
Label	Enter the label for any user-defined field that you include in the import file. You cannot enter labels for predefined fields. If you have Vantagepoint databases set up in multiple languages, you can log in to each language and enter the appropriate label for each language.
Data Type	This field displays the data type for a field, which indicates the type of characters used for the data: Varchar: The field can contain both letters and numbers. Datetime: The field contains a date. Decimal: The field contains numeric amounts.

Matching Rules

Use this section to apply matching rules to imported bank records and payment transactions.

Field	Description
Automatically Clear Matched Transactions	Select Yes to automatically clear any transactions associated with a matching imported bank record. Vantagepoint matches the record on the import tab and updates the Cleared check box on the Receipts and Payments tabs in Cash Management > Bank Reconciliation. If you select No, Vantagepoint matches the bank record with the posted Vantagepoint record according to the matching rules. However, you can review and clear matched transactions as part of the Bank Reconciliation process.
Payment Days +/-	Use this field to enter the number of days difference between the posted record and bank transaction for records to display in the suggestions section of the matching dialog box in Cash Management > Bank Reconciliation, for payment transactions. For example, enter 5 to specify that if there is a record with a five day difference between the Vantagepoint bank document line date and the bank statement line date, it will display in the suggested section in Bank Reconciliation.
Payment Amount +/-	Use this field to enter the transaction amount difference between the posted record and bank transaction for records to display in the suggestions section of the matching dialog box in Cash Management > Bank Reconciliation, for payment transactions. For example, enter 1.00 to specify that you want to include transactions that are off by a dollar between the bank record and the posted record.

Payment Matching Grid

Use this grid to view and apply matching rules for payment records that you plan to import.

Field	Description
Application	This column displays the Vantagepoint applications associated with bank transactions.
Transaction	This column displays the type of bank transaction.
Matching Rule	This column displays the type of matching rule used. Select one of the following options from the drop-down list: Amount and Refno: Select this option to match Vantagepoint-posted transactions to imported records based on the transaction amount and reference number. This is the default rule for check-related transactions Amount and Date: Select this option to match Vantagepoint-posted transactions to imported records based on the transaction amount and the transaction date on the import file. This is the default rule for all non-check related transactions.
Receipt Days +/-	Use this field to enter the number of days difference between the posted record and bank transaction for records to display in the suggestions section of the matching dialog box. In Cash Management > Bank Reconciliation, for receipt transactions. For example, enter 5 to specify that if there is a record with a five day difference between the Vantagepoint bank document line date and the bank statement line date, it will display in the suggested section in Bank Reconciliation.
Receipt Amount +/-	Use this field to enter the transaction amount difference between the posted record and bank transaction for records to display in the suggestions section of the matching dialog box in Cash Management > Bank Reconciliation , for receipt transactions. For example, enter 1.00 to specify that you want to include transactions that are off by a dollar between the bank record and the Vantagepoint-posted record.

Receipt Matching Grid

Use this section to view and apply matching rules to receipt (deposit) records that you plan to import.

Field	Description
Application	This column displays the Vantagepoint applications associated with bank transactions.
Transaction	This column displays the type of bank transaction.
Matching Rule	This column displays the type of matching rule used for the receipt records. Select one of the following options from the drop-down list: Amount and Refno: Select this option to match Vantagepoint-posted transactions to imported records based on the transaction amount and reference number. This is the default rule for check-related transactions. Amount and Date: Select this option to match Vantagepoint-posted transactions to imported records based on the transaction amount and the transaction date on the import file. This is the default rule for all non-check related transactions.