Bank Reconciliation Report Window: AU, CA, GB, NZ, US, and ZA

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 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.

End of the note.

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 Note

Amounts in brackets indicate negative amounts.

End of the note.

Report Header

G/L Account
Displays the code and name of the selected G/L account.

Reconciliation Number
Displays the number of the reconciliation that you specified in the selection criteria window.

Statement Date
Displays the date specified in the End Date field in the External Bank Reconciliation – Selection Criteria window for this reconciliation under Banking Bank Statements and External Reconciliations Manual Reconciliation .

Statement Number
Displays the number specified in the Statement No. field in the Reconciliation Bank Statement window for this reconciliation. To open this window, choose Banking Bank Statements and External Reconciliations Manual Reconciliation , specify relevant information, and choose the OK button.

Date, Time
Displays the date and time when you run the report.

Reconciliation Summary

Beginning Balance
Displays the number in the Last Statement Balance field in the Reconciliation Bank Statement window for this reconciliation. To open this window, choose Banking Bank Statements and External Reconciliations Manual Reconciliation , specify relevant information, and choose the OK button.

Cleared Checks and Payments
Displays the cleared amount of outgoing transactions in this reconciliation, that is, transactions in which the selected G/L account is credited.

Cleared Deposits and Credits
Displays the cleared amount of incoming transactions in this reconciliation, that is, transactions in which the selected G/L account is debited.

Ending Balance
Displays the number in the Statement Ending Balance field in the Reconciliation Bank Statement window for this reconciliation. To open this window, choose Banking Bank Statements and External Reconciliations Manual Reconciliation , specify relevant information, and choose the OK button.

Account Balance
Displays the balance on the selected G/L account as of the statement date.

Uncleared Checks and Payments
Displays the uncleared amount of outgoing transactions in this reconciliation, that is, transactions in which the selected G/L account is credited.

Uncleared Deposits and Credits
Displays the uncleared amount of incoming transactions in this reconciliation, that is, transactions in which the selected G/L account is debited.

Adjusted Account Balance
Displays the result of Account Balance + Uncleared Checks and Payments – Uncleared Deposits and Credits.

Variance
Displays the difference between the Ending Balance and the Adjusted Account Balance.

Report Body

Type
Displays the transaction type: PS represents outgoing transactions, that is, transactions in which the selected G/L account is credited (such as checks and bank transfers issued to vendors). DP represents incoming transactions, that is, transactions in which the selected G/L account is debited (such as deposits made of checks and bank transfers received from customers).

Trans. No.
Displays the number of the transaction and provides a link to the journal entry.

Posting Date
Displays the value as it appears in the Posting Date field in the Journal Entry window for this transaction.

Payee/Account Name, BP Code/Account Code
Displays the name and code of the business partner or account that acts as the offset account to the selected G/L account.

Ref. No.1, Ref. No.3
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.

Check No.
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 Banking Outgoing Payments Checks for Payment .

Remarks
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.

Deposit
Displays the amount on the debit side of the selected G/L account.

Payment
Displays the amount on the credit side of the selected G/L account.

Balance
Displays the total cumulative amount calculated by adding deposits and subtracting payments.

More Information

Bank Reconciliation Report - Selection Criteria Window: AU, CA, GB, NZ, US, and ZA

Running the Bank Reconciliation Report: AU, CA, GB, NZ, US, and