About the new Multi-Location Item Sales Report

Why deliver a new report? We've improved some features, such as updating the date-picker, to be easier to use and focus on the most-used selections. We streamlined some metrics based on real customer feedback and usage. Most importantly, we've introduced some fun new items like at-a-glance tiles providing a high-level view and improved default metrics. Plus, the ability to include multiple businesses/outlets in one PMIX/Item Sales report!

Jump to:

Navigation - How to Find the Multi-Location Item Sales Report

In your navigation pane, you'll find the new report, labeled Multi-location Item Sales in the Sales section, under the existing Item Sales Report. Note that this report can include multiple businesses or properties, but presents results aggregated as a single list, so it does not appear with Group reports.

How to Run the Multi-Location Item Sales Report

The date filter is now located above the report generator with important contextual dates. Now, it’s even easier to select a common date range, such as yesterday, WTD, MTD, or YTD with our quick filters. Just Click and Go!

This report allows you to include multiple businesses. You can see all outlets at your property in one Item Sales Report, or all Grab ‘n’ Go concepts across your whole organization.
We now automatically group your business by property, reducing the time needed to manually select businesses to see item sales for your whole property, simply select your property and all outlets will be included.
Property (where eligible) is now built into the location filter, to allow hotel customers to evaluate their item sales at the property level, without running multiple reports.

The report will return POS Items rolled up by order type, meal period, and category. Select which category type you would like to see: Global, Major, or Minor.

Remember, Major and Minor Categories come from your POS, and Avero adds Global Categories for your convenience. You might have a Minor Category for Salads, which rolls up to a Major Category of Appetizers, in the Global Category of FOOD. Selecting Category Type allows you to choose how granular you want this report to be!

The Multi-Location Item Sales Report can be filtered by:

Revenue Centers
Order Types
Meal Periods
Categories at each level(Global, Major, or Minor)

All available values from the selected businesses will be available to include/exclude. If you don't see a value in the filters you expect, check the date and business selection - if the value is not present in the data for the selected businesses for the selected dates, it will not be available as a filter.

Running the Multi-Location Item Sales Report by Business

How to run:

Select your date range from the quick-clicks
Check Businesses to include
Filter to only specific:
- Revenue Centers
- Order Types
- Meal Periods
- or leave All selected
Choose a Category Level (Global, Major, or Minor) - determines how the report displays
Filter to only specific Categories or leave all selected
Click RUN!

Running the Multi-Location Item Sales Report by Property

A Property is a single location with a group of businesses, such as a hotel, casino, or food hall. Properties are represented by a Property Code, or initialism, and selecting a property in your report will include all businesses at that property/location.

If you want to view only specific outlets from a property, run the report by Business instead.

How to run:

Select your date range from the quick-clicks
Check Properties to include
Filter to only specific:
- Revenue Centers
- Order Types
- Meal Periods
- or leave All selected
Choose a Category Level (Global, Major, or Minor) - determines how the report displays
Filter to only specific Categories or leave all selected
Click RUN!

How to View and Interpret the Item Sales Report

Viewing the new Item Sales Report will be slightly different from our previous report.

You'll still be able to collapse/expand categories and sort the tables to efficiently digest the data in your reporting:

Tiles

Above the table report, you'll now see Tiles. These are contextual, high-level information available at-a-glance. Quickly see the number of checks or covers and high-level sales information. The full report is available in the table below.

Improved Default Metrics

We've updated the automatically included metrics to feature the most-requested and best-loved metrics from our existing reporting and reduced the setup to get you a report so you can hit the ground running with your findings.

The new Item Sales Report will automatically include the following metrics:

Quantity Sold: The number of items sold in the time frame of the report, across all included businesses
Item/Cover %: This refers to 'popularity', out of all covers served in the included timeframe, what % ordered this item? 50% means half of all guests served ordered this item. 200% means all guests served ordered two of these items (such as multiple glasses of the same wine).
Average Item Price: The average price this item was sold for, across all sales in the included timeframe of the report, across all included businesses
Gross Sales: The total amount of revenue associated with this item or category's sales during the timeframe of the report, across all included businesses
Net Sales: The sales revenue for this item or category, less discounts/comps/promotions, across all included businesses

Frequently Asked Questions about Multi-Location Item Sales Report

What does Multi-Location mean? Is it different from Group?

Multi-location means this Item Sales Report runs and displays item sales across multiple businesses (or outlets, venues, locations) or entire properties. In the Multi-Location Item Sales report, data for the selected businesses/properties all roll up into a single report. Allowing you to view your item sales in aggregate - in a single list - for all the included businesses.

Our Group Item Sales Report also allows you to view item sales across multiple businesses or properties but displays the results broken out by the individual business or property- so you can compare the outlets or locations against each other

Item Sales for all businesses in one list = Multi-Location Item Sales Report
Item Sales for all businesses listed individually by business or property = Group Item Sales Report

How can I learn to use this report?

Training for any Avero report is available in the big, purple question mark in the bottom right-hand corner of your Avero screen. Select Training and search for Multi-Location Item Sales!

Can I export this report?

Of course! You'll notice a download icon in the top-right of your report. This will download the report results into an easy-to-use CSV file.

Can I view my historical data in the Multi-Location Item Sales Report?

Only data from July 1, 2022 to current day is included in the new Multi-Location Item Sales Report. Older hisotrical data must use the single-location Item Sales Report or the multi-location Group Category & Item Sales Report

Why does the Multi-location Item Sales Report show our sales in US Dollars when we use local currency?

This new report is still under development and does not yet have all of the features the finished report will have. One of the features not yet introduced is the currency conversion or currency special characters. All Multi-location Item Sales reporting will show the accurate sales from your POS, and the values will be of the currency the sales were recorded in, but they will all be displayed as though they were in USD (with a $ symbol).

Please note:

Your sales have not been converted to USD, they are just being shown with the default ($) symbol and this cannot be changed in your report at this time.
Sales cannot be converted between currencies - this feature will be added in the future but is not currently available for this new report.
All sales will be in local currency but with the $ symbol, which will make multiple businesses total up as though they were Dollars when different currencies are in use. Due to the inability to distinguish between currencies, we recommend you limit your new report to one currency at a time to reduce confusion.