cash flow statement

Hello
I have little problem
I have three worksheet with cash flows, income, outcome and balance (initial) for four different branches. The cash flows are sorted by days in month. e.g.
initial balance 200
1.2. income $100
2.2. income $ 200 in one sheet for one branche

initial balance 100
3.2. income $50
4.2.outcome $100

how to make one cash flow statement for whole company divided by date
with collums date initial balance income outcome total balance for 1.2.,2.2.,3.2....and othe days of month
somethink with multiple sheet pivot table?

thank you

Hi petkaml,

Welcome to the forum.

I would suggest you to upload a sample file which will help the forum to understand better. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

Hi petkaml,

See the pivot at sheet1 which has the data from Branch 1, 2 and 3. Hope this helps you to start on. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

Ok..

On sheet 1, row 6 column E in the pivot table is 100 000, but B7 is 25 000, which is initial balance for branch 2, I need to sum it up, so B7 should be 125 000

But you can play around by creating an additional column on the right side, see the attachment. Thanks.


Regards,
DILIPandey

<click on below 'star' if this helps>