Contents of the Advanced Matching Rules Dialog Box

Use these fields and options to set up matching rules that determine how posted transactions are matched with imported bank records.

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.

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 `DPS` applications associated with bank transactions.
`DPS` Transaction	This column displays the type of bank transaction.
Matching Rule	This column displays the type of matching rule used. Select one of the following options from the drop-down list: Amount and Refno: Select this option to match `DPS`-posted transactions to imported records based on the transaction amount and reference number. This is the default rule for check-related transactions Amount and Date: Select this option to match `DPS`-posted transactions to imported records based on the transaction amount and the transaction date on the import file. This is the default rule for all non-check related transactions.