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:
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:
|
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:
|
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:
|
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
.
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 | , 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 | , 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:
|
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 | , 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 | , 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:
|