AA21.1.1

Release Date: January 6, 2020

Overview

Minor bug fixes and enhancements.

New Reports 

Cash Reconciliation 

The Cash Reconciliation report is an event-based cash management report available to clients within the multi-tenant environment which reports on cash actions as well as recorded cash and custom tender drops.

Updates to Existing Reports

All Orders

The CSV/XLSX export now includes information previously found on the ‘Rounding Report’ such as the rounding type (Round Up For Charity, Rounding Up Or Down, Round Down, Round Up) and rounded amount.

Cost of Sales

The Cost of Sales report now includes non-chargeable standsheet items as well as chargeable items. In addition, this report will now exclude items where sales equal to 0 (zero sales items).

Inventory Value

The Inventory Value report will now include items that do not have an ingredient or depletion item assigned to them.

Revenue/Open SKU

The ‘Group By’ filter has been moved back to the top.

Bug fixes

• Cost of Sales: The cost of sale value now correctly calculates on the Cost of Sales report.
• Purchase Orders: Purchase order values no longer report incorrect values and should correctly match the original purchase order statement.
• Revenue: To correctly balance with payments, unauthorized authorizations within freedom pay are no longer present on reports. A payment must be completed fully to appear on reports.
• Transfers: The quantity now correctly calculates on the Transfers report.

AA20.2.1

Release Date: December 29, 2020

Overview

This release is a small follow up to Connect 11.0 (AA20.2.0) and includes additional functionality for exports, more revenue standard exports, additional enhanced filters, and bug fixes. AA20.2.1 will finalize our first iteration of Excel for revenue reports as well as revenue filters.

Additional Standard Excel Exports

Two additional standard exports have been added: Sales by Vendor Group and Refunds. Sales by Vendor Group can be accessed through the Sales by Item report and Refunds can be accessed through the Refunds report.

These reports have predefined columns as follows:

Sales by Vendor Group

• Vendor Group
• Primary Category
• Gross Sales
• Subtotal
• Refunds
• Total Discounts
• Net Sales
• Inclusive Tax
• Exclusive Tax
• Tips
• Fees
• Total

Refunds

• SKU
• Unique ID
• Item Name
• Item Price
• Primary Category
• Secondary Category
• Tertiary Category
• Vendor Name
• User Name
• Gross Sales
• Refunds
• Refunded Discounts
• Net Sales
• Refunded Tax % of Sales

Excel Subtotal By Functionality

The Subtotal By functionality allows users to group and subtotal totals on Excel exports. Users will be able to subtotal either vendors or users on the Sales by Item, Revenue, Discounts, and Refunds report. Subtotal options can be selected when configuring Excel options.

Additional Subtotal By options and customizations will be coming in the future.

Additional Enhanced Filters

Users will find even more filters available when loading revenue reports. Filters can be configured before loading data and can be used to filter Excel exports (without rendering the report). We will continue to add more filters in the future.

Minor Changes

• PDF (Legacy) renamed Screen Print on Download options.
  
  
  
  
• When selecting Excel from Download options, users will no longer type in an export name but instead be presented with a drop down choice of available exports for that report.
  
  

 

• The date range selected will be printed on Excel exports.
  
  

Bug fixes

• An issue resulting in an error message being shown even though an Excel export was correctly emailed has been corrected.

AA20.2.0

Release Date: December 7, 2020

Overview

AA20.2.0, set to release with Connect 11.0, is our biggest release so far and will include an entirely updated reporting module, updated reports for all clients, filter enhancements, and new exporting functionality. This will also lay additional ground work for more enhancements to exporting in the future.

• New Reporting Module: Analytics
• Enhanced Filters
• Enhanced Excel Export
• New Available Reports
• Enterprise & Classic Reports
  • Revenue
  • Audit
  • Inventory

General

New Reporting Module: Analytics

As our reporting requirements have evolved, we have continuously added features and visual enhancements to existing modules. As a part of our effort to streamline the user experience of reporting, we have enabled a new module that will serve as the new home for all reports. Users will find Analytics in place of Advanced Analytics when logging into Connect. Selecting the Reports option will take users to a refreshed landing page with some existing features such as Favorite Reports and Report Descriptions as well as some new features such as a Search Bar and Report Type Dropdown.

