Import Tab of the Bank Statement Reconciliation Form

The Import tab lists bank records that were imported into Vision.

Contents

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

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

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.