Import Tab of Bank Codes

Use this tab to enable the ability to import bank statements directly into bank statement reconciliation, allow the automatic matching of bank and Vision records, and make it possible to match any remaining records manually.

This tab allows you define the format for the bank file you will be importing as well as define the matching rules.

Contents

Field Description
Import Select this check box to enable bank statement imports in Bank Reconciliation and enable the fields that are used to configure how Vision identifies the data on the file being imported.

File Format

Field Description
Field Delimiter From the drop-down list, select the character to use as a separator between the values (fields) in the files that you will import into Vision.
Options are:
  • {Tab}
  • @
  • #
  • $
  • ^
  • |
  • ; (semi colon)
  • , (comma)
Text Qualifier From the drop-down list, select the character that you are using as a text qualifier in the files to import into Vision.
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 value (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.

Example:

You use comma delimiters and you use a single quotation mark as the text qualifier.

A row of data in the file is as follows:

'John Bartlett', 'Marriott International, Inc', '10/20/2014', '$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

Field Description
Order Select the order in which you want the month (M), day (D), and year (Y) to appear in dates.

Options are: DMY, DYM, MDY, MYD, YDM, and YMD.

Delimiter Enter the character that you want to use as the separate between month, day, and year. Examples are / or -.
Leading Zeros Select this check box if you want leading zeros used for one-digit months or days (for example, use 01 instead of 1 for January).
Four Digit Year Select this check box if you want all four digits of the year included for years (for example, use 2014 instead of 14).

Import Values

Field Description
Define Receipt/Payment Use this field to define how Vision differentiates 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:
  • Recipient greater than zero — Select this option if there is not another indicator on the file to define a receipt (deposit) or a payment. Select this option so that Vision can identify a deposit as a transaction amount greater than zero. Amounts equal to and less than zero will be payment amounts.
  • Recipient less than zero — Select this option if there is not another indicator on the file to define a deposit or a payment. Select this option so that Vision 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 option to define the mapping that the bank uses to identify each record as either a receipt or a payment. Selecting this option enables the Type Mapping option on the Import Values grid toolbar. Click the Type Mapping option to display the Bank Transaction Type Matching dialog box, where you can configure the different transaction types.
  • Separate Columns — Select this option if the deposits and payments are identified under different columns in the file to be imported.

Import Values Grid Toolbar

Field Description
Import Values Drop-Down

Click the drop-down arrow on a grid header to complete any of the following actions:

  • To print grid data, click Print. On the Print Preview form, click File > Print to send the grid data to your default printer.
  • To export grid data to an Excel spreadsheet, click Export to Excel. When Microsoft Excel opens, use its features to modify, print, or email the grid data, or to save the spreadsheet file locally.
  • To turn on grouping for a grid, click Enable Grouping. When a field displays with the instruction: "Drag a column header here to group by that column," drag and drop column headers into the field, in the sequence that you want them to display.

Not all options are available on all grids.

Field Description
Type Mapping This option is enabled when you select the Type Mapping option from the Define Receipt/Payment drop-down list.

Click this option to display the Bank Transaction Type Matching dialog box, where you configure how Vision identifies whether the bank transaction are payment records or receipt records.

Down, Up, and Move Included Items Up Use the these options to re-order a selected field to match the order in your import file.

Click Move Included Items Up to move all selected fields to the top of the list.

Import Values Grid Columns

Field Description
Include This column displays a check box for each row on 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 by Vision 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 configuration that is entered on the Bank Transaction Type Matching dialog box as a reference when transactions are processed during import.
  • 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 — The five possible user-defined fields are UserDefined1, UserDefined2, UserDefined3, UserDefined4, and UserDefined5. You can configure the user-defined fields to reference other fields on the import file that are not available on the list of pre-defined fields on 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 on a payment.

Label Enter the label for any user-defined field that you include in the import file. You cannot enter labels for the predefined fields.

If you have Vision 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

Field Description
Automatically Clear Matched Transactions Select this option to automatically clear any transactions associated with a matching bank imported record. Vision matches the record on the import tab and updates the clear check box on the Receipts and Payments tab on Accounting > Bank Reconciliation.

If you do not select this option, Vision matches the bank record with the posted Vision record according to the matching rules. However, it allows for review and an additional step to clear the matched transaction on the receipt and payment tabs as part of the bank reconciliation process.

Advanced Matching Rules Click this button to display the Advanced Matching Rules dialog box. Use the dialog box to modify what matching rule Vision will follow for a transaction. The available matching rules are based on either amount and reference number or amount and transaction date.
Matching Suggestions Click this button to display the Matching Suggestions dialog box. Vision uses the values entered on the dialog box to define a filtered list of suggested records when manually matching transactions in Bank Reconciliation. When manually matching transactions, Bank Reconciliation provides a list of all unmatched transactions and a list of suggested transactions.