Advanced Matching Rules Dialog Box

Use this dialog box to configure how Vision matches posted transactions with imported bank records by transaction type in Vision. This dialog allows you to edit the default matching rules.

Location

To display the dialog box, complete the following steps:

  1. On the Vision Navigation Menu, click Configuration > Accounting > Banks.
  2. Open an existing bank code or create a new record.
  3. Click the Import tab.
  4. Select the Import check box if it is not yet selected.
  5. Click the Advanced Matching Rules button.

Contents

Field Description
Payments 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.

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

Grid Columns

Field Description
Application This column displays the Vision applications associated with bank transactions.
Vision Transaction This column displays the type of bank transaction for the corresponding Vision application.
Matching Rule This column displays the type of matching rule used for the corresponding Vision application and transaction. Select one of the following options from the drop-down list:
  • Amount and Refno — Select this option to match Vision-posted transactions to imported records based on transaction amount and the reference number. This is the default rule for Vision check-related transactions
  • Amount and Date — Select this option to match Vision-posted transactions to imported records based on transaction amount and the transaction date on the import file. This is the default rule for all non-check related transactions.