This report is valid for the following localizations: Australia, Canada, Great Britain (United Kingdom), New Zealand, United States, and South Africa.
This report compares the ending balance of a bank statement with the adjusted balance of the G/L account that represents the bank account as of the statement date. It lists the cleared transactions in the bank statement and the uncleared transactions in the G/L account as of the statement date.
Note
This report uses only external reconciliations created with the function for manually reconciling bank statements. This function is localized for the following countries: Australia, Brazil, Canada, China, Cyprus, India, Japan, Korea, New Zealand, Singapore, South Africa, United Kingdom, and United States. For more information about this function, see Manually Reconciling Bank Statements: AU, BR, CA, CN, CY, GB, IN.
This window displays the Bank Reconciliation report according to your selection criteria.
It consists of the following sections:
Report header – displays the criteria selected in the Bank Reconciliation Report - Selection Criteria window and other relevant information.
Reconciliation summary – displays the summarized information of cleared checks, payments, deposits, and credits in the bank statement; and uncleared checks, payments, deposits, and credits in the G/L account, and the balances and variance.
Report body – displays the detailed information of cleared checks, payments, deposits, and credits; uncleared checks, payments, deposits; and credits; subtotals of each section; and totals of cleared and uncleared transactions.
Note
Amounts in brackets indicate negative amounts.
Displays the code and name of the selected G/L account. |
Displays the number of the reconciliation that you specified in the selection criteria window. |
Displays the date specified in the End Date field in the External Bank Reconciliation – Selection Criteria window for this reconciliation under . |
Displays the number specified in the Statement No. field in the Reconciliation Bank Statement window for this reconciliation. To open this window, choose , specify relevant information, and choose the OK button. |
Displays the date and time when you run the report. |
Displays the number in the Last Statement Balance field in the Reconciliation Bank Statement window for this reconciliation. To open this window, choose , specify relevant information, and choose the OK button. |
Displays the cleared amount of outgoing transactions in this reconciliation, that is, transactions in which the selected G/L account is credited. |
Displays the cleared amount of incoming transactions in this reconciliation, that is, transactions in which the selected G/L account is debited. |
Displays the number in the Statement Ending Balance field in the Reconciliation Bank Statement window for this reconciliation. To open this window, choose , specify relevant information, and choose the OK button. |
Displays the balance on the selected G/L account as of the statement date. |
Displays the uncleared amount of outgoing transactions in this reconciliation, that is, transactions in which the selected G/L account is credited. |
Displays the uncleared amount of incoming transactions in this reconciliation, that is, transactions in which the selected G/L account is debited. |
Displays the result of Account Balance + Uncleared Checks and Payments – Uncleared Deposits and Credits. |
Displays the difference between the Ending Balance and the Adjusted Account Balance. |
Displays the transaction type:
|
Displays the number of the transaction and provides a link to the journal entry. |
Displays the value as it appears in the Posting Date field in the Journal Entry window for this transaction. |
Displays the name and code of the business partner or account that acts as the offset account to the selected G/L account. |
Displays the values as they appear in the Ref.1 and Ref.3 fields in the expanded mode of the Journal Entry window for the selected G/L account. |
When the transaction is a check, displays the value as it appears in the Internal ID field in the Checks for Payment window for this check under . |
Displays the value as it appears in the Remarks field in the expanded mode of the Journal Entry window for the selected G/L account. |
Displays the amount on the debit side of the selected G/L account. |
Displays the amount on the credit side of the selected G/L account. |
Displays the total cumulative amount calculated by adding deposits and subtracting payments. |