• The Advanced Analytics module will no longer be available -but don't worry, the reports are just as good; we just want to reserve the term Advanced for some exciting reports coming in the future.
  
  
  
  
• The new landing page has the same functionality such as favorite reports and report details with some additional features such as an added search bar.
  
  
  
  
• Weve made identifying reports easier by adding an icon to visually represent the type of report. Some of these you will recognize from other parts of Connect such as Inventory and Suites reporting.
  
  
  
  
• Accessing reports is just as easy! Simply click on the report to load and you will be directed to the new landing page; now with enhanced filters.

Enhanced Filters

We've been keeping an eye on how users engage with reports and noticed that sometimes having to wait for the report to render and then update filters is a pain. We've enhanced our filters to render separately from the report so a user can select whatever filters they need then render data.

Separating these filters also allow us to connect directly to some of our exporting mechanisms so you can export data without having to wait to render a visualization. Users will find the same filters on reports at the top of the report landing page and notice nothing will render until everything is chosen.

We've started with Revenue and Audit reports, but these filter enhancements will come to other report types in the future.

Filter sets can still be saved to quickly refer to later.

Enhanced Excel Export

Exporting data to Excel has been a frequent request and we are excited to share it's finally available in Analytics. When a user selects Download they will be prompted with some new options.

Export Types

• Excel (New)
• CSV
• IMG
• XLSX (Previously Excel)
• PDF (Legacy)
  
  

Excel Options

1. Enter Export Name
2. Select saved Filter Set or use current filters
3. Toggle Grand Total on/off
4. Export will be emailed to the email associated with your Connect account.
   
   

Export Formatting

• Exports include headers such as the name of the report and when the report was run.
  
  
  
  
• Columns are formatted as currency (not text) allowing for users to easily create custom calculations or sum in Excel.
• Exports include headers such as the name of the report and when the report was run.

         

• Columns are formatted as currency (not text) allowing for users to easily create custom calculations or sum in Excel.

     

New Available Reports

With this release we will be migrating all classic venues to Analytics Reports. Clients will find the same data on these reports in an easier to read, tabular format. Not only will more information be available to clients, migrating to Analytics sets the Classic environment on the same release/maintenance cadence as all other environments resulting in faster bug fixes and standardized release notes.

Please refer to our New Report Mapping for questions about migrating to the new reports.

 

Enterprise & Classic Reports

Revenue

All Orders

The 'All Orders' report displays a detailed breakdown of orders by order ID, venue, vendor, order status, method of tender, and date time. Total represents the total amount paid and should correlate with the total found on Sales by Item. This report is most often used to validate order-level details or used to validate against other reports.

Cash Management

The 'Cash Management' report displays a detailed breakdown of all cash actions performed in the cash management module for a given date range. Details include POS cash sales, cash paid in, cash paid out, expected and deposited cash, and over/short amounts. This report is most often used to monitor bank drops, cash pickups, and other cash operations by individual employees.

Discounts

The 'Discounts' report displays a detailed breakdown of discounts by discount name, vendor name, category, item name, user name, and terminal ID. Total discounts is calculated by item-level discounts (plus) cart-level discounts. This report is most often used to review total discounts by user or item at end-of-day.

Open SKU

The 'Open SKU' report displays a breakdown of items that have the 'Open Item' setting enabled in Connect. The item will prompt a cashier to input price, name, and SKU and if the item is not found, management can identify and add missing items accordingly. This report breaks down these items by vendor name, category, item name, user name, terminal, and hour. This report is most often used to identify items that have not been assigned to the vendor.

Refunds

The 'Refunds' report displays a detailed breakdown of refunded transactions by primary category, item name, vendor name, user name, and terminal ID. The refunded amount is calculated by the price of the item (times) the quantity refunded. This report is most often used to review refunds by item or vendor at end-of-day.

Revenue
The 'Revenue' report displays a detailed breakdown of payments by method of tender, vendor name, user name, and terminal ID. Total represents the total amount paid and should correlate with the total found on Sales by Item. This report is most often used to review payment types, tips and fees, or collected taxes by vendor or user at end-of-day.

Sales by Hour
The 'Sales by Hour' report displays a detailed breakdown of sales by hour by primary category, item name, vendor name, user name, and terminal ID. Total is calculated by subtotal (plus) exclusive tax (plus) tips (plus) fees (minus) refunds (minus) discounts. This report is most often used to review totals sales by item or vendor at end-of-day.

