Dashboards

This excel template is built to provide an overview to the user about the key financial information of the business. The user can add the data and other relevant details as per their business and, it will populate the graphical representations and figures in the dashboard sheet to give an analytical insight into the business.

Financial statements are a useful tool in analyzing the company’s financial position and performance. They are comprised of four main components, of which the balance sheet and the income statement are essential. The first item to consider when looking at a set of financial statements is whether these are external financial statements or internal financial statements.
External financial statements are issued for external reporting purposes. They are for investors, tax authorities or other significant partners who require financial information. External financial statements are normally produced on an annual basis, although in some cases (including for public companies) they are produced quarterly. To ensure comparability and consistency, external financial statements are usually based on Generally Accepted Accounting Principles (GAAP), which has specific requirements that must be followed.
Internal financial statements are more flexible than external financial statements and have a higher analytical component. They may report by division, have more detail or be produced on a more frequent basis (weekly, monthly or quarterly).
A set of financial statements is comprised of several statements, some of which are optional. If the statements are prepared or reported by an external accountant, they will begin with a report from the accountant. This will be followed by the two essential financial statements:
• The balance sheet (sometimes also known as a statement of financial position)
• The income statement (which may include the statement of retained earnings or it may be included as a separate statement)
The balance sheet and the income statement are usually followed by the cash flow statement and notes to the financial statements.
Generally, external financial statements are prepared on the accrual basis of accounting, which means that assets and liabilities are recorded when they are committed to, and revenue and expenses are recorded when they are incurred (rather than when they are actually paid).
The sheet named dashboard in the document contains all the visuals are populated on the basis of the data provided. In order to analyze the performance of the business, the user require to update the actual balance sheet of the business of the specific period. This dashboard will be very useful to the CFO and other stakeholders to understand the performance of the business in a particular month, or year.