Show TOC

 Bank Reconciliation

 

You use this report to reconcile the difference between the balance shown in the bank statements you receive from your banks, and the corresponding amount shown in your own accounting records at a particular point in time.

Prerequisites

You have made the following settings in Customizing:

  • You have assigned a form to this report in Assign PDFs to Reports.

You must also:

  • Ensure that the following accounts are entered and properly maintained:

    • Incoming Clearing Accounts

    • Outgoing Clearing Accounts

    • Main Bank Account

    • Accounts for incoming payments that were not included in the statement

    • Accounts for outgoing payments that were not included in the statement

    • Accounts for other amounts not present in the bank statement

  • Ensure that the vendor and customer are entered in the system

Features

After a bank statement has been entered into the system, run this report to gather data for account items and check the account statement for errors. The output will contain the following data:

  • Beginning of period/end of period balances and turnovers for the main bank account and related clearing accounts. The program gathers data from the main bank account and related clearing accounts totals from the GLT0 and BSIS/BSAS tables.

  • Open items of clearing accounts. The program gathers data for clearing account open items from the BSIS and BKPF tables.

  • Unreconciled items. The program gathers data for items that have not been cleared from the BSAS and BKPF tables.

Selection

Make sure you execute the program for the first date of the financial period.

Specify the following information:

  • Incoming Clearing Accounts (range)

  • Outgoing Clearing Accounts (range)

  • Main Bank Accounts (range)

  • Accounts for incoming payments not in Statement (range)

  • Accounts for outgoing payments not in Statement (range)

  • Accounts for other unreconciled amounts (range)

  • Company Code

  • Posting dates

  • Choose which items to include in the output by selecting:

    • Open items

      Only open items under the Clearing Accounts tab and the Unreconciled Items Accounttab, the totals will be calculated by all items inside the selected time period.

    • Cleared items

      Only cleared items under the Clearing Accounts tab and Unreconciled Items Account tab, the totals will be calculated by all items inside selected time period.

      Note Note

      An item will be displayed as cleared if it was cleared by the date when the program is run, even if inside the selected time period it was still open.

      End of the note.

    • All items

      Both open and cleared items will be displayed under the Clearing Accounts tab and the Unreconciled Items Account tab.

Activities

To access this report, on the SAP Easy Access screen, choose Start of the navigation path Accounting Next navigation step Financial Accounting Next navigation step Banks Next navigation step Country Specifics Next navigation step Kuwait Next navigation step Bank Reconciliation End of the navigation path.