/uploads/packs/000012/BS - Trends.PNG

 

Presentation

This dashboard page shows the evolution of any of your Balance Sheet KPIs.

For any selected KPI, three visualizations are available:

  • Overall evolution of your KPI
  • Year-over-year
  • Yearly evolution

 

Overall evolution of your KPI

Select one KPI and visualize how it evolves across months:

  • The area shows the monthly evolution of your KPI over the selected period of time
  • The colored line at the top of the area represents the growth % vs previous period

 

Year over year 

Monthly evolution of the KPI you selected, one line per year. This DataViz highlights periodicity in your business.

 

Yearly evolution

One row per year, it shows the monthly evolution of your KPI. This DataViz allows you to easily see the relative values of one month across years.

 

Select KPI

'Select KPI' selector allows you to easily switch from one KPI to another, so you can analyze your data from any point of view.

The list of available KPIs is defined during the configuration of your dashboard in LinPack.

In your Balance Sheet dashboard, you will be able to select the following KPIs:

  • Current Assets Assets that are expected to be converted into cash in less than 12 months: Cash, Accounts Receivables, Inventory, Prepaid Expenses
  • Current Liabilities Bills that must be paid within one year of the date of the Balance Sheet: Accounts Payable, Accrued Expenses, Current Portion of Debt, Income Taxes Payable
  • Total Assets The final amount of all gross investments, cash and equivalents, receivables, and other assets as they are presented on the balance sheet
  • Total Liabilities Sum of Current Liabilities and Long-Term Debt
  • Working Capital Amount of money the enterprise has to work with in the short-term: 'Current Assets' - 'Current Liabilities' (also called 'Net Current Assets' or 'Funds')
  • Working Capital ratio Current Assets / Current Liabilities (%)
  • Liquidity ratio Current Liabilities / Current Assets (%)
  • Total Equity Total Assets - Total Liabilities
  • Debt to equity ratio How much debt the company has relative to its investor equity: Total Liabilities / Total Equity (%)
  • (+ any KPI you want to add to your Balance Sheet dashboard)

 

Filter on Date

This data visualization comes with a filter on the Date value. This feature enables you to focus on the period you are interested in.

You can filter dates at multiple levels: Day, Week, Month, Quarter or Year.

 

Filter your data

This data visualization comes with four top filters:

In your Balance Sheet dashboard, you will be able to filter on:

  • Legal Entity / CompanyLegal Entity, Company
  • Cost Center / Department / DivisionCost Center, Department, Division

Other #DataViz in "Balance Sheet" Pack

Home

Balance Sheet Home

Balance Sheet Home
Balance Sheet Home Balance Sheet Home
Get a Home Page for your Balance Sheet dashboard

Cockpit

Balance Sheet Cockpit

Balance Sheet Cockpit
Balance Sheet Cockpit Balance Sheet Cockpit
Get instant overview of your Balance Sheet KPIs: Total Assets, Total Liabilities, Working Capital Ratio, Liquidity Ratio, Total Equity, Debt to income ratio...

Balance Sheet Top KPIs Overview

Balance Sheet Top KPIs Overview
Balance Sheet Top KPIs Overview Balance Sheet Top KPIs Overview
Get a transverse view on your top 6 Balance Sheet KPIs, split by the dimension of your choice

Balance Sheet Top KPIs Evolution

Balance Sheet Top KPIs Evolution
Balance Sheet Top KPIs Evolution Balance Sheet Top KPIs Evolution
Visualize how your Balance Sheet KPIs are evolving (Month-to-Date, Year-to-Date)

Financial Analytics

Balance Sheet

Balance Sheet
Balance Sheet Balance Sheet
Get an instant overview of your main Balance Sheet KPIs

Behavioral Analytics

Balance Sheet KPI Performance

Balance Sheet KPI Performance
Balance Sheet KPI Performance Balance Sheet KPI Performance
Visualize the overall performance of any of your Balance Sheet KPIs: what is the performance, how does this performance evolve, who contributes to this performance

Trends Analytics

Balance Sheet Trends Analysis

Balance Sheet Trends Analysis
Balance Sheet Trends Analysis Balance Sheet Trends Analysis
Visualize the evolution of any of your Balance Sheet KPIs: Trends, Performance & Year over Year

Distribution Analytics

Balance Sheet Segmentation Analysis

Balance Sheet Segmentation Analysis
Balance Sheet Segmentation Analysis Balance Sheet Segmentation Analysis
Visualize the value of any of your Balance Sheet KPIs, split by the dimension you selected (market share analysis)

Balance Sheet Pareto Analysis

Balance Sheet Pareto Analysis
Balance Sheet Pareto Analysis Balance Sheet Pareto Analysis
Perform a Pareto Analysis on any of your Balance Sheet KPIs: the 80/20 rule.

Other Packs