Creative BI: Multi-Year Trending on Profit & Loss

January 18, 2014

Due to reasons like convention, technical limitations or just an embrace of statutory financial reporting doubling up as management reporting, profit and loss reports often report on activity for the current and previous years only.

I know that for a start-up or a company that experiences a high degree of change, assessing trends over multiple years is not necessarily helpful to managing the business. But there are many companies who would benefit from having a Profit and Loss  Statement for many years to assess trends in incomes and expenses.

By creatively applying Business Intelligence, we encourage BI professionals to give customers that option and we encourage companies to insist on multi-year Profit and Loss solutions. Below is a basic example of such a solution, accompanied by a graphical representation of the trend.

Screen Shot 2014-01-25 at 12.00.25


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: