Integration of Bank Statements
To help the cash manager to get an overview of the cash flow in the company, bank statements are also integrated into One Exposure when:
They are imported with the status “do not post” because they are operationally relevant to another system.
They are imported, but no posting is carried out due to problems in account determination.
They are not imported in chronological order. It is then not sufficient to consider only the accounting documents to determine the bank account balance.
Date and Amount
The transaction date and amount are determined based on the bank statement item and bank statement value date.
Example
The following examples illustrate how information from bank statements is recorded in One Exposure:
A bank statement with date 24.02.2016 is imported with opening balance 1000 and closing balance 1100. The bank statement lists one item with the value date 23.02.2016. In One Exposure the system now creates one flow with transaction date 23.02.2016, which represents the incoming bank cash of the item, and two flows with transaction date 24.02.2016, which represent the transition from incoming bank cash to incoming confirmed bank cash.
Bank Statement
Opening Balance: 1000
Closing Balance: 1100
Date: 24.02.2016
Items:
Value Date
Amount
23.02.2016
100
One Exposure
Date
Flow Type
Amount
23.02.2016
900014 - Incoming Bank Cash Increase
+100
24.02.2016
900015 - Incoming Bank Cash Decrease
-100
24.02.2016
900006 - Incoming Bank Confirmed Cash Increase
+100
If errors occur during data upload, the system collects these errors in an application log. You can access it with transaction code FQM_APPLICATION_LOG
.
Activities
IMG Customizing Activities
Assign Planning Levels to Flow Types
The system fills the planning level, if the planning level is assigned to the flow types the system uses.
Bank Statement Information | Default Flow Types |
|---|---|
Bank Statement | 900006 - Incoming Bank Confirmed Cash Increase 900008 - Outgoing Bank Confirmed Cash Increase 900014 - Incoming Bank Cash Increase 900015 - Incoming Bank Cash Decrease 900016 - Outgoing Bank Cash Increase 900017 - Outgoing Bank Cash Decrease |