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