Bank Book

Bank book is the traditional passbook report required for the purpose of checking payment.

Closing balance as on date in the bank for making the payments, (Sum of incoming, outgoing).

In SAP, such reports are not available on ready basis, so every time we need to take 3 GL and check.

Processing time of payment would be high due to manual check of balances, to reduce the same.

Basic FI module with Bank accounting

Clear visibility for the banking payments and receipts and this report stops the accounts team from releasing the extra payments cheque over and above the bank balance.

It is a very big benefit as the incidence of cheque bounce can be restricted and controlled with this report

Approach:

1. In SAP there are 3 Bank GL are there i.e. Main, Incoming and Outgoing, we will take all the 3 GL accounts for a particular house bank and generate this report.

Assumptions:

1. All the payments are being routed through the SAP Bank outgoing account only of a particular house bank

2. All the receipts are being routed through the SAP Bank Incoming account only of a particular house bank

3. Bank reconciliations being done on a regular basis by the accounts team

Since this is a custom report so any additional requirements would be a challenge

Bank book reports and SOP for running the same with Functional specifications and technical specifications

We have the Report program ready with us and we will copy the program and required parameters in the SAP system to ensure the execution of the report

1 weeks for understanding the current process, account grouping and format discussion

1 week for preparing the solution documents based on the understanding and sign off

2 weeks for Realization and Testing the solutions in the DEV and Quality system of SAP

1 week for moving the TR To Production system and generate bank book report in Production system

This report enable to check the bank balance with incoming and outgoing to be checked on real time basis so any cheque bounce incident would be avoided and it is a great opportunity

One month of development time and 1 week of support with 1 functional and 1 ABAP Resource

M1 – Project start

M2 – Solution Document sign off

M3- UAT Sign off

M4- First month end closing

INR 1,50,000/-

In just 1.5 L we have the complete visibility of bank balance is extremely useful one