HelpCenter

AMS Reports
Updated

Avanti offers over 40 different reports to help you optimize your business. Look below for overviews of those reports.

We will have deep-dives for our top reports in separate articles coming soon! 

Report 

Description 

Purpose 

Account 
Profitability 

Summarizes gross profits and gross profit percentage for selected locations, capturing gross sales, discounts, promotions, taxes, deposits; net sales, costs, stales, and overs/shorts for each location for a given date range. The Data Summary shows the total gross profit and the gross profit percentage for the Report View. 

Executive Summary  Financial Report – Includes stales and product over/shorts 

Bad Scans 

Details every bad product scan on the kiosks for selected locations for a given date range or in real time. Captures location, scan code, kiosk, kiosk serial number, and transaction date/time. 

Displays product scancodes for products not extended to markets 

Bottle  
Deposits 

Summarizes bottle deposits for each selected location, detailing deposit sales, non-deposit sales, net sales, deposit amount, discount, promotions, tax, gross sales, and the number of deposits/non-deposits made for a given date range. 

Cumulative deposit totals by location 

Cart  
Cancelled 

Details every cart cancellation by location and kiosk for selected locations in a given date range. Captures location, kiosk, transaction ID, amount, and transaction date/time. 

Loss Prevention Report- Includes product details and time stamp 

Cash Flow 

Summarizes cash flow for each selected location, detailing credit card sales, Market Card sales, coupon sales, sales total, credit recharge, credit recharge bonus, cash recharge, cash recharge bonus, coupon recharge, added recharge money, payroll deduct recharge, and recharge total for a given date range. The Data Summary includes separate totals on the above items for all locations in the Report View.  

Captures financial activity for all recharge and sales options available within AMS 

Credit Card 
Errors 

Details every declined credit/debit card transaction by location for a given date range. Captures location, kiosk, date created, action, the last four of the card, transaction date, reason for error, and “is keyed” information. Records are grouped by location and kiosk.  

Reports rejected CC transactions.  Includes both online and offline kiosk transactions  

Declined Sales Summary 

Summarizes declined sales by location, detailing gross sales, taxes, deposits, discounts, promotions, net sales, costs, gross margin, order count, and item count for a given date range. The Data Summary shows totals for the Report View. 

Summarizes declined sales by location 

Discounts by 
Location 

Lists individual discount campaigns by location. Captures the number of transactions and the total discount amount at selected locations for a given date range. 

Displays the total number of discounts by description and location 

Fingerprint Login Results 

Summarizes the total number of Fingerprint accounts, total number Fingerprint purchases, and total Fingerprint sales by location for a given date range. It captures location, number of Fingerprint accounts, number of Fingerprint purchases, and total Fingerprint sales. The Data Summary displays the total number of Fingerprint accounts, the total number of Fingerprint purchases, and the total Fingerprint sales for a given Report View. 

Displays biometric performance.  Captures successful and unsuccessful scans 

Guest Pass  
Coupons Redeemed 

Details Guest Pass Coupons redeemed by location for a given date range. Captures target location, description, Market Card, location used, transaction date, and amount. 

Tracks redeemed guest pass coupon activity 

Inventory Adjustment 
Summary 

Summary of inventory adjustments for selected locations by location for a given date range. The detailed drill down information captures time stamped adjustments made at each location which include restock, restock amount, stale quantity, stale amount, reduction quantity, reduction amount, over/short quantity, over/short amount, number of errors, error amount, sales quantity, and sales cost. The Data Summary shows totals for the above categories for the Report View 

Detailed product adjustment activity report.  Includes time stamps  

Inventory Analysis 

Analysis of sales and inventory for a single location. Captures product category, product name, scan code, quantity sold, dollar amount sold, cost sold, quantity on-hand, dollar amount of on-hand inventory, and min/max stock. 

Analyzes on hand inventory to product sales sold within the report query timeframe  

Inventory  
Movement 

Details of all inventory movement including stales and losses by product. Captures product, category, scan code, operator code, restock quantity, restock cost, stale quantity, stale cost, reduction (pulled from shelf) quantity, reduction cost, over/short (over max or under min) quantity, over/short cost, error quantity, error cost, sales quantity, and sales cost. The Data Summary shows totals for each of the above for the Report View. 

Cumulative product movement report.  Can be run for one, many, or ALL market locations 

Kiosk Cash 

Lists the cash currently in each kiosk. Captures location, kiosk, and amount. The Data Summary shows total cash for the Report View. 

Real time Report – Records the amount of cash on hand at each market  location 

Kiosk Cash Out 

Details of the exact number of bills taken out of each kiosk by denomination for a given date range. Captures location, kiosk, cash out date, total amount, $1 bills, $2 bills, $5 bills, $10 bills, $20 bills, $50 bills, $100 bills, and first/last name of the system user. The Data Summary shows the totals amount and totals for each denomination for the Report View. 

Cash accountability- Detailed cash collection details, by location and route driver 

Market User Activity 

Summarizes market user balance activity by location for a given date range. Captures location, start balance count, start balance amount, money added count, money added amount, adjustment count, and adjustment amount.  The detailed (drill down) information captures Start Balance Count for grand openings, Money Added Count for bulk user updates, and Adjustment Counts for individual refunds.  The adjustments capture date, time, and reason for the adjustment for auditing purposes. 

Tracks refunds, card start balance, and bulk user updates.   Records AMS user and reason 

Market User Float 

