For Israel and Panama localizations, use this window to import an external bank statement from electronic files provided by the bank.
To open the window, choose
In the Process External Bank Statement window, from the G/LAccount 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.Note
If you record transactions from business partner statements, you cannot use the Import from File function.
Note This topic documents fields and other elements in this window that either are not self-explanatory or require additional information. End of the note. |
From the dropdown list, select the file format that matches the electronic file provided by the bank. |
To identify a file from which the data is imported, either specify the complete file name or search for a file on your computer using the Browse button. |
Choose 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 select a file, the table at the bottom of the window displays the information stored in the file. |
Displays the current balance of the selected account as it appears in the Current Balance field in the last row of the external bank statement. |
Displays the date on which the transaction was recorded at the bank. |
Displays the relevant data as recorded in the file received from the bank. |
Displays the cumulative balance of the account. |
Amount according to bank statement. |
Displays the account balance calculated as if the transactions had been recorded in the company database. |
Choose to copy the data displayed in the table into the Process External Bank Statement window. |