Business dashboard template: FINANCIAL STATEMENT

dashboard template for tableau on Corporate Finance Finance Financial Statement cockpit

Providea workbookcontaining at least11 attributes

Geta ready-to-use,best-in-marketFINANCIAL STATEMENT dashboard

Financial Statement Home

Get a Home Page for your Financial Statement dashboard

Finance Cockpit

Clear picture on your Financial performance: Income Statement (P&L: Revenues, Margin, Opex, Operating Income...), Balance Sheet (Assets, Liabilities, Working Capital, Liquidity...)

Financial KPIs by Company

Get instant overview of your Finance KPIs split by Company: Total Revenues, Gross Margin%, OpEx, EBIT%, Working Capital, Liquidity ratio, Total Equity, Debt to equity ratio, ROI%

Income Statement

Get an instant overview of your main Profit & Loss KPIs

11 required attributes

Month
Company
Revenues
Operating Costs, COGS
Operating Expenses, OpEx
Depreciations & Amortizations
Interests & Taxes
Current Assets
Current Liabilities
Total Assets
Total Liabilities
...add your own attributes!

10 dashboard pages

Required Attributes

To get your Financial Statement dashboard, you need to provide a Tableau workbook file with (at least) the following 5 attributes (the name of your attributes can differ):

Month Month (Date type) (Date used for time-series analysis)
Company Legal Entity, Company, Cost Center...(or any level of detail of your choice)
Revenues Sales, Revenues
Operating Costs, COGS Operating Costs, COGS (Cost of Goods Sold) [positive value expected]
Operating Expenses, OpEx Operating Expenses, OpEx [positive value expected]
Depreciations & Amortizations Depreciations + Amortizations [positive value expected]
Interests & Taxes Interests + Taxes [positive value expected]
Current Assets Current Assets
Current Liabilities Current Liabilities [positive value expected]
Total Assets Total Assets
Total Liabilities Total Liabilities [positive value expected]

KPIs

Your Financial Statement dashboard will contain 23 KPIs

Total RevenuesSum of Revenues
COGSCost of goods sold (COGS, also known as 'Cost of Sales') refers to the direct costs attributable to the production of the goods sold in a company. This amount includes the cost of the materials used in creating the good along with the direct labor costs used to produce the good. It excludes indirect expenses such as distribution costs and sales force costs.
Gross MarginAmount left over from Revenues after Costs of Goods Sold are subtracted (also called 'Gross Profit'): Revenues - COGS
Gross Margin %Share of Gross Margin on Total Revenues: Gross Margin / Revenues (%)
OpExOperating Expenses: Expenditures (that is, cash out) that a company makes to generate income (also called 'SG&A Expenses'): S&M Expenses, R&D Expenses, G&A Expenses
OpEx to Revenues ratioShare of Operating Expenses on Total Revenues: OpEx / Revenues (%)
Deprec. & Amort.Amortizations and depreciations are methods of prorating the cost of business assets over the course of their useful life
Operating IncomeEarnings before interest and taxes -> profits before taking away interest charges and tax payments: Gross Margin - (OpEx + Depreciations + Amortizations)
Operating Income %Share of Operating Income on Total Revenues: Operating Income / Revenues (%)
Interests & TaxesSum of Interests & Taxes
Net IncomeNet Income: Operating Income - (Interests + Taxes)
Net Income %Net Income / Revenues (%)
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
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 (%); Also called 'Current Ratio'
Liquidity ratioCurrent Liabilities / Current Assets (%)
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
Total EquityTotal Assets - Total Liabilities
Debt to equity ratioHow much debt the company has relative to its investor equity: Total Liabilities / Total Equity (%)
Debt to income ratioTotal Liabilities / Revenues (%)
ROI %Net Income / Total Equity (%)

Dashboard Pages & Data Visualizations

Your Financial Statement dashboard will contain 10 pages

Home

Financial Statement Home

Get a Home Page for your Financial Statement dashboard

Cockpit

Finance Cockpit

Clear picture on your Financial performance: Income Statement (P&L: Revenues, Margin, Opex, Operating Income...), Balance Sheet (Assets, Liabilities, Working Capital, Liquidity...)

Financial KPIs by Company

Get instant overview of your Finance KPIs split by Company: Total Revenues, Gross Margin%, OpEx, EBIT%, Working Capital, Liquidity ratio, Total Equity, Debt to equity ratio, ROI%

Financial Analytics

Income Statement

Get an instant overview of your main Profit & Loss KPIs

Income Statement: What-if Analysis

Easily perform simulations and what-if analysis on your Top P&L KPIs

Income Statement: Waterfall

Waterfall visualization of your Income Statement: unpack financial trends and understand drivers of change over time

Income Statement: Annual Report

Visualize the monthly values of all your income Statement KPIs

Balance Sheet

Get an instant overview of your main Balance Sheet KPIs

Behavioral Analytics

Financial Statement Adhoc Analysis

Perform simple ad-hoc analysis on your Financial Statement data set: analyze any of your KPIs across any dimension (trends, distribution and pareto analysis)

Financial Statement KPI Performance

Visualize the overall performance of any of your Financial Statement KPIs: what is the performance, how does this performance evolve, who contributes to this performance

Creating your FINANCIAL STATEMENT dashboard Step-by-Step

You want to get a clear understanding on your Financial Statement results? You want to build a Tableau dashboard to better understand your Financial Statement data?

Using LinPack-for-Tableau.com, you can generate an eye-catching, fit-for-purpose Tableau Dashboard on your Financial Statement data in less than 5 minutes!

Financial Statement dashboard Live Demo

1st STEP: Create the initial Tableau workbook file

Create a Tableau workbook in which you map your Financial Statement 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):

Month Month (Date type) (Date used for time-series analysis)
Company Legal Entity, Company, Cost Center...(or any level of detail of your choice)
Revenues Sales, Revenues
Operating Costs, COGS Operating Costs, COGS (Cost of Goods Sold) [positive value expected]
Operating Expenses, OpEx Operating Expenses, OpEx [positive value expected]
Depreciations & Amortizations Depreciations + Amortizations [positive value expected]
Interests & Taxes Interests + Taxes [positive value expected]
Current Assets Current Assets
Current Liabilities Current Liabilities [positive value expected]
Total Assets Total Assets
Total Liabilities Total Liabilities [positive value expected]

2nd STEP: Upload your Tableau workbook file

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

Collapse All Expand All