Month
Legal Entity (or Company...)
Cost Center (or Department, Division...)
Revenues
Operating Costs, COGS
Operating Expenses, OpEx
Depreciations & Amortizations
Interests & Taxes
Current Assets
Current Liabilities
Total Assets
Total Liabilities
- Total Revenues
- COGS
- Gross Margin
- Gross Margin %
- OpEx
- OpEx to Revenues ratio
- Operating Income
- Operating Income %
- Net Income
- Net Income %
- Deprec. & Amort.
- Interests & Taxes
- Current Assets
- Current Liabilities
- Total Assets
- Total Liabilities
- Working Capital
- Working Capital ratio
- Liquidity ratio
- Total Equity
- ROI %
- Debt to income ratio
- Debt to equity ratio
Detailed presentation of the FINANCIAL STATEMENT dashboard
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 (%)
- 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 (%)
- Net IncomeNet Income: Operating Income - (Interests + Taxes)
- Net Income %Net Income / Revenues (%)
- Deprec. & Amort.Amortizations and depreciations are methods of prorating the cost of business assets over the course of their useful life
- Interests & TaxesSum of Interests & Taxes
- 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 (%); Also called 'Current Ratio'
- Liquidity ratioCurrent Liabilities / Current Assets (%)
- Total EquityTotal Assets - Total Liabilities
- ROI %Net Income / Total Equity (%)
- Debt to income ratioTotal Liabilities / Revenues (%)
- Debt to equity ratioHow much debt the company has relative to its investor equity: Total Liabilities / Total Equity (%)
and 11 dashboard pages
Home
Cockpit
Finance Cockpit
Financial KPIs by Company
Financial Statement Top Performers
Financial Analytics
Income Statement - What-if Analysis
Income Statement: Waterfall
Behavioral Analytics
Financial Statement Adhoc Analysis
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!
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):
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).
3rd STEP: Map your attributes
Map the attributes of your workbook on the attributes of the template.
Finally, click 'Confirm & Download'... and your Financial Statement dashboard is already downloading :-)
Open the Tableau workbook file you received, it will automatically reconnect to your data sources.
Your Financial Statement dashboard is now ready to be used or customized!