Once you have installed it and activated for each company that you want to use the report, you will see it under Report Class Banking, you may be looking under Report Class General Ledger

Joe

I have installed and activated the extension" Cash Flow Statement Report" but when I go to Reports (Banking) the report is not there.   What else should I do to see this report?
Thank you.

Janusz

Joe

Tested it on a number of companies and works great for me. Think we can offer it on the extensions.

regards

Sorry for only getting back to you now. I think it looks great. Will test it on a number of installation with multiple bank accounts and see what it does.

See it will give you last twelve months which is great. Some might want a from and to date to do the report for  quarter of six months.

Thanks for the development. Will keep you posted.

Just had to make one (temporary) change as I don't have a company logo uploaded - the report threw an error (company logo missing...)

// Company logo setting
// $companylogoenable = true;
$companylogoenable = false;

Once I did that the report loaded without problems.

You may want to test if the company logo is actually present and if not then set

$companylogoenable = false;

That would account for people like myself who don't want to show a company logo.

Another suggestion:

Allow selecting a period say 2nd quarter of the current financial year or a selected month, meaning we need a period from -->> to box (boxes)

Thanks / Frank

I have now made a first draft of the Cash Flow Statement according to your advice. At this stage I have made it as a custom report.

The selection periods are slightly different from your approach. I have made the same selection as the detailed break down reports.

Please download the attached zip file. Unzip it in the modules folder. You will then have a folder called rep_cash_flow_statement.

Go into FA and move to Setup tab, select the install/activate extensions. Select the rep_cash_flow_statement.
After that you must activate it for the Company you are working on.

Now the report should show up in the Banking Reports.

Tell me if we are on the right way

/Joe

I will give it a try. Maybe a banking report or?

Joe

Regards

It will receive all the cash receipts minus the cash payments for each account. The balance would be you positive or negative cash flow. This is not sales on credit or purchases on credit. These will only reflect when you receive payment on those sales or when you pay your supplier.

Depending how you have setup your accounts, will determine how one would write the report.

Let's for example say that you have two bank accounts set up. Bank Account A (Current Account) and Bank Account B (Cash Account).

Need to add all the receipts in Account A for a given period together and then subtract the expenses that was paid from that account.

Then you need to do the same for Account B.

Each account will then have an opening and closing balance and the difference would be you negative or positive cash flow.

To that one need to decide how many periods should be included in this cash flow  report. 1,2,3,4,5,6 periods and the total for those periods. Say from 01/01/20xx to 31/01/20xx would be one period.

------------------------------------------------------------------------------------------
Example:

CASH Flow
    As at 01-Mar-2011
    Account
    October   10 -  November  10    December  10    January   11    February  11    March     11    Total
   
    0.00                   0.00                     0.00                      0.00              0.00              0.00             0.00
       
    Net Cash Flow   
        0.00                   0.00                     0.00                       0.00              0.00              0.00              0.00
    Total Bank Balance   
        0.00                   0.00                     0.00                        0.00               0.00              0.00               0.00

----------------------------------------------------------------------------------------------------------------------------------------------------

Joe