Use this window to record your bank statement. You automatically import or manually enter the transactions listed by your bank so that you can perform internal and external reconciliation.
You can vary the fields and columns displayed in the Bank Statement Details window according to your company’s needs and local business rules.
The fields that appear in the Bank Statement Details window are described below.
To open the window, from the SAP Business One Main Menu, choose
. In the Bank Statement Summary window, specify in the required fields the information appearing in the bank statement header, and then choose either the Create New button for manual processing or the Import from File button for automatic processing.Note
When you right-click a bank statement row and choose Posting Proposal for Row, the row appears as the first row in the window.
Note
When you choose the Posting Proposal for Uncleared Rows button or the Posting Proposal for Row option after right-clicking a bank statement row, SAP Business One proposes transactions with posting dates that are earlier than or the same as the posting date of the bank statement row. If the Posting Date field of the bank statement row is empty, SAP Business One proposes transactions with posting dates that are earlier than or the same as the current system date.
Note
In Belgium, when finalizing a bank statement, all business partner transactions are posted to the bank interim account in separate journal entries, and an additional journal entry is posted to transfer all the business partner transaction amounts from the bank interim account to the bank account. The posting date of the additional journal entry is the value in the Statement Date field in the general area of the Bank Statement Details window, and its reconciliation date is the latest posting date of all the business partner transactions.
The bank statement number optionally entered from the bank statement received. Note After the bank statement is finalized, you can still change the bank statement number. End of the note. |
The value appearing in the Bank field in the Bank Statement Summary window is automatically copied to this field. |
The bank account to which the bank statement is linked. The value appearing in the Account field in the Bank Statement Summary window is automatically copied to this field. To open the House Bank Accounts – Setup window and to view the linked bank account, choose (Link Arrow). |
This field appears only if the Permit More than One Document Type per Series checkbox is selected in tab.This value is copied from the Series column in the Bank Statement Summary window and specifies the numbering series to be used for journal entries, as well as incoming and outgoing payments created through bank statement processing. |
Display the IBAN and BIC/SWIFT code of the selected house bank account. |
G/L account to which the selected bank account is linked. SAP Business One populates this field according to the information defined in the G/L Account field in . |
Displays the automatically-populated sequential row number in the Bank Statement Summary window. |
Specify the date on which the received bank statement was generated by the bank and displayed on the bank statement. The default is the current date. Note After the bank statement is finalized, you can still change the statement date. This change does not affect the statement row date, statement due date, posting date, due date, and document date in the Bank Statement Details window. This change does not affect the period name or the sequential number in the Bank Statement Summary window. End of the note. |
Specify the balance of the bank account before any of the transactions on the bank statement have been taken into consideration. Enter the value as displayed on the bank statement received. The value must match the corresponding field in the Bank Statement Summary window. The default is the ending balance from the previous statement (draft or finalized). |
Specify the balance of the bank account after all the transactions on the bank statement have been taken into consideration. Enter the value as displayed on the received bank statement. The value must match the corresponding field in the Bank Statement Summary window. |
Displays the difference between the cleared balance and the ending balance on the bank statement for the selected transactions. |
Shows the currency information taken from the G/L account’s definition in the Chart of Accounts window. The ## symbol indicates that the G/L account is multicurrency. |
Specify the offsetting G/L interim account to use for transaction posting. The default is taken from the House Bank Account – Setup window. This column is available only when the posting method is Bank Interim Account from/to Bank Account. |
Select this checkbox to clear a bank transaction row or to select a posting proposal line. You can define a transaction row as cleared only if the applied amount as matched in local currency or foreign currency is zero in the case of G/L account postings. In the case of a business partner posting, the difference is posted to the business partner without the payment being based on an existing marketing document. |
Specify the code for the transaction type according to the set of external codes in the External Bank Operation Codes window that are associated with this bank account. This value may have been assigned during setup to an internal bank operation code and may be displayed on the received bank statement. |
Specify the code for the transaction type according to the Internal Code field in the Internal Bank Operation Codes window. This value may have been assigned during setup to an external bank operation code, in which case it will be automatically populated if the external code was selected. Note When the bank file is imported automatically, the bank statement details usually contain only the external bank operation code. If the bank operation code list has not been defined, choose an internal code manually for every bank statement row. End of the note. |
Specify the posting method to be used to create transactions for the bank statement rows associated with the internal operation code on finalizing the bank statement, according to the Posting Method field in the Internal Bank Operation Codes window. The available options are:
|
The posting date of each transaction assigned to the respective row in the bank statement. For a new bank statement row, the default statement row date is the value in the Statement Date field in the general area. |
The posting date of all the transactions created for the bank statement is the posting date assigned to that bank statement. For a new bank statement row, the default statement due date is the value in the Statement Date field in the general area. |
Specify the currency if a statement transaction is recorded as being in a different currency from the default currency. By default the currency is the bank G/L account currency or the local currency if the bank G/L account is an all currency account. |
Specify the exchange rate to apply for foreign currency conversion to local currency, as per the bank statement. |
The matching field for bank statement rows. If the row is a bank statement row, enter a document number or reference, as it appears in the statement. If the row is a posting proposal row, SAP Business One populates this field with the document numbers of proposed documents or the code and name of proposed G/L account postings. |
Specify the financial value for a particular transaction row in the case of an incoming payment. |
Specify the financial value for a particular transaction row in the case of an outgoing payment. |
Specify the financial value of the reduction on a particular transaction (row). |
Specify the amount of VAT included in the particular transaction (row). |
Enter the actual amount that was applied for the particular proposal (row) after the discount amount and VAT amount were taken into consideration. Note For one or more proposals within one uncleared bank statement row, you can choose Ctrl+B to display the following:
This works also in All currency situations. End of the note. |
Default percentage of discount value specified for the business partner. |
8-character additional information from the bank statement. The value is stored in the Ref. 3 field in the journal entry. |
Additional information from the bank statement (254-character limit). Note In Belgium, when finalizing a bank statement, all business partner transactions are posted to the bank interim account in separate journal entries, and an additional journal entry is posted to transfer all the business partner transaction amounts from the bank interim account to the bank account. In the separate journal entry, the values in the Remarks fields (both in the general area and in the expanded editing mode area for all rows) are the values in the Details fields of the proposed bank statement row. In the additional journal entry, the value in the Remarks field in the expanded editing mode area for each interim account row is the value in the Details field of the proposed bank statement row, respectively. The Remarks field in the expanded editing mode area for the bank account row displays Bank Statement and the value in the Bank Statement No. field of the Bank Statement Details window. End of the note. |
Specify the business partner name corresponding to the specified business partner code. |
Specify the code of the business partner whose transactions you want to reconcile. |
Bank details of the business partner whose transactions you want to reconcile. For a bank statement row with the posting method of Business Partner from/to Bank Account, after it is finalized with the business partner bank code and bank account, if this bank code and bank account combination has not been assigned to this business partner before, the combination will appear in the Business Partner Bank Account - Setup window for this business partner. To open this window, from the SAP Business One Main Menu, choose (Choose from List) button next to the Bank Country field. The next time this bank code and bank account combination is entered or imported, if this combination is unique to the business partner, this business partner code will be automatically identified in the BP Code field. tab, and choose theNote In the Netherlands, the bank code is not sent and you can only search the bank account number. End of the note. |
The BIC/SWIFT code of the business partner bank account, as defined in the Business Partner Bank Accounts – Setup window. |
Enter the offsetting G/L interim account to use for transaction posting for the specified business partner. |
Specify the fee charged by the bank for the particular transaction (row). Note This is relevant only for a single bank statement row containing both a transaction amount and a bank fee. If bank fees are presented as separate bank statement rows then this field should not be filled. End of the note. |
Specify the account to which any fee amount charged for a transaction is posted. Note This is relevant only for a single bank statement row containing both a transaction amount and a bank fee. If bank fees are presented as separate bank statement rows, then this field should not be filled. End of the note. |
Specify a distribution rule. |
Specify a project. |
The posting date to be assigned to the transaction. By default, this column is populated according to the definition for the particular bank in Banks – Setup window. |
The due date to be assigned to the transaction. By default, this column is populated according to the definition for the particular bank in Banks – Setup window. |
Enter the date on which the bank statement was generated. By default, this column is populated according to the definition for the particular bank in the Banks - Setup window. If you enter the date manually, it is retained. |
The journal entry number after posting. |
The number of the external reconciliation. |
SAP Business One displays information relating to automatic matching and processing errors. |
Displays the status of each bank statement row:
Note The field is not visible by default. You can set it to visible through the Form Settings window. End of the note. |