Statistical Accounts are non-financial accounts that can be used to track operational information, such as the number of Employees, number of tables/seats, and guest count, among others. Once created, Stat Accounts can be posted to through the normal Journal Entry process; however, when a Stat Account is used, there will be no distribution for that detail as Stat Accounts do not post to the General Ledger.
Statistical Accounts are also available on budgets so that reports can be created to include their transactional and budget data. When used, Stat Accounts allow Operational data to be added to Financial Reports, such as Custom Financial Reports (Trial Balance and P&L reports), which include both Actuals and Budget information for each Stat Account, and other Account-specific reports within 'My Reports', such as the Trial Balance, GL Account Detail, Account Balance by Location, and Transaction Detail Export reports.
It is important to note that since Stat Accounts do not post to the General Ledger, they are one-sided entries and will not need to balance, and they can be entered in both open and closed periods.
As of now, Guest Count and Transaction Count are the only Default Stat Accounts in the system that are automatically updated daily via a DSS Journal Entry. However, additional Stat Accounts can be created manually via the Import Tool. Click here to learn how to import Statistical Account data.
Stat Account Recommendations
The following are Stat Account Recommendations:
- Guest Count
- Labor Hours
- Average Check
- Square Footage
- Number of Seats
- Customer Survey Scores
- Average Time at the Window
- Number of Employees
Statistical Account Record
Since a Stat Account is a non-financial account, it does not need to be grouped by a GL Type. Therefore, the GL Account record is structured differently for Stat Accounts.
To create a Stat Account, hover over 'Account' in the top ribbon and click 'New Account'. A new window will open where the details of the Stat Account can then be entered. When the 'Stat Account' checkbox is checked, the 'Parent Account' and 'GL Type' fields will be replaced with the fields listed below.
1) Stat Account Type - The way in which information is pulled for this account. This information is usually predetermined based on the selected GL Type, but since a Stat Account does not post to the General Ledger, the User needs to classify this type. The following are the options used to designate the account type:
- Net Change - The total change made within a selected time frame. An example of this would be the total Guest Count from a chosen date range
- Balance - The balance of the account. An example of this would be the current number of Employees
2) Better / Worse Direction - The manner in which the variance is displayed within Custom Financial Reports when a Stat Account is used with a Better/Worse Column Type. On non-Stat Accounts, this is determined by GL Type. The following are the variance options:
- Base - Comparison- When the Stat Account is used with a Better/Worse column, it will take the column set as the Base Column and subtract it from the Comparison column
- Example: Use this for Guest Count, or something similar to it, so that if an Actual Column is set as the base and a budget column is set as the comparison, then a Guest Count higher than budget will display as positive
- Comparison - Base- When the Stat Account is used with a Better/Worse column, it will take the column set as the Comparison column and subtract it from the Base column
- Example: Use this for Labor Hours, or something similar to it, so that if an Actual Column is set as the base and a budget column is set as the comparison, then Labor hours higher than budget will display as negative
Note: Stat Accounts can also be created via the Import Tool and Setup Assistant.