Show TOC

Procedure documentationImporting External Bank Statements: Israel and Panama Locate this document in the navigation structure

 

For Israel and Panama localizations, you can import an external bank statement from electronic files provided by the bank. This saves you the time required to manually enter this information.

Note Note

If you record transactions from business partner statements, you cannot use this procedure to import a statement from a file.

End of the note.

Procedure

  1. From the SAP Business One Main Menu, choose  Banking   Bank Statements and External Reconciliations   Process External Bank Statement  .

    The Process External Bank Statement window appears.

  2. To record transactions from a bank statement, from the G/L Account dropdown list select G/L Account. Specify the code of the G/L account for which you want to record the statement and choose the Import from File button.

    The Import External Bank Statement window appears. Current Balance displays the current balance of the selected account as it appears in the Current Balance field in the last row of the G/L account in the Process External Bank Statement window.

  3. From the Bank Format dropdown list, choose the relevant file format of the electronic file provided by the bank.

    Choose the Browse button to search for the file on your computer. SAP Business One displays the path for the selected file in the Data File field. After you choose a file, the table displays the information stored in the file.

    SAP Business One calculates the account balance as if the transactions had been recorded in the SAP Business One database and displays this balance in the Projected Balance field.

  4. To add the data displayed in the table into the Process External Bank Statement window, choose the Read button.