Profit & Loss Analytics App
Profit & Loss Analytics App summarizes the revenues, costs, and expenses incurred during a specified time period. Provides information about ability (or inability) to generate profit by revenue increase, cost reduction or both and using the power of Qlik. At the same time it offers a view on your cost centers or business units in deep detail – all available within few clicks.
Identify easily your revenue structure and confront it with history and forecasts. Did you plan well or do you have to got better in budget creating?
Everything about General Ledger data saves time and energy to get the context of other financial statements and enables you to spend more time making the decisions than generating valuable insights.
Overwiev: key KPIs (such as Revenues, Costs, EBITDA) with budget, history and forecasting
PnL Plan: deep drill-down into Profit and Loss Acounts using period and planned values
General Ledger Items: drill-down into GL Items detail such as Factory, Document ID and Description, related Account
Forecast: select from multiple KPIs and evalutes their history, actual status and forecast
Trends and Revenue structure: analyze core Revenue streams and their share in total Revenues
PLUS create your own sheets and objects for sharing with your team
Measures, Dimensions and KPIs
Basic measures: General Ledger Items Count, Items Amout Sum,…
Dimensions: Factories,Centres, Business Units, Main/Sub Accounts, year, month,…
General Ledger Items Dimensions: Accounts, Account Number, Description, Partner ID, Amount,…
Typical Use Cases
KPIs reporting with Factory/Business Unit in detail
Find actual Revenue, Costs and EBITDA values in the context of history and planned budget. How do we stand as a holding company? And do stand particular units and divisions of the Group?
Well, I can see that Division-2 did not hit budgeted revenues for almost all year! Also, Centre-3 didn´t hit last year’s performance. We need to make measures before this turns to a bigger problem. Performance management is now a crucial component of business. Check out the video to see how P&L tackle this within seconds.
Deep drill-down into monthly detail of PnL accounts. How does the company Net Sales look like? And what is the plan?
Preparation for internal or board meetings has never been easier – select Q1 or a specific month with just a few clicks. How much did we pay for Technical Services? Which accounts have been affected and how much?
We see our spending is related only to Q1 month. Was this in a plan?
Cost structure with GL Items detail
Do you prefer a high-level overview or deep insights? As a CFO you need both! Analyze General Ledger Items directly.
Centre-58 related to Factory-6 had the highest spending in January. In Qlik we can easily sort items’ list and filter it for certain Cost Center/Business Unit. Moreover, using Document-ID we can immediately find which users processed this transaction and read their basic description.
Forecasting and its quality
As a manufacturing company, EBITDA is an important indicator of the health of your business. Put in context for certain Factory and Centre for Month-by-Month analysis.
Factory-4 didn’t go well last June, but related Centre-4 had a successful year. What about this year’s budget? Jul and August seem to be really challenging! But what does the forecast say? Even budget looks challenging, we´re on a fast track to hit even higher numbers.
By one click is easy to analyze another KPI – what about Production Revenues and Operating Costs?
Revenues Trends and structure
A manufacturing company has two main Revenue streams – Production Revenues and Sale of Merchandise. In addition, there are also Operational and Financial Revenues.
How does this structure look like for particular divison? Division-3 long term dominates in Production, but between 2012 and 2014. Last year´s Month-by-Month analysis proves the same.
On the other hand, Centre-3 is a long term related to Sale of Merchandise.