Skip to Content
author's profile photo Former Member
Former Member

Report for Cash flow (fund flow from Bank GL)

Hi Expert,

I would like to have your advice on how can I create this type of report? Is it better using Fund Management?

My client is asking on cash flow report in which the report should show all fund (cash at bank) movement. Basically, the report should have 2 main category, which are Cash Inflow / Cash Outflow,for example:

Cash Inflow

- Payment received from customer

- Interest received from FD at Bank

- Other receipts

- Government Subsidy Received

- Government Grant

Cash Outflow

- Payment to vendor

- Finance charge paid to bank (overdraft/loan, etc)

- Operating Expenses

- CAPEX

- Other Payments

For cash inflow, double entries involve to bank GL is as follows:

DR Bank

CR Item listed in cash inflow section, for example: payment received from customer (or CR csutomer), FD interest received (Revenue item of P/L), etc

For cash outflow, double entries involve to bank GL is as follows:

DR Item listed in cash outflow section, for example: payment to vendor (or DR vendor), Payment to non-trade vendor (for asset purchase, etc), Interest paid (expense item of P/L), etc

Questions:

Since my debit or credit leg of my bank account, currently does not have any indicator that can explicitly indicator the nature of my inflow and outflow, how can I produce my report of cash flow show above?

Note: It is extremely heavy for customized ABAP program to extract my bank entry and point back to the opposite leg to find the nature of my inflow/outflow as well.

Kindly advise.

Thanks in advance,

sbmel

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Apr 25, 2011 at 04:41 AM

    Hi

    In ECC 6.0 EhP4 - A new feature has been added inorder to provide such a kind of cash flow report... You need to activate Business Function PSM_FA_CASH..

    Refer this link http://help.sap.com/erp2005_ehp_04/helpdata/EN/42/e34f2c31023ee1e10000000a1553f6/frameset.htm...

    ... Under Business Functions in SAP ERP > Enterprise Busn Func > Accounting > Public Sector management > PSM, Cash basis accounting & Cash flow reporting

    Once you activate it, you will find additional nodes of IMG under SPRO > Public Sector management.....

    This works the same way as Doc Splitting... technically speaking, this new feature is extended arm of Doc Spliting... In Doc Splitting, you assign item Categories to each GL Account.... Similarly, you will assign a "Revenue / Expense Account" to each GL Account.... This R/E Account can be any alpha numeric text.... This R/E account then gets added as a Doc Splittin Char and is populated in every FI Doc that you post

    I have tried this in a test client a year ago and was more or less satisified with it barring some exceptions....

    br, Ajay M

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.