Documents for QlikView related information.
Creating a Cash Flow is challenging, but often this is often, really what the Finance Department want to see.
It is challenging because, usually, the General Ledger / Chart of Accounts doesn't provide the details necessary to produce the Cash Flow statement.
Cash Flow Methodology
There are two methods of creating a cash flow, the "direct method" or the "indirect method". The majority of financial statements use the "indirect method":
Indirect method |
---|
Profit before interest and income taxes |
Add back depreciation |
Add back amortization of goodwill |
Increase in receivables |
Decrease in inventories |
Increase in trade payables |
Interest expense |
Less Interest accrued but not yet paid |
Interest paid |
Income tax paid |
Net cash from operating activities |
You will require to determine which General Ledger Accounts are grouped into the various Cash Flow Movements. Some will be from within the "Income Statement" and some are "Balance Sheet" movements.
Here is a simplified example of how to create a Cash Flow statement, with integrated the Income Statement (Profit & Loss) and Balance Sheet.
Explore & Enjoy
Nick Scott.
Discover more on GitHub: GitHub - nicholasscott72/Qlik-DimensionalModelling: A simple development methodology for QlikView ap...
very good example can you please post an example of P&L
The Income Statement is the term now used for Profit & Loss (P&L). Obviously you will need to amend this to the specific requirements of each project.
Nick Scott.
Qlick-iT(Intelligent Technologies) Ltd.
Mobile: +44 (0)7766 490830
email: nick.scott@qlickit.co.uk<mailto:nick.scott@qlickit.co.uk>
Excellent! Thanks a lot for this great contribution!
helpful and informative
Hi Nick
Thank you for your sharing. I just download the QVW file , when i go to the sheet name " Financial Statement " i only can see the top row selection filter , i am not able to view any table or chart ?
where i go wrong ? i am using ver 9.