Cash Flow Statement in TM1

[sfreundschuh]

I need to create an automated Cash Flow Statement in TM1, and have never done this before... Does anyone have any tips and tricks they would share?

Thanks in advance for any help!

Shawn

[afshin]

Hi Shawn,

Must be that time of the year, surprised you have not got a answer yet.

I am not sure what you mean by "automated" but yes creating a Cash Flow statement is fairly easy and can be done in TM1. TM1 can be used to create simple cash flow statements or discounted cash flow statements if you plan to do equity valuation using TM1.

I suggest you have a look at Rules in the TM1 manual ( DB or transfer Data between cubes ) and also searching this forum for IBM Cognos on IBM Blueprints and if I am not mistaken the Strategic Finance has a very good example model that you can learn heaps from.

Cheers

[christianp]

I asked our ERP system guys to create a view of the "other side" of every cash transaction in our ERP system. This involved, for instance, tracing a payment from the bank account to creditors, seeing which invoices that payment was for and recording the general ledger account coding/s for those invoices. We then created a consolidation of general ledger account codes to suit the cash flow statement.

One of the elements in our "balances" dimension (ie opening balance, movement, adjustment, closing balance) allows us to manually fix miscoded invoices.

We use this for a management accounts style cash flow but I am sure that it could also be used for statutory cash flow statements as well.

I hope this helps.

Regards,
Christian