Navigating the sea of data

Power Pivot consistently amazes me by effortlessly converting raw data into crucial, real-time information—like overdue receivables or extended payment terms—that would otherwise be buried in a sea of data.

Although standard ERP systems have all the data for accounts receivable by customers, checking customer AR balances through ERP involves a snail-like process. Typically this entails keying in the customer code into a field box and checking the balance and aging for the outstanding amounts one by one. Even though the data is all there in the system, for a company with more than several thousand customers, identifying and properly acting upon overdue accounts receivable on a timely basis tends not to be such a quick exercise when using ERP alone.

Everybody who works with Power BI and page tooltips knows that, after period of time the report can be overwhelmed by too many pages and it could be quite a chaos.

In this article I am showing easy an alternative way how to lower number of tooltip pages to minimum and in some cases to only ONE single page!

Many accountants consider cash flow statements to be the most important indicator of a company’s performance, as they do not rely on estimates or judgments by the preparers.

While indirect method cash flow statements can be easily prepared from the P&L and the opening and closing balance sheets, they do not provide much insight into where the money is coming from or going to. Because of this, users of financial statements and accounting standard setters alike (e.g., FASB and IASB) have always preferred the direct method over the indirect method for cash flow statements.