Menu Path: Cash Management Inquiries Bank Reconciliation Account Balance Inquiry
View transactions for a bank account.
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.
To use Bank Reconciliation Account Balance Inquiry:
Enter the bank account in the Cash Account field for which you want to display posted deposits, payments, and general ledger adjustments.
Select filter criteria for the transactions you want to display.
Select whether to summarize uncleared deposits by deposit date or batch.
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.
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. |
Field or Button |
Description |
Enter a bank account for which to display transactions, or click the Lookup button to select a bank account. |
|
This field displays the currency of the account entered in the Cash Account field. |
|
Select this check box to display deposits for all deposit dates. This check box is selected by default. |
|
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. |
|
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. |
|
Select this check box to display payments for all payment dates. This check box is selected by default. |
|
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. |
|
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. |
|
Select this check box to display general ledger adjustments for all bank reconciliation dates. This check box is selected by default. |
|
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. |
|
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. |
|
Select whether to display cleared, uncleared, or both cleared and uncleared transactions. |
|
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. |
Field or Button |
Description |
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. |
|
This field displays the total of all displayed deposits, payments, and general ledger adjustments for the selected account. |