The Financial Dashboard provides a high level overview of key financial data so that your Accounting Admins and Managers can assess a store's financial standing for a given day, week, month, period, and/or year compared to the same time frame for the previous year without the need to run reports. 


Users with the necessary security access can build out Financial Dashboards for any User by updating their Report Role to include one or more dashboard widgets. These widgets include the following data points:


Note: This is currently only available to Early Adopters.



Security


Users are granted access to viewing the Financial Dashboard from the Report Role Setup screen. Full Access Users or Users with the 'User Setup' Secondary Security Role will have access to this screen.


Users can only gain access to the Financial Dashboard by having their Report Role updated to include Financial Dashboard widgets. To do this, navigate to the Report Role Setup screen and select a Report Role to update.


In the 'Not Available to Report Role' grid, scroll down until 'Financial Dashboard' appears in the 'Category' column. Choose the widgets that Users with this Report Role will have access to by clicking their row. This will remove them from this grid and add them to the 'Available to Report Role' grid. 


Any updates made to the Report Role will be automatically saved.



Navigation



Open the Financial Dashboard by clicking 'Financial Dashboard' under 'Reports' in the Accounting module.



Dashboard Header


The Dashboard header is where the User will select the Locations and Date Range for all widget data. In addition to this, the user can view any action items that need to be completed via My Workflows.



1) Locations - A listing of all Locations assigned to the User. Choose one or all Locations to have their data populate the widgets on the dashboard

2) Date Range - The date range that the data is pulled for. Options include:

  • Today
  • Last 7 Days
  • Last 30 Days
  • This Month
  • Last Month
  • This Period
  • Last Period
  • This Year

3) Showing Dates - The dates that are selected for the date range (#2). This is a read-only field 

4) Greeting and Action Items - A greeting to the User, which may include additional text that lists any action items that need approval from My Workflows. If one or more tasks need to be completed, they will be listed next to the greeting and link out to the User's Active Workflow tab



Profit Widget


The Profit Widget lists the Net Profit for the selected store and for the period defined in the date range selector and compares that against the Net Profit of this store for the same period previous year. This will show if the store is successful and profitable and how its current state compares to last year's numbers.



1) Net Profit Dollar Amount - The Net Profit for the selected date range (Sales – Controllable Expenses – Non-Controllable Expenses) 

2) Net Profit Percentage - The Net Profit for the selected date range ÷ the Net Profit for the selected date range last year. Based on this percentage, it will be displayed in one of the following colors with the corresponding icon:

  • Green - The percentage is < 0%
  • Gray   - The percentage equals 0% or the previous year is not available
  • Red    - The percentage is > 0%

3) Profit After Controllable Amount - The Profit reduced by Controllable Costs (Total Sales – Controllable Expenses)



Gross Profit Margin Widget


The Gross Profit Margin widget displays high level gross profit margins for the period defined in the date range selector compared to the same period for the previous year. Looking at the Gross Profit Margin will help determine how much of a factor current expenses have on each store's profitability.



1) Total Gross Profit Margin Percentage - This shows the percentage of Gross Margin for the current period [((Sales – CoGS Labor) ÷ Sales) x 100%]

2) Total Gross Profit Margin Progress Bar - The percentage of Gross Margin for the current period displayed on a progress bar. Along with this, an icon will be displayed next to the Margin Percentage (#1) as one of the following:

  • Green - The percentage is < 0%
  • Gray   - The percentage equals 0% or the previous year is not available
  • Red    - The percentage is > 0%

3) Total Gross Profit Margin Progress Bar Same Period Last Year - The percentage of Gross Margin for the same period last year displayed as a percentage and on a progress bar. The progress bar will be displayed in one of the three colors: 

  • Green - The percentage is > 0%
  • Gray - The percentage equals 0% or the previous year is not available
  • Red - The percentage is < 0%

4) By Market - This section will provide the Gross Profit Margin Percentages broken down by Location Reporting Category. The following columns will be listed:

  • Location Reporting Category - The Location Reporting Category's name
  • Progress Bar- The percentage of Gross Margin for the current period displayed on a progress bar
    • Green - The percentage is > 0%
    • Gray - The percentage equals 0% or the previous year is not available
    • Red - The percentage is < 0% 
  • Current Gross Profit Margin Percentage - The percentage of Gross Profit Margin for the current period for this Location Reporting Category [((Sales – CoGS Labor) ÷ Sales) x 100%]
  • Last Year's Gross Profit Margin Percentage - The percentage of Gross Profit Margin for the same period last year for this Location Reporting Category [((Sales – CoGS Labor) ÷ Sales) x 100%]



Income vs Cost of Goods Sold Widget


The Income vs Cost of Goods Sold Widget compares the total Income against the Cost of Goods Sold for all CoGS Types and then broken down by CoGS Type. This will help determine if the selected store is bringing in more income than they are spending or if current spending needs to be analyzed for efficiency purposes.



1) Total Income - The total income for the selected date range

2) % Compared to - The total income for the selected date range divided by the total income for the selected date range last year. The following colors/symbols will be displayed based on this percentage:

  • Green - The percentage is > 0%
  • Gray   - The percentage equals 0%
  • Red    - The percentage is < 0%

3) Total Food and Beverage CoGS - The total Cost of Goods Sold for all CoGS Types

4) Food and Beverage CoGS % - This will show a breakdown of the Income in green and the Cost of Goods Sold in red by CoGS Type, which include:

  • F = COGS - Food
  • N = COGS - N/A Beverage
  • B = COGS - Beer
  • W = COGS - Wine
  • L = COGS - Liquor

5) $ Dollar - This will display the Food and Beverage CoGS % (#4) by dollars

6) % Percentage - This will display the Food and Beverage CoGS % (#4) by percentage



Balance Sheet Widget



The Balance Sheet widget includes two sections: Assets and Liabilities/Equity. Each section will be broken down by GL Type and list the total costs of all GL Types at the bottom to help show a high level overview of the selected store's current financial position.



Profit and Loss Widget



The Profit and Loss widget includes three sections: Cost/Expenses, Income/Sales, and Total. The Cost/Expenses and Income/Sales are broken down by GL Type and provide a GL Type Total at the bottom of their sections. The Total section is broken down by Total Profit and Loss and the Profit After Controllable. 


This widget provides some insights into the total of Expenses and Income that play a factor in the overall Net Income.