Import Tab of the Bank Statement Reconciliation Form

The Import tab lists bank records that were imported.

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.
Unmatched	This field displays imported bank records that do not match any records.
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 posted records, select Matched. The import process matches records based on the matching rules on the Import tab of SettingsAccountingBanks or suggests matching records based on parameters such as the number of days or an amount range. To display imported bank records that do not match a posted record, 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. Wildcards are applied 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 so that 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	This check box is selected automatically if a match between a posted transaction and an imported bank record is found during the import process. This check box is updated if you manually match a bank record to a posted record on the Match Details dialog box. 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, such as Payment or Receipt.
Number	This field displays the reference number (for example, the check number) of the imported transaction. The value of this field is used 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. The value of this field is used to match the transaction with a posted record. By default, non-check related transactions are matched based on transaction date and amount.
Receipt	This field displays the amount of the receipt, as indicated in the imported bank record. The value of this field is used to match the transaction with a posted record.
Payment	This field displays the amount of the payment as indicated in the imported bank record. The value of this field is used 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 on the Import tabv of Settings > Accounting > Banks; when that option is selected, receipt and payment records are cleared when the record is matched.