Bank Statement Types and Multi-Division Customer Receipts

This document provides a brief overview of bank statement types and how customer receipts from several divisions can be managed on the company (central) level in the Automatic Bank Statement module.

Bank Statement Types

A bank statement type identifies the type of electronic bank statement to process. The bank statement type is selected in ‘Additional Information. Structure’ (ABS930), and also, when registering transactions from a bank statement manually, in ‘Bank Statement. Open’ (ABS100).

These bank statement types exist:

Type 1 – Regular Bank Statement

A regular bank statement can contain both supplier payments and customer receipts.

An account entry is created for the bank statement based on accounting rule AB10–370.*

Type 2 – Payment Specification

In some areas, the bank statement includes one line for all customer receipts and/or one line for all supplier payments. A separate payment specification declares all the individual records of payments made by a customer or supplier and the corresponding invoices. The information enhances the allocation of invoices to bank statement lines.

An account entry is created for the bank statement based on accounting rule AB10–374 (bank in transit).*

Type 3 – Customer Receipts

This third bank statement type refers to an electronic bank file with customer receipts only. This type of file does not contain any opening or closing balances, so the fields for those balances are not displayed when you work with the file header in ‘Bank Statement. Open’ (ABS100/F).

An account entry is created for the bank statement based on accounting rule AB10–370.*

If you select alternative 3 in (ABS930), you must also select alternative 1 (Accounts receivable) in the ‘AR/AP payment’ field in the same program.

* Whether account entries are created for the bank statement as a whole or for each total per bank statement line is defined in ‘Bank Account Identifier. Open’ (ABS900).

Multi-Division Customer Receipts

On the company level (that is, the central level), you can accept to process customer receipts belonging to another division than the current one by selecting the ‘Customer receipts from multiple divisions’ check box in ‘Bank Account Identifier. Open’ (ABS900). The customer receipts are then automatically allocated independently of the division in the bank statement

Prerequisites

These two prerequisites must be met for multi-division customer receipts to work:

The reason for the second prerequisite is that transactions are created in several divisions. The FAM functions retrieve the voucher number and control the date limits defined for each division. The receiving division, which is the division in the bank statement header, receives the payment, whereas the division for the bank statement line is the division of the invoice.

When Local Currency Differs

If the local currency of the company is different than the one used by another division, the invoices receives line status 5 in ‘Bank Statement. Open Line Details’ (ABS102/E). These invoices must be processed manually, for example, by booking them as on-account payments for the customer in the receiving division. The invoice and the on-account payment are then matched manually in ‘Payment Received. Record’ (ARS110) in the appropriate division.

The ID of the original division (the division of the invoice) is also displayed on the same panel.

Account Entries

These accounting rules are used to create account entries for multi-division customer receipts:

Example:

In the receiving division AAA, these account entries are created:

In division BBB, these account entries are created:

Related topics