Contents of the Match Transaction Dialog Box (Receipts and Payments)

After you click Match Transaction on the Receipts or Payments tab of the Bank Reconciliation form, use the fields on this dialog box to review the imported bank records that match records that were posted.

Field Description
Actions

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 enable grouping for a grid, click Enable Grouping. When a field displays with the instruction to "Drag a column header here to group by that column," you can 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.

Select Select this checkbox to match the suggestion with the imported bank transaction. The suggestions are posted bank records that fall within the parameters set on the Matching Suggestion dialog box. The parameters define which records should be considered as suggestions based on the difference of the number of days, or on the difference of the amount between the posted record and the imported bank record.

Bank transactions imported through the bank feed are not matched with posted records that have statement dates that occur in the future.

Cleared Click this option to indicate that the transaction was listed as a cleared on the bank statement.
Type This field displays the import transaction type of either Payment or Receipt.
Number This column displays the reference number entered for the transactions. For example, for checks, this is the check number.
Description This column shows the description of the imported transactions and the posted transaction.
Date This column displays the transaction date of the imported record.
Amount This column displays the amount of the imported record.