Bank Reconciliation Account Balance Inquiry

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

Purpose

View transactions for a bank account.

Overview

Use Bank Reconciliation Account Balance Inquiry to display posted deposits, payments, and general ledger adjustments for a bank account. You can use this information to help perform the bank reconciliation process. You can filter the transactions by a range of deposit, payment, or bank reconciliation dates. For information on the bank reconciliation process, see Bank Reconciliation.

Using the Inquiry

To use Bank Reconciliation Account Balance Inquiry:

  1. Enter the bank account in the Cash Account field for which you want to display posted deposits, payments, and general ledger adjustments.

  2. Select filter criteria for the transactions you want to display.

  3. Select whether to summarize uncleared deposits by deposit date or batch.

  4. Click the Show Data button in the ribbon. The Results tab displays the transactions for the account selected in step 1 that meet the criteria selected in steps 2 and 3.

Ribbon Home Tab Buttons

Button

Description

Exit

Click this button to close the Bank Reconciliation Account Balance 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.

UP

Click this button to display all transactions if you are viewing specific deposits.

Down

Click this button to display specific deposits if you are viewing deposits grouped by deposit date or batch.

Select Tab Fields and Buttons

Field or Button

Description

Cash Account

Enter a bank account for which to display transactions, or click the Lookup button to select a bank account.

Bank Account Currency

This field displays the currency of the account entered in the Cash Account field.

All Deposit Dates

Select this check box to display deposits for all deposit dates. This check box is selected by default.

From (Deposit Date)

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

To (Deposit Date)

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

All Payment Dates

Select this check box to display payments for all payment dates. This check box is selected by default.

From (Payment Date)

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

To (Payment Date)

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

All Bank Rec Dates

Select this check box to display general ledger adjustments for all bank reconciliation dates. This check box is selected by default.

From (Bank Reconciliation Dates)

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

To (Bank Reconciliation Dates)

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

Cleared Status

Select whether to display cleared, uncleared, or both cleared and uncleared transactions.

Summarize Deposits by

Select whether to summarize deposits by deposit date or batch. This radio set is only enabled if the Not Cleared or Both radio button is selected for the Cleared Status radio set.

NOTE This option is only used for uncleared deposits. Cleared deposits display by deposit date or batch based on how the bank reconciliation process was performed.

Results Tab Fields and Buttons

Field or Button

Description

Transactions

This grid displays posted deposits, payments, and general ledger adjustments for the selected bank account after you click the Show Data button in the ribbon. Uncleared deposits in this grid are displayed grouped by date or batch based on the Summarize Deposits by option selected on the Select tab. You can double-click a row of deposits grouped by date or batch to display specific deposits. You can then double-click a specific deposits to display deposits grouped by date or batch again. You can also use the UP and Down buttons in the ribbon to switch the view of deposits.

Total Amount

This field displays the total of all displayed deposits, payments, and general ledger adjustments for the selected account.