Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.

Cash Flow Statement (with Income Statement & Balance Sheet)

nick_scott
New Contributor III

Cash Flow Statement (with Income Statement & Balance Sheet)

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.

github.png

Discover more on GitHub: GitHub - nicholasscott72/Qlik-DimensionalModelling: A simple development methodology for QlikView ap...

Attachments
Comments
m_irfan360
Contributor

very good example can you please post an example of P&L

nick_scott
New Contributor III

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>

santiago_respane
Valued Contributor

Excellent! Thanks a lot for this great contribution!

beck_bakytbek
Valued Contributor III

helpful and informative

paulyeo11
Valued Contributor II

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.

Version history
Revision #:
1 of 1
Last update:
‎10-02-2013 06:10 AM
Updated by: