HelpCenter

ADM Reports
Updated

Table of Contents

 

This article only shows a couple of the reports that ADM has to offer, these are a list of the most commonly used reports and their functionality.

 

Cancel Report

  • This report will record every time there is a cancellation at the kiosk. Useful for troubleshooting theft issues.
  • A picture will be taken from the webcam on the kiosk and stored in this report for each cancellation.
  • To view the picture, click on the cancellation within the report.Cancel.png

  • Location: Shows the location where the cancellation occurred.
  • Time Cancelled: What time the transaction was cancelled on the kiosk.
  • Screen: What screen the kiosk was on when the transaction was cancelled.
  • Trans ID: The unique transaction ID number associated to the cancellation.
  • Items: Shows what items were part of the transaction that was cancelled.
  • Total: The total dollar amount of the products that were cancelled.
  • Customer: This will only show the consumer's name if they already logged into their account on the kiosk.
  • Name on CC: If using a credit card was attempted, the name on the credit card will appear.
  • Last 4 of CC: If using a credit card was attempted, last four digits on the card will appear.

 

Credit Transaction Report

  • This report will show every credit transaction that has taken place at a location.Credit_Transaction.png

  • Transdate: Local time of when the transaction took place.
  • Location: Location of the kiosk.
  • Transid: Unique identifier number for the transaction.
  • Consumer Name: This will s how the consumer's name if they swiped their card to add funds to their account.
  • Type: Charge or Credit:
      • Charges are walk up credit purchases.
      • Credit is when funds are added to an account using a credit card.
  • CC Type: This will show what type of card was used, e.g., Visa, MasterCard, American Express, etc.
  • PAN: The last four digits of the card that was used.
  • Amount: Total amount of the transaction.
  • Void: This will show if the transaction was voided (ReadyTouch feature only).
  • Reason: This will display the reason for the void (ReadyTouch feature only).
  • HostRef: This allows us to see a reference for the transaction to see who the processor is (used by the Support team).

 

Daily Sales Summary

  • This report will show your sales for each day within the date range you have chosenDaily_Sales_Summary.png

  • Date: This shows each day listed one by one.
  • Location: Kiosk location.
  • Transactions: How many transactions occurred on that date.
  • Item Count: How many items sold on that date.
  • Sales: Total amount in sales for that date (does not include tax).
  • Taxes: How much tax was collected for that date.
  • Deposit: How many deposits were collected on that date. (This only shows if you have deposits setup for your products.)
  • Discount: How many discounts were applied to products sold, if you are running a promotion.
  • Total Sales: Combines Sales, Taxes, Deposits and Discounts to calculate a grand total for that day.
  • Consumer Count: How many transactions were completed using a GMA account for that day.

 

Delete Summary

  • This report will display all items that have been removed from a market.Delete_Summary.png

  • Date/Time: Shows when the product was removed.
  • Location: The location where the product was removed.
  • Scancode: UPC of the product.
  • UserKey: This is only needed for Lightspeed integration.
  • Product: Name of product that was removed.
  • Cat 1-3: Shows the categories linked to the product.
  • # Del: How many of that product was removed.
  • Total Cost: # Del x Cost of individual product.
  • Total Price: # Del x Price of individual product.
  • Reason: Shows the reason why the product was removed.
  • User: Shows who was taking inventory when that product was removed.

 

Financial Canned Report

  • This report is best used to see how much product you are missing due to possible theft or spoilage.Financial_Canned.png

  • Location: Kiosk location.
  • Sales: Total revenue for the selected date range.
  • Product Cost: Total amount spent on products based on what was sold for the given date range. (This only shows if you have entered the product cost for your products.)
  • Product Cost %: Shows the percentage of your total revenue going towards buying products.
  • Spoil/Damaged $: A summation of the total COST of all products removed from a location due to a reason code of: Damage, Damaged, Spoil, Spoiled, Spoilage, Waste, Wasted, Stale, or Stales.
  • Spoil/Damaged %: This field displays the proportion of the COST of spoiled or damaged goods to total revenues, calculated as Spoil/Damaged / Sales $.
  • Over $: The COST of products added to a location during inventory adjustment. This value is the additional dollar amount of products over what should be added during regular market stocking. This value has a system generated reason code of Physical Adjustment.
  • Over %: This field displays the proportion of the COST of over products added to the market compared to total revenues, calculated as Over $ / Sales $.
  • (Short) $: The COST of products removed from a location during inventory adjustment. Short will include the Physical Adjustments reason code, which is system generated during inventories. It will also include the additional reason codes of Shrink, Shrinkage, Short, Shortage, and Theft.
  • (Short) %: This field displays the proportion of the COST of short products removed from the market compared to total revenues, calculated as Short $ / Sales $.
  • Gross Margin %: This field shows the percentage of revenues that remains after taking cost of goods sold, spoilage, and short inventory into consideration. It is calculated as 100% - Product Cost % - Spoil/Damaged % - Short %.
  • Last year/year: The value of Sales $ from the current selected date range compared to the value of Sales $ of the previous year’s date range. If no data is available, or if the data is partial for the previous year, this field would be blank or show a partial result.
    Example: Sales $ for 2017 is $1,000 and Sales $ for 2016 is $500, so Last Year/Year is $500. A negative value for Last Year/Year indicates that sales for the current date range are less than sales for the previous year’s date range.
  • Last year/year %: A proportion calculated as the Sales $ from the selected date range divided by the Sales $ of the previous year’s date range. If no data is available, or if the data is partial for the previous year, this field would be blank or show a partial result. A value in excess of 100% indicates that Sales $ in the current date range have exceeded the Sales $ in the previous year’s date range.

 

Inventory Adjustment Detail

  • This report will show you all product movement including Sales, Adding and Removing product.Inventory_Adjustment_Detail.png

  • Location: Kiosk location.
  • Product: Name of product that was moved
  • Scancode: UPC of the product.
  • Userkey: This is only needed for Lightspeed integration.
  • Category: First category the product has linked to it.
  • Movement Type: Sale, Add or Remove.
  • Reason: Shows the specific reason code associated to adding or removing a product if there was one.
  • Quantity: Total amount of product sold, added or removed.
  • Price: The price of one unit.
  • Cost: The cost of one unit.
  • User: This shows who added or removed the product.
  • Date/Time: Time that the product was added or removed.

 

Inventory Totals

  • This report shows your total inventory levels among your entire company.Inventory_Totals.png

  • Item: Name of the product.
  • Inventory Count: Total amount of that product you have on-hand.
  • Product Cost: Total cost of that product (Inventory Count x Cost of a single unit).

 

Inventory Value Summary

  • This report can be used to see your current on-hand quantity levels and the total cost and price of all your product that has yet to be sold.Inventory_Value_Summary.png

  • Location Name: Where the kiosk is located.
  • Userkey: This is only needed for Lightspeed integration.
  • Scancode: UPC of the product.
  • Description: Description of the product.
  • Cat 1-3: Categories linked to the product.
  • Cost: Cost of one unit.
  • Price: Price of one unit.
  • Qty on Hand: Current on hand levels.
  • Min: What your Min level is currently set to.
  • Max: What your Max level is currently set to.
  • Cost Total: Cost of one unit x Qty on Hand.
  • Price Total: Price of one unit x Qty on Hand.
  • Sold in a Week: How much of that product you sold in one week.
  • Total Sold: Total amount of that product sold from the time you started selling that product.

 

Product Canned Report

  • This report will show you the individual items that have been removed from your market due to spoilage or theft.
  • This report works like the Financial Canned Report in how it calculates the Shrink and Spoilage.Product_Canned_Report.png

  • Product: Product name.
  • Sales Units: Shows how much product has been sold within the date range chosen.
  • Sales: Total revenue of the product sold.
  • Avg Sell Price: Sales/Sales Units will give you the average sell price.
  • Spoil/Damaged Units: How much of that product has been removed due to spoilage.
  • Spoil/Damage%: Spoiled Units/Sales Units will give you the percent of spoilage.
  • Shrink Units: Number of units that are missing when inventory is taken.
  • Shrink%: Shrink Units/Sales Units will give you the shrink percentage.
  • Min: What your min level is set to for that product.
  • Max: What your max is set to for that product.

 