Sales by Item
The 'Sales by Item' report displays a detailed breakdown of sales by primary category, item name, vendor name, user name, and terminal ID. Total sales is calculated by subtotal (plus) exclusive tax (plus) tips (plus) fees (minus) refunds (minus) discounts. This report is most often used to review totals sales by item or vendor at end-of-day.

Sales Summary
The Sales Summary report displays a summary of sales against payments. This is a high-level report most commonly used to reconcile item sales and payments.

Sales by Tax Name
The Sales by Tax Name report displays a detailed breakdown of items sold and associated taxes. Total tax includes inclusive tax (plus) exclusive tax. This report is most often used to review taxes that have been correctly applied to item sales.

Tax Exempt
The 'Tax Exempt' report displays the total tax exempt amount by vendor, user, reason code, tax exempt id, and order id. Tax exemptions are set up in Connect, but cannot be configured per item. The report is most commonly used to review total tax exempt amount or total tax exempt orders for financial reporting.

Audit

Electronic Journal (AX only)
The 'Electronic Journal' displays keystrokes performed by users broken down by vendor, user name, role, manager, and terminal. This report is most often used to identify abnormal behavior by an employee by monitoring actions such as applying discounts or opening cash drawer.

Loss Prevention (AX only)
The 'Loss Prevention' report is used to identify abnormal activities such as excessive refunds, discounts, or cash drawer openings. This report breaks out each action by vendor, terminal, and user by hour. This report is most often used to quickly identify abnormalities in user actions to improve loss prevention.

Tax Configurations
The 'Tax Configurations' report displays all taxes configured in the back office and a breakdown of codes, types, and rates. This report is most often used to audit active tax configurations.

User Configurations
The User Configurations report displays all users and permissions sets set up in the back office. This report is most often used to review user configurations and associated permission set configurations.

Vendor Group Configurations
The 'Vendor Group Configurations' report displays all vendor group configurations set up in the back office and a breakdown of vendors associated with them. This report is most often used to audit active vendor group configurations.

Inventory

Cost of Goods
The Cost of Goods report displays a breakdown by item of gross profit determined by subtracting the cost of units sold from inventory sales. Gross profit is calculated by gross sales (minus) cost of sales. This report is most often used to analyze profit margins for items, based on inventory sales.

Inventory Valuation
The Inventory Valuation report is used to view the value of your inventory on hand quantity by item, broken down by GL Account or category for each warehouse and vendor where inventory is tracked. This report is often used to determine inventory levels and provide periodic inventory value for financial reporting.

Par Level Configurations
The Par Level Configurations report is a listing report of inventory items and their par level restock setup for each location (vendor) that is assigned. The report is used to help manage par restock levels for vendors.

Purchase Orders
The Purchase Orders report shows details of purchase orders made during a given period of time, by distributor, category, or item. This report is most often used to track items and quantity ordered, delivery and supplier invoice matching for accounts payable reconciliation.

Recipe Book
The Recipe Book report is a listing report for how recipe items are built for inventory tracking. The report is most often used to determine ingredient level item mix of recipe items.

Revenue Reconciliation
More info coming soon!

Sales Recap
More info coming soon!

Spoilage
The Spoilage report displays a breakdown by item of waste and comps recorded on standsheets for a given event or period. The report is most often used to analyze and account for item usage not directly related to sales.

Standsheets
The Standsheets report displays a detailed breakdown of inventory counts and transfers used to determine inventory units sold, compared to POS units sold. This report is most often used to review inventory count variances for a given event or period.

Transfers
The Transfers report shows details of transfers generated during a given period of time, by status, category, or item. A transfer is when inventory is moved from one location to another, e.g., from a warehouse to a vendor. The report is most often used to track items and quantity transferred and their associated value based on item cost.

True Up Count Variance
The True Up Count Variance report shows details of inventory quantity variances and is most often used after a True Up Count has been completed for a given event. The report allows users to easily identify items that may not have been counted correctly so that a recount can be requested.

Units Sold Recap
The Units Sold Recap report displays a detailed breakdown of item sold based on the chargeable item counts on standsheets for a given event or period. The report is most often used to analyze performance of sold items by revenue center, based on inventory sales.