Lists each location as well as the total dollar amount and total points available on all Market Cards for each location in real time. The Data Summary displays the totals of the above for the report view.  This is a real time report.  There is no date selection option. 

Real Time Report – Displays cumulative market user balances for each market 

Market User Float 
Summary 

Lists each location as well as the total dollar amount and total points available on all Market Cards for each location for a given end date. The Data Summary displays the totals of the above for the report view.  Date selection captures End Of Day values. 

Displays cumulative market user balances for each market Able to select end date 

Market User 

Lists the details on each end user’s Market Card at a single location for a given date range. Captures market user name, email address, scan code, current balance, amount spent, date and time of last purchase, purchase count, points balance, points earned, and if the account is disabled.  

Query market user balances for the query dates selected 

On Hand  
Inventory 

Provides snapshot of the total inventory value (cost*quantity) and market value (price*quantity) currently on hand by location. Captures price and cost. The Data Summary displays totals for each of the above for the Report View. 

This is a real time report.  There is no date selection option. 

Real Time Report – Displays cumulative on hand inventory totals for each market 

On Hand Inventory Summary 

Provides snapshot of the total inventory value (cost*quantity) and market value (price*quantity) of all goods on hand by location for the Ending Date selected. Date selection captures End Of Day values. 

Displays cumulative on hand inventory totals for each market.  Able to select end date 

Operator Fees 

Summarizes operator fees by location for a given week (Saturday to Friday). Captures selected week(s), location, net sales, CC recharge, CC sales, CC fees, flat fees, service fees, and net due. The Data Summary includes totals of all the above for the Report View.  

Detailed weekly operator service fee reconciliation and payment report 

Product Activity 

Details activity of individual products for a given date range. Captures location, product name, product category, product scan code, product op code, quantity sold, price sold, restock quantity, restock amount, stale quantity, stale amount, reduction quantity, reduction amount, over/short quantity, and over/short amount. 

Customizable product performance report for individual products.  All markets 

Product Analysis 

Detailed sales analysis for each product at a selected location for a given date range. Captures product category, product name, product scan code, operator code, quantity sold, net sales, total cost, gross margin, quantity on hand, cost, on hand total cost, and min/max inventory required.  

Product activity and performance report 

Product Pricing 
by Location 

Details product pricing by location or route. Captures product id, product name, product category, scan code, op code, cost, default price, market, market cost, and market price.  

Real Time Report – Displays individual product pricing.  All markets 

Product Sales 

Details product sales at selected locations for a given time range. Captures product name, product category, product scan code, quantity sold, and sold total.  

Cumulative product sales report.   

Product Tax 
and Deposit 

Details the taxes and deposits required for every product at a location for a given date range. Captures transaction date, product name, product category, price, tax, and deposit.  

Individual product tax and deposit report 

Recharge Coupons Redeemed 

Lists Recharge Coupons redeemed by selected location(s) for a given date range. Captures target location, description, Market Card, location used, transaction date, and amount.  

Tracks redeemed recharge coupon activity 

Sales Item by Location 

Details of products sold, reported by location for a given date range. Captures product name, scan code, Market Card used, category, price, and transaction time. 

Tracks individual product sales, market card information, and transaction time stamp  

Sales Summary and Costs 

Details sales summary and costs by location for a given date range. Captures location, gross sales, deposits, net sales, costs, gross margin, order count, and item count. Data Summary includes gross margin and totals for all of the other columns mentioned above for the Report View. 

Executive Summary  Financial Report – Includes number of transactions and items purchased 

Taxes 

Summarizes taxes collected by location for a given date range. Captures location, taxed sales, non-taxed sales, net sales, tax, discount, promotions, deposit, gross sales, tax quantity, and non-tax quantity.  

Cumulative taxed and non-taxes sales by location 

Taxes by  
Description 

Taxes broken down by description and by location for a given date range. Captures location, tax description, tax rate, total receipts, taxes, and gross sales. 

Cumulative tax report  by location and tax rate description 

 

Product Sold Out 

 

 

Displays products sold out date & times in the markets.  Displays last restock date & time, sold out date & time, QTY sold, min/max par level, and last balance for each product.  This report can be run for individual or all market locations. 

Displays sold out date & time from last restock allowing operators optimize their min/max par levels.  

Unsold Products 

Lists products at a location that have a quantity on hand but have not sold within a given date range. Captures product category, product name, scan code, amount on hand, unit cost, total cost, min stock, and max stock.  

Displays products that have had no sales during the report query timeframe 

Inventory 
Adjustment 
Details (Org) 

Details inventory adjustments for selected operators for a given date range. Captures operator name, location, product, product category, scan code, movement type, reason, quantity, cost, transaction date, and system user.  

Raw Data Report – Product adjustment report 

On Hand  
Inventory Details (Org) 

Details on hand inventory by product. Captures operator, location, product, category, scan code, quantity on hand, cost, and total cost. This is a real time report.  There is no date selection option. 

Raw Data Report – Real Time detailed on hand product report 

Reload Details 
(Org) 

Details Market Card reloads for selected operators for a given date range. Captures operator, location, scan code, amount, transaction date, action type, payment type, and transaction id. 

Raw Data Report – Displays individual market user market card recharges within the operator Org 

Sales Details 
(Org) 

Details sales for selected operators for a given date range. Captures, operator, location, payment type, Market Card scan code, product, category, product scan code, price, tax, cost, margin, transaction date, and transaction id.  

Raw Data Report – Displays individual product sales for all products within the operator Org 

[Text Wrapping Break]