Field | Description |
Imported Items Summary 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.
|
Matched
|
This field displays imported bank records that match records that were posted in Vision.
|
Unmatched
|
This field displays imported bank records that do not match any records in Vision.
|
Total
|
This field displays summarized information on all bank records.
|
Matched Drop-down
|
Click the drop-down arrow to complete any of the following actions:
- To display imported bank records that are already matched with records posted in Vision, select
Matched. Vision automatically matches records during the import process based on the matching rules in Bank Configuration or may suggest matching records based on set parameters (number of days or amount range).
- To display imported bank records that do not match a posted record in Vision, click
Unmatched. You need to match them manually.
- To display all records, click
All.
|
Search Imported Records
|
To search imported records, enter information such as amount, reference number, or description in the search box, and click
Search. Vision applies wildcards before and after the text that you enter in this field. For example, if you enter
Cash Transfer in this field, the search results include all records that have that phrase in the description.
|
Imported Records 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.
|
Match Detail
|
To display transaction details on the Match Transaction dialog box, where you can review matching posted records or manually match an imported record to a posted record, select the record in the grid and then click this option.
|
Matched
|
Vision automatically selects this check box if a match between a posted transaction and an imported bank record is found during the import process. Vision also updates this check box if you manually match a bank record to a posted record using the Match Details dialog.
You can also select this check box if the imported bank transaction matches a journal entry that is not part of a bank statement.
|
Type
|
This field displays the bank transaction type (for example, Payment or Receipt).
|
Number
|
This field displays the reference number (for example, the check number) of the imported transaction in Vision. Vision uses the value of this field to match the bank transaction with a posted record for check-type transactions. For non-check related transactions (deposits, electronic fund transfers, and wires), this field may be blank and may not be used for automatic matching.
|
Description
|
This field displays the description of the bank record as shown in the imported file.
|
Transaction Date
|
This field displays the date of the receipt or payment as indicated in the imported bank record. Vision uses the value of this field to match the transaction with a posted record. By default, Vision matches non-check related transactions based on transaction date and amount.
|
Receipt
|
This field displays the amount of the receipt, as indicated in the imported bank record. Vision uses the value of this field to match the transaction with a posted record.
|
Payment
|
This field displays the amount of the payment as indicated in the import ed bank record. Vision uses the value of this field to match the transaction with a posted record.
|
Clear Matched Transactions
|
Select this option when you want to clear the associated receipt and payment records on the Receipts and Payments tabs with the matched transactions. This option only appears if
Automatically Clear Matched Transactions is not selected in Bank Configuration. When
Automatically Clear Matched Transactions is selected, Vision clears receipt and payment records at the time the record is matched.
|