Bank Reconciliation Transaction Inquiry

Menu Path: Cash Management Images\bluerarw.gif Inquiries Images\bluerarw.gif Bank Reconciliation Transaction Inquiry

Purpose

View reconciled bank transactions.

Overview

Use Bank Reconciliation Transaction Inquiry to display a list of reconciled bank transactions (transactions cleared during the bank reconciliation process). For information on the bank reconciliation process, see Bank Reconciliation.

Ribbon Home Tab Buttons

Button

Description

Exit

Click this button to close the Bank Reconciliation Transaction Inquiry window.

Show Data

Click this button to display bank reconciliation transactions on the Results tab based on the selected criteria on the Select tab.

Select Tab Fields and Buttons

Field or Button

Description

Transaction Type

Select the type of bank reconciliation transactions you want to display.

All Cleared Dates

Select this check box to display bank reconciliation transactions for all cleared dates. This check box is selected by default.

From (Cleared Date)

Enter the first date in a range of cleared dates for which to display bank reconciliation transactions, or click the drop-down arrow to select a date. This field is only enabled if you clear the All Cleared Dates check box.

To (Cleared Date)

Enter the last date in a range of cleared dates for which to display bank reconciliation transactions, or click the drop-down arrow to select a date. This field is only enabled if you clear the All Cleared Dates check box.

All Deposit Dates/All Payment Dates/All Adjustment Dates

Select this check box to display bank reconciliation transactions for all deposit, payment, or adjustment dates. This check box is selected by default.

From (Deposit/Payment/Adjustment Date)

Enter the first date in a range of deposit, payment, or adjustment dates for which to display bank reconciliation transactions, or click the drop-down arrow to select a date. This field is only enabled if you clear the All Deposit Dates, All Payment Dates, or All Adjustment Dates check box.

To (Deposit/Payment/Adjustment Date)

Enter the last date in a range of deposit, payment, or adjustment dates for which to display bank reconciliation transactions, or click the drop-down arrow to select a date. This field is only enabled if you clear the All Deposit Dates, All Payment Dates, or All Adjustment Dates check box.

All Bank Reconciliation Descriptions

Select this check box to display transactions for all bank reconciliation descriptions. This check box is selected by default.

From (Bank Reconciliation Description)

Enter a bank reconciliation description for which to display transactions, or click the Lookup button to select a bank reconciliation description. If you want to display bank reconciliation transactions for a range of bank reconciliation descriptions, enter the first bank reconciliation description in the range. This field is only enabled if you clear the All Bank Reconciliation Descriptions check box.

To (Bank Reconciliation Description)

Enter the last bank reconciliation description in a range of bank reconciliation descriptions for which to display transactions, or click the Lookup button to select a bank reconciliation description. If you want to display bank reconciliation transactions for a single bank reconciliation description, you can leave this field blank. This field is only enabled if you clear the All Bank Reconciliation Descriptions check box.

All Statement Dates

Select this check box to display bank reconciliation transactions for all statement dates. This check box is selected by default.

From (Statement Date)

Enter the first date in a range of statement dates for which to display bank reconciliation transactions, or click the drop-down arrow to select a date. This field is only enabled if you clear the All Statement Dates check box.

To (Statement Date)

Enter the first date in a range of statement dates for which to display bank reconciliation transactions, or click the drop-down arrow to select a date. This field is only enabled if you clear the All Statement Dates check box.

All Cash Accounts

Select this check box to display bank reconciliation transactions for all cash accounts. This check box is selected by default.

From (Cash Account)

Enter a cash account for which to display bank reconciliation transactions, or click the Lookup button to select a cash account. If you want to display bank reconciliation transactions for a range of accounts, enter the first account in the range. This field is only enabled if you clear the All Cash Accounts check box.

To (Cash Account)

Enter the last cash account in a range of cash accounts for which to display bank reconciliation transactions, or click the Lookup button to select a cash account. If you want to only display bank reconciliation transactions for a single cash account, you can leave this field blank. This field is only enabled if you clear the All Cash Accounts check box.

All Bank Account Currencies

Select this check box to display bank reconciliation transactions for all bank account currencies. This check box is selected by default.

From (Bank Account Currency)

Enter a currency to display bank reconciliation transactions for bank accounts associated with the currency, or click the Lookup button to select a currency. If you want to display bank reconciliation transactions for bank accounts associated with a range of currencies, enter the first currency in the range. This field is only enabled if you clear the All Bank Account Currencies check box.

To (Bank Account Currency)

Enter the last currency in a range of currencies to display bank reconciliation transactions for bank accounts associated with the currencies, or click the Lookup button to select a currency. If you want to display bank reconciliation transactions for bank accounts associated with a single currency, you can leave this field blank. This field is only enabled if you clear the All Bank Account Currencies check box.

Results Tab Fields and Buttons

Field or Button

Description

Reconciled Transactions

This grid displays bank reconciliation transactions after you click the Show Data button in the ribbon.

NOTE If you are viewing deposits that were summarized by batch during the bank reconciliation process, the deposits are summarized by batch in this grid.

To drill down to the details of the individual deposits for a deposit date or batch, double-click the total deposit, or click the down arrow button.