The following Guide details the reporting capabilities of the Data Genie within the Clubessential Office product.
To begin select the desired view
Pick the date range you would like to pull into the Genie (NOTE: Depending on the view and club activity the view can contain 100s of thousands of records.)
Chose values based on desired analysis, and avoid pulling in too much data at once.
Once you have the view selected, on the top of the Genie interface are a series of available columns. Simply Drag-and-Drop a column to either the left side (row results) or top side (column results) to begin. Don’t be afraid to experiment, this data is completely read-only.
For advanced view, select multiple columns on the left or top side to enable drill-down analysis.
When there is significant transaction detail it can often be worthwhile to pre-filter the data before pulling from the database. Select the “Add Filter” button to customize your data retrieval based on any combination of filters and search criteria. These filters will be applied at the database level and help reduce load times and memory usage locally.
When completed the user can save their layout, print or export the layout using the tool bar at the top.
Additional automatic charting is available at the bottom of the screen based on currently highlighted records.
The Genie provides detailed pivot-table reporting based on select views of data from your system. The following list details available views:
This view contains all sales transactions for the entire system with only summary data. This view is suitable for analysis of ticket trends and can include gratuity and cover counts.
Sales Summary with Line Item Detail:
This view contains all sales transactions for the entire system with additional drill down to the ticket detail level. This view is suitable for analysis of line item sales detail but does not contain gratuity or covers information.
Sales Summary with Settlement Detail:
This view contains all sales transactions for the entire system but only shows the total values of the tickets based on settlement type. This view is suitable for analysis of tender activity at the club.
Employee Hours Worked:
This view contains all timekeeping transactions for the entire system.This view is suitable for analysis of labor hours and wages. NOTE: This view does not include wage calculations for overtime.
This view contains all posted General Ledger transactions.
This view contains information about all billings generated using the month end wizard. This view is suitable for analysis of billing, minimum or late fee trends.
This view contains information about all member payments captured by the system. This view is suitable for analysis of member payment cash flow detail.
This view contains information about all member guest visits to the club. This view is suitable for analysis of guest activity.
This view contains all purchase information from posted AP invoices and credit memos. This view is suitable for analysis of expense history, reciprocal member charges, and inventory purchases.
Golf Play Detail:
This view contains all sales transactions of item flagged in the system as a “Golf Round”. This view is suitable for analysis of golf rounds and cart activity billed through the POS system regardless of Tee Sheet being used.
Once you have configured a view to your liking, the user can save that view using the Save, Save as New and Load Layout options. This allows a quick jump back to a previously configured Genie report.