Cash Flow Statement (Page 1 of 2)

Hi, I too am looking for a Cash Flow Report in FA. After a quick search around this forum, I think there hasn't been any active discussion about implementing it.
So please if anybody has any ideas or is already implementing it, please share it here.

kuro

I understand you, but please help us doing this. If some of you will help us with such a report we will incorporate it into release 2.4.

/Joe

Just use one of the other reports as a template.
The reports are in the file /reporting/reports_main.php. They are using an internal number depending of which section it belongs to. F.i. The COA report have rep701.php. You can use the next available number for.
You also see in this file, the various selections you can do on the report.
So create the new report and put it in reports_main.php.

This should do the job. If you run into problems, please don't hesitate to ask again.

/Joe

Hi guys,
Any success on cashflow statement? I really need it so much.

Hi guys,

first post, just installed and configured FA on my webserver (SSL) in an attempt to get rid of the QuickBooks tax and eventually the M$ Windows tax.

FA offers all I need with the exception of a Cash Flow Report.

I am (sort of) familiar with php having contributed a few Zencart plugins and also maintaining the German language pack for the latest ZC 1.5.1

But that is where my php coding capabilities end....

Whilst looking around the web for a php based cash flow report I found this:

http://media.wiley.com/Lux/42/310642.image0.jpg

Basically that is the report needed in FA. Would the FA devs be willing to give this a go.... ??

Thanks

Frank

I have found a resource document here.

Maybe we can use that as a template. What do you guys think?

/Joe

Just curious: has any progress been made with this mod?

Cash Flow statement would be done with the bank and cash accounts setup.

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

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

If this will do the task, I guess it would be quite simple to make the report.

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

Joe

That looks good Joe - certainly fills my requirements. Thank you!

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

Joe

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

regards

The report is already available for install  from our extensions. Thank you for making FA beeter .

Janusz