Metric Glossary
SOURCE SALES
Source Sales are where the item sale’s value will be attributed to. It may not always be the same as the location the item was purchased from.
Location sales are where the item physically gets fulfilled from.
Source Sales » Net Sales
Net sales are defined as gross sales minus both net markdowns and gross returns.
Net sales are total revenue, minus the cost of sales returns, allowances, and discounts.
This is the primary sales figure reviewed by analysts when they examine the income statement of a business.
Sales at gross invoice amount minus any adjustments for returns, allowances, or discounts taken.
Reporting Tips:
Source Sales » Net Returns
Investment’s gross income minus expenses.
Source Sales » Net Qty Sold
Net Quantity Sold equals the Gross Quantity Sold minus Gross Quantity Returned
Source Sales » Net Item Sold Cost
This is the Cost of Goods Sold (COGS). It is the average cost your business paid for the items at the time of sale, not including other costs such as freight.
Source Sales » Net Markdowns
Total discounts on items sold, calculated as the difference between the item's Original Price and the selling price.
If the item did not have an Original Price, it’s calculated as the difference between the item's Current Price and it’s sold price.
Source Sales » Net Markdowns excluding Price Adjustments
Coupon and Promotion discounts, minus manual price adjustments
Source Sales » Gross Margin
Net Sales minus Net Item Sold Cost
The difference between Net Sales and Net Item Sold Cost.
Source Sales » Gross Margin %
To calculate, first find your gross profit: Net sales - Net Item Sold Cost = Gross Margin
Gross Margin divided by net sales = Gross Margin percentage
Gross margin % = percentage of Net Sales sold
Source Sales » Sold Margin
Gross Sales minus the Net Item Sold Cost, excluding Returns.
Source Sales » Sold Margin %
Sold Margin divided by Gross Sales
Source Sales » Gross Sales
Gross Sales are sales at full retail price
Gross sales are a grand total of all sales transactions reported in a period, without any deductions included within the figure.
Source Sales » Gross Qty Sold
Gross Quantity Sold is the total number of items sold.
Source Sales » Gross Returns
Total Original Price of retail dollars returned by a customer.
Gross Returns do not include markdowns. Return markdowns are included in Net Markdowns.
As an example, if a customer purchases an $100 item for $80 and then returns that item, the Gross Return would be $100 and the $20 markdown would be included in Net Markdowns.
Source Sales » Gross Qty Returned
Gross Quantity Returned is the total number of items returned.
Source Sales » # of Items
Total number of unique items sold in a period
Source Sales » # of Customers
(Customer Count): Number of unique customers entered on transactions.
Leaving the customer field blank will count as only one customer no matter how many transactions are rung.
Source Sales » # of Tickets
The total number of tickets
Source Sales » Average Transaction Value
Net Sales divided by # of Transactions.
(Transaction Count): Total number of transactions processed, including tickets and sales orders.
Source Sales » Average Unit Sold Price
Net Sales divided by Net Qty Sold.
Source Sales » Units Per Transaction
Net Qty Sold divided by # of Transactions.
Source Sales » First Purchase Date
The first date the item was purchased in the store
Source Sales » Last Purchase Date
The last date the item was purchased in the store
Source Sales » Gift Cards Issued
Purchased here but physically provided from another location (location sales)
LOCATION SALES
Location sales are where the item physically gets fulfilled from.
Location Sales » Sell-through
Sell-through refers to the percentage of a product that is sold by a retailer after being shipped by its supplier, typically expressed as a percentage.
Net sales essentially refer to the same thing, in absolute numbers.
Sell-through is calculated during a period (usually 1 month).
Location Sales » Net Sales
Net sales are defined as gross sales minus both net markdowns and gross returns.
In bookkeeping, accounting, and finance, Net sales are operating revenues earned by a company for selling its products or rendering its services.
Also referred to as revenue, they are reported directly on the income statement as Sales or Net sales.
Location Sales » Inventory Turn
A measure of the number of times inventory is sold or used in a time period such as a year.
Location Sales » Net Returns
Investment’s gross income minus expenses.
Location Sales » Net Qty Sold
Net Quantity Sold = Gross Quantity Sold less Gross Quantity Returned
Location Sales » Net Item Sold Cost
This is Cost of Goods Sold ( COGS ). It is the average cost your business paid for the items sold at the time of sale, not including other costs like freight.
Location Sales » Net Markdowns
Total discounts on items sold, calculated as the difference between the item's Original Price and the selling price.
If the item did not have an Original Price, it is calculated as the difference between the item's Current Price and the selling price.
If you have returns, the markdown from that return, will be included in this Net Markdown number.
Location Sales » Net Markdowns excluding Price Adjustments
Coupon and Promotion discounts, no manual price adjustments
Location Sales » Gross Margin
Net Sales less Net Item Sold Cost
The difference between NET SALES and COST OF GOODS SOLD.
Location Sales » Gross Margin %
Divide gross profit by the revenue. To make the margin a percentage, multiply the result by 100
Location Sales » Sold Margin %
Sold Margin divided by Gross Sales
Location Sales » Sold Margin
Gross Sales less Net Item Sold Cost, excluding Returns.
Location Sales » Gross Sales
Total of all sales transactions by location
Gross sales are a grand total of all sales transactions reported in a period, without any deductions included within the figure.
Location Sales » Gross Qty Sold
Gross Quantity Sold is the total number of items sold.
Location Sales » Gross Returns
Total original retail dollars returned by a customer.
This is gross, it does not include markdowns. Return markdowns are included in Net Markdowns.
As an example, if a customer purchases an $100 item for $80 and then returns that item, the Gross Return would be $100 and the $20 markdown would be included in Net Markdowns.
Location Sales » Gross Qty Returned
Gross Quantity Returned is the total number of items returned.
Location Sales » # of Items
Total number of unique items sold in a period
Location Sales » # of Customers
Customer Count: Number of unique customers entered on transactions.
Leaving the customer field blank will count as only one customer no matter how many transactions are rung.
Location Sales » # of Tickets
Transaction Count: Total number of transactions processed, including tickets and sales orders.
Location Sales » Average Transaction Value
Net Sales divided by # of Transactions.
Location Sales » Average Unit Sold Price
-Net Sales divided by Net Qty Sold.
Location Sales » Units Per Transaction
Net Qty Sold divided by # of Transactions.
Location Sales » First Purchase Date
First purchase date of an item at that location
Location Sales » Last Purchase Date
Last purchase date of an item at that location
Location Sales » Gift Cards Issued
Purchased here but physically provided from another location (location sales)
Item: Price Adjustment » Net Amount
Reports the total $ amount of price adjustments that were made to the 'current price' on the items.
In the report above items were marked down (the current price on item recorded was changed) by $300. Some will refer to this as Permanent Markdowns.
Item: Price Adjustment » Net Quantity
Reports how many items were on hand when the 'current price' was changed on the item record.
Beginning Inventory » Qty Owned
Total quantity of stock that is owned
Beginning Inventory » Cost Owned
How much the items cost your business to acquire
Beginning Inventory » Price Owned
Price owned of inventory
Beginning Inventory » Qty Committed
Items owned but committed for sale, either on a sales order or layaway.
Beginning Inventory » Cost Committed
Investment on inventory already made and cannot recover
Beginning Inventory » Price Committed
The retail price of units committed inventory.
EXAMPLE: Open sales order or Layaway
Beginning Inventory » Qty In Transit
Total number of SKUs that are currently being shipped from one location to another
Beginning Inventory » Cost In Transit
Cost of inventory that has been shipped by the seller, but has not yet been received by the purchaser
Beginning Inventory » Price In Transit
Price of inventory that has been shipped by the seller, but has not yet been received by the purchaser
Beginning Inventory » Qty On Hand
The total you have physically available (minus any items that have been “picked” in a sales order
Beginning Inventory » Cost On Hand
Cost on hand refers to the stock of on-hand supplies of consumable items that is typically maintained by a business to support its operations.
Beginning Inventory » Price On Hand
Price on hand of beginning inventory(inventory that is physically in-store)
Beginning Inventory » Qty Available
How many items you have left if you fulfill all open sales orders and is therefore equal to Qty on Hand (what is left after you have shipped all of your current orders
Beginning Inventory » Cost Available
Cost of what is on hand
Beginning Inventory » Price Available
The retail price of the inventory
Beginning Inventory » Original Price On Hand
Original Price of the item MSRP (Manufacturer's Suggested Retail Price) for Beginning InventoryMetric as of 11:59 pm on the last day of your metric.
If your time period includes today, the Current inventory and Ending inventory will match.
Ending inventory
The value of goods available for sale at the end of (the date metrics you set), plays an important role in reporting the financial status of a company and can best be figured out using the equation, Beginning Inventory + Net Purchases - Cost of Goods Sold (or COGS) = Ending Inventory.
Ending Inventory » Qty Owned
Total quantity of stock that is owned
Ending Inventory » Cost Owned
How much the items cost your business to acquire
Ending Inventory » Price Owned
How much you price your items based on the cost to your business to acquire(retail price)
Ending Inventory » Qty Committed
Ending inventory items owned but committed for sale, either on a sales order or layaway.
Ending Inventory » Cost Committed
Cost of inventory committed (cannot recover)
Ending Inventory » Price Committed
Retail price of inventory committed (cannot recover)
Ending Inventory » Qty In Transit
Quantity of inventory while in transit ( not yet received at a location)
Ending Inventory » Cost In Transit
Cost of inventory while in transit ( not yet received at a location)
Ending Inventory » Price In Transit
Price of inventory while in transit ( not yet received at a location)
Ending Inventory » Qty On Hand
Total you have physically available (minus any items that have been “picked” in a sales order
Ending Inventory » Cost On Hand
Cost on-hand refers to the stock of on-hand supplies of consumable items that are typically maintained by a business to support its operations.
Ending Inventory » Price On Hand
Price on hand for current inventory physically in your store
Ending Inventory » Qty Available
Inventory qty available ( will match current)
Ending Inventory » Cost Available
Cost of what is on hand
Ending Inventory » Price Available
The retail price of the inventory
Ending Inventory » Original Price On Hand
Original Price of the item MSRP (Manufacturer's Suggested Retail Price) for Ending InventoryCurrent: Metric as of right now.
This is not useful for most time period comparisons because it always shows the metric's current value regardless of the time period selected.
Current Inventory » Qty On Hand
Quantity of current inventory physically in the store
Current Inventory » Cost On Hand
Cost on hand refers to the stock of on-hand supplies of consumable items that is typically maintained by a business to support its operations.
Current Inventory » Price On Hand
Current Price on hand
Current Inventory » Days Since First Received
How many days has it been since your inventory was first received?
EXAMPLE: If you received your inventory( shipment 1 of 2) on Monday, and today is Friday (same week) then it would be 4 days.
Current Inventory » Days Since Last Received
How many days has it been since you received the same inventory (shipment 2 of 2) in different shipments
Current Inventory » First Received Date
What date your current inventory was received on EXAMPLE: 6/15/19 (shipment 1 of 2)
Current Inventory » Last Received Date
What date your current inventory was received (shipment 2 of 2)
EXAMPLE 6-16-19
Current Inventory » Days Since Last Sold
Number of days that have gone by since there was a sale on current item inventory
Current Inventory » Last Sold Date
Last sold date of current item inventory
Current Inventory » Original Price On Hand
Original Price of the item MSRP (Manufacturer's Suggested Retail Price) for current Inventory
Inventory Adjustments » Net Adjusted Cost
Cost after adjustments are made
Inventory Adjustments » Net Adjusted Qty
Quantity after adjustments are made
Inventory Adjustments » Net Adjusted Price
Price after adjustments are made
Sales Tax » Net Amount Collected (By Location)
Amount of Sales Tax Collection by location
Sales Tax » Net Amount Collected (By Source)
Amount of Sales Tax Collected by Source
Shipping » Net Shipping Income
Shipping Income is the amount you charge a customer for shipping in order to ship that item to your customer.
Payments » Gross Payments
Number of payments before any deductions are made
Gross Payments are total payments collected and include product sales, gift card sales, shipping income, and sales tax collected.
Payments » Refunds
A repayment of a sum of money
Payments » Net Payments
Number of payments after deductions are made
Net Payments are total payments collected and include product sales, gift card sales, shipping income, and sales tax collected, less return payments.
Payments » #
Transactions Number of transactions made
Payments » # Credit Card Transactions
Number of payments that were credit card transactions
Payments » Deposits Relieved
The location from which the item is being shipped out will receive an alert to fulfill and invoice this sales order.
Upon completion, the amount prepaid for the sales order will show up as Deposits Relieved in that store location as well as be added to your Net Location Sales for the day.
Payments » Net Deposits
The difference between the Total Deposits and Total Withdrawals you've made for a particular payment method.
The Net Deposit figure is worked out simply by taking the Total Withdrawals amount from the Total Deposits amount.
Gift Cards » Beginning Balance
Beginning balance of a gift card that has been issued
Gift Cards » Ending Balance
Ending balance of a gift card that has been issued
Gift Cards » Gift Cards Expired
Issued Gift cards that have met or passed their expiration date
Gift Cards » Net Adjusted Amount
Amount remaining after adjustments have been made
Transfers Shipped » Net Price
Net Price of inventory included in transfers from one location to the other
Net price is the value at which a product or service is sold after all taxes and other costs are added and all discounts subtracted. Net price is what the seller's customers pay.
Transfers Shipped » Net Cost
Net cost of the transfers shipped at one location
Net cost is the gross cost of an object, reduced by any benefits gained from owning the object.
Examples of net cost: The gross cost of a machine, minus the margin on all goods produced with that machine.
Transfers Shipped » Net Qty
Quantity of Transfers that were shipped from one location to another
Transfers Received » Net Cost
Net cost of the transfers received at one location
Transfers Received » Net Qty
Quantity of Transfers that were received from one location to another
Transfers Received » Net Price
Net price of the transfers received at one location
Purchasing (as a whole)
Purchasing > ___ Month Open Cost (or QTY or Price) on PO: This tells you the open cost, QTY, or Price on PO as of the PO end ship month date.
Traffic » Store Entrance Count
Number of customers that have walked through the entrance
Traffic » Zone Count
Number of customers that have walked in a specific zone in the store
Traffic » Conversion Rate
Sales divided by how many people have walked through your door.
Traffic » Sales per Capita
Sales per person
Sales Plans » Amount
Amount of your sales plan for the day