Show TOC

Procedure documentationRunning the Bank Reconciliation Report: AU, CA, GB, NZ, US, and ZA Locate this document in the navigation structure

 

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 supports:

  • External reconciliations linked with the G/L accounts that represent house bank accounts

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

Procedure

To run the bank reconciliation report, do one of the following:

  • Run the report from the Banking module or the Reports module:

    1. From the SAP Business One Main Menu, choose   Banking   Banking Reports   External Reconciliation   Bank Reconciliation Report  . Alternatively, choose   Reports   Banking   External Reconciliation   Bank Reconciliation Report  .

      The Bank Reconciliation Report - Selection Criteria window appears.

    2. From the dropdown lists, select the account code and reconciliation number.

    3. Choose the OK button.

      The Bank Reconciliation Report window appears in the Crystal Reports viewer in SAP Business One.

  • Run the report from the Administration module:

    Note Note

    Only superusers and authorized regular users can perform the procedure below.

    End of the note.
    1. From the SAP Business One Main Menu, choose   Administration   Setup   General   Report and Layout Manager  .

      The Report and Layout Manager window appears.

    2. In the navigation pane on the left, choose   Banking   Banking Reports   External Reconciliation   Bank Reconciliation Report  .

    3. In the work area on the right, choose the Run Report button.

      The Bank Reconciliation Report - Selection Criteria window appears.

    4. From the dropdown lists, select the account code and reconciliation number.

    5. Choose the OK button.

      The Bank Reconciliation Report window appears in the Crystal Reports viewer in SAP Business One.