Bank Statement Details Window

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 Banking Bank Statements and External Reconciliations Bank Statement Processing . 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 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.

End of the note.

Note 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.

End of the note.

Note 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.

End of the note.

General Area

Bank Statement No.
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.

Bank Name
The value appearing in the Bank field in the Bank Statement Summary window is automatically copied to this field.

Bank Account
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).

Series
This field appears only if the Permit More than One Document Type per Series checkbox is selected in Administration System Initialization Company Details Basic Initialization 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.

IBAN, BIC/SWIFT Code
Display the IBAN and BIC/SWIFT code of the selected house bank account.

G/L 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 Administration Setup Banking House Bank Accounts .

No.
Displays the automatically-populated sequential row number in the Bank Statement Summary window.

Statement Date
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.

Starting Balance
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).

Ending Balance
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.

Difference
Displays the difference between the cleared balance and the ending balance on the bank statement for the selected transactions.

G/L Account Currency
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.

Interim Account
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`.

Row Details

Cleared/Selected
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.

Operation Code

External Code
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.

Internal Code
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.

Posting Method
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: G/L Account from/to Bank Account – indicates the following: A journal entry between the bank account and specific G/L accounts is created. External reconciliation takes place between the bank statement row and the bank G/L account posting. Business Partner from/to Bank Account – indicates the following: An incoming or outgoing payment from or to the business partner is created. Internal reconciliation takes place on the business partner side (if matching rules have been activated and matched records have been selected for reconciliation). External reconciliation takes place between the bank statement row and the bank G/L account posting. Bank Interim Account from/to Bank Account - creates a journal entry that may be internally reconciled on the interim bank account side (subject to matching criteria settings), and externally reconciled on the bank account side. External Reconciliation – indicates that only external reconciliation is to be performed on the bank account side, but that no transaction is posted. Ignore – does not process any of the automatic actions described above – if associated with a bank statement row, that row is recorded as being part of the bank statement. It effectively acts as a text line.

Dates from the Bank Statement

Row Date
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.

Due Date
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.

Currency Details

Payment Currency
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.

Exchange Rate
Specify the exchange rate to apply for foreign currency conversion to local currency, as per the bank statement.

G/L Account/ Doc. Identification No.
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.

Payment Currency Amounts

Incoming Amt
Specify the financial value for a particular transaction row in the case of an incoming payment.

Outgoing Amt
Specify the financial value for a particular transaction row in the case of an outgoing payment.

Discount Amount
Specify the financial value of the reduction on a particular transaction (row).

VAT Amount
Specify the amount of VAT included in the particular transaction (row).

Applied Amount
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: When the balance due of the bank statement row is larger than the balance due of the proposed transaction minus the discount amount, this field displays the balance due of the proposed transaction minus the discount amount. When the balance due of the bank statement row is smaller than the balance due of the proposed transaction minus the discount amount, this field displays the balance due of the bank statement row. This works also in multi-currency situations. End of the note.

Default Discount %
Default percentage of discount value specified for the business partner.

Additional Details

Reference
8-character additional information from the bank statement. The value is stored in the Ref. 3 field in the journal entry.

Details and Details 2
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.

Business Partner Details

BP Name
Specify the business partner name corresponding to the specified business partner code.

BP Code
Specify the code of the business partner whose transactions you want to reconcile.

BP Bank Code, BP Bank Account, BP IBAN
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 Business Partners Business Partner Master Data Payment Terms tab, and choose the (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. Note In the Netherlands, the bank code is not sent and you can only search the bank account number. End of the note.

BP BIC/SWIFT Code
The BIC/SWIFT code of the business partner bank account, as defined in the Business Partner Bank Accounts – Setup window.

Interim Account
Enter the offsetting G/L interim account to use for transaction posting for the specified business partner.

Fee

Amount
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.

Account
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.

Distr. Rule
Specify a distribution rule.

Project
Specify a project.

Dates for Posting Creation

Posting Date
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.

Due Date
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.

Document Date
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.

Journal Entry
The journal entry number after posting.

External Recon.
The number of the external reconciliation.

Log
SAP Business One displays information relating to automatic matching and processing errors.

Source
Displays the status of each bank statement row: `Imported` - the bank statement row was imported from a bank file with no adjustments, except for possible value changes in the Cleared/Selected or the BP Code field. `Imported and Amended` - the bank statement row was imported from a bank file and values were manually adjusted in fields other than the Cleared/Selected and the BP Code fields. `Manually Entered` - the bank statement row was not imported but manually entered. Note The field is not visible by default. You can set it to visible through the Form Settings window. End of the note.