Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER

Cash Flow Statement (with Income Statement & Balance Sheet)

Contributor III
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
Creator
Creator

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

0 Likes
Contributor III
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>

0 Likes
Specialist
Specialist

Excellent! Thanks a lot for this great contribution!

Master
Master

helpful and informative

0 Likes
Master
Master

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.

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