Product Sales Report

  • This report will show you how much of each product you are selling to determine what products are selling better than others.Product_Sales.png

  • Product: Name of product sold.
  • Scancode: UPC of the product.
  • UserKey: This is only needed if using the Lightspeed integration.
  • Cat 1-3: Shows the categories of the product.
  • Qty Sold: How much of that product you have sold within the selected date range.
  • Total Price: Qty Sold x Price of one unit.
  • Case Count: If picking that product by the case, this will show how many individual items are in a case.

 

Sold Detail Report

  • This report will show every item that was sold from your market.Sold_Detail.png

  • Location: The location where the transaction occurred.
  • Device: Serial number of kiosk where the item was sold.
  • Transdate: Local time the transaction was completed by the consumer.
  • Date Created: Server time. If the server is in a different time zone than the kiosk, it will record the time of the Server in this field.
  • Product Name: Name of the product that was sold.
  • Scancode: The UPC of the product.
  • UserKey: This is only needed if you use the LightSpeed Integration.
  • Customer: The unique identifier of the consumer who made the purchase. This field will only be populated if a consumer used a GMA account to make a purchase. It will not be populated for anonymous transactions.
  • Pay Method: The method that the consumer used to pay for the purchase. Possible payment  methods include Loyalty, Credit and Account.
  • Cat 1-3: Categories linked to that product.
  • Price: The price of the product, not including tax, deposits, or discounts.
  • Tax 1-4: The amount of tax that was applied to the product sale.
  • Deposit: The deposit amount for the product. (This only shows if you have a deposit tied to that product.)
  • Total Price: The total cost of the product, which is the sum of the amount, tax 1, tax 2, and the deposit.
  • Discount: The discount amount that was applied to the product sale due to any promotions that were in effect.
  • Cost: The amount you paid for the product. (This only shows if you have entered the product cost for that product.) 
  • Margin – The difference between the price and the cost of the product.
  • Loyalty – How many points were awarded for buying that product if the Loyalty Rewards Program is activated.

 

Sold Item COGS

COGS = Cost of Goods

  • This report is used to see your profit margins for the items sold.Sold_Item_COGS.png

  • Location Name: Kiosk location.
  • Product Name: Name of the product sold.
  • Scancode: UPC of the product.
  • Product Category: Displays the first category of the product.
  • Units Sold: Total number of that product sold within the date range selected.
  • Cost Per Unit: Goes by the Cost field of the product and displays its cost.
  • Total COGS: Total cost of the product that was sold (Cost Per Unit x Units Sold).
  • Revenue: How much total revenue was generated from that product.
  • Profit: How much money you made on that product.

 

Transaction Canned Report

  • This report will compare account transactions to credit card transactions.
  • You can also see your total revenue for the date range chosen.Transaction_Canned_.png

  • Location: Kiosk location.
  • Transactions: The number of total transactions that occurred in a specific date range.
  • Sales Units: The total number of products sold in a specific date range.
  • Sales $: The total revenue generated in a specific date range.
  • Units per transaction:* An average of how many products are sold in each transaction.
  • Sales per transactions:* The average transaction cost.
  • Sales per unit:* Average dollar amount of individual products in a transaction.
  • Account Transactions: The number of purchases that were completed using an Account.
  • Account Amount: How much revenue was generated by Account transactions only.
  • Account %: The total percentage of transactions completed with accounts.
  • Credit Transactions: Total number of transactions completed with a credit card.
  • Credit Amount: Total revenue generated by credit cards only.
  • Credit %: The total percentage of transactions completed with credit cards.
  • Credit Comparison: This shows a comparison between the average sales per transaction when credit is used versus the average sales per transaction when an account is used.

    Example: A value of 20% indicates that when a credit card is used to make a purchase, on average, the total amount spent is 20% greater than if that customer was to make a purchase on an account. If the average sales amount is enough to cover credit card fees, it could be more profitable for the operator to allow customers to keep using their credit cards, rather than encouraging the use of GMA accounts.

* There are also fields for account transactions only (Account) and credit transactions only (Credit).