/uploads/galerie/000056/BS - Cockpit.PNG

Detailed presentation of the BALANCE SHEET (+BUDGET) dashboard

Your BALANCE SHEET (+BUDGET) dashboard will contain 18 KPIs

  • Current AssetsAssets that are expected to be converted into cash in less than 12 months: Cash, Accounts Receivables, Inventory, Prepaid Expenses
  • Current LiabilitiesBills 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 AssetsThe final amount of all gross investments, cash and equivalents, receivables, and other assets as they are presented on the balance sheet
  • Total LiabilitiesSum of Current Liabilities and Long-Term Debt
  • Working CapitalAmount 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 ratioCurrent Assets / Current Liabilities (%)
  • Liquidity ratioCurrent Liabilities / Current Assets (%)
  • Total EquityTotal Assets - Total Liabilities
  • Debt to equity ratioHow much debt the company has relative to its investor equity: Total Liabilities / Total Equity (%)
  • Current Assets (Budget)Assets that are expected to be converted into cash in less than 12 months: Cash, Accounts Receivables, Inventory, Prepaid Expenses (Budget)
  • Current Liabilities (Budget)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 (Budget)
  • Total Assets (Budget)The final amount of all gross investments, cash and equivalents, receivables, and other assets as they are presented on the balance sheet (Budget)
  • Total Liabilities (Budget)Sum of Current Liabilities and Long-Term Debt (Budget)
  • Working Capital (Budget)Amount of money the enterprise has to work with in the short-term: 'Current Assets' - 'Current Liabilities' (also called 'Net Current Assets' or 'Funds') (Budget)
  • Working Capital ratio (Budget)Current Assets / Current Liabilities (%) (Budget)
  • Liquidity ratio (Budget)Current Liabilities / Current Assets (%) (Budget)
  • Total Equity (Budget)Total Assets - Total Liabilities (Budget)
  • Debt to equity ratio (Budget)How much debt the company has relative to its investor equity: Total Liabilities / Total Equity (%) (Budget)

and 9 dashboard pages

Home

Balance Sheet (+Budget) Home

Balance Sheet (+Budget) Home
Balance Sheet (+Budget) HomeBalance Sheet (+Budget) Home
Get a Home Page for your Balance Sheet (+Budget) dashboard

Cockpit

Balance Sheet Cockpit

Balance Sheet Cockpit
Balance Sheet CockpitBalance 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 (+Budget) Top KPIs Breakdown

Balance Sheet (+Budget) Top KPIs Breakdown
Balance Sheet (+Budget) Top KPIs BreakdownBalance Sheet (+Budget) Top KPIs Breakdown
Get a transverse view on your top 6 Balance Sheet (+Budget) KPIs, split by the dimension of your choice

Balance Sheet (+Budget) Top KPIs Evolution

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

Financial Analytics

Balance Sheet

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

Behavioral Analytics

Balance Sheet (+Budget) KPI Performance

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

Trends Analytics

Balance Sheet (+Budget) Trends Analysis

Balance Sheet (+Budget) Trends Analysis
Balance Sheet (+Budget) Trends AnalysisBalance Sheet (+Budget) Trends Analysis
Visualize the evolution of any of your Balance Sheet (+Budget) KPIs: Trends, Performance & Year over Year

Distribution Analytics

Balance Sheet (+Budget) Segmentation Analysis

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

Balance Sheet (+Budget) Pareto Analysis

Balance Sheet (+Budget) Pareto Analysis
Balance Sheet (+Budget) Pareto AnalysisBalance Sheet (+Budget) Pareto Analysis
Perform a Pareto Analysis on any of your Balance Sheet (+Budget) KPIs: the 80/20 rule.

Creating your BALANCE SHEET (+BUDGET) dashboard Step-by-Step

You want to get a clear understanding on your Balance Sheet (+Budget) results? You want to build a Tableau dashboard to better understand your Balance Sheet (+Budget) data?

Using LinPack-for-Tableau.com, you can generate an eye-catching, fit-for-purpose Tableau Dashboard on your Balance Sheet (+Budget) data in less than 5 minutes!

1st STEP: Create the initial Tableau workbook file

Create a Tableau workbook in which you map your Balance Sheet (+Budget) data (whether it comes from: ERP, database, Excel, CSV file...)

You must retrieve at least the following attributes (it is ok if the names don't match, and it is better to add additional attributes to analyze):

  • date
    Month Month (Date type) (Date used for time-series analysis)
  • string
    Legal Entity / Company Legal Entity, Company
  • string
    Cost Center / Department / Division Cost Center, Department, Division
  • numeric
    Actual - Current Assets Actual: Current Assets
  • numeric
    Actual - Current Liabilities Actual: Current Liabilities [positive value expected]
  • numeric
    Actual - Total Assets Actual: Total Assets
  • numeric
    Actual - Total Liabilities Actual: Total Liabilities [positive value expected]
  • numeric
    Budget - Current Assets Budget: Current Assets
  • numeric
    Budget - Current Liabilities Budget: Current Liabilities [positive value expected]
  • numeric
    Budget - Total Assets Budget: Total Assets
  • numeric
    Budget - Total Liabilities Budget: Total Liabilities [positive value expected]

2nd STEP: Upload your Tableau workbook file

On LinPack-for-Tableau.com, select 'create dashboard from template: Balance Sheet (+Budget)' and upload your Tableau workbook (note: your data is NOT uploaded).

3rd STEP: Map your attributes

Map the attributes of your workbook on the attributes of the template.

Finally, click 'Confirm & Download'... and your Balance Sheet (+Budget) dashboard is already downloading :-)

Open the Tableau workbook file you received, it will automatically reconnect to your data sources.

Your Balance Sheet (+Budget) dashboard is now ready to be used or customized!


Other #DataViz Packs