How to Do Bank Reconciliation in SAP

Written by victoria gorski
  • Share
  • Tweet
  • Share
  • Email

The SAP bank reconciliation process allows a user to reconcile cash transits daily from the previous day. This process can be used to compare system-shown account holdings with actual account holdings, or compare records against general ledgers and other information. The process can be performed in a number of bank statement formats, though it's usually BAI format, the most popular bank statement format in the U.S. Usually, SAP bank reconciliation processes are performed at the end of the month, but they can be initiated at any time as long as the previous statement is erased.

Skill level:

Other People Are Reading


    Create a BAI File

  1. 1

    Access the transaction by opening "Tools." Select the "ABAP Workbench" and scroll to "Development," then select the "ABAP Editor."

  2. 2

    Enter the necessary details for your company using the "ABAP Editor" tool. The "Field Name," "Program," "Description" and "Action Values" fields must be filled out. Select the green "tick" symbol to continue.

  3. 3

    Select the "General Test Data for BAI Statements and Create Open Items" screen that appears. Fill out the list and enter your desired values. Click on the small boxes next to "EOD," "Generate Items," "Last w/Diff," "With Bank Details," "With Ref. Data," "XBLNR," "Generate Items" and "Specific." All of these fields appear in the described chronological order and are confirmed by a "tick" symbol once selected.

    Fill out the rest of the information with your chosen details --- i.e., "EOD File Name" may be "RECON1." Make sure you select any dates as yesterday's date.

  4. 4

    Click the green arrow to continue. Your BAI file should be displayed and saved on SAP. This BAI file posts the selected items into one of nine clearing accounts for your master account.

    Bank Statement Reconciliation

  1. 1

    Access this process by selecting "Accounting," then selecting "Financial Accounting" from the drop-down menu. Select "Banks," scroll to "Input," scroll to "Bank Statement" and select "Import."

  2. 2

    Open the "Bank Statements" screen and select the BAI file. Select "Import Data" from the list and deselect "Workstation Upload." Type the name of the statement file in the "Statement File" field from the previous step and select the fields "Print Bank Statement," "Print Posting Log" and "Print Statistics."

  3. 3

    Select the green arrow to continue. SAP should now display the bank statement created in the previous section --- the BAI file --- and has now cleared these items to the master account.

Tips and warnings

  • You should already have "House Bank," "EDI Partner Profile," "Account Symbols" and "Posting Rules" configured in SAP beforehand (see Resources).
  • You must delete the previous BAI statement before performing a new bank reconciliation